From 5d6b2739bb8bfb3c6e7cc297d3c51e180dc5260f Mon Sep 17 00:00:00 2001 From: Shauren Date: Sat, 26 Nov 2011 22:11:36 +0100 Subject: SQL: Drop columns only after data was copied to new table --- sql/updates/world/4.x/2011_11_25_02_world_item_template.sql | 5 ----- sql/updates/world/4.x/2011_11_25_02_world_item_template_addon.sql | 7 ++++++- 2 files changed, 6 insertions(+), 6 deletions(-) (limited to 'sql') diff --git a/sql/updates/world/4.x/2011_11_25_02_world_item_template.sql b/sql/updates/world/4.x/2011_11_25_02_world_item_template.sql index 8a047ed9d11..9580838fdb7 100644 --- a/sql/updates/world/4.x/2011_11_25_02_world_item_template.sql +++ b/sql/updates/world/4.x/2011_11_25_02_world_item_template.sql @@ -35,11 +35,6 @@ ALTER TABLE `item_template` DROP `shadow_res`, DROP `arcane_res`, DROP `ammo_type`, - DROP `spellppmRate_1`, - DROP `spellppmRate_2`, - DROP `spellppmRate_3`, - DROP `spellppmRate_4`, - DROP `spellppmRate_5`, DROP `block`, DROP `RequiredDisenchantSkill`, DROP `DisenchantId`, diff --git a/sql/updates/world/4.x/2011_11_25_02_world_item_template_addon.sql b/sql/updates/world/4.x/2011_11_25_02_world_item_template_addon.sql index 2d99d9fc610..62692f00e6b 100644 --- a/sql/updates/world/4.x/2011_11_25_02_world_item_template_addon.sql +++ b/sql/updates/world/4.x/2011_11_25_02_world_item_template_addon.sql @@ -35,4 +35,9 @@ ALTER TABLE `item_template` DROP `BuyCount`, DROP `FoodType`, DROP `minMoneyLoot`, - DROP `maxMoneyLoot`; + DROP `maxMoneyLoot`, + DROP `spellppmRate_1`, + DROP `spellppmRate_2`, + DROP `spellppmRate_3`, + DROP `spellppmRate_4`, + DROP `spellppmRate_5`; -- cgit v1.2.3