X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;ds=sidebyside;f=sql%2Fen_US-new.sql;h=e1ddc2d709842c6241957d22d5200fc8e5253f41;hb=1a88a3e8c8dc9b63d88697e4f330a0501a301f44;hp=a2f4321d29f205852a5db77a7b4292dc9bd78cb0;hpb=2c2164f6e17101e8bbfe029d272ea0d5266d6ec4;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` --