Attachment 169461 Details for Bug 18086 – Bug 18086: (follow-up) remove COLLATE from sql update

[patch] Bug 18086: (follow-up) remove COLLATE from sql update

Bug-18086-follow-up-remove-COLLATE-from-sql-update.patch (text/plain), 1.80 KB, created by Baptiste Wojtkowski (bwoj) on 2024-07-24 08:31:35 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Baptiste Wojtkowski (bwoj)

Created: 2024-07-24 08:31:35 UTC

Size: 1.80 KB

patch

obsolete

>From 004fca241e7cef9454560d9d77409c5ff008abd4 Mon Sep 17 00:00:00 2001
>From: Baptiste Wojtkowski <bski@laposte.net>
>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

Actions: View | Diff | Splinter Review

Attachments on bug 18086: 105368 | 105369 | 105380 | 105382 | 105387 | 105388 | 105424 | 105551 | 106201 | 134730 | 134731 | 168810 | 168811 | 168812 | 168813 | 168814 | 168815 | 169287 | 169288 | 169289 | 169290 | 169291 | 169292 | 169293 | 169294 | 169295 | 169296 | 169297 | 169298 | 169299 | 169300 | 169301 | 169302 | 169396 | 169397 | 169398 | 169399 | 169400 | 169401 | 169402 | 169403 | 169404 | 169455 | 169456 | 169457 | 169458 | 169459 | 169460 | 169461 | 169462 | 169463 | 169543 | 169544