CREATE TABLE `users` (
`id` int(11) NOT NULL auto_increment,
`login` varchar(25) NOT NULL,
`password` varchar(30) NOT NULL,
`sex` int(2) default NULL,
`status` int(2) default NULL,
`ip` text,
`user_agent` text NOT NULL,
`room` text,
`rtime` varchar(50) NOT NULL,
`clogin` text,
`ctext` text,
`avatar` int(10) default NULL,
`posts` int(10) default NULL,
`points` int(10) default NULL,
`credits` int(10) default NULL,
`rating` int(10) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=cp1251 AUTO_INCREMENT=9 ;
INSERT INTO `users` VALUES (5, 'nevermore', '1234', 0, 6, '127.0.0.1', 'Opera/9.80 (Windows NT 6.1; U; ru) Presto/2.10.229 Version/11.64', '1', '1340366785', 'gradient', '1', 0, 64, 76, 1,0);
INSERT INTO `users` VALUES (8, 'test', 'test', 1, 1, '127.0.0.1', 'Opera/9.80 (Windows NT 6.1; U; ru) Presto/2.10.229 Version/11.64', '0', '1340356205', '1', '1', 0, 1, 101, 1);