Attachment 133766 Details for Bug 30565 – Bug 30565: Correct kohastructure

[patch] Bug 30565: Correct kohastructure

Bug-30565-Correct-kohastructure.patch (text/plain), 1.35 KB, created by Tomás Cohen Arazi (tcohen) on 2022-04-25 12:30:43 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Tomás Cohen Arazi (tcohen)

Created: 2022-04-25 12:30:43 UTC

Size: 1.35 KB

patch

obsolete

>From e244bd2b06a2795ea3c821301ddcfcd37f9bec1d Mon Sep 17 00:00:00 2001
>From: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
>Date: Wed, 20 Apr 2022 11:22:15 +0000
>Subject: [PATCH] Bug 30565: Correct kohastructure
>
>The unique key was added in a dbrev and is referred to in code.
>But forgotten in kohastructure.
>
>Test plan:
>Run new install or kohastructure.sql on empty db.
>
>Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
>Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
>---
> installer/data/mysql/kohastructure.sql | 3 ++-
> 1 file changed, 2 insertions(+), 1 deletion(-)
>
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index 8f5f7b438f8..e19b86c5854 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -4790,7 +4790,8 @@ CREATE TABLE `stockrotationrotas` (
>   `description` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Description for this rota',
>   `cyclical` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Should items on this rota keep cycling?',
>   `active` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is this rota currently active?',
>-  PRIMARY KEY (`rota_id`)
>+  PRIMARY KEY (`rota_id`),
>+  UNIQUE KEY `stockrotationrotas_title` (`title`)
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
>-- 
>2.34.1

Actions: View | Diff | Splinter Review

Attachments on bug 30565: 133457 | 133458 | 133459 | 133766 | 133767 | 133768