-
|
-- 表的结构 `os_currentstep`
|
--
|
|
CREATE
TABLE
`os_currentstep`
(
|
`ID` bigint(20)
NOT
NULL,
|
`ENTRY_ID` bigint(20)
default
NULL,
|
`STEP_ID` int(11)
default
NULL,
|
`ACTION_ID` int(11)
default
NULL,
|
`OWNER` varchar(35)
default
NULL,
|
`START_DATE` datetime
default
NULL,
|
`FINISH_DATE` datetime
default
NULL,
|
`DUE_DATE` datetime
default
NULL,
|
`STATUS` varchar(40)
default
NULL,
|
`CALLER` varchar(35)
default
NULL,
|
PRIMARY
KEY (`ID`),
|
KEY
`ENTRY_ID`
(`ENTRY_ID`),
|
KEY
`OWNER`
(`OWNER`),
|
KEY
`CALLER`
(`CALLER`)
|
) ENGINE=InnoDB
DEFAULT CHARSET=utf8;
|
|
-- --------------------------------------------------------
|
|
--
|
-- 表的结构 `os_currentstep_prev`
|
--
|
|
CREATE
TABLE
`os_currentstep_prev`
(
|
`ID` bigint(20)
NOT
NULL,
|
`PREVIOUS_ID` bigint(20)
NOT
NULL,
|
PRIMARY
KEY (`ID`,`PREVIOUS_ID`),
|
KEY
`ID`
(`ID`),
|
KEY
`PREVIOUS_ID`
(`PREVIOUS_ID`)
|
) ENGINE=InnoDB
DEFAULT CHARSET=utf8;
|
|
-- --------------------------------------------------------
|
|
--
|
-- 表的结构 `os_entryids`
|
--
|
|
CREATE
TABLE
`os_entryids`
(
|
`ID` bigint(20)
NOT
NULL auto_increment,
|
PRIMARY
KEY (`ID`)
|
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=2
;
|
|
-- --------------------------------------------------------
|
|
--
|
-- 表的结构 `os_group`
|
--
|
|
CREATE
TABLE
`os_group`
(
|
`GROUPNAME` varchar(20)
NOT
NULL,
|
PRIMARY
KEY (`GROUPNAME`)
|
) ENGINE=InnoDB
DEFAULT CHARSET=utf8;
|
|
-- --------------------------------------------------------
|
|
--
|
-- 表的结构 `os_historystep`
|
--
|
|
CREATE
TABLE
`os_historystep`
(
|
`ID` bigint(20)
NOT
NULL,
|
`ENTRY_ID` bigint(20)
default
NULL,
|
`STEP_ID` int(11)
default
NULL,
|
`ACTION_ID` int(11)
default
NULL,
|
`OWNER` varchar(35)
default
NULL,
|
`START_DATE` datetime
default
NULL,
|
`FINISH_DATE` datetime
default
NULL,
|
`DUE_DATE` datetime
default
NULL,
|
`STATUS` varchar(40)
default
NULL,
|
`CALLER` varchar(35)
default
NULL,
|
PRIMARY
KEY (`ID`),
|
KEY
`ENTRY_ID`
(`ENTRY_ID`),
|
KEY
`OWNER`
(`OWNER`),
|
KEY
`CALLER`
(`CALLER`)
|
) ENGINE=InnoDB
DEFAULT CHARSET=utf8;
|
|
-- --------------------------------------------------------
|
|
--
|
-- 表的结构 `os_historystep_prev`
|
--
|
|
CREATE
TABLE
`os_historystep_prev`
(
|
`ID` bigint(20)
NOT
NULL,
|
`PREVIOUS_ID` bigint(20)
NOT
NULL,
|
PRIMARY
KEY (`ID`,`PREVIOUS_ID`),
|
KEY
`ID`
(`ID`),
|
KEY
`PREVIOUS_ID`
(`PREVIOUS_ID`)
|
) ENGINE=InnoDB
DEFAULT CHARSET=utf8;
|
|
-- --------------------------------------------------------
|
|
--
|
-- 表的结构 `os_membership`
|
--
|
|
CREATE
TABLE
`os_membership`
(
|
`USERNAME` varchar(20)
NOT
NULL,
|
`GROUPNAME` varchar(20)
NOT
NULL,
|
PRIMARY
KEY (`USERNAME`,`GROUPNAME`),
|
KEY
`USERNAME`
(`USERNAME`),
|
KEY
`GROUPNAME`
(`GROUPNAME`)
|
) ENGINE=InnoDB
DEFAULT CHARSET=utf8;
|
|
-- --------------------------------------------------------
|
|
--
|
-- 表的结构 `os_propertyentry`
|
--
|
|
CREATE
TABLE
`os_propertyentry`
(
|
`GLOBAL_KEY` varchar(250)
NOT
NULL,
|
`ITEM_KEY` varchar(250)
NOT
NULL,
|
`ITEM_TYPE` tinyint(4)
default
NULL,
|
`STRING_VALUE` varchar(255)
default
NULL,
|
`DATE_VALUE` datetime
default
NULL,
|
`DATA_VALUE` longtext,
|
`FLOAT_VALUE` float
default
NULL,
|
`NUMBER_VALUE` decimal(10,0)
default
NULL,
|
PRIMARY
KEY (`GLOBAL_KEY`,`ITEM_KEY`)
|
) ENGINE=InnoDB
DEFAULT CHARSET=utf8;
|
|
-- --------------------------------------------------------
|
|
--
|
-- 表的结构 `os_stepids`
|
--
|
|
CREATE
TABLE
`os_stepids`
(
|
`ID` bigint(20)
NOT
NULL auto_increment,
|
PRIMARY
KEY (`ID`)
|
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=11
;
|
|
-- --------------------------------------------------------
|
|
--
|
-- 表的结构 `os_user`
|
--
|
|
CREATE
TABLE
`os_user`
(
|
`USERNAME` varchar(100)
NOT
NULL,
|
`PASSWORDHASH` mediumtext,
|
PRIMARY
KEY (`USERNAME`),
|
KEY
`USERNAME`
(`USERNAME`)
|
) ENGINE=InnoDB
DEFAULT CHARSET=utf8;
|
|
-- --------------------------------------------------------
|
|
--
|
-- 表的结构 `os_wfentry`
|
--
|
|
CREATE
TABLE
`os_wfentry`
(
|
`ID` bigint(20)
NOT
NULL,
|
`NAME` varchar(60)
default
NULL,
|
`STATE` int(11)
default
NULL,
|
PRIMARY
KEY (`ID`)
|
) ENGINE=InnoDB
DEFAULT CHARSET=utf8;
|
|
-- --------------------------------------------------------
|
|
--
|
-- 表的结构 `os_workflowdefs`
|
--
|
|
CREATE
TABLE
`os_workflowdefs`
(
|
`WF_NAME` varchar(250)
NOT
NULL,
|
`WF_DEFINITION` longtext
NOT
NULL,
|
PRIMARY
KEY (`WF_NAME`)
|
) ENGINE=InnoDB
DEFAULT CHARSET=utf8;
|
|
-- --------------------------------------------------------
|
|
--
|
-- 表的结构 `sl_config`
|
--
|
|
CREATE
TABLE
`sl_config`
(
|
`KEY` varchar(64)
NOT
NULL,
|
`TYPE` int(11)
NOT
NULL,
|
`DESCRIPTION` varchar(256)
default
NULL,
|
`VALUE` varchar(256)
NOT
NULL,
|
`DEFAULT_VALUE` varchar(256)
default
NULL,
|
PRIMARY
KEY (`KEY`)
|
) ENGINE=InnoDB
DEFAULT CHARSET=utf8;
|
|
-- --------------------------------------------------------
|
|
--
|
-- 表的结构 `sl_messages`
|
--
|
|
CREATE
TABLE
`sl_messages`
(
|
`id` bigint(20)
NOT
NULL auto_increment,
|
`name` varchar(256)
NOT
NULL,
|
`type` varchar(256)
NOT
NULL,
|
`content` longtext
NOT
NULL,
|
PRIMARY
KEY (`id`)
|
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
; |