-- Deploy gaia:2019_7_4_add_al_search_rank_table to mysql

BEGIN;

CREATE TABLE `al_search_rank` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `update_date` date NOT NULL,
  `query` varchar(128) NOT NULL,
  `search_cnt` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_key` (`update_date`,`query`)
) ENGINE=InnoDB AUTO_INCREMENT=41911 DEFAULT CHARSET=utf8mb4;

COMMIT;
