topic Re: tables renaming in Alfresco Archive

tables renaming

tombaeyens — Thu, 19 Aug 2010 09:43:51 GMT

In order to better indicate which category the different tables are in, I propose following table renames:ACT_ID_GROUP –> ACT_ID_GROUPACT_ID_MEMBERSHIP –> ACT_ID_MEMBERSHIPACT_ID_USER –> ACT_ID_USERACT_H_PROCINST –> ACT_HS_PROC_INSTACT_H_ACTINST –>

Re: tables renaming

jbarrez — Thu, 19 Aug 2010 10:11:58 GMT

I agree, now is the time to get the table names consistent.

How will we cope with the alpha4->beta1 migration? None ? Or create a small DDL with the changes ?
Imo, since it is an alpha4, we should not invest time in it.

Re: tables renaming

tombaeyens — Fri, 20 Aug 2010 15:39:53 GMT

i agree. no compatibility is guaranteed until GA.

Re: tables renaming

falko_menge — Sun, 22 Aug 2010 09:26:46 GMT

Why do all field names have an underscore at the end?

Re: tables renaming

tombaeyens — Mon, 23 Aug 2010 06:56:24 GMT

Why do all field names have an underscore at the end?

That's to prevent name clashes with DB reserved words. (E.g. Some db has 'start' as a reserved word) Every DB has a different set of reserved words. Instead of fixing such a problem each time, we decided (long time ago at jbpm) to always postfix it with underscore. Since then we don't have the nameclash problem any more.