<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Yep, that was one of my ideas too. So, less work will be necessary on
C4 subs.<br>
But as said K. Fisher, if there are "deleted..." tables, it is probably
for one reason??<br>
<br>
Mathieu<br>
<br>
<br>
Galen Charlton a écrit :
<blockquote
cite="mid:CAPLnt64QP_ddaDiw99H2+drPGVgj7Ek8xi7jrtQ+x=NN5f83LA@mail.gmail.com"
type="cite">
<div dir="ltr">Hi,
<div class="gmail_extra"><br>
<div class="gmail_quote">On Sun, Sep 15, 2013 at 6:41 AM, Mathieu
Saby <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:mathieu.saby@univ-rennes2.fr" target="_blank">mathieu.saby@univ-rennes2.fr</a>></span>
wrote:<br>
<blockquote class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div text="#000000" bgcolor="#FFFFFF">- or by creating a new column
'deletedbiblionumber" in acqorders<br>
<br>
I would prefer the 3d option (the "cleaner" for me, as I suppose
removing foreign key is not good for integrity of DB), but I am very
very far from being a database expert or a real developer.<br>
</div>
</blockquote>
</div>
<div class="gmail_extra"><br>
</div>
For the sake of listing more possibilities, another option would be to
merge deletedbiblio into biblio and add a Boolean column to indicate
whether the bib is logically deleted or not.</div>
<div class="gmail_extra"><br>
</div>
<div class="gmail_extra">Regards,</div>
<div class="gmail_extra"><br>
Galen<br>
-- <br>
<div dir="ltr">
<div>Galen Charlton</div>
<div>Manager of Implementation</div>
<div>Equinox Software, Inc. / The Open Source Experts</div>
<div>email: <a moz-do-not-send="true"
href="mailto:gmc@esilibrary.com" target="_blank">gmc@esilibrary.com</a></div>
<div>direct: +1 770-709-5581</div>
<div>cell: +1 404-984-4366</div>
<div>skype: gmcharlt</div>
<div>web: <a moz-do-not-send="true"
href="http://www.esilibrary.com/" target="_blank">http://www.esilibrary.com/</a></div>
<div>Supporting Koha and Evergreen: <a moz-do-not-send="true"
href="http://koha-community.org" target="_blank">http://koha-community.org</a>
& <a moz-do-not-send="true" href="http://evergreen-ils.org"
target="_blank">http://evergreen-ils.org</a></div>
</div>
</div>
</div>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Mathieu Saby
Service d'Informatique Documentaire
Service Commun de la Documentation
Université Rennes 2
Téléphone : 02 99 14 12 65
Courriel : <a class="moz-txt-link-abbreviated" href="mailto:mathieu.saby@univ-rennes2.fr">mathieu.saby@univ-rennes2.fr</a>
</pre>
</body>
</html>