- |
-- 表的结构 `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 ; |
mysql 创建表的实例
最新推荐文章于 2025-01-15 18:01:07 发布