· 8 years ago · May 14, 2018, 04:08 AM
1DROP TABLE IF EXISTS `players`;
2CREATE TABLE `players` (
3 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
4 `name` varchar(255) NOT NULL DEFAULT '',
5 `account_id` int(10) unsigned NOT NULL DEFAULT '0',
6 `group_id` int(10) unsigned NOT NULL DEFAULT '0',
7 `sex` int(10) unsigned NOT NULL DEFAULT '0',
8 `vocation` int(10) unsigned NOT NULL DEFAULT '0',
9 `experience` bigint(20) unsigned NOT NULL DEFAULT '0',
10 `level` int(10) unsigned NOT NULL DEFAULT '1',
11 `maglevel` int(10) unsigned NOT NULL DEFAULT '0',
12 `health` int(10) unsigned NOT NULL DEFAULT '100',
13 `healthmax` int(10) unsigned NOT NULL DEFAULT '100',
14 `mana` int(10) unsigned NOT NULL DEFAULT '100',
15 `manamax` int(10) unsigned NOT NULL DEFAULT '100',
16 `manaspent` int(10) unsigned NOT NULL DEFAULT '0',
17 `soul` int(10) unsigned NOT NULL DEFAULT '0',
18 `direction` int(10) unsigned NOT NULL DEFAULT '0',
19 `lookbody` int(10) unsigned NOT NULL DEFAULT '10',
20 `lookfeet` int(10) unsigned NOT NULL DEFAULT '10',
21 `lookhead` int(10) unsigned NOT NULL DEFAULT '10',
22 `looklegs` int(10) unsigned NOT NULL DEFAULT '10',
23 `looktype` int(10) unsigned NOT NULL DEFAULT '136',
24 `lookaddons` int(10) unsigned NOT NULL DEFAULT '0',
25 `posx` int(11) NOT NULL DEFAULT '0',
26 `posy` int(11) NOT NULL DEFAULT '0',
27 `posz` int(11) NOT NULL DEFAULT '0',
28 `cap` int(11) NOT NULL DEFAULT '0',
29 `lastlogin` int(10) unsigned NOT NULL DEFAULT '0',
30 `lastlogout` int(10) unsigned NOT NULL DEFAULT '0',
31 `lastip` int(10) unsigned NOT NULL DEFAULT '0',
32 `save` tinyint(1) NOT NULL DEFAULT '1',
33 `conditions` blob NOT NULL,
34 `redskulltime` int(10) unsigned NOT NULL DEFAULT '0',
35 `redskull` tinyint(1) NOT NULL DEFAULT '0',
36 `guildnick` varchar(255) NOT NULL DEFAULT '',
37 `loss_experience` int(11) NOT NULL DEFAULT '100',
38 `loss_mana` int(11) NOT NULL DEFAULT '100',
39 `loss_skills` int(11) NOT NULL DEFAULT '100',
40 `loss_items` int(11) NOT NULL DEFAULT '10',
41 `loss_containers` int(11) NOT NULL DEFAULT '100',
42 `rank_id` int(10) unsigned NOT NULL DEFAULT '0',
43 `town_id` int(11) NOT NULL DEFAULT '0',
44 `balance` int(11) NOT NULL DEFAULT '0',
45 `stamina` int(11) NOT NULL DEFAULT '151200000',
46 PRIMARY KEY (`id`)
47) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
48
49--
50-- Dumping data for table `players`
51--
52
53/*!40000 ALTER TABLE `players` DISABLE KEYS */;
54INSERT INTO `players` (`id`,`name`,`account_id`,`group_id`,`sex`,`vocation`,`experience`,`level`,`maglevel`,`health`,`healthmax`,`mana`,`manamax`,`manaspent`,`soul`,`direction`,`lookbody`,`lookfeet`,`lookhead`,`looklegs`,`looktype`,`lookaddons`,`posx`,`posy`,`posz`,`cap`,`lastlogin`,`lastlogout`,`lastip`,`save`,`conditions`,`redskulltime`,`redskull`,`guildnick`,`loss_experience`,`loss_mana`,`loss_skills`,`loss_items`,`loss_containers`,`rank_id`,`town_id`,`balance`,`stamina`) VALUES
55 (2,'Rob',1,3,1,1,1955550,50,99,395,395,1295,1295,33578,3,0,76,114,57,76,130,0,33147,32526,6,10000,1279714897,1279714965,2550245568,1,0x0100010000020000000003608326001B001C0000000010D7000000110A00000012E0AB00001320EB0300FE,0,0,'',10,10,10,10,10,0,3,0,151200000),
56 (3,'Marcin',2,3,1,2,946500,40,99,390,390,1265,1265,444999,4,2,114,114,59,114,134,0,33141,32524,7,10000,1279751923,1279751927,2550245568,1,0x010001000002000000000308C217001B001C0000000010D7000000110A00000012B80B00001360610200FE0110000000020000000003E02E00001B001C000000000BEB0100000C9A99193F0D000048C20E9A99193F0F000048C2FE,0,0,'',10,10,10,10,10,0,2,0,151160000),
57 (4,'Newplayer',2,1,1,1,28568985,121,24,750,750,2525,3425,6004,100,2,10,10,10,10,133,0,32954,32036,6,1600,1279751032,1279751138,2550245568,1,0x010000800002FFFFFFFF03000000001B001C00000000FE010000200002FFFFFFFF03000000001B001C00000000FE,0,0,'',100,100,100,10,100,0,3,0,151200000),
58 (5,'Derk',3,1,1,1,852637,39,14,340,340,65,965,1746,0,3,10,10,10,10,128,0,32943,32053,6,10000,1279750779,1279751015,2550245568,1,'',0,0,'',100,100,100,10,100,0,3,0,151200000);
59/*!40000 ALTER TABLE `players` ENABLE KEYS */;