• Home
• org.flowable
• flowable-engine
• 6.6.0
• source code
• flowable.oracle.upgradestep.6010.to.6100.history.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.

org.flowable.db.upgrade.flowable.oracle.upgradestep.6010.to.6100.history.sql Maven / Gradle / Ivy

create index ACT_IDX_HI_PROCVAR_EXE on ACT_HI_VARINST(EXECUTION_ID_);

alter table ACT_HI_PROCINST add REV_ INTEGER default 1;
update ACT_HI_PROCINST set REV_ = 1;

alter table ACT_HI_ACTINST add REV_ INTEGER default 1;
update ACT_HI_ACTINST set REV_ = 1;

alter table ACT_HI_TASKINST add REV_ INTEGER default 1;
update ACT_HI_TASKINST set REV_ = 1;

alter table ACT_HI_TASKINST add LAST_UPDATED_TIME_ TIMESTAMP(6);
alter table ACT_HI_VARINST modify REV_ default 1;
update ACT_HI_VARINST set REV_ = 1 where REV_ is null OR REV_ = 0;