· 9 years ago · Nov 03, 2016, 03:32 PM
1CREATE TABLE IF NOT EXISTS `users` (
2 `id` int(250) NOT NULL AUTO_INCREMENT,
3 `username` varchar(500) NOT NULL,
4 `look` varchar(500) NOT NULL,
5 `realname` varchar(500) NOT NULL DEFAULT '',
6 `homeroom` int(250) NOT NULL DEFAULT '0',
7 `password` varchar(500) NOT NULL,
8 `ssoTicket` varchar(500) NOT NULL,
9 `email` varchar(500) NOT NULL,
10 `coins` int(250) NOT NULL DEFAULT '250000',
11 `othercoins` int(250) NOT NULL DEFAULT '250000',
12 `score` int(255) NOT NULL DEFAULT '0',
13 `mission` varchar(500) NOT NULL,
14 `Gender` enum('M','F') NOT NULL,
15 `Habbo_Club` enum('0','1') NOT NULL DEFAULT '0',
16 `Respects` int(250) NOT NULL DEFAULT '0',
17 `Max_Users_Respects` int(250) NOT NULL DEFAULT '3',
18 `Max_Pets_Respects` int(250) NOT NULL DEFAULT '3',
19 `rank` int(250) NOT NULL DEFAULT '0',
20 `ban_time` int(250) NOT NULL DEFAULT '0',
21 `ban_count` int(255) NOT NULL DEFAULT '0',
22 `Habbo_Club_Init` varchar(500) NOT NULL DEFAULT '',
23 `Habbo_Club_Expire` varchar(500) NOT NULL DEFAULT '',
24 `ban` enum('0','1') NOT NULL DEFAULT '0',
25 `kuick` enum('0','1') NOT NULL DEFAULT '0',
26 `last_ip` varchar(500) NOT NULL DEFAULT '',
27 `registred_ip` varchar(500) NOT NULL DEFAULT '',
28 `registred_time` varchar(500) NOT NULL DEFAULT '',
29 `last_login` varchar(500) NOT NULL DEFAULT '2012/11/21 20:50:48',
30 `diamonds` int(11) NOT NULL,
31 PRIMARY KEY (`id`)
32) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=181 ;