1 ALTER TABLE character_db_version CHANGE COLUMN required_9661_01_characters_character_talent required_9680_01_characters_character_stats bit;
3 DROP TABLE IF EXISTS `character_stats`;
4 CREATE TABLE `character_stats` (
5 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier, Low part',
6 `maxhealth` int(10) UNSIGNED NOT NULL default '0',
7 `maxpower1` int(10) UNSIGNED NOT NULL default '0',
8 `maxpower2` int(10) UNSIGNED NOT NULL default '0',
9 `maxpower3` int(10) UNSIGNED NOT NULL default '0',
10 `maxpower4` int(10) UNSIGNED NOT NULL default '0',
11 `maxpower5` int(10) UNSIGNED NOT NULL default '0',
12 `maxpower6` int(10) UNSIGNED NOT NULL default '0',
13 `maxpower7` int(10) UNSIGNED NOT NULL default '0',
14 `strength` int(10) UNSIGNED NOT NULL default '0',
15 `agility` int(10) UNSIGNED NOT NULL default '0',
16 `stamina` int(10) UNSIGNED NOT NULL default '0',
17 `intellect` int(10) UNSIGNED NOT NULL default '0',
18 `spirit` int(10) UNSIGNED NOT NULL default '0',
19 `armor` int(10) UNSIGNED NOT NULL default '0',
20 `resHoly` int(10) UNSIGNED NOT NULL default '0',
21 `resFire` int(10) UNSIGNED NOT NULL default '0',
22 `resNature` int(10) UNSIGNED NOT NULL default '0',
23 `resFrost` int(10) UNSIGNED NOT NULL default '0',
24 `resShadow` int(10) UNSIGNED NOT NULL default '0',
25 `resArcane` int(10) UNSIGNED NOT NULL default '0',
26 `blockPct` float UNSIGNED NOT NULL default '0',
27 `dodgePct` float UNSIGNED NOT NULL default '0',
28 `parryPct` float UNSIGNED NOT NULL default '0',
29 `critPct` float UNSIGNED NOT NULL default '0',
30 `rangedCritPct` float UNSIGNED NOT NULL default '0',
31 `spellCritPct` float UNSIGNED NOT NULL default '0',
32 `attackPower` int(10) UNSIGNED NOT NULL default '0',
33 `rangedAttackPower` int(10) UNSIGNED NOT NULL default '0',
34 `spellPower` int(10) UNSIGNED NOT NULL default '0',
36 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;