Temporary fixes for php encoding library bugs ending with segfault.

[fa-stable.git] / sql / alter2.2rc.sql

diff --git a/sql/alter2.2rc.sql b/sql/alter2.2rc.sql
index 12dbb097294a48a68cebc702c75a6f631f4e5fa7..aff4c0a7cfedd408f8596cb131e293804171b60d 100644 (file)
--- 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` ;