6FUJEmFw

1 
2CREATE TABLE IF NOT EXISTS `accounts` (
3  `id` int(11) NOT NULL AUTO_INCREMENT,
4  `name` varchar(32) NOT NULL,
5  `password` char(40) NOT NULL,
6  `type` int(11) NOT NULL DEFAULT '1',
7  `premdays` int(11) NOT NULL DEFAULT '0',
8  `lastday` int(10) unsigned NOT NULL DEFAULT '0',
9  `email` varchar(255) NOT NULL DEFAULT '',
10  `creation` int(11) NOT NULL DEFAULT '0',
11  `page_access` int(11) DEFAULT NULL,
12  `page_lastday` int(11) DEFAULT NULL,
13  `email_new` varchar(255) DEFAULT NULL,
14  `email_new_time` int(15) DEFAULT NULL,
15  `rlname` varchar(255) DEFAULT NULL,
16  `location` varchar(255) DEFAULT NULL,
17  `created` int(16) DEFAULT NULL,
18  `email_code` varchar(255) DEFAULT NULL,
19  `next_email` int(11) DEFAULT NULL,
20  `premium_points` int(11) DEFAULT NULL,
21  `nickname` char(48) DEFAULT NULL,
22  `avatar` char(48) DEFAULT NULL,
23  `about_me` text,
24  `key` varchar(128) NOT NULL DEFAULT '',
25  `blocked` int(11) NOT NULL,
26  PRIMARY KEY (`id`),
27  UNIQUE KEY `name` (`name`)
28) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;