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 <n...@dataetic.fr>: > 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, > -- > [image: dataetic] > > *Nicolas Dorigny* > Consultant - Développeur web freelance > n...@dataetic.fr | 05 61 87 01 89 <0561870189> | 06 65 68 44 64 <0665684464> > > > > _______________________________________________ > Dolibarr-dev mailing list > Dolibarr-dev@nongnu.org > https://lists.nongnu.org/mailman/listinfo/dolibarr-dev > > -- EMail: e...@destailleur.fr 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: cont...@destailleur.fr) * AWStats (Author) : http://awstats.sourceforge.net (make a donation for AWStats project via Paypal: cont...@destailleur.fr) * AWBot (Author) : http://awbot.sourceforge.net * CVSChangeLogBuilder (Author) : http://cvschangelogb.sourceforge.net
_______________________________________________ Dolibarr-dev mailing list Dolibarr-dev@nongnu.org https://lists.nongnu.org/mailman/listinfo/dolibarr-dev
