From 9be16be7b355ae95d4d28d0d33dea9859eb0bad1 Mon Sep 17 00:00:00 2001 From: Nay Date: Fri, 17 Jun 2011 23:40:52 +0100 Subject: DB: TrinityDB revision 41: move SQL updates to the old directory --- sql/updates/characters/2011_05_29_0_characters_mail_items.sql | 8 -------- sql/updates/characters/2011_05_29_1_characters_character_pet.sql | 2 -- sql/updates/characters/2011_05_31_0_characters_character_pet.sql | 3 --- 3 files changed, 13 deletions(-) delete mode 100644 sql/updates/characters/2011_05_29_0_characters_mail_items.sql delete mode 100644 sql/updates/characters/2011_05_29_1_characters_character_pet.sql delete mode 100644 sql/updates/characters/2011_05_31_0_characters_character_pet.sql (limited to 'sql/updates/characters') diff --git a/sql/updates/characters/2011_05_29_0_characters_mail_items.sql b/sql/updates/characters/2011_05_29_0_characters_mail_items.sql deleted file mode 100644 index 3162fe1b263..00000000000 --- a/sql/updates/characters/2011_05_29_0_characters_mail_items.sql +++ /dev/null @@ -1,8 +0,0 @@ --- Uncomment this query if the ALTER query gives you primary key violation errors --- SET @item_guid := (SELECT `item_guid` FROM `mail_items` GROUP BY `item_guid` HAVING COUNT(`item_guid`) > 1); --- DELETE FROM `mail_items` WHERE `item_guid` IN (@item_guid); - -ALTER TABLE `mail_items` -DROP PRIMARY KEY, -ADD PRIMARY KEY(`item_guid`), -ADD KEY `idx_mail_id` (`mail_id`); diff --git a/sql/updates/characters/2011_05_29_1_characters_character_pet.sql b/sql/updates/characters/2011_05_29_1_characters_character_pet.sql deleted file mode 100644 index 33de0087ce3..00000000000 --- a/sql/updates/characters/2011_05_29_1_characters_character_pet.sql +++ /dev/null @@ -1,2 +0,0 @@ -ALTER TABLE `character_pet` -ADD KEY `idx_slot` (`slot`); diff --git a/sql/updates/characters/2011_05_31_0_characters_character_pet.sql b/sql/updates/characters/2011_05_31_0_characters_character_pet.sql deleted file mode 100644 index f36bc806de7..00000000000 --- a/sql/updates/characters/2011_05_31_0_characters_character_pet.sql +++ /dev/null @@ -1,3 +0,0 @@ -ALTER TABLE `character_pet` -DROP COLUMN `resettalents_cost`, -DROP COLUMN `resettalents_time`; -- cgit v1.2.3