· 8 years ago · Nov 23, 2017, 08:50 PM
1DROP TABLE IF EXISTS `characters`;
2CREATE TABLE `characters` (
3 `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
4 `account` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Account Identifier',
5 `name` varchar(12) NOT NULL DEFAULT '',
6 `race` tinyint(3) unsigned NOT NULL DEFAULT '0',
7 `class` tinyint(3) unsigned NOT NULL DEFAULT '0',
8 `gender` tinyint(3) unsigned NOT NULL DEFAULT '0',
9 `level` tinyint(3) unsigned NOT NULL DEFAULT '0',
10 `xp` int(10) unsigned NOT NULL DEFAULT '0',
11 `money` int(10) unsigned NOT NULL DEFAULT '0',
12 `playerBytes` int(10) unsigned NOT NULL DEFAULT '0',
13 `playerBytes2` int(10) unsigned NOT NULL DEFAULT '0',
14 `playerFlags` int(10) unsigned NOT NULL DEFAULT '0',
15 `position_x` float NOT NULL DEFAULT '0',
16 `position_y` float NOT NULL DEFAULT '0',
17 `position_z` float NOT NULL DEFAULT '0',
18 `map` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',
19 `orientation` float NOT NULL DEFAULT '0',
20 `taximask` longtext,
21 `online` tinyint(3) unsigned NOT NULL DEFAULT '0',
22 `cinematic` tinyint(3) unsigned NOT NULL DEFAULT '0',
23 `totaltime` int(11) unsigned NOT NULL DEFAULT '0',
24 `leveltime` int(11) unsigned NOT NULL DEFAULT '0',
25 `logout_time` bigint(20) unsigned NOT NULL DEFAULT '0',
26 `is_logout_resting` tinyint(3) unsigned NOT NULL DEFAULT '0',
27 `rest_bonus` float NOT NULL DEFAULT '0',
28 `resettalents_multiplier` int(11) unsigned NOT NULL DEFAULT '0',
29 `resettalents_time` bigint(20) unsigned NOT NULL DEFAULT '0',
30 `trans_x` float NOT NULL DEFAULT '0',
31 `trans_y` float NOT NULL DEFAULT '0',
32 `trans_z` float NOT NULL DEFAULT '0',
33 `trans_o` float NOT NULL DEFAULT '0',
34 `transguid` bigint(20) unsigned NOT NULL DEFAULT '0',
35 `extra_flags` int(11) unsigned NOT NULL DEFAULT '0',
36 `stable_slots` tinyint(1) unsigned NOT NULL DEFAULT '0',
37 `at_login` int(11) unsigned NOT NULL DEFAULT '0',
38 `zone` int(11) unsigned NOT NULL DEFAULT '0',
39 `death_expire_time` bigint(20) unsigned NOT NULL DEFAULT '0',
40 `taxi_path` text,
41 `honorRankPoints` float NOT NULL DEFAULT '0',
42 `honorHighestRank` int(11) unsigned NOT NULL DEFAULT '0',
43 `honorStanding` int(11) unsigned NOT NULL DEFAULT '0',
44 `honorLastWeekHK` int(11) unsigned NOT NULL DEFAULT '0',
45 `honorLastWeekCP` float NOT NULL DEFAULT '0',
46 `honorStoredHK` int(11) NOT NULL DEFAULT '0',
47 `honorStoredDK` int(11) NOT NULL DEFAULT '0',
48 `watchedFaction` int(10) unsigned NOT NULL DEFAULT '0',
49 `drunk` smallint(5) unsigned NOT NULL DEFAULT '0',
50 `health` int(10) unsigned NOT NULL DEFAULT '0',
51 `power1` int(10) unsigned NOT NULL DEFAULT '0',
52 `power2` int(10) unsigned NOT NULL DEFAULT '0',
53 `power3` int(10) unsigned NOT NULL DEFAULT '0',
54 `power4` int(10) unsigned NOT NULL DEFAULT '0',
55 `power5` int(10) unsigned NOT NULL DEFAULT '0',
56 `exploredZones` longtext,
57 `equipmentCache` longtext,
58 `ammoId` int(10) unsigned NOT NULL DEFAULT '0',
59 `actionBars` tinyint(3) unsigned NOT NULL DEFAULT '0',
60 `deleteInfos_Account` int(11) unsigned DEFAULT NULL,
61 `deleteInfos_Name` varchar(12) DEFAULT NULL,
62 `deleteDate` bigint(20) DEFAULT NULL,
63 `area` int(11) unsigned NOT NULL DEFAULT '0',
64 `world_phase_mask` int(11) DEFAULT '0',
65 `customFlags` int(11) NOT NULL DEFAULT '0',
66 PRIMARY KEY (`guid`),
67 KEY `idx_account` (`account`),
68 KEY `idx_online` (`online`),
69 KEY `idx_name` (`name`)
70) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';