@@ -, +, @@ --- installer/data/mysql/kohastructure.sql | 2 ++ 1 file changed, 2 insertions(+) --- a/installer/data/mysql/kohastructure.sql +++ a/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; --