45UvLWnL

1CREATE TABLE IF NOT EXISTS `characters` (
2  `guid` int(10) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
3  `account` int(10) unsigned NOT NULL default '0' COMMENT 'Account Identifier',
4  `name` varchar(12) NOT NULL default '',
5  `race` tinyint(3) unsigned NOT NULL default '0',
6  `class` tinyint(3) unsigned NOT NULL default '0',
7  `gender` tinyint(3) unsigned NOT NULL default '0',
8  `level` tinyint(3) unsigned NOT NULL default '0',
9  `xp` int(10) unsigned NOT NULL default '0',
10  `money` int(10) unsigned NOT NULL default '0',
11  `playerBytes` int(10) unsigned NOT NULL default '0',
12  `playerBytes2` int(10) unsigned NOT NULL default '0',
13  `playerFlags` int(10) unsigned NOT NULL default '0',
14  `position_x` float NOT NULL default '0',
15  `position_y` float NOT NULL default '0',
16  `position_z` float NOT NULL default '0',
17  `map` int(10) default NULL,
18  `instance_id` int(10) unsigned NOT NULL default '0',
19  `instance_mode_mask` tinyint(3) unsigned NOT NULL default '0',
20  `orientation` float NOT NULL default '0',
21  `taximask` text NOT NULL,
22  `online` tinyint(3) unsigned NOT NULL default '0',
23  `cinematic` tinyint(3) unsigned NOT NULL default '0',
24  `totaltime` int(10) unsigned NOT NULL default '0',
25  `leveltime` int(10) unsigned NOT NULL default '0',
26  `logout_time` int(10) unsigned NOT NULL default '0',
27  `is_logout_resting` tinyint(3) unsigned NOT NULL default '0',
28  `rest_bonus` float NOT NULL default '0',
29  `resettalents_cost` int(10) unsigned NOT NULL default '0',
30  `resettalents_time` int(10) unsigned NOT NULL default '0',
31  `trans_x` float NOT NULL default '0',
32  `trans_y` float NOT NULL default '0',
33  `trans_z` float NOT NULL default '0',
34  `trans_o` float NOT NULL default '0',
35  `transguid` mediumint(8) unsigned NOT NULL default '0',
36  `extra_flags` smallint(5) unsigned NOT NULL default '0',
37  `at_login` smallint(5) unsigned NOT NULL default '0',
38  `zone` int(10) default NULL,
39  `death_expire_time` int(10) unsigned NOT NULL default '0',
40  `taxi_path` text,
41  `conquestPoints` int(10) unsigned NOT NULL default '0',
42  `totalHonorPoints` int(10) unsigned NOT NULL default '0',
43  `totalKills` int(10) unsigned NOT NULL default '0',
44  `todayKills` smallint(5) unsigned NOT NULL default '0',
45  `yesterdayKills` smallint(5) unsigned NOT NULL default '0',
46  `chosenTitle` int(10) unsigned NOT NULL default '0',
47  `watchedFaction` int(10) unsigned NOT NULL default '0',
48  `drunk` smallint(5) unsigned NOT NULL default '0',
49  `health` int(10) unsigned NOT NULL default '0',
50  `power1` int(10) unsigned NOT NULL default '0',
51  `power2` int(10) unsigned NOT NULL default '0',
52  `power3` int(10) unsigned NOT NULL default '0',
53  `power4` int(10) unsigned NOT NULL default '0',
54  `power5` int(10) unsigned NOT NULL default '0',
55  `power6` int(10) unsigned NOT NULL default '0',
56  `power7` int(10) unsigned NOT NULL default '0',
57  `power8` int(10) unsigned NOT NULL default '0',
58  `power9` int(10) unsigned NOT NULL default '0',
59  `power10` int(10) unsigned NOT NULL default '0',
60  `latency` mediumint(8) unsigned NOT NULL default '0',
61  `speccount` tinyint(3) unsigned NOT NULL default '1',
62  `activespec` tinyint(3) unsigned NOT NULL default '0',
63  `exploredZones` longtext,
64  `equipmentCache` longtext,
65  `knownTitles` longtext,
66  `actionBars` tinyint(3) unsigned NOT NULL default '0',
67  `currentPetSlot` tinyint(3) default NULL,
68  `petSlotUsed` bigint(10) default NULL,
69  `grantableLevels` tinyint(3) unsigned NOT NULL default '0',
70  `deleteInfos_Account` int(10) unsigned default NULL,
71  `deleteInfos_Name` varchar(12) default NULL,
72  `deleteDate` int(10) unsigned default NULL,
73  PRIMARY KEY  (`guid`),
74  KEY `idx_account` (`account`),
75  KEY `idx_online` (`online`),
76  KEY `idx_name` (`name`)
77) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';