· 6 years ago · Mar 22, 2019, 11:38 PM
1CREATE TABLE IF NOT EXISTS `users` (
2 `user_id` int(250) DEFAULT NULL,
3 `home_room` int(10) unsigned NOT NULL DEFAULT '1694',
4 `gotw_points_honor` int(11) DEFAULT '0',
5 `facebook_id` varchar(100) NOT NULL DEFAULT '',
6 `nux_room` enum('true','false') NOT NULL DEFAULT 'true',
7 `mastertrade` enum('0','1','2','3','4') NOT NULL DEFAULT '0',
8 `gotw_points_calabazas` int(11) DEFAULT '0',
9 `targeted_buy` int(10) NOT NULL,
10 `namecolor` varchar(125) NOT NULL DEFAULT '000000',
11 `bonus_points` int(11) DEFAULT '0',
12 `nametag` varchar(125) NOT NULL,
13 `cde` enum('0','1','2','3') NOT NULL DEFAULT '0',
14 `gotw_points_huevo` int(11) DEFAULT '1',
15 `tagcolor` varchar(255) DEFAULT NULL,
16 `tag` varchar(255) DEFAULT NULL,
17 `quiz_passed` enum('1','0') DEFAULT '1',
18 `changename` enum('0','1') NOT NULL DEFAULT '1',
19 `cms_colab` int(11) DEFAULT NULL,
20 `pincode` varchar(255) NOT NULL,
21 `pin_client` varchar(255) NOT NULL,
22 `mysticdata` varchar(15) DEFAULT '100,100,100',
23 `email_verificado` enum('0','1') NOT NULL DEFAULT '0',
24 `cms_birthday` varchar(100) NOT NULL,
25 `cms_staffocult` enum('0','1') NOT NULL DEFAULT '0',
26 `cms_role` varchar(50) NOT NULL,
27 `cms_rank` varchar(150) NOT NULL DEFAULT 'Usuario',
28 `user_rank` int(11) NOT NULL DEFAULT '1',
29 `cms_pin` enum('0','1','2') NOT NULL DEFAULT '0',
30 `vip_time` int(11) NOT NULL,
31 `vip_mes` int(11) NOT NULL,
32 `cms_stories` int(50) NOT NULL DEFAULT '0',
33 `code_forgot` varchar(50) NOT NULL,
34 `cms_forgot_time` int(11) NOT NULL,
35 `user_fondo` varchar(500) NOT NULL DEFAULT '/app/assets/img/personal/bg_fondo.png',
36 `user_referrals` varchar(100) NOT NULL DEFAULT '0',
37 `user_new` enum('0','1') NOT NULL DEFAULT '0',
38 `loto_clicks` int(2) NOT NULL DEFAULT '1',
39 `respetos` int(5) NOT NULL DEFAULT '3',
40 `public_stories` enum('0','1') NOT NULL DEFAULT '0',
41 `swf_description` enum('0','1') NOT NULL DEFAULT '0',
42 `time_pass` int(11) NOT NULL,
43 `pin_act` enum('0','1') NOT NULL DEFAULT '0',
44 `pin_intentos` int(5) NOT NULL DEFAULT '3',
45 `pin_time` int(11) NOT NULL,
46 `cuenta_suspendida` enum('0','1') NOT NULL DEFAULT '0',
47 `premio` int(30) NOT NULL DEFAULT '0',
48 `puntos_eventos` int(30) NOT NULL DEFAULT '0',
49 `talent_status` enum('citizenship','helper') NOT NULL DEFAULT 'citizenship',
50 `bubble_color` varchar(100) NOT NULL,
51 `bubble_id` int(11) NOT NULL DEFAULT '0',
52 PRIMARY KEY (`id`,`auth_ticket`,`pincode`,`pin_client`),
53 UNIQUE KEY `id` (`id`) USING HASH,
54 UNIQUE KEY `username` (`username`) USING BTREE,
55 KEY `rank` (`rank`),
56 KEY `ip_last` (`ip_last`),
57 KEY `ip_reg` (`ip_reg`),
58 KEY `credits` (`credits`),
59 KEY `activity_points` (`activity_points`),
60 KEY `online` (`online`),
61 KEY `mail` (`mail`),
62 KEY `machine_id` (`machine_id`),
63 KEY `auth_ticket` (`auth_ticket`),
64 KEY `last_online` (`last_online`),
65 KEY `home_room` (`home_room`),
66 KEY `rank_vip` (`rank_vip`),
67 KEY `messenger` (`id`,`username`,`look`,`motto`,`last_online`) USING BTREE
68) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;