[Koha-devel] Need advice for Bug 10758 - Show bibliographic information of deleted records in acquisitions

[Galen Charlton]

Hi,

On Sun, Sep 15, 2013 at 6:41 AM, Mathieu Saby
<mathieu.saby at univ-rennes2.fr>wrote:

> - or by creating a new column 'deletedbiblionumber" in acqorders
>
> 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.
>

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.

Regards,

Galen
-- 
Galen Charlton
Manager of Implementation
Equinox Software, Inc. / The Open Source Experts
email:  gmc at esilibrary.com
direct: +1 770-709-5581
cell:   +1 404-984-4366
skype:  gmcharlt
web:    http://www.esilibrary.com/
Supporting Koha and Evergreen: http://koha-community.org &
http://evergreen-ils.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20130916/69b4834a/attachment.html>