mysql 创建表的实例

-

-- 表的结构 `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 ;