diff options
| author | Nay <dnpd.dd@gmail.com> | 2011-06-17 23:40:52 +0100 |
|---|---|---|
| committer | Nay <dnpd.dd@gmail.com> | 2011-06-17 23:46:57 +0100 |
| commit | 9be16be7b355ae95d4d28d0d33dea9859eb0bad1 (patch) | |
| tree | 1f42988e3921287ff6d75c67659d4d5452a7335a /sql/updates/characters | |
| parent | c8a9bd2d1c42235ce75e84664cbe3223b41f2493 (diff) | |
DB: TrinityDB revision 41: move SQL updates to the old directory
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`; |