· 8 years ago · Aug 20, 2018, 11:44 PM
1
2CREATE TABLE IF NOT EXISTS `users` (
3 `id` int(11) NOT NULL AUTO_INCREMENT,
4 `username` varchar(125) NOT NULL,
5 `password` varchar(255) DEFAULT NULL,
6 `btn_compartilhar` enum('0','1') DEFAULT '0',
7 `nome_programa` text,
8 `dias_programa` text,
9 `locutor` enum('0','1') DEFAULT '0',
10 `cms_background` varchar(500) DEFAULT './_images/150k_easter_bg_938x1360.png',
11 `cms_staffocult` enum('0','1') DEFAULT '0',
12 `locutor_online` enum('0','1') DEFAULT '0',
13 `mail` varchar(255) DEFAULT 'defaultuser@meth0d.org',
14 `auth_ticket` varchar(60) NOT NULL DEFAULT '',
15 `rank` int(1) unsigned DEFAULT '1',
16 `Rankcms` int(1) unsigned DEFAULT '1',
17 `Cargo` varchar(100) NOT NULL,
18 `rank_vip` int(11) DEFAULT '1',
19 `credits` int(11) DEFAULT '999999',
20 `vip_points` int(11) DEFAULT '0',
21 `activity_points` int(11) DEFAULT '5000',
22 `look` char(255) DEFAULT 'ha-1003-62.ea-1406-62.ch-804-77.hr-893-1042.lg-275-62.hd-209-2.sh-300-62',
23 `gender` enum('M','F') DEFAULT 'M',
24 `motto` char(240) DEFAULT 'Eu <3 o Bot!',
25 `account_created` char(12) DEFAULT '0',
26 `last_online` int(11) DEFAULT '0',
27 `online` enum('0','1') DEFAULT '0',
28 `ip_last` varchar(45) DEFAULT '',
29 `ip_reg` varchar(45) DEFAULT NULL,
30 `home_room` int(10) DEFAULT '19',
31 `is_muted` enum('0','1') DEFAULT '0',
32 `block_newfriends` enum('0','1') DEFAULT '0',
33 `hide_online` enum('0','1') DEFAULT '0',
34 `hide_inroom` enum('0','1') DEFAULT '0',
35 `vip` enum('0','1') DEFAULT '1',
36 `volume` varchar(15) DEFAULT '100,100,100',
37 `last_change` int(20) DEFAULT '0',
38 `machine_id` varchar(125) DEFAULT '',
39 `focus_preference` enum('0','1') DEFAULT '0',
40 `chat_preference` enum('0','1') DEFAULT '0',
41 `pets_muted` enum('0','1') DEFAULT '0',
42 `bots_muted` enum('0','1') DEFAULT '0',
43 `advertising_report_blocked` enum('0','1') DEFAULT '0',
44 `gotw_points` int(11) DEFAULT '0',
45 `cadstaff` enum('true','false') NOT NULL DEFAULT 'false',
46 `rank_promocao` int(10) NOT NULL DEFAULT '0',
47 `CoreEmu` enum('true','false') NOT NULL DEFAULT 'false',
48 `talent_status` enum('citizenship','helper') NOT NULL DEFAULT 'citizenship',
49 `programer` enum('true','false') NOT NULL DEFAULT 'false',
50 `Novato` enum('true','false') NOT NULL DEFAULT 'false',
51 `Targetcont` enum('true','false') NOT NULL DEFAULT 'false',
52 `Vipss` enum('true','false') NOT NULL DEFAULT 'false',
53 `Presidio` enum('true','false') NOT NULL DEFAULT 'false',
54 `Premiar` int(10) NOT NULL DEFAULT '1',
55 `prefix_name` varchar(100) NOT NULL,
56 `prefix_color` varchar(100) NOT NULL,
57 `name_color` varchar(100) NOT NULL,
58 `ignore_invites` enum('0','1') DEFAULT '0',
59 `time_muted` double DEFAULT '0',
60 `allow_gifts` enum('0','1') DEFAULT '1',
61 `trading_locked` double DEFAULT '0',
62 `friend_bar_state` enum('0','1') NOT NULL DEFAULT '1',
63 `disable_forced_effects` enum('0','1') NOT NULL DEFAULT '0',
64 `allow_mimic` enum('1','0') NOT NULL DEFAULT '1',
65 `allow_events` enum('0','1') NOT NULL DEFAULT '1',
66 `staff_twitter` varchar(50) DEFAULT NULL,
67 `staff_facebook` varchar(50) DEFAULT NULL,
68 `forgot_ticket` varchar(50) DEFAULT NULL,
69 `facebook_id` varchar(50) DEFAULT NULL,
70 `pin` varchar(50) DEFAULT NULL,
71 `facebook_change` varchar(50) DEFAULT NULL,
72 `facebook` varchar(50) DEFAULT NULL,
73 `staff_background_url` text,
74 `staff_ocult` varchar(50) DEFAULT '0',
75 `role` varchar(50) DEFAULT NULL,
76 `country_cf` varchar(50) DEFAULT 'ec',
77 `last_used` varchar(50) DEFAULT '0',
78 `refer_count` varchar(50) DEFAULT '0',
79 `staff_profileimage_url` varchar(150) DEFAULT '0',
80 `seckey` varchar(999) DEFAULT NULL,
81 `designer` enum('1','0') DEFAULT '0',
82 `expert` enum('1','0') DEFAULT '0',
83 `youtube_embed` varchar(11) DEFAULT 'OWodAv1KHaM',
84 `aboutme` varchar(250) DEFAULT 'No description yet',
85 `kik` varchar(30) DEFAULT 'Not submitted',
86 `bot_frank` varchar(30) NOT NULL DEFAULT '0',
87 `Datahoje` varchar(30) NOT NULL DEFAULT '0',
88 `isNoob` enum('1','0') NOT NULL DEFAULT '1',
89 `isMedal` enum('1','0') NOT NULL DEFAULT '1',
90 `helper_level` int(10) NOT NULL DEFAULT '0',
91 `frank_gift_count` int(10) NOT NULL DEFAULT '0',
92 `quiz_passed` enum('1','0') NOT NULL DEFAULT '0',
93 `namePrefix` varchar(150) NOT NULL DEFAULT '',
94 `namePrefix_color` varchar(150) NOT NULL DEFAULT '',
95 `Hjs` varchar(30) NOT NULL DEFAULT '0',
96 `Lala` int(11) DEFAULT '0',
97 `LalaAlert` int(11) DEFAULT '0',
98 `cms_post` int(11) DEFAULT '0',
99 `referidos` int(11) DEFAULT '0',
100 `LalaRecu` int(11) DEFAULT '0',
101 `LalaCod` int(11) DEFAULT '0',
102 `Lalacodcon` varchar(100) NOT NULL DEFAULT '0',
103 `LalaConf` varchar(100) NOT NULL DEFAULT '0',
104 `ScoreGame` varchar(100) NOT NULL DEFAULT '0',
105 PRIMARY KEY (`id`,`auth_ticket`),
106 UNIQUE KEY `id` (`id`) USING HASH,
107 UNIQUE KEY `username` (`username`) USING BTREE,
108 KEY `rank` (`rank`),
109 KEY `ip_last` (`ip_last`),
110 KEY `ip_reg` (`ip_reg`),
111 KEY `credits` (`credits`),
112 KEY `activity_points` (`activity_points`),
113 KEY `online` (`online`),
114 KEY `mail` (`mail`),
115 KEY `machine_id` (`machine_id`),
116 KEY `auth_ticket` (`auth_ticket`),
117 KEY `last_online` (`last_online`),
118 KEY `home_room` (`home_room`),
119 KEY `rank_vip` (`rank_vip`),
120 KEY `messenger` (`id`,`username`,`look`,`motto`,`last_online`) USING BTREE
121) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9469 ;
122
123--
124-- Extraindo dados da tabela `users`