· 6 years ago · Jul 13, 2019, 07:34 PM
1-- ----------------------------
2-- Table structure for `users`
3-- ----------------------------
4DROP TABLE IF EXISTS `users`;
5CREATE TABLE `users` (
6 `id` int(11) NOT NULL AUTO_INCREMENT,
7 `username` varchar(125) NOT NULL,
8 `password` varchar(255) NOT NULL,
9 `mail` varchar(255) DEFAULT 'mail@hobbaz.me',
10 `account_security` varchar(255) DEFAULT NULL,
11 `real_name` text,
12 `auth_ticket` varchar(200) DEFAULT NULL,
13 `rank` int(1) unsigned DEFAULT '2',
14 `rank_vip` int(1) DEFAULT '3',
15 `credits` int(11) DEFAULT '0',
16 `seasonal_currency` int(11) DEFAULT '0',
17 `vip_points` int(11) DEFAULT '0',
18 `jetons` int(11) DEFAULT '0',
19 `activity_points` int(11) DEFAULT '0',
20 `look` char(255) DEFAULT NULL,
21 `gender` enum('M','F') DEFAULT 'M',
22 `motto` char(50) DEFAULT NULL,
23 `account_created` char(12) DEFAULT '0',
24 `last_online` int(11) DEFAULT '0',
25 `online` enum('0','1') DEFAULT '0',
26 `ip_last` varchar(45) DEFAULT '',
27 `ip_reg` varchar(45) DEFAULT NULL,
28 `home_room` int(16) DEFAULT '1',
29 `is_muted` enum('0','1') DEFAULT '0',
30 `hide_online` enum('0','1') DEFAULT '0',
31 `hide_inroom` enum('0','1') DEFAULT '0',
32 `vip` enum('0','1') DEFAULT '1',
33 `volume` varchar(15) DEFAULT '100,100,100',
34 `last_change` int(20) DEFAULT '0',
35 `machine_id` varchar(125) DEFAULT '',
36 `gotw_points` int(11) DEFAULT '0',
37 `time_muted` double DEFAULT '0',
38 `trading_locked` double DEFAULT '0',
39 `seckey` varchar(999) DEFAULT NULL,
40 `hote_id` int(11) DEFAULT NULL,
41 `avatars` int(11) DEFAULT '49',
42 `show_staff_event_notif` tinyint(1) DEFAULT '1',
43 `nux_user` enum('false','true') DEFAULT 'true' COMMENT 'Tutoriel',
44 `pets_muted` tinyint(1) DEFAULT '0',
45 `motto_staff` text,
46 `block_newfriends` int(11) DEFAULT NULL,
47 `bot_frank` int(11) DEFAULT '0',
48 `talent_status
49talent_status
50talent_status` enum('helper','citizenship') DEFAULT 'citizenship',
51 `last_offline` double DEFAULT NULL,
52 `allow_mimic` enum('1','0') NOT NULL DEFAULT '1',
53 `disabled` int(6) DEFAULT NULL,
54 `remember_token` varchar(250) DEFAULT NULL,
55 `function` varchar(100) DEFAULT NULL,
56 `facebook` text,
57 `premium_time` int(25) DEFAULT NULL,
58 `background_staff` text,
59 `rank_id` int(11) DEFAULT NULL,
60 PRIMARY KEY (`id`),
61 UNIQUE KEY `id` (`id`) USING HASH,
62 UNIQUE KEY `username` (`username`) USING BTREE,
63 KEY `rank` (`rank`),
64 KEY `ip_last` (`ip_last`),
65 KEY `ip_reg` (`ip_reg`),
66 KEY `credits` (`credits`),
67 KEY `activity_points` (`activity_points`),
68 KEY `online` (`online`),
69 KEY `machine_id` (`machine_id`),
70 KEY `auth_ticket` (`auth_ticket`),
71 KEY `last_online` (`last_online`),
72 KEY `home_room` (`home_room`),
73 KEY `rank_vip` (`rank_vip`),
74 KEY `messenger` (`id`,`username`,`look`,`motto`,`last_online`) USING BTREE
75) ENGINE=InnoDB DEFAULT CHARSET=latin1;