* Add support for signed values in item_template fields: Flags, maxcount,

* stackable, BuyPrice, spellid_1, spellid_2, spellid_3, spellid_4, spellid_5,
* RandomProperty
* Patch by Kudlaty, SQL by Malcrom -- THANK YOU!

--HG--
branch : trunk

1 files changed, 51 insertions, 0 deletions

diff --git a/sql/updates/6692_world_item_template.sql b/sql/updates/6692_world_item_template.sql
new file mode 100644
index 00000000000..8055fadb7d0
--- /dev/null
+++ b/sql/updates/6692_world_item_template.sql
@@ -0,0 +1,51 @@
+-- Alter Flags column in item_template to allow signed value
+ALTER TABLE `item_template` CHANGE `Flags` `Flagstemp` INT(10);
+ALTER TABLE `item_template` ADD `Flags` INT SIGNED NOT NULL AFTER `Quality`;
+UPDATE `item_template` SET `Flags` = `Flagstemp`;
+ALTER TABLE `item_template` DROP `Flagstemp`;
+-- Alter maxcount column in item_template to allow max signed value
+ALTER TABLE `item_template` CHANGE `maxcount` `maxcounttemp` smallINT(5);
+ALTER TABLE `item_template` ADD `maxcount` INT SIGNED NOT NULL AFTER `RequiredReputationRank`;
+UPDATE `item_template` SET `maxcount` = `maxcounttemp`;
+ALTER TABLE `item_template` DROP `maxcounttemp`;
+-- Alter stackable column in item_template to allow max signed value
+ALTER TABLE `item_template` CHANGE `stackable` `stackabletemp` INT(11);
+ALTER TABLE `item_template` ADD `stackable` INT SIGNED DEFAULT 1 AFTER `maxcount`;
+UPDATE `item_template` SET `stackable` = `stackabletemp`;
+ALTER TABLE `item_template` DROP `stackabletemp`;
+-- Alter BuyPrice column in item_template to allow max signed value
+ALTER TABLE `item_template` CHANGE `BuyPrice` `BuyPricetemp` INT(10);
+ALTER TABLE `item_template` ADD `BuyPrice` INT SIGNED NOT NULL AFTER `BuyCount`;
+UPDATE `item_template` SET `BuyPrice` = `BuyPricetemp`;
+ALTER TABLE `item_template` DROP `BuyPricetemp`;
+-- Alter spellid_1 column in item_template to allow signed value
+ALTER TABLE `item_template` CHANGE `spellid_1` `spellid_1temp` MEDIUMINT(8);
+ALTER TABLE `item_template` ADD `spellid_1` MEDIUMINT(8) SIGNED NOT NULL AFTER `RangedModRange`;
+UPDATE `item_template` SET `spellid_1` = `spellid_1temp`;
+ALTER TABLE `item_template` DROP `spellid_1temp`;
+-- Alter spellid_2 column in item_template to allow signed value
+ALTER TABLE `item_template` CHANGE `spellid_2` `spellid_2temp` MEDIUMINT(8);
+ALTER TABLE `item_template` ADD `spellid_2` MEDIUMINT(8) SIGNED NOT NULL AFTER `spellcategorycooldown_1`;
+UPDATE `item_template` SET `spellid_2` = `spellid_2temp`;
+ALTER TABLE `item_template` DROP `spellid_2temp`;
+-- Alter spellid_3 column in item_template to allow signed value
+ALTER TABLE `item_template` CHANGE `spellid_3` `spellid_3temp` MEDIUMINT(8);
+ALTER TABLE `item_template` ADD `spellid_3` MEDIUMINT(8) SIGNED NOT NULL AFTER `spellcategorycooldown_2`;
+UPDATE `item_template` SET `spellid_3` = `spellid_3temp`;
+ALTER TABLE `item_template` DROP `spellid_3temp`;
+-- Alter spellid_4 column in item_template to allow signed value
+ALTER TABLE `item_template` CHANGE `spellid_4` `spellid_4temp` MEDIUMINT(8);
+ALTER TABLE `item_template` ADD `spellid_4` MEDIUMINT(8) SIGNED NOT NULL AFTER `spellcategorycooldown_3`;
+UPDATE `item_template` SET `spellid_4` = `spellid_4temp`;
+ALTER TABLE `item_template` DROP `spellid_4temp`;
+-- Alter spellid_5 column in item_template to allow signed value
+ALTER TABLE `item_template` CHANGE `spellid_5` `spellid_5temp` MEDIUMINT(8);
+ALTER TABLE `item_template` ADD `spellid_5` MEDIUMINT(8) SIGNED NOT NULL AFTER `spellcategorycooldown_4`;
+UPDATE `item_template` SET `spellid_5` = `spellid_5temp`;
+ALTER TABLE `item_template` DROP `spellid_5temp`;
+-- Alter RandomProperty column in item_template to allow signed value
+ALTER TABLE `item_template` CHANGE `RandomProperty` `RandomPropertytemp` MEDIUMINT(8);
+ALTER TABLE `item_template` ADD `RandomProperty` MEDIUMINT(8) SIGNED NOT NULL AFTER `sheath`;
+UPDATE `item_template` SET `RandomProperty` = `RandomPropertytemp`;
+ALTER TABLE `item_template` DROP `RandomPropertytemp`;
+