migration.oracle-pre-5.8-5.9.sql Maven / Gradle / Ivy

Go to download
alter table BN_OE_DEF add COR_KEY_NAME1_ varchar2(50 char);
alter table BN_OE_DEF add COR_KEY_EXPR1_ CLOB;
alter table BN_OE_DEF add COR_KEY_NAME2_ varchar2(50 char);
alter table BN_OE_DEF add COR_KEY_EXPR2_ CLOB;
alter table BN_OE_DEF add COR_KEY_NAME3_ varchar2(50 char);
alter table BN_OE_DEF add COR_KEY_EXPR3_ CLOB;
alter table BN_OE_DEF add COR_KEY_NAME4_ varchar2(50 char);
alter table BN_OE_DEF add COR_KEY_EXPR4_ CLOB;
alter table BN_OE_DEF add COR_KEY_NAME5_ varchar2(50 char);
alter table BN_OE_DEF add COR_KEY_EXPR5_ CLOB;

alter table BN_IE_DEF add COR_KEY_NAME1_ varchar2(50 char);
alter table BN_IE_DEF add COR_KEY_EXPR1_ CLOB;
alter table BN_IE_DEF add COR_KEY_NAME2_ varchar2(50 char);
alter table BN_IE_DEF add COR_KEY_EXPR2_ CLOB;
alter table BN_IE_DEF add COR_KEY_NAME3_ varchar2(50 char);
alter table BN_IE_DEF add COR_KEY_EXPR3_ CLOB;
alter table BN_IE_DEF add COR_KEY_NAME4_ varchar2(50 char);
alter table BN_IE_DEF add COR_KEY_EXPR4_ CLOB;
alter table BN_IE_DEF add COR_KEY_NAME5_ varchar2(50 char);
alter table BN_IE_DEF add COR_KEY_EXPR5_ CLOB;

alter table BN_EVENTS add COR_KEY_NAME1_ varchar2(50 char);
alter table BN_EVENTS add COR_KEY_EXPR1_ CLOB;
alter table BN_EVENTS add COR_KEY_NAME2_ varchar2(50 char);
alter table BN_EVENTS add COR_KEY_EXPR2_ CLOB;
alter table BN_EVENTS add COR_KEY_NAME3_ varchar2(50 char);
alter table BN_EVENTS add COR_KEY_EXPR3_ CLOB;
alter table BN_EVENTS add COR_KEY_NAME4_ varchar2(50 char);
alter table BN_EVENTS add COR_KEY_EXPR4_ CLOB;
alter table BN_EVENTS add COR_KEY_NAME5_ varchar2(50 char);
alter table BN_EVENTS add COR_KEY_EXPR5_ CLOB;

alter table BN_OEI_ add COR_KEY1_ varchar2(55 char);
alter table BN_OEI_ add COR_KEY2_ varchar2(55 char);
alter table BN_OEI_ add COR_KEY3_ varchar2(55 char);
alter table BN_OEI_ add COR_KEY4_ varchar2(55 char);
alter table BN_OEI_ add COR_KEY5_ varchar2(55 char);
create index IDX_OEI_COR_KEY_ on BN_OEI_ (COR_KEY1_, COR_KEY2_, COR_KEY3_, COR_KEY4_, COR_KEY5_);

alter table BN_IEI_ add COR_KEY1_ varchar2(55 char);
alter table BN_IEI_ add COR_KEY2_ varchar2(55 char);
alter table BN_IEI_ add COR_KEY3_ varchar2(55 char);
alter table BN_IEI_ add COR_KEY4_ varchar2(55 char);
alter table BN_IEI_ add COR_KEY5_ varchar2(55 char);
create index IDX_IEI_COR_KEY_ on BN_IEI_ (COR_KEY1_, COR_KEY2_, COR_KEY3_, COR_KEY4_, COR_KEY5_);

create table BN_JOB (
  DBID_ number(19,0) not null,
  EVENT_NAME_ varchar2(255 char) not null,
  EVENT_POSITION_ varchar2(15 char) not null,
  EVENT_TYPE_ varchar2(15 char) not null,
  ROOT_INST_UUID_ varchar2(255 char),
  SUB_PRO_UUID_ varchar2(255 char),
  EXEC_UUID_ varchar2(255 char),
  ACT_DEF_UUID_ varchar2(255 char),
  OE_ID_ number(19,0),
  EXPR_ CLOB,
  FIRE_TIME_ number(19,0) not null,
  RETRIES_ number(10,0) not null,
  EXCEPTION_ CLOB,
  LOCK_ number(1,0) not null,
  INST_UUID_ varchar2(255 char),
  primary key (DBID_)
);
create index IDX_EXEC_ID_ on BN_JOB (EXEC_UUID_);
create index IDX_JB_ACT_UUID_ on BN_JOB (ACT_DEF_UUID_);
create index IDX_JB_EVT_TYP_ on BN_JOB (EVENT_TYPE_);
create index IDX_JB_INST_UUID_ on BN_JOB (INST_UUID_);
create index IDX_JB_LK_ on BN_JOB (RETRIES_, LOCK_);
alter table BN_JOB add constraint FK_OE_ foreign key (OE_ID_) references BN_OEI_;

create table BN_JOB_LOCK (
  DBID_ number(19,0) not null,
  PRI_UUID_ varchar2(255 char) unique,
  primary key (DBID_)
);
create index IDX_JL_PRI_UUID_ on BN_JOB_LOCK (PRI_UUID_);