bWm32w20

1CREATE TABLE IF NOT EXISTS `characters` (
2  `account_name` VARCHAR(45) DEFAULT NULL,
3  `charId` INT UNSIGNED NOT NULL DEFAULT 0,
4  `char_name` VARCHAR(35) NOT NULL,
5  `level` TINYINT UNSIGNED DEFAULT NULL,
6  `maxHp` MEDIUMINT UNSIGNED DEFAULT NULL,
7  `curHp` MEDIUMINT UNSIGNED DEFAULT NULL,
8  `maxCp` MEDIUMINT UNSIGNED DEFAULT NULL,
9  `curCp` MEDIUMINT UNSIGNED DEFAULT NULL,
10  `maxMp` MEDIUMINT UNSIGNED DEFAULT NULL,
11  `curMp` MEDIUMINT UNSIGNED DEFAULT NULL,
12  `face` TINYINT UNSIGNED DEFAULT NULL,
13  `hairStyle` TINYINT UNSIGNED DEFAULT NULL,
14  `hairColor` TINYINT UNSIGNED DEFAULT NULL,
15  `sex` TINYINT UNSIGNED DEFAULT NULL,
16  `heading` MEDIUMINT DEFAULT NULL,
17  `x` MEDIUMINT DEFAULT NULL,
18  `y` MEDIUMINT DEFAULT NULL,
19  `z` MEDIUMINT DEFAULT NULL,
20  `exp` BIGINT UNSIGNED DEFAULT 0,
21  `expBeforeDeath` BIGINT UNSIGNED DEFAULT 0,
22  `sp` BIGINT(10) UNSIGNED NOT NULL DEFAULT 0,
23  `reputation` INT DEFAULT NULL,
24  `fame` MEDIUMINT UNSIGNED NOT NULL DEFAULT 0,
25  `raidbossPoints` MEDIUMINT UNSIGNED NOT NULL DEFAULT 0,
26  `pvpkills` SMALLINT UNSIGNED DEFAULT NULL,
27  `pkkills` SMALLINT UNSIGNED DEFAULT NULL,
28  `clanid` INT UNSIGNED DEFAULT NULL,
29  `race` TINYINT UNSIGNED DEFAULT NULL,
30  `classid` TINYINT UNSIGNED DEFAULT NULL,
31  `base_class` TINYINT UNSIGNED NOT NULL DEFAULT 0,
32  `transform_id` SMALLINT UNSIGNED NOT NULL DEFAULT 0,
33  `deletetime` bigint(13) unsigned NOT NULL DEFAULT '0',
34  `cancraft` TINYINT UNSIGNED DEFAULT NULL,
35  `title` VARCHAR(21) DEFAULT NULL,
36  `title_color` MEDIUMINT UNSIGNED NOT NULL DEFAULT 0xECF9A2,
37  `accesslevel` MEDIUMINT DEFAULT 0,
38  `online` TINYINT UNSIGNED DEFAULT NULL,
39  `onlinetime` INT DEFAULT NULL,
40  `char_slot` TINYINT UNSIGNED DEFAULT NULL,
41  `lastAccess` bigint(13) unsigned NOT NULL DEFAULT '0',
42  `clan_privs` MEDIUMINT UNSIGNED DEFAULT 0,
43  `wantspeace` TINYINT UNSIGNED DEFAULT 0,
44  `power_grade` TINYINT UNSIGNED DEFAULT NULL,
45  `nobless` TINYINT UNSIGNED NOT NULL DEFAULT 0,
46  `subpledge` SMALLINT NOT NULL DEFAULT 0,
47  `lvl_joined_academy` TINYINT UNSIGNED NOT NULL DEFAULT 0,
48  `apprentice` INT UNSIGNED NOT NULL DEFAULT 0,
49  `sponsor` INT UNSIGNED NOT NULL DEFAULT 0,
50  `clan_join_expiry_time` bigint(13) unsigned NOT NULL DEFAULT '0',
51  `clan_create_expiry_time` bigint(13) unsigned NOT NULL DEFAULT '0',
52  `bookmarkslot` SMALLINT UNSIGNED NOT NULL DEFAULT 0,
53  `vitality_points` MEDIUMINT UNSIGNED NOT NULL DEFAULT 0,
54  `createDate` date NOT NULL DEFAULT '1970-01-01',
55  `language` VARCHAR(2) DEFAULT NULL,
56  PRIMARY KEY (`charId`),
57  KEY `account_name` (`account_name`),
58  KEY `char_name` (`char_name`),
59  KEY `clanid` (`clanid`),
60  KEY `online` (`online`)
61) ENGINE=InnoDB DEFAULT CHARSET=utf8;