org.activiti.db.upgrade.activiti.mysql.upgradestep.510.to.511.engine.sql Maven / Gradle / Ivy
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-1424
alter 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';