# Host: localhost (Version: 5.7.26) # Date: 2023-04-04 14:49:51 # Generator: MySQL-Front 5.3 (Build 4.234) /*!40101 SET NAMES utf8 */; # # Structure for table "eb_article" # CREATE TABLE `eb_article` ( `article_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '文章管理ID', `cid` int(11) unsigned DEFAULT '0' COMMENT '分类id', `title` varchar(64) NOT NULL COMMENT '文章标题', `author` varchar(32) DEFAULT NULL COMMENT '文章作者', `image_input` varchar(128) NOT NULL COMMENT '文章图片', `synopsis` varchar(128) DEFAULT NULL COMMENT '文章简介', `visit` varchar(255) DEFAULT NULL COMMENT '浏览次数', `sort` int(10) unsigned DEFAULT '0' COMMENT '排序', `url` varchar(128) DEFAULT NULL COMMENT '原文链接', `admin_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '管理员id', `mer_id` int(10) unsigned DEFAULT '0' COMMENT '商户id', `is_hot` tinyint(1) unsigned DEFAULT '0' COMMENT '是否热门(小程序)', `is_banner` tinyint(1) unsigned DEFAULT '0' COMMENT '是否轮播图(小程序)', `status` tinyint(1) unsigned DEFAULT NULL COMMENT '状态', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间', `wechat_news_id` int(11) DEFAULT '0' COMMENT '微信图文id', PRIMARY KEY (`article_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=151 DEFAULT CHARSET=utf8 COMMENT='文章管理表'; # # Data for table "eb_article" # INSERT INTO `eb_article` VALUES (149,16,'CRMEB多商户演示平台','crmeb','https://cremb.oss-cn-beijing.aliyuncs.com/c09b6202007091814409216.png','多商户演示',NULL,0,'',12,0,1,1,0,'2020-07-14 10:41:13',0),(150,18,'CRMEB多商户演示平台','crmeb','https://cremb.oss-cn-beijing.aliyuncs.com/c09b6202007091814409216.png','CRMEB多商户演示平台',NULL,0,'',12,0,1,1,0,'2020-07-14 10:42:30',0); # # Structure for table "eb_article_category" # CREATE TABLE `eb_article_category` ( `article_category_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '文章分类id', `pid` int(11) NOT NULL DEFAULT '0' COMMENT '父级ID', `mer_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商户 id', `title` varchar(32) NOT NULL COMMENT '文章分类标题', `info` varchar(255) DEFAULT NULL COMMENT '文章分类简介', `image` varchar(128) NOT NULL COMMENT '文章分类图片', `status` tinyint(1) unsigned NOT NULL COMMENT '状态', `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间', PRIMARY KEY (`article_category_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='文章分类表'; # # Data for table "eb_article_category" # INSERT INTO `eb_article_category` VALUES (16,0,0,'平台活动','最新活动介绍','https://cremb.oss-cn-beijing.aliyuncs.com/c57f7202007092057158018.jpeg',1,5,'2020-07-14 10:37:01'),(17,0,0,'最新优惠','优惠活动','https://cremb.oss-cn-beijing.aliyuncs.com/10a33202007092100053405.jpeg',1,4,'2020-07-14 10:37:26'),(18,0,0,'平台公告','官方公告','https://cremb.oss-cn-beijing.aliyuncs.com/f7797202007092058528666.jpeg',1,3,'2020-07-14 10:37:51'); # # Structure for table "eb_article_content" # CREATE TABLE `eb_article_content` ( `article_content_id` int(10) unsigned NOT NULL COMMENT '文章id', `content` text NOT NULL COMMENT '文章内容', UNIQUE KEY `article_content_id` (`article_content_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文章内容表'; # # Data for table "eb_article_content" # INSERT INTO `eb_article_content` VALUES (149,'
CRMEB多商户演示平台,CRMEB多商户演示平台CRMEB多商户演示平台CRMEB多商户演示平台。CRMEB多商户演示平台,CRMEB多商户演示平台,CRMEB多商户演示平台CRMEB多商户演示平台CRMEB多商户演示平台。CRMEB多商户演示平台,CRMEB多商户演示平台,CRMEB多商户演示平台CRMEB多商户演示平台CRMEB多商户演示平台。CRMEB多商户演示平台,CRMEB多商户演示平台,CRMEB多商户演示平台CRMEB多商户演示平台CRMEB多商户演示平台。CRMEB多商户演示平台CRMEB多商户演示平台,CRMEB多商户演示平台CRMEB多商户演示平台CRMEB多商户演示平台。CRMEB多商户演示
CRMEB多商户演示平台,CRMEB多商户演示平台CRMEB多商户演示平台CRMEB多商户演示平台。CRMEB多商户演示平台
CRMEB多商户演示平台,CRMEB多商户演示平台CRMEB多商户演示平台CRMEB多商户演示平台。CRMEB多商户演示平台CRMEB多商户演示平台,CRMEB多商户演示平台CRMEB多商户演示平台CRMEB多商户演示平台。CRMEB多商户演示平台CRMEB多商户演示平台,CRMEB多商户演示平台CRMEB多商户演示平台CRMEB多商户演示平台。CRMEB多商户演示平台
CRMEB多商户演示平台,CRMEB多商户演示平台CRMEB多商户演示平台CRMEB多商户演示平台。CRMEB多商户演示平台CRMEB多商户演示平台,CRMEB多商户演示平台CRMEB多商户演示平台CRMEB多商户演示平台。CRMEB多商户演示平台CRMEB多商户演示平台,CRMEB多商户演示平台CRMEB多商户演示平台CRMEB多商户演示平台。CRMEB多商户演示平台CRMEB多商户演示平台,CRMEB多商户演示平台CRMEB多商户演示平台CRMEB多商户演示平台。CRMEB多商户演示平台。!
'),(150,'CRMEB多商户演示平台CRMEB多商户演示平台
'); # # Structure for table "eb_broadcast_assistant" # CREATE TABLE `eb_broadcast_assistant` ( `assistant_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(50) DEFAULT NULL COMMENT '微信号', `nickname` varchar(100) DEFAULT NULL COMMENT '微信昵称', `mer_id` int(11) DEFAULT NULL COMMENT '商户ID', `mark` varchar(255) DEFAULT NULL COMMENT '备注', `is_del` tinyint(1) DEFAULT '0', UNIQUE KEY `id` (`assistant_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='直播助手信息'; # # Data for table "eb_broadcast_assistant" # # # Structure for table "eb_broadcast_goods" # CREATE TABLE `eb_broadcast_goods` ( `broadcast_goods_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `mer_id` int(10) unsigned NOT NULL COMMENT '商户 id', `goods_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '微信商品ID', `audit_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '审核单 id', `cover_img` varchar(255) NOT NULL COMMENT '图片', `name` varchar(64) NOT NULL COMMENT '商品名称', `price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '价格', `product_type` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '商品类型', `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商品 id', `error_msg` varchar(255) DEFAULT NULL COMMENT '未通过原因', `audit_status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0:未审核,1:审核中,2:审核通过,3审核失败', `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '审核状态0=未审核1=微信审核2=审核通过-1=审核未通过', `is_show` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否显示', `is_mer_show` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '商户是否显示', `mark` varchar(512) DEFAULT NULL COMMENT '备注', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `sort` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `is_del` tinyint(1) unsigned NOT NULL DEFAULT '0', `is_mer_del` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '商户是否删除', PRIMARY KEY (`broadcast_goods_id`) USING BTREE, KEY `mer_id` (`mer_id`) USING BTREE, KEY `goods_id` (`goods_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='直播商品表'; # # Data for table "eb_broadcast_goods" # # # Structure for table "eb_broadcast_room" # CREATE TABLE `eb_broadcast_room` ( `broadcast_room_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `mer_id` int(10) unsigned NOT NULL COMMENT '商户 id', `room_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '直播间 id', `name` varchar(32) NOT NULL COMMENT '直播间名字', `cover_img` varchar(255) NOT NULL COMMENT '背景图', `share_img` varchar(255) NOT NULL COMMENT '分享图', `start_time` timestamp NULL DEFAULT NULL COMMENT '直播计划开始时间', `end_time` timestamp NULL DEFAULT NULL COMMENT '直播计划结束时间', `anchor_name` varchar(32) NOT NULL COMMENT '主播昵称', `anchor_wechat` varchar(32) NOT NULL COMMENT '主播微信号', `phone` varchar(32) NOT NULL COMMENT '主播手机号', `type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '直播间类型 【1: 推流,0:手机直播】', `screen_type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '横屏、竖屏 【1:横屏,0:竖屏】', `close_like` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否关闭点赞', `close_goods` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否关闭货架', `close_comment` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否关闭评论', `close_share` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否关闭分享', `close_kf` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否关闭客服', `error_msg` varchar(255) DEFAULT NULL COMMENT '未通过原因', `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '审核状态0=未审核1=微信审核2=审核通过-1=审核未通过', `live_status` smallint(5) unsigned NOT NULL DEFAULT '102' COMMENT '直播状态101:直播中,102:未开始,103已结束,104禁播,105:暂停,106:异常,107:已过期', `mark` varchar(512) DEFAULT NULL COMMENT '备注', `replay_status` tinyint(1) unsigned DEFAULT '0' COMMENT '回放状态', `is_mer_show` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '商户是否显示', `is_show` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否显示', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间', `star` smallint(1) unsigned NOT NULL DEFAULT '1' COMMENT '推荐星级', `sort` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `is_del` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除', `is_mer_del` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '商户是否删除', `feeds_img` varchar(255) DEFAULT NULL COMMENT '封面图', `push_url` varchar(255) DEFAULT NULL COMMENT '推流地址', `assistant_id` varchar(255) DEFAULT NULL COMMENT '小助手ID', `is_feeds_public` tinyint(1) unsigned DEFAULT '0' COMMENT '是否开启官方收录,1 开启,0 关闭', PRIMARY KEY (`broadcast_room_id`) USING BTREE, KEY `mer_id` (`mer_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='直播间表'; # # Data for table "eb_broadcast_room" # # # Structure for table "eb_broadcast_room_goods" # CREATE TABLE `eb_broadcast_room_goods` ( `broadcast_room_id` int(10) unsigned NOT NULL, `broadcast_goods_id` int(10) unsigned NOT NULL, `on_sale` tinyint(2) DEFAULT '1' COMMENT '商品上下架', KEY `broadcast_room_id` (`broadcast_room_id`,`broadcast_goods_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='直播间导入商品表'; # # Data for table "eb_broadcast_room_goods" # # # Structure for table "eb_cache" # CREATE TABLE `eb_cache` ( `key` varchar(32) NOT NULL, `expire_time` int(11) NOT NULL DEFAULT '0' COMMENT '0=永久', `result` longtext NOT NULL COMMENT '缓存数据', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '缓存时间', PRIMARY KEY (`key`) USING BTREE, KEY `key` (`key`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='微信缓存表'; # # Data for table "eb_cache" # INSERT INTO `eb_cache` VALUES ('platform_rule',0,'\" 平台规则<\\/strong><\\/p> <\\/span><\\/span><\\/strong><\\/p> 第一章<\\/span> 概述<\\/span><\\/span><\\/strong><\\/p> 第一条<\\/span> 本规则适用于<\\/span><\\/span>CRMEB<\\/span>开放平台商家,商家可以根据业务需求选择经营模式以通过<\\/span>CRMEB<\\/span>开放平台向消费者销售商品或提供服务。本规则不适用于<\\/span>CRMEB<\\/span>自营商品及信息。<\\/span><\\/p> 第二条<\\/span> 为促进平等、开放、透明的平台生态的搭建,根据《<\\/span><\\/span>CRMEB<\\/span>用户注册协议》、《<\\/span>“<\\/span><\\/span>CRMEB***<\\/span>.COM”开放平台服务协议》等服务\\/合作协议,制定本规则。<\\/span><\\/p> 第三条<\\/span> <\\/span><\\/span>CRMEB<\\/span>开放平台总则,是对<\\/span>CRMEB<\\/span>商家增加基本义务或规范商家行使基本权利的条款。<\\/span><\\/p> 第四条<\\/span> 违规行为的认定与处理,<\\/span><\\/span>CRMEB<\\/span>将基于法律法规的规定、协议的约定、消费者和商家提供的证据材料以及平台记录的相关信息等做出判断并依据相关规则严格执行。<\\/span>CRMEB<\\/span>商家在适用规则上一律平等。<\\/span><\\/p> 第五条<\\/span> 商家应遵守国家法律、行政法规、部门规章等规范性文件。对任何涉嫌违反国家法律、行政法规、部门规章等规范性文件的行为,本规则已有规定的,适用本规则;本规则尚无规定的,<\\/span><\\/span>CRMEB<\\/span>有权依据相应规则酌情处理,但<\\/span>CRMEB<\\/span>对商家的处理不免除商家因违法、违约等行为应承担的法律责任。<\\/span><\\/p> 第六条<\\/span> 商家在<\\/span><\\/span>CRMEB<\\/span>的任何行为,应同时遵守与<\\/span>CRMEB<\\/span>所签订的各项协议。<\\/span><\\/p> 第七条<\\/span> <\\/span><\\/span>CRMEB<\\/span>有权随时变更本规则并在规则平台或商家管理系统等渠道予以公告。若商家不同意相关变更,应立即停止使用<\\/span>CRMEB<\\/span>开放平台提供的相关服务,并及时通知<\\/span>CRMEB<\\/span>。<\\/span>CRMEB<\\/span>有权对商家行为及应适用的规则<\\/span>\\/协议约定进行单方认定,并据此处理。<\\/span><\\/span><\\/p> <\\/span><\\/p> 第二章<\\/span> 入驻<\\/span><\\/span><\\/strong><\\/p> 第八条<\\/span> 用户应当严格遵守<\\/span><\\/span>CRMEB<\\/span>系统设置的注册流程完成注册,并严格遵守《<\\/span>CRMEB<\\/span>用户注册协议》的规定。用户在选择用户名时须遵守国家法律法规,不得包含违法或涉嫌侵犯他人权利等的相关信息。<\\/span><\\/p> 第九条<\\/span> 用户必须满足以下条件,才有权申请加入<\\/span><\\/span>CRMEB<\\/span>,成为商家:<\\/span><\\/p> (一)<\\/span> 商家应符合<\\/span><\\/span>《<\\/span><\\/span><\\/span>CRMEB<\\/span><\\/span><\\/span>开放平台招商标准》<\\/span><\\/span><\\/span><\\/a>。<\\/span><\\/p> (二)<\\/span> 商家及其销售的商品或提供的服务应符合<\\/span><\\/span>《<\\/span><\\/span><\\/span>CRMEB<\\/span><\\/span><\\/span>开放平台招商基础资质标准》<\\/span><\\/span><\\/span><\\/a>并符合<\\/span>CRMEB<\\/span>开放平台对商品质量的相关要求。<\\/span><\\/p> (三)商家有效签署《<\\/span>“<\\/span><\\/span>CRMEB***<\\/span>.COM”开放平台服务协议》并承诺遵守平台全部规则要求。<\\/span><\\/p> (四)商家须开通<\\/span>CRMEB<\\/span>钱包,并以<\\/span>CRMEB<\\/span>钱包账户作为唯一结算账户(经<\\/span>CRMEB<\\/span>开放平台确认的特殊类型商家除外)。<\\/span><\\/p> (五)<\\/span> 商家需按照开通类目的资费标准缴纳各项费用,具体标准详见<\\/span><\\/span>《<\\/span><\\/span>CRMEB<\\/span><\\/span>开放平台各类目资费一览表》<\\/span><\\/span><\\/a>。<\\/span><\\/p> (六)<\\/span> 商家满足<\\/span><\\/span>CRMEB<\\/span>开放平台要求的其他条件。<\\/span><\\/p> <\\/span><\\/p> 第三章 经营<\\/span><\\/strong><\\/p> 第十条<\\/span> 店铺<\\/span><\\/span><\\/p> (一)<\\/span> 商家申请店铺名、子域名等信息时,应须遵守国家法律法规及开放平台相关规则,不得包含违法或涉嫌侵犯他人权利等的相关信息。详细规则请参见<\\/span><\\/span>《<\\/span><\\/span><\\/span><\\/a>CRMEB<\\/span><\\/span><\\/span>开放平台商家店铺命名规则<\\/span><\\/span><\\/span><\\/a>》<\\/span><\\/span><\\/span><\\/a>、<\\/span>《<\\/span><\\/span><\\/span><\\/a>CRMEB<\\/span><\\/span><\\/span>开放平台子域名管理规则<\\/span><\\/span><\\/span><\\/a>》<\\/span><\\/span><\\/span><\\/a>。<\\/span><\\/p> (二)商家上传的店铺信息(包括但不限于店标、店铺名称、店铺公告、店铺介绍、店铺通栏、店铺活动区域等)内容设置需真实、有效且与商家注册信息一致,不得违反国家法律法规规定及平台规则等,否则<\\/span>CRMEB<\\/span>有权按<\\/span>《<\\/span><\\/span>CRMEB<\\/span><\\/span>开放平台商家违规积分管理规则》<\\/span><\\/span><\\/a>进行处理。<\\/span><\\/p> (三)<\\/span> 商家使用<\\/span><\\/span>CRMEB<\\/span>开放平台<\\/span>API接口的,须严格遵守<\\/span><\\/span>《<\\/span>API接口使用管理规定》<\\/span><\\/span><\\/span><\\/a>。<\\/span><\\/p> (四)<\\/span> 商家应遵守<\\/span><\\/span>《<\\/span><\\/span><\\/span>CRMEB<\\/span><\\/span><\\/span>开放平台保证金管理规定》<\\/span><\\/span><\\/span><\\/a>及时缴存及补缴保证金。<\\/span><\\/p>
<\\/p>