厂商广告
<p>[TOC]</p>
<h5>新增表</h5>
<pre><code>/******************************************/
/* DatabaseName = kyy */
/* TableName = mf_ad */
/******************************************/
CREATE TABLE `mf_ad` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
`package_id` int(10) unsigned NOT NULL COMMENT '包id',
`mf_id` tinyint(3) unsigned NOT NULL COMMENT '厂商id',
`ad_id` varchar(500) NOT NULL COMMENT '广告位id',
`type` tinyint(3) unsigned NOT NULL COMMENT '类型',
`status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '0 关闭 1 开启 2 删除',
PRIMARY KEY (`id`),
KEY `ad_id` (`ad_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='厂商广告'
;
/******************************************/
/* DatabaseName = kyy */
/* TableName = task_package */
/******************************************/
CREATE TABLE `task_package` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
`package_id` int(10) unsigned NOT NULL COMMENT '包id',
`task_id` int(10) unsigned NOT NULL COMMENT '任务id',
`data` varchar(500) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT 'json数据',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='包自定义任务表'
;
/******************************************/
/* DatabaseName = kyy */
/* TableName = mfad_user_log */
/******************************************/
CREATE TABLE `mfad_user_log` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
`package_id` int(10) unsigned NOT NULL COMMENT '包id',
`adate` int(10) unsigned NOT NULL COMMENT '日期',
`uid` int(10) unsigned NOT NULL COMMENT '用户id',
`type` tinyint(3) unsigned NOT NULL COMMENT '类型',
`task_id` int(10) unsigned NOT NULL COMMENT '任务id',
`mf_ad_id` int(10) unsigned NOT NULL COMMENT '厂商广告id',
PRIMARY KEY (`id`),
KEY `date` (`adate`) USING BTREE,
KEY `uid` (`uid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='厂商广告用户日志'
;
/******************************************/
/* DatabaseName = kyy */
/* TableName = mf_ad_summary */
/******************************************/
CREATE TABLE `mf_ad_summary` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
`package_id` int(10) unsigned NOT NULL COMMENT '包ID',
`adate` int(10) unsigned NOT NULL COMMENT '日期',
`mf_ad_id` int(10) unsigned NOT NULL COMMENT '广告id',
`type` tinyint(3) unsigned NOT NULL COMMENT '统计类型',
`user` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '人数',
`distinct_user` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '去重人数',
PRIMARY KEY (`id`),
KEY `date` (`adate`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='厂商广告统计'
;
</code></pre>