Re: [Dolibarr-dev] Constraint to remove ?

[Laurent Destailleur (aka Eldy)]

If field are "NULL" possible field, then we can add a constraint. 

The only reason why it is not is that developers forgot it. :-)

Any PR to this is welcome.

2016-09-08 18:27 GMT+02:00 Nicolas Dorigny - datætic <address@hidden>:

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

 

_______________________________________________
Dolibarr-dev mailing list
address@hidden
https://lists.nongnu.org/mailman/listinfo/dolibarr-dev

--

EMail: address@hidden

Web: http://www.destailleur.fr

------------------------------------------------------------------------------------

Google+: https://plus.google.com/+LaurentDestailleur-Open-Source-Expert/
Facebook: https://www.facebook.com/Destailleur.Laurent

Twitter: http://www.twitter.com/eldy10

------------------------------------------------------------------------------------

* Dolibarr (Project leader): http://www.dolibarr.org (make a donation for Dolibarr project via Paypal: address@hidden)

* AWStats (Author) : http://awstats.sourceforge.net (make a donation for AWStats project via Paypal: address@hidden)

* AWBot (Author) : http://awbot.sourceforge.net

* CVSChangeLogBuilder (Author) : http://cvschangelogb.sourceforge.net