· 7 years ago · Mar 05, 2019, 02:06 AM
1CREATE TABLE IF NOT EXISTS `keywords` (
2 `kid` int(11) unsigned NOT NULL AUTO_INCREMENT,
3 `language_id` int(11) NOT NULL,
4 `keyword` varchar(120) NOT NULL,
5 PRIMARY KEY (`kid`),
6 UNIQUE KEY `custom_idx` (`language_id`,`keyword`)
7) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;