· 7 years ago · Mar 04, 2019, 09:46 AM
1
2CREATE TABLE IF NOT EXISTS `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 'default@default.com',
8 `auth_ticket` text NOT NULL,
9 `rank` int(11) unsigned NOT NULL DEFAULT '1',
10 `credits` int(11) NOT NULL DEFAULT '0',
11 `fonction` varchar(50) NOT NULL,
12 `vip_points` int(11) NOT NULL,
13 `activity_points` int(11) NOT NULL DEFAULT '0',
14 `activity_points_lastupdate` double NOT NULL DEFAULT '0',
15 `look` varchar(100) NOT NULL DEFAULT 'hr-115-42.hd-190-1.ch-215-62.lg-285-91.sh-290-62',
16 `gender` enum('M','F') NOT NULL DEFAULT 'M',
17 `motto` varchar(50) NOT NULL,
18 `account_created` varchar(50) NOT NULL,
19 `last_online` varchar(50) NOT NULL,
20 `online` enum('0','1') NOT NULL DEFAULT '0',
21 `ip_last` varchar(120) NOT NULL,
22 `ip_reg` varchar(120) NOT NULL,
23 `home_room` int(10) unsigned NOT NULL DEFAULT '0',
24 `respect` int(11) NOT NULL DEFAULT '0',
25 `daily_respect_points` int(11) NOT NULL DEFAULT '3',
26 `gifts_given` int(10) NOT NULL DEFAULT '0',
27 `gifts_received` int(10) NOT NULL DEFAULT '0',
28 `daily_pet_respect_points` int(11) NOT NULL DEFAULT '3',
29 `newbie_status` int(11) NOT NULL DEFAULT '2',
30 `is_muted` enum('0','1') NOT NULL DEFAULT '0',
31 `mutant_penalty` enum('0','1','2') NOT NULL,
32 `mutant_penalty_expire` int(11) NOT NULL,
33 `block_newfriends` enum('0','1') NOT NULL DEFAULT '0',
34 `last_updated` varchar(50) NOT NULL,
35 `quest_id` int(10) unsigned NOT NULL DEFAULT '0',
36 `quest_progress` int(10) NOT NULL DEFAULT '0',
37 `lev_builder` int(10) NOT NULL DEFAULT '0',
38 `lev_social` int(10) NOT NULL DEFAULT '0',
39 `lev_identity` int(10) NOT NULL DEFAULT '0',
40 `lev_explore` int(10) NOT NULL DEFAULT '0',
41 `respect_given` int(10) NOT NULL DEFAULT '0',
42 `last_respect_update` varchar(100) NOT NULL,
43 `time_online` int(10) NOT NULL DEFAULT '0',
44 `is_ultra_vip` enum('0','1') NOT NULL DEFAULT '0',
45 `marketplace_tickets` int(10) NOT NULL DEFAULT '0',
46 `fireworks` int(10) NOT NULL DEFAULT '0',
47 `online1` text,
48 `ipaddress_last` varchar(100) DEFAULT NULL,
49 `noob` int(1) DEFAULT NULL,
50 `birth` varchar(100) DEFAULT NULL,
51 `hbirth` varchar(100) DEFAULT NULL,
52 `lastvisit` varchar(50) DEFAULT NULL,
53 `badge_status` int(10) DEFAULT NULL,
54 `postcount` int(10) DEFAULT NULL,
55 `tickets` int(5) DEFAULT NULL,
56 `newsletter` int(1) DEFAULT NULL,
57 `email_verified` int(1) DEFAULT NULL,
58 `ipaddress` varchar(100) DEFAULT NULL,
59 `hide_online` enum('0','1') DEFAULT '0',
60 `hide_inroom` enum('0','1') DEFAULT '0',
61 `mail_verified` varchar(6) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT '0',
62 `vip` enum('0','1') DEFAULT '0',
63 `volume` int(3) NOT NULL DEFAULT '100',
64 `scadenza` varchar(50) NOT NULL DEFAULT 'Non definito',
65 `accept_trading` enum('0','1') NOT NULL DEFAULT '1',
66 `facebook_id` varchar(255) NOT NULL DEFAULT '0',
67 `show_homepage` enum('0','1') DEFAULT '0',
68 `ruolo` varchar(50) NOT NULL DEFAULT 'Nessun Ruolo',
69 `datosreg` varchar(500) NOT NULL DEFAULT '0',
70 `secret` varchar(10) DEFAULT NULL,
71 `me` enum('0','1') NOT NULL DEFAULT '0',
72 PRIMARY KEY (`id`)
73) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=229 ;