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.
58 lines
1.2 KiB
58 lines
1.2 KiB
alter table ACT_RU_EXECUTION |
|
add SUSPENSION_STATE_ integer; |
|
|
|
alter table ACT_RE_PROCDEF |
|
add SUSPENSION_STATE_ integer; |
|
|
|
alter table ACT_RE_PROCDEF |
|
add REV_ integer; |
|
|
|
update ACT_RE_PROCDEF set REV_ = 1; |
|
update ACT_RE_PROCDEF set SUSPENSION_STATE_ = 1; |
|
update ACT_RU_EXECUTION set SUSPENSION_STATE_ = 1; |
|
|
|
|
|
|
|
|
|
|
|
create table ACT_RU_EVENT_SUBSCR ( |
|
ID_ varchar(64) not null, |
|
REV_ integer, |
|
EVENT_TYPE_ varchar(255) not null, |
|
EVENT_NAME_ varchar(255), |
|
EXECUTION_ID_ varchar(64), |
|
PROC_INST_ID_ varchar(64), |
|
ACTIVITY_ID_ varchar(64), |
|
CONFIGURATION_ varchar(255), |
|
CREATED_ timestamp not null DEFAULT CURRENT_TIMESTAMP, |
|
primary key (ID_) |
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin; |
|
create index ACT_IDX_EVENT_SUBSCR_CONFIG_ on ACT_RU_EVENT_SUBSCR(CONFIGURATION_); |
|
|
|
alter table ACT_RU_EVENT_SUBSCR |
|
add constraint ACT_FK_EVENT_EXEC |
|
foreign key (EXECUTION_ID_) |
|
references ACT_RU_EXECUTION(ID_); |
|
|
|
|
|
|
|
|
|
|
|
alter table ACT_RU_EXECUTION |
|
add IS_EVENT_SCOPE_ TINYINT; |
|
|
|
update ACT_RU_EXECUTION set IS_EVENT_SCOPE_ = 0; |
|
|
|
|
|
|
|
|
|
alter table ACT_HI_PROCINST |
|
add DELETE_REASON_ varchar(4000); |
|
|
|
|
|
|
|
|
|
alter table ACT_GE_BYTEARRAY |
|
add GENERATED_ TINYINT; |
|
|
|
update ACT_GE_BYTEARRAY set GENERATED_ = 0; |