From 1390440f140f59feefe7f5c8f51eb99bce6dbf12 Mon Sep 17 00:00:00 2001
From: megamage <none@none>
Date: Thu, 14 May 2009 15:37:28 -0500
Subject: [7823] Fix ScalingStatValue field size in item_template table.
 Author: DiSlord

--HG--
branch : trunk
---
 sql/mangos.sql                               | 4 ++--
 sql/updates/7823_01_mangos_item_template.sql | 4 ++++
 2 files changed, 6 insertions(+), 2 deletions(-)
 create mode 100644 sql/updates/7823_01_mangos_item_template.sql

diff --git a/sql/mangos.sql b/sql/mangos.sql
index 60d99b0f6ba..ae74c23f91b 100644
--- a/sql/mangos.sql
+++ b/sql/mangos.sql
@@ -23,7 +23,7 @@ DROP TABLE IF EXISTS `db_version`;
 CREATE TABLE `db_version` (
   `version` varchar(120) default NULL,
   `creature_ai_version` varchar(120) default NULL,
-  `required_7796_02_mangos_mangos_string` bit(1) default NULL
+  `required_7823_01_mangos_item_template` bit(1) default NULL
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Used DB version notes';
 
 --
@@ -1711,7 +1711,7 @@ CREATE TABLE `item_template` (
   `stat_type10` tinyint(3) unsigned NOT NULL default '0',
   `stat_value10` smallint(6) NOT NULL default '0',
   `ScalingStatDistribution` smallint(6) NOT NULL default '0',
-  `ScalingStatValue` smallint(6) NOT NULL default '0',
+  `ScalingStatValue` int(6) unsigned NOT NULL default '0',
   `dmg_min1` float NOT NULL default '0',
   `dmg_max1` float NOT NULL default '0',
   `dmg_type1` tinyint(3) unsigned NOT NULL default '0',
diff --git a/sql/updates/7823_01_mangos_item_template.sql b/sql/updates/7823_01_mangos_item_template.sql
new file mode 100644
index 00000000000..2b3a0b314b6
--- /dev/null
+++ b/sql/updates/7823_01_mangos_item_template.sql
@@ -0,0 +1,4 @@
+ALTER TABLE db_version CHANGE COLUMN required_7796_02_mangos_mangos_string required_7823_01_mangos_item_template bit;
+
+ALTER TABLE item_template
+CHANGE COLUMN ScalingStatValue ScalingStatValue int(6) unsigned NOT NULL default '0';
\ No newline at end of file
-- 
cgit v1.2.3