Activity 5.17 mysql 建表sql

因为部分表存在外键。按以下顺序可顺利建表。否则有些表会因外键建表失败。

01

-- 导出  表 act_re_deployment 结构  
DROP TABLE IF EXISTS `act_re_deployment`;  
CREATE TABLE IF NOT EXISTS `act_re_deployment` (  
  `ID_` varchar(64) collate utf8_bin NOT NULL default '',  
  `NAME_` varchar(255) collate utf8_bin default NULL,  
  `CATEGORY_` varchar(255) collate utf8_bin default NULL,  
  `DEPLOY_TIME_` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,  
  PRIMARY KEY  (`ID_`)  
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;  






02
-- 导出  表 act_ge_bytearray 结构  
DROP TABLE IF EXISTS `act_ge_bytearray`;  
CREATE TABLE IF NOT EXISTS `act_ge_bytearray` (  
  `ID_` varchar(64) collate utf8_bin NOT NULL default '',  
  `REV_` int(11) default NULL,  
  `NAME_` varchar(255) collate utf8_bin default NULL,  
  `DEPLOYMENT_ID_` varchar(64) collate utf8_bin default NULL,  
  `BYTES_` longblob,  
  `GENERATED_` tinyint(4) default NULL,  
  PRIMARY KEY  (`ID_`),  
  KEY `ACT_FK_BYTEARR_DEPL` (`DEPLOYMENT_ID_`),  
  CONSTRAINT `ACT_FK_BYTEARR_DEPL` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `act_re_deployment` (`ID_`)  
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;  




03
-- 导出  表 act_ge_property 结构  
DROP TABLE IF EXISTS `act_ge_property`;  
CREATE TABLE IF NOT EXISTS `act_ge_property` (  
  `NAME_` varchar(64) collate utf8_bin NOT NULL default '',  
  `VALUE_` varchar(300) collate utf8_bin default NULL,  
  `REV_` int(11) default NULL,  
  PRIMARY KEY  (`NAME_`)  
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; 




04
-- 导出  表 act_hi_actinst 结构  
DROP TABLE IF EXISTS `act_hi_actinst`;  
CREATE TABLE IF NOT EXISTS `act_hi_actinst` (  
  `ID_` varchar(64) collate utf8_bin NOT NULL,  
  `PROC_DEF_ID_` varchar(64) collate utf8_bin NOT NULL,  
  `PROC_INST_ID_` varchar(64) collate utf8_bin NOT NULL,  
  `EXECUTION_ID_` varchar(64) collate utf8_bin NOT NULL,  
  `ACT_ID_` varchar(255) collate utf8_bin NOT NULL,  
  `TASK_ID_` varchar(64) collate utf8_bin default NULL,  
  `CALL_PROC_INST_ID_` varchar(64) collate utf8_bin default NULL,  
  `ACT_NAME_` varchar(255) collate utf8_bin default NULL,  
  `ACT_TYPE_` varchar(255) collate utf8_bin NOT NULL,  
  `ASSIGNEE_` varchar(255) collate utf8_bin default NULL,  
  `START_TIME_` datetime NOT NULL,  
  `END_TIME_` datetime default NULL,  
  `DURATION_` bigint(20) default NULL,  
  PRIMARY KEY  (`ID_`),  
  KEY `ACT_IDX_HI_ACT_INST_START` (`START_TIME_`),  
  KEY `ACT_IDX_HI_ACT_INST_END` (`END_TIME_`),  
  KEY `ACT_IDX_HI_ACT_INST_PROCINST` (`PROC_INST_ID_`,`ACT_ID_`),  
  KEY `ACT_IDX_HI_ACT_INST_EXEC` (`EXECUTION_ID_`,`ACT_ID_`)  
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;  




05
-- 导出  表 act_hi_attachment 结构  
DROP TABLE IF EXISTS `act_hi_attachment`;  
CREATE TABLE IF NOT EXISTS `act_hi_attachment` (  
  `ID_` varchar(64) collate utf8_bin NOT NULL,  
  `REV_` int(11) default NULL,  
  `USER_ID_` varchar(255) collate utf8_bin default NULL,  
  `NAME_` varchar(255) collate utf8_bin default NULL,  
  `DESCRIPTION_` varchar(4000) collate utf8_bin default NULL,  
  `TYPE_` varchar(255) collate utf8_bin default NULL,  
  `TASK_ID_` varchar(64) collate utf8_bin default NULL,  
  `PROC_INST_ID_` varchar(64) collate utf8_bin default NULL,  
  `URL_` varchar(4000) collate utf8_bin default NULL,  
  `CONTENT_ID_` varchar(64) collate utf8_bin default NULL,  
  PRIMARY KEY  (`ID_`)  
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;  


06
-- 导出  表 act_hi_comment 结构  
DROP TABLE IF EXISTS `act_hi_comment`;  
CREATE TABLE IF NOT EXISTS `act_hi_comment` (  
  `ID_` varchar(64) collate utf8_bin NOT NULL,  
  `TYPE_` varchar(255) collate utf8_bin default NULL,  
  `TIME_` datetime NOT NULL,  
  `USER_ID_` varchar(255) collate utf8_bin default NULL,  
  `TASK_ID_` varchar(64) collate utf8_bin default NULL,  
  `PROC_INST_ID_` varchar(64) collate utf8_bin default NULL,  
  `ACTION_` varchar(255) collate utf8_bin default NULL,  
  `MESSAGE_` varchar(4000) collate utf8_bin default NULL,  
  `FULL_MSG_` longblob,  
  PRIMARY KEY  (`ID_`)  
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;  


07
-- 导出  表 act_hi_detail 结构  
DROP TABLE IF EXISTS `act_hi_detail`;  
CREATE TABLE IF NOT EXISTS `act_hi_detail` (  
  `ID_` varchar(64) collate utf8_bin NOT NULL,  
  `TYPE_` varchar(255) collate utf8_bin NOT NULL,  
  `PROC_INST_ID_` varchar(64) collate utf8_bin default NULL,  
  `EXECUTION_ID_` varchar(64) collate utf8_bin default NULL,  
  `TASK_ID_` varchar(64) collate utf8_bin default NULL,  
  `ACT_INST_ID_` varchar(64) collate utf8_bin default NULL,  
  `NAME_` varchar(255) collate utf8_bin NOT NULL,  
  `VAR_TYPE_` varchar(255) collate utf8_bin default NULL,  
  `REV_` int(11) default NULL,  
  `TIME_` datetime NOT NULL,  
  `BYTEARRAY_ID_` varchar(64) collate utf8_bin default NULL,  
  `DOUBLE_` double default NULL,  
  `LONG_` bigint(20) default NULL,  
  `TEXT_` varchar(4000) collate utf8_bin default NULL,  
  `TEXT2_` varchar(4000) collate utf8_bin default NULL,  
  PRIMARY KEY  (`ID_`),  
  KEY `ACT_IDX_HI_DETAIL_PROC_INST` (`PROC_INST_ID_`),  
  KEY `ACT_IDX_HI_DETAIL_ACT_INST` (`ACT_INST_ID_`),  
  KEY `ACT_IDX_HI_DETAIL_TIME` (`TIME_`),  
  KEY `ACT_IDX_HI_DETAIL_NAME` (`NAME_`),  
  KEY `ACT_IDX_HI_DETAIL_TASK_ID` (`TASK_ID_`)  
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;  
  


08
-- 导出  表 act_hi_identitylink 结构  
DROP TABLE IF EXISTS `act_hi_identitylink`;  
CREATE TABLE IF NOT EXISTS `act_hi_identitylink` (  
  `ID_` varchar(64) collate utf8_bin NOT NULL default '',  
  `GROUP_ID_` varchar(255) collate utf8_bin default NULL,  
  `TYPE_` varchar(255) collate utf8_bin default NULL,  
  `USER_ID_` varchar(255) collate utf8_bin default NULL,  
  `TASK_ID_` varchar(64) collate utf8_bin default NULL,  
  `PROC_INST_ID_` varchar(64) collate utf8_bin default NULL,  
  PRIMARY KEY  (`ID_`),  
  KEY `ACT_IDX_HI_IDENT_LNK_USER` (`USER_ID_`),  
  KEY `ACT_IDX_HI_IDENT_LNK_TASK` (`TASK_ID_`),  
  KEY `ACT_IDX_HI_IDENT_LNK_PROCINST` (`PROC_INST_ID_`)  
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;  


09
-- 导出  表 act_hi_procinst 结构  
DROP TABLE IF EXISTS `act_hi_procinst`;  
CREATE TABLE IF NOT EXISTS `act_hi_procinst` (  
  `ID_` varchar(64) collate utf8_bin NOT NULL,  
  `PROC_INST_ID_` varchar(64) collate utf8_bin NOT NULL,  
  `BUSINESS_KEY_` varchar(255) collate utf8_bin default NULL,  
  `PROC_DEF_ID_` varchar(64) collate utf8_bin NOT NULL,  
  `START_TIME_` datetime NOT NULL,  
  `END_TIME_` datetime default NULL,  
  `DURATION_` bigint(20) default NULL,  
  `START_USER_ID_` varchar(255) collate utf8_bin default NULL,  
  `START_ACT_ID_` varchar(255) collate utf8_bin default NULL,  
  `END_ACT_ID_` varchar(255) collate utf8_bin default NULL,  
  `SUPER_PROCESS_INSTANCE_ID_` varchar(64) collate utf8_bin default NULL,  
  `DELETE_REASON_` varchar(4000) collate utf8_bin default NULL,  
  PRIMARY KEY  (`ID_`),  
  UNIQUE KEY `PROC_INST_ID_` (`PROC_INST_ID_`),  
  UNIQUE KEY `ACT_UNIQ_HI_BUS_KEY` (`PROC_DEF_ID_`,`BUSINESS_KEY_`),  
  KEY `ACT_IDX_HI_PRO_INST_END` (`END_TIME_`),  
  KEY `ACT_IDX_HI_PRO_I_BUSKEY` (`BUSINESS_KEY_`)  
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; 


10
-- 导出  表 act_hi_taskinst 结构  
DROP TABLE IF EXISTS `act_hi_taskinst`;  
CREATE TABLE IF NOT EXISTS `act_hi_taskinst` (  
  `ID_` varchar(64) collate utf8_bin NOT NULL,  
  `PROC_DEF_ID_` varchar(64) collate utf8_bin default NULL,  
  `TASK_DEF_KEY_` varchar(255) collate utf8_bin default NULL,  
  `PROC_INST_ID_` varchar(64) collate utf8_bin default NULL,  
  `EXECUTION_ID_` varchar(64) collate utf8_bin default NULL,  
  `NAME_` varchar(255) collate utf8_bin default NULL,  
  `PARENT_TASK_ID_` varchar(64) collate utf8_bin default NULL,  
  `DESCRIPTION_` varchar(4000) collate utf8_bin default NULL,  
  `OWNER_` varchar(255) collate utf8_bin default NULL,  
  `ASSIGNEE_` varchar(255) collate utf8_bin default NULL,  
  `START_TIME_` datetime NOT NULL,  
  `CLAIM_TIME_` datetime default NULL,  
  `END_TIME_` datetime default NULL,  
  `DURATION_` bigint(20) default NULL,  
  `DELETE_REASON_` varchar(4000) collate utf8_bin default NULL,  
  `PRIORITY_` int(11) default NULL,  
  `DUE_DATE_` datetime default NULL,  
  `FORM_KEY_` varchar(255) collate utf8_bin default NULL,  
  PRIMARY KEY  (`ID_`)  
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;  


11
-- 导出  表 act_hi_varinst 结构  
DROP TABLE IF EXISTS `act_hi_varinst`;  
CREATE TABLE IF NOT EXISTS `act_hi_varinst` (  
  `ID_` varchar(64) collate utf8_bin NOT NULL,  
  `PROC_INST_ID_` varchar(64) collate utf8_bin default NULL,  
  `EXECUTION_ID_` varchar(64) collate utf8_bin default NULL,  
  `TASK_ID_` varchar(64) collate utf8_bin default NULL,  
  `NAME_` varchar(255) collate utf8_bin NOT NULL,  
  `VAR_TYPE_` varchar(100) collate utf8_bin default NULL,  
  `REV_` int(11) default NULL,  
  `BYTEARRAY_ID_` varchar(64) collate utf8_bin default NULL,  
  `DOUBLE_` double default NULL,  
  `LONG_` bigint(20) default NULL,  
  `TEXT_` varchar(4000) collate utf8_bin default NULL,  
  `TEXT2_` varchar(4000) collate utf8_bin default NULL,  
  PRIMARY KEY  (`ID_`),  
  KEY `ACT_IDX_HI_PROCVAR_PROC_INST` (`PROC_INST_ID_`),  
  KEY `ACT_IDX_HI_PROCVAR_NAME_TYPE` (`NAME_`,`VAR_TYPE_`)  
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;  


12
-- 导出  表 act_id_group 结构  
DROP TABLE IF EXISTS `act_id_group`;  
CREATE TABLE IF NOT EXISTS `act_id_group` (  
  `ID_` varchar(64) collate utf8_bin NOT NULL default '',  
  `REV_` int(11) default NULL,  
  `NAME_` varchar(255) collate utf8_bin default NULL,  
  `TYPE_` varchar(255) collate utf8_bin default NULL,  
  PRIMARY KEY  (`ID_`)  
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; 


13
-- 导出  表 act_id_info 结构  
DROP TABLE IF EXISTS `act_id_info`;  
CREATE TABLE IF NOT EXISTS `act_id_info` (  
  `ID_` varchar(64) collate utf8_bin NOT NULL default '',  
  `REV_` int(11) default NULL,  
  `USER_ID_` varchar(64) collate utf8_bin default NULL,  
  `TYPE_` varchar(64) collate utf8_bin default NULL,  
  `KEY_` varchar(255) collate utf8_bin default NULL,  
  `VALUE_` varchar(255) collate utf8_bin default NULL,  
  `PASSWORD_` longblob,  
  `PARENT_ID_` varchar(255) collate utf8_bin default NULL,  
  PRIMARY KEY  (`ID_`)  
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;  


14
-- 导出  表 act_id_user 结构  
DROP TABLE IF EXISTS `act_id_user`;  
CREATE TABLE IF NOT EXISTS `act_id_user` (  
  `ID_` varchar(64) collate utf8_bin NOT NULL default '',  
  `REV_` int(11) default NULL,  
  `FIRST_` varchar(255) collate utf8_bin default NULL,  
  `LAST_` varchar(255) collate utf8_bin default NULL,  
  `EMAIL_` varchar(255) collate utf8_bin default NULL,  
  `PWD_` varchar(255) collate utf8_bin default NULL,  
  `PICTURE_ID_` varchar(64) collate utf8_bin default NULL,  
  PRIMARY KEY  (`ID_`)  
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;  




15
-- 导出  表 act_id_membership 结构  
DROP TABLE IF EXISTS `act_id_membership`;  
CREATE TABLE IF NOT EXISTS `act_id_membership` (  
  `USER_ID_` varchar(64) collate utf8_bin NOT NULL default '',  
  `GROUP_ID_` varchar(64) collate utf8_bin NOT NULL default '',  
  PRIMARY KEY  (`USER_ID_`,`GROUP_ID_`),  
  KEY `ACT_FK_MEMB_GROUP` (`GROUP_ID_`),  
  CONSTRAINT `ACT_FK_MEMB_GROUP` FOREIGN KEY (`GROUP_ID_`) REFERENCES `act_id_group` (`ID_`),  
  CONSTRAINT `ACT_FK_MEMB_USER` FOREIGN KEY (`USER_ID_`) REFERENCES `act_id_user` (`ID_`)  
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;  


16
-- 导出  表 act_re_model 结构  
DROP TABLE IF EXISTS `act_re_model`;  
CREATE TABLE IF NOT EXISTS `act_re_model` (  
  `ID_` varchar(64) collate utf8_bin NOT NULL,  
  `REV_` int(11) default NULL,  
  `NAME_` varchar(255) collate utf8_bin default NULL,  
  `KEY_` varchar(255) collate utf8_bin default NULL,  
  `CATEGORY_` varchar(255) collate utf8_bin default NULL,  
  `CREATE_TIME_` timestamp NULL default NULL,  
  `LAST_UPDATE_TIME_` timestamp NULL default NULL,  
  `VERSION_` int(11) default NULL,  
  `META_INFO_` varchar(4000) collate utf8_bin default NULL,  
  `DEPLOYMENT_ID_` varchar(64) collate utf8_bin default NULL,  
  `EDITOR_SOURCE_VALUE_ID_` varchar(64) collate utf8_bin default NULL,  
  `EDITOR_SOURCE_EXTRA_VALUE_ID_` varchar(64) collate utf8_bin default NULL,  
  PRIMARY KEY  (`ID_`),  
  KEY `ACT_FK_MODEL_SOURCE` (`EDITOR_SOURCE_VALUE_ID_`),  
  KEY `ACT_FK_MODEL_SOURCE_EXTRA` (`EDITOR_SOURCE_EXTRA_VALUE_ID_`),  
  KEY `ACT_FK_MODEL_DEPLOYMENT` (`DEPLOYMENT_ID_`),  
  CONSTRAINT `ACT_FK_MODEL_DEPLOYMENT` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `act_re_deployment` (`ID_`),  
  CONSTRAINT `ACT_FK_MODEL_SOURCE` FOREIGN KEY (`EDITOR_SOURCE_VALUE_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),  
  CONSTRAINT `ACT_FK_MODEL_SOURCE_EXTRA` FOREIGN KEY (`EDITOR_SOURCE_EXTRA_VALUE_ID_`) REFERENCES `act_ge_bytearray` (`ID_`)  
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;  


17
-- 导出  表 act_re_procdef 结构  
DROP TABLE IF EXISTS `act_re_procdef`;  
CREATE TABLE IF NOT EXISTS `act_re_procdef` (  
  `ID_` varchar(64) collate utf8_bin NOT NULL,  
  `REV_` int(11) default NULL,  
  `CATEGORY_` varchar(255) collate utf8_bin default NULL,  
  `NAME_` varchar(255) collate utf8_bin default NULL,  
  `KEY_` varchar(255) collate utf8_bin NOT NULL,  
  `VERSION_` int(11) NOT NULL,  
  `DEPLOYMENT_ID_` varchar(64) collate utf8_bin default NULL,  
  `RESOURCE_NAME_` varchar(4000) collate utf8_bin default NULL,  
  `DGRM_RESOURCE_NAME_` varchar(4000) collate utf8_bin default NULL,  
  `DESCRIPTION_` varchar(4000) collate utf8_bin default NULL,  
  `HAS_START_FORM_KEY_` tinyint(4) default NULL,  
  `SUSPENSION_STATE_` int(11) default NULL,  
  PRIMARY KEY  (`ID_`),  
  UNIQUE KEY `ACT_UNIQ_PROCDEF` (`KEY_`,`VERSION_`)  
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; 


18
-- 导出  表 act_ru_execution 结构  
DROP TABLE IF EXISTS `act_ru_execution`;  
CREATE TABLE IF NOT EXISTS `act_ru_execution` (  
  `ID_` varchar(64) collate utf8_bin NOT NULL default '',  
  `REV_` int(11) default NULL,  
  `PROC_INST_ID_` varchar(64) collate utf8_bin default NULL,  
  `BUSINESS_KEY_` varchar(255) collate utf8_bin default NULL,  
  `PARENT_ID_` varchar(64) collate utf8_bin default NULL,  
  `PROC_DEF_ID_` varchar(64) collate utf8_bin default NULL,  
  `SUPER_EXEC_` varchar(64) collate utf8_bin default NULL,  
  `ACT_ID_` varchar(255) collate utf8_bin default NULL,  
  `IS_ACTIVE_` tinyint(4) default NULL,  
  `IS_CONCURRENT_` tinyint(4) default NULL,  
  `IS_SCOPE_` tinyint(4) default NULL,  
  `IS_EVENT_SCOPE_` tinyint(4) default NULL,  
  `SUSPENSION_STATE_` int(11) default NULL,  
  `CACHED_ENT_STATE_` int(11) default NULL,  
  PRIMARY KEY  (`ID_`),  
  UNIQUE KEY `ACT_UNIQ_RU_BUS_KEY` (`PROC_DEF_ID_`,`BUSINESS_KEY_`),  
  KEY `ACT_IDX_EXEC_BUSKEY` (`BUSINESS_KEY_`),  
  KEY `ACT_FK_EXE_PROCINST` (`PROC_INST_ID_`),  
  KEY `ACT_FK_EXE_PARENT` (`PARENT_ID_`),  
  KEY `ACT_FK_EXE_SUPER` (`SUPER_EXEC_`),  
  CONSTRAINT `ACT_FK_EXE_PARENT` FOREIGN KEY (`PARENT_ID_`) REFERENCES `act_ru_execution` (`ID_`),  
  CONSTRAINT `ACT_FK_EXE_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`),  
  CONSTRAINT `ACT_FK_EXE_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE CASCADE ON UPDATE CASCADE,  
  CONSTRAINT `ACT_FK_EXE_SUPER` FOREIGN KEY (`SUPER_EXEC_`) REFERENCES `act_ru_execution` (`ID_`)  
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;  


19
-- 导出  表 act_ru_event_subscr 结构  
DROP TABLE IF EXISTS `act_ru_event_subscr`;  
CREATE TABLE IF NOT EXISTS `act_ru_event_subscr` (  
  `ID_` varchar(64) collate utf8_bin NOT NULL,  
  `REV_` int(11) default NULL,  
  `EVENT_TYPE_` varchar(255) collate utf8_bin NOT NULL,  
  `EVENT_NAME_` varchar(255) collate utf8_bin default NULL,  
  `EXECUTION_ID_` varchar(64) collate utf8_bin default NULL,  
  `PROC_INST_ID_` varchar(64) collate utf8_bin default NULL,  
  `ACTIVITY_ID_` varchar(64) collate utf8_bin default NULL,  
  `CONFIGURATION_` varchar(255) collate utf8_bin default NULL,  
  `CREATED_` timestamp NOT NULL default CURRENT_TIMESTAMP,  
  PRIMARY KEY  (`ID_`),  
  KEY `ACT_IDX_EVENT_SUBSCR_CONFIG_` (`CONFIGURATION_`),  
  KEY `ACT_FK_EVENT_EXEC` (`EXECUTION_ID_`),  
  CONSTRAINT `ACT_FK_EVENT_EXEC` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`)  
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;  


20
-- 导出  表 act_ru_task 结构  
DROP TABLE IF EXISTS `act_ru_task`;  
CREATE TABLE IF NOT EXISTS `act_ru_task` (  
  `ID_` varchar(64) collate utf8_bin NOT NULL default '',  
  `REV_` int(11) default NULL,  
  `EXECUTION_ID_` varchar(64) collate utf8_bin default NULL,  
  `PROC_INST_ID_` varchar(64) collate utf8_bin default NULL,  
  `PROC_DEF_ID_` varchar(64) collate utf8_bin default NULL,  
  `NAME_` varchar(255) collate utf8_bin default NULL,  
  `PARENT_TASK_ID_` varchar(64) collate utf8_bin default NULL,  
  `DESCRIPTION_` varchar(4000) collate utf8_bin default NULL,  
  `TASK_DEF_KEY_` varchar(255) collate utf8_bin default NULL,  
  `OWNER_` varchar(255) collate utf8_bin default NULL,  
  `ASSIGNEE_` varchar(255) collate utf8_bin default NULL,  
  `DELEGATION_` varchar(64) collate utf8_bin default NULL,  
  `PRIORITY_` int(11) default NULL,  
  `CREATE_TIME_` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,  
  `DUE_DATE_` datetime default NULL,  
  `SUSPENSION_STATE_` int(11) default NULL,  
  PRIMARY KEY  (`ID_`),  
  KEY `ACT_IDX_TASK_CREATE` (`CREATE_TIME_`),  
  KEY `ACT_FK_TASK_EXE` (`EXECUTION_ID_`),  
  KEY `ACT_FK_TASK_PROCINST` (`PROC_INST_ID_`),  
  KEY `ACT_FK_TASK_PROCDEF` (`PROC_DEF_ID_`),  
  CONSTRAINT `ACT_FK_TASK_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`),  
  CONSTRAINT `ACT_FK_TASK_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`),  
  CONSTRAINT `ACT_FK_TASK_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`)  
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; 


21
-- 导出  表 act_ru_identitylink 结构  
DROP TABLE IF EXISTS `act_ru_identitylink`;  
CREATE TABLE IF NOT EXISTS `act_ru_identitylink` (  
  `ID_` varchar(64) collate utf8_bin NOT NULL default '',  
  `REV_` int(11) default NULL,  
  `GROUP_ID_` varchar(255) collate utf8_bin default NULL,  
  `TYPE_` varchar(255) collate utf8_bin default NULL,  
  `USER_ID_` varchar(255) collate utf8_bin default NULL,  
  `TASK_ID_` varchar(64) collate utf8_bin default NULL,  
  `PROC_INST_ID_` varchar(64) collate utf8_bin default NULL,  
  `PROC_DEF_ID_` varchar(64) collate utf8_bin default NULL,  
  PRIMARY KEY  (`ID_`),  
  KEY `ACT_IDX_IDENT_LNK_USER` (`USER_ID_`),  
  KEY `ACT_IDX_IDENT_LNK_GROUP` (`GROUP_ID_`),  
  KEY `ACT_IDX_ATHRZ_PROCEDEF` (`PROC_DEF_ID_`),  
  KEY `ACT_FK_TSKASS_TASK` (`TASK_ID_`),  
  KEY `ACT_FK_IDL_PROCINST` (`PROC_INST_ID_`),  
  CONSTRAINT `ACT_FK_ATHRZ_PROCEDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`),  
  CONSTRAINT `ACT_FK_IDL_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`),  
  CONSTRAINT `ACT_FK_TSKASS_TASK` FOREIGN KEY (`TASK_ID_`) REFERENCES `act_ru_task` (`ID_`)  
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; 


22
-- 导出  表 act_ru_job 结构  
DROP TABLE IF EXISTS `act_ru_job`;  
CREATE TABLE IF NOT EXISTS `act_ru_job` (  
  `ID_` varchar(64) collate utf8_bin NOT NULL,  
  `REV_` int(11) default NULL,  
  `TYPE_` varchar(255) collate utf8_bin NOT NULL,  
  `LOCK_EXP_TIME_` timestamp NULL default NULL,  
  `LOCK_OWNER_` varchar(255) collate utf8_bin default NULL,  
  `EXCLUSIVE_` tinyint(1) default NULL,  
  `EXECUTION_ID_` varchar(64) collate utf8_bin default NULL,  
  `PROCESS_INSTANCE_ID_` varchar(64) collate utf8_bin default NULL,  
  `PROC_DEF_ID_` varchar(64) collate utf8_bin default NULL,  
  `RETRIES_` int(11) default NULL,  
  `EXCEPTION_STACK_ID_` varchar(64) collate utf8_bin default NULL,  
  `EXCEPTION_MSG_` varchar(4000) collate utf8_bin default NULL,  
  `DUEDATE_` timestamp NULL default NULL,  
  `REPEAT_` varchar(255) collate utf8_bin default NULL,  
  `HANDLER_TYPE_` varchar(255) collate utf8_bin default NULL,  
  `HANDLER_CFG_` varchar(4000) collate utf8_bin default NULL,  
  PRIMARY KEY  (`ID_`),  
  KEY `ACT_FK_JOB_EXCEPTION` (`EXCEPTION_STACK_ID_`),  
  CONSTRAINT `ACT_FK_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `act_ge_bytearray` (`ID_`)  
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; 




23
-- 导出  表 act_ru_variable 结构  
DROP TABLE IF EXISTS `act_ru_variable`;  
CREATE TABLE IF NOT EXISTS `act_ru_variable` (  
  `ID_` varchar(64) collate utf8_bin NOT NULL,  
  `REV_` int(11) default NULL,  
  `TYPE_` varchar(255) collate utf8_bin NOT NULL,  
  `NAME_` varchar(255) collate utf8_bin NOT NULL,  
  `EXECUTION_ID_` varchar(64) collate utf8_bin default NULL,  
  `PROC_INST_ID_` varchar(64) collate utf8_bin default NULL,  
  `TASK_ID_` varchar(64) collate utf8_bin default NULL,  
  `BYTEARRAY_ID_` varchar(64) collate utf8_bin default NULL,  
  `DOUBLE_` double default NULL,  
  `LONG_` bigint(20) default NULL,  
  `TEXT_` varchar(4000) collate utf8_bin default NULL,  
  `TEXT2_` varchar(4000) collate utf8_bin default NULL,  
  PRIMARY KEY  (`ID_`),  
  KEY `ACT_IDX_VARIABLE_TASK_ID` (`TASK_ID_`),  
  KEY `ACT_FK_VAR_EXE` (`EXECUTION_ID_`),  
  KEY `ACT_FK_VAR_PROCINST` (`PROC_INST_ID_`),  
  KEY `ACT_FK_VAR_BYTEARRAY` (`BYTEARRAY_ID_`),  
  CONSTRAINT `ACT_FK_VAR_BYTEARRAY` FOREIGN KEY (`BYTEARRAY_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),  
  CONSTRAINT `ACT_FK_VAR_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`),  
  CONSTRAINT `ACT_FK_VAR_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`)  
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;