• Home
• org.ow2.bonita
• bonita-server
• 5.9.1
• source code
• h2-pre-5.8-5.9.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

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

alter table BN_OE_DEF add COR_KEY_NAME1_ varchar(50);
alter table BN_OE_DEF add COR_KEY_EXPR1_ longvarchar;
alter table BN_OE_DEF add COR_KEY_NAME2_ varchar(50);
alter table BN_OE_DEF add COR_KEY_EXPR2_ longvarchar;
alter table BN_OE_DEF add COR_KEY_NAME3_ varchar(50);
alter table BN_OE_DEF add COR_KEY_EXPR3_ longvarchar;
alter table BN_OE_DEF add COR_KEY_NAME4_ varchar(50);
alter table BN_OE_DEF add COR_KEY_EXPR4_ longvarchar;
alter table BN_OE_DEF add COR_KEY_NAME5_ varchar(50);
alter table BN_OE_DEF add COR_KEY_EXPR5_ longvarchar;

alter table BN_IE_DEF add COR_KEY_NAME1_ varchar(50);
alter table BN_IE_DEF add COR_KEY_EXPR1_ longvarchar;
alter table BN_IE_DEF add COR_KEY_NAME2_ varchar(50);
alter table BN_IE_DEF add COR_KEY_EXPR2_ longvarchar;
alter table BN_IE_DEF add COR_KEY_NAME3_ varchar(50);
alter table BN_IE_DEF add COR_KEY_EXPR3_ longvarchar;
alter table BN_IE_DEF add COR_KEY_NAME4_ varchar(50);
alter table BN_IE_DEF add COR_KEY_EXPR4_ longvarchar;
alter table BN_IE_DEF add COR_KEY_NAME5_ varchar(50);
alter table BN_IE_DEF add COR_KEY_EXPR5_ longvarchar;

alter table BN_EVENTS add COR_KEY_NAME1_ varchar(50);
alter table BN_EVENTS add COR_KEY_EXPR1_ longvarchar;
alter table BN_EVENTS add COR_KEY_NAME2_ varchar(50);
alter table BN_EVENTS add COR_KEY_EXPR2_ longvarchar;
alter table BN_EVENTS add COR_KEY_NAME3_ varchar(50);
alter table BN_EVENTS add COR_KEY_EXPR3_ longvarchar;
alter table BN_EVENTS add COR_KEY_NAME4_ varchar(50);
alter table BN_EVENTS add COR_KEY_EXPR4_ longvarchar;
alter table BN_EVENTS add COR_KEY_NAME5_ varchar(50);
alter table BN_EVENTS add COR_KEY_EXPR5_ longvarchar;

alter table BN_OEI_ add COR_KEY1_ varchar(55);
alter table BN_OEI_ add COR_KEY2_ varchar(55);
alter table BN_OEI_ add COR_KEY3_ varchar(55);
alter table BN_OEI_ add COR_KEY4_ varchar(55);
alter table BN_OEI_ add COR_KEY5_ varchar(55);
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_ varchar(55);
alter table BN_IEI_ add COR_KEY2_ varchar(55);
alter table BN_IEI_ add COR_KEY3_ varchar(55);
alter table BN_IEI_ add COR_KEY4_ varchar(55);
alter table BN_IEI_ add COR_KEY5_ varchar(55);
create index IDX_IEI_COR_KEY_ on BN_IEI_ (COR_KEY1_, COR_KEY2_, COR_KEY3_, COR_KEY4_, COR_KEY5_);

create table BN_JOB (
  DBID_ bigint generated by default as identity,
  EVENT_NAME_ varchar(255) not null,
  EVENT_POSITION_ varchar(15) not null,
  EVENT_TYPE_ varchar(15) not null,
  ROOT_INST_UUID_ varchar(255),
  SUB_PRO_UUID_ varchar(255),
  EXEC_UUID_ varchar(255),
  ACT_DEF_UUID_ varchar(255),
  OE_ID_ bigint,
  EXPR_ longvarchar,
  FIRE_TIME_ bigint not null,
  RETRIES_ integer not null,
  EXCEPTION_ longvarchar,
  LOCK_ boolean not null,
  INST_UUID_ varchar(255),
  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_ bigint generated by default as identity,
  PRI_UUID_ varchar(255) unique,
  primary key (DBID_)
);
create index IDX_JL_PRI_UUID_ on BN_JOB_LOCK (PRI_UUID_);