diff options
Diffstat (limited to 'sql/updates/characters')
3 files changed, 0 insertions, 13 deletions
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`; |