<div dir="ltr">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.<div><br></div><div>Thanks for your replies!</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">El mar., 30 jul. 2019 a las 16:05, Katrin Fischer (<<a href="mailto:katrin.fischer.83@web.de">katrin.fischer.83@web.de</a>>) escribió:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div bgcolor="#FFFFFF">
<p>Hi Sophie,<br>
</p>
<p>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?</p>
<p>Katrin<br>
</p>
<p>On 30.07.19 16:32, Sophie Meynieux wrote:<br>
</p>
<blockquote type="cite">
<p>Hello,</p>
<p>But itype must not be null if syspref item-level_itype is on,
isn't it ? <br>
</p>
<p>S. Meynieux<br>
</p>
<pre class="gmail-m_-8131025960625350699moz-signature" cols="72">--
Responsable support
BibLibre
+ 33 (0)4 91 81 35 08
<a class="gmail-m_-8131025960625350699moz-txt-link-freetext" href="http://www.biblibre.com" target="_blank">http://www.biblibre.com</a></pre>
<div class="gmail-m_-8131025960625350699moz-cite-prefix">Le 29/07/2019 à 20:17, Katrin Fischer
a écrit :<br>
</div>
<blockquote type="cite">
<p>+1</p>
<p>With a on delete set null?<br>
</p>
<div class="gmail-m_-8131025960625350699moz-cite-prefix">On 29.07.19 19:39, Tomas Cohen
Arazi wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">Why shouldn't we add it :-D<br clear="all">
<div><br>
</div>
-- <br>
<div dir="ltr" class="gmail-m_-8131025960625350699gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div style="font-size:12.8px">Tomás Cohen Arazi</div>
<div style="font-size:12.8px">Theke Solutions (<a href="http://theke.io/" target="_blank">http://theke.io</a>)<br>
✆ +54 9351 3513384<br>
GPG: B2F3C15F</div>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="gmail-m_-8131025960625350699mimeAttachmentHeader"></fieldset>
<pre class="gmail-m_-8131025960625350699moz-quote-pre">_______________________________________________
Koha-devel mailing list
<a class="gmail-m_-8131025960625350699moz-txt-link-abbreviated" href="mailto:Koha-devel@lists.koha-community.org" target="_blank">Koha-devel@lists.koha-community.org</a>
<a class="gmail-m_-8131025960625350699moz-txt-link-freetext" href="http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel" target="_blank">http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel</a>
website : <a class="gmail-m_-8131025960625350699moz-txt-link-freetext" href="http://www.koha-community.org/" target="_blank">http://www.koha-community.org/</a>
git : <a class="gmail-m_-8131025960625350699moz-txt-link-freetext" href="http://git.koha-community.org/" target="_blank">http://git.koha-community.org/</a>
bugs : <a class="gmail-m_-8131025960625350699moz-txt-link-freetext" href="http://bugs.koha-community.org/" target="_blank">http://bugs.koha-community.org/</a></pre>
</blockquote>
<br>
<fieldset class="gmail-m_-8131025960625350699mimeAttachmentHeader"></fieldset>
<pre class="gmail-m_-8131025960625350699moz-quote-pre">_______________________________________________
Koha-devel mailing list
<a class="gmail-m_-8131025960625350699moz-txt-link-abbreviated" href="mailto:Koha-devel@lists.koha-community.org" target="_blank">Koha-devel@lists.koha-community.org</a>
<a class="gmail-m_-8131025960625350699moz-txt-link-freetext" href="http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel" target="_blank">http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel</a>
website : <a class="gmail-m_-8131025960625350699moz-txt-link-freetext" href="http://www.koha-community.org/" target="_blank">http://www.koha-community.org/</a>
git : <a class="gmail-m_-8131025960625350699moz-txt-link-freetext" href="http://git.koha-community.org/" target="_blank">http://git.koha-community.org/</a>
bugs : <a class="gmail-m_-8131025960625350699moz-txt-link-freetext" href="http://bugs.koha-community.org/" target="_blank">http://bugs.koha-community.org/</a></pre>
</blockquote>
<br>
<fieldset class="gmail-m_-8131025960625350699mimeAttachmentHeader"></fieldset>
<pre class="gmail-m_-8131025960625350699moz-quote-pre">_______________________________________________
Koha-devel mailing list
<a class="gmail-m_-8131025960625350699moz-txt-link-abbreviated" href="mailto:Koha-devel@lists.koha-community.org" target="_blank">Koha-devel@lists.koha-community.org</a>
<a class="gmail-m_-8131025960625350699moz-txt-link-freetext" href="http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel" target="_blank">http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel</a>
website : <a class="gmail-m_-8131025960625350699moz-txt-link-freetext" href="http://www.koha-community.org/" target="_blank">http://www.koha-community.org/</a>
git : <a class="gmail-m_-8131025960625350699moz-txt-link-freetext" href="http://git.koha-community.org/" target="_blank">http://git.koha-community.org/</a>
bugs : <a class="gmail-m_-8131025960625350699moz-txt-link-freetext" href="http://bugs.koha-community.org/" target="_blank">http://bugs.koha-community.org/</a></pre>
</blockquote>
</div>
_______________________________________________<br>
Koha-devel mailing list<br>
<a href="mailto:Koha-devel@lists.koha-community.org" target="_blank">Koha-devel@lists.koha-community.org</a><br>
<a href="http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel" rel="noreferrer" target="_blank">http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel</a><br>
website : <a href="http://www.koha-community.org/" rel="noreferrer" target="_blank">http://www.koha-community.org/</a><br>
git : <a href="http://git.koha-community.org/" rel="noreferrer" target="_blank">http://git.koha-community.org/</a><br>
bugs : <a href="http://bugs.koha-community.org/" rel="noreferrer" target="_blank">http://bugs.koha-community.org/</a></blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div style="font-size:12.8px">Tomás Cohen Arazi</div><div style="font-size:12.8px">Theke Solutions (<a href="http://theke.io/" target="_blank">http://theke.io</a>)<br>✆ +54 9351 3513384<br>GPG: B2F3C15F</div></div></div></div></div>