· 6 years ago · Mar 22, 2019, 11:16 PM
1CREATE TABLE IF NOT EXISTS `users` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `user_id` int(250) DEFAULT NULL,
4 `username` varchar(125) NOT NULL,
5 `password` varchar(255) DEFAULT NULL,
6 `mail` varchar(255) DEFAULT 'defaultuser@meth0d.org',
7 `auth_ticket` varchar(60) NOT NULL,
8 `rank` int(1) unsigned DEFAULT '1',
9 `rank_vip` int(1) DEFAULT '0',
10 `credits` int(11) DEFAULT '99999',
11 `vip_points` int(11) DEFAULT '0',
12 `activity_points` int(11) DEFAULT '0',
13 `look` char(255) DEFAULT NULL,
14 `gender` enum('M','F') DEFAULT 'M',
15 `motto` char(50) DEFAULT NULL,
16 `account_created` char(12) DEFAULT '0',
17 `last_online` int(11) DEFAULT '0',
18 `online` enum('0','1') DEFAULT '0',
19 `ip_last` varchar(45) DEFAULT '',
20 `ip_reg` varchar(45) DEFAULT NULL,
21 `home_room` int(10) unsigned NOT NULL DEFAULT '1694',
22 `is_muted` enum('0','1') DEFAULT '0',
23 `block_newfriends` enum('0','1') DEFAULT '0',
24 `hide_online` enum('0','1') DEFAULT '0',
25 `hide_inroom` enum('0','1') DEFAULT '0',
26 `vip` enum('0','1') DEFAULT '0',
27 `volume` varchar(15) DEFAULT '100,100,100',
28 `last_change` int(20) DEFAULT '0',
29 `machine_id` varchar(125) DEFAULT '',
30 `focus_preference` enum('0','1') DEFAULT '0',
31 `chat_preference` enum('0','1') DEFAULT '0',
32 `pets_muted` enum('0','1') DEFAULT '0',
33 `bots_muted` enum('0','1') DEFAULT '0',
34 `advertising_report_blocked` enum('0','1') DEFAULT '0',
35 `gotw_points_honor` int(11) DEFAULT '0',
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 `allow_emoji` enum('1','0') NOT NULL DEFAULT '1',
44 `publi` enum('0','1','2','3') NOT NULL DEFAULT '0',
45 `guia` enum('0','1','2','3','4') NOT NULL DEFAULT '0',
46 `tarea` varchar(50) NOT NULL DEFAULT '0',
47 `cms_signature` text,
48 `cms_currency` int(99) NOT NULL,
49 `key_colour` int(11) NOT NULL DEFAULT '0',
50 `userpo` int(99) NOT NULL,
51 `user_points` int(99) NOT NULL,
52 `acc_flagged` enum('0','1') NOT NULL DEFAULT '0',
53 `country` text,
54 `radio` varchar(100) NOT NULL DEFAULT 'autoplay',
55 `bancobloq` int(99) NOT NULL,
56 `croupier` enum('0','1') NOT NULL DEFAULT '0',
57 `builder` enum('0','1') NOT NULL DEFAULT '0',
58 `facebook_id` varchar(100) NOT NULL DEFAULT '',
59 `nux_user` enum('true','false') DEFAULT 'true',
60 `nux_room` enum('true','false') NOT NULL DEFAULT 'true',
61 `mastertrade` enum('0','1','2','3','4') NOT NULL DEFAULT '0',
62 `pumpkins` int(11) DEFAULT '0',
63 `gotw_points_calabazas` int(11) DEFAULT '0',
64 `gotw_points` int(11) DEFAULT '0',
65 `targeted_buy` int(10) NOT NULL,
66 `namecolor` varchar(125) NOT NULL DEFAULT '000000',
67 `bonus_points` int(11) DEFAULT '0',
68 `nametag` varchar(125) NOT NULL,
69 `cde` enum('0','1','2','3') NOT NULL DEFAULT '0',
70 `gotw_points_huevo` int(11) DEFAULT '1',
71 `tagcolor` varchar(255) DEFAULT NULL,
72 `tag` varchar(255) DEFAULT NULL,
73 `quiz_passed` enum('1','0') DEFAULT '1',
74 `changename` enum('0','1') NOT NULL DEFAULT '1',
75 `cms_colab` int(11) DEFAULT NULL,
76 `pincode` varchar(255) NOT NULL,
77 `pin_client` varchar(255) NOT NULL,
78 `mysticdata` varchar(15) DEFAULT '100,100,100',
79 `email_verificado` enum('0','1') NOT NULL DEFAULT '0',
80 `cms_birthday` varchar(100) NOT NULL,
81 `cms_staffocult` enum('0','1') NOT NULL DEFAULT '0',
82 `cms_role` varchar(50) NOT NULL,
83 `cms_rank` varchar(150) NOT NULL DEFAULT 'Usuario',
84 `user_rank` int(11) NOT NULL DEFAULT '1',
85 `cms_pin` enum('0','1','2') NOT NULL DEFAULT '0',
86 `vip_time` int(11) NOT NULL,
87 `vip_mes` int(11) NOT NULL,
88 `cms_stories` int(50) NOT NULL DEFAULT '0',
89 `code_forgot` varchar(50) NOT NULL,
90 `cms_forgot_time` int(11) NOT NULL,
91 `user_fondo` varchar(500) NOT NULL DEFAULT '/app/assets/img/personal/bg_fondo.png',
92 `user_referrals` varchar(100) NOT NULL DEFAULT '0',
93 `user_new` enum('0','1') NOT NULL DEFAULT '0',
94 `loto_clicks` int(2) NOT NULL DEFAULT '1',
95 `respetos` int(5) NOT NULL DEFAULT '3',
96 `public_stories` enum('0','1') NOT NULL DEFAULT '0',
97 `swf_description` enum('0','1') NOT NULL DEFAULT '0',
98 `time_pass` int(11) NOT NULL,
99 `pin_act` enum('0','1') NOT NULL DEFAULT '0',
100 `pin_intentos` int(5) NOT NULL DEFAULT '3',
101 `pin_time` int(11) NOT NULL,
102 `cuenta_suspendida` enum('0','1') NOT NULL DEFAULT '0',
103 `premio` int(30) NOT NULL DEFAULT '0',
104 `puntos_eventos` int(30) NOT NULL DEFAULT '0',
105 `talent_status` enum('citizenship','helper') NOT NULL DEFAULT 'citizenship',
106 `bubble_color` varchar(100) NOT NULL,
107 `bubble_id` int(11) NOT NULL DEFAULT '0',
108 PRIMARY KEY (`id`,`auth_ticket`,`pincode`,`pin_client`),
109 UNIQUE KEY `id` (`id`) USING HASH,
110 UNIQUE KEY `username` (`username`) USING BTREE,
111 KEY `rank` (`rank`),
112 KEY `ip_last` (`ip_last`),
113 KEY `ip_reg` (`ip_reg`),
114 KEY `credits` (`credits`),
115 KEY `activity_points` (`activity_points`),
116 KEY `online` (`online`),
117 KEY `mail` (`mail`),
118 KEY `machine_id` (`machine_id`),
119 KEY `auth_ticket` (`auth_ticket`),
120 KEY `last_online` (`last_online`),
121 KEY `home_room` (`home_room`),
122 KEY `rank_vip` (`rank_vip`),
123 KEY `messenger` (`id`,`username`,`look`,`motto`,`last_online`) USING BTREE
124) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;