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