| 1234567891011121314151617181920212223242526 |
- 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_)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
- 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_);
-
|
