· 6 years ago · May 30, 2019, 05:00 PM
1
2CREATE TABLE IF NOT EXISTS `users` (
3 `id` int(11) NOT NULL AUTO_INCREMENT,
4 `username` varchar(125) CHARACTER SET latin1 NOT NULL,
5 `password` varchar(255) CHARACTER SET latin1 NOT NULL,
6 `auth_ticket` varchar(60) CHARACTER SET latin1 NOT NULL,
7 `rank` int(11) unsigned NOT NULL DEFAULT '1',
8 `vip_points` int(11) NOT NULL DEFAULT '30',
9 `credits` int(11) NOT NULL DEFAULT '99999999',
10 `activity_points` int(11) NOT NULL DEFAULT '0',
11 `look` varchar(160) CHARACTER SET latin1 NOT NULL DEFAULT 'sh-290-1222.hr-100-1045.hd-180-1.ch-210-1201.lg-275-97',
12 `gender` enum('M','F') CHARACTER SET latin1 NOT NULL DEFAULT 'M',
13 `motto` varchar(50) CHARACTER SET latin1 NOT NULL DEFAULT '',
14 `mail` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT 'undefined',
15 `account_created` double(50,0) NOT NULL DEFAULT '0',
16 `last_online` int(11) NOT NULL DEFAULT '0',
17 `online` enum('0','1') CHARACTER SET latin1 NOT NULL DEFAULT '0',
18 `ip_last` varchar(120) CHARACTER SET latin1 NOT NULL DEFAULT '',
19 `ip_reg` varchar(120) CHARACTER SET latin1 NOT NULL DEFAULT '',
20 `home_room` int(10) unsigned DEFAULT '0',
21 `newbie_status` int(11) NOT NULL DEFAULT '1',
22 `is_muted` enum('0','1') CHARACTER SET latin1 NOT NULL DEFAULT '0',
23 `mutant_penalty` enum('0','1','2') CHARACTER SET latin1 NOT NULL DEFAULT '0',
24 `mutant_penalty_expire` int(11) NOT NULL DEFAULT '0',
25 `trade_lock` enum('0','1') NOT NULL DEFAULT '0',
26 `trade_lock_expire` int(11) NOT NULL DEFAULT '0',
27 `block_newfriends` enum('0','1') CHARACTER SET latin1 NOT NULL DEFAULT '0',
28 `hide_online` enum('0','1') CHARACTER SET latin1 NOT NULL DEFAULT '0',
29 `hide_inroom` enum('0','1') CHARACTER SET latin1 NOT NULL DEFAULT '0',
30 `vip` enum('0','1') CHARACTER SET latin1 NOT NULL DEFAULT '0',
31 `vip_expire` timestamp NOT NULL DEFAULT '2014-05-13 07:29:12',
32 `birth` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT '',
33 `last_name_change` int(11) NOT NULL DEFAULT '0',
34 `client_volume` varchar(255) NOT NULL DEFAULT '100,100,100',
35 `nux_passed` enum('0','1') NOT NULL DEFAULT '0',
36 `fundom` varchar(255) NOT NULL DEFAULT '#43AC6A',
37 `facebook_id` varchar(50) DEFAULT NULL,
38 `facebook_mail` varchar(255) DEFAULT NULL,
39 `facebook_name` varchar(255) DEFAULT NULL,
40 `pin` varchar(50) DEFAULT '0000',
41 `client_pin` varchar(255) NOT NULL DEFAULT '1212',
42 `facebook_change` varchar(50) DEFAULT '0',
43 `facebook` enum('0','1') DEFAULT '0',
44 `country_cf` varchar(50) DEFAULT 'US',
45 `refer_count` varchar(50) DEFAULT '0',
46 `seckey` varchar(255) NOT NULL DEFAULT 'autoplay',
47 `change_name` int(1) NOT NULL DEFAULT '0',
48 `home_active` enum('0','1','2') NOT NULL DEFAULT '1',
49 `home_active_security` enum('0','1','2') NOT NULL DEFAULT '1',
50 `home_active_badges` enum('0','1') NOT NULL DEFAULT '1',
51 `home_active_rooms` enum('0','1') NOT NULL DEFAULT '1',
52 `home_active_friends` enum('0','1') NOT NULL DEFAULT '1',
53 `home_active_fb` varchar(500) NOT NULL,
54 `home_active_twitter` varchar(500) NOT NULL,
55 `home_active_instagram` varchar(500) NOT NULL,
56 `home_active_redes` enum('0','1','2') NOT NULL DEFAULT '1',
57 `home_active_diamonds` enum('0','1','2') NOT NULL DEFAULT '1',
58 `home_active_duckets` enum('0','1','2') NOT NULL DEFAULT '1',
59 `home_active_gotw` enum('0','1','2') NOT NULL DEFAULT '1',
60 `home_active_color` varchar(500) NOT NULL DEFAULT '#e6c873',
61 `home_active_colorc` varchar(500) NOT NULL DEFAULT '#806f40',
62 `allow_pull` enum('0','1') NOT NULL DEFAULT '0',
63 `country` varchar(255) NOT NULL DEFAULT 'Unknown',
64 `rank_vip` int(1) DEFAULT '1',
65 `volume` varchar(15) NOT NULL DEFAULT '100,100,100',
66 `last_change` int(20) NOT NULL DEFAULT '0',
67 `machine_id` varchar(125) CHARACTER SET latin1 DEFAULT NULL,
68 `focus_preference` enum('0','1') CHARACTER SET latin1 DEFAULT '0',
69 `chat_preference` enum('0','1') CHARACTER SET latin1 DEFAULT '0',
70 `pets_muted` enum('0','1') CHARACTER SET latin1 DEFAULT '0',
71 `bots_muted` enum('0','1') CHARACTER SET latin1 DEFAULT '0',
72 `advertising_report_blocked` enum('0','1') CHARACTER SET latin1 DEFAULT '0',
73 `gotw_points` int(11) DEFAULT '0',
74 `ignore_invites` enum('0','1') CHARACTER SET latin1 DEFAULT '0',
75 `time_muted` double DEFAULT '0',
76 `allow_gifts` enum('0','1') CHARACTER SET latin1 DEFAULT '1',
77 `trading_locked` double DEFAULT '0',
78 `friend_bar_state` enum('0','1') CHARACTER SET latin1 NOT NULL DEFAULT '1',
79 `disable_forced_effects` enum('0','1') CHARACTER SET latin1 NOT NULL DEFAULT '0',
80 `allow_mimic` enum('1','0') CHARACTER SET latin1 NOT NULL DEFAULT '1',
81 `cms_signature` text,
82 `forum_color` varchar(6) NOT NULL DEFAULT '666666',
83 `cms_currency` int(99) NOT NULL,
84 `bot_frank` varchar(500) NOT NULL DEFAULT '9999',
85 `nux_user` enum('true','false') NOT NULL DEFAULT 'false',
86 `is_nuevo` enum('0','1') NOT NULL DEFAULT '0',
87 `name_color` varchar(666) NOT NULL,
88 `prefix_name` varchar(666) NOT NULL,
89 `prefix_name_color` varchar(699) NOT NULL,
90 `bubble_color` varchar(666) NOT NULL,
91 `bubble_id` int(11) NOT NULL DEFAULT '0',
92 `publi` enum('0','1','2','3') NOT NULL DEFAULT '0',
93 `guia` enum('0','1','2','3','4') NOT NULL DEFAULT '0',
94 `builder` enum('0','1') NOT NULL,
95 `croupier` enum('1','0') NOT NULL DEFAULT '0',
96 `user_points` int(99) NOT NULL DEFAULT '0',
97 `pumpkins` int(11) NOT NULL DEFAULT '0',
98 `talent_status` enum('citizenship','helper') NOT NULL DEFAULT 'citizenship',
99 `staff_ocult` enum('0','1') NOT NULL DEFAULT '0',
100 `work` text NOT NULL,
101 `targeted_buy` int(11) NOT NULL DEFAULT '0',
102 `frank_gift_count` int(11) NOT NULL DEFAULT '0',
103 `bonus_points` int(11) NOT NULL DEFAULT '0',
104 `secretcode` int(11) DEFAULT '0',
105 `working` int(11) DEFAULT '0',
106 `mymusik` int(11) DEFAULT '0',
107 `LalaCod` int(11) DEFAULT '0',
108 `Lalacodcon` varchar(100) NOT NULL DEFAULT '0',
109 `ScoreGame` varchar(100) NOT NULL DEFAULT '0',
110 `LalaConf` varchar(100) NOT NULL DEFAULT '0',
111 `cms_post` int(11) DEFAULT '0',
112 `isMedal` enum('1','0') NOT NULL DEFAULT '1',
113 `Hjs` varchar(30) NOT NULL DEFAULT '0',
114 `Datahoje` varchar(30) NOT NULL DEFAULT '99',
115 `Novato` enum('true','false') NOT NULL DEFAULT 'false',
116 `Targetcont` enum('true','false') NOT NULL DEFAULT 'false',
117 `Vipss` enum('true','false') NOT NULL DEFAULT 'false',
118 `Presidio` enum('true','false') NOT NULL DEFAULT 'false',
119 `Premiar` int(10) NOT NULL DEFAULT '1',
120 `cadstaff` enum('true','false') NOT NULL DEFAULT 'false',
121 `DataHC` varchar(30) NOT NULL DEFAULT '0',
122 `allow_events` enum('0','1') NOT NULL DEFAULT '1',
123 `last_offline` double NOT NULL,
124 PRIMARY KEY (`id`)
125) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT AUTO_INCREMENT=7 ;