activity表创建

IF EXISTS (SELECT name FROM sysindexes WHERE name = 'ACT_IDX_EXEC_BUSKEY') drop index ACT_RU_EXECUTION.ACT_IDX_EXEC_BUSKEY;  
IF EXISTS (SELECT name FROM sysindexes WHERE name = 'ACT_IDX_TASK_CREATE') drop index ACT_RU_TASK.ACT_IDX_TASK_CREATE;  
IF EXISTS (SELECT name FROM sysindexes WHERE name = 'ACT_IDX_IDENT_LNK_USER') drop index ACT_RU_IDENTITYLINK.ACT_IDX_IDENT_LNK_USER;  
IF EXISTS (SELECT name FROM sysindexes WHERE name = 'ACT_IDX_IDENT_LNK_GROUP') drop index ACT_RU_IDENTITYLINK.ACT_IDX_IDENT_LNK_GROUP;  
IF EXISTS (SELECT name FROM sysindexes WHERE name = 'ACT_IDX_VARIABLE_TASK_ID') drop index ACT_RU_VARIABLE.ACT_IDX_VARIABLE_TASK_ID;  
IF EXISTS (SELECT name FROM sysindexes WHERE name = 'ACT_IDX_EVENT_SUBSCR_CONFIG_') drop index ACT_RU_EVENT_SUBSCR.ACT_IDX_EVENT_SUBSCR_CONFIG_;  
  
if exists (select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'ACT_GE_BYTEARRAY') alter table ACT_GE_BYTEARRAY drop constraint ACT_FK_BYTEARR_DEPL;  
if exists (select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'ACT_RE_PROCDEF') alter table ACT_RE_PROCDEF drop constraint ACT_UNIQ_PROCDEF;  
if exists (select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'ACT_RU_EXECUTION') alter table ACT_RU_EXECUTION drop constraint ACT_FK_EXE_PROCDEF;  
if exists (select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'ACT_RU_EXECUTION') alter table ACT_RU_EXECUTION drop constraint ACT_FK_EXE_PARENT;  
if exists (select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'ACT_RU_EXECUTION') alter table ACT_RU_EXECUTION drop constraint ACT_FK_EXE_SUPER;    
if exists (select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'ACT_RU_IDENTITYLINK') alter table ACT_RU_IDENTITYLINK drop constraint ACT_FK_TSKASS_TASK;  
if exists (select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'ACT_RU_IDENTITYLINK') alter table ACT_RU_IDENTITYLINK drop constraint ACT_FK_ATHRZ_PROCEDEF;  
if exists (select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'ACT_RU_TASK') alter table ACT_RU_TASK drop constraint ACT_FK_TASK_EXE;  
if exists (select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'ACT_RU_TASK') alter table ACT_RU_TASK drop constraint ACT_FK_TASK_PROCINST;  
if exists (select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'ACT_RU_TASK') alter table ACT_RU_TASK drop constraint ACT_FK_TASK_PROCDEF;  
if exists (select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'ACT_RU_VARIABLE') alter table ACT_RU_VARIABLE drop constraint ACT_FK_VAR_EXE;  
if exists (select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'ACT_RU_VARIABLE') alter table ACT_RU_VARIABLE drop constraint ACT_FK_VAR_PROCINST;      
if exists (select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'ACT_RU_VARIABLE') alter table ACT_RU_VARIABLE drop constraint ACT_FK_VAR_BYTEARRAY;  
if exists (select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'ACT_RU_JOB') alter table ACT_RU_JOB drop constraint ACT_FK_JOB_EXCEPTION;  
if exists (select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'ACT_RU_EVENT_SUBSCR') alter table ACT_RU_EVENT_SUBSCR drop constraint ACT_FK_EVENT_EXEC;  
if exists (select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'ACT_RE_MODEL') alter table ACT_RE_MODEL drop constraint ACT_FK_MODEL_SOURCE;  
if exists (select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'ACT_RE_MODEL') alter table ACT_RE_MODEL drop constraint ACT_FK_MODEL_SOURCE_EXTRA;  
if exists (select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'ACT_RE_MODEL') alter table ACT_RE_MODEL drop constraint ACT_FK_MODEL_DEPLOYMENT;  
  
