BJLdSkFf

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