Clean up in en_US-demo.sql and en_US-new.sql. @apmuthu.

diff --git a/sql/en_US-demo.sql b/sql/en_US-demo.sql
index 284281b4180e6747e77c6ba1621026dfea684243..d536e000ee7605c42b1a1b6ec91f73c148804c9d 100644 (file)
--- 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
 -- 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'),
 ('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,
 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` --
 ) ENGINE=InnoDB ;
 
 -- Data of table `0_tag_associations` --

diff --git a/sql/en_US-new.sql b/sql/en_US-new.sql
index a2f4321d29f205852a5db77a7b4292dc9bd78cb0..e1ddc2d709842c6241957d22d5200fc8e5253f41 100644 (file)
--- 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,
 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` --
 ) ENGINE=InnoDB ;
 
 -- Data of table `0_tag_associations` --