| cat | CREATE TABLE `cat` (
`number` int(11) NOT NULL AUTO_INCREMENT,
`name1` varchar(20) DEFAULT NULL,
`surname` char(12) DEFAULT NULL,
`age` int(11) DEFAULT NULL,
PRIMARY KEY (`number`),
UNIQUE KEY `age` (`age`),
UNIQUE KEY `name1` (`name1`,`surname`,`age`),
UNIQUE KEY `name1_2` (`name1`,`surname`,`age`),
UNIQUE KEY `name1_3` (`name1`,`surname`,`age`)
) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=utf8 | |