okayapi_admanage_adeffect_h

-- MySQL Table okayapi_admanage_adeffect_h
-- From: OkayAPI.com
CREATE TABLE `okayapi_admanage_adeffect_h` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `AdID` int(10) NOT NULL COMMENT '广告编号',
    `okayapi_admanage_adeffect_h_Hour` varchar(2) NOT NULL COMMENT '时',
    `okayapi_admanage_adeffect_h_Day` varchar(2) NOT NULL COMMENT '天',
    `okayapi_admanage_adeffect_h_Month` varchar(2) NOT NULL COMMENT '月',
    `okayapi_admanage_adeffect_h_Year` varchar(5) NOT NULL COMMENT '年',
    `AdShow` varchar(10) NOT NULL COMMENT '广告展现量',
    `AdClick` varchar(10) NOT NULL COMMENT '广告点击量',
    `AdConver` varchar(10) NOT NULL COMMENT '广告转换量',
    `AdShowPeo` varchar(10) NOT NULL COMMENT '展现量对应人数',
    `AdClickPeo` varchar(10) NOT NULL COMMENT '点击量对应人数',
    `AdCoverPeo` varchar(10) NOT NULL COMMENT '转换量对应人数',
    KEY `AdID` (`AdID`),
    KEY `okayapi_admanage_adeffect_h_Hour` (`okayapi_admanage_adeffect_h_Hour`),
    KEY `okayapi_admanage_adeffect_h_Day` (`okayapi_admanage_adeffect_h_Day`),
    KEY `okayapi_admanage_adeffect_h_Month` (`okayapi_admanage_adeffect_h_Month`),
    KEY `okayapi_admanage_adeffect_h_Year` (`okayapi_admanage_adeffect_h_Year`),
    KEY `AdShow` (`AdShow`),
    KEY `AdClick` (`AdClick`),
    KEY `AdConver` (`AdConver`),
    KEY `AdShowPeo` (`AdShowPeo`),
    KEY `AdClickPeo` (`AdClickPeo`),
    KEY `AdCoverPeo` (`AdCoverPeo`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '广告管理-广告效果统计小时粒度表';

After replication, you can go to the database to create the database table.