mysql 创建表的实例

-
-- 表的结构 `os_currentstep`
--

CREATE TABLE `os_currentstep`(
  `ID` bigint(20)NOT NULL,
  `ENTRY_ID` bigint(20)defaultNULL,
  `STEP_ID` int(11)defaultNULL,
  `ACTION_ID` int(11)defaultNULL,
  `OWNER` varchar(35)defaultNULL,
  `START_DATE` datetimedefaultNULL,
  `FINISH_DATE` datetimedefaultNULL,
  `DUE_DATE` datetimedefaultNULL,
  `STATUS` varchar(40)defaultNULL,
  `CALLER` varchar(35)defaultNULL,
  PRIMARYKEY  (`ID`),
  KEY`ENTRY_ID`(`ENTRY_ID`),
  KEY`OWNER`(`OWNER`),
  KEY`CALLER`(`CALLER`)
) ENGINE=InnoDBDEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `os_currentstep_prev`
--

CREATE TABLE `os_currentstep_prev`(
  `ID` bigint(20)NOT NULL,
  `PREVIOUS_ID` bigint(20)NOT NULL,
  PRIMARYKEY  (`ID`,`PREVIOUS_ID`),
  KEY`ID`(`ID`),
  KEY`PREVIOUS_ID`(`PREVIOUS_ID`)
) ENGINE=InnoDBDEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `os_entryids`
--

CREATE TABLE `os_entryids`(
  `ID` bigint(20)NOT NULL auto_increment,
  PRIMARYKEY  (`ID`)
) ENGINE=InnoDBDEFAULT CHARSET=utf8 AUTO_INCREMENT=2;

-- --------------------------------------------------------

--
-- 表的结构 `os_group`
--

CREATE TABLE `os_group`(
  `GROUPNAME` varchar(20)NOT NULL,
  PRIMARYKEY  (`GROUPNAME`)
) ENGINE=InnoDBDEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `os_historystep`
--

CREATE TABLE `os_historystep`(
  `ID` bigint(20)NOT NULL,
  `ENTRY_ID` bigint(20)defaultNULL,
  `STEP_ID` int(11)defaultNULL,
  `ACTION_ID` int(11)defaultNULL,
  `OWNER` varchar(35)defaultNULL,
  `START_DATE` datetimedefaultNULL,
  `FINISH_DATE` datetimedefaultNULL,
  `DUE_DATE` datetimedefaultNULL,
  `STATUS` varchar(40)defaultNULL,
  `CALLER` varchar(35)defaultNULL,
  PRIMARYKEY  (`ID`),
  KEY`ENTRY_ID`(`ENTRY_ID`),
  KEY`OWNER`(`OWNER`),
  KEY`CALLER`(`CALLER`)
) ENGINE=InnoDBDEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `os_historystep_prev`
--

CREATE TABLE `os_historystep_prev`(
  `ID` bigint(20)NOT NULL,
  `PREVIOUS_ID` bigint(20)NOT NULL,
  PRIMARYKEY  (`ID`,`PREVIOUS_ID`),
  KEY`ID`(`ID`),
  KEY`PREVIOUS_ID`(`PREVIOUS_ID`)
) ENGINE=InnoDBDEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `os_membership`
--

CREATE TABLE `os_membership`(
  `USERNAME` varchar(20)NOT NULL,
  `GROUPNAME` varchar(20)NOT NULL,
  PRIMARYKEY  (`USERNAME`,`GROUPNAME`),
  KEY`USERNAME`(`USERNAME`),
  KEY`GROUPNAME`(`GROUPNAME`)
) ENGINE=InnoDBDEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `os_propertyentry`
--

CREATE TABLE `os_propertyentry`(
  `GLOBAL_KEY` varchar(250)NOT NULL,
  `ITEM_KEY` varchar(250)NOT NULL,
  `ITEM_TYPE` tinyint(4)defaultNULL,
  `STRING_VALUE` varchar(255)defaultNULL,
  `DATE_VALUE` datetimedefaultNULL,
  `DATA_VALUE` longtext,
  `FLOAT_VALUE` floatdefaultNULL,
  `NUMBER_VALUE` decimal(10,0)defaultNULL,
  PRIMARYKEY  (`GLOBAL_KEY`,`ITEM_KEY`)
) ENGINE=InnoDBDEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `os_stepids`
--

CREATE TABLE `os_stepids`(
  `ID` bigint(20)NOT NULL auto_increment,
  PRIMARYKEY  (`ID`)
) ENGINE=InnoDBDEFAULT CHARSET=utf8 AUTO_INCREMENT=11;

-- --------------------------------------------------------

--
-- 表的结构 `os_user`
--

CREATE TABLE `os_user`(
  `USERNAME` varchar(100)NOT NULL,
  `PASSWORDHASH` mediumtext,
  PRIMARYKEY  (`USERNAME`),
  KEY`USERNAME`(`USERNAME`)
) ENGINE=InnoDBDEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `os_wfentry`
--

CREATE TABLE `os_wfentry`(
  `ID` bigint(20)NOT NULL,
  `NAME` varchar(60)defaultNULL,
  `STATE` int(11)defaultNULL,
  PRIMARYKEY  (`ID`)
) ENGINE=InnoDBDEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `os_workflowdefs`
--

CREATE TABLE `os_workflowdefs`(
  `WF_NAME` varchar(250)NOT NULL,
  `WF_DEFINITION` longtextNOT NULL,
  PRIMARYKEY  (`WF_NAME`)
) ENGINE=InnoDBDEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `sl_config`
--

CREATE TABLE `sl_config`(
  `KEY` varchar(64)NOT NULL,
  `TYPE` int(11)NOT NULL,
  `DESCRIPTION` varchar(256)defaultNULL,
  `VALUE` varchar(256)NOT NULL,
  `DEFAULT_VALUE` varchar(256)defaultNULL,
  PRIMARYKEY  (`KEY`)
) ENGINE=InnoDBDEFAULT 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` longtextNOT NULL,
  PRIMARYKEY  (`id`)
) ENGINE=InnoDBDEFAULT CHARSET=utf8 AUTO_INCREMENT=1;