AnsweredAssumed Answered

Diff between 5.11 Create SQLs and 5.8 to 5.11 Upgrade SQLs

Question asked by badrisudheer on Jan 25, 2013
Latest reply on Jan 28, 2013 by frederikheremans1
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

Outcomes