· 7 years ago · Sep 16, 2018, 11:24 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 '',
6 `password` varchar(50) NOT NULL,
7 `mail` varchar(50) NOT NULL DEFAULT 'defaultuser@meth0d.org',
8 `auth_ticket` text NOT NULL,
9 `rank` int(11) unsigned NOT NULL DEFAULT '1',
10 `credits` int(11) NOT NULL DEFAULT '50000',
11 `vip_points` int(11) NOT NULL DEFAULT '0',
12 `activity_points` int(11) NOT NULL DEFAULT '0',
13 `activity_points_lastupdate` double NOT NULL DEFAULT '0',
14 `look` varchar(255) NOT NULL DEFAULT 'hr-115-42.hd-190-1.ch-215-62.lg-285-91.sh-290-62',
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` varchar(50) 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 '0',
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 '0',
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 '0',
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 `working` varchar(50) NOT NULL DEFAULT '0',
35 `secretcode` varchar(8) NOT NULL DEFAULT '0',
36 `mymusik` varchar(100) NOT NULL DEFAULT '0',
37 `voted` text,
38 `werbe_punkte` text,
39 `vip` enum('0','1') NOT NULL DEFAULT '0',
40 `volume` int(3) NOT NULL DEFAULT '100',
41 `accept_trading` enum('0','1') NOT NULL DEFAULT '1',
42 `getmoney_date` varchar(20) DEFAULT '0',
43 `stammaccount` int(250) NOT NULL,
44 `linked_email` int(250) NOT NULL,
45 `visibility` int(250) NOT NULL,
46 PRIMARY KEY (`id`)
47) ENGINE=MyISAM AUTO_INCREMENT=1660 DEFAULT CHARSET=latin1;