diff options
| author | Shauren <shauren.trinity@gmail.com> | 2011-11-26 22:11:36 +0100 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2011-11-26 22:11:36 +0100 |
| commit | 5d6b2739bb8bfb3c6e7cc297d3c51e180dc5260f (patch) | |
| tree | a4a348239d125ae6f6e4b5f846d8f80b01efa900 | |
| parent | bef006c5bf7269a69d06a62aa8235f48be5faaf9 (diff) | |
SQL: Drop columns only after data was copied to new table
| -rw-r--r-- | sql/updates/world/4.x/2011_11_25_02_world_item_template.sql | 5 | ||||
| -rw-r--r-- | sql/updates/world/4.x/2011_11_25_02_world_item_template_addon.sql | 7 |
2 files changed, 6 insertions, 6 deletions
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`; |