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_`),