topic Diff between 5.11 Create SQLs and 5.8 to 5.11 Upgrade SQLs in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/diff-between-5-11-create-sqls-and-5-8-to-5-11-upgrade-sqls/m-p/122139#M86007 <HTML><HEAD></HEAD><BODY><SPAN>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.</SPAN><BR /><BR /><SPAN>ALTER TABLE ACT_HI_DETAIL MODIFY (ID_ NVARCHAR2(64));</SPAN><BR /><SPAN>ALTER TABLE ACT_HI_TASKINST MODIFY (ASSIGNEE_ NVARCHAR2(255));</SPAN><BR /><SPAN>ALTER TABLE ACT_HI_TASKINST MODIFY (OWNER_ NVARCHAR2(255));</SPAN><BR /><SPAN>ALTER TABLE ACT_RU_IDENTITYLINK MODIFY (GROUP_ID_ NVARCHAR2(255));</SPAN><BR /><SPAN>ALTER TABLE ACT_RU_IDENTITYLINK MODIFY (USER_ID_ NVARCHAR2(255));</SPAN><BR /><SPAN>ALTER TABLE ACT_RU_TASK MODIFY (ASSIGNEE_ NVARCHAR2(255));</SPAN><BR /><SPAN>ALTER TABLE ACT_RU_TASK MODIFY (OWNER_ NVARCHAR2(255));</SPAN><BR /><BR /><SPAN>CREATE INDEX ACT_IDX_EXE_PROCDEF ON ACT_RU_EXECUTION (PROC_DEF_ID_);</SPAN><BR /><BR /><SPAN>Thanks</SPAN><BR /><SPAN>Sudheer</SPAN></BODY></HTML> Fri, 25 Jan 2013 22:38:51 GMT badrisudheer 2013-01-25T22:38:51Z Diff between 5.11 Create SQLs and 5.8 to 5.11 Upgrade SQLs https://connect.hyland.com/t5/alfresco-archive/diff-between-5-11-create-sqls-and-5-8-to-5-11-upgrade-sqls/m-p/122139#M86007 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_ Fri, 25 Jan 2013 22:38:51 GMT https://connect.hyland.com/t5/alfresco-archive/diff-between-5-11-create-sqls-and-5-8-to-5-11-upgrade-sqls/m-p/122139#M86007 badrisudheer 2013-01-25T22:38:51Z Re: Diff between 5.11 Create SQLs and 5.8 to 5.11 Upgrade SQLs https://connect.hyland.com/t5/alfresco-archive/diff-between-5-11-create-sqls-and-5-8-to-5-11-upgrade-sqls/m-p/122140#M86008 <HTML><HEAD></HEAD><BODY><SPAN>Thanks for reporting this. We're aware of this issue and will be addressed soon…</SPAN></BODY></HTML> Mon, 28 Jan 2013 09:27:17 GMT https://connect.hyland.com/t5/alfresco-archive/diff-between-5-11-create-sqls-and-5-8-to-5-11-upgrade-sqls/m-p/122140#M86008 frederikherema1 2013-01-28T09:27:17Z