From: Joe Hunt <joe.hunt.consulting@gmail.com>
Date: Mon, 4 Mar 2019 07:42:29 +0000 (+0100)
Subject: Clean up in en_US-demo.sql and en_US-new.sql. @apmuthu.
X-Git-Url: https://delta.frontaccounting.com/gitweb/?p=fa-stable.git;a=commitdiff_plain;h=1a88a3e8c8dc9b63d88697e4f330a0501a301f44

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