奇店社区团购智慧电商小程序v1.3.9+前端

/* Navicat MySQL Data Transfer Source Server : we79 Source Server Version : 50562 Source Host : localhost:3306 Source Database : we79 Target Server Type : MYSQL Target Server Version : 50562 File Encoding : 65001 Date: 2020-06-25 00:00:29 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `ims_qidian_lifeshop_address` -- ---------------------------- DROP TABLE IF EXISTS `ims_qidian_lifeshop_address`; CREATE TABLE `ims_qidian_lifeshop_address` ( `address_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id', `uniacid` int(11) NOT NULL COMMENT '公众号id', `member_id` int(11) NOT NULL COMMENT '会员id', `name` varchar(100) NOT NULL COMMENT '收货人姓名', `telephone` varchar(50) NOT NULL COMMENT '电话', `address` varchar(255) NOT NULL COMMENT '收货地址', `address_name` enum('HOME','WORK') NOT NULL DEFAULT 'HOME' COMMENT '收货地址类型', `lon_lat` varchar(30) DEFAULT '' COMMENT '地址经纬度', `lou_meng_hao` varchar(100) DEFAULT '' COMMENT '门牌号-楼号', `is_default` tinyint(1) NOT NULL COMMENT '是否默认的收货地址', `city_id` int(10) NOT NULL COMMENT '市', `country_id` int(10) NOT NULL COMMENT '县乡', `province_id` int(10) NOT NULL COMMENT '省', PRIMARY KEY (`address_id`), KEY `uniacid` (`uniacid`,`member_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='奇店社区商城地址库'; -- ---------------------------- -- Records of ims_qidian_lifeshop_address -- ---------------------------- -- ---------------------------- -- Table structure for `ims_qidian_lifeshop_adv` -- ---------------------------- DROP TABLE IF EXISTS `ims_qidian_lifeshop_adv`; CREATE TABLE `ims_qidian_lifeshop_adv` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id', `uniacid` int(11) NOT NULL COMMENT '公众号id', `advname` varchar(200) NOT NULL COMMENT '广告名称', `thumb` varchar(255) NOT NULL COMMENT '图片地址', `link` varchar(255) NOT NULL COMMENT '广告链接地址', `appid` varchar(255) DEFAULT NULL COMMENT '外部小程序appid', `linktype` tinyint(1) NOT NULL DEFAULT '1' COMMENT '0外链 1小程序内 2外部小程序', `type` enum('slider','nav') NOT NULL COMMENT '广告类型，slider幻灯，nav导航小图', `catid` int(11) NOT NULL DEFAULT '0', `displayorder` int(10) NOT NULL COMMENT '排序，越大排序越前面', `enabled` tinyint(1) NOT NULL COMMENT '是否生效，1生效，0不生效', `addtime` int(10) NOT NULL COMMENT '添加广告时间', `urlid` int(10) NOT NULL COMMENT '小程序 url id', PRIMARY KEY (`id`), KEY `uniacid` (`uniacid`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='奇店社区商城商品广告表'; -- ---------------------------- -- Records of ims_qidian_lifeshop_adv -- ---------------------------- -- ---------------------------- -- Table structure for `ims_qidian_lifeshop_appointment` -- ---------------------------- DROP TABLE IF EXISTS `ims_qidian_lifeshop_appointment`; CREATE TABLE `ims_qidian_lifeshop_appointment` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `fieldname` varchar(30) NOT NULL COMMENT '字段名称', `uniacid` int(10) NOT NULL, `fieldform` varchar(255) NOT NULL COMMENT '备注', `is_field` tinyint(1) NOT NULL DEFAULT '0' COMMENT '表单类型', `order_by` int(11) NOT NULL COMMENT '排序', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=269 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of ims_qidian_lifeshop_appointment -- ---------------------------- -- ---------------------------- -- Table structure for `ims_qidian_lifeshop_area` -- ---------------------------- DROP TABLE IF EXISTS `ims_qidian_lifeshop_area`; CREATE TABLE `ims_qidian_lifeshop_area` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '11', `uniacid` int(11) NOT NULL COMMENT '公众号id', `name` varchar(100) NOT NULL COMMENT '地区名称', `pid` int(11) NOT NULL COMMENT '上级id', `code` varchar(20) NOT NULL COMMENT '地区编号', PRIMARY KEY (`id`), KEY `uniacid` (`uniacid`), KEY `pid` (`pid`) ) ENGINE=InnoDB AUTO_INCREMENT=3608 DEFAULT CHARSET=utf8 COMMENT='奇店社区商城地区配置表'; -- ---------------------------- -- Records of ims_qidian_lifeshop_area -- ---------------------------- -- ---------------------------- -- Table structure for `ims_qidian_lifeshop_article` -- ---------------------------- DROP TABLE IF EXISTS `ims_qidian_lifeshop_article`; CREATE TABLE `ims_qidian_lifeshop_article` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id', `uniacid` int(11) NOT NULL COMMENT '公众号id', `title` varchar(100) NOT NULL COMMENT '标题', `content` text NOT NULL COMMENT '内容', `thumb` varchar(100) NOT NULL COMMENT '专题图片', `displayorder` int(10) NOT NULL COMMENT '排序，越大排序越前面', `enabled` tinyint(1) NOT NULL COMMENT '是否生效，1生效，0不生效', `addtime` int(10) NOT NULL COMMENT '添加时间', PRIMARY KEY (`id`), KEY `uniacid` (`uniacid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='奇店社区商城文章列表'; -- ---------------------------- -- Records of ims_qidian_lifeshop_article -- ---------------------------- -- ---------------------------- -- Table structure for `ims_qidian_lifeshop_articlelun` -- ---------------------------- DROP TABLE IF EXISTS `ims_qidian_lifeshop_articlelun`; CREATE TABLE `ims_qidian_lifeshop_articlelun` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `advname` varchar(20) DEFAULT NULL, `lunimg` varchar(100) DEFAULT NULL, `displayorder` int(11) DEFAULT NULL, `enabled` tinyint(4) DEFAULT '1', `uniacid` int(10) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='专题轮播图表'; -- ---------------------------- -- Records of ims_qidian_lifeshop_articlelun -- ---------------------------- -- ---------------------------- -- Table structure for `ims_qidian_lifeshop_biaoshi` -- ---------------------------- DROP TABLE IF EXISTS `ims_qidian_lifeshop_biaoshi`; CREATE TABLE `ims_qidian_lifeshop_biaoshi` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `type` enum('pintuan','normal','lottery','virtual','bargain','integral','community','water','house') NOT NULL DEFAULT 'normal' COMMENT '标识类型', `name` varchar(20) NOT NULL, `is_show` tinyint(4) NOT NULL DEFAULT '0', `thumb` varchar(100) NOT NULL, `uniacid` int(10) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='门店标识'; -- ---------------------------- -- Records of ims_qidian_lifeshop_biaoshi -- ---------------------------- -- ---------------------------- -- Table structure for `ims_qidian_lifeshop_car` -- ---------------------------- DROP TABLE IF EXISTS `ims_qidian_lifeshop_car`; CREATE TABLE `ims_qidian_lifeshop_car` ( `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '自增id', `uniacid` int(11) NOT NULL COMMENT '公众号id', `token` varchar(200) NOT NULL COMMENT '客户端token,会员身份', `community_id` int(10) NOT NULL COMMENT '团长id', `carkey` varchar(255) NOT NULL COMMENT '购物车key', `format_data` text NOT NULL COMMENT '购物车商品参数', `modifytime` int(10) DEFAULT '0' COMMENT '加入购物车时间', PRIMARY KEY (`id`), KEY `token` (`token`), KEY `uniacid` (`uniacid`), KEY `community_id` (`community_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='客户端购物车表'; -- ---------------------------- -- Records of ims_qidian_lifeshop_car -- ---------------------------- -- ---------------------------- -- Table structure for `ims_qidian_lifeshop_cash` -- ---------------------------- DROP TABLE IF EXISTS `ims_qidian_lifeshop_cash`; CREATE TABLE `ims_qidian_lifeshop