?
# Dumping structure for table jbpmdb.jbpm4_deployment
DROP TABLE IF EXISTS `jbpm4_deployment`;
CREATE TABLE IF NOT EXISTS `jbpm4_deployment` (
? ?`DBID_` BIGINT(20) NOT NULL COMMENT '流程模版说明',
? ?`NAME_` LONGTEXT COMMENT '流程模版名称',
? ?`TIMESTAMP_` BIGINT(20) DEFAULT NULL COMMENT '时间戳',
? ?`STATE_` VARCHAR(255) DEFAULT NULL COMMENT '可用状态',
? ?PRIMARY KEY ?(`DBID_`)
?) ENGINE=INNODB DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC COMMENT='流程定义表';
?
# Data exporting was unselected.
?
?
# Dumping structure for table jbpmdb.jbpm4_deployprop
DROP TABLE IF EXISTS `jbpm4_deployprop`;
CREATE TABLE IF NOT EXISTS `jbpm4_deployprop` (
? ?`DBID_` BIGINT(20) NOT NULL COMMENT '主键',
? ?`DEPLOYMENT_` BIGINT(20) DEFAULT NULL COMMENT '流程ID',
? ?`OBJNAME_` VARCHAR(255) DEFAULT NULL COMMENT '流程名称',
? ?`KEY_` VARCHAR(255) DEFAULT NULL COMMENT '类型',
? ?`STRINGVAL_` VARCHAR(255) DEFAULT NULL COMMENT '类型是字符串时的值',
? ?`LONGVAL_` BIGINT(20) DEFAULT NULL COMMENT '类型是数值时的值',
? ?PRIMARY KEY ?(`DBID_`),
? ?KEY `IDX_DEPLPROP_DEPL` (`DEPLOYMENT_`),
? ?KEY `FK_DEPLPROP_DEPL` (`DEPLOYMENT_`),
? ?CONSTRAINT `FK_DEPLPROP_DEPL` FOREIGN KEY (`DEPLOYMENT_`) REFERENCES `jbpm4_deployment` (`DBID_`)
?) ENGINE=INNODB DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC COMMENT='流程定义属性表';
?
# Data exporting was unselected.
?
?
# Dumping structure for table jbpmdb.jbpm4_execution
DROP TABLE IF EXISTS `jbpm4_execution`;
CREATE TABLE IF NOT EXISTS `jbpm4_execution` (
? ?`DBID_` BIGINT(20) NOT NULL COMMENT '流程实例ID',
? ?`CLASS_` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '类型',
? ?`DBVERSION_` INT(11) NOT NULL COMMENT '步骤版本',
? ?`ACTIVITYNAME_` VARCHAR(255) DEFAULT NULL COMMENT '节点名称',
? ?`PROCDEFID_` VARCHAR(255) DEFAULT NULL COMMENT '流程定义ID',
? ?`HASVARS_` BIT(1) DEFAULT NULL COMMENT '是否有变量值',
? ?`NAME_` VARCHAR(255) DEFAULT NULL COMMENT '名称',
? ?`KEY_` VARCHAR(255) DEFAULT NULL,
? ?`ID_` VARCHAR(255) DEFAULT NULL COMMENT '令牌ID',
? ?`STATE_` VARCHAR(255) DEFAULT NULL COMMENT '令牌状态',
? ?`SUSPHISTSTATE_` VARCHAR(255) DEFAULT NULL COMMENT '保存暂停之前',
? ?`PRIORITY_` INT(11) DEFAULT NULL COMMENT '优先级',
? ?`HISACTINST_` BIGINT(20) DEFAULT NULL COMMENT '历史活动实例ID',
? ?`PARENT_` BIGINT(20) DEFAULT NULL COMMENT '父实例',
? ?`INSTANCE_` BIGINT(20) DEFAULT NULL COMMENT '流程实例',
? ?`SUPEREXEC_` BIGINT(20) DEFAULT NULL COMMENT '父令牌',
? ?`SUBPROCINST_` BIGINT(20) DEFAULT NULL COMMENT '子流程实例',
? ?`PARENT_IDX_` INT(11) DEFAULT NULL COMMENT '父实例序号',
? ?PRIMARY KEY ?(`DBID_`),
? ?UNIQUE KEY `ID_` (`ID_`),
? ?KEY `IDX_EXEC_SUBPI` (`SUBPROCINST_`),
? ?KEY `IDX_EXEC_PARENT` (`PARENT_`),
? ?KEY `IDX_EXEC_SUPEREXEC` (`SUPEREXEC_`),
? ?KEY `IDX_EXEC_INSTANCE` (`INSTANCE_`),
? ?KEY `FK_EXEC_SUBPI` (`SUBPROCINST_`),
? ?KEY `FK_EXEC_INSTANCE` (`INSTANCE_`),
? ?KEY `FK_EXEC_SUPEREXEC` (`SUPEREXEC_`),
? ?KEY `FK_EXEC_PARENT` (`PARENT_`),
? ?CONSTRAINT `FK_EXEC_INSTANCE` FOREIGN KEY (`INSTANCE_`) REFERENCES `jbpm4_execution` (`DBID_`),
? ?CONSTRAINT `FK_EXEC_PARENT` FOREIGN KEY (`PARENT_`) REFERENCES `jbpm4_execution` (`DBID_`),
? ?CONSTRAINT `FK_EXEC_SUBPI` FOREIGN KEY (`SUBPROCINST_`) REFERENCES `jbpm4_execution` (`DBID_`),
? ?CONSTRAINT `FK_EXEC_SUPEREXEC` FOREIGN KEY (`SUPEREXEC_`) REFERENCES `jbpm4_execution` (`DBID_`)
?) ENGINE=INNODB DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC COMMENT='流程实例表'
?
# Data exporting was unselected.
?
?
# Dumping structure for table jbpmdb.jbpm4_hist_actinst
DROP TABLE IF EXISTS `jbpm4_hist_actinst`;
CREATE TABLE IF NOT EXISTS `jbpm4_hist_actinst` (
? ?`DBID_` BIGINT(20) NOT NULL COMMENT '标识',
? ?`CLASS_` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'activitiy类型',
? ?`DBVERSION_` INT(11) NOT NULL COMMENT '版本',
? ?`HPROCI_` BIGINT(20) DEFAULT NULL COMMENT '历史流程实例',
? ?`TYPE_` VARCHAR(255) DEFAULT NULL COMMENT '活动实例类型',
? ?`EXECUTION_` VARCHAR(255) DEFAULT NULL COMMENT '令牌',
? ?`ACTIVITY_NAME_` VARCHAR(255) DEFAULT NULL COMMENT '活动实例名称',
? ?`START_` DATETIME DEFAULT NULL COMMENT '开始名称',
? ?`END_` DATETIME DEFAULT NULL COMMENT '结束时间',
? ?`DURATION_` BIGINT(20) DEFAULT NULL COMMENT '节点停留时间',
? ?`TRANSITION_` VARCHAR(255) DEFAULT NULL COMMENT '迁移路径',
? ?`NEXTIDX_` INT(11) DEFAULT NULL COMMENT '对应的路径',
? ?`HTASK_` BIGINT(20) DEFAULT NULL COMMENT '对应的定义任务',
? ?PRIMARY KEY ?(`DBID_`),
? ?KEY `IDX_HTI_HTASK` (`HTASK_`),
? ?KEY `IDX_HACTI_HPROCI` (`HPROCI_`),
? ?KEY `FK_HACTI_HPROCI` (`HPROCI_`),
? ?KEY `FK_HTI_HTASK` (`HTASK_`),
? ?CONSTRAINT `FK_HACTI_HPROCI` FOREIGN KEY (`HPROCI_`) REFERENCES `jbpm4_hist_procinst` (`DBID_`),
? ?CONSTRAINT `FK_HTI_HTASK` FOREIGN KEY (`HTASK_`) REFERENCES `jbpm4_hist_task` (`DBID_`)
?) ENGINE=INNODB DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC COMMENT='流程活动(节点)实例表'
?
# Data exporting was unselected.
?
?
# Dumping structure for table jbpmdb.jbpm4_hist_detail
DROP TABLE IF EXISTS `jbpm4_hist_detail`;
CREATE TABLE IF NOT EXISTS `jbpm4_hist_detail` (
? ?`DBID_` BIGINT(20) NOT NULL COMMENT '流程模版标识',
? ?`CLASS_` VARCHAR(255) NOT NULL DEFAULT '',
? ?`DBVERSION_` INT(11) NOT NULL COMMENT '版本',
? ?`USERID_` VARCHAR(255) DEFAULT NULL COMMENT '用户ID',
? ?`TIME_` DATETIME DEFAULT NULL COMMENT '时间',
? ?`HPROCI_` BIGINT(20) DEFAULT NULL COMMENT '对应的历史流程实例',
? ?`HPROCIIDX_` INT(11) DEFAULT NULL,
? ?`HACTI_` BIGINT(20) DEFAULT NULL COMMENT '对应的历史活动实例ID',
? ?`HACTIIDX_` INT(11) DEFAULT NULL,
? ?`HTASK_` BIGINT(20) DEFAULT NULL COMMENT '对应的任务',
? ?`HTASKIDX_` INT(11) DEFAULT NULL,
? ?`HVAR_` BIGINT(20) DEFAULT NULL COMMENT '对应的变量',
? ?`HVARIDX_` INT(11) DEFAULT NULL,
? ?`MESSAGE_` LONGTEXT COMMENT '消息',
? ?`OLD_STR_` VARCHAR(255) DEFAULT NULL COMMENT '老的String类型的值',
? ?`NEW_STR_` VARCHAR(255) DEFAULT NULL COMMENT '新的String类型的值',
? ?`OLD_INT_` INT(11) DEFAULT NULL,
? ?`NEW_INT_` INT(11) DEFAULT NULL,
? ?`OLD_TIME_` DATETIME DEFAULT NULL,
? ?`NEW_TIME_` DATETIME DEFAULT NULL,
? ?`PARENT_` BIGINT(20) DEFAULT NULL COMMENT '父变量',
? ?`PARENT_IDX_` INT(11) DEFAULT NULL COMMENT '变量的父变量序号',
? ?PRIMARY KEY ?(`DBID_`),
? ?KEY `IDX_HDET_HVAR` (`HVAR_`),
? ?KEY `IDX_HDET_HACTI` (`HACTI_`),
? ?KEY `IDX_HDET_HTASK` (`HTASK_`),
? ?KEY `IDX_HDET_HPROCI` (`HPROCI_`),
? ?KEY `FK_HDETAIL_HVAR` (`HVAR_`),
? ?KEY `FK_HDETAIL_HPROCI` (`HPROCI_`),
? ?KEY `FK_HDETAIL_HTASK` (`HTASK_`),
? ?KEY `FK_HDETAIL_HACTI` (`HACTI_`),
? ?CONSTRAINT `FK_HDETAIL_HACTI` FOREIGN KEY (`HACTI_`) REFERENCES `jbpm4_hist_actinst` (`DBID_`),
? ?CONSTRAINT `FK_HDETAIL_HPROCI` FOREIGN KEY (`HPROCI_`) REFERENCES `jbpm4_hist_procinst` (`DBID_`),
? ?CONSTRAINT `FK_HDETAIL_HTASK` FOREIGN KEY (`HTASK_`) REFERENCES `jbpm4_hist_task` (`DBID_`),
? ?CONSTRAINT `FK_HDETAIL_HVAR` FOREIGN KEY (`HVAR_`) REFERENCES `jbpm4_hist_var` (`DBID_`)
?) ENGINE=INNODB DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC COMMENT='流程历史详细表(保存变量变更记录)';
?
# Data exporting was unselected.
?
?
# Dumping structure for table jbpmdb.jbpm4_hist_procinst
DROP TABLE IF EXISTS `jbpm4_hist_procinst`;
CREATE TABLE IF NOT EXISTS `jbpm4_hist_procinst` (
? ?`DBID_` BIGINT(20) NOT NULL COMMENT '标识',
? ?`DBVERSION_` INT(11) NOT NULL COMMENT '版本',
? ?`ID_` VARCHAR(255) DEFAULT NULL,
? ?`PROCDEFID_` VARCHAR(255) DEFAULT NULL COMMENT '流程定义ID',
? ?`KEY_` VARCHAR(255) DEFAULT NULL,
? ?`START_` DATETIME DEFAULT NULL COMMENT '开始时间',
? ?`END_` DATETIME DEFAULT NULL COMMENT '结束时间',
? ?`DURATION_` BIGINT(20) DEFAULT NULL COMMENT '停留时间',
? ?`STATE_` VARCHAR(255) DEFAULT NULL COMMENT '流程实例状态（活动，完成）',
? ?`ENDACTIVITY_` VARCHAR(255) DEFAULT NULL COMMENT '是否完成',
? ?`NEXTIDX_` INT(11) DEFAULT NULL,
? ?PRIMARY KEY ?(`DBID_`)
?) ENGINE=INNODB DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC COMMENT='流程实例历史表';
?
# Data exporting was unselected.
?
?
# Dumping structure for table jbpmdb.jbpm4_hist_task
DROP TABLE IF EXISTS `jbpm4_hist_task`;
CREATE TABLE IF NOT EXISTS `jbpm4_hist_task` (
? ?`DBID_` BIGINT(20) NOT NULL COMMENT '标识',
? ?`DBVERSION_` INT(11) NOT NULL COMMENT '版本',
? ?`EXECUTION_` VARCHAR(255) DEFAULT NULL COMMENT '令牌',
? ?`OUTCOME_` VARCHAR(255) DEFAULT NULL COMMENT '路径名称',
? ?`ASSIGNEE_` VARCHAR(255) DEFAULT NULL COMMENT '处理人',
? ?`PRIORITY_` INT(11) DEFAULT NULL COMMENT '优先级',
? ?`STATE_` VARCHAR(255) DEFAULT NULL COMMENT '完成情况',
? ?`CREATE_` DATETIME DEFAULT NULL COMMENT '创建时间',
? ?`END_` DATETIME DEFAULT NULL COMMENT '完成时间',
? ?`DURATION_` BIGINT(20) DEFAULT NULL COMMENT '任务节点停留时间',
? ?`NEXTIDX_` INT(11) DEFAULT NULL,
? ?`SUPERTASK_` BIGINT(20) DEFAULT NULL COMMENT '父任务',
? ?PRIMARY KEY ?(`DBID_`),
? ?KEY `IDX_HSUPERT_SUB` (`SUPERTASK_`),
? ?KEY `FK_HSUPERT_SUB` (`SUPERTASK_`),
? ?CONSTRAINT `FK_HSUPERT_SUB` FOREIGN KEY (`SUPERTASK_`) REFERENCES `jbpm4_hist_task` (`DBID_`)
?) ENGINE=INNODB DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC COMMENT='流程任务实例历史表'
?
# Data exporting was unselected.
?
?
# Dumping structure for table jbpmdb.jbpm4_hist_var
DROP TABLE IF EXISTS `jbpm4_hist_var`;
CREATE TABLE IF NOT EXISTS `jbpm4_hist_var` (
? ?`DBID_` BIGINT(20) NOT NULL COMMENT '流程模版标识',
? ?`DBVERSION_` INT(11) NOT NULL COMMENT '版本',
? ?`PROCINSTID_` VARCHAR(255) DEFAULT NULL COMMENT '对应运行的流程实例',
? ?`EXECUTIONID_` VARCHAR(255) DEFAULT NULL COMMENT '活动实例ID',
? ?`VARNAME_` VARCHAR(255) DEFAULT NULL COMMENT '变量名称',
? ?`VALUE_` VARCHAR(255) DEFAULT NULL COMMENT '值',
? ?`HPROCI_` BIGINT(20) DEFAULT NULL COMMENT '历史流程实例',
? ?`HTASK_` BIGINT(20) DEFAULT NULL COMMENT '历史任务',
? ?PRIMARY KEY ?(`DBID_`),
? ?KEY `IDX_HVAR_HTASK` (`HTASK_`),
? ?KEY `IDX_HVAR_HPROCI` (`HPROCI_`),
? ?KEY `FK_HVAR_HPROCI` (`HPROCI_`),
? ?KEY `FK_HVAR_HTASK` (`HTASK_`),
? ?CONSTRAINT `FK_HVAR_HPROCI` FOREIGN KEY (`HPROCI_`) REFERENCES `jbpm4_hist_procinst` (`DBID_`),
? ?CONSTRAINT `FK_HVAR_HTASK` FOREIGN KEY (`HTASK_`) REFERENCES `jbpm4_hist_task` (`DBID_`)
?) ENGINE=INNODB DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC COMMENT='流程变量(上下文)历史表 （保存历史的变量）'
?
# Data exporting was unselected.
?
?
# Dumping structure for table jbpmdb.jbpm4_id_group
DROP TABLE IF EXISTS `jbpm4_id_group`;
CREATE TABLE IF NOT EXISTS `jbpm4_id_group` (
? `DBID_` BIGINT(20) NOT NULL,
? `DBVERSION_` INT(11) NOT NULL,
? `ID_` VARCHAR(255) DEFAULT NULL,
? `NAME_` VARCHAR(255) DEFAULT NULL,
? `TYPE_` VARCHAR(255) DEFAULT NULL,
? `PARENT_` BIGINT(20) DEFAULT NULL,
? PRIMARY KEY (`DBID_`),
? KEY `IDX_GROUP_PARENT` (`PARENT_`),
? KEY `FK_GROUP_PARENT` (`PARENT_`),
? CONSTRAINT `FK_GROUP_PARENT` FOREIGN KEY (`PARENT_`) REFERENCES `jbpm4_id_group` (`DBID_`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=INNODB DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC COMMENT='用户组表';
?
# Data exporting was unselected.
?
?
# Dumping structure for table jbpmdb.jbpm4_id_membership
DROP TABLE IF EXISTS `jbpm4_id_membership`;
CREATE TABLE IF NOT EXISTS `jbpm4_id_membership` (
? `DBID_` BIGINT(20) NOT NULL,
? `DBVERSION_` INT(11) NOT NULL,
? `USER_` BIGINT(20) DEFAULT NULL,
? `GROUP_` BIGINT(20) DEFAULT NULL,
? `NAME_` VARCHAR(255) DEFAULT NULL,
? PRIMARY KEY (`DBID_`),
? KEY `IDX_MEM_GROUP` (`GROUP_`),
? KEY `IDX_MEM_USER` (`USER_`),
? KEY `FK_MEM_GROUP` (`GROUP_`),
? KEY `FK_MEM_USER` (`USER_`),
? CONSTRAINT `FK_MEM_GROUP` FOREIGN KEY (`GROUP_`) REFERENCES `jbpm4_id_group` (`DBID_`) ON DELETE CASCADE ON UPDATE CASCADE,
? CONSTRAINT `FK_MEM_USER` FOREIGN KEY (`USER_`) REFERENCES `jbpm4_id_user` (`DBID_`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=INNODB DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC COMMENT='成员关系表';
?
# Data exporting was unselected.
?
?
# Dumping structure for table jbpmdb.jbpm4_id_user
DROP TABLE IF EXISTS `jbpm4_id_user`;
CREATE TABLE IF NOT EXISTS `jbpm4_id_user` (
? `DBID_` BIGINT(20) NOT NULL,
? `DBVERSION_` INT(11) NOT NULL,
? `ID_` VARCHAR(255) DEFAULT NULL,
? `PASSWORD_` VARCHAR(255) DEFAULT NULL,
? `GIVENNAME_` VARCHAR(255) DEFAULT NULL,
? `FAMILYNAME_` VARCHAR(255) DEFAULT NULL,
? `BUSINESSEMAIL_` VARCHAR(255) DEFAULT NULL,
? PRIMARY KEY (`DBID_`)
) ENGINE=INNODB DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC COMMENT='用户表';
?
# Data exporting was unselected.
?
?
# Dumping structure for table jbpmdb.jbpm4_job
DROP TABLE IF EXISTS `jbpm4_job`;
CREATE TABLE IF NOT EXISTS `jbpm4_job` (
? ?`DBID_` BIGINT(20) NOT NULL COMMENT '标识',
? ?`CLASS_` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '版本',
? ?`DBVERSION_` INT(11) NOT NULL,
? ?`DUEDATE_` DATETIME DEFAULT NULL COMMENT '到期时间',
? ?`STATE_` VARCHAR(255) DEFAULT NULL COMMENT '状态',
? ?`ISEXCLUSIVE_` BIT(1) DEFAULT NULL COMMENT '是否可执行',
? ?`LOCKOWNER_` VARCHAR(255) DEFAULT NULL COMMENT '锁定的参与者',
? ?`LOCKEXPTIME_` DATETIME DEFAULT NULL COMMENT '锁定释放时间',
? ?`EXCEPTION_` LONGTEXT COMMENT '活动实例',
? ?`RETRIES_` INT(11) DEFAULT NULL COMMENT '重复次数',
? ?`PROCESSINSTANCE_` BIGINT(20) DEFAULT NULL COMMENT '流程实例',
? ?`EXECUTION_` BIGINT(20) DEFAULT NULL COMMENT '异常信息',
? ?`CFG_` BIGINT(20) DEFAULT NULL COMMENT '配置',
? ?`SIGNAL_` VARCHAR(255) DEFAULT NULL COMMENT '信号',
? ?`EVENT_` VARCHAR(255) DEFAULT NULL COMMENT '时间',
? ?`REPEAT_` VARCHAR(255) DEFAULT NULL COMMENT '重复',
? ?PRIMARY KEY ?(`DBID_`),
? ?KEY `IDX_JOBRETRIES` (`RETRIES_`),
? ?KEY `IDX_JOBDUEDATE` (`DUEDATE_`),
? ?KEY `IDX_JOBLOCKEXP` (`LOCKEXPTIME_`),
? ?KEY `IDX_JOB_CFG` (`CFG_`),
? ?KEY `IDX_JOB_EXE` (`EXECUTION_`),
? ?KEY `IDX_JOB_PRINST` (`PROCESSINSTANCE_`),
? ?KEY `FK_JOB_CFG` (`CFG_`),
? ?CONSTRAINT `FK_JOB_CFG` FOREIGN KEY (`CFG_`) REFERENCES `jbpm4_lob` (`DBID_`)
?) ENGINE=INNODB DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC COMMENT='定时';
?
# Data exporting was unselected.
?
?
# Dumping structure for table jbpmdb.jbpm4_lob
DROP TABLE IF EXISTS `jbpm4_lob`;
CREATE TABLE IF NOT EXISTS `jbpm4_lob` (
? ?`DBID_` BIGINT(20) NOT NULL COMMENT '主键',
? ?`DBVERSION_` INT(11) NOT NULL COMMENT '版本',
? ?`BLOB_VALUE_` LONGBLOB COMMENT '流程定义文件（xml、img、class）',
? ?`DEPLOYMENT_` BIGINT(20) DEFAULT NULL COMMENT '流程模版标识ID',
? ?`NAME_` LONGTEXT COMMENT '流程定义文件名',
? ?PRIMARY KEY ?(`DBID_`),
? ?KEY `IDX_LOB_DEPLOYMENT` (`DEPLOYMENT_`),
? ?KEY `FK_LOB_DEPLOYMENT` (`DEPLOYMENT_`),
? ?CONSTRAINT `FK_LOB_DEPLOYMENT` FOREIGN KEY (`DEPLOYMENT_`) REFERENCES `jbpm4_deployment` (`DBID_`)
?) ENGINE=INNODB DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC COMMENT='存储';
?
# Data exporting was unselected.
?
?
# Dumping structure for table jbpmdb.jbpm4_participation
DROP TABLE IF EXISTS `jbpm4_participation`;
CREATE TABLE IF NOT EXISTS `jbpm4_participation` (
? ?`DBID_` BIGINT(20) NOT NULL COMMENT '标识',
? ?`DBVERSION_` INT(11) NOT NULL COMMENT '版本',
? ?`GROUPID_` VARCHAR(255) DEFAULT NULL COMMENT '组ID',
? ?`USERID_` VARCHAR(255) DEFAULT NULL COMMENT '用户ID',
? ?`TYPE_` VARCHAR(255) DEFAULT NULL COMMENT '类型',
? ?`TASK_` BIGINT(20) DEFAULT NULL COMMENT '任务ID',
? ?`SWIMLANE_` BIGINT(20) DEFAULT NULL COMMENT '对应泳道',
? ?PRIMARY KEY ?(`DBID_`),
? ?KEY `IDX_PART_TASK` (`TASK_`),
? ?KEY `FK_PART_SWIMLANE` (`SWIMLANE_`),
? ?KEY `FK_PART_TASK` (`TASK_`),
? ?CONSTRAINT `FK_PART_SWIMLANE` FOREIGN KEY (`SWIMLANE_`) REFERENCES `jbpm4_swimlane` (`DBID_`),
? ?CONSTRAINT `FK_PART_TASK` FOREIGN KEY (`TASK_`) REFERENCES `jbpm4_task` (`DBID_`)
?) ENGINE=INNODB DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC COMMENT='参与者';
?
# Data exporting was unselected.
?
?
# Dumping structure for table jbpmdb.jbpm4_property
DROP TABLE IF EXISTS `jbpm4_property`;
CREATE TABLE IF NOT EXISTS `jbpm4_property` (
? `KEY_` VARCHAR(255) NOT NULL,
? `VERSION_` INT(11) NOT NULL,
? `VALUE_` VARCHAR(255) DEFAULT NULL,
? PRIMARY KEY (`KEY_`)
) ENGINE=INNODB DEFAULT CHARSET=gbk;
?
# Data exporting was unselected.
?
?
# Dumping structure for table jbpmdb.jbpm4_swimlane
DROP TABLE IF EXISTS `jbpm4_swimlane`;
CREATE TABLE IF NOT EXISTS `jbpm4_swimlane` (
? ?`DBID_` BIGINT(20) NOT NULL COMMENT '标识',
? ?`DBVERSION_` INT(11) NOT NULL COMMENT '版本',
? ?`NAME_` VARCHAR(255) DEFAULT NULL COMMENT '泳道名',
? ?`ASSIGNEE_` VARCHAR(255) DEFAULT NULL COMMENT '处理人',
? ?`EXECUTION_` BIGINT(20) DEFAULT NULL COMMENT '活动实例',
? ?PRIMARY KEY ?(`DBID_`),
? ?KEY `IDX_SWIMLANE_EXEC` (`EXECUTION_`),
? ?KEY `FK_SWIMLANE_EXEC` (`EXECUTION_`),
? ?CONSTRAINT `FK_SWIMLANE_EXEC` FOREIGN KEY (`EXECUTION_`) REFERENCES `jbpm4_execution` (`DBID_`)
?) ENGINE=INNODB DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC COMMENT='泳道';
?
# Data exporting was unselected.
?
?
# Dumping structure for table jbpmdb.jbpm4_task
DROP TABLE IF EXISTS `jbpm4_task`;
CREATE TABLE IF NOT EXISTS `jbpm4_task` (
? ?`DBID_` BIGINT(20) NOT NULL COMMENT '主键',
? ?`CLASS_` CHAR(1) NOT NULL DEFAULT '' COMMENT '类型',
? ?`DBVERSION_` INT(11) NOT NULL COMMENT '版本',
? ?`NAME_` VARCHAR(255) DEFAULT NULL COMMENT '活动节点名称',
? ?`DESCR_` LONGTEXT COMMENT '描述',
? ?`STATE_` VARCHAR(255) DEFAULT NULL COMMENT '状态',
? ?`SUSPHISTSTATE_` VARCHAR(255) DEFAULT NULL COMMENT '保存暂停之前状态',
? ?`ASSIGNEE_` VARCHAR(255) DEFAULT NULL COMMENT '处理人',
? ?`FORM_` VARCHAR(255) DEFAULT NULL COMMENT '表单地址',
? ?`PRIORITY_` INT(11) DEFAULT NULL COMMENT '优先级',
? ?`CREATE_` DATETIME DEFAULT NULL COMMENT '创建时间',
? ?`DUEDATE_` DATETIME DEFAULT NULL COMMENT '任务持续时间，表明任务应在多长时间内完成',
? ?`PROGRESS_` INT(11) DEFAULT NULL COMMENT '活动实例名称',
? ?`SIGNALLING_` BIT(1) DEFAULT NULL COMMENT '签收',
? ?`EXECUTION_ID_` VARCHAR(255) DEFAULT NULL COMMENT '活动实例ID',
? ?`ACTIVITY_NAME_` VARCHAR(255) DEFAULT NULL COMMENT '活动实例名称',
? ?`HASVARS_` BIT(1) DEFAULT NULL COMMENT '是否有流程变量',
? ?`SUPERTASK_` BIGINT(20) DEFAULT NULL COMMENT '父任务',
? ?`EXECUTION_` BIGINT(20) DEFAULT NULL COMMENT '活动实例',
? ?`PROCINST_` BIGINT(20) DEFAULT NULL COMMENT '流程实例',
? ?`SWIMLANE_` BIGINT(20) DEFAULT NULL COMMENT '对应的泳道',
? ?`TASKDEFNAME_` VARCHAR(255) DEFAULT NULL COMMENT '任务定义名',
? ?PRIMARY KEY ?(`DBID_`),
? ?KEY `IDX_TASK_SUPERTASK` (`SUPERTASK_`),
? ?KEY `FK_TASK_SWIML` (`SWIMLANE_`),
? ?KEY `FK_TASK_SUPERTASK` (`SUPERTASK_`),
? ?CONSTRAINT `FK_TASK_SUPERTASK` FOREIGN KEY (`SUPERTASK_`) REFERENCES `jbpm4_task` (`DBID_`),
? ?CONSTRAINT `FK_TASK_SWIML` FOREIGN KEY (`SWIMLANE_`) REFERENCES `jbpm4_swimlane` (`DBID_`)
?) ENGINE=INNODB DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC COMMENT='任务表';
?
# Data exporting was unselected.
?
?
# Dumping structure for table jbpmdb.jbpm4_variable
DROP TABLE IF EXISTS `jbpm4_variable`;
CREATE TABLE IF NOT EXISTS `jbpm4_variable` (
? ?`DBID_` BIGINT(20) NOT NULL COMMENT '标识',
? ?`CLASS_` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '版本',
? ?`DBVERSION_` INT(11) NOT NULL COMMENT '变量类型',
? ?`KEY_` VARCHAR(255) DEFAULT NULL COMMENT '变量索引',
? ?`CONVERTER_` VARCHAR(255) DEFAULT NULL COMMENT '数值转换器',
? ?`HIST_` BIT(1) DEFAULT NULL COMMENT '对应的流程实例',
? ?`EXECUTION_` BIGINT(20) DEFAULT NULL COMMENT '活动实例',
? ?`TASK_` BIGINT(20) DEFAULT NULL COMMENT '对应的任务',
? ?`LOB_` BIGINT(20) DEFAULT NULL,
? ?`DATE_VALUE_` DATETIME DEFAULT NULL COMMENT '当值为date类型时，存值',
? ?`DOUBLE_VALUE_` DOUBLE DEFAULT NULL COMMENT '当值为double类型时，存值',
? ?`CLASSNAME_` VARCHAR(255) DEFAULT NULL COMMENT '变量类型',
? ?`LONG_VALUE_` BIGINT(20) DEFAULT NULL COMMENT '当值为long类型时，存值',
? ?`STRING_VALUE_` VARCHAR(255) DEFAULT NULL COMMENT '当值为String类型时，存值',
? ?`TEXT_VALUE_` LONGTEXT COMMENT '当值为text类型时，存值',
? ?`EXESYS_` BIGINT(20) DEFAULT NULL,
? ?PRIMARY KEY ?(`DBID_`),
? ?KEY `IDX_VAR_EXESYS` (`EXESYS_`),
? ?KEY `IDX_VAR_TASK` (`TASK_`),
? ?KEY `IDX_VAR_EXECUTION` (`EXECUTION_`),
? ?KEY `IDX_VAR_LOB` (`LOB_`),
? ?KEY `FK_VAR_EXESYS` (`EXESYS_`),
? ?KEY `FK_VAR_LOB` (`LOB_`),
? ?KEY `FK_VAR_TASK` (`TASK_`),
? ?KEY `FK_VAR_EXECUTION` (`EXECUTION_`),
? ?CONSTRAINT `FK_VAR_EXECUTION` FOREIGN KEY (`EXECUTION_`) REFERENCES `jbpm4_execution` (`DBID_`),
? ?CONSTRAINT `FK_VAR_EXESYS` FOREIGN KEY (`EXESYS_`) REFERENCES `jbpm4_execution` (`DBID_`),
? ?CONSTRAINT `FK_VAR_LOB` FOREIGN KEY (`LOB_`) REFERENCES `jbpm4_lob` (`DBID_`),
? ?CONSTRAINT `FK_VAR_TASK` FOREIGN KEY (`TASK_`) REFERENCES `jbpm4_task` (`DBID_`)
?) ENGINE=INNODB DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC COMMENT='上下文(存放流程临时变量，当流程实例结束后，表中内容清除)';