From 5f62c2c4938f070f3258409d1a6f8cb14958d9f5 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 See the atomic update. Signed-off-by: Marcel de Rooy Tested on command line. Signed-off-by: Kyle M Hall --- 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 bcdb33834a..2533e9d66e 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -3933,6 +3933,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; @@ -3947,6 +3948,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.39.2