jbpm4.3表创建

 

# 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='上下文(存放流程临时变量，当流程实例结束后，表中内容清除)';