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