· 7 years ago · Sep 23, 2018, 06:52 PM
1DROP TABLE IF EXISTS `users`;
2CREATE TABLE `users` (
3 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
4 `username` varchar(50) NOT NULL,
5 `real_name` varchar(100) NOT NULL DEFAULT 'Krz',
6 `password` varchar(50) NOT NULL,
7 `mail` varchar(50) NOT NULL DEFAULT 'defaultuser@privatecms.com',
8 `auth_ticket` text NOT NULL,
9 `rank` int(11) unsigned NOT NULL DEFAULT '2',
10 `credits` int(11) NOT NULL DEFAULT '0',
11 `vip_points` int(11) NOT NULL DEFAULT '0',
12 `activity_points` int(11) NOT NULL DEFAULT '150000',
13 `activity_points_lastupdate` double NOT NULL DEFAULT '0',
14 `look` varchar(160) NOT NULL DEFAULT 'sh-3027-96-96.lg-3023-78.hr-831-61.hd-180-5.ch-3059-96.ca-1803-110',
15 `gender` enum('M','F') NOT NULL DEFAULT 'M',
16 `motto` varchar(50) NOT NULL,
17 `account_created` varchar(50) NOT NULL,
18 `last_online` int(15) NOT NULL,
19 `online` enum('0','1') NOT NULL DEFAULT '0',
20 `ip_last` varchar(120) NOT NULL,
21 `ip_reg` varchar(120) NOT NULL,
22 `home_room` int(10) unsigned NOT NULL DEFAULT '6038',
23 `respect` int(11) NOT NULL DEFAULT '0',
24 `daily_respect_points` int(11) NOT NULL DEFAULT '3',
25 `daily_pet_respect_points` int(11) NOT NULL DEFAULT '3',
26 `newbie_status` int(11) NOT NULL DEFAULT '2',
27 `is_muted` enum('0','1') NOT NULL DEFAULT '0',
28 `mutant_penalty` enum('0','1','2') NOT NULL DEFAULT '0',
29 `mutant_penalty_expire` int(11) NOT NULL DEFAULT '0',
30 `block_newfriends` enum('0','1') NOT NULL DEFAULT '1',
31 `hide_online` enum('0','1') NOT NULL DEFAULT '0',
32 `hide_inroom` enum('0','1') NOT NULL DEFAULT '0',
33 `mail_verified` varchar(6) NOT NULL DEFAULT '0',
34 `vip` enum('0','1') NOT NULL DEFAULT '1',
35 `secretcode` int(11) NOT NULL,
36 `dolares` int(11) NOT NULL,
37 `avatars_select` varchar(50) NOT NULL,
38 `volume` int(3) NOT NULL DEFAULT '100',
39 `country` varchar(11) NOT NULL,
40 `loginid` varchar(200) NOT NULL DEFAULT 'icon_habbo_small',
41 `accept_trading` enum('0','1') NOT NULL DEFAULT '1',
42 `idioma` text NOT NULL,
43 `home` int(10) NOT NULL DEFAULT '0',
44 `facebook-new` varchar(50) NOT NULL,
45 `change_name` varchar(50) NOT NULL DEFAULT '0',
46 `pesos` int(50) NOT NULL DEFAULT '0',
47 `puntodecontrol` varchar(50) NOT NULL,
48 `rpx_last_login` varchar(50) NOT NULL,
49 `rpx` enum('3','2','1','0') NOT NULL,
50 `security_check` varchar(50) NOT NULL,
51 `pasos` varchar(50) NOT NULL DEFAULT '0',
52 `one_password` varchar(500) NOT NULL,
53 `datosreg` varchar(500) NOT NULL DEFAULT '0',
54 `update` enum('0','1') NOT NULL DEFAULT '0',
55 `alertview` varchar(100) NOT NULL DEFAULT '0',
56 PRIMARY KEY (`id`)
57) ENGINE=MyISAM AUTO_INCREMENT=10811 DEFAULT CHARSET=latin1;