eMhsR945

1CREATE TABLE IF NOT EXISTS `users` (
2  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
3  `login` varchar(30) NOT NULL,
4  `password` varchar(32) NOT NULL,
5  `hash` varchar(32) NOT NULL,
6  `ip` int(10) unsigned NOT NULL DEFAULT '0',
7  `mail` varchar(30) NOT NULL,
8  `name` varchar(30) NOT NULL,
9  `last_name` varchar(30) NOT NULL,
10  `status` varchar(30) NOT NULL,
11  `avatar` int(10) unsigned NOT NULL DEFAULT '1',
12  PRIMARY KEY (`id`)
13) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;