X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sql%2Falter2.2rc.sql;h=aff4c0a7cfedd408f8596cb131e293804171b60d;hb=75564761d1429129282bd04ab00575c5e80fe4c2;hp=12dbb097294a48a68cebc702c75a6f631f4e5fa7;hpb=dab46164b519d9730cac11ca5e7fa0af7b763e6c;p=fa-stable.git

diff --git a/sql/alter2.2rc.sql b/sql/alter2.2rc.sql
index 12dbb097..aff4c0a7 100644
--- a/sql/alter2.2rc.sql
+++ b/sql/alter2.2rc.sql
@@ -1,8 +1,7 @@
 # Patch for upgrade from 2.2beta to 2.2RC/final
 
-ALTER TABLE `0_tag_associations` DROP PRIMARY KEY;
 ALTER TABLE `0_tag_associations` DROP COLUMN `id`;
-ALTER TABLE `0_tag_associations` ADD UNIQUE KEY (`type`,`name`);
+ALTER TABLE `0_tag_associations` ADD  UNIQUE KEY(`record_id`,`tag_id`);
 
 DROP TABLE IF EXISTS `0_useronline` ;