| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263 | alter table ACT_RE_PROCDEF     MODIFY KEY_ varchar(255) not null;alter table ACT_RE_PROCDEF     MODIFY VERSION_ integer not null;    -- https://activiti.atlassian.net/browse/ACT-1424alter table ACT_RU_JOB     MODIFY LOCK_EXP_TIME_ timestamp null;    alter table ACT_RE_DEPLOYMENT     add CATEGORY_ varchar(255);    alter table ACT_RE_PROCDEF    add DESCRIPTION_ varchar(4000);    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_ varchar(64) not null,    REV_ integer,    NAME_ varchar(255),    KEY_ varchar(255),    CATEGORY_ varchar(255),    CREATE_TIME_ timestamp null,    LAST_UPDATE_TIME_ timestamp null,    VERSION_ integer,    META_INFO_ varchar(4000),    DEPLOYMENT_ID_ varchar(64),    EDITOR_SOURCE_VALUE_ID_ varchar(64),    EDITOR_SOURCE_EXTRA_VALUE_ID_ varchar(64),    primary key (ID_)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;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_);   delete from ACT_GE_PROPERTY where NAME_ = 'historyLevel';alter table ACT_RU_JOB    add PROC_DEF_ID_ varchar(64);update ACT_GE_PROPERTY set VALUE_ = '5.11' where NAME_ = 'schema.version';
 |