IF EXISTS (SELECT name FROM sysindexes WHERE name = 'ACT_IDX_ATHRZ_PROCEDEF') drop index ACT_RU_IDENTITYLINK.ACT_IDX_ATHRZ_PROCEDEF;  
      
if exists (select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'ACT_GE_PROPERTY') drop table ACT_GE_PROPERTY;  
if exists (select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'ACT_GE_BYTEARRAY') drop table ACT_GE_BYTEARRAY;  
if exists (select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'ACT_RE_PROCDEF') drop table ACT_RE_PROCDEF;  
if exists (select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'ACT_RE_DEPLOYMENT') drop table ACT_RE_DEPLOYMENT;  
if exists (select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'ACT_RE_MODEL') drop table ACT_RE_MODEL;  
if exists (select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'ACT_RU_IDENTITYLINK') drop table ACT_RU_IDENTITYLINK;  
if exists (select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'ACT_RU_TASK') drop table ACT_RU_TASK;  
if exists (select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'ACT_RU_VARIABLE') drop table ACT_RU_VARIABLE;  
if exists (select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'ACT_RU_EXECUTION') drop table ACT_RU_EXECUTION;  
if exists (select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'ACT_RU_EVENT_SUBSCR') drop table ACT_RU_EVENT_SUBSCR;  
if exists (select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'ACT_RU_JOB') drop table ACT_RU_JOB;  
  
IF EXISTS (SELECT name FROM sysindexes WHERE name = 'ACT_IDX_HI_PRO_INST_END') drop index ACT_HI_PROCINST.ACT_IDX_HI_PRO_INST_END;  
IF EXISTS (SELECT name FROM sysindexes WHERE name = 'ACT_IDX_HI_PRO_I_BUSKEY') drop index ACT_HI_PROCINST.ACT_IDX_HI_PRO_I_BUSKEY;  
IF EXISTS (SELECT name FROM sysindexes WHERE name = 'ACT_IDX_HI_ACT_INST_START') drop index ACT_HI_ACTINST.ACT_IDX_HI_ACT_INST_START;  
IF EXISTS (SELECT name FROM sysindexes WHERE name = 'ACT_IDX_HI_ACT_INST_END') drop index ACT_HI_ACTINST.ACT_IDX_HI_ACT_INST_END;  
IF EXISTS (SELECT name FROM sysindexes WHERE name = 'ACT_IDX_HI_DETAIL_PROC_INST') drop index ACT_HI_DETAIL.ACT_IDX_HI_DETAIL_PROC_INST;  
IF EXISTS (SELECT name FROM sysindexes WHERE name = 'ACT_IDX_HI_DETAIL_ACT_INST') drop index ACT_HI_DETAIL.ACT_IDX_HI_DETAIL_ACT_INST;  
IF EXISTS (SELECT name FROM sysindexes WHERE name = 'ACT_IDX_HI_DETAIL_TIME') drop index ACT_HI_DETAIL.ACT_IDX_HI_DETAIL_TIME;  
IF EXISTS (SELECT name FROM sysindexes WHERE name = 'ACT_IDX_HI_DETAIL_NAME') drop index ACT_HI_DETAIL.ACT_IDX_HI_DETAIL_NAME;  
IF EXISTS (SELECT name FROM sysindexes WHERE name = 'ACT_IDX_HI_DETAIL_TASK_ID') drop index ACT_HI_DETAIL.ACT_IDX_HI_DETAIL_TASK_ID;  
IF EXISTS (SELECT name FROM sysindexes WHERE name = 'ACT_IDX_HI_PROCVAR_PROC_INST') drop index ACT_HI_VARINST.ACT_IDX_HI_PROCVAR_PROC_INST;  
IF EXISTS (SELECT name FROM sysindexes WHERE name = 'ACT_IDX_HI_PROCVAR_NAME_TYPE') drop index ACT_HI_VARINST.ACT_IDX_HI_PROCVAR_NAME_TYPE;  
IF EXISTS (SELECT name FROM sysindexes WHERE name = 'ACT_IDX_HI_ACT_INST_PROCINST') drop index ACT_HI_ACTINST.ACT_IDX_HI_ACT_INST_PROCINST;  
IF EXISTS (SELECT name FROM sysindexes WHERE name = 'ACT_IDX_HI_IDENT_LNK_USER') drop index ACT_HI_IDENTITYLINK.ACT_IDX_HI_IDENT_LNK_USER;  
IF EXISTS (SELECT name FROM sysindexes WHERE name = 'ACT_IDX_HI_IDENT_LNK_TASK') drop index ACT_HI_IDENTITYLINK.ACT_IDX_HI_IDENT_LNK_TASK;  
IF EXISTS (SELECT name FROM sysindexes WHERE name = 'ACT_IDX_HI_IDENT_LNK_PROCINST') drop index ACT_HI_IDENTITYLINK.ACT_IDX_HI_IDENT_LNK_PROCINST;  
  
