CREATE TABLE
`users` (
`category` ENUM('дом', 'работа', 'учеба') NOT NULL,
`id` MEDIUMINT NOT NULL AUTO_INCREMENT,
`name` CHAR(30) NOT NULL,
`age` SMALLINT(6) NOT NULL,
PRIMARY KEY(`id`, `category`)
INDEX `indx` (`name`(12))
);

SET foreign_key_checks = 0;
CREATE TABLE
`users` (
`category` ENUM('дом', 'работа', 'учеба') NOT NULL,
`id` MEDIUMINT NOT NULL AUTO_INCREMENT,
`name` CHAR(30) NOT NULL,
`age` SMALLINT(6) NOT NULL;

INSERT INTO table
(column1, column2, … )
VALUES
(expression1, expression2, … ),
(expression1, expression2, … ),
…;
...

...
ALTER TABLE `users` ADD PRIMARY KEY (`id`, `category`);
ALTER TABLE `users` ADD INDEX `indx` (`name`(12));
...
SET foreign_key_checks = 1;