diff options
| author | Magnifikator <user385@ximbo.net> | 2014-01-31 15:53:05 +0000 |
|---|---|---|
| committer | Duarte Duarte <dnpd.dd@gmail.com> | 2014-01-31 15:53:05 +0000 |
| commit | 956fde1f0f40dadd3f69d56a6e9e6153873dd19c (patch) | |
| tree | 4e8a9a1750d449fb858b49174fceef4de6e5d9ca | |
| parent | 5666c7cc35ac8e5ff56a796bbbbe869028c8ea41 (diff) | |
DB/item_template: Set defaults of spellcharges_X to 0 instead of NULL
Closes #10748
Signed-off-by: Duarte Duarte <dnpd.dd@gmail.com>
| -rw-r--r-- | sql/updates/world/2014_01_31_01_world_item_template.sql | 5 |
1 files changed, 5 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 new file mode 100644 index 00000000000..802b93c69cf --- /dev/null +++ b/sql/updates/world/2014_01_31_01_world_item_template.sql @@ -0,0 +1,5 @@ +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', + CHANGE `spellcharges_4` `spellcharges_4` SMALLINT( 6 ) NOT NULL DEFAULT '0', + CHANGE `spellcharges_5` `spellcharges_5` SMALLINT( 6 ) NOT NULL DEFAULT '0'; |