show create table user

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
CREATE TABLE `users` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(32) NOT NULL,
`name2` varchar(32) default NULL,
`name3` varchar(32) default NULL,
`birth` date NOT NULL,
`gender` varchar(2) NOT NULL,
`mail` varchar(64) NOT NULL,
`country` varchar(32) NOT NULL,
`adres` varchar(64) NOT NULL,
`index` int(6) NOT NULL,
`city` int(11) NOT NULL,
`phone` varchar(32) NOT NULL,
`metro` varchar(64) default NULL,
`sn` tinyint(1) NOT NULL default '0',
`so` tinyint(1) NOT NULL default '0',
`snw` tinyint(1) NOT NULL default '0',
`pass` varchar(64) NOT NULL,
`salt` varchar(64) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=cp1251