[Dolibarr-dev] Constraint to remove ?

[Nicolas Dorigny - datætic]

Hello,

I just noticed that in the DB schema, in the llx_socpeople table, there's a constraint on foreign key fk_user_creat but not on fk_user_modif :

CONSTRAINT `fk_socpeople_user_creat_user_rowid` FOREIGN KEY (`fk_user_creat`) REFERENCES `llx_user` (`rowid`)

And there aren't such constraints in llx_projet or llx_societe tables, that also have fk_user_creat and fk_user_modif columns.

Is there a reason ?

If not, this constraint on llx_socpeople/fk_user_creat should be removed.

Regards,

--

Nicolas Dorigny
Consultant - Développeur web freelance
address@hidden | 05 61 87 01 89 | 06 65 68 44 64