https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18182
--- Comment #17 from Marcel de Rooy <m.de.r...@rijksmuseum.nl> --- (In reply to Jonathan Druart from comment #16) > I have added tests, but one fails on 'Koha::Serial::Item'. > Could you take a look? CREATE TABLE `serialitems` ( `itemnumber` int(11) NOT NULL, `serialid` int(11) NOT NULL, UNIQUE KEY `serialitemsidx` (`itemnumber`), KEY `serialitems_sfk_1` (`serialid`), CONSTRAINT `serialitems_sfk_1` FOREIGN KEY (`serialid`) REFERENCES `serial` (`serialid`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `serialitems_sfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE ) Serialitems should have a primary key. Since itemnumber is a unique key, we could promote it to PK as well. Should be solved on a different report. -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/
