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/

Reply via email to