diff options
| -rw-r--r-- | sql/updates/world/2014_01_31_01_world_item_template.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/2014_01_31_01_world_item_template.sql b/sql/updates/world/2014_01_31_01_world_item_template.sql index 802b93c69cf..f47e96cf403 100644 --- a/sql/updates/world/2014_01_31_01_world_item_template.sql +++ b/sql/updates/world/2014_01_31_01_world_item_template.sql @@ -1,3 +1,9 @@ +UPDATE `item_template` SET `spellcharges_1`=0 WHERE `spellcharges_1` IS NULL; +UPDATE `item_template` SET `spellcharges_2`=0 WHERE `spellcharges_2` IS NULL; +UPDATE `item_template` SET `spellcharges_3`=0 WHERE `spellcharges_3` IS NULL; +UPDATE `item_template` SET `spellcharges_4`=0 WHERE `spellcharges_4` IS NULL; +UPDATE `item_template` SET `spellcharges_5`=0 WHERE `spellcharges_5` IS NULL; + ALTER TABLE `item_template` CHANGE `spellcharges_1` `spellcharges_1` SMALLINT( 6 ) NOT NULL DEFAULT '0', CHANGE `spellcharges_2` `spellcharges_2` SMALLINT( 6 ) NOT NULL DEFAULT '0', CHANGE `spellcharges_3` `spellcharges_3` SMALLINT( 6 ) NOT NULL DEFAULT '0', |