· 7 years ago · Mar 04, 2019, 10:02 AM
1CREATE TABLE IF NOT EXISTS `users` (
2 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
3 `username` varchar(50) NOT NULL,
4 `real_name` varchar(100) NOT NULL DEFAULT '',
5 `password` varchar(50) NOT NULL,
6 `mail` varchar(50) NOT NULL DEFAULT 'default@default.com',
7 `auth_ticket` text NOT NULL,
8 `rank` int(11) unsigned NOT NULL DEFAULT '1',
9 `credits` int(11) NOT NULL DEFAULT '0',
10 `fonction` varchar(50) NOT NULL,
11 `vip_points` int(11) NOT NULL,
12 `activity_points` int(11) NOT NULL DEFAULT '0',
13 `activity_points_lastupdate` double NOT NULL DEFAULT '0',
14 `look` varchar(100) 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 `gifts_given` int(10) NOT NULL DEFAULT '0',
26 `gifts_received` int(10) NOT NULL DEFAULT '0',
27 `daily_pet_respect_points` int(11) NOT NULL DEFAULT '3',
28 `newbie_status` int(11) NOT NULL DEFAULT '2',
29 `is_muted` enum('0','1') NOT NULL DEFAULT '0',
30 `mutant_penalty` enum('0','1','2') NOT NULL,
31 `mutant_penalty_expire` int(11) NOT NULL,
32 `block_newfriends` enum('0','1') NOT NULL DEFAULT '0',
33 `last_updated` varchar(50) NOT NULL,
34 `quest_id` int(10) unsigned NOT NULL DEFAULT '0',
35 `quest_progress` int(10) NOT NULL DEFAULT '0',
36 `lev_builder` int(10) NOT NULL DEFAULT '0',
37 `lev_social` int(10) NOT NULL DEFAULT '0',
38 `lev_identity` int(10) NOT NULL DEFAULT '0',
39 `lev_explore` int(10) NOT NULL DEFAULT '0',
40 `respect_given` int(10) NOT NULL DEFAULT '0',
41 `last_respect_update` varchar(100) NOT NULL,
42 `time_online` int(10) NOT NULL DEFAULT '0',
43 `is_ultra_vip` enum('0','1') NOT NULL DEFAULT '0',
44 `marketplace_tickets` int(10) NOT NULL DEFAULT '0',
45 `fireworks` int(10) NOT NULL DEFAULT '0',
46 `online1` text,
47 `ipaddress_last` varchar(100) DEFAULT NULL,
48 `noob` int(1) DEFAULT NULL,
49 `birth` varchar(100) DEFAULT NULL,
50 `hbirth` varchar(100) DEFAULT NULL,
51 `lastvisit` varchar(50) DEFAULT NULL,
52 `badge_status` int(10) DEFAULT NULL,
53 `postcount` int(10) DEFAULT NULL,
54 `tickets` int(5) DEFAULT NULL,
55 `newsletter` int(1) DEFAULT NULL,
56 `email_verified` int(1) DEFAULT NULL,
57 `ipaddress` varchar(100) DEFAULT NULL,
58 `hide_online` enum('0','1') DEFAULT '0',
59 `hide_inroom` enum('0','1') DEFAULT '0',
60 `mail_verified` varchar(6) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT '0',
61 `vip` enum('0','1') DEFAULT '0',
62 `volume` int(3) NOT NULL DEFAULT '100',
63 `scadenza` varchar(50) NOT NULL DEFAULT 'Non definito',
64 `accept_trading` enum('0','1') NOT NULL DEFAULT '1',
65 `facebook_id` varchar(255) NOT NULL DEFAULT '0',
66 `show_homepage` enum('0','1') DEFAULT '0',
67 `ruolo` varchar(50) NOT NULL DEFAULT 'Nessun Ruolo',
68 `datosreg` varchar(500) NOT NULL DEFAULT '0',
69 `secret` varchar(10) DEFAULT NULL,
70 `me` enum('0','1') NOT NULL DEFAULT '0',
71`points` int(11) NOT NULL DEFAULT '0',
72 `block_trade` enum('1','0') NOT NULL DEFAULT '0',
73 `crystals` int(11) NOT NULL DEFAULT '0',
74 `currentquestid` int(11) unsigned NOT NULL DEFAULT '0',
75 `currentquestprogress` int(11) NOT NULL DEFAULT '0',
76 `achievement_points` int(11) NOT NULL DEFAULT '0',
77 `seckey` varchar(999) DEFAULT NULL,
78 PRIMARY KEY (`username`),
79 UNIQUE KEY `id` (`id`) USING HASH,
80 UNIQUE KEY `username` (`username`) USING BTREE,
81 KEY `ip_last` (`ip_last`) USING BTREE
82) ENGINE=InnoDB DEFAULT CHARSET=latin1;