· 6 years ago · Mar 23, 2019, 06:24 PM
1DROP TABLE IF EXISTS `users`;
2CREATE TABLE `users` (
3 `id` int(11) NOT NULL AUTO_INCREMENT,
4 `username` varchar(125) NOT NULL,
5 `password` varchar(255) DEFAULT NULL,
6 `mail` varchar(255) DEFAULT 'defaultuser@meth0d.org',
7 `rank` int(1) unsigned DEFAULT '1',
8 `rank_vip` int(1) DEFAULT '0',
9 `credits` int(11) NOT NULL DEFAULT '50000',
10 `vip_points` int(11) DEFAULT '0',
11 `activity_points` int(11) DEFAULT '5000',
12 `look` varchar(255) DEFAULT NULL COMMENT 'hd-3092-3.ha-987462863-62.sh-6102459-92-110.ea-6136543-110.hr-987462893-1041.ch-235-1334.lg-6050208-1189',
13 `gender` enum('M','F') DEFAULT 'M',
14 `motto` char(50) DEFAULT NULL,
15 `account_created` char(12) DEFAULT '0',
16 `last_online` int(11) DEFAULT '0',
17 `online` enum('0','1') DEFAULT '0',
18 `ip_reg` varchar(45) DEFAULT '',
19 `ip_last` varchar(45) DEFAULT '',
20 `home_room` int(10) DEFAULT '2',
21 `is_muted` enum('0','1') DEFAULT '0',
22 `block_newfriends` enum('0','1') DEFAULT '0',
23 `hide_online` enum('0','1') DEFAULT '0',
24 `hide_inroom` enum('0','1') DEFAULT '0',
25 `vip` enum('0','1') DEFAULT '0',
26 `volume` varchar(15) DEFAULT '100,100,100',
27 `last_change` int(20) DEFAULT '0',
28 `machine_id` varchar(125) DEFAULT '',
29 `focus_preference` enum('0','1') DEFAULT '0',
30 `chat_preference` enum('0','1') DEFAULT '0',
31 `pets_muted` enum('0','1') DEFAULT '0',
32 `bots_muted` enum('0','1') DEFAULT '0',
33 `advertising_report_blocked` enum('0','1') DEFAULT '0',
34 `gotw_points` int(11) DEFAULT '0',
35 `bot_frank` enum('true','false') NOT NULL DEFAULT 'false',
36 `ignore_invites` enum('0','1') DEFAULT '0',
37 `time_muted` double DEFAULT '0',
38 `allow_gifts` enum('0','1') DEFAULT '1',
39 `trading_locked` double DEFAULT '0',
40 `friend_bar_state` enum('0','1') NOT NULL DEFAULT '1',
41 `disable_forced_effects` enum('0','1') NOT NULL DEFAULT '0',
42 `allow_mimic` enum('1','0') NOT NULL DEFAULT '1',
43 `publi` enum('0','1','2','3') NOT NULL DEFAULT '0',
44 `guia` enum('0','1','2','3','4') NOT NULL DEFAULT '0',
45 `tarea` varchar(50) NOT NULL DEFAULT '0',
46 `cms_signature` text,
47 `cms_currency` int(99) NOT NULL DEFAULT '0',
48 `key_colour` int(11) NOT NULL DEFAULT '0',
49 `userpo` int(99) NOT NULL DEFAULT '0',
50 `user_points` int(99) NOT NULL DEFAULT '0',
51 `acc_flagged` enum('0','1') NOT NULL DEFAULT '0',
52 `country` text,
53 `radio` varchar(100) NOT NULL DEFAULT 'autoplay',
54 `bancobloq` int(99) NOT NULL DEFAULT '0',
55 `builder` enum('0','1') DEFAULT '0',
56 `croupier` enum('1','0') DEFAULT '0',
57 `nux_user` enum('true','false') DEFAULT 'true',
58 `pumpkins` int(11) DEFAULT '0',
59 `seckey` varchar(999) DEFAULT NULL,
60 `job` varchar(50) DEFAULT NULL,
61 `hidden` enum('0','1') DEFAULT '0',
62 `pin` varchar(255) DEFAULT '0',
63 `hulptroepen` int(1) unsigned DEFAULT '0',
64 `camera_count` int(1) DEFAULT '0',
65 `teamrank` int(1) DEFAULT '0',
66 `fbid` varchar(255) DEFAULT '0',
67 `fbenable` enum('0','1','3','2') DEFAULT '2',
68 `auth_ticket` varchar(60) DEFAULT NULL,
69 PRIMARY KEY (`id`),
70 UNIQUE KEY `id` (`id`) USING HASH,
71 UNIQUE KEY `username` (`username`) USING BTREE,
72 KEY `rank` (`rank`),
73 KEY `ip_last` (`ip_last`),
74 KEY `ip_reg` (`ip_reg`),
75 KEY `credits` (`credits`),
76 KEY `activity_points` (`activity_points`),
77 KEY `online` (`online`),
78 KEY `mail` (`mail`),
79 KEY `machine_id` (`machine_id`),
80 KEY `auth_ticket` (`auth_ticket`),
81 KEY `last_online` (`last_online`),
82 KEY `home_room` (`home_room`),
83 KEY `rank_vip` (`rank_vip`),
84 KEY `messenger` (`id`,`username`,`look`,`motto`,`last_online`) USING BTREE
85) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=latin1;