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.
38 lines
1.1 KiB
38 lines
1.1 KiB
alter table ACT_HI_TASKINST |
|
add CATEGORY_ varchar(255); |
|
|
|
Call Sysproc.admin_cmd ('REORG TABLE ACT_HI_TASKINST'); |
|
|
|
drop index ACT_UNIQ_HI_BUS_KEY; |
|
|
|
alter table ACT_HI_VARINST |
|
add CREATE_TIME_ timestamp; |
|
|
|
alter table ACT_HI_VARINST |
|
add LAST_UPDATED_TIME_ timestamp; |
|
|
|
-- 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_HI_PROCINST drop colum UNI_BUSINESS_KEY; |
|
-- alter table ACT_HI_PROCINST drop colum UNI_PROC_DEF_ID; |
|
-- Call Sysproc.admin_cmd ('REORG TABLE ACT_HI_PROCINST'); |
|
|
|
|
|
alter table ACT_HI_PROCINST |
|
add TENANT_ID_ varchar(255) default ''; |
|
|
|
Call Sysproc.admin_cmd ('REORG TABLE ACT_HI_PROCINST'); |
|
|
|
alter table ACT_HI_ACTINST |
|
add TENANT_ID_ varchar(255) default ''; |
|
|
|
Call Sysproc.admin_cmd ('REORG TABLE ACT_HI_ACTINST'); |
|
|
|
alter table ACT_HI_TASKINST |
|
add TENANT_ID_ varchar(255) default ''; |
|
|
|
Call Sysproc.admin_cmd ('REORG TABLE ACT_HI_TASKINST'); |
|
|
|
alter table ACT_HI_ACTINST alter column ASSIGNEE_ SET DATA TYPE varchar(255); |
|
|
|
Call Sysproc.admin_cmd ('REORG TABLE ACT_HI_ACTINST'); |