[Koha-bugs] [Bug 10758] Show bibliographic information of deleted records in acquisitions

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10758

--- Comment #9 from mathieu saby <mathieu.saby at univ-rennes2.fr> ---
In statistics table, there is no constraint on biblionumber at all.
I suppose it won't be good for safety reason to merely suppress existing
constraint in aqorders, so I edited updatedatabse to suppress the "ON DELETE
SET NULL", and keep only "ON UPDATE CASCADE".
It is the 1st time I try to do this kind of manipulation... and I did it wrong
: when I tried to suppress a biblio record linked to an order, it raised a SQL
error.
Could you tell me how to write the constraint to link aqorders.biblionumber
with biblio.biblionumber, but to keep the value of  aqorders.biblionumber when
the biblio is suppressed ?

Mathieu

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.