flowable / flowable/flowable-engine
The database upgrade folder may have some missing SQL scripts
- 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.