* Adding the update SQL for the last commit

* Thanks Aokreomes

--HG--
branch : trunk

1 files changed, 11 insertions, 0 deletions

diff --git a/sql/updates/6486_world_item_template.sql b/sql/updates/6486_world_item_template.sql
new file mode 100644
index 00000000000..91c87833694
--- /dev/null
+++ b/sql/updates/6486_world_item_template.sql
@@ -0,0 +1,11 @@
+-- item_template update from Malcrom
+-- Alter column AllowableClass to allowed max value signed.
+ALTER TABLE `item_template` CHANGE `AllowableClass` `AllowableClasstemp` MEDIUMINT(9);
+ALTER TABLE `item_template` ADD `AllowableClass` INT SIGNED NOT NULL AFTER `InventoryType`;
+UPDATE `item_template` SET `AllowableClass` = `AllowableClasstemp`;
+ALTER TABLE `item_template` DROP `AllowableClasstemp`;
+-- Alter column AllowableRace to allowed max value signed.
+ALTER TABLE `item_template` CHANGE `AllowableRace` `AllowableRacetemp` MEDIUMINT(9);
+ALTER TABLE `item_template` ADD `AllowableRace` INT SIGNED NOT NULL AFTER `AllowableClass`;
+UPDATE `item_template` SET `AllowableRace` = `AllowableRacetemp`;
+ALTER TABLE `item_template` DROP `AllowableRacetemp`;