http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3206
--- Comment #9 from Matthias Meusburger <[email protected]> --- (In reply to Frédéric Demians from comment #7) > Adding a new syspref, you're supposed to add it also to sysprefs.sql file. Added ! > > I don't understand this in your patch: > > diff --git a/installer/data/mysql/kohastructure.sql > b/installer/data/mysql/kohastructure.sql > index c41710c..5fd5612 100644 > --- a/installer/data/mysql/kohastructure.sql > +++ b/installer/data/mysql/kohastructure.sql > @@ -1609,7 +1609,6 @@ CREATE TABLE `oai_sets_biblios` ( > `biblionumber` int(11) NOT NULL, > `set_id` int(11) NOT NULL, > PRIMARY KEY (`biblionumber`, `set_id`), > - CONSTRAINT `oai_sets_biblios_ibfk_1` FOREIGN KEY (`biblionumber`) > REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE, > CONSTRAINT `oai_sets_biblios_ibfk_2` FOREIGN KEY (`set_id`) REFERENCES > `oai_sets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE > ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; This is required to be able to display deleted records in a set. With the constraint, when a record is deleted, its biblionumber is automatically deleted from the oai_sets_biblio, and thus removed from the set. -- You are receiving this mail because: 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/
