CREATE TABLE `db_keyword` (
`keyword_id` int(11) UNSIGNED NOT NULL,
`type` enum('host','path') NOT NULL,
`route` enum('location/location','product/product') NOT NULL,
`key` varchar(191) NOT NULL,
`value` varchar(191) NOT NULL,
`name` varchar(255) NOT NULL,
`keyword` varchar(191) NOT NULL,
`group` varchar(191) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
ALTER TABLE `db_keyword`
ADD PRIMARY KEY (`keyword_id`),
ADD KEY `type` (`type`),
ADD KEY `route` (`route`),
ADD KEY `key` (`key`),
ADD KEY `value` (`value`),
ADD FULLTEXT `keyword` (`keyword`);
ALTER TABLE `db_keyword`
MODIFY `keyword_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
INSERT INTO `db_keyword` (`keyword_id`, `type`, `route`, `key`, `value`, `name`, `keyword`, `group`) VALUES
(1, 'path', 'product/product', 'product_id', '1', 'ID', 'smartphone', '0'),
(2, 'path', 'product/product', 'product_id', '2', 'ID', 'ventilador', '0'),
(3, 'path', 'product/product', 'product_id', '3', 'ID', 'geladeira', '0'),
(4, 'path', 'product/product', 'product_id', '4', 'ID', 'geladeira-frost-free', '0'),
(5, 'path', 'location/location', 'location_id', '1', 'ID', 'sao-paulo-sp', '0'),
(6, 'path', 'location/location', 'location_id', '2', 'ID', 'americana-sp', '0'),
(7, 'path', 'location/location', 'location_id', '3', 'ID', 'campinas-sp', '0'),
(8, 'path', 'location/location', 'location_id', '4', 'ID', 'sao-pedro-sp', '0'),
(9, 'path', 'product/product', 'product_id', '5', 'ID', 'geladeira-mini', '0'),
(10, 'path', 'product/product', 'product_id', '6', 'ID', 'geladeira-minis', '0'),
(11, 'path', 'product/product', 'product_id', '7', 'ID', 'geladeira-duplex', '0');
#SELECT * FROM `db_keyword` WHERE MATCH (`keyword`) AGAINST ('smartphone-em-sao-paulo-sp' IN NATURAL LANGUAGE MODE);