d0G5EGiG

1
2CREATE TABLE IF NOT EXISTS `users` (
3  `id` int(12) NOT NULL AUTO_INCREMENT,
4  `username` varchar(255) CHARACTER SET utf8 NOT NULL,
5  `email` varchar(255) CHARACTER SET utf8 NOT NULL,
6  `password` varchar(255) CHARACTER SET utf8 NOT NULL,
7  `name` varchar(255) CHARACTER SET utf8 NOT NULL,
8  `surname` varchar(255) CHARACTER SET utf8 NOT NULL,
9  `cellphone_1` int(15) NOT NULL,
10  `cellphone_2` int(15) NOT NULL,
11  `homephone` int(15) NOT NULL,
12  `skype` varchar(255) CHARACTER SET utf8 NOT NULL,
13  `address` text CHARACTER SET utf8 NOT NULL,
14  `date_reg` int(20) NOT NULL,
15  `date_change` int(20) NOT NULL,
16  `date_change_user_id` int(12) NOT NULL,
17  `date_lastauth` int(20) NOT NULL,
18  PRIMARY KEY (`id`),
19  UNIQUE KEY `email` (`email`)
20) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=3 ;