From e1d93bd00f676701b1de87f86a1f2fc5cfc11438 Mon Sep 17 00:00:00 2001
From: megamage <none@none>
Date: Wed, 1 Jul 2009 18:07:20 -0500
Subject: *Backup your DB!     [8098] Support uint32 spell ids in code. Author:
 VladimirMangos

    * Propertly work with uint32 spell ids in player action bar
    * Fix in same time bug with not save equipment set button with id==0
    * Merge misc field in character_action and playercreateinfo_action to action field as 3 byte
    * Propertly load uint32 spell ids from character_spell
    * Fixed types for some pet/creature related structure for spell id storing.

--HG--
branch : trunk
---
 sql/characters.sql | 5 ++---
 1 file changed, 2 insertions(+), 3 deletions(-)

(limited to 'sql/characters.sql')

diff --git a/sql/characters.sql b/sql/characters.sql
index 693ddfed803..4271dd02db6 100644
--- a/sql/characters.sql
+++ b/sql/characters.sql
@@ -23,7 +23,7 @@
 
 DROP TABLE IF EXISTS `character_db_version`;
 CREATE TABLE `character_db_version` (
-  `required_8072_02_characters_characters` bit(1) default NULL
+  `required_8098_04_characters_pet_spell` bit(1) default NULL
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Last applied sql update to DB';
 
 --
@@ -389,9 +389,8 @@ DROP TABLE IF EXISTS `character_action`;
 CREATE TABLE `character_action` (
   `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
   `button` tinyint(3) unsigned NOT NULL default '0',
-  `action` smallint(5) unsigned NOT NULL default '0',
+  `action` int(11) unsigned NOT NULL default '0',
   `type` tinyint(3) unsigned NOT NULL default '0',
-  `misc` tinyint(3) unsigned NOT NULL default '0',
   PRIMARY KEY  (`guid`,`button`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
 
-- 
cgit v1.2.3

