X-Git-Url: https://delta.frontaccounting.com/gitweb/?p=fa-stable.git;a=blobdiff_plain;f=sql%2Fen_US-demo.sql;h=d536e000ee7605c42b1a1b6ec91f73c148804c9d;hp=284281b4180e6747e77c6ba1621026dfea684243;hb=1a88a3e8c8dc9b63d88697e4f330a0501a301f44;hpb=52f4ea3f7360e1284b1cf1cd39b2efda6ff0606f 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` --