RXzNEvuq

1DROP TABLE IF EXISTS `characters`;
2CREATE TABLE `characters` (
3  `account_name` varchar(45) DEFAULT NULL,
4  `obj_Id` int(10) unsigned NOT NULL DEFAULT '0',
5  `char_name` varchar(35) NOT NULL,
6  `level` tinyint(3) unsigned DEFAULT NULL,
7  `maxHp` mediumint(8) unsigned DEFAULT NULL,
8  `curHp` mediumint(8) unsigned DEFAULT NULL,
9  `maxCp` mediumint(8) unsigned DEFAULT NULL,
10  `curCp` mediumint(8) unsigned DEFAULT NULL,
11  `maxMp` mediumint(8) unsigned DEFAULT NULL,
12  `curMp` mediumint(8) unsigned DEFAULT NULL,
13  `face` tinyint(3) unsigned DEFAULT NULL,
14  `hairStyle` tinyint(3) unsigned DEFAULT NULL,
15  `hairColor` tinyint(3) unsigned DEFAULT NULL,
16  `sex` tinyint(3) unsigned DEFAULT NULL,
17  `heading` mediumint(9) DEFAULT NULL,
18  `x` mediumint(9) DEFAULT NULL,
19  `y` mediumint(9) DEFAULT NULL,
20  `z` mediumint(9) DEFAULT NULL,
21  `exp` bigint(20) unsigned DEFAULT '0',
22  `expBeforeDeath` bigint(20) unsigned DEFAULT '0',
23  `sp` int(10) unsigned NOT NULL DEFAULT '0',
24  `karma` int(10) unsigned DEFAULT NULL,
25  `pvpkills` smallint(5) unsigned DEFAULT NULL,
26  `pkkills` smallint(5) unsigned DEFAULT NULL,
27  `clanid` int(10) unsigned DEFAULT NULL,
28  `race` tinyint(3) unsigned DEFAULT NULL,
29  `classid` tinyint(3) unsigned DEFAULT NULL,
30  `base_class` tinyint(3) unsigned NOT NULL DEFAULT '0',
31  `deletetime` bigint(20) DEFAULT NULL,
32  `cancraft` tinyint(3) unsigned DEFAULT NULL,
33  `title` varchar(16) DEFAULT NULL,
34  `rec_have` tinyint(3) unsigned NOT NULL DEFAULT '0',
35  `rec_left` tinyint(3) unsigned NOT NULL DEFAULT '0',
36  `accesslevel` mediumint(9) DEFAULT '0',
37  `online` tinyint(3) unsigned DEFAULT NULL,
38  `onlinetime` int(11) DEFAULT NULL,
39  `char_slot` tinyint(3) unsigned DEFAULT NULL,
40  `lastAccess` bigint(20) unsigned DEFAULT NULL,
41  `clan_privs` mediumint(8) unsigned DEFAULT '0',
42  `wantspeace` tinyint(3) unsigned DEFAULT '0',
43  `isin7sdungeon` tinyint(3) unsigned NOT NULL DEFAULT '0',
44  `punish_level` tinyint(3) unsigned NOT NULL DEFAULT '0',
45  `punish_timer` bigint(20) unsigned NOT NULL DEFAULT '0',
46  `power_grade` tinyint(3) unsigned DEFAULT NULL,
47  `nobless` tinyint(3) unsigned NOT NULL DEFAULT '0',
48  `hero` tinyint(3) unsigned NOT NULL DEFAULT '0',
49  `subpledge` smallint(6) NOT NULL DEFAULT '0',
50  `last_recom_date` bigint(20) unsigned NOT NULL DEFAULT '0',
51  `lvl_joined_academy` tinyint(3) unsigned NOT NULL DEFAULT '0',
52  `apprentice` int(10) unsigned NOT NULL DEFAULT '0',
53  `sponsor` int(10) unsigned NOT NULL DEFAULT '0',
54  `varka_ketra_ally` tinyint(4) NOT NULL DEFAULT '0',
55  `clan_join_expiry_time` bigint(20) unsigned NOT NULL DEFAULT '0',
56  `clan_create_expiry_time` bigint(20) unsigned NOT NULL DEFAULT '0',
57  `death_penalty_level` smallint(5) unsigned NOT NULL DEFAULT '0',
58  `nameColor` varchar(6) NOT NULL DEFAULT 'FFFFFF',
59  `titleColor` varchar(6) NOT NULL DEFAULT 'FFFF77',
60  `isBlockExperience` tinyint(1) NOT NULL DEFAULT '0',
61  `isBlockAutoLoot` tinyint(1) NOT NULL DEFAULT '1',
62  `isBlockPrivateMessages` tinyint(1) NOT NULL DEFAULT '0',
63  `isBlockBuffs` tinyint(1) NOT NULL DEFAULT '0',
64  PRIMARY KEY (`obj_Id`),
65  KEY `clanid` (`clanid`)
66) ENGINE=InnoDB DEFAULT CHARSET=utf8;