game-sdk/data/sql/update_20201215.sql

CREATE TABLE `h_agent_game_date_cost` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `agent_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '渠道ID',
    `app_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '游戏ID',
    `date` date NOT NULL COMMENT '日期',
    `cost` decimal(12,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '成本',
    `create_time` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
    `update_time` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
    PRIMARY KEY (`id`),
    UNIQUE KEY `agent_game_date_unique` (`agent_id`,`app_id`,`date`),
    KEY `gad_app_index` (`app_id`),
    KEY `gad_agent_index` (`agent_id`),
    KEY `gad_date_index` (`date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='游戏渠道每日成本表';