From 4f238eea944b73e0751b58046c33f5efd8e0c343 Mon Sep 17 00:00:00 2001 From: Marcel de Rooy Date: Fri, 13 Jan 2017 09:58:54 +0100 Subject: [PATCH] Bug 17196: [QA Follow-up] Missing unique key in kohastructure Content-Type: text/plain; charset=utf-8 See the atomic update. Signed-off-by: Marcel de Rooy Tested on command line. --- installer/data/mysql/kohastructure.sql | 2 ++ 1 file changed, 2 insertions(+) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 65fd18d..338b467 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -3931,6 +3931,7 @@ CREATE TABLE biblio_metadata ( `marcflavour` VARCHAR(16) NOT NULL, `metadata` LONGTEXT NOT NULL, PRIMARY KEY(id), + UNIQUE KEY `biblio_metadata_uniq_key` (`biblionumber`,`format`,`marcflavour`), CONSTRAINT `record_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES biblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; @@ -3945,6 +3946,7 @@ CREATE TABLE deletedbiblio_metadata ( `marcflavour` VARCHAR(16) NOT NULL, `metadata` LONGTEXT NOT NULL, PRIMARY KEY(id), + UNIQUE KEY `deletedbiblio_metadata_uniq_key` (`biblionumber`,`format`,`marcflavour`), CONSTRAINT `deletedrecord_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES deletedbiblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- 2.1.4