/* Navicat MySQL Data Transfer
Source Server : myconn Source Server Version : 50528 Source Host : localhost:3306 Source Database : cpes
Target Server Type : MYSQL Target Server Version : 50528 File Encoding : 65001
Date: 2019-01-16 18:51:35 */
SET FOREIGN_KEY_CHECKS=0;
-- Table structure for act_ge_bytearray
DROP TABLE IF EXISTS act_ge_bytearray;
CREATE TABLE 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;
-- Table structure for act_ge_property
DROP TABLE IF EXISTS act_ge_property;
CREATE TABLE 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;
-- Table structure for act_hi_actinst
DROP TABLE IF EXISTS act_hi_actinst;
CREATE TABLE 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,
TENANT_ID_ varchar(255) COLLATE utf8_bin DEFAULT '',
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;
-- Table structure for act_hi_attachment
DROP TABLE IF EXISTS act_hi_attachment;
CREATE TABLE 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;
-- Table structure for act_hi_comment
DROP TABLE IF EXISTS act_hi_comment;
CREATE TABLE 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;
-- Table structure for act_hi_detail
DROP TABLE IF EXISTS act_hi_detail;
CREATE TABLE 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;
-- Table structure for act_hi_identitylink
DROP TABLE IF EXISTS act_hi_identitylink;
CREATE TABLE 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;
-- Table structure for act_hi_procinst
DROP TABLE IF EXISTS act_hi_procinst;
CREATE TABLE 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,
TENANT_ID_ varchar(255) COLLATE utf8_bin DEFAULT '',
PRIMARY KEY (ID_),
UNIQUE KEY PROC_INST_ID_ (PROC_INST_ID_),
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;
-- Table structure for act_hi_taskinst
DROP TABLE IF EXISTS act_hi_taskinst;
CREATE TABLE 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,
CATEGORY_ varchar(255) COLLATE utf8_bin DEFAULT NULL,
TENANT_ID_ varchar(255) COLLATE utf8_bin DEFAULT '',
PRIMARY KEY (ID_)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- Table structure for act_hi_varinst
DROP TABLE IF EXISTS act_hi_varinst;
CREATE TABLE 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,
CREATE_TIME_ datetime DEFAULT NULL,
LAST_UPDATED_TIME_ datetime 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;
-- Table structure for act_id_group
DROP TABLE IF EXISTS act_id_group;
CREATE TABLE 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;
-- Table structure for act_id_info
DROP TABLE IF EXISTS act_id_info;
CREATE TABLE 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;
-- Table structure for act_id_membership
DROP TABLE IF EXISTS act_id_membership;
CREATE TABLE 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_USER FOREIGN KEY (USER_ID_) REFERENCES act_id_user (ID_),
CONSTRAINT ACT_FK_MEMB_GROUP FOREIGN KEY (GROUP_ID_) REFERENCES act_id_group (ID_)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- Table structure for act_id_user
DROP TABLE IF EXISTS act_id_user;
CREATE TABLE 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;
-- Table structure for act_re_deployment
DROP TABLE IF EXISTS act_re_deployment;
CREATE TABLE 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,
TENANT_ID_ varchar(255) COLLATE utf8_bin DEFAULT '',
DEPLOY_TIME_ timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (ID_)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- Table structure for act_re_model
DROP TABLE IF EXISTS act_re_model;
CREATE TABLE 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,
TENANT_ID_ varchar(255) COLLATE utf8_bin DEFAULT '',
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;
-- Table structure for act_re_procdef
DROP TABLE IF EXISTS act_re_procdef;
CREATE TABLE 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,
TENANT_ID_ varchar(255) COLLATE utf8_bin DEFAULT '',
PRIMARY KEY (ID_),
UNIQUE KEY ACT_UNIQ_PROCDEF (KEY_,VERSION_,TENANT_ID_)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- Table structure for act_ru_event_subscr
DROP TABLE IF EXISTS act_ru_event_subscr;
CREATE TABLE 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,
PROC_DEF_ID_ varchar(64) COLLATE utf8_bin DEFAULT NULL,
TENANT_ID_ varchar(255) COLLATE utf8_bin DEFAULT '',
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;
-- Table structure for act_ru_execution
DROP TABLE IF EXISTS act_ru_execution;
CREATE TABLE 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,
TENANT_ID_ varchar(255) COLLATE utf8_bin DEFAULT '',
PRIMARY KEY (ID_),
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_),
KEY ACT_FK_EXE_PROCDEF (PROC_DEF_ID_),
CONSTRAINT ACT_FK_EXE_PROCDEF FOREIGN KEY (PROC_DEF_ID_) REFERENCES act_re_procdef (ID_),
CONSTRAINT ACT_FK_EXE_PARENT FOREIGN KEY (PARENT_ID_) REFERENCES act_ru_execution (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;
-- Table structure for act_ru_identitylink
DROP TABLE IF EXISTS act_ru_identitylink;
CREATE TABLE 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_IDL_PROCINST FOREIGN KEY (PROC_INST_ID_) REFERENCES act_ru_execution (ID_),
CONSTRAINT ACT_FK_ATHRZ_PROCEDEF FOREIGN KEY (PROC_DEF_ID_) REFERENCES act_re_procdef (ID_),
CONSTRAINT ACT_FK_TSKASS_TASK FOREIGN KEY (TASK_ID_) REFERENCES act_ru_task (ID_)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- Table structure for act_ru_job
DROP TABLE IF EXISTS act_ru_job;
CREATE TABLE 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,
TENANT_ID_ varchar(255) COLLATE utf8_bin DEFAULT '',
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;
-- Table structure for act_ru_task
DROP TABLE IF EXISTS act_ru_task;
CREATE TABLE 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,
CATEGORY_ varchar(255) COLLATE utf8_bin DEFAULT NULL,
SUSPENSION_STATE_ int(11) DEFAULT NULL,
TENANT_ID_ varchar(255) COLLATE utf8_bin DEFAULT '',
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_PROCDEF FOREIGN KEY (PROC_DEF_ID_) REFERENCES act_re_procdef (ID_),
CONSTRAINT ACT_FK_TASK_EXE FOREIGN KEY (EXECUTION_ID_) REFERENCES act_ru_execution (ID_),
CONSTRAINT ACT_FK_TASK_PROCINST FOREIGN KEY (PROC_INST_ID_) REFERENCES act_ru_execution (ID_)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- Table structure for act_ru_variable
DROP TABLE IF EXISTS act_ru_variable;
CREATE TABLE 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;
-- Table structure for t_acct_cert
DROP TABLE IF EXISTS t_acct_cert;
CREATE TABLE t_acct_cert (
id int(11) NOT NULL AUTO_INCREMENT,
accttype char(1) NOT NULL,
certid int(11) NOT NULL COMMENT '0-商业公司，1-个体工商户，2-个人经营，3-政府及非盈利组织',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
-- Table structure for t_cert
DROP TABLE IF EXISTS t_cert;
CREATE TABLE t_cert (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(255) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
-- Table structure for t_member
DROP TABLE IF EXISTS t_member;
CREATE TABLE t_member (
id int(11) NOT NULL AUTO_INCREMENT,
loginacct varchar(255) DEFAULT NULL,
password char(32) DEFAULT NULL,
status char(1) DEFAULT NULL COMMENT '0 - 未实名认证， 1 - 已实名认证',
accttype char(1) DEFAULT NULL COMMENT '0 - 企业， 1 - 个体， 2 - 个人， 3 - 政府',
realname varchar(255) DEFAULT NULL,
cardno varchar(255) DEFAULT NULL,
tel varchar(255) DEFAULT NULL,
email varchar(255) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- Table structure for t_member_cert
DROP TABLE IF EXISTS t_member_cert;
CREATE TABLE t_member_cert (
id int(11) NOT NULL AUTO_INCREMENT,
memberid int(11) DEFAULT NULL,
certid int(11) DEFAULT NULL,
iconpath varchar(255) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- Table structure for t_menu
DROP TABLE IF EXISTS t_menu;
CREATE TABLE t_menu (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(255) DEFAULT NULL,
url varchar(255) DEFAULT NULL,
pid int(11) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
-- Table structure for t_permission
DROP TABLE IF EXISTS t_permission;
CREATE TABLE t_permission (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(255) DEFAULT NULL,
url varchar(255) DEFAULT NULL,
pid int(11) DEFAULT NULL,
icon varchar(255) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
-- Table structure for t_role
DROP TABLE IF EXISTS t_role;
CREATE TABLE t_role (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(255) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
-- Table structure for t_role_permission
DROP TABLE IF EXISTS t_role_permission;
CREATE TABLE t_role_permission (
roleid int(11) DEFAULT NULL,
permissionid int(11) DEFAULT NULL,
id int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8;
-- Table structure for t_ticket
DROP TABLE IF EXISTS t_ticket;
CREATE TABLE t_ticket (
id int(11) NOT NULL AUTO_INCREMENT,
memberid int(11) DEFAULT NULL,
piid varchar(64) DEFAULT NULL,
authstatus char(1) DEFAULT NULL COMMENT '0 - 未审批， 1 - 已审批',
processstep varchar(255) DEFAULT NULL,
authcode varchar(255) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- Table structure for t_user
DROP TABLE IF EXISTS t_user;
CREATE TABLE t_user (
id int(11) NOT NULL AUTO_INCREMENT,
loginacct varchar(255) NOT NULL,
password char(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '用户表',
username varchar(255) DEFAULT NULL,
email varchar(255) DEFAULT NULL,
creatTime char(19) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
-- Table structure for t_user_role
DROP TABLE IF EXISTS t_user_role;
CREATE TABLE t_user_role (
userid int(11) DEFAULT NULL,
roleid int(11) DEFAULT NULL,
id int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;