flowable / flowable/flowable-engine

The database upgrade folder may have some missing SQL scripts

Open
#1,191 5 comments 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
9.5k
Forks
2.9k
Avg merge
7h 8m
Merged PRs (30d)
2

Description

Hi:
I migrated my project from activiti5.20.0 to flowable5.3.1, so I used the upgrade SQL scripts.After I upgraded and compared the tables with the create SQL scripts,some colums and indexs were missing.

I found them in the github flowable reposity,the missing SQL scripts may below(I am using Mysql)

- flowable.mysql.upgradestep.6001.to.6002.history.sql

```
alter table ACT_HI_ACTINST add column DELETE_REASON_ varchar(4000);
```

- flowable.mysql.upgradestep.6004.to.6005.history.sql

```
alter table ACT_HI_IDENTITYLINK add column CREATE_TIME_ datetime(3);
```

- flowable.mysql.upgradestep.6010.to.6100.history.sql

```
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(3);
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;
```

- flowable.mysql.upgradestep.6120.to.6200.history.sql

```
alter table ACT_HI_PROCINST add column CALLBACK_ID_ varchar(255);
alter table ACT_HI_PROCINST add column CALLBACK_TYPE_ varchar(255);
```

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.