内推渠道每日数据

<p>[TOC]</p> <h5>新增表</h5> <pre><code>/******************************************/ /* DatabaseName = kyy */ /* TableName = inner_channel_summary */ /******************************************/ CREATE TABLE `inner_channel_summary` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id', `package_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '包id', `channel_id` int(10) unsigned NOT NULL COMMENT '内推渠道id', `adate` int(10) unsigned NOT NULL COMMENT '日期', `clk` int(10) unsigned NOT NULL COMMENT '点击数', `pay_order` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '已支付订单数', `amount` int(10) NOT NULL DEFAULT '0' COMMENT '金额', PRIMARY KEY (`id`), UNIQUE KEY `date_channel_pack` (`adate`,`channel_id`,`package_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='内推渠道汇总' ;</code></pre>