-- Deploy gaia:create_table_2020_01_14_toprank to mysql

BEGIN;

-- XXX Add DDLs here.
CREATE TABLE `api_toprankbanner` (
    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
    `city_id` varchar(128),
    `rank_type` varchar(32),
    `img_src` varchar(300),
    `create_at` datetime(6) NOT NULL
) default charset utf8
;
CREATE TABLE `api_toprankmeddle` (
    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
    `city_id` varchar(128),
    `sort_idx` integer,
    `rank_type` varchar(32),
    `is_online` bool NOT NULL,
    `rid` varchar(128),
    `start_time` integer,
    `end_time` integer,
    `create_at` datetime(6) NOT NULL
) default charset utf8
;
COMMIT;