if exists (select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'ACT_HI_PROCINST') drop table ACT_HI_PROCINST;  
if exists (select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'ACT_HI_ACTINST') drop table ACT_HI_ACTINST;  
if exists (select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'ACT_HI_VARINST') drop table ACT_HI_VARINST;  
if exists (select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'ACT_HI_TASKINST') drop table ACT_HI_TASKINST;  
if exists (select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'ACT_HI_DETAIL') drop table ACT_HI_DETAIL;  
if exists (select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'ACT_HI_COMMENT') drop table ACT_HI_COMMENT;  
if exists (select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'ACT_HI_ATTACHMENT') drop table ACT_HI_ATTACHMENT;  
if exists (select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'ACT_HI_IDENTITYLINK') drop table ACT_HI_IDENTITYLINK;  
  
if exists (select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'ACT_ID_INFO') drop table ACT_ID_INFO;  
  
  
  
create table ACT_GE_PROPERTY (  
    NAME_ nvarchar(64),  
    VALUE_ nvarchar(300),  
    REV_ int,  
    primary key (NAME_)  
);  
  
insert into ACT_GE_PROPERTY  
values ('schema.version', '5.13', 1);  
  
insert into ACT_GE_PROPERTY  
values ('schema.history', 'create(5.13)', 1);  
  
insert into ACT_GE_PROPERTY  
values ('next.dbid', '1', 1);  
  
create table ACT_GE_BYTEARRAY (  
    ID_ nvarchar(64),  
    REV_ int,  
    NAME_ nvarchar(255),  
    DEPLOYMENT_ID_ nvarchar(64),  
    BYTES_  varbinary(max),  
    GENERATED_ tinyint,  
    primary key (ID_)  
);  
  
create table ACT_RE_DEPLOYMENT (  
    ID_ nvarchar(64),  
    NAME_ nvarchar(255),  
    CATEGORY_ nvarchar(255),  
    DEPLOY_TIME_ datetime,  
    primary key (ID_)  
);  
  
create table ACT_RE_MODEL (  
    ID_ nvarchar(64) not null,  
    REV_ int,  
    NAME_ nvarchar(255),  
    KEY_ nvarchar(255),  
    CATEGORY_ nvarchar(255),  
    CREATE_TIME_ datetime,  
    LAST_UPDATE_TIME_ datetime,  
    VERSION_ int,  
    META_INFO_ nvarchar(4000),  
    DEPLOYMENT_ID_ nvarchar(64),  
    EDITOR_SOURCE_VALUE_ID_ nvarchar(64),  
    EDITOR_SOURCE_EXTRA_VALUE_ID_ nvarchar(64),  
    primary key (ID_)  
);  
  
create table ACT_RU_EXECUTION (  
    ID_ nvarchar(64),  
    REV_ int,  
    PROC_INST_ID_ nvarchar(64),  
    BUSINESS_KEY_ nvarchar(255),  
    PARENT_ID_ nvarchar(64),  
    PROC_DEF_ID_ nvarchar(64),  
    SUPER_EXEC_ nvarchar(64),  
    ACT_ID_ nvarchar(255),  
    IS_ACTIVE_ tinyint,  
    IS_CONCURRENT_ tinyint,  
    IS_SCOPE_ tinyint,  
    IS_EVENT_SCOPE_ tinyint,  
    SUSPENSION_STATE_ tinyint,  
    CACHED_ENT_STATE_ int,  
    primary key (ID_)  
);  
  
create table ACT_RU_JOB (  
    ID_ nvarchar(64) NOT NULL,  
  REV_ int,  
    TYPE_ nvarchar(255) NOT NULL,  
    LOCK_EXP_TIME_ datetime,  
    LOCK_OWNER_ nvarchar(255),  
    EXCLUSIVE_ bit,  
    EXECUTION_ID_ nvarchar(64),  
    PROCESS_INSTANCE_ID_ nvarchar(64),  
    PROC_DEF_ID_ nvarchar(64),  
    RETRIES_ int,  
    EXCEPTION_STACK_ID_ nvarchar(64),  
    EXCEPTION_MSG_ nvarchar(4000),  
    DUEDATE_ datetime NULL,  
    REPEAT_ nvarchar(255),  
    HANDLER_TYPE_ nvarchar(255),  
    HANDLER_CFG_ nvarchar(4000),  
    primary key (ID_)  
);  
  
create table ACT_RE_PROCDEF (  
    ID_ nvarchar(64) not null,  
    REV_ int,  
    CATEGORY_ nvarchar(255),  
    NAME_ nvarchar(255),  
    KEY_ nvarchar(255) not null,  
    VERSION_ int not null,  
    DEPLOYMENT_ID_ nvarchar(64),  
    RESOURCE_NAME_ nvarchar(4000),  
    DGRM_RESOURCE_NAME_ nvarchar(4000),  
    DESCRIPTION_ nvarchar(4000),  
    HAS_START_FORM_KEY_ tinyint,  
    SUSPENSION_STATE_ tinyint,  
    primary key (ID_)  
);  
  
create table ACT_RU_TASK (  
    ID_ nvarchar(64),  
    REV_ int,  
    EXECUTION_ID_ nvarchar(64),  
    PROC_INST_ID_ nvarchar(64),  
    PROC_DEF_ID_ nvarchar(64),  
    NAME_ nvarchar(255),  
    PARENT_TASK_ID_ nvarchar(64),  
    DESCRIPTION_ nvarchar(4000),  
    TASK_DEF_KEY_ nvarchar(255),  
    OWNER_ nvarchar(255),  
    ASSIGNEE_ nvarchar(255),  
    DELEGATION_ nvarchar(64),  
    PRIORITY_ int,  
    CREATE_TIME_ datetime,  
    DUE_DATE_ datetime,  
    SUSPENSION_STATE_ int,  
    primary key (ID_)  
);  
  
create table ACT_RU_IDENTITYLINK (  
    ID_ nvarchar(64),  
    REV_ int,  
    GROUP_ID_ nvarchar(255),  
    TYPE_ nvarchar(255),  
    USER_ID_ nvarchar(255),  
    TASK_ID_ nvarchar(64),  
    PROC_INST_ID_ nvarchar(64),  
    PROC_DEF_ID_ nvarchar(64),  
    primary key (ID_)  
);  
  
create table ACT_RU_VARIABLE (  
    ID_ nvarchar(64) not null,  
    REV_ int,  
    TYPE_ nvarchar(255) not null,  
    NAME_ nvarchar(255) not null,  
    EXECUTION_ID_ nvarchar(64),  
    PROC_INST_ID_ nvarchar(64),  
    TASK_ID_ nvarchar(64),  
    BYTEARRAY_ID_ nvarchar(64),  
    DOUBLE_ double precision,  
    LONG_ numeric(19,0),  
    TEXT_ nvarchar(4000),  
    TEXT2_ nvarchar(4000),  
    primary key (ID_)  
);  
  
create table ACT_RU_EVENT_SUBSCR (  
    ID_ nvarchar(64) not null,  
    REV_ int,  
    EVENT_TYPE_ nvarchar(255) not null,  
    EVENT_NAME_ nvarchar(255),  
    EXECUTION_ID_ nvarchar(64),  
    PROC_INST_ID_ nvarchar(64),  
    ACTIVITY_ID_ nvarchar(64),  
    CONFIGURATION_ nvarchar(255),  
    CREATED_ datetime not null,  
    primary key (ID_)  
);  
  
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 unique index ACT_UNIQ_RU_BUS_KEY on ACT_RU_EXECUTION (PROC_DEF_ID_, BUSINESS_KEY_) ;  
create index ACT_IDX_ATHRZ_PROCEDEF on ACT_RU_IDENTITYLINK(PROC_DEF_ID_);  
create index ACT_IDX_EXECUTION_PROC on ACT_RU_EXECUTION(PROC_DEF_ID_);  
create index ACT_IDX_EXECUTION_PARENT on ACT_RU_EXECUTION(PARENT_ID_);  
create index ACT_IDX_EXECUTION_SUPER on ACT_RU_EXECUTION(SUPER_EXEC_);  
create index ACT_IDX_EXECUTION_IDANDREV on ACT_RU_EXECUTION(ID_, REV_);  
create index ACT_IDX_VARIABLE_BA on ACT_RU_VARIABLE(BYTEARRAY_ID_);  
create index ACT_IDX_VARIABLE_EXEC on ACT_RU_VARIABLE(EXECUTION_ID_);  
create index ACT_IDX_VARIABLE_PROCINST on ACT_RU_VARIABLE(PROC_INST_ID_);  
create index ACT_IDX_IDENT_LNK_TASK on ACT_RU_IDENTITYLINK(TASK_ID_);  
create index ACT_IDX_IDENT_LNK_PROCINST on ACT_RU_IDENTITYLINK(PROC_INST_ID_);  
create index ACT_IDX_IDENT_LNK_PROCDEF on ACT_RU_IDENTITYLINK(PROC_DEF_ID_);  
create index ACT_IDX_TASK_EXEC on ACT_RU_TASK(EXECUTION_ID_);  
create index ACT_IDX_TASK_PROCINST on ACT_RU_TASK(PROC_INST_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_);  
      
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_);      
      
     
---crate history  
create table ACT_HI_PROCINST (  
    ID_ nvarchar(64) not null,  
    PROC_INST_ID_ nvarchar(64) not null,  
    BUSINESS_KEY_ nvarchar(255),  
    PROC_DEF_ID_ nvarchar(64) not null,  
    START_TIME_ datetime not null,  
    END_TIME_ datetime,  
    DURATION_ numeric(19,0),  
    START_USER_ID_ nvarchar(255),  
    START_ACT_ID_ nvarchar(255),  
    END_ACT_ID_ nvarchar(255),  
    SUPER_PROCESS_INSTANCE_ID_ nvarchar(64),  
    DELETE_REASON_ nvarchar(4000),  
    primary key (ID_),  
    unique (PROC_INST_ID_)  
);  
  
create table ACT_HI_ACTINST (  
    ID_ nvarchar(64) not null,  
    PROC_DEF_ID_ nvarchar(64) not null,  
    PROC_INST_ID_ nvarchar(64) not null,  
    EXECUTION_ID_ nvarchar(64) not null,  
    ACT_ID_ nvarchar(255) not null,  
    TASK_ID_ nvarchar(64),  
    CALL_PROC_INST_ID_ nvarchar(64),  
    ACT_NAME_ nvarchar(255),  
    ACT_TYPE_ nvarchar(255) not null,  
    ASSIGNEE_ nvarchar(64),  
    START_TIME_ datetime not null,  
    END_TIME_ datetime,  
    DURATION_ numeric(19,0),  
    primary key (ID_)  
);  
  
create table ACT_HI_TASKINST (  
    ID_ nvarchar(64) not null,  
    PROC_DEF_ID_ nvarchar(64),  
    TASK_DEF_KEY_ nvarchar(255),  
    PROC_INST_ID_ nvarchar(64),  
    EXECUTION_ID_ nvarchar(64),  
    NAME_ nvarchar(255),  
    PARENT_TASK_ID_ nvarchar(64),  
    DESCRIPTION_ nvarchar(4000),  
    OWNER_ nvarchar(255),  
    ASSIGNEE_ nvarchar(255),  
    START_TIME_ datetime not null,  
    CLAIM_TIME_ datetime,  
    END_TIME_ datetime,  
    DURATION_ numeric(19,0),  
    DELETE_REASON_ nvarchar(4000),  
    PRIORITY_ int,  
    DUE_DATE_ datetime,  
    FORM_KEY_ nvarchar(255),  
    primary key (ID_)  
);  
  
create table ACT_HI_VARINST (  
    ID_ nvarchar(64) not null,  
    PROC_INST_ID_ nvarchar(64),  
    EXECUTION_ID_ nvarchar(64),  
    TASK_ID_ nvarchar(64),  
    NAME_ nvarchar(255) not null,  
    VAR_TYPE_ nvarchar(100),  
    REV_ int,  
    BYTEARRAY_ID_ nvarchar(64),  
    DOUBLE_ double precision,  
    LONG_ numeric(19,0),  
    TEXT_ nvarchar(4000),  
    TEXT2_ nvarchar(4000),  
    primary key (ID_)  
);  
  
create table ACT_HI_DETAIL (  
    ID_ nvarchar(64) not null,  
    TYPE_ nvarchar(255) not null,  
    PROC_INST_ID_ nvarchar(64),  
    EXECUTION_ID_ nvarchar(64),  
    TASK_ID_ nvarchar(64),  
    ACT_INST_ID_ nvarchar(64),  
    NAME_ nvarchar(255) not null,  
    VAR_TYPE_ nvarchar(255),  
    REV_ int,  
    TIME_ datetime not null,  
    BYTEARRAY_ID_ nvarchar(64),  
    DOUBLE_ double precision,  
    LONG_ numeric(19,0),  
    TEXT_ nvarchar(4000),  
    TEXT2_ nvarchar(4000),  
    primary key (ID_)  
);  
  
create table ACT_HI_COMMENT (  
    ID_ nvarchar(64) not null,  
    TYPE_ nvarchar(255),  
    TIME_ datetime not null,  
    USER_ID_ nvarchar(255),  
    TASK_ID_ nvarchar(64),  
    PROC_INST_ID_ nvarchar(64),  
    ACTION_ nvarchar(255),  
    MESSAGE_ nvarchar(4000),  
    FULL_MSG_ varbinary(max),  
    primary key (ID_)  
);  
  
create table ACT_HI_ATTACHMENT (  
    ID_ nvarchar(64) not null,  
    REV_ integer,  
    USER_ID_ nvarchar(255),  
    NAME_ nvarchar(255),  
    DESCRIPTION_ nvarchar(4000),  
    TYPE_ nvarchar(255),  
    TASK_ID_ nvarchar(64),  
    PROC_INST_ID_ nvarchar(64),  
    URL_ nvarchar(4000),  
    CONTENT_ID_ nvarchar(64),  
    primary key (ID_)  
);  
  
create table ACT_HI_IDENTITYLINK (  
    ID_ nvarchar(64),  
    GROUP_ID_ nvarchar(255),  
    TYPE_ nvarchar(255),  
    USER_ID_ nvarchar(255),  
    TASK_ID_ nvarchar(64),  
    PROC_INST_ID_ nvarchar(64),  
    primary key (ID_)  
);  
  
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 unique index ACT_UNIQ_HI_BUS_KEY on ACT_HI_PROCINST (PROC_DEF_ID_, BUSINESS_KEY_);  
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_);