· 6 years ago · Mar 29, 2019, 03:30 PM
1SET FOREIGN_KEY_CHECKS=0;
2-- ----------------------------
3-- Table structure for `users`
4-- ----------------------------
5DROP TABLE IF EXISTS `users`;
6CREATE TABLE `users` (
7 `id` int(11) NOT NULL AUTO_INCREMENT,
8 `username` varchar(12) NOT NULL,
9 `password` varchar(255) DEFAULT NULL,
10 `mail` varchar(255) DEFAULT 'defaultuser@meth0d.org',
11 `auth_ticket` varchar(60) DEFAULT NULL,
12 `rank` int(1) unsigned DEFAULT '1',
13 `rank_vip` int(1) DEFAULT '0',
14 `credits` int(11) NOT NULL DEFAULT '25000',
15 `seasonal_currency` int(11) NOT NULL DEFAULT '1',
16 `vip_points` int(11) NOT NULL DEFAULT '0',
17 `activity_points` int(11) DEFAULT '10',
18 `look` varchar(160) NOT NULL DEFAULT 'hd-180-1.ch-210-66.lg-…-290-91.hr-100-',
19 `gender` enum('M','F') DEFAULT 'M',
20 `motto` varchar(50) NOT NULL DEFAULT 'Bienvenue sur Dango Hôtel!',
21 `account_created` char(12) DEFAULT '0',
22 `last_online` int(11) DEFAULT '0',
23 `online` enum('0','1') DEFAULT '0',
24 `ip_last` varchar(45) DEFAULT '',
25 `ip_reg` varchar(45) DEFAULT NULL,
26 `home_room` int(10) unsigned NOT NULL DEFAULT '324',
27 `is_muted` enum('0','1') DEFAULT '0',
28 `block_newfriends` enum('0','1') DEFAULT '0',
29 `hide_online` enum('0','1') DEFAULT '0',
30 `hide_inroom` enum('0','1') DEFAULT '0',
31 `vip` enum('0','1') DEFAULT '0',
32 `volume` varchar(15) DEFAULT '100,100,100',
33 `last_change` int(20) DEFAULT '0',
34 `machine_id` varchar(125) DEFAULT '',
35 `focus_preference` enum('0','1') DEFAULT '0',
36 `chat_preference` enum('0','1') DEFAULT '0',
37 `pets_muted` enum('0','1') DEFAULT '0',
38 `bots_muted` enum('0','1') DEFAULT '0',
39 `advertising_report_blocked` enum('0','1') DEFAULT '0',
40 `gotw_points_honor` int(11) DEFAULT '0',
41 `ignore_invites` enum('0','1') DEFAULT '0',
42 `time_muted` double DEFAULT '0',
43 `allow_gifts` enum('0','1') DEFAULT '1',
44 `trading_locked` double DEFAULT '0',
45 `friend_bar_state` enum('0','1') NOT NULL DEFAULT '1',
46 `disable_forced_effects` enum('0','1') NOT NULL DEFAULT '0',
47 `allow_mimic` enum('1','0') NOT NULL DEFAULT '1',
48 `allow_emoji` enum('1','0') NOT NULL DEFAULT '1',
49 `publi` enum('0','1','2','3') NOT NULL DEFAULT '0',
50 `guia` enum('0','1','2','3','4') NOT NULL DEFAULT '0',
51 `tarea` varchar(50) NOT NULL DEFAULT '0',
52 `cms_signature` text,
53 `cms_currency` int(99) NOT NULL,
54 `key_colour` int(11) NOT NULL DEFAULT '0',
55 `userpo` int(99) NOT NULL,
56 `user_points` int(99) NOT NULL,
57 `acc_flagged` enum('0','1') NOT NULL DEFAULT '0',
58 `country` text,
59 `radio` varchar(100) NOT NULL DEFAULT 'autoplay',
60 `bancobloq` int(99) NOT NULL,
61 `croupier` enum('0','1') NOT NULL DEFAULT '0',
62 `builder` enum('0','1') NOT NULL DEFAULT '0',
63 `facebook_id` varchar(100) NOT NULL DEFAULT '',
64 `nux_user` enum('true','false') DEFAULT 'false',
65 `nux_room` enum('true','false') NOT NULL DEFAULT 'false',
66 `mastertrade` enum('0','1','2','3','4') NOT NULL DEFAULT '0',
67 `pumpkins` int(11) DEFAULT '0',
68 `gotw_points_calabazas` int(11) DEFAULT '0',
69 `gotw_points` int(11) DEFAULT '0',
70 `targeted_buy` int(10) NOT NULL,
71 `namecolor` varchar(125) NOT NULL DEFAULT '000000',
72 `bonus_points` int(11) DEFAULT '0',
73 `nametag` varchar(125) NOT NULL,
74 `cde` enum('0','1','2','3') NOT NULL DEFAULT '0',
75 `gotw_points_huevo` int(11) DEFAULT '1',
76 `tagcolor` varchar(255) DEFAULT NULL,
77 `tag` varchar(255) DEFAULT NULL,
78 `quiz_passed` enum('1','0') DEFAULT '1',
79 `changename` enum('0','1') NOT NULL DEFAULT '1',
80 `cms_colab` int(11) DEFAULT NULL,
81 `pincode` varchar(255) NOT NULL DEFAULT '573538',
82 `pin_client` varchar(255) NOT NULL DEFAULT '573538',
83 `mysticdata` varchar(15) DEFAULT '100,100,100',
84 `email_verificado` enum('0','1') NOT NULL DEFAULT '0',
85 `cms_birthday` varchar(100) NOT NULL,
86 `cms_staffocult` enum('0','1') NOT NULL DEFAULT '0',
87 `cms_role` varchar(50) NOT NULL,
88 `cms_rank` varchar(150) NOT NULL DEFAULT 'Usuario',
89 `user_rank` int(11) NOT NULL DEFAULT '1',
90 `cms_pin` enum('0','1','2') NOT NULL DEFAULT '0',
91 `vip_time` int(11) NOT NULL,
92 `vip_mes` int(11) NOT NULL,
93 `cms_stories` int(50) NOT NULL DEFAULT '0',
94 `code_forgot` varchar(50) NOT NULL,
95 `pin_intentos` int(5) NOT NULL DEFAULT '3',
96 `cms_forgot_time` int(11) NOT NULL,
97 `user_fondo` varchar(500) NOT NULL DEFAULT '/app/assets/img/personal/bg_fondo.png',
98 `user_referrals` varchar(100) NOT NULL DEFAULT '0',
99 `user_new` enum('0','1') NOT NULL DEFAULT '0',
100 `loto_clicks` int(2) NOT NULL DEFAULT '1',
101 `respetos` int(5) NOT NULL DEFAULT '3',
102 `public_stories` enum('0','1') NOT NULL DEFAULT '0',
103 `swf_description` enum('0','1') NOT NULL DEFAULT '0',
104 `time_pass` int(11) NOT NULL,
105 `pin_act` enum('0','1') NOT NULL DEFAULT '0',
106 `pin_time` int(11) NOT NULL,
107 `cuenta_suspendida` enum('0','1') NOT NULL DEFAULT '0',
108 `premio` int(30) NOT NULL DEFAULT '0',
109 `puntos_eventos` int(30) NOT NULL DEFAULT '0',
110 `talent_status` enum('citizenship','helper') NOT NULL DEFAULT 'citizenship',
111 `bubble_color` varchar(100) NOT NULL,
112 `bubble_id` int(11) NOT NULL DEFAULT '0',
113 `staff_beschreibung` varchar(999) NOT NULL,
114 `premiar` int(30) NOT NULL DEFAULT '0',
115 `working` varchar(999) NOT NULL DEFAULT 'User',
116 `disabled` int(6) NOT NULL DEFAULT '0',
117 `Datahoje` varchar(10) DEFAULT '20',
118 `prison` int(1) NOT NULL DEFAULT '0',
119 `relation` int(1) NOT NULL DEFAULT '0',
120 `seckey` varchar(999) NOT NULL,
121 `cms_pbackground` varchar(200) NOT NULL DEFAULT '/Huggo_ProfilbannerV2.png',
122 `cms_pprofile` varchar(200) NOT NULL DEFAULT '/landing/img/files/perfil/foto.png',
123 `cms_pais` varchar(100) NOT NULL,
124 `cms_firma` longtext CHARACTER SET latin1 COLLATE latin1_general_ci,
125 `profileVisible` enum('0','1') NOT NULL DEFAULT '1',
126 `designer` enum('1','0') DEFAULT '0',
127 `expert` enum('1','0') DEFAULT '0',
128 `youtube_embed` varchar(11) DEFAULT 'OWodAv1KHaM',
129 `aboutme` varchar(250) DEFAULT 'No description yet',
130 `jetons` int(11) NOT NULL DEFAULT '0',
131 `points_game` int(11) NOT NULL DEFAULT '0',
132 `staffclub` enum('non','oui') NOT NULL DEFAULT 'non',
133 `staff_background_url` text,
134 `staff_profileimage_url` varchar(150) DEFAULT '0',
135 `last_offline` double NOT NULL,
136 `last_used` varchar(50) DEFAULT '0',
137 `bandera` enum('AF','AL','DE','AD','AO','AI','AQ','AG','SA','DZ','AR','AM','AW','AU','AT','AZ','BS','BD','BB','BH','BE','BZ','BJ','BM','BY','BO','BQ','BA','BW','BR','BN','BG','BF','BI','BT','CV','KH','CM','CA','TD','CL','CN','CY','CO','KM','CD','CG','KR','CI','CR','HR','CU','CW','DK','DM','EC','EG','SV','AE','ER','SK','SI','ES','US','EE','ET','RU','PH','FI','FJ','FR','GA','GM','GE','GH','GI','GD','GR','GL','GP','GU','GT','GF','GG','GW','GQ','GN','GY','HT','HN','HK','HU','IN','ID','IQ','IR','IE','BV','IM','CX','NF','IS','AX','KY','CC','CK','FK','FO','GS','HM','MP','MH','SB','TC','UM','VG','VI','IL','IT','JM','JP','JE','JO','KZ','KE','KG','KI','KW','LS','LV','LB','LR','LY','LI','LT','LU','MO','MK','MG','MY','MW','MV','ML','MT','MA','MQ','MU','MR','YT','MX','FM','MD','MC','MN','ME','MS','MZ','MM','NA','NR','NP','NI','NG','NE','NU','NO','NC','NZ','OM','NL','PK','PW','PS','PA','PG','PY','PE','PN','PF','PL','PT','PR','QA','GB','CF','CZ','LA','DO','RE','RW','RO','EH','AS','WS','BL','KN','SM','MF','PM','VC','SH','LC','VA','ST','SN','RS','SC','SL','SG','SX','SY','SO','LK','SZ','ZA','SS','SD','SE','CH','SR','SJ','TH','TW','TZ','TJ','IO','TF','TL','TG','TK','TO','TT','TN','TM','TR','TV','UA','UG','UY','UZ','VU','VE','VN','WF','YE','DJ','ZM','ZW') DEFAULT NULL,
138 `shops` int(100) NOT NULL DEFAULT '0',
139 `cms_verified` enum('1','0') NOT NULL DEFAULT '0',
140 `cms_color_c` varchar(100) NOT NULL DEFAULT '#e6a836',
141 `avatar_gesture` enum('std','spk','eyb','sml','sad','srp','agr') DEFAULT 'std',
142 `avatar_action` varchar(100) NOT NULL DEFAULT 'std',
143 `cms_color_m` varchar(100) NOT NULL DEFAULT '#806f40',
144 `lootcrates_bought` int(100) unsigned DEFAULT '1',
145 `isMedal` enum('1','0') CHARACTER SET utf8 NOT NULL DEFAULT '1',
146 `schutz` enum('true','false') CHARACTER SET utf8 NOT NULL DEFAULT 'false',
147 PRIMARY KEY (`id`,`pincode`,`pin_client`),
148 UNIQUE KEY `id` (`id`) USING HASH,
149 UNIQUE KEY `username` (`username`) USING BTREE,
150 KEY `rank` (`rank`),
151 KEY `ip_last` (`ip_last`),
152 KEY `ip_reg` (`ip_reg`),
153 KEY `credits` (`credits`),
154 KEY `activity_points` (`activity_points`),
155 KEY `online` (`online`),
156 KEY `mail` (`mail`),
157 KEY `machine_id` (`machine_id`),
158 KEY `auth_ticket` (`auth_ticket`),
159 KEY `last_online` (`last_online`),
160 KEY `home_room` (`home_room`),
161 KEY `rank_vip` (`rank_vip`),
162 KEY `messenger` (`id`,`username`,`look`,`motto`,`last_online`) USING BTREE
163) ENGINE=InnoDB AUTO_INCREMENT=1438 DEFAULT CHARSET=latin1;
164
165-- ----------------------------
166-- Records of users
167-- ----------------------------
168INSERT INTO `users` VALUES ('1', 'moso', 'e50d1fba6df1297cfd84bc17ff14e7e54753e2ea0521640b3a227fdf11124c7ec9ff655563112fde', 'moso@hotmail.fr', 'YeezyCMS-561-b19fbd47823c102bb2244334589c97096', '17', '0', '500100555', '1', '48886', '999888135', 'ch-987462876-92.hd-209-1.hr-155-61.sh-7321-73-62.lg-270-1198', 'M', 'Slt', '1553188723', '1553867419', '0', '2a01:cb19:8236:c400:e423:2a0:d25a:f3ee', '93.115.97.169', '324', '0', '0', '0', '0', '0', '100,100,100', '1553796555', 'f5b938d7f70b13580c9e13b6780eadc7', '0', '0', '0', '0', '0', '50000', '0', '0', '1', '0', '1', '0', '1', '1', '0', '0', '0', null, '0', '0', '0', '0', '0', null, 'autoplay', '0', '0', '0', '', 'false', 'false', '0', '0', '50000', '100000502', '0', '', '0', '', '0', '5', null, '', '1', '0', null, '573538', '573538', '100,100,100', '0', '01/01/1970', '0', '', 'Usuario', '1', '0', '0', '0', '1', '', '3', '0', '/app/assets/img/personal/bg_fondo.png', '0', '0', '2', '500000', '0', '0', '0', '0', '0', '0', '1', '502', 'citizenship', 'green', '0', '', '0', 'User', '0', '20', '0', '0', '', 'http://image.noelshack.com/fichiers/2019/12/5/1553279016-2637.jpeg', '/landing/img/files/perfil/foto.png', '', null, '1', '0', '0', 'OWodAv1KHaM', 'No description yet', '500', '500', 'non', null, '0', '0', '1553867419', null, '1', '0', '#e6a836', 'agr', 'std', '#806f40', '1', '1', 'false');