https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21946
--- Comment #102 from Alex Arnaud <alex.arn...@biblibre.com> --- Comment on attachment 99419 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=99419 Bug 21946: Database updates Review of attachment 99419: --> (https://bugs.koha-community.org/bugzilla3/page.cgi?id=splinter.html&bug=21946&attachment=99419) ----------------------------------------------------------------- ::: installer/data/mysql/kohastructure.sql @@ +892,4 @@ > hideinopac tinyint(1) NOT NULL DEFAULT 0, -- Hide the item type from the > search options in OPAC > searchcategory varchar(80) default NULL, -- Group this item type with > others with the same value on OPAC search options > PRIMARY KEY (`itemtype`), > + FOREIGN KEY (parent_type) REFERENCES itemtypes(itemtype) ON UPDATE CASCADE > ON DELETE CASCADE, Can you use CONSTRAINT as in the atomic update. So that we can have the constraint name that is defined in. -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://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/