From 83e0cc3b0c2b5afb78223ef9ee0c37d16e0db5be Mon Sep 17 00:00:00 2001 From: Duarte Duarte Date: Fri, 31 Jan 2014 16:35:22 +0000 Subject: SQL: Update 2014_01_31_01_world_item_template.sql --- sql/updates/world/2014_01_31_01_world_item_template.sql | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'sql/updates') 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', -- cgit v1.2.3