yJ5kAqpT

1CREATE TABLE IF NOT EXISTS `users` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `username` varchar(20) NOT NULL,
4  `nickname` varchar(20) NOT NULL,
5  `email` varchar(999) NOT NULL,
6  `password` varchar(999) NOT NULL,
7  `active` int(1) NOT NULL DEFAULT '0',
8  `ubdate` varchar(255) NOT NULL,
9  `items` longblob NOT NULL,
10  `curhead` varchar(10) NOT NULL DEFAULT '413',
11  `curface` varchar(10) NOT NULL DEFAULT '0',
12  `curneck` varchar(10) NOT NULL DEFAULT '0',
13  `curbody` varchar(10) NOT NULL DEFAULT '0',
14  `curhands` varchar(10) NOT NULL DEFAULT '0',
15  `curfeet` varchar(10) NOT NULL DEFAULT '0',
16  `curphoto` varchar(10) NOT NULL DEFAULT '0',
17  `curflag` varchar(10) NOT NULL DEFAULT '0',
18  `colour` varchar(10) NOT NULL DEFAULT '11',
19  `buddies` longtext NOT NULL,
20  `ignore` longtext NOT NULL,
21  `joindate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
22  `lkey` varchar(50) NOT NULL,
23  `coins` int(11) NOT NULL,
24  `ismoderator` int(11) NOT NULL COMMENT '0 is False 1 is True',
25  `ismediator` int(11) NOT NULL COMMENT '0 is False 1 is True',
26  `isadmin` int(11) NOT NULL COMMENT '0 is False 1 is True',
27  `issuperadmin` int(11) NOT NULL COMMENT '0 is False 1 is True',
28  `rank` int(11) NOT NULL DEFAULT '1',
29  `ips` longtext,
30  `igloo` int(11) NOT NULL DEFAULT '1' COMMENT 'Igloo',
31  `furniture` longblob NOT NULL,
32  `floor` int(11) NOT NULL DEFAULT '0' COMMENT 'Flooring ID code',
33  `mood` text NOT NULL,
34  `NinjaRank` varchar(20) NOT NULL,
35  `NinjaRankPercent` varchar(20) NOT NULL,
36  `FireNinjaRank` varchar(20) NOT NULL,
37  `FireNinjaRankPercent` varchar(20) NOT NULL,
38  `WaterNinjaRank` varchar(20) NOT NULL,
39  `WaterNinjaRankPercent` varchar(20) NOT NULL,
40  PRIMARY KEY (`id`)
41) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2230 ;