| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162 |
- alter table ACT_RE_PROCDEF
- modify KEY_ not null;
- alter table ACT_RE_PROCDEF
- modify VERSION_ not null;
-
- alter table ACT_RE_DEPLOYMENT
- add CATEGORY_ NVARCHAR2(255);
-
- alter table ACT_RE_PROCDEF
- add DESCRIPTION_ NVARCHAR2(2000);
-
- alter table ACT_RU_TASK
- add SUSPENSION_STATE_ INTEGER;
-
- update ACT_RU_TASK set SUSPENSION_STATE_ = 1;
- alter table ACT_RU_EXECUTION
- add constraint ACT_FK_EXE_PROCDEF
- foreign key (PROC_DEF_ID_)
- references ACT_RE_PROCDEF (ID_);
- create table ACT_RE_MODEL (
- ID_ NVARCHAR2(64) not null,
- REV_ INTEGER,
- NAME_ NVARCHAR2(255),
- KEY_ NVARCHAR2(255),
- CATEGORY_ NVARCHAR2(255),
- CREATE_TIME_ TIMESTAMP(6),
- LAST_UPDATE_TIME_ TIMESTAMP(6),
- VERSION_ INTEGER,
- META_INFO_ NVARCHAR2(2000),
- DEPLOYMENT_ID_ NVARCHAR2(64),
- EDITOR_SOURCE_VALUE_ID_ NVARCHAR2(64),
- EDITOR_SOURCE_EXTRA_VALUE_ID_ NVARCHAR2(64),
- primary key (ID_)
- );
- create index ACT_IDX_MODEL_SOURCE on ACT_RE_MODEL(EDITOR_SOURCE_VALUE_ID_);
- alter table ACT_RE_MODEL
- add constraint ACT_FK_MODEL_SOURCE
- foreign key (EDITOR_SOURCE_VALUE_ID_)
- references ACT_GE_BYTEARRAY (ID_);
- create index ACT_IDX_MODEL_SOURCE_EXTRA on ACT_RE_MODEL(EDITOR_SOURCE_EXTRA_VALUE_ID_);
- alter table ACT_RE_MODEL
- add constraint ACT_FK_MODEL_SOURCE_EXTRA
- foreign key (EDITOR_SOURCE_EXTRA_VALUE_ID_)
- references ACT_GE_BYTEARRAY (ID_);
-
- create index ACT_IDX_MODEL_DEPLOYMENT on ACT_RE_MODEL(DEPLOYMENT_ID_);
- alter table ACT_RE_MODEL
- add constraint ACT_FK_MODEL_DEPLOYMENT
- foreign key (DEPLOYMENT_ID_)
- references ACT_RE_DEPLOYMENT (ID_);
- delete from ACT_GE_PROPERTY where NAME_ = 'historyLevel';
- alter table ACT_RU_JOB
- add PROC_DEF_ID_ NVARCHAR2(64);
- update ACT_GE_PROPERTY set VALUE_ = '5.11' where NAME_ = 'schema.version';
|
