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

[fa-stable.git] / sql / en_US-demo.sql

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
-('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` --