| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162 | alter table ACT_RE_PROCDEF    modify KEY_ not null;alter table ACT_RE_PROCDEF    modify VERSION_ not null;    alter table ACT_RE_DEPLOYMENT     add CATEGORY_ NVARCHAR2(255);    alter table ACT_RE_PROCDEF    add DESCRIPTION_ NVARCHAR2(2000);    alter table ACT_RU_TASK    add SUSPENSION_STATE_ INTEGER;    update ACT_RU_TASK set SUSPENSION_STATE_ = 1; alter table ACT_RU_EXECUTION    add constraint ACT_FK_EXE_PROCDEF     foreign key (PROC_DEF_ID_)     references ACT_RE_PROCDEF (ID_);    create table ACT_RE_MODEL (    ID_ NVARCHAR2(64) not null,    REV_ INTEGER,    NAME_ NVARCHAR2(255),    KEY_ NVARCHAR2(255),    CATEGORY_ NVARCHAR2(255),    CREATE_TIME_ TIMESTAMP(6),    LAST_UPDATE_TIME_ TIMESTAMP(6),    VERSION_ INTEGER,    META_INFO_ NVARCHAR2(2000),    DEPLOYMENT_ID_ NVARCHAR2(64),    EDITOR_SOURCE_VALUE_ID_ NVARCHAR2(64),    EDITOR_SOURCE_EXTRA_VALUE_ID_ NVARCHAR2(64),    primary key (ID_));create index ACT_IDX_MODEL_SOURCE on ACT_RE_MODEL(EDITOR_SOURCE_VALUE_ID_);alter table ACT_RE_MODEL     add constraint ACT_FK_MODEL_SOURCE     foreign key (EDITOR_SOURCE_VALUE_ID_)     references ACT_GE_BYTEARRAY (ID_);create index ACT_IDX_MODEL_SOURCE_EXTRA on ACT_RE_MODEL(EDITOR_SOURCE_EXTRA_VALUE_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_);    create index ACT_IDX_MODEL_DEPLOYMENT on ACT_RE_MODEL(DEPLOYMENT_ID_);    alter table ACT_RE_MODEL     add constraint ACT_FK_MODEL_DEPLOYMENT     foreign key (DEPLOYMENT_ID_)     references ACT_RE_DEPLOYMENT (ID_);        delete from ACT_GE_PROPERTY where NAME_ = 'historyLevel';alter table ACT_RU_JOB    add PROC_DEF_ID_ NVARCHAR2(64);update ACT_GE_PROPERTY set VALUE_ = '5.11' where NAME_ = 'schema.version';
 |