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

--- Comment #9 from mathieu saby <[email protected]> ---
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.
_______________________________________________
Koha-bugs mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to