topic tables renaming in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/tables-renaming/m-p/5643#M1012 <HTML><HEAD></HEAD><BODY><SPAN>In order to better indicate which category the different tables are in, I propose following table renames:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>ACT_ID_GROUP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; –&gt; ACT_ID_GROUP<BR />ACT_ID_MEMBERSHIP&nbsp;&nbsp;&nbsp;&nbsp; –&gt; ACT_ID_MEMBERSHIP<BR />ACT_ID_USER&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; –&gt; ACT_ID_USER<BR />ACT_H_PROCINST&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; –&gt; ACT_HS_PROC_INST<BR />ACT_H_ACTINST&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; –&gt; ACT_HS_ACT_INST<BR />ACT_PROPERTY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; –&gt; ACT_MG_PROPERTY<BR />ACT_DEPLOYMENT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; –&gt; ACT_RP_DEPLOYMENT<BR />ACT_PROCESSDEFINITION –&gt; ACT_RP_PROC_DEF<BR />ACT_BYTEARRAY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; –&gt; ACT_RT_BYTEARRAY<BR />ACT_EXECUTION&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; –&gt; ACT_RT_EXECUTION<BR />ACT_JOB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; –&gt; ACT_RT_JOB<BR />ACT_TASK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; –&gt; ACT_RT_TASK<BR />ACT_TASKINVOLVEMENT&nbsp;&nbsp; –&gt; ACT_RT_TASK_IVMNT<BR />ACT_VARIABLE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; –&gt; ACT_RT_VARIABLE<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>ACT_ID_XXX –&gt; tables for the identity component</SPAN><BR /><SPAN>ACT_HS_XXX –&gt; tables for the history component</SPAN><BR /><SPAN>ACT_MG_XXX –&gt; tables for the management component&nbsp; (i'm unsure about this one, but couldn't find a better name)</SPAN><BR /><SPAN>ACT_RP_XXX –&gt; tables containing the static repository data</SPAN><BR /><SPAN>ACT_RT_XXX –&gt; tables containing the dynamic runtime data</SPAN><BR /><BR /><SPAN>any objections or thoughts?</SPAN></BODY></HTML> Thu, 19 Aug 2010 09:43:51 GMT tombaeyens 2010-08-19T09:43:51Z tables renaming https://connect.hyland.com/t5/alfresco-archive/tables-renaming/m-p/5643#M1012 In order to better indicate which category the different tables are in, I propose following table renames:ACT_ID_GROUP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; –&gt; ACT_ID_GROUPACT_ID_MEMBERSHIP&nbsp;&nbsp;&nbsp;&nbsp; –&gt; ACT_ID_MEMBERSHIPACT_ID_USER&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; –&gt; ACT_ID_USERACT_H_PROCINST&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; –&gt; ACT_HS_PROC_INSTACT_H_ACTINST&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; –&gt; Thu, 19 Aug 2010 09:43:51 GMT https://connect.hyland.com/t5/alfresco-archive/tables-renaming/m-p/5643#M1012 tombaeyens 2010-08-19T09:43:51Z Re: tables renaming https://connect.hyland.com/t5/alfresco-archive/tables-renaming/m-p/5644#M1013 <HTML><HEAD></HEAD><BODY><SPAN>I agree, now is the time to get the table names consistent.</SPAN><BR /><BR /><SPAN>How will we cope with the alpha4-&gt;beta1 migration? None ? Or create a small DDL with the changes ? </SPAN><BR /><SPAN>Imo, since it is an alpha4, we should not invest time in it.</SPAN></BODY></HTML> Thu, 19 Aug 2010 10:11:58 GMT https://connect.hyland.com/t5/alfresco-archive/tables-renaming/m-p/5644#M1013 jbarrez 2010-08-19T10:11:58Z Re: tables renaming https://connect.hyland.com/t5/alfresco-archive/tables-renaming/m-p/5645#M1014 <HTML><HEAD></HEAD><BODY><SPAN>i agree.&nbsp; no compatibility is guaranteed until GA.</SPAN></BODY></HTML> Fri, 20 Aug 2010 15:39:53 GMT https://connect.hyland.com/t5/alfresco-archive/tables-renaming/m-p/5645#M1014 tombaeyens 2010-08-20T15:39:53Z Re: tables renaming https://connect.hyland.com/t5/alfresco-archive/tables-renaming/m-p/5646#M1015 <HTML><HEAD></HEAD><BODY><SPAN>Why do all field names have an underscore at the end?</SPAN></BODY></HTML> Sun, 22 Aug 2010 09:26:46 GMT https://connect.hyland.com/t5/alfresco-archive/tables-renaming/m-p/5646#M1015 falko_menge 2010-08-22T09:26:46Z Re: tables renaming https://connect.hyland.com/t5/alfresco-archive/tables-renaming/m-p/5647#M1016 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">Why do all field names have an underscore at the end?</BLOCKQUOTE><BR /><SPAN>That's to prevent name clashes with DB reserved words.&nbsp; (E.g. Some db has 'start' as a reserved word) Every DB has a different set of reserved words.&nbsp; Instead of fixing such a problem each time, we decided (long time ago at jbpm) to always postfix it with underscore.&nbsp; Since then we don't have the nameclash problem any more.</SPAN></BODY></HTML> Mon, 23 Aug 2010 06:56:24 GMT https://connect.hyland.com/t5/alfresco-archive/tables-renaming/m-p/5647#M1016 tombaeyens 2010-08-23T06:56:24Z