diff options
| author | Duarte Duarte <dnpd.dd@gmail.com> | 2014-01-31 16:35:22 +0000 |
|---|---|---|
| committer | Duarte Duarte <dnpd.dd@gmail.com> | 2014-01-31 16:35:22 +0000 |
| commit | 83e0cc3b0c2b5afb78223ef9ee0c37d16e0db5be (patch) | |
| tree | 515bc417610ee1bac095797e1475335167320155 | |
| parent | 956fde1f0f40dadd3f69d56a6e9e6153873dd19c (diff) | |
SQL: Update 2014_01_31_01_world_item_template.sql
| -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', |