You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
63 lines
1.8 KiB
63 lines
1.8 KiB
3 years ago
|
alter table ACT_RU_TASK
|
||
|
|
add CATEGORY_ varchar(255);
|
||
|
|
|
||
|
|
Call Sysproc.admin_cmd ('REORG TABLE ACT_RU_TASK');
|
||
|
|
|
||
|
|
drop index ACT_UNIQ_RU_BUS_KEY;
|
||
|
|
|
||
|
|
-- DB2 *cannot* drop columns. Yes, this is 2013.
|
||
|
|
-- This means that for DB2 the columns will remain as they are (they won't be used)
|
||
|
|
-- alter table ACT_RU_EXECUTION drop colum UNI_BUSINESS_KEY;
|
||
|
|
-- alter table ACT_RU_EXECUTION drop colum UNI_PROC_DEF_ID;
|
||
|
|
|
||
|
|
Call Sysproc.admin_cmd ('REORG TABLE ACT_RU_EXECUTION');
|
||
|
|
|
||
|
|
alter table ACT_RE_DEPLOYMENT
|
||
|
|
add TENANT_ID_ varchar(255) default '';
|
||
|
|
|
||
|
|
Call Sysproc.admin_cmd ('REORG TABLE ACT_RE_DEPLOYMENT');
|
||
|
|
|
||
|
|
alter table ACT_RE_PROCDEF
|
||
|
|
add TENANT_ID_ varchar(255) not null default '';
|
||
|
|
|
||
|
|
Call Sysproc.admin_cmd ('REORG TABLE ACT_RE_PROCDEF');
|
||
|
|
|
||
|
|
alter table ACT_RU_EXECUTION
|
||
|
|
add TENANT_ID_ varchar(255) default '';
|
||
|
|
|
||
|
|
Call Sysproc.admin_cmd ('REORG TABLE ACT_RU_EXECUTION');
|
||
|
|
|
||
|
|
alter table ACT_RU_TASK
|
||
|
|
add TENANT_ID_ varchar(255) default '';
|
||
|
|
|
||
|
|
Call Sysproc.admin_cmd ('REORG TABLE ACT_RU_TASK');
|
||
|
|
|
||
|
|
alter table ACT_RU_JOB
|
||
|
|
add TENANT_ID_ varchar(255) default '';
|
||
|
|
|
||
|
|
Call Sysproc.admin_cmd ('REORG TABLE ACT_RU_JOB');
|
||
|
|
|
||
|
|
alter table ACT_RE_MODEL
|
||
|
|
add TENANT_ID_ varchar(255) default '';
|
||
|
|
|
||
|
|
Call Sysproc.admin_cmd ('REORG TABLE ACT_RE_MODEL');
|
||
|
|
|
||
|
|
alter table ACT_RU_EVENT_SUBSCR
|
||
|
|
add TENANT_ID_ varchar(255) default '';
|
||
|
|
|
||
|
|
alter table ACT_RU_EVENT_SUBSCR
|
||
|
|
add PROC_DEF_ID_ varchar(64);
|
||
|
|
|
||
|
|
Call Sysproc.admin_cmd ('REORG TABLE ACT_RU_EVENT_SUBSCR');
|
||
|
|
|
||
|
|
alter table ACT_RE_PROCDEF
|
||
|
|
drop unique ACT_UNIQ_PROCDEF;
|
||
|
|
|
||
|
|
alter table ACT_RE_PROCDEF
|
||
|
|
add constraint ACT_UNIQ_PROCDEF
|
||
|
|
unique (KEY_,VERSION_, TENANT_ID_);
|
||
|
|
|
||
|
|
Call Sysproc.admin_cmd ('REORG TABLE ACT_RE_PROCDEF');
|
||
|
|
|
||
|
|
update ACT_GE_PROPERTY set VALUE_ = '5.15' where NAME_ = 'schema.version';
|