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

[patch] Bug 30565: Correct kohastructure

Bug-30565-Correct-kohastructure.patch (text/plain), 1.33 KB, created by Marcel de Rooy on 2022-04-20 11:40:28 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Marcel de Rooy

Created: 2022-04-20 11:40:28 UTC

Size: 1.33 KB

patch

obsolete

>From 0e1d1e13f8de4d54ac7447aa650f846c554caf2e 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
>Content-Type: text/plain; charset=utf-8
>
>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>
>---
> 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 0c82c00394..c392a590c3 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -4786,7 +4786,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.20.1

Actions: View | Diff | Splinter Review

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