| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333 | 
							- 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.22.0.0', 1);
 
- insert into ACT_GE_PROPERTY
 
- values ('schema.history', 'create(5.22.0.0)', 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),
 
-     TENANT_ID_ nvarchar(255) default '',
 
-     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),
 
-     TENANT_ID_ nvarchar(255) default '',
 
-     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,
 
-     TENANT_ID_ nvarchar(255) default '',
 
-     NAME_ nvarchar(255),
 
-     LOCK_TIME_ datetime,
 
-     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),
 
-     TENANT_ID_ nvarchar(255) default '',
 
-     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,
 
-     HAS_GRAPHICAL_NOTATION_ tinyint,
 
-     SUSPENSION_STATE_ tinyint,
 
-     TENANT_ID_ nvarchar(255) default '',
 
-     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,
 
-     CATEGORY_ nvarchar(255),
 
-     SUSPENSION_STATE_ int,
 
-     TENANT_ID_ nvarchar(255) default '',
 
-     FORM_KEY_ nvarchar(255),
 
-     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,
 
-     PROC_DEF_ID_ nvarchar(64),
 
-     TENANT_ID_ nvarchar(255) default '',
 
-     primary key (ID_)
 
- );
 
- create table ACT_EVT_LOG (
 
-     LOG_NR_ numeric(19,0) IDENTITY(1,1),
 
-     TYPE_ nvarchar(64),
 
-     PROC_DEF_ID_ nvarchar(64),
 
-     PROC_INST_ID_ nvarchar(64),
 
-     EXECUTION_ID_ nvarchar(64),
 
-     TASK_ID_ nvarchar(64),
 
-     TIME_STAMP_ datetime not null,
 
-     USER_ID_ nvarchar(255),
 
-     DATA_ varbinary(max),
 
-     LOCK_OWNER_ nvarchar(255),
 
-     LOCK_TIME_ datetime null,
 
-     IS_PROCESSED_ tinyint default 0,
 
-     primary key (LOG_NR_)
 
- );
 
- create table ACT_PROCDEF_INFO (
 
- 	ID_ nvarchar(64) not null,
 
-     PROC_DEF_ID_ nvarchar(64) not null,
 
-     REV_ int,
 
-     INFO_JSON_ID_ nvarchar(64),
 
-     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 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_TASK_EXEC on ACT_RU_TASK(EXECUTION_ID_);
 
- create index ACT_IDX_TASK_PROCINST on ACT_RU_TASK(PROC_INST_ID_);
 
- create index ACT_IDX_EXEC_PROC_INST_ID on ACT_RU_EXECUTION(PROC_INST_ID_);
 
- create index ACT_IDX_TASK_PROC_DEF_ID on ACT_RU_TASK(PROC_DEF_ID_);
 
- create index ACT_IDX_EVENT_SUBSCR_EXEC_ID on ACT_RU_EVENT_SUBSCR(EXECUTION_ID_);
 
- create index ACT_IDX_JOB_EXCEPTION_STACK_ID on ACT_RU_JOB(EXCEPTION_STACK_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_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_);
 
 
  |