topic Re: Question on ACT_RU_IDENTITYLINK for DBA adding constraints and indexes in Alfresco Archive

Question on ACT_RU_IDENTITYLINK for DBA adding constraints and indexes

jwestra — Mon, 21 Mar 2016 16:50:07 GMT

Hi!My DBA is adding more constraints and indexes to the standard postgresql scripts.Is it valid to say, ACT_RU_IDENTITYLINK rows will have "either" a user_id or a group_id, but never both?Here is an example, our DBA wants to add:===============================alter table act_ru_identitylink add cons

Re: Question on ACT_RU_IDENTITYLINK for DBA adding constraints and indexes

jwestra — Wed, 23 Mar 2016 23:48:00 GMT

BUMP

Re: Question on ACT_RU_IDENTITYLINK for DBA adding constraints and indexes

jbarrez — Fri, 25 Mar 2016 15:07:56 GMT

1) Is it valid to say, ACT_RU_IDENTITYLINK rows will have "either" a user_id or a group_id, but never both?

Yes, for the default out of the box logic that is the case indeed. Custom logic could do that, though.

2) Again, same story. Out of the box, not. But there are use cases where people update the identity links dynamically and then this rev column is important for detecting concurrent changes.