Changeset 1072 for trunk

Timestamp:

12/13/09 13:00:31 (2 years ago)

Author:

bogdan2412

Message:

Fixed task-tags migration script to add proper unique index.

File:

• trunk/scripts/migrate-task-tags (modified) (1 diff)

trunk/scripts/migrate-task-tags

@@ -7 +7 @@
 db_query("
     ALTER TABLE `ia_tags`
-    ADD COLUMN `type` ENUM('author','contest','year','round','age_group','method','algorithm','tag') NOT NULL
+    ADD COLUMN `type` ENUM('author','contest','year','round','age_group','method','algorithm','tag') NOT NULL,
+    DROP INDEX `name`,
+    ADD UNIQUE INDEX `name_type` USING BTREE(`name`, `type`)
 ");
 db_query('UPDATE `ia_tags` SET `type` = "tag"');