高级搜索

数据库

ucs
SQL

CREATE TABLE `tb_search_more_log` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `user_id` int(11) NOT NULL,
 `search_key` varchar(255) NOT NULL DEFAULT '',
 `search_filter` varchar(20000) NOT NULL DEFAULT '',
 `match_fields` varchar(255) NOT NULL DEFAULT '',
 `add_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `lastupdatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 PRIMARY KEY (`id`),
 KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8