wVYJ7X9L

· 8 years ago · Nov 29, 2017, 09:30 AM
1DROP TABLE IF EXISTS `characters`; 
2CREATE TABLE `characters` ( // linha 1117
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  `race` tinyint(3) unsigned DEFAULT NULL,
28  `classid` tinyint(3) unsigned DEFAULT NULL,
29  `base_class` tinyint(3) unsigned NOT NULL DEFAULT '0',
30  `deletetime` bigint(20) DEFAULT NULL,
31  `cancraft` tinyint(3) unsigned DEFAULT NULL,
32  `title` varchar(16) DEFAULT NULL,
33  `rec_have` tinyint(3) unsigned NOT NULL DEFAULT '0',
34  `rec_left` tinyint(3) unsigned NOT NULL DEFAULT '0',
35  `accesslevel` mediumint(9) DEFAULT '0',
36  `online` tinyint(3) unsigned DEFAULT NULL,
37  `onlinetime` int(11) DEFAULT NULL,
38  `char_slot` tinyint(3) unsigned DEFAULT NULL,
39  `lastAccess` bigint(20) unsigned DEFAULT NULL,
40  `punish_level` tinyint(3) unsigned NOT NULL DEFAULT '0',
41  `punish_timer` int(10) unsigned NOT NULL DEFAULT '0',
42  `power_grade` tinyint(3) unsigned DEFAULT NULL,
43  `nobless` tinyint(3) unsigned NOT NULL DEFAULT '0',
44  `hero` tinyint(3) unsigned NOT NULL DEFAULT '0',
45  `last_recom_date` bigint(20) unsigned NOT NULL DEFAULT '0'
46  PRIMARY KEY (`obj_Id`)
47) ENGINE=InnoDB DEFAULT CHARSET=utf8;
48
49-- ----------------------------
50-- Records of characters
51-- ----------------------------
52INSERT INTO `characters` VALUES ('test', '268438558', 'fadsfdsfas', '1', '0', '91', '0', '36', '0', '35', '0', '0', '0', '0', '19412', '39310', '38838', '-3603', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
53INSERT INTO `characters` VALUES ('test', '268439333', 'Human', '1', '91', '91', '36', '36', '35', '35', '0', '0', '0', '0', '7098', '-71485', '258227', '-3109', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '1', null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
54INSERT INTO `characters` VALUES ('test', '268439334', 'HumanMage', '1', '116', '116', '58', '58', '47', '47', '0', '1', '0', '0', '43999', '-90943', '248262', '-3596', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10', '0', '0', '', '0', '0', '0', '0', '0', '2', null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
55INSERT INTO `characters` VALUES ('test', '268439335', 'Elf', '1', '101', '101', '40', '40', '35', '35', '0', '0', '0', '0', '14150', '46484', '41306', '-3508', '0', '0', '0', '0', '0', '0', '0', '1', '18', '18', '0', '0', '', '0', '0', '0', '0', '0', '3', null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
56INSERT INTO `characters` VALUES ('test', '268439336', 'dElf', '1', '107', '0', '43', '43', '35', '35', '0', '0', '0', '0', '49073', '28109', '10914', '-4233', '0', '0', '0', '0', '0', '0', '0', '2', '31', '31', '0', '0', '', '0', '0', '0', '0', '0', '4', null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
57INSERT INTO `characters` VALUES ('test', '268439337', 'Orcey', '1', '92', '92', '46', '46', '35', '35', '0', '0', '0', '0', '17097', '-55792', '-113585', '-672', '0', '0', '0', '0', '0', '0', '0', '3', '44', '44', '0', '0', '', '0', '0', '0', '0', '0', '5', null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
58INSERT INTO `characters` VALUES ('test', '268439338', 'Dwarf', '1', '92', '92', '64', '64', '35', '35', '0', '0', '0', '0', '14827', '109312', '-173797', '-559', '0', '0', '0', '0', '0', '0', '0', '4', '53', '53', '0', '0', '', '0', '0', '0', '0', '0', '6', null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
59INSERT INTO `characters` VALUES ('elfo', '268440114', 'Elfocrash', '1', '91', '91', '36', '36', '35', '35', '0', '0', '0', '0', '15167', '-71871', '257680', '-3115', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
60INSERT INTO `characters` VALUES ('elfo', '268440890', 'Inventotest', '1', '91', '91', '36', '36', '35', '35', '0', '0', '0', '0', '40514', '-72607', '256924', '-3115', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '1', null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');