QhhTTA4f

1-- Table structure for players
2-- ----------------------------
3DROP TABLE IF EXISTS `players`;
4CREATE TABLE `players`  (
5  `id` int(11) NOT NULL AUTO_INCREMENT,
6  `username` varchar(75) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT 'Avatar',
7  `figure` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT 'hr-828-31.ch-255-82.sh-3089-64.hd-180-10.lg-3058-64',
8  `motto` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT '',
9  `credits` int(11) NULL DEFAULT 5000,
10  `diamonds` int(11) NULL DEFAULT 0,
11  `duckets` int(11) NOT NULL DEFAULT 0,
12  `clouds` int(11) NOT NULL DEFAULT 0,
13  `rank` int(3) NULL DEFAULT 1,
14  `auth_ticket` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
15  `gender` enum('M','F') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'M',
16  `reg_timestamp` int(11) NOT NULL DEFAULT 0,
17  `reg_date` varchar(12) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT '10/06/2013',
18  `last_online` int(11) NULL DEFAULT 0,
19  `online` enum('1','0') CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT '0',
20  `password` varchar(72) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT '',
21  `email` varchar(72) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT '',
22  `last_ip` varchar(72) CHARACTER SET latin1 COLLATE latin1_bin NULL DEFAULT '',
23  `unique_id` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
24  `vip_end` int(11) NOT NULL DEFAULT 1904294866,
25  `achievement_points` int(11) NULL DEFAULT 0,
26  `favourite_group` int(11) NULL DEFAULT 0,
27  `chat_ticket` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT '',
28  `quest_id` int(11) NULL DEFAULT 0,
29  `time_muted` int(11) NOT NULL DEFAULT 0,
30  `hiderank` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
31  `prefix_name` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
32  `has_nux_steps` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
33  PRIMARY KEY (`id`) USING BTREE
34) ENGINE = InnoDB AUTO_INCREMENT = 2220 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;