## 数据库结构 也可以在后台维护->数据备份查看表详情 ```[sql] -- ---------------------------- -- Table structure for `eb_article` -- ---------------------------- DROP TABLE IF EXISTS `eb_article`; CREATE TABLE `eb_article` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '文章管理ID', `cid` varchar(255) DEFAULT '1' COMMENT '分类id', `title` varchar(255) NOT NULL COMMENT '文章标题', `author` varchar(255) DEFAULT NULL COMMENT '文章作者', `image_input` varchar(255) NOT NULL COMMENT '文章图片', `synopsis` varchar(255) DEFAULT NULL COMMENT '文章简介', `share_title` varchar(255) DEFAULT NULL COMMENT '文章分享标题', `share_synopsis` varchar(255) DEFAULT NULL COMMENT '文章分享简介', `visit` varchar(255) DEFAULT NULL COMMENT '浏览次数', `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `url` varchar(255) DEFAULT NULL COMMENT '原文链接', `status` tinyint(1) unsigned NOT NULL COMMENT '状态', `add_time` varchar(255) NOT NULL COMMENT '添加时间', `hide` tinyint(1) unsigned NOT NULL DEFAULT '0' 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 NOT NULL DEFAULT '0' COMMENT '是否热门(小程序)', `is_banner` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否轮播图(小程序)', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=152 DEFAULT CHARSET=utf8 COMMENT='文章管理表'; CREATE TABLE `eb_article` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '文章管理ID', `cid` varchar(255) DEFAULT '1' COMMENT '分类id', `title` varchar(255) NOT NULL COMMENT '文章标题', `author` varchar(255) DEFAULT NULL COMMENT '文章作者', `image_input` varchar(255) NOT NULL COMMENT '文章图片', `synopsis` varchar(255) DEFAULT NULL COMMENT '文章简介', `share_title` varchar(255) DEFAULT NULL COMMENT '文章分享标题', `share_synopsis` varchar(255) DEFAULT NULL COMMENT '文章分享简介', `visit` varchar(255) DEFAULT NULL COMMENT '浏览次数', `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `url` varchar(255) DEFAULT NULL COMMENT '原文链接', `status` tinyint(1) unsigned NOT NULL COMMENT '状态', `add_time` varchar(255) NOT NULL COMMENT '添加时间', `hide` tinyint(1) unsigned NOT NULL DEFAULT '0' 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 NOT NULL DEFAULT '0' COMMENT '是否热门(小程序)', `is_banner` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否轮播图(小程序)', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=152 DEFAULT CHARSET=utf8 COMMENT='文章管理表'; -- ---------------------------- -- Table structure for `eb_article_category` -- ---------------------------- DROP TABLE IF EXISTS `eb_article_category`; CREATE TABLE `eb_article_category` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '文章分类id', `pid` int(11) NOT NULL DEFAULT '0' COMMENT '父级ID', `title` varchar(255) NOT NULL COMMENT '文章分类标题', `intr` varchar(255) DEFAULT NULL COMMENT '文章分类简介', `image` varchar(255) NOT NULL COMMENT '文章分类图片', `status` tinyint(1) unsigned NOT NULL COMMENT '状态', `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `is_del` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '1删除0未删除', `add_time` varchar(255) NOT NULL COMMENT '添加时间', `hidden` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否隐藏', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COMMENT='文章分类表'; -- ---------------------------- -- Table structure for `eb_article_content` -- ---------------------------- DROP TABLE IF EXISTS `eb_article_content`; CREATE TABLE `eb_article_content` ( `nid` int(10) unsigned NOT NULL COMMENT '文章id', `content` text NOT NULL COMMENT '文章内容', UNIQUE KEY `nid` (`nid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='文章内容表'; -- ---------------------------- -- Table structure for `eb_cache` -- ---------------------------- DROP TABLE IF EXISTS `eb_cache`; CREATE TABLE `eb_cache` ( `key` varchar(32) NOT NULL, `result` text COMMENT '缓存数据', `add_time` int(10) DEFAULT NULL COMMENT '缓存时间', PRIMARY KEY (`key`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='记录缓存'; -- ---------------------------- -- Table structure for `eb_express` -- ---------------------------- DROP TABLE IF EXISTS `eb_express`; CREATE TABLE `eb_express` ( `id` mediumint(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '快递公司id', `code` varchar(50) NOT NULL COMMENT '快递公司简称', `name` varchar(50) NOT NULL COMMENT '快递公司全称', `sort` int(11) NOT NULL COMMENT '排序', `is_show` tinyint(1) NOT NULL COMMENT '是否显示', PRIMARY KEY (`id`), UNIQUE KEY `code` (`code`) USING BTREE, KEY `is_show` (`is_show`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=426 DEFAULT CHARSET=utf8 COMMENT='快递公司表'; -- ---------------------------- -- Table structure for `eb_routine_access_token` -- ---------------------------- DROP TABLE IF EXISTS `eb_routine_access_token`; CREATE TABLE `eb_routine_access_token` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '小程序access_token表ID', `access_token` varchar(256) NOT NULL COMMENT 'openid', `stop_time` int(11) unsigned NOT NULL COMMENT '添加时间', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='小程序access_token表'; -- ---------------------------- -- Table structure for `eb_routine_form_id` -- ---------------------------- DROP TABLE IF EXISTS `eb_routine_form_id`; CREATE TABLE `eb_routine_form_id` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '表单ID表ID', `uid` int(11) DEFAULT '0' COMMENT '用户uid', `form_id` varchar(32) NOT NULL COMMENT '表单ID', `stop_time` int(11) unsigned DEFAULT NULL COMMENT '表单ID失效时间', `status` tinyint(1) unsigned DEFAULT '0' COMMENT '状态1 未使用 2不能使用', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=1041 DEFAULT CHARSET=utf8 COMMENT='表单id表记录表'; -- ---------------------------- -- Table structure for `eb_routine_qrcode` -- ---------------------------- DROP TABLE IF EXISTS `eb_routine_qrcode`; CREATE TABLE `eb_routine_qrcode` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '微信二维码ID', `third_type` varchar(32) NOT NULL COMMENT '二维码类型 spread(用户推广) product_spread(产品推广)', `third_id` int(11) unsigned NOT NULL COMMENT '用户id', `status` tinyint(1) unsigned DEFAULT '1' COMMENT '状态 0不可用 1可用', `add_time` varchar(255) DEFAULT NULL COMMENT '添加时间', `page` varchar(255) DEFAULT NULL COMMENT '小程序页面路径带参数', `qrcode_url` varchar(255) DEFAULT NULL COMMENT '小程序二维码路径', `url_time` int(11) unsigned DEFAULT NULL COMMENT '二维码添加时间', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=512 DEFAULT CHARSET=utf8 COMMENT='小程序二维码管理表'; -- ---------------------------- -- Table structure for `eb_routine_template` -- ---------------------------- DROP TABLE IF EXISTS `eb_routine_template`; CREATE TABLE `eb_routine_template` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '模板id', `tempkey` char(50) NOT NULL COMMENT '模板编号', `name` char(100) NOT NULL COMMENT '模板名', `content` varchar(1000) NOT NULL COMMENT '回复内容', `tempid` char(100) DEFAULT NULL COMMENT '模板ID', `add_time` varchar(15) NOT NULL COMMENT '添加时间', `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '状态', PRIMARY KEY (`id`), KEY `tempkey` (`tempkey`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COMMENT='微信模板'; -- ---------------------------- -- Table structure for `eb_server_upgrade_log` -- ---------------------------- DROP TABLE IF EXISTS `eb_server_upgrade_log`; CREATE TABLE `eb_server_upgrade_log` ( `id` int(12) NOT NULL AUTO_INCREMENT, `versionid` int(50) NOT NULL COMMENT '更新的版本表ID', `webid` int(20) NOT NULL COMMENT '站点ID', `update_time` int(12) NOT NULL COMMENT '更新时间', `versionbefor` varchar(50) NOT NULL COMMENT '更新前版本号', `versionend` varchar(50) NOT NULL COMMENT '更新后版本号', `content` varchar(3000) NOT NULL, `type` char(20) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=146 DEFAULT CHARSET=utf8 COMMENT='在线升级明细记录表'; -- ---------------------------- -- Table structure for `eb_store_bargain` -- ---------------------------- DROP TABLE IF EXISTS `eb_store_bargain`; CREATE TABLE `eb_store_bargain` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '砍价产品ID', `product_id` int(11) unsigned NOT NULL COMMENT '关联产品ID', `title` varchar(255) NOT NULL COMMENT '砍价活动名称', `image` varchar(150) NOT NULL COMMENT '砍价活动图片', `unit_name` varchar(16) DEFAULT NULL COMMENT '单位名称', `stock` int(11) unsigned DEFAULT NULL COMMENT '库存', `sales` int(11) unsigned DEFAULT NULL COMMENT '销量', `images` varchar(1000) NOT NULL COMMENT '砍价产品轮播图', `start_time` int(11) unsigned NOT NULL COMMENT '砍价开启时间', `stop_time` int(11) unsigned NOT NULL COMMENT '砍价结束时间', `store_name` varchar(255) DEFAULT NULL COMMENT '砍价产品名称', `price` decimal(8,2) unsigned DEFAULT NULL COMMENT '砍价金额', `min_price` decimal(8,2) unsigned DEFAULT NULL COMMENT '砍价商品最低价', `num` int(11) unsigned DEFAULT NULL COMMENT '每次购买的砍价产品数量', `bargain_max_price` decimal(8,2) unsigned DEFAULT NULL COMMENT '用户每次砍价的最大金额', `bargain_min_price` decimal(8,2) unsigned DEFAULT NULL COMMENT '用户每次砍价的最小金额', `bargain_num` int(11) unsigned NOT NULL DEFAULT '1' COMMENT '用户每次砍价的次数', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '砍价状态 0(到砍价时间不自动开启) 1(到砍价时间自动开启时间)', `description` text COMMENT '砍价详情', `give_integral` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '反多少积分', `info` varchar(255) DEFAULT NULL COMMENT '砍价活动简介', `cost` decimal(8,2) unsigned DEFAULT NULL COMMENT '成本价', `sort` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `is_hot` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否推荐0不推荐1推荐', `is_del` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除 0未删除 1删除', `add_time` int(11) unsigned NOT NULL COMMENT '添加时间', `is_postage` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否包邮 0不包邮 1包邮', `postage` decimal(10,2) unsigned DEFAULT NULL COMMENT '邮费', `rule` text COMMENT '砍价规则', `look` int(11) unsigned DEFAULT '0' COMMENT '砍价产品浏览量', `share` int(11) unsigned DEFAULT '0' COMMENT '砍价产品分享量', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 COMMENT='砍价表'; -- ---------------------------- -- Table structure for `eb_store_bargain_user` -- ---------------------------- DROP TABLE IF EXISTS `eb_store_bargain_user`; CREATE TABLE `eb_store_bargain_user` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户参与砍价表ID', `uid` int(11) unsigned DEFAULT NULL COMMENT '用户ID', `bargain_id` int(11) unsigned DEFAULT NULL COMMENT '砍价产品id', `bargain_price_min` decimal(8,2) unsigned DEFAULT NULL COMMENT '砍价的最低价', `bargain_price` decimal(8,2) DEFAULT NULL COMMENT '砍价金额', `price` decimal(8,2) unsigned DEFAULT NULL COMMENT '砍掉的价格', `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态 1参与中 2 活动结束参与失败 3活动结束参与成功', `add_time` int(11) unsigned DEFAULT NULL COMMENT '参与时间', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=259 DEFAULT CHARSET=utf8 COMMENT='用户参与砍价表'; -- ---------------------------- -- Table structure for `eb_store_bargain_user_help` -- ---------------------------- DROP TABLE IF EXISTS `eb_store_bargain_user_help`; CREATE TABLE `eb_store_bargain_user_help` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '砍价用户帮助表ID', `uid` int(11) unsigned DEFAULT NULL COMMENT '帮助的用户id', `bargain_id` int(11) unsigned DEFAULT NULL COMMENT '砍价产品ID', `bargain_user_id` int(11) unsigned DEFAULT NULL COMMENT '用户参与砍价表id', `price` decimal(8,2) unsigned DEFAULT NULL COMMENT '帮助砍价多少金额', `add_time` int(11) unsigned DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=353 DEFAULT CHARSET=utf8 COMMENT='砍价用户帮助表'; -- ---------------------------- -- Table structure for `eb_store_cart` -- ---------------------------- DROP TABLE IF EXISTS `eb_store_cart`; CREATE TABLE `eb_store_cart` ( `id` bigint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '购物车表ID', `uid` int(10) unsigned NOT NULL COMMENT '用户ID', `type` varchar(32) NOT NULL COMMENT '类型', `product_id` int(10) unsigned NOT NULL COMMENT '商品ID', `product_attr_unique` varchar(16) NOT NULL DEFAULT '' COMMENT '商品属性', `cart_num` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '商品数量', `add_time` int(10) unsigned NOT NULL COMMENT '添加时间', `is_pay` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0 = 未购买 1 = 已购买', `is_del` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除', `is_new` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否为立即购买', `combination_id` int(11) unsigned NOT NULL COMMENT '拼团id', `seckill_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '秒杀产品ID', `bargain_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '砍价id', PRIMARY KEY (`id`), KEY `user_id` (`uid`) USING BTREE, KEY `goods_id` (`product_id`) USING BTREE, KEY `uid` (`uid`,`is_pay`) USING BTREE, KEY `uid_2` (`uid`,`is_del`) USING BTREE, KEY `uid_3` (`uid`,`is_new`) USING BTREE, KEY `type` (`type`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=2080 DEFAULT CHARSET=utf8 COMMENT='购物车表'; -- ---------------------------- -- Table structure for `eb_store_category` -- ---------------------------- DROP TABLE IF EXISTS `eb_store_category`; CREATE TABLE `eb_store_category` ( `id` mediumint(11) NOT NULL AUTO_INCREMENT COMMENT '商品分类表ID', `pid` mediumint(11) NOT NULL COMMENT '父id', `cate_name` varchar(100) NOT NULL COMMENT '分类名称', `sort` mediumint(11) NOT NULL COMMENT '排序', `pic` varchar(128) NOT NULL DEFAULT '' COMMENT '图标', `is_show` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否推荐', `add_time` int(11) NOT NULL COMMENT '添加时间', PRIMARY KEY (`id`), KEY `pid` (`pid`) USING BTREE, KEY `is_base` (`is_show`) USING BTREE, KEY `sort` (`sort`) USING BTREE, KEY `add_time` (`add_time`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT='商品分类表'; -- ---------------------------- -- Table structure for `eb_store_combination` -- ---------------------------- DROP TABLE IF EXISTS `eb_store_combination`; CREATE TABLE `eb_store_combination` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `product_id` int(10) unsigned NOT NULL COMMENT '商品id', `mer_id` int(10) unsigned DEFAULT '0' COMMENT '商户id', `image` varchar(255) NOT NULL COMMENT '推荐图', `images` varchar(1000) NOT NULL COMMENT '轮播图', `title` varchar(255) NOT NULL COMMENT '活动标题', `attr` varchar(255) NOT NULL COMMENT '活动属性', `people` int(2) unsigned NOT NULL COMMENT '参团人数', `info` varchar(255) NOT NULL COMMENT '简介', `price` decimal(10,2) unsigned NOT NULL COMMENT '价格', `sort` int(10) unsigned NOT NULL COMMENT '排序', `sales` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '销量', `stock` int(10) unsigned NOT NULL COMMENT '库存', `add_time` varchar(128) NOT NULL COMMENT '添加时间', `is_host` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '推荐', `is_show` tinyint(1) unsigned NOT NULL COMMENT '产品状态', `is_del` tinyint(1) unsigned NOT NULL DEFAULT '0', `combination` tinyint(1) unsigned NOT NULL DEFAULT '1', `mer_use` tinyint(1) unsigned NOT NULL COMMENT '商户是否可用1可用0不可用', `is_postage` tinyint(1) unsigned NOT NULL COMMENT '是否包邮1是0否', `postage` decimal(10,2) unsigned NOT NULL COMMENT '邮费', `description` text NOT NULL COMMENT '拼团内容', `start_time` int(11) unsigned NOT NULL COMMENT '拼团开始时间', `stop_time` int(11) unsigned NOT NULL COMMENT '拼团结束时间', `cost` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '拼图产品成本', `browse` int(11) DEFAULT '0' COMMENT '浏览量', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='拼团产品表'; -- ---------------------------- -- Table structure for `eb_store_combination_attr` -- ---------------------------- DROP TABLE IF EXISTS `eb_store_combination_attr`; CREATE TABLE `eb_store_combination_attr` ( `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商品ID', `attr_name` varchar(32) NOT NULL COMMENT '属性名', `attr_values` varchar(256) NOT NULL COMMENT '属性值', KEY `store_id` (`product_id`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='商品属性表'; -- ---------------------------- -- Table structure for `eb_store_combination_attr_result` -- ---------------------------- DROP TABLE IF EXISTS `eb_store_combination_attr_result`; CREATE TABLE `eb_store_combination_attr_result` ( `product_id` int(10) unsigned NOT NULL COMMENT '商品ID', `result` text NOT NULL COMMENT '商品属性参数', `change_time` int(10) unsigned NOT NULL COMMENT '上次修改时间', UNIQUE KEY `product_id` (`product_id`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='商品属性详情表'; -- ---------------------------- -- Table structure for `eb_store_combination_attr_value` -- ---------------------------- DROP TABLE IF EXISTS `eb_store_combination_attr_value`; CREATE TABLE `eb_store_combination_attr_value` ( `product_id` int(10) unsigned NOT NULL COMMENT '商品ID', `suk` varchar(128) NOT NULL COMMENT '商品属性索引值 (attr_value|attr_value[|....])', `stock` int(10) unsigned NOT NULL COMMENT '属性对应的库存', `sales` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '销量', `price` decimal(8,2) unsigned NOT NULL COMMENT '属性金额', `image` varchar(128) DEFAULT NULL COMMENT '图片', `unique` char(8) NOT NULL DEFAULT '' COMMENT '唯一值', `cost` decimal(8,2) unsigned NOT NULL COMMENT '成本价', UNIQUE KEY `unique` (`unique`,`suk`) USING BTREE, KEY `store_id` (`product_id`,`suk`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='商品属性值表'; -- ---------------------------- -- Table structure for `eb_store_coupon` -- ---------------------------- DROP TABLE IF EXISTS `eb_store_coupon`; CREATE TABLE `eb_store_coupon` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '优惠券表ID', `title` varchar(64) NOT NULL COMMENT '优惠券名称', `integral` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '兑换消耗积分值', `coupon_price` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '兑换的优惠券面值', `use_min_price` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '最低消费多少金额可用优惠券', `coupon_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '优惠券有效期限(单位:天)', `sort` int(11) unsigned NOT NULL DEFAULT '1' COMMENT '排序', `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态(0:关闭,1:开启)', `add_time` int(11) unsigned NOT NULL COMMENT '兑换项目添加时间', `is_del` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除', PRIMARY KEY (`id`), KEY `state` (`status`) USING BTREE, KEY `add_time` (`add_time`) USING BTREE, KEY `coupon_time` (`coupon_time`) USING BTREE, KEY `is_del` (`is_del`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=83 DEFAULT CHARSET=utf8 COMMENT='优惠券表'; -- ---------------------------- -- Table structure for `eb_store_coupon_issue` -- ---------------------------- DROP TABLE IF EXISTS `eb_store_coupon_issue`; CREATE TABLE `eb_store_coupon_issue` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `cid` int(10) DEFAULT NULL COMMENT '优惠券ID', `start_time` int(10) DEFAULT NULL COMMENT '优惠券领取开启时间', `end_time` int(10) DEFAULT NULL COMMENT '优惠券领取结束时间', `total_count` int(10) DEFAULT NULL COMMENT '优惠券领取数量', `remain_count` int(10) DEFAULT NULL COMMENT '优惠券剩余领取数量', `is_permanent` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否无限张数', `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1 正常 0 未开启 -1 已无效', `is_del` tinyint(1) unsigned NOT NULL DEFAULT '0', `add_time` int(10) DEFAULT NULL COMMENT '优惠券添加时间', PRIMARY KEY (`id`), KEY `cid` (`cid`) USING BTREE, KEY `start_time` (`start_time`,`end_time`) USING BTREE, KEY `remain_count` (`remain_count`) USING BTREE, KEY `status` (`status`) USING BTREE, KEY `is_del` (`is_del`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=83 DEFAULT CHARSET=utf8 COMMENT='优惠券前台领取表'; -- ---------------------------- -- Table structure for `eb_store_coupon_issue_user` -- ---------------------------- DROP TABLE IF EXISTS `eb_store_coupon_issue_user`; CREATE TABLE `eb_store_coupon_issue_user` ( `uid` int(10) DEFAULT NULL COMMENT '领取优惠券用户ID', `issue_coupon_id` int(10) DEFAULT NULL COMMENT '优惠券前台领取ID', `add_time` int(10) DEFAULT NULL COMMENT '领取时间', UNIQUE KEY `uid` (`uid`,`issue_coupon_id`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='优惠券前台用户领取记录表'; -- ---------------------------- -- Table structure for `eb_store_coupon_user` -- ---------------------------- DROP TABLE IF EXISTS `eb_store_coupon_user`; CREATE TABLE `eb_store_coupon_user` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '优惠券发放记录id', `cid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '兑换的项目id', `uid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '优惠券所属用户', `coupon_title` varchar(32) NOT NULL COMMENT '优惠券名称', `coupon_price` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '优惠券的面值', `use_min_price` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '最低消费多少金额可用优惠券', `add_time` int(11) unsigned NOT NULL COMMENT '优惠券创建时间', `end_time` int(11) unsigned NOT NULL COMMENT '优惠券结束时间', `use_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '使用时间', `type` varchar(32) NOT NULL DEFAULT 'send' COMMENT '获取方式', `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态(0:未使用,1:已使用, 2:已过期)', `is_fail` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否有效', PRIMARY KEY (`id`), KEY `cid` (`cid`) USING BTREE, KEY `uid` (`uid`) USING BTREE, KEY `add_time` (`add_time`) USING BTREE, KEY `end_time` (`end_time`) USING BTREE, KEY `status` (`status`) USING BTREE, KEY `is_fail` (`is_fail`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=342 DEFAULT CHARSET=utf8 COMMENT='优惠券发放记录表'; -- ---------------------------- -- Table structure for `eb_store_order` -- ---------------------------- DROP TABLE IF EXISTS `eb_store_order`; CREATE TABLE `eb_store_order` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '订单ID', `order_id` varchar(32) NOT NULL COMMENT '订单号', `uid` int(11) unsigned NOT NULL COMMENT '用户id', `real_name` varchar(32) NOT NULL COMMENT '用户姓名', `user_phone` varchar(18) NOT NULL COMMENT '用户电话', `user_address` varchar(100) NOT NULL COMMENT '详细地址', `cart_id` varchar(256) NOT NULL DEFAULT '[]' COMMENT '购物车id', `total_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '订单商品总数', `total_price` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '订单总价', `total_postage` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '邮费', `pay_price` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '实际支付金额', `pay_postage` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '支付邮费', `deduction_price` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '抵扣金额', `coupon_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '优惠券id', `coupon_price` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '优惠券金额', `paid` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '支付状态', `pay_time` int(11) unsigned DEFAULT NULL COMMENT '支付时间', `pay_type` varchar(32) NOT NULL COMMENT '支付方式', `add_time` int(11) unsigned NOT NULL COMMENT '创建时间', `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '订单状态(-1 : 申请退款 -2 : 退货成功 0:待发货;1:待收货;2:已收货;3:待评价;-1:已退款)', `refund_status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0 未退款 1 申请中 2 已退款', `refund_reason_wap_img` varchar(255) DEFAULT NULL COMMENT '退款图片', `refund_reason_wap_explain` varchar(255) DEFAULT NULL COMMENT '退款用户说明', `refund_reason_time` int(11) unsigned DEFAULT NULL COMMENT '退款时间', `refund_reason_wap` varchar(255) DEFAULT NULL COMMENT '前台退款原因', `refund_reason` varchar(255) DEFAULT NULL COMMENT '不退款的理由', `refund_price` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '退款金额', `delivery_name` varchar(64) DEFAULT NULL COMMENT '快递名称/送货人姓名', `delivery_type` varchar(32) DEFAULT NULL COMMENT '发货类型', `delivery_id` varchar(64) DEFAULT NULL COMMENT '快递单号/手机号', `gain_integral` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '消费赚取积分', `use_integral` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '使用积分', `back_integral` decimal(8,2) unsigned DEFAULT NULL COMMENT '给用户退了多少积分', `mark` varchar(512) NOT NULL COMMENT '备注', `is_del` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除', `unique` char(32) NOT NULL COMMENT '唯一id(md5加密)类似id', `remark` varchar(512) DEFAULT NULL COMMENT '管理员备注', `mer_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商户ID', `is_mer_check` tinyint(3) unsigned NOT NULL DEFAULT '0', `combination_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '拼团产品id0一般产品', `pink_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '拼团id 0没有拼团', `cost` decimal(8,2) unsigned NOT NULL COMMENT '成本价', `seckill_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '秒杀产品ID', `bargain_id` int(11) unsigned DEFAULT '0' COMMENT '砍价id', `is_channel` tinyint(1) unsigned DEFAULT '0' COMMENT '支付渠道(0微信公众号1微信小程序)', PRIMARY KEY (`id`), UNIQUE KEY `order_id_2` (`order_id`,`uid`) USING BTREE, UNIQUE KEY `unique` (`unique`) USING BTREE, KEY `uid` (`uid`) USING BTREE, KEY `add_time` (`add_time`) USING BTREE, KEY `pay_price` (`pay_price`) USING BTREE, KEY `paid` (`paid`) USING BTREE, KEY `pay_time` (`pay_time`) USING BTREE, KEY `pay_type` (`pay_type`) USING BTREE, KEY `status` (`status`) USING BTREE, KEY `is_del` (`is_del`) USING BTREE, KEY `coupon_id` (`coupon_id`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=1006 DEFAULT CHARSET=utf8 COMMENT='订单表'; -- ---------------------------- -- Table structure for `eb_store_order_cart_info` -- ---------------------------- DROP TABLE IF EXISTS `eb_store_order_cart_info`; CREATE TABLE `eb_store_order_cart_info` ( `oid` int(11) unsigned NOT NULL COMMENT '订单id', `cart_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '购物车id', `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商品ID', `cart_info` text NOT NULL COMMENT '购买东西的详细信息', `unique` char(32) NOT NULL COMMENT '唯一id', UNIQUE KEY `oid` (`oid`,`unique`) USING BTREE, KEY `cart_id` (`cart_id`) USING BTREE, KEY `product_id` (`product_id`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='订单购物详情表'; -- ---------------------------- -- Table structure for `eb_store_order_status` -- ---------------------------- DROP TABLE IF EXISTS `eb_store_order_status`; CREATE TABLE `eb_store_order_status` ( `oid` int(10) unsigned NOT NULL COMMENT '订单id', `change_type` varchar(32) NOT NULL COMMENT '操作类型', `change_message` varchar(256) NOT NULL COMMENT '操作备注', `change_time` int(10) unsigned NOT NULL COMMENT '操作时间', KEY `oid` (`oid`) USING BTREE, KEY `change_type` (`change_type`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='订单操作记录表'; -- ---------------------------- -- Table structure for `eb_store_pink` -- ---------------------------- DROP TABLE IF EXISTS `eb_store_pink`; CREATE TABLE `eb_store_pink` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `uid` int(10) unsigned NOT NULL COMMENT '用户id', `order_id` varchar(32) NOT NULL COMMENT '订单id 生成', `order_id_key` int(10) unsigned NOT NULL COMMENT '订单id 数据库', `total_num` int(10) unsigned NOT NULL COMMENT '购买商品个数', `total_price` decimal(10,2) unsigned NOT NULL COMMENT '购买总金额', `cid` int(10) unsigned NOT NULL COMMENT '拼团产品id', `pid` int(10) unsigned NOT NULL COMMENT '产品id', `people` int(10) unsigned NOT NULL COMMENT '拼图总人数', `price` decimal(10,2) unsigned NOT NULL COMMENT '拼团产品单价', `add_time` varchar(24) NOT NULL COMMENT '开始时间', `stop_time` varchar(24) NOT NULL, `k_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '团长id 0为团长', `is_tpl` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否发送模板消息0未发送1已发送', `is_refund` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否退款 0未退款 1已退款', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态1进行中2已完成3未完成', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=118 DEFAULT CHARSET=utf8 COMMENT='拼团表'; -- ---------------------------- -- Table structure for `eb_store_product` -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product`; CREATE TABLE `eb_store_product` ( `id` mediumint(11) NOT NULL AUTO_INCREMENT COMMENT '商品id', `mer_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商户Id(0为总后台管理员创建,不为0的时候是商户后台创建)', `image` varchar(128) NOT NULL COMMENT '商品图片', `slider_image` varchar(512) NOT NULL COMMENT '轮播图', `store_name` varchar(128) NOT NULL COMMENT '商品名称', `store_info` varchar(256) NOT NULL COMMENT '商品简介', `keyword` varchar(256) NOT NULL COMMENT '关键字', `cate_id` varchar(64) NOT NULL COMMENT '分类id', `price` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '商品价格', `vip_price` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '会员价格', `ot_price` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '市场价', `postage` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '邮费', `unit_name` varchar(32) NOT NULL COMMENT '单位名', `sort` smallint(11) NOT NULL DEFAULT '0' COMMENT '排序', `sales` mediumint(11) unsigned NOT NULL DEFAULT '0' COMMENT '销量', `stock` mediumint(11) unsigned NOT NULL DEFAULT '0' COMMENT '库存', `is_show` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态(0:未上架,1:上架)', `is_hot` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否热卖', `is_benefit` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否优惠', `is_best` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否精品', `is_new` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否新品', `description` text NOT NULL COMMENT '产品描述', `add_time` int(11) unsigned NOT NULL COMMENT '添加时间', `is_postage` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否包邮', `is_del` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除', `mer_use` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '商户是否代理 0不可代理1可代理', `give_integral` decimal(8,2) unsigned NOT NULL COMMENT '获得积分', `cost` decimal(8,2) unsigned NOT NULL COMMENT '成本价', `is_seckill` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '秒杀状态 0 未开启 1已开启', `is_bargain` tinyint(1) unsigned NOT NULL COMMENT '砍价状态 0未开启 1开启', `ficti` mediumint(11) NOT NULL DEFAULT '100' COMMENT '虚拟销量', `browse` int(11) DEFAULT '0' COMMENT '浏览量', `code_path` varchar(64) DEFAULT NULL COMMENT '产品二维码地址(用户小程序海报)', PRIMARY KEY (`id`), KEY `cate_id` (`cate_id`) USING BTREE, KEY `is_hot` (`is_hot`) USING BTREE, KEY `is_benefit` (`is_benefit`) USING BTREE, KEY `is_best` (`is_best`) USING BTREE, KEY `is_new` (`is_new`) USING BTREE, KEY `toggle_on_sale, is_del` (`is_del`) USING BTREE, KEY `price` (`price`) USING BTREE, KEY `is_show` (`is_show`) USING BTREE, KEY `sort` (`sort`) USING BTREE, KEY `sales` (`sales`) USING BTREE, KEY `add_time` (`add_time`) USING BTREE, KEY `is_postage` (`is_postage`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=677 DEFAULT CHARSET=utf8 COMMENT='商品表'; -- ---------------------------- -- Table structure for `eb_store_product_attr` -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product_attr`; CREATE TABLE `eb_store_product_attr` ( `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商品ID', `attr_name` varchar(32) NOT NULL COMMENT '属性名', `attr_values` varchar(256) NOT NULL COMMENT '属性值', KEY `store_id` (`product_id`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='商品属性表'; -- ---------------------------- -- Table structure for `eb_store_product_attr_result` -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product_attr_result`; CREATE TABLE `eb_store_product_attr_result` ( `product_id` int(10) unsigned NOT NULL COMMENT '商品ID', `result` text NOT NULL COMMENT '商品属性参数', `change_time` int(10) unsigned NOT NULL COMMENT '上次修改时间', UNIQUE KEY `product_id` (`product_id`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='商品属性详情表'; -- ---------------------------- -- Table structure for `eb_store_product_attr_value` -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product_attr_value`; CREATE TABLE `eb_store_product_attr_value` ( `product_id` int(10) unsigned NOT NULL COMMENT '商品ID', `suk` varchar(128) NOT NULL COMMENT '商品属性索引值 (attr_value|attr_value[|....])', `stock` int(10) unsigned NOT NULL COMMENT '属性对应的库存', `sales` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '销量', `price` decimal(8,2) unsigned NOT NULL COMMENT '属性金额', `image` varchar(128) DEFAULT NULL COMMENT '图片', `unique` char(8) NOT NULL DEFAULT '' COMMENT '唯一值', `cost` decimal(8,2) unsigned NOT NULL COMMENT '成本价', UNIQUE KEY `unique` (`unique`,`suk`) USING BTREE, KEY `store_id` (`product_id`,`suk`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='商品属性值表'; -- ---------------------------- -- Table structure for `eb_store_product_relation` -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product_relation`; CREATE TABLE `eb_store_product_relation` ( `uid` int(10) unsigned NOT NULL COMMENT '用户ID', `product_id` int(10) unsigned NOT NULL COMMENT '商品ID', `type` varchar(32) NOT NULL COMMENT '类型(收藏(collect)、点赞(like))', `category` varchar(32) NOT NULL COMMENT '某种类型的商品(普通商品、秒杀商品)', `add_time` int(10) unsigned NOT NULL COMMENT '添加时间', UNIQUE KEY `uid` (`uid`,`product_id`,`type`) USING BTREE, KEY `type` (`type`) USING BTREE, KEY `category` (`category`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='商品点赞和收藏表'; -- ---------------------------- -- Table structure for `eb_store_product_reply` -- ---------------------------- DROP TABLE IF EXISTS `eb_store_product_reply`; CREATE TABLE `eb_store_product_reply` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '评论ID', `uid` int(11) NOT NULL COMMENT '用户ID', `oid` int(11) NOT NULL COMMENT '订单ID', `unique` char(32) NOT NULL COMMENT '唯一id', `product_id` int(11) NOT NULL COMMENT '产品id', `reply_type` varchar(32) NOT NULL DEFAULT 'product' COMMENT '某种商品类型(普通商品、秒杀商品)', `product_score` tinyint(1) NOT NULL COMMENT '商品分数', `service_score` tinyint(1) NOT NULL COMMENT '服务分数', `comment` varchar(512) NOT NULL COMMENT '评论内容', `pics` text NOT NULL COMMENT '评论图片', `add_time` int(11) NOT NULL COMMENT '评论时间', `merchant_reply_content` varchar(300) NOT NULL COMMENT '管理员回复内容', `merchant_reply_time` int(11) NOT NULL COMMENT '管理员回复时间', `is_del` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0未删除1已删除', `is_reply` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0未回复1已回复', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `order_id_2` (`oid`,`unique`) USING BTREE, KEY `add_time` (`add_time`) USING BTREE, KEY `parent_id` (`reply_type`) USING BTREE, KEY `is_del` (`is_del`) USING BTREE, KEY `product_score` (`product_score`) USING BTREE, KEY `service_score` (`service_score`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='评论表'; -- ---------------------------- -- Table structure for `eb_store_seckill` -- ---------------------------- DROP TABLE IF EXISTS `eb_store_seckill`; CREATE TABLE `eb_store_seckill` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '商品秒杀产品表id', `product_id` int(10) unsigned NOT NULL COMMENT '商品id', `image` varchar(255) NOT NULL COMMENT '推荐图', `images` varchar(1000) NOT NULL COMMENT '轮播图', `title` varchar(255) NOT NULL COMMENT '活动标题', `info` varchar(255) NOT NULL COMMENT '简介', `price` decimal(10,2) unsigned NOT NULL COMMENT '价格', `cost` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '成本', `ot_price` decimal(10,2) unsigned NOT NULL COMMENT '原价', `give_integral` decimal(10,2) unsigned NOT NULL COMMENT '返多少积分', `sort` int(10) unsigned NOT NULL COMMENT '排序', `stock` int(10) unsigned NOT NULL COMMENT '库存', `sales` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '销量', `unit_name` varchar(16) NOT NULL COMMENT '单位名', `postage` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '邮费', `description` text NOT NULL COMMENT '内容', `start_time` varchar(128) NOT NULL COMMENT '开始时间', `stop_time` varchar(128) NOT NULL COMMENT '结束时间', `add_time` varchar(128) NOT NULL COMMENT '添加时间', `status` tinyint(1) unsigned NOT NULL COMMENT '产品状态', `is_postage` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否包邮', `is_hot` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '热门推荐', `is_del` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '删除 0未删除1已删除', `num` int(11) unsigned NOT NULL COMMENT '最多秒杀几个', `is_show` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '显示', PRIMARY KEY (`id`), KEY `product_id` (`product_id`), KEY `start_time` (`start_time`,`stop_time`), KEY `is_del` (`is_del`), KEY `is_hot` (`is_hot`), KEY `is_show` (`status`), KEY `add_time` (`add_time`), KEY `sort` (`sort`), KEY `is_postage` (`is_postage`) ) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 COMMENT='商品秒杀产品表'; -- ---------------------------- -- Table structure for `eb_store_seckill_attr` -- ---------------------------- DROP TABLE IF EXISTS `eb_store_seckill_attr`; CREATE TABLE `eb_store_seckill_attr` ( `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商品ID', `attr_name` varchar(32) NOT NULL COMMENT '属性名', `attr_values` varchar(256) NOT NULL COMMENT '属性值', KEY `store_id` (`product_id`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='秒杀商品属性表'; -- ---------------------------- -- Table structure for `eb_store_seckill_attr_result` -- ---------------------------- DROP TABLE IF EXISTS `eb_store_seckill_attr_result`; CREATE TABLE `eb_store_seckill_attr_result` ( `product_id` int(10) unsigned NOT NULL COMMENT '商品ID', `result` text NOT NULL COMMENT '商品属性参数', `change_time` int(10) unsigned NOT NULL COMMENT '上次修改时间', UNIQUE KEY `product_id` (`product_id`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='秒杀商品属性详情表'; -- ---------------------------- -- Table structure for `eb_store_seckill_attr_value` -- ---------------------------- DROP TABLE IF EXISTS `eb_store_seckill_attr_value`; CREATE TABLE `eb_store_seckill_attr_value` ( `product_id` int(10) unsigned NOT NULL COMMENT '商品ID', `suk` varchar(128) NOT NULL COMMENT '商品属性索引值 (attr_value|attr_value[|....])', `stock` int(10) unsigned NOT NULL COMMENT '属性对应的库存', `sales` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '销量', `price` decimal(8,2) unsigned NOT NULL COMMENT '属性金额', `image` varchar(128) DEFAULT NULL COMMENT '图片', `unique` char(8) NOT NULL DEFAULT '' COMMENT '唯一值', `cost` decimal(8,2) unsigned NOT NULL COMMENT '成本价', UNIQUE KEY `unique` (`unique`,`suk`) USING BTREE, KEY `store_id` (`product_id`,`suk`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='秒杀商品属性值表'; -- ---------------------------- -- Table structure for `eb_store_service` -- ---------------------------- DROP TABLE IF EXISTS `eb_store_service`; CREATE TABLE `eb_store_service` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '客服id', `mer_id` int(11) NOT NULL DEFAULT '0' COMMENT '商户id', `uid` int(11) NOT NULL COMMENT '客服uid', `avatar` varchar(250) NOT NULL COMMENT '客服头像', `nickname` varchar(50) NOT NULL COMMENT '代理名称', `add_time` int(11) NOT NULL COMMENT '添加时间', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '0隐藏1显示', `notify` int(2) DEFAULT '0' COMMENT '订单通知1开启0关闭', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='客服表'; -- ---------------------------- -- Table structure for `eb_store_service_log` -- ---------------------------- DROP TABLE IF EXISTS `eb_store_service_log`; CREATE TABLE `eb_store_service_log` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '客服用户对话记录表ID', `mer_id` int(11) NOT NULL DEFAULT '0' COMMENT '商户id', `msn` text NOT NULL COMMENT '消息内容', `uid` int(11) NOT NULL COMMENT '发送人uid', `to_uid` int(11) NOT NULL COMMENT '接收人uid', `add_time` int(11) NOT NULL COMMENT '发送时间', `type` tinyint(1) DEFAULT '0' COMMENT '是否已读(0:否;1:是;)', `remind` tinyint(1) DEFAULT '0' COMMENT '是否提醒过', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=151 DEFAULT CHARSET=utf8 COMMENT='客服用户对话记录表'; -- ---------------------------- -- Table structure for `eb_store_visit` -- ---------------------------- DROP TABLE IF EXISTS `eb_store_visit`; CREATE TABLE `eb_store_visit` ( `id` int(10) NOT NULL AUTO_INCREMENT, `product_id` int(11) DEFAULT NULL COMMENT '产品ID', `product_type` varchar(32) DEFAULT NULL COMMENT '产品类型', `cate_id` int(11) DEFAULT NULL COMMENT '产品分类ID', `type` char(50) DEFAULT NULL COMMENT '产品类型', `uid` int(11) DEFAULT NULL COMMENT '用户ID', `count` int(11) DEFAULT NULL COMMENT '访问次数', `content` varchar(255) DEFAULT NULL COMMENT '备注描述', `add_time` int(11) DEFAULT NULL COMMENT '添加时间', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=5322 DEFAULT CHARSET=utf8 COMMENT='产品浏览分析表'; -- ---------------------------- -- Table structure for `eb_system_admin` -- ---------------------------- DROP TABLE IF EXISTS `eb_system_admin`; CREATE TABLE `eb_system_admin` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '后台管理员表ID', `account` varchar(32) NOT NULL COMMENT '后台管理员账号', `pwd` char(32) NOT NULL COMMENT '后台管理员密码', `real_name` varchar(16) NOT NULL COMMENT '后台管理员姓名', `roles` varchar(128) NOT NULL COMMENT '后台管理员权限(menus_id)', `last_ip` varchar(16) DEFAULT NULL COMMENT '后台管理员最后一次登录ip', `last_time` int(10) unsigned DEFAULT NULL COMMENT '后台管理员最后一次登录时间', `add_time` int(10) unsigned NOT NULL COMMENT '后台管理员添加时间', `login_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '登录次数', `level` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '后台管理员级别', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '后台管理员状态 1有效0无效', `is_del` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account` (`account`) USING BTREE, KEY `status` (`status`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 COMMENT='后台管理员表'; -- ---------------------------- -- Table structure for `eb_system_attachment` -- ---------------------------- DROP TABLE IF EXISTS `eb_system_attachment`; CREATE TABLE `eb_system_attachment` ( `att_id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL COMMENT '附件名称', `att_dir` varchar(200) NOT NULL COMMENT '附件路径', `satt_dir` varchar(200) DEFAULT NULL COMMENT '压缩图片路径', `att_size` char(30) NOT NULL COMMENT '附件大小', `att_type` char(30) NOT NULL COMMENT '附件类型', `pid` int(10) NOT NULL COMMENT '分类ID0编辑器,1产品图片,2拼团图片,3砍价图片,4秒杀图片,5文章图片,6组合数据图', `time` int(11) NOT NULL COMMENT '上传时间', PRIMARY KEY (`att_id`) ) ENGINE=InnoDB AUTO_INCREMENT=278 DEFAULT CHARSET=utf8 COMMENT='附件管理表'; -- ---------------------------- -- Table structure for `eb_system_attachment_category` -- ---------------------------- DROP TABLE IF EXISTS `eb_system_attachment_category`; CREATE TABLE `eb_system_attachment_category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `pid` int(11) DEFAULT '0' COMMENT '父级ID', `name` varchar(50) NOT NULL COMMENT '分类名称', `enname` varchar(50) NOT NULL COMMENT '分类目录', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COMMENT='附件分类表'; -- ---------------------------- -- Table structure for `eb_system_config` -- ---------------------------- DROP TABLE IF EXISTS `eb_system_config`; CREATE TABLE `eb_system_config` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '配置id', `menu_name` varchar(255) NOT NULL COMMENT '字段名称', `type` varchar(255) NOT NULL COMMENT '类型(文本框,单选按钮...)', `config_tab_id` int(10) unsigned NOT NULL COMMENT '配置分类id', `parameter` varchar(255) DEFAULT NULL COMMENT '规则 单选框和多选框', `upload_type` tinyint(1) unsigned DEFAULT NULL COMMENT '上传文件格式1单图2多图3文件', `required` varchar(255) DEFAULT NULL COMMENT '规则', `width` int(10) unsigned DEFAULT NULL COMMENT '多行文本框的宽度', `high` int(10) unsigned DEFAULT NULL COMMENT '多行文框的高度', `value` varchar(5000) DEFAULT NULL COMMENT '默认值', `info` varchar(255) NOT NULL COMMENT '配置名称', `desc` varchar(255) DEFAULT NULL COMMENT '配置简介', `sort` int(10) unsigned NOT NULL COMMENT '排序', `status` tinyint(1) unsigned NOT NULL COMMENT '是否隐藏', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=111 DEFAULT CHARSET=utf8 COMMENT='配置表'; -- ---------------------------- -- Table structure for `eb_system_config_tab` -- ---------------------------- DROP TABLE IF EXISTS `eb_system_config_tab`; CREATE TABLE `eb_system_config_tab` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '配置分类id', `title` varchar(255) NOT NULL COMMENT '配置分类名称', `eng_title` varchar(255) NOT NULL COMMENT '配置分类英文名称', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '配置分类状态', `info` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '配置分类是否显示', `icon` varchar(30) DEFAULT NULL COMMENT '图标', `type` int(2) DEFAULT '0' COMMENT '配置类型', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COMMENT='配置分类表'; -- ---------------------------- -- Table structure for `eb_system_file` -- ---------------------------- DROP TABLE IF EXISTS `eb_system_file`; CREATE TABLE `eb_system_file` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '文件对比ID', `cthash` char(32) NOT NULL COMMENT '文件内容', `filename` varchar(255) NOT NULL COMMENT '文价名称', `atime` char(12) NOT NULL COMMENT '上次访问时间', `mtime` char(12) NOT NULL COMMENT '上次修改时间', `ctime` char(12) NOT NULL COMMENT '上次改变时间', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=6208 DEFAULT CHARSET=utf8 COMMENT='文件对比表'; -- ---------------------------- -- Table structure for `eb_system_group` -- ---------------------------- DROP TABLE IF EXISTS `eb_system_group`; CREATE TABLE `eb_system_group` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '组合数据ID', `name` varchar(50) NOT NULL COMMENT '数据组名称', `info` varchar(256) NOT NULL COMMENT '数据提示', `config_name` varchar(50) NOT NULL COMMENT '数据字段', `fields` text COMMENT '数据组字段以及类型(json数据)', PRIMARY KEY (`id`), UNIQUE KEY `config_name` (`config_name`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 COMMENT='组合数据表'; -- ---------------------------- -- Table structure for `eb_system_group_data` -- ---------------------------- DROP TABLE IF EXISTS `eb_system_group_data`; CREATE TABLE `eb_system_group_data` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '组合数据详情ID', `gid` int(11) NOT NULL COMMENT '对应的数据组id', `value` text NOT NULL COMMENT '数据组对应的数据值(json数据)', `add_time` int(10) NOT NULL COMMENT '添加数据时间', `sort` int(11) NOT NULL COMMENT '数据排序', `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态(1:开启;2:关闭;)', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=110 DEFAULT CHARSET=utf8 COMMENT='组合数据详情表'; -- ---------------------------- -- Table structure for `eb_system_log` -- ---------------------------- DROP TABLE IF EXISTS `eb_system_log`; CREATE TABLE `eb_system_log` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '管理员操作记录ID', `admin_id` int(10) unsigned NOT NULL COMMENT '管理员id', `admin_name` varchar(64) NOT NULL COMMENT '管理员姓名', `path` varchar(128) NOT NULL COMMENT '链接', `page` varchar(64) NOT NULL COMMENT '行为', `method` varchar(12) NOT NULL COMMENT '访问类型', `ip` varchar(16) NOT NULL COMMENT '登录IP', `type` varchar(32) NOT NULL COMMENT '类型', `add_time` int(10) unsigned NOT NULL COMMENT '操作时间', `merchant_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商户id', PRIMARY KEY (`id`), KEY `admin_id` (`admin_id`) USING BTREE, KEY `add_time` (`add_time`) USING BTREE, KEY `type` (`type`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=53075 DEFAULT CHARSET=utf8 COMMENT='管理员操作记录表'; -- ---------------------------- -- Table structure for `eb_system_menus` -- ---------------------------- DROP TABLE IF EXISTS `eb_system_menus`; CREATE TABLE `eb_system_menus` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '菜单ID', `pid` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '父级id', `icon` varchar(16) NOT NULL COMMENT '图标', `menu_name` varchar(32) NOT NULL DEFAULT '' COMMENT '按钮名', `module` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '模块名', `controller` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '控制器', `action` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '方法名', `params` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '[]' COMMENT '参数', `sort` tinyint(3) NOT NULL DEFAULT '1' COMMENT '排序', `is_show` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否显示', `access` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '子管理员是否可用', PRIMARY KEY (`id`), KEY `pid` (`pid`) USING BTREE, KEY `is_show` (`is_show`) USING BTREE, KEY `access` (`access`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=458 DEFAULT CHARSET=utf8 COMMENT='菜单表'; -- ---------------------------- -- Table structure for `eb_system_notice` -- ---------------------------- DROP TABLE IF EXISTS `eb_system_notice`; CREATE TABLE `eb_system_notice` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '通知模板id', `title` varchar(64) NOT NULL COMMENT '通知标题', `type` varchar(64) NOT NULL COMMENT '通知类型', `icon` varchar(16) NOT NULL COMMENT '图标', `url` varchar(64) NOT NULL COMMENT '链接', `table_title` varchar(256) NOT NULL COMMENT '通知数据', `template` varchar(64) NOT NULL COMMENT '通知模板', `push_admin` varchar(128) NOT NULL COMMENT '通知管理员id', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态', PRIMARY KEY (`id`), UNIQUE KEY `type` (`type`) USING BTREE, KEY `status` (`status`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='通知模板表'; -- ---------------------------- -- Table structure for `eb_system_notice_admin` -- ---------------------------- DROP TABLE IF EXISTS `eb_system_notice_admin`; CREATE TABLE `eb_system_notice_admin` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '通知记录ID', `notice_type` varchar(64) NOT NULL COMMENT '通知类型', `admin_id` smallint(5) unsigned NOT NULL COMMENT '通知的管理员', `link_id` int(10) unsigned NOT NULL COMMENT '关联ID', `table_data` text NOT NULL COMMENT '通知的数据', `is_click` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '点击次数', `is_visit` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '访问次数', `visit_time` int(11) NOT NULL COMMENT '访问时间', `add_time` int(10) unsigned NOT NULL COMMENT '通知时间', PRIMARY KEY (`id`), KEY `admin_id` (`admin_id`,`notice_type`) USING BTREE, KEY `add_time` (`add_time`) USING BTREE, KEY `is_visit` (`is_visit`) USING BTREE, KEY `is_click` (`is_click`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='通知记录表'; -- ---------------------------- -- Table structure for `eb_system_role` -- ---------------------------- DROP TABLE IF EXISTS `eb_system_role`; CREATE TABLE `eb_system_role` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '身份管理id', `role_name` varchar(32) NOT NULL COMMENT '身份管理名称', `rules` text NOT NULL COMMENT '身份管理权限(menus_id)', `level` tinyint(3) unsigned NOT NULL DEFAULT '0', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态', PRIMARY KEY (`id`), KEY `status` (`status`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COMMENT='身份管理表'; -- ---------------------------- -- Table structure for `eb_user` -- ---------------------------- DROP TABLE IF EXISTS `eb_user`; CREATE TABLE `eb_user` ( `uid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户id', `account` varchar(32) NOT NULL COMMENT '用户账号', `pwd` varchar(32) NOT NULL COMMENT '用户密码', `nickname` varchar(16) NOT NULL COMMENT '用户昵称', `avatar` varchar(256) NOT NULL COMMENT '用户头像', `phone` char(15) NOT NULL COMMENT '手机号码', `add_time` int(11) unsigned NOT NULL COMMENT '添加时间', `add_ip` varchar(16) NOT NULL COMMENT '添加ip', `last_time` int(11) unsigned NOT NULL COMMENT '最后一次登录时间', `last_ip` varchar(16) NOT NULL COMMENT '最后一次登录ip', `now_money` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '用户余额', `integral` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '用户剩余积分', `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1为正常,0为禁止', `level` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '等级', `spread_uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '推广元id', `user_type` varchar(32) NOT NULL COMMENT '用户类型', `is_promoter` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否为推广员', `pay_count` int(11) unsigned DEFAULT '0' COMMENT '用户购买次数', PRIMARY KEY (`uid`), KEY `account` (`account`) USING BTREE, KEY `spreaduid` (`spread_uid`) USING BTREE, KEY `level` (`level`) USING BTREE, KEY `status` (`status`) USING BTREE, KEY `is_promoter` (`is_promoter`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=1447 DEFAULT CHARSET=utf8 COMMENT='用户表'; -- ---------------------------- -- Table structure for `eb_user_address` -- ---------------------------- DROP TABLE IF EXISTS `eb_user_address`; CREATE TABLE `eb_user_address` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户地址id', `uid` int(10) unsigned NOT NULL COMMENT '用户id', `real_name` varchar(32) NOT NULL COMMENT '收货人姓名', `phone` varchar(16) NOT NULL COMMENT '收货人电话', `province` varchar(64) NOT NULL COMMENT '收货人所在省', `city` varchar(64) NOT NULL COMMENT '收货人所在市', `district` varchar(64) NOT NULL COMMENT '收货人所在区', `detail` varchar(256) NOT NULL COMMENT '收货人详细地址', `post_code` int(10) unsigned NOT NULL COMMENT '邮编', `longitude` varchar(16) NOT NULL DEFAULT '0' COMMENT '经度', `latitude` varchar(16) NOT NULL DEFAULT '0' COMMENT '纬度', `is_default` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否默认', `is_del` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除', `add_time` int(10) unsigned NOT NULL COMMENT '添加时间', PRIMARY KEY (`id`), KEY `uid` (`uid`) USING BTREE, KEY `is_default` (`is_default`) USING BTREE, KEY `is_del` (`is_del`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=196 DEFAULT CHARSET=utf8 COMMENT='用户地址表'; -- ---------------------------- -- Table structure for `eb_user_bill` -- ---------------------------- DROP TABLE IF EXISTS `eb_user_bill`; CREATE TABLE `eb_user_bill` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户账单id', `uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用户uid', `link_id` varchar(32) NOT NULL DEFAULT '0' COMMENT '关联id', `pm` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0 = 支出 1 = 获得', `title` varchar(64) NOT NULL COMMENT '账单标题', `category` varchar(64) NOT NULL COMMENT '明细种类', `type` varchar(64) NOT NULL DEFAULT '' COMMENT '明细类型', `number` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '明细数字', `balance` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '剩余', `mark` varchar(512) NOT NULL COMMENT '备注', `add_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间', `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '0 = 带确定 1 = 有效 -1 = 无效', PRIMARY KEY (`id`), KEY `openid` (`uid`) USING BTREE, KEY `status` (`status`) USING BTREE, KEY `add_time` (`add_time`) USING BTREE, KEY `pm` (`pm`) USING BTREE, KEY `type` (`category`,`type`,`link_id`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=332 DEFAULT CHARSET=utf8 COMMENT='用户账单表'; -- ---------------------------- -- Table structure for `eb_user_enter` -- ---------------------------- DROP TABLE IF EXISTS `eb_user_enter`; CREATE TABLE `eb_user_enter` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '商户申请ID', `uid` int(10) unsigned NOT NULL COMMENT '用户ID', `province` varchar(32) NOT NULL COMMENT '商户所在省', `city` varchar(32) NOT NULL COMMENT '商户所在市', `district` varchar(32) NOT NULL COMMENT '商户所在区', `address` varchar(256) NOT NULL COMMENT '商户详细地址', `merchant_name` varchar(256) NOT NULL COMMENT '商户名称', `link_user` varchar(32) NOT NULL, `link_tel` varchar(16) NOT NULL COMMENT '商户电话', `charter` varchar(512) NOT NULL COMMENT '商户证书', `add_time` int(10) unsigned NOT NULL COMMENT '添加时间', `apply_time` int(10) unsigned NOT NULL COMMENT '审核时间', `success_time` int(11) NOT NULL COMMENT '通过时间', `fail_message` varchar(256) NOT NULL COMMENT '未通过原因', `fail_time` int(10) unsigned NOT NULL COMMENT '未通过时间', `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '-1 审核未通过 0未审核 1审核通过', `is_lock` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0 = 开启 1= 关闭', `is_del` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除', PRIMARY KEY (`id`), UNIQUE KEY `uid` (`uid`) USING BTREE, KEY `province` (`province`,`city`,`district`) USING BTREE, KEY `is_lock` (`is_lock`) USING BTREE, KEY `is_del` (`is_del`) USING BTREE, KEY `status` (`status`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='商户申请表'; -- ---------------------------- -- Table structure for `eb_user_extract` -- ---------------------------- DROP TABLE IF EXISTS `eb_user_extract`; CREATE TABLE `eb_user_extract` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `uid` int(10) unsigned DEFAULT NULL, `real_name` varchar(64) DEFAULT NULL COMMENT '名称', `extract_type` varchar(32) DEFAULT 'bank' COMMENT 'bank = 银行卡 alipay = 支付宝wx=微信', `bank_code` varchar(32) DEFAULT '0' COMMENT '银行卡', `bank_address` varchar(256) DEFAULT '' COMMENT '开户地址', `alipay_code` varchar(64) DEFAULT '' COMMENT '支付宝账号', `extract_price` decimal(8,2) unsigned DEFAULT '0.00' COMMENT '提现金额', `mark` varchar(512) DEFAULT NULL, `balance` decimal(8,2) unsigned DEFAULT '0.00', `fail_msg` varchar(128) DEFAULT NULL COMMENT '无效原因', `fail_time` int(10) unsigned DEFAULT NULL, `add_time` int(10) unsigned DEFAULT NULL COMMENT '添加时间', `status` tinyint(2) DEFAULT '0' COMMENT '-1 未通过 0 审核中 1 已提现', `wechat` varchar(15) DEFAULT NULL COMMENT '微信号', PRIMARY KEY (`id`), KEY `extract_type` (`extract_type`) USING BTREE, KEY `status` (`status`) USING BTREE, KEY `add_time` (`add_time`) USING BTREE, KEY `openid` (`uid`) USING BTREE, KEY `fail_time` (`fail_time`) ) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COMMENT='用户提现表'; -- ---------------------------- -- Table structure for `eb_user_group` -- ---------------------------- DROP TABLE IF EXISTS `eb_user_group`; CREATE TABLE `eb_user_group` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `group_name` varchar(64) DEFAULT NULL COMMENT '用户分组名称', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='用户分组表'; -- ---------------------------- -- Table structure for `eb_user_notice` -- ---------------------------- DROP TABLE IF EXISTS `eb_user_notice`; CREATE TABLE `eb_user_notice` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` text NOT NULL COMMENT '接收消息的用户id(类型:json数据)', `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '消息通知类型(1:系统消息;2:用户通知)', `user` varchar(20) NOT NULL DEFAULT '' COMMENT '发送人', `title` varchar(20) NOT NULL COMMENT '通知消息的标题信息', `content` varchar(500) NOT NULL COMMENT '通知消息的内容', `add_time` int(11) NOT NULL COMMENT '通知消息发送的时间', `is_send` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否发送(0:未发送;1:已发送)', `send_time` int(11) NOT NULL COMMENT '发送时间', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=44 DEFAULT CHARSET=utf8 COMMENT='用户通知表'; -- ---------------------------- -- Table structure for `eb_user_notice_see` -- ---------------------------- DROP TABLE IF EXISTS `eb_user_notice_see`; CREATE TABLE `eb_user_notice_see` ( `id` int(11) NOT NULL AUTO_INCREMENT, `nid` int(11) NOT NULL COMMENT '查看的通知id', `uid` int(11) NOT NULL COMMENT '查看通知的用户id', `add_time` int(11) NOT NULL COMMENT '查看通知的时间', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=89 DEFAULT CHARSET=utf8 COMMENT='用户通知发送记录表'; -- ---------------------------- -- Table structure for `eb_user_recharge` -- ---------------------------- DROP TABLE IF EXISTS `eb_user_recharge`; CREATE TABLE `eb_user_recharge` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `uid` int(10) DEFAULT NULL COMMENT '充值用户UID', `order_id` varchar(32) DEFAULT NULL COMMENT '订单号', `price` decimal(8,2) DEFAULT NULL COMMENT '充值金额', `recharge_type` varchar(32) DEFAULT NULL COMMENT '充值类型', `paid` tinyint(1) DEFAULT NULL COMMENT '是否充值', `pay_time` int(10) DEFAULT NULL COMMENT '充值支付时间', `add_time` int(12) DEFAULT NULL COMMENT '充值时间', `refund_price` decimal(10,2) unsigned NOT NULL COMMENT '退款金额', PRIMARY KEY (`id`), UNIQUE KEY `order_id` (`order_id`) USING BTREE, KEY `uid` (`uid`) USING BTREE, KEY `recharge_type` (`recharge_type`) USING BTREE, KEY `paid` (`paid`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=96 DEFAULT CHARSET=utf8 COMMENT='用户充值表'; -- ---------------------------- -- Table structure for `eb_wechat_media` -- ---------------------------- DROP TABLE IF EXISTS `eb_wechat_media`; CREATE TABLE `eb_wechat_media` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '微信视频音频id', `type` varchar(16) NOT NULL COMMENT '回复类型', `path` varchar(128) NOT NULL COMMENT '文件路径', `media_id` varchar(64) NOT NULL COMMENT '微信服务器返回的id', `url` varchar(256) NOT NULL COMMENT '地址', `temporary` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否永久或者临时 0永久1临时', `add_time` int(10) unsigned NOT NULL COMMENT '添加时间', PRIMARY KEY (`id`), UNIQUE KEY `type` (`type`,`media_id`) USING BTREE, KEY `type_2` (`type`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='微信回复表'; -- ---------------------------- -- Table structure for `eb_wechat_message` -- ---------------------------- DROP TABLE IF EXISTS `eb_wechat_message`; CREATE TABLE `eb_wechat_message` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户行为记录id', `openid` varchar(32) NOT NULL COMMENT '用户openid', `type` varchar(32) NOT NULL COMMENT '操作类型', `result` varchar(512) NOT NULL COMMENT '操作详细记录', `add_time` int(10) unsigned NOT NULL COMMENT '操作时间', PRIMARY KEY (`id`), KEY `openid` (`openid`) USING BTREE, KEY `type` (`type`) USING BTREE, KEY `add_time` (`add_time`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=5507 DEFAULT CHARSET=utf8 COMMENT='用户行为记录表'; -- ---------------------------- -- Table structure for `eb_wechat_news_category` -- ---------------------------- DROP TABLE IF EXISTS `eb_wechat_news_category`; CREATE TABLE `eb_wechat_news_category` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '图文消息管理ID', `cate_name` varchar(255) NOT NULL COMMENT '图文名称', `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态', `new_id` varchar(255) NOT NULL COMMENT '文章id', `add_time` varchar(255) NOT NULL COMMENT '添加时间', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 COMMENT='图文消息管理表'; -- ---------------------------- -- Table structure for `eb_wechat_qrcode` -- ---------------------------- DROP TABLE IF EXISTS `eb_wechat_qrcode`; CREATE TABLE `eb_wechat_qrcode` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '微信二维码ID', `third_type` varchar(32) NOT NULL COMMENT '二维码类型', `third_id` int(11) unsigned NOT NULL COMMENT '用户id', `ticket` varchar(255) NOT NULL COMMENT '二维码参数', `expire_seconds` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '二维码有效时间', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态', `add_time` varchar(255) NOT NULL COMMENT '添加时间', `url` varchar(255) NOT NULL COMMENT '微信访问url', `qrcode_url` varchar(255) NOT NULL COMMENT '微信二维码url', `scan` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '被扫的次数', PRIMARY KEY (`id`), UNIQUE KEY `third_type` (`third_type`,`third_id`) USING BTREE, KEY `ticket` (`ticket`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=876 DEFAULT CHARSET=utf8 COMMENT='微信二维码管理表'; -- ---------------------------- -- Table structure for `eb_wechat_reply` -- ---------------------------- DROP TABLE IF EXISTS `eb_wechat_reply`; CREATE TABLE `eb_wechat_reply` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '微信关键字回复id', `key` varchar(64) NOT NULL COMMENT '关键字', `type` varchar(32) NOT NULL COMMENT '回复类型', `data` text NOT NULL COMMENT '回复数据', `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '0=不可用 1 =可用', `hide` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否隐藏', PRIMARY KEY (`id`), UNIQUE KEY `key` (`key`) USING BTREE, KEY `type` (`type`) USING BTREE, KEY `status` (`status`) USING BTREE, KEY `hide` (`hide`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=32 DEFAULT CHARSET=utf8 COMMENT='微信关键字回复表'; -- ---------------------------- -- Table structure for `eb_wechat_template` -- ---------------------------- DROP TABLE IF EXISTS `eb_wechat_template`; CREATE TABLE `eb_wechat_template` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '模板id', `tempkey` char(50) NOT NULL COMMENT '模板编号', `name` char(100) NOT NULL COMMENT '模板名', `content` varchar(1000) NOT NULL COMMENT '回复内容', `tempid` char(100) DEFAULT NULL COMMENT '模板ID', `add_time` varchar(15) NOT NULL COMMENT '添加时间', `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '状态', PRIMARY KEY (`id`), KEY `tempkey` (`tempkey`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COMMENT='微信模板'; -- ---------------------------- -- Table structure for `eb_wechat_user` -- ---------------------------- DROP TABLE IF EXISTS `eb_wechat_user`; CREATE TABLE `eb_wechat_user` ( `uid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '微信用户id', `unionid` varchar(30) DEFAULT NULL COMMENT '只有在用户将公众号绑定到微信开放平台帐号后,才会出现该字段', `openid` varchar(30) DEFAULT NULL COMMENT '用户的标识,对当前公众号唯一', `routine_openid` varchar(32) DEFAULT NULL COMMENT '小程序唯一身份ID', `nickname` varchar(64) NOT NULL COMMENT '用户的昵称', `headimgurl` varchar(256) NOT NULL COMMENT '用户头像', `sex` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '用户的性别,值为1时是男性,值为2时是女性,值为0时是未知', `city` varchar(64) NOT NULL COMMENT '用户所在城市', `language` varchar(64) NOT NULL COMMENT '用户的语言,简体中文为zh_CN', `province` varchar(64) NOT NULL COMMENT '用户所在省份', `country` varchar(64) NOT NULL COMMENT '用户所在国家', `remark` varchar(256) DEFAULT NULL COMMENT '公众号运营者对粉丝的备注,公众号运营者可在微信公众平台用户管理界面对粉丝添加备注', `groupid` smallint(5) unsigned DEFAULT '0' COMMENT '用户所在的分组ID(兼容旧的用户分组接口)', `tagid_list` varchar(256) DEFAULT NULL COMMENT '用户被打上的标签ID列表', `subscribe` tinyint(3) unsigned DEFAULT '1' COMMENT '用户是否订阅该公众号标识', `subscribe_time` int(10) unsigned DEFAULT NULL COMMENT '关注公众号时间', `add_time` int(10) unsigned DEFAULT NULL COMMENT '添加时间', `stair` int(11) unsigned DEFAULT NULL COMMENT '一级推荐人', `second` int(11) unsigned DEFAULT NULL COMMENT '二级推荐人', `order_stair` int(11) DEFAULT NULL COMMENT '一级推荐人订单', `order_second` int(11) unsigned DEFAULT NULL COMMENT '二级推荐人订单', `now_money` int(11) unsigned DEFAULT NULL COMMENT '佣金', `session_key` varchar(32) DEFAULT NULL COMMENT '小程序用户会话密匙', `user_type` varchar(32) DEFAULT 'wechat' COMMENT '用户类型', PRIMARY KEY (`uid`), UNIQUE KEY `openid` (`openid`) USING BTREE, KEY `groupid` (`groupid`) USING BTREE, KEY `subscribe_time` (`subscribe_time`) USING BTREE, KEY `add_time` (`add_time`) USING BTREE, KEY `subscribe` (`subscribe`) USING BTREE, KEY `unionid` (`unionid`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=1447 DEFAULT CHARSET=utf8 COMMENT='微信用户表'; SET FOREIGN_KEY_CHECKS = 1; ```