• Home
• org.flowable
• flowable-engine
• 6.6.0
• source code
• flowable.mysql55.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.mysql55.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 column REV_ integer default 1;
update ACT_HI_PROCINST set REV_ = 1;

alter table ACT_HI_ACTINST add column REV_ integer default 1;
update ACT_HI_ACTINST set REV_ = 1;

alter table ACT_HI_TASKINST add column REV_ integer default 1;
update ACT_HI_TASKINST set REV_ = 1;

alter table ACT_HI_TASKINST add column LAST_UPDATED_TIME_ datetime;
alter table ACT_HI_VARINST alter column REV_ set default 1;
update ACT_HI_VARINST set REV_ = 1 where REV_ is null OR REV_ = 0;