· 8 years ago · Jun 15, 2018, 01:16 PM
1CREATE TABLE IF NOT EXISTS `category_map` (
2 `id` int(11) NOT NULL auto_increment,
3 `category_id` int(11) NOT NULL,
4 `type` varchar(25) NOT NULL,
5 `type_id` int(11) NOT NULL,
6 PRIMARY KEY (`id`),
7 UNIQUE KEY `category_id` (`category_id`,`type`,`type_id`)
8) ENGINE=MyISAM;