From 1a88a3e8c8dc9b63d88697e4f330a0501a301f44 Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Mon, 4 Mar 2019 08:42:29 +0100 Subject: [PATCH] Clean up in en_US-demo.sql and en_US-new.sql. @apmuthu. --- sql/en_US-demo.sql | 3 +-- sql/en_US-new.sql | 2 +- 2 files changed, 2 insertions(+), 3 deletions(-) diff --git a/sql/en_US-demo.sql b/sql/en_US-demo.sql index 284281b4..d536e000 100644 --- a/sql/en_US-demo.sql +++ b/sql/en_US-demo.sql @@ -1366,7 +1366,6 @@ CREATE TABLE `0_refs` ( -- Data of table `0_refs` -- INSERT INTO `0_refs` VALUES -('1', '0', '001/2012'), ('1', '1', '001/2018'), ('1', '10', '001/2018'), ('5', '10', '001/2019'), @@ -1947,7 +1946,7 @@ DROP TABLE IF EXISTS `0_tag_associations`; CREATE TABLE `0_tag_associations` ( `record_id` varchar(15) NOT NULL, `tag_id` int(11) NOT NULL, - UNIQUE KEY `record_id` (`record_id`,`tag_id`) + PRIMARY KEY (`record_id`,`tag_id`) ) ENGINE=InnoDB ; -- Data of table `0_tag_associations` -- diff --git a/sql/en_US-new.sql b/sql/en_US-new.sql index a2f4321d..e1ddc2d7 100644 --- a/sql/en_US-new.sql +++ b/sql/en_US-new.sql @@ -1619,7 +1619,7 @@ DROP TABLE IF EXISTS `0_tag_associations`; CREATE TABLE `0_tag_associations` ( `record_id` varchar(15) NOT NULL, `tag_id` int(11) NOT NULL, - UNIQUE KEY `record_id` (`record_id`,`tag_id`) + PRIMARY KEY (`record_id`,`tag_id`) ) ENGINE=InnoDB ; -- Data of table `0_tag_associations` -- -- 2.30.2