We can set a FK constraint while allowing NULL too. The reason for me to post this on the list is to hear (probably) historical reasons for this constraint not to be set already at DB level.
Thanks for your replies! El mar., 30 jul. 2019 a las 16:05, Katrin Fischer (<katrin.fischer...@web.de>) escribió: > Hi Sophie, > > I think on database level we need to allow NULL, because of the > item-level_itype 'record level' setting. I understand that itemtypes are > not set on item level at all in that case? > > Katrin > > On 30.07.19 16:32, Sophie Meynieux wrote: > > Hello, > > But itype must not be null if syspref item-level_itype is on, isn't it ? > > S. Meynieux > > -- > Responsable support > BibLibre > + 33 (0)4 91 81 35 08http://www.biblibre.com > > Le 29/07/2019 à 20:17, Katrin Fischer a écrit : > > +1 > > With a on delete set null? > On 29.07.19 19:39, Tomas Cohen Arazi wrote: > > Why shouldn't we add it :-D > > -- > Tomás Cohen Arazi > Theke Solutions (http://theke.io) > ✆ +54 9351 3513384 > GPG: B2F3C15F > > _______________________________________________ > Koha-devel mailing > listkoha-de...@lists.koha-community.orghttp://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel > website : http://www.koha-community.org/ > git : http://git.koha-community.org/ > bugs : http://bugs.koha-community.org/ > > > _______________________________________________ > Koha-devel mailing > listkoha-de...@lists.koha-community.orghttp://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel > website : http://www.koha-community.org/ > git : http://git.koha-community.org/ > bugs : http://bugs.koha-community.org/ > > > _______________________________________________ > Koha-devel mailing > listkoha-de...@lists.koha-community.orghttp://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel > website : http://www.koha-community.org/ > git : http://git.koha-community.org/ > bugs : http://bugs.koha-community.org/ > > _______________________________________________ > Koha-devel mailing list > Koha-devel@lists.koha-community.org > http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel > website : http://www.koha-community.org/ > git : http://git.koha-community.org/ > bugs : http://bugs.koha-community.org/ -- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
