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.
26 lines
711 B
26 lines
711 B
3 years ago
|
update ACT_GE_PROPERTY set VALUE_ = '5.18.0.1' where NAME_ = 'schema.version';
|
||
|
|
|
||
|
|
create table ACT_PROCDEF_INFO (
|
||
|
|
ID_ varchar(64) not null,
|
||
|
|
PROC_DEF_ID_ varchar(64) not null,
|
||
|
|
REV_ integer,
|
||
|
|
INFO_JSON_ID_ varchar(64),
|
||
|
|
primary key (ID_)
|
||
|
|
);
|
||
|
|
|
||
|
|
create index ACT_IDX_INFO_PROCDEF on ACT_PROCDEF_INFO(PROC_DEF_ID_);
|
||
|
|
|
||
|
|
alter table ACT_PROCDEF_INFO
|
||
|
|
add constraint ACT_FK_INFO_JSON_BA
|
||
|
|
foreign key (INFO_JSON_ID_)
|
||
|
|
references ACT_GE_BYTEARRAY (ID_);
|
||
|
|
|
||
|
|
alter table ACT_PROCDEF_INFO
|
||
|
|
add constraint ACT_FK_INFO_PROCDEF
|
||
|
|
foreign key (PROC_DEF_ID_)
|
||
|
|
references ACT_RE_PROCDEF (ID_);
|
||
|
|
|
||
|
|
alter table ACT_PROCDEF_INFO
|
||
|
|
add constraint ACT_UNIQ_INFO_PROCDEF
|
||
|
|
unique (PROC_DEF_ID_);
|
||
|
|
|