http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8034 --- Comment #32 from Jonathan Druart <jonathan.druart@biblibre.com> --- (In reply to comment #31)
(In reply to comment #27)
QA comment:
* The DB update, you write "ALTER TABLE branches MODIFY branchprinter varchar(20) NULL, ADD FOREIGN KEY (branchprinter) REFERENCES printers (printqueue) ON UPDATE CASCADE" => why not also add ON DELETE SET NULL (on delete cascade would be a strong mistake, you don't want to delete branches just because you deleted a printer !!!) ?
Because we don't want to leave branches without their default printer, so only unused printers can be removed.
So you must catch the error raised by mysql if a printer is deleted and some branches use it. -- You are receiving this mail because: You are watching all bug changes.