aboutsummaryrefslogtreecommitdiff
path: root/sql/characters.sql
diff options
context:
space:
mode:
authormegamage <none@none>2009-07-01 18:07:20 -0500
committermegamage <none@none>2009-07-01 18:07:20 -0500
commite1d93bd00f676701b1de87f86a1f2fc5cfc11438 (patch)
tree092bc22e10ba60a13b5bf04ee351f614d8679b4c /sql/characters.sql
parent8122a15f467a8493cd5c49decc4fe09499b78af4 (diff)
*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
Diffstat (limited to 'sql/characters.sql')
-rw-r--r--sql/characters.sql5
1 files changed, 2 insertions, 3 deletions
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';