hYpYsYAH

1CREATE TABLE IF NOT EXISTS `players` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `name` varchar(255) NOT NULL,
4  `group_id` int(11) NOT NULL DEFAULT '1',
5  `account_id` int(11) NOT NULL DEFAULT '0',
6  `level` int(11) NOT NULL DEFAULT '1',
7  `vocation` int(11) NOT NULL DEFAULT '0',
8  `health` int(11) NOT NULL DEFAULT '150',
9  `healthmax` int(11) NOT NULL DEFAULT '150',
10  `experience` bigint(20) NOT NULL DEFAULT '0',
11  `lookbody` int(11) NOT NULL DEFAULT '0',
12  `lookfeet` int(11) NOT NULL DEFAULT '0',
13  `lookhead` int(11) NOT NULL DEFAULT '0',
14  `looklegs` int(11) NOT NULL DEFAULT '0',
15  `looktype` int(11) NOT NULL DEFAULT '136',
16  `lookaddons` int(11) NOT NULL DEFAULT '0',
17  `maglevel` int(11) NOT NULL DEFAULT '0',
18  `mana` int(11) NOT NULL DEFAULT '0',
19  `manamax` int(11) NOT NULL DEFAULT '0',
20  `manaspent` int(11) unsigned NOT NULL DEFAULT '0',
21  `soul` int(10) unsigned NOT NULL DEFAULT '0',
22  `town_id` int(11) NOT NULL DEFAULT '0',
23  `posx` int(11) NOT NULL DEFAULT '0',
24  `posy` int(11) NOT NULL DEFAULT '0',
25  `posz` int(11) NOT NULL DEFAULT '0',
26  `conditions` blob NOT NULL,
27  `cap` int(11) NOT NULL DEFAULT '0',
28  `sex` int(11) NOT NULL DEFAULT '0',
29  `lastlogin` bigint(20) unsigned NOT NULL DEFAULT '0',
30  `lastip` int(10) unsigned NOT NULL DEFAULT '0',
31  `save` tinyint(1) NOT NULL DEFAULT '1',
32  `skull` tinyint(1) NOT NULL DEFAULT '0',
33  `skulltime` int(11) NOT NULL DEFAULT '0',
34  `lastlogout` bigint(20) unsigned NOT NULL DEFAULT '0',
35  `blessings` tinyint(2) NOT NULL DEFAULT '0',
36  `onlinetime` int(11) NOT NULL DEFAULT '0',
37  `deletion` bigint(15) NOT NULL DEFAULT '0',
38  `balance` bigint(20) unsigned NOT NULL DEFAULT '0',
39  `offlinetraining_time` smallint(5) unsigned NOT NULL DEFAULT '43200',
40  `offlinetraining_skill` int(11) NOT NULL DEFAULT '-1',
41  `stamina` smallint(5) unsigned NOT NULL DEFAULT '3360',
42  `skill_fist` int(10) unsigned NOT NULL DEFAULT 10,
43  `skill_fist_tries` bigint(20) unsigned NOT NULL DEFAULT 0,
44  `skill_club` int(10) unsigned NOT NULL DEFAULT 10,
45  `skill_club_tries` bigint(20) unsigned NOT NULL DEFAULT 0,
46  `skill_sword` int(10) unsigned NOT NULL DEFAULT 10,
47  `skill_sword_tries` bigint(20) unsigned NOT NULL DEFAULT 0,
48  `skill_axe` int(10) unsigned NOT NULL DEFAULT 10,
49  `skill_axe_tries` bigint(20) unsigned NOT NULL DEFAULT 0,
50  `skill_dist` int(10) unsigned NOT NULL DEFAULT 10,
51  `skill_dist_tries` bigint(20) unsigned NOT NULL DEFAULT 0,
52  `skill_shielding` int(10) unsigned NOT NULL DEFAULT 10,
53  `skill_shielding_tries` bigint(20) unsigned NOT NULL DEFAULT 0,
54  `skill_fishing` int(10) unsigned NOT NULL DEFAULT 10,
55  `skill_fishing_tries` bigint(20) unsigned NOT NULL DEFAULT 0,
56  PRIMARY KEY (`id`),
57  UNIQUE KEY `name` (`name`),
58  FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
59  KEY `vocation` (`vocation`)
60) ENGINE=InnoDB;