drop table if exists buss;

drop table if exists chatRecord;

drop table if exists installPackage;

drop table if exists job;

drop table if exists menu;

drop table if exists org;

drop table if exists orgExt;

drop table if exists permission;

drop table if exists processAgencySet;

drop table if exists processSet;

drop table if exists registryTable;

drop table if exists registryType;

drop table if exists role;

drop table if exists rolePermission;

drop table if exists systemUser;

drop table if exists userExt;

drop table if exists userOrg;

drop table if exists userRole;

create table buss

(

name varchar(64) not null,

description varchar(128),

script text not null,

primary key (name)

);

create table chatRecord

(

id int not null auto_increment,

fromAccount varchar(128) not null,

fromName varchar(128) not null,

toAccount varchar(128) not null,

toName varchar(128) not null,

content varchar(512) not null,

sendTime datetime not null,

primary key (id)

);

create table installPackage

(

installVersion varchar(32) not null,

detail varchar(512) not null,

fileName varchar(64) not null,

newest tinyint not null,

publishDate varchar(32) not null,

primary key (installVersion)

);

create table job

(

id int not null auto_increment,

name varchar(64) not null comment '名称',

description varchar(256) comment '描述',

cronExpression varchar(128) comment 'cron表达式',

startTime varchar(64) comment '开始执行时间',

endTime varchar(64) comment '结束执行时间',

exeCount int comment '执行次数',

maxExeCount int comment '最大执行次数',

status varchar(16) comment '状态',

className varchar(256) not null comment '完整类路径',

methodName varchar(128) not null comment '执行类方法名',

delayTime int comment '延迟时间',

intervalTime int comment '间隔时间',

primary key (id)

);

alter table job comment '任务';

create table menu

(

id int not null auto_increment,

text varchar(64) not null,

parentID int not null,

url varchar(256),

orderNo int,

primary key (id)

);

alter table menu comment '菜单';

create table org

(

id int not null auto_increment comment '机构ID',

text varchar(128) not null comment '名称',

parentID int not null comment '父机构ID',

orderNo int comment '排序',

primary key (id)

);

alter table org comment '机构';

create table orgExt

(

id int not null comment '机构ID',

primary key (id)

);

alter table orgExt comment '机构扩展';

create table permission

(

id int not null auto_increment,

text varchar(64) not null,

url varchar(512),

parentID int not null,

primary key (id)

);

create table processAgencySet

(

id int not null auto_increment,

startTime varchar(32) not null comment '开始时间',

endTime varchar(32) not null comment '结束时间',

account varchar(64) not null comment '设置人',

agencyAccount varchar(64) not null comment '代理人',

primary key (id)

);

alter table processAgencySet comment '流程代办设置';

create table processSet

(

id varchar(16) not null comment '流程ID',

sendType varchar(32) binary not null comment '发送类型',

allStart tinyint not null comment '是否所有人员都可以启动流程',

primary key (id)

);

alter table processSet comment '流程设置';

create table registryTable

(

id int not null auto_increment,

code varchar(64) not null comment '编码',

value varchar(128) not null comment '值',

typeID int not null comment '类型ID',

description varchar(128) comment '描述',

primary key (id)

);

alter table registryTable comment '注册表';

create table registryType

(

id int not null auto_increment,

text varchar(128) not null comment '名称',

parentID int not null comment '父ID',

primary key (id)

);

alter table registryType comment '注册类型';

create table role

(

name varchar(64) not null,

description varchar(64),

primary key (name)

);

create table rolePermission

(

id int not null auto_increment,

roleName varchar(64) not null,

permissionID int not null,

primary key (id)

);

create table systemUser

(

account varchar(64) not null,

name varchar(64) not null,

pwd varchar(256) not null,

primary key (account)

);

create table userExt

(

userAccount varchar(64) not null comment '用户账号',

primary key (userAccount)

);

alter table userExt comment '用户扩展';

create table userOrg

(

id int not null auto_increment,

userAccount varchar(64) not null comment '用户账号',

orgID int not null comment '机构ID',

primary key (id)

);

alter table userOrg comment '用户机构';

create table userRole

(

userAccount varchar(64) not null,

roleName varchar(64) not null,

primary key (userAccount, roleName)

);

insert into menu(id,text,parentID,url,orderNo) values(10000,'机构管理',-1,'/org/list.do',1);

insert into menu(id,text,parentID,url,orderNo) values(10001,'用户管理',-1,'/user/list.do',2);

insert into menu(id,text,parentID,url,orderNo) values(10002,'角色管理',-1,'/role/list.do',3);

insert into menu(id,text,parentID,url,orderNo) values(10003,'权限管理',-1,'/permission/list.do',4);

insert into menu(id,text,parentID,url,orderNo) values(10004,'菜单管理',-1,'/menu/list.do',5);

insert into menu(id,text,parentID,url,orderNo) values(10005,'业务管理',-1,'/buss/list.do',6);

insert into menu(id,text,parentID,url,orderNo) values(10006,'版本管理',-1,'/install/list.do',7);

insert into menu(id,text,parentID,url,orderNo) values(10007,'注册类型管理',-1,'/registryType/list.do',8);

insert into menu(id,text,parentID,url,orderNo) values(10008,'注册表管理',-1,'/registryTable/list.do',9);

insert into menu(id,text,parentID,url,orderNo) values(10009,'流程管理',-1,'/processManagement/list.do',10);

insert into menu(id,text,parentID,url,orderNo) values(10010,'待办任务',-1,'/processDoing/list.do',11);

insert into menu(id,text,parentID,url,orderNo) values(10011,'已办任务',-1,'/processDone/list.do',12);

insert into menu(id,text,parentID,url,orderNo) values(10012,'启动流程',-1,'/processStart/list.do',13);

insert into menu(id,text,parentID,url,orderNo) values(10013,'流程监控',-1,'/processMonitor/list.do',14);

insert into menu(id,text,parentID,url,orderNo) values(10014,'代办设置',-1,'/processAgencySet/list.do',15);

insert into menu(id,text,parentID,url,orderNo) values(10015,'已归档流程',-1,'/processFinish/list.do',16);

insert into menu(id,text,parentID,url,orderNo) values(10016,'作业管理',-1,'/processJob/list.do',18);

insert into menu(id,text,parentID,url,orderNo) values(10017,'任务管理',-1,'/job/list.do',19);

create table ACT_GE_PROPERTY (

NAME_ varchar(64),

VALUE_ varchar(300),

REV_ integer,

primary key (NAME_)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;

insert into ACT_GE_PROPERTY

values ('schema.version', '5.21.0.0', 1);

insert into ACT_GE_PROPERTY

values ('schema.history', 'create(5.21.0.0)', 1);

insert into ACT_GE_PROPERTY

values ('next.dbid', '1', 1);

create table ACT_GE_BYTEARRAY (

ID_ varchar(64),

REV_ integer,

NAME_ varchar(255),

DEPLOYMENT_ID_ varchar(64),

BYTES_ LONGBLOB,

GENERATED_ TINYINT,

primary key (ID_)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;

create table ACT_RE_DEPLOYMENT (

ID_ varchar(64),

NAME_ varchar(255),

CATEGORY_ varchar(255),

TENANT_ID_ varchar(255) default '',

DEPLOY_TIME_ timestamp(3) NULL,

primary key (ID_)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;

create table ACT_RE_MODEL (

ID_ varchar(64) not null,

REV_ integer,

NAME_ varchar(255),

KEY_ varchar(255),

CATEGORY_ varchar(255),

CREATE_TIME_ timestamp(3) null,

LAST_UPDATE_TIME_ timestamp(3) null,

VERSION_ integer,

META_INFO_ varchar(4000),

DEPLOYMENT_ID_ varchar(64),

EDITOR_SOURCE_VALUE_ID_ varchar(64),

EDITOR_SOURCE_EXTRA_VALUE_ID_ varchar(64),

TENANT_ID_ varchar(255) default '',

primary key (ID_)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;

create table ACT_RU_EXECUTION (

ID_ varchar(64),

REV_ integer,

PROC_INST_ID_ varchar(64),

BUSINESS_KEY_ varchar(255),

PARENT_ID_ varchar(64),

PROC_DEF_ID_ varchar(64),

SUPER_EXEC_ varchar(64),

ACT_ID_ varchar(255),

IS_ACTIVE_ TINYINT,

IS_CONCURRENT_ TINYINT,

IS_SCOPE_ TINYINT,

IS_EVENT_SCOPE_ TINYINT,

SUSPENSION_STATE_ integer,

CACHED_ENT_STATE_ integer,

TENANT_ID_ varchar(255) default '',

NAME_ varchar(255),

LOCK_TIME_ timestamp(3) NULL,

primary key (ID_)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;

create table ACT_RU_JOB (

ID_ varchar(64) NOT NULL,

REV_ integer,

TYPE_ varchar(255) NOT NULL,

LOCK_EXP_TIME_ timestamp(3) NULL,

LOCK_OWNER_ varchar(255),

EXCLUSIVE_ boolean,

EXECUTION_ID_ varchar(64),

PROCESS_INSTANCE_ID_ varchar(64),

PROC_DEF_ID_ varchar(64),

RETRIES_ integer,

EXCEPTION_STACK_ID_ varchar(64),

EXCEPTION_MSG_ varchar(4000),

DUEDATE_ timestamp(3) NULL,

REPEAT_ varchar(255),

HANDLER_TYPE_ varchar(255),

HANDLER_CFG_ varchar(4000),

TENANT_ID_ varchar(255) default '',

primary key (ID_)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;

create table ACT_RE_PROCDEF (

ID_ varchar(64) not null,

REV_ integer,

CATEGORY_ varchar(255),

NAME_ varchar(255),

KEY_ varchar(255) not null,

VERSION_ integer not null,

DEPLOYMENT_ID_ varchar(64),

RESOURCE_NAME_ varchar(4000),

DGRM_RESOURCE_NAME_ varchar(4000),

DESCRIPTION_ varchar(4000),

HAS_START_FORM_KEY_ TINYINT,

HAS_GRAPHICAL_NOTATION_ TINYINT,

SUSPENSION_STATE_ integer,

TENANT_ID_ varchar(255) default '',

primary key (ID_)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;

create table ACT_RU_TASK (

ID_ varchar(64),

REV_ integer,

EXECUTION_ID_ varchar(64),

PROC_INST_ID_ varchar(64),

PROC_DEF_ID_ varchar(64),

NAME_ varchar(255),

PARENT_TASK_ID_ varchar(64),

DESCRIPTION_ varchar(4000),

TASK_DEF_KEY_ varchar(255),

OWNER_ varchar(255),

ASSIGNEE_ varchar(255),

DELEGATION_ varchar(64),

PRIORITY_ integer,

CREATE_TIME_ timestamp(3) NULL,

DUE_DATE_ datetime(3),

CATEGORY_ varchar(255),

SUSPENSION_STATE_ integer,

TENANT_ID_ varchar(255) default '',

FORM_KEY_ varchar(255),

primary key (ID_)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;

create table ACT_RU_IDENTITYLINK (

ID_ varchar(64),

REV_ integer,

GROUP_ID_ varchar(255),

TYPE_ varchar(255),

USER_ID_ varchar(255),

TASK_ID_ varchar(64),

PROC_INST_ID_ varchar(64),

PROC_DEF_ID_ varchar(64),

primary key (ID_)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;

create table ACT_RU_VARIABLE (

ID_ varchar(64) not null,

REV_ integer,

TYPE_ varchar(255) not null,

NAME_ varchar(255) not null,

EXECUTION_ID_ varchar(64),

PROC_INST_ID_ varchar(64),

TASK_ID_ varchar(64),

BYTEARRAY_ID_ varchar(64),

DOUBLE_ double,

LONG_ bigint,

TEXT_ varchar(4000),

TEXT2_ varchar(4000),

primary key (ID_)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;

create table ACT_RU_EVENT_SUBSCR (

ID_ varchar(64) not null,

REV_ integer,

EVENT_TYPE_ varchar(255) not null,

EVENT_NAME_ varchar(255),

EXECUTION_ID_ varchar(64),

PROC_INST_ID_ varchar(64),

ACTIVITY_ID_ varchar(64),

CONFIGURATION_ varchar(255),

CREATED_ timestamp(3) not null DEFAULT CURRENT_TIMESTAMP(3),

PROC_DEF_ID_ varchar(64),

TENANT_ID_ varchar(255) default '',

primary key (ID_)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;

create table ACT_EVT_LOG (

LOG_NR_ bigint auto_increment,

TYPE_ varchar(64),

PROC_DEF_ID_ varchar(64),

PROC_INST_ID_ varchar(64),

EXECUTION_ID_ varchar(64),

TASK_ID_ varchar(64),

TIME_STAMP_ timestamp(3) not null,

USER_ID_ varchar(255),

DATA_ LONGBLOB,

LOCK_OWNER_ varchar(255),

LOCK_TIME_ timestamp(3) null,

IS_PROCESSED_ tinyint default 0,

primary key (LOG_NR_)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;

create table ACT_PROCDEF_INFO (

ID_ varchar(64) not null,

PROC_DEF_ID_ varchar(64) not null,

REV_ integer,

INFO_JSON_ID_ varchar(64),

primary key (ID_)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;

create index ACT_IDX_EXEC_BUSKEY on ACT_RU_EXECUTION(BUSINESS_KEY_);

create index ACT_IDX_TASK_CREATE on ACT_RU_TASK(CREATE_TIME_);

create index ACT_IDX_IDENT_LNK_USER on ACT_RU_IDENTITYLINK(USER_ID_);

create index ACT_IDX_IDENT_LNK_GROUP on ACT_RU_IDENTITYLINK(GROUP_ID_);

create index ACT_IDX_EVENT_SUBSCR_CONFIG_ on ACT_RU_EVENT_SUBSCR(CONFIGURATION_);

create index ACT_IDX_VARIABLE_TASK_ID on ACT_RU_VARIABLE(TASK_ID_);

create index ACT_IDX_ATHRZ_PROCEDEF on ACT_RU_IDENTITYLINK(PROC_DEF_ID_);

create index ACT_IDX_INFO_PROCDEF on ACT_PROCDEF_INFO(PROC_DEF_ID_);

alter table ACT_GE_BYTEARRAY

add constraint ACT_FK_BYTEARR_DEPL

foreign key (DEPLOYMENT_ID_)

references ACT_RE_DEPLOYMENT (ID_);

alter table ACT_RE_PROCDEF

add constraint ACT_UNIQ_PROCDEF

unique (KEY_,VERSION_, TENANT_ID_);

alter table ACT_RU_EXECUTION

add constraint ACT_FK_EXE_PROCINST

foreign key (PROC_INST_ID_)

references ACT_RU_EXECUTION (ID_) on delete cascade on update cascade;

alter table ACT_RU_EXECUTION

add constraint ACT_FK_EXE_PARENT

foreign key (PARENT_ID_)

references ACT_RU_EXECUTION (ID_);

alter table ACT_RU_EXECUTION

add constraint ACT_FK_EXE_SUPER

foreign key (SUPER_EXEC_)

references ACT_RU_EXECUTION (ID_);

alter table ACT_RU_EXECUTION

add constraint ACT_FK_EXE_PROCDEF

foreign key (PROC_DEF_ID_)

references ACT_RE_PROCDEF (ID_);

alter table ACT_RU_IDENTITYLINK

add constraint ACT_FK_TSKASS_TASK

foreign key (TASK_ID_)

references ACT_RU_TASK (ID_);

alter table ACT_RU_IDENTITYLINK

add constraint ACT_FK_ATHRZ_PROCEDEF

foreign key (PROC_DEF_ID_)

references ACT_RE_PROCDEF(ID_);

alter table ACT_RU_IDENTITYLINK

add constraint ACT_FK_IDL_PROCINST

foreign key (PROC_INST_ID_)

references ACT_RU_EXECUTION (ID_);

alter table ACT_RU_TASK

add constraint ACT_FK_TASK_EXE

foreign key (EXECUTION_ID_)

references ACT_RU_EXECUTION (ID_);

alter table ACT_RU_TASK

add constraint ACT_FK_TASK_PROCINST

foreign key (PROC_INST_ID_)

references ACT_RU_EXECUTION (ID_);

alter table ACT_RU_TASK

add constraint ACT_FK_TASK_PROCDEF

foreign key (PROC_DEF_ID_)

references ACT_RE_PROCDEF (ID_);

alter table ACT_RU_VARIABLE

add constraint ACT_FK_VAR_EXE

foreign key (EXECUTION_ID_)

references ACT_RU_EXECUTION (ID_);

alter table ACT_RU_VARIABLE

add constraint ACT_FK_VAR_PROCINST

foreign key (PROC_INST_ID_)

references ACT_RU_EXECUTION(ID_);

alter table ACT_RU_VARIABLE

add constraint ACT_FK_VAR_BYTEARRAY

foreign key (BYTEARRAY_ID_)

references ACT_GE_BYTEARRAY (ID_);

alter table ACT_RU_JOB

add constraint ACT_FK_JOB_EXCEPTION

foreign key (EXCEPTION_STACK_ID_)

references ACT_GE_BYTEARRAY (ID_);

alter table ACT_RU_EVENT_SUBSCR

add constraint ACT_FK_EVENT_EXEC

foreign key (EXECUTION_ID_)

references ACT_RU_EXECUTION(ID_);

alter table ACT_RE_MODEL

add constraint ACT_FK_MODEL_SOURCE

foreign key (EDITOR_SOURCE_VALUE_ID_)

references ACT_GE_BYTEARRAY (ID_);

alter table ACT_RE_MODEL

add constraint ACT_FK_MODEL_SOURCE_EXTRA

foreign key (EDITOR_SOURCE_EXTRA_VALUE_ID_)

references ACT_GE_BYTEARRAY (ID_);

alter table ACT_RE_MODEL

add constraint ACT_FK_MODEL_DEPLOYMENT

foreign key (DEPLOYMENT_ID_)

references ACT_RE_DEPLOYMENT (ID_);

alter table ACT_PROCDEF_INFO

add constraint ACT_FK_INFO_JSON_BA

foreign key (INFO_JSON_ID_)

references ACT_GE_BYTEARRAY (ID_);

alter table ACT_PROCDEF_INFO

add constraint ACT_FK_INFO_PROCDEF

foreign key (PROC_DEF_ID_)

references ACT_RE_PROCDEF (ID_);

alter table ACT_PROCDEF_INFO

add constraint ACT_UNIQ_INFO_PROCDEF

unique (PROC_DEF_ID_);

create table ACT_HI_PROCINST (

ID_ varchar(64) not null,

PROC_INST_ID_ varchar(64) not null,

BUSINESS_KEY_ varchar(255),

PROC_DEF_ID_ varchar(64) not null,

START_TIME_ datetime(3) not null,

END_TIME_ datetime(3),

DURATION_ bigint,

START_USER_ID_ varchar(255),

START_ACT_ID_ varchar(255),

END_ACT_ID_ varchar(255),

SUPER_PROCESS_INSTANCE_ID_ varchar(64),

DELETE_REASON_ varchar(4000),

TENANT_ID_ varchar(255) default '',

NAME_ varchar(255),

primary key (ID_),

unique (PROC_INST_ID_)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;

create table ACT_HI_ACTINST (

ID_ varchar(64) not null,

PROC_DEF_ID_ varchar(64) not null,

PROC_INST_ID_ varchar(64) not null,

EXECUTION_ID_ varchar(64) not null,

ACT_ID_ varchar(255) not null,

TASK_ID_ varchar(64),

CALL_PROC_INST_ID_ varchar(64),

ACT_NAME_ varchar(255),

ACT_TYPE_ varchar(255) not null,

ASSIGNEE_ varchar(255),

START_TIME_ datetime(3) not null,

END_TIME_ datetime(3),

DURATION_ bigint,

TENANT_ID_ varchar(255) default '',

primary key (ID_)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;

create table ACT_HI_TASKINST (

ID_ varchar(64) not null,

PROC_DEF_ID_ varchar(64),

TASK_DEF_KEY_ varchar(255),

PROC_INST_ID_ varchar(64),

EXECUTION_ID_ varchar(64),

NAME_ varchar(255),

PARENT_TASK_ID_ varchar(64),

DESCRIPTION_ varchar(4000),

OWNER_ varchar(255),

ASSIGNEE_ varchar(255),

START_TIME_ datetime(3) not null,

CLAIM_TIME_ datetime(3),

END_TIME_ datetime(3),

DURATION_ bigint,

DELETE_REASON_ varchar(4000),

PRIORITY_ integer,

DUE_DATE_ datetime(3),

FORM_KEY_ varchar(255),

CATEGORY_ varchar(255),

TENANT_ID_ varchar(255) default '',

primary key (ID_)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;

create table ACT_HI_VARINST (

ID_ varchar(64) not null,

PROC_INST_ID_ varchar(64),

EXECUTION_ID_ varchar(64),

TASK_ID_ varchar(64),

NAME_ varchar(255) not null,

VAR_TYPE_ varchar(100),

REV_ integer,

BYTEARRAY_ID_ varchar(64),

DOUBLE_ double,

LONG_ bigint,

TEXT_ varchar(4000),

TEXT2_ varchar(4000),

CREATE_TIME_ datetime(3),

LAST_UPDATED_TIME_ datetime(3),

primary key (ID_)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;

create table ACT_HI_DETAIL (

ID_ varchar(64) not null,

TYPE_ varchar(255) not null,

PROC_INST_ID_ varchar(64),

EXECUTION_ID_ varchar(64),

TASK_ID_ varchar(64),

ACT_INST_ID_ varchar(64),

NAME_ varchar(255) not null,

VAR_TYPE_ varchar(255),

REV_ integer,

TIME_ datetime(3) not null,

BYTEARRAY_ID_ varchar(64),

DOUBLE_ double,

LONG_ bigint,

TEXT_ varchar(4000),

TEXT2_ varchar(4000),

primary key (ID_)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;

create table ACT_HI_COMMENT (

ID_ varchar(64) not null,

TYPE_ varchar(255),

TIME_ datetime(3) not null,

USER_ID_ varchar(255),

TASK_ID_ varchar(64),

PROC_INST_ID_ varchar(64),

ACTION_ varchar(255),

MESSAGE_ varchar(4000),

FULL_MSG_ LONGBLOB,

primary key (ID_)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;

create table ACT_HI_ATTACHMENT (

ID_ varchar(64) not null,

REV_ integer,

USER_ID_ varchar(255),

NAME_ varchar(255),

DESCRIPTION_ varchar(4000),

TYPE_ varchar(255),

TASK_ID_ varchar(64),

PROC_INST_ID_ varchar(64),

URL_ varchar(4000),

CONTENT_ID_ varchar(64),

TIME_ datetime(3),

primary key (ID_)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;

create table ACT_HI_IDENTITYLINK (

ID_ varchar(64),

GROUP_ID_ varchar(255),

TYPE_ varchar(255),

USER_ID_ varchar(255),

TASK_ID_ varchar(64),

PROC_INST_ID_ varchar(64),

primary key (ID_)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;

create index ACT_IDX_HI_PRO_INST_END on ACT_HI_PROCINST(END_TIME_);

create index ACT_IDX_HI_PRO_I_BUSKEY on ACT_HI_PROCINST(BUSINESS_KEY_);

create index ACT_IDX_HI_ACT_INST_START on ACT_HI_ACTINST(START_TIME_);

create index ACT_IDX_HI_ACT_INST_END on ACT_HI_ACTINST(END_TIME_);

create index ACT_IDX_HI_DETAIL_PROC_INST on ACT_HI_DETAIL(PROC_INST_ID_);

create index ACT_IDX_HI_DETAIL_ACT_INST on ACT_HI_DETAIL(ACT_INST_ID_);

create index ACT_IDX_HI_DETAIL_TIME on ACT_HI_DETAIL(TIME_);

create index ACT_IDX_HI_DETAIL_NAME on ACT_HI_DETAIL(NAME_);

create index ACT_IDX_HI_DETAIL_TASK_ID on ACT_HI_DETAIL(TASK_ID_);

create index ACT_IDX_HI_PROCVAR_PROC_INST on ACT_HI_VARINST(PROC_INST_ID_);

create index ACT_IDX_HI_PROCVAR_NAME_TYPE on ACT_HI_VARINST(NAME_, VAR_TYPE_);

create index ACT_IDX_HI_PROCVAR_TASK_ID on ACT_HI_VARINST(TASK_ID_);

create index ACT_IDX_HI_ACT_INST_PROCINST on ACT_HI_ACTINST(PROC_INST_ID_, ACT_ID_);

create index ACT_IDX_HI_ACT_INST_EXEC on ACT_HI_ACTINST(EXECUTION_ID_, ACT_ID_);

create index ACT_IDX_HI_IDENT_LNK_USER on ACT_HI_IDENTITYLINK(USER_ID_);

create index ACT_IDX_HI_IDENT_LNK_TASK on ACT_HI_IDENTITYLINK(TASK_ID_);

create index ACT_IDX_HI_IDENT_LNK_PROCINST on ACT_HI_IDENTITYLINK(PROC_INST_ID_);

create index ACT_IDX_HI_TASK_INST_PROCINST on ACT_HI_TASKINST(PROC_INST_ID_);

create table ACT_ID_GROUP (

ID_ varchar(64),

REV_ integer,

NAME_ varchar(255),

TYPE_ varchar(255),

primary key (ID_)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;

create table ACT_ID_MEMBERSHIP (

USER_ID_ varchar(64),

GROUP_ID_ varchar(64),

primary key (USER_ID_, GROUP_ID_)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;

create table ACT_ID_USER (

ID_ varchar(64),

REV_ integer,

FIRST_ varchar(255),

LAST_ varchar(255),

EMAIL_ varchar(255),

PWD_ varchar(255),

PICTURE_ID_ varchar(64),

primary key (ID_)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;

create table ACT_ID_INFO (

ID_ varchar(64),

REV_ integer,

USER_ID_ varchar(64),

TYPE_ varchar(64),

KEY_ varchar(255),

VALUE_ varchar(255),

PASSWORD_ LONGBLOB,

PARENT_ID_ varchar(255),

primary key (ID_)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;

alter table ACT_ID_MEMBERSHIP

add constraint ACT_FK_MEMB_GROUP

foreign key (GROUP_ID_)

references ACT_ID_GROUP (ID_);

alter table ACT_ID_MEMBERSHIP

add constraint ACT_FK_MEMB_USER

foreign key (USER_ID_)

references ACT_ID_USER (ID_);

CREATE TABLE BATCH_JOB_INSTANCE (

JOB_INSTANCE_ID BIGINT NOT NULL PRIMARY KEY ,

VERSION BIGINT ,

JOB_NAME VARCHAR(100) NOT NULL,

JOB_KEY VARCHAR(32) NOT NULL,

constraint JOB_INST_UN unique (JOB_NAME, JOB_KEY)

) ENGINE=InnoDB;

CREATE TABLE BATCH_JOB_EXECUTION (

JOB_EXECUTION_ID BIGINT NOT NULL PRIMARY KEY ,

VERSION BIGINT ,

JOB_INSTANCE_ID BIGINT NOT NULL,

CREATE_TIME DATETIME NOT NULL,

START_TIME DATETIME DEFAULT NULL ,

END_TIME DATETIME DEFAULT NULL ,

STATUS VARCHAR(10) ,

EXIT_CODE VARCHAR(2500) ,

EXIT_MESSAGE VARCHAR(2500) ,

LAST_UPDATED DATETIME,

JOB_CONFIGURATION_LOCATION VARCHAR(2500) NULL,

constraint JOB_INST_EXEC_FK foreign key (JOB_INSTANCE_ID)

references BATCH_JOB_INSTANCE(JOB_INSTANCE_ID)

) ENGINE=InnoDB;

CREATE TABLE BATCH_JOB_EXECUTION_PARAMS (

JOB_EXECUTION_ID BIGINT NOT NULL ,

TYPE_CD VARCHAR(6) NOT NULL ,

KEY_NAME VARCHAR(100) NOT NULL ,

STRING_VAL VARCHAR(250) ,

DATE_VAL DATETIME DEFAULT NULL ,

LONG_VAL BIGINT ,

DOUBLE_VAL DOUBLE PRECISION ,

IDENTIFYING CHAR(1) NOT NULL ,

constraint JOB_EXEC_PARAMS_FK foreign key (JOB_EXECUTION_ID)

references BATCH_JOB_EXECUTION(JOB_EXECUTION_ID)

) ENGINE=InnoDB;

CREATE TABLE BATCH_STEP_EXECUTION (

STEP_EXECUTION_ID BIGINT NOT NULL PRIMARY KEY ,

VERSION BIGINT NOT NULL,

STEP_NAME VARCHAR(100) NOT NULL,

JOB_EXECUTION_ID BIGINT NOT NULL,

START_TIME DATETIME NOT NULL ,

END_TIME DATETIME DEFAULT NULL ,

STATUS VARCHAR(10) ,

COMMIT_COUNT BIGINT ,

READ_COUNT BIGINT ,

FILTER_COUNT BIGINT ,

WRITE_COUNT BIGINT ,

READ_SKIP_COUNT BIGINT ,

WRITE_SKIP_COUNT BIGINT ,

PROCESS_SKIP_COUNT BIGINT ,

ROLLBACK_COUNT BIGINT ,

EXIT_CODE VARCHAR(2500) ,

EXIT_MESSAGE VARCHAR(2500) ,

LAST_UPDATED DATETIME,

constraint JOB_EXEC_STEP_FK foreign key (JOB_EXECUTION_ID)

references BATCH_JOB_EXECUTION(JOB_EXECUTION_ID)

) ENGINE=InnoDB;

CREATE TABLE BATCH_STEP_EXECUTION_CONTEXT (

STEP_EXECUTION_ID BIGINT NOT NULL PRIMARY KEY,

SHORT_CONTEXT VARCHAR(2500) NOT NULL,

SERIALIZED_CONTEXT TEXT ,

constraint STEP_EXEC_CTX_FK foreign key (STEP_EXECUTION_ID)

references BATCH_STEP_EXECUTION(STEP_EXECUTION_ID)

) ENGINE=InnoDB;

CREATE TABLE BATCH_JOB_EXECUTION_CONTEXT (

JOB_EXECUTION_ID BIGINT NOT NULL PRIMARY KEY,

SHORT_CONTEXT VARCHAR(2500) NOT NULL,

SERIALIZED_CONTEXT TEXT ,

constraint JOB_EXEC_CTX_FK foreign key (JOB_EXECUTION_ID)

references BATCH_JOB_EXECUTION(JOB_EXECUTION_ID)

) ENGINE=InnoDB;

CREATE TABLE BATCH_STEP_EXECUTION_SEQ (

ID BIGINT NOT NULL,

UNIQUE_KEY CHAR(1) NOT NULL,

constraint UNIQUE_KEY_UN unique (UNIQUE_KEY)

) ENGINE=InnoDB;

INSERT INTO BATCH_STEP_EXECUTION_SEQ (ID, UNIQUE_KEY) select * from (select 0 as ID, '0' as UNIQUE_KEY) as tmp where not exists(select * from BATCH_STEP_EXECUTION_SEQ);

CREATE TABLE BATCH_JOB_EXECUTION_SEQ (

ID BIGINT NOT NULL,

UNIQUE_KEY CHAR(1) NOT NULL,

constraint UNIQUE_KEY_UN unique (UNIQUE_KEY)

) ENGINE=InnoDB;

INSERT INTO BATCH_JOB_EXECUTION_SEQ (ID, UNIQUE_KEY) select * from (select 0 as ID, '0' as UNIQUE_KEY) as tmp where not exists(select * from BATCH_JOB_EXECUTION_SEQ);

CREATE TABLE BATCH_JOB_SEQ (

ID BIGINT NOT NULL,

UNIQUE_KEY CHAR(1) NOT NULL,

constraint UNIQUE_KEY_UN unique (UNIQUE_KEY)

) ENGINE=InnoDB;

INSERT INTO BATCH_JOB_SEQ (ID, UNIQUE_KEY) select * from (select 0 as ID, '0' as UNIQUE_KEY) as tmp where not exists(select * from BATCH_JOB_SEQ);