https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18086
--- Comment #35 from Victor Grousset/tuxayo <[email protected]> --- Comment on attachment 168810 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=168810 Bug 18086: Add FK constraints for branchcode and categorycode Review of attachment 168810: --> (https://bugs.koha-community.org/bugzilla3/page.cgi?id=splinter.html&bug=18086&attachment=168810) ----------------------------------------------------------------- ::: installer/data/mysql/kohastructure.sql @@ +4962,5 @@ > /*!40101 SET character_set_client = utf8 */; > CREATE TABLE `overduerules` ( > `overduerules_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique > identifier for the overduerules', > + `branchcode` varchar(10) COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL > COMMENT 'foreign key from the branches table to define which branch this rule > is for (if blank it''s all libraries)', > + `categorycode` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT > 'foreign key from the categories table to define which patron category this > rule is for', Is there a reason for adding "COLLATE utf8mb4_unicode_ci" ? It's already set exactly like that on the whole table. -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] 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/
