From 663a4fb607133bcc1ca43b0fce18cf3ab8f8e2ee Mon Sep 17 00:00:00 2001 From: Baptiste Wojtkowski Date: Mon, 22 Jul 2024 13:42:12 +0200 Subject: [PATCH] Bug 18086: (follow-up) remove COLLATE from sql update --- installer/data/mysql/kohastructure.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 76e24d5..29554a3 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -4962,8 +4962,8 @@ DROP TABLE IF EXISTS `overduerules`; /*!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 NULL DEFAULT NULL COMMENT 'foreign key from the categories table to define which patron category this rule is for', + `branchcode` varchar(10) 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) NULL DEFAULT NULL COMMENT 'foreign key from the categories table to define which patron category this rule is for', `delay1` int(4) DEFAULT NULL COMMENT 'number of days after the item is overdue that the first notice is sent', `letter1` varchar(20) DEFAULT NULL COMMENT 'foreign key from the letter table to define which notice should be sent as the first notice', `debarred1` varchar(1) DEFAULT '0' COMMENT 'is the patron restricted when the first notice is sent (1 for yes, 0 for no)', -- 2.43.0