• Home
• org.ow2.bonita
• bonita-server
• 5.9.1
• source code
• h2-post-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-post-5.8-5.9.sql Maven / Gradle / Ivy

create index IDX_LOCK_ on BN_OEI_ (OVERDUE, LOCKED);
create index IDX_OEI on BN_OEI_ (NAME, PROC_NAME, ACT_NAME, LOCKED);
alter table BN_OEI_ drop column LOCK_OWNER;
alter table BN_OEI_ drop column CONSUMED;

create index IDX_IEI on BN_IEI_ (NAME, PROC_NAME, ACT_NAME, ENABLE_TIME_, LOCKED);
alter table BN_IEI_ drop column LOCK_OWNER;
alter table BN_IEI_ drop column RETRIES_;
alter table BN_IEI_ drop column CONSUMED;

alter table BN_INST_ACTUSERS drop constraint FK_INST_ACTUSERS;
alter table BN_INST_ACTUSERS drop PRIMARY KEY;
alter table BN_INST_ACTUSERS drop COLUMN INDEX_;
alter table BN_INST_ACTUSERS add constraint FK_INST_ACTUSERS foreign key (INSTANCE_DBID_) references BN_PROC_INST;