I have come across the following differences when I tried to run 5.11 Create scripts and 5.8 to 5.11 Upgrade scripts provided in Activiti 5.11 zip/jar. So, looks like the following might be included in Update scripts. These may be trivial but, thought of sharing.
ALTER TABLE ACT_HI_DETAIL MODIFY (ID_ NVARCHAR2(64));
ALTER TABLE ACT_HI_TASKINST MODIFY (ASSIGNEE_ NVARCHAR2(255));
ALTER TABLE ACT_HI_TASKINST MODIFY (OWNER_ NVARCHAR2(255));
ALTER TABLE ACT_RU_IDENTITYLINK MODIFY (GROUP_ID_ NVARCHAR2(255));
ALTER TABLE ACT_RU_IDENTITYLINK MODIFY (USER_ID_ NVARCHAR2(255));
ALTER TABLE ACT_RU_TASK MODIFY (ASSIGNEE_ NVARCHAR2(255));
ALTER TABLE ACT_RU_TASK MODIFY (OWNER_ NVARCHAR2(255));
CREATE INDEX ACT_IDX_EXE_PROCDEF ON ACT_RU_EXECUTION (PROC_DEF_ID_);
Thanks
Sudheer
