From 146c5bd43744f6086434df610aacfc27b6f6f1fb Mon Sep 17 00:00:00 2001 From: Tomas Cohen Arazi Date: Fri, 16 Feb 2018 14:08:12 -0300 Subject: [PATCH] Bug 18336: Library groups fix Library groups were added after this patchset was submitted. This patch adjusts kohastructure.sql entry for library_groups. Signed-off-by: Tomas Cohen Arazi Signed-off-by: Kyle M Hall --- installer/data/mysql/kohastructure.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index b3926e9..4793951 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -4152,7 +4152,7 @@ CREATE TABLE library_groups ( FOREIGN KEY (parent_id) REFERENCES library_groups(id) ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON UPDATE CASCADE ON DELETE CASCADE, UNIQUE KEY title ( title ) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; -- 2.10.2