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

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

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

alter table ACT_HI_TASKINST add LAST_UPDATED_TIME_ datetime2;

alter table ACT_HI_VARINST ADD DEFAULT 1 FOR REV_;
update ACT_HI_VARINST set REV_ = 1 where REV_ is null OR REV_ = 0;

alter table ACT_HI_VARINST alter column LAST_UPDATED_TIME_ datetime2;