From 8911cbb0ef49ac93fbb09d1668ae4d3f0afffed1 Mon Sep 17 00:00:00 2001 From: Marcel de Rooy 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 Signed-off-by: Tomas Cohen Arazi Signed-off-by: Fridolin Somers Signed-off-by: Kyle M Hall --- 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 597f1a2edf..826f1947c7 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -4749,7 +4749,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.39.5