1940 lines
91 KiB
SQL
Executable File
1940 lines
91 KiB
SQL
Executable File
-- MySQL dump 10.13 Distrib 5.7.44, for Linux (x86_64)
|
||
--
|
||
-- Host: 127.0.0.1 Database: youda_test
|
||
-- ------------------------------------------------------
|
||
-- Server version 5.7.44-log
|
||
|
||
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
||
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
||
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
||
/*!40101 SET NAMES utf8 */;
|
||
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
|
||
/*!40103 SET TIME_ZONE='+00:00' */;
|
||
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
|
||
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
|
||
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
||
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
|
||
|
||
--
|
||
-- Table structure for table `admin`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `admin`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `admin` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`username` varchar(20) CHARACTER SET gbk DEFAULT NULL COMMENT '账号',
|
||
`nickname` varchar(20) COLLATE utf8_unicode_ci NOT NULL COMMENT '姓名',
|
||
`password` varchar(40) CHARACTER SET gbk DEFAULT NULL COMMENT '登录密码',
|
||
`qid` int(10) unsigned DEFAULT NULL COMMENT '权限ID',
|
||
`status` int(11) unsigned DEFAULT '0' COMMENT '0正常 1禁用',
|
||
`get_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '登录刷新时间',
|
||
`random` varchar(20) CHARACTER SET utf8 NOT NULL COMMENT 'token随机数',
|
||
`token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'token',
|
||
`admin_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '操作人',
|
||
`addtime` int(11) unsigned NOT NULL DEFAULT '0',
|
||
`update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='管理员';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `admin_goods_log`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `admin_goods_log`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `admin_goods_log` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`a_id` int(11) NOT NULL COMMENT '管理员ID',
|
||
`goods_id` int(11) DEFAULT '0',
|
||
`goods_list_id` int(11) DEFAULT '0',
|
||
`original_data` text COLLATE utf8_unicode_ci,
|
||
`new_data` text COLLATE utf8_unicode_ci,
|
||
`ip` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '登录ip',
|
||
`addtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '登录时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='管理员登录日志';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `admin_login_log`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `admin_login_log`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `admin_login_log` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`a_id` int(11) NOT NULL COMMENT '管理员ID',
|
||
`ip` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '登录ip',
|
||
`addtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '登录时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='管理员登录日志';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `admin_operation_log`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `admin_operation_log`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `admin_operation_log` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`a_id` int(11) NOT NULL COMMENT '管理员ID',
|
||
`ip` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '操作ip',
|
||
`operation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '操作控制器',
|
||
`content` text COLLATE utf8_unicode_ci,
|
||
`addtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '操作时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=2789 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='管理员操作日志';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `admin_quanxian`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `admin_quanxian`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `admin_quanxian` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`title` varchar(100) DEFAULT NULL,
|
||
`describe` longtext,
|
||
`quanxian` text,
|
||
`addtime` int(11) DEFAULT NULL,
|
||
`update_time` int(11) DEFAULT NULL,
|
||
`admin_id` int(11) DEFAULT NULL COMMENT '操作人',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gbk COMMENT='权限';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `ads`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `ads`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `ads` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`ads` int(11) DEFAULT NULL COMMENT '序号',
|
||
`title` varchar(255) DEFAULT NULL,
|
||
`account_id` varchar(255) DEFAULT NULL,
|
||
`access_token` varchar(255) DEFAULT NULL,
|
||
`user_action_set_id` varchar(255) DEFAULT NULL,
|
||
`status` int(11) DEFAULT '1' COMMENT '1.正常 2.已禁用',
|
||
`create_time` varchar(255) DEFAULT NULL,
|
||
`update_time` varchar(255) DEFAULT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `advert`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `advert`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `advert` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`imgurl` varchar(100) NOT NULL COMMENT '图片',
|
||
`url` varchar(225) DEFAULT NULL COMMENT '跳转路径',
|
||
`sort` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
|
||
`type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '类型 1首页轮播图 2抽卡机轮播图',
|
||
`addtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
|
||
`ttype` tinyint(1) unsigned DEFAULT '0' COMMENT '跳转类型 0不跳转 1优惠券 2一番赏 3无限赏',
|
||
`coupon_id` int(11) unsigned DEFAULT '0' COMMENT '优惠券id',
|
||
`goods_id` int(11) unsigned DEFAULT '0' COMMENT '盒子id',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=161 DEFAULT CHARSET=gbk;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `advert_type`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `advert_type`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `advert_type` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`name` varchar(50) NOT NULL,
|
||
`sort` int(10) DEFAULT '0',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `card_level`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `card_level`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `card_level` (
|
||
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
|
||
`title` varchar(255) CHARACTER SET utf8mb4 NOT NULL COMMENT '卡名称',
|
||
`imgurl` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '等级图片',
|
||
`sort` int(11) DEFAULT NULL COMMENT '排序',
|
||
`addtime` int(11) DEFAULT NULL COMMENT '添加时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `category`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `category`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `category` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
`title` varchar(255) NOT NULL COMMENT '商品名称',
|
||
`sort` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
|
||
`addtime` int(10) unsigned NOT NULL COMMENT '添加时间',
|
||
`update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `id` (`id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='盒子分类';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `code`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `code`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `code` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '验证码id',
|
||
`phone` varchar(11) NOT NULL COMMENT '手机号',
|
||
`code` varchar(6) NOT NULL COMMENT '验证码',
|
||
`addtime` int(11) NOT NULL COMMENT '添加时间',
|
||
`type` tinyint(1) NOT NULL COMMENT '类型，1 登录注册',
|
||
`status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态 0正常，-1失效',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='短信记录';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `collect`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `collect`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `collect` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
|
||
`goods_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '盒子ID',
|
||
`num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '箱号',
|
||
`type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '1一番赏 2无限赏 3擂台赏 4抽卡机 5积分赏 6全局赏 7福利盲盒 8领主赏 9连击赏',
|
||
`addtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=FIXED;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `config`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `config`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `config` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`key` varchar(255) NOT NULL,
|
||
`value` text,
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `coupon`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `coupon`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `coupon` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
`type` tinyint(1) unsigned DEFAULT '0' COMMENT '1新人优惠券 2权益优惠卷',
|
||
`title` varchar(255) NOT NULL COMMENT '商品名称',
|
||
`sort` int(10) unsigned DEFAULT '1' COMMENT '排序值',
|
||
`price` decimal(10,2) unsigned DEFAULT NULL COMMENT '减多少',
|
||
`man_price` decimal(10,2) DEFAULT NULL COMMENT '满多少减多少',
|
||
`effective_day` int(11) DEFAULT NULL COMMENT '有效时间(天)',
|
||
`addtime` int(10) unsigned NOT NULL COMMENT '添加时间',
|
||
`status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0上架 2下架 4已删除',
|
||
`ttype` tinyint(1) unsigned DEFAULT '0' COMMENT '是否限制使用 0不限制 1一番赏 2无限赏 3擂台赏 6全局赏 9领主赏 9连击赏',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `id` (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=302 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='优惠券表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `coupon_receive`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `coupon_receive`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `coupon_receive` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
`title` varchar(255) NOT NULL COMMENT '商品名称',
|
||
`price` decimal(10,2) unsigned DEFAULT NULL COMMENT '商品价格',
|
||
`man_price` decimal(10,2) DEFAULT NULL COMMENT '满多少减多少',
|
||
`end_time` int(11) DEFAULT NULL COMMENT '过期时间',
|
||
`addtime` int(10) unsigned NOT NULL COMMENT '添加时间',
|
||
`status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0未使用1已使用2已过期',
|
||
`user_id` int(11) DEFAULT NULL COMMENT '会员id',
|
||
`coupon_id` int(11) DEFAULT NULL,
|
||
`state` tinyint(1) unsigned DEFAULT '0' COMMENT '是否限制使用 0不限制 1一番赏 2无限赏 3擂台赏 6全局赏 9领主赏 9连击赏',
|
||
`ttype` int(2) NOT NULL DEFAULT '0',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `id` (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户优惠券表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `danye`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `danye`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `danye` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '类型，1服务协议，2隐私政策',
|
||
`title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '标题',
|
||
`content` text COLLATE utf8_unicode_ci NOT NULL COMMENT '内容',
|
||
`update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
|
||
`status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0正常 1隐藏',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `delivery`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `delivery`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `delivery` (
|
||
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
|
||
`name` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '快递公司',
|
||
`code` varchar(30) COLLATE utf8_unicode_ci NOT NULL COMMENT '快递编码',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='快递公司';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `error_log`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `error_log`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `error_log` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(11) NOT NULL,
|
||
`goods_id` int(11) NOT NULL,
|
||
`addtime` int(11) NOT NULL,
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `give`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `give`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `give` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '会员id',
|
||
`time_int` varchar(100) DEFAULT NULL,
|
||
`time_date` varchar(100) DEFAULT NULL,
|
||
`money` decimal(10,2) unsigned NOT NULL COMMENT '消费金额',
|
||
`addtime` int(11) unsigned NOT NULL DEFAULT '0',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `id` (`id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='无限令领取记录';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `goods`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `goods`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `goods` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
`category_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '分类ID',
|
||
`title` varchar(255) NOT NULL COMMENT '盒子名称',
|
||
`imgurl` varchar(255) NOT NULL COMMENT '盒子封面图',
|
||
`imgurl_detail` varchar(255) NOT NULL COMMENT '盒子详情图',
|
||
`price` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '商品价格',
|
||
`stock` int(10) unsigned DEFAULT '0' COMMENT '套数',
|
||
`sale_stock` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '销量库存',
|
||
`lock_is` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '锁箱 0否 1是',
|
||
`lock_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '锁箱时间',
|
||
`coupon_is` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '发券开关0关闭 1开启',
|
||
`coupon_pro` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '发券概率',
|
||
`integral_is` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '发积分开关0关闭 1开启',
|
||
`prize_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '擂台赏抽全局赏数量',
|
||
`status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '1上架 2下架 3售罄',
|
||
`sort` int(10) unsigned DEFAULT '1' COMMENT '排序值',
|
||
`type` tinyint(1) unsigned DEFAULT '0' COMMENT '1一番赏 2无限赏 3擂台赏 4抽卡机 5积分赏 6全局赏 7福利盲盒 8领主赏 9连击赏',
|
||
`show_is` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '首页显示 0是 1否',
|
||
`show_price` varchar(100) DEFAULT NULL COMMENT '卡册显示价格',
|
||
`prize_imgurl` varchar(255) DEFAULT NULL COMMENT '抽卡机卡牌背面图',
|
||
`card_banner` varchar(255) DEFAULT NULL COMMENT '卡册banner',
|
||
`card_set` text COMMENT '抽卡机抽奖设置',
|
||
`card_notice` varchar(255) DEFAULT NULL COMMENT '抽卡机描述',
|
||
`sale_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '预售时间',
|
||
`addtime` int(10) unsigned NOT NULL COMMENT '添加时间',
|
||
`update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
|
||
`delete_time` int(11) DEFAULT NULL,
|
||
`card_num` int(11) DEFAULT '1' COMMENT '一包几张',
|
||
`rage_is` tinyint(1) unsigned DEFAULT '0' COMMENT '怒气值开关 0关 1开',
|
||
`rage` int(11) unsigned DEFAULT '0' COMMENT '怒气值',
|
||
`item_card_id` int(11) unsigned DEFAULT '0' COMMENT '道具卡ID',
|
||
`lingzhu_is` tinyint(1) DEFAULT '0' COMMENT '领主开关 0关 1开',
|
||
`lingzhu_fan` int(11) DEFAULT '0' COMMENT '领主每发返',
|
||
`lingzhu_shang_id` int(11) DEFAULT '0' COMMENT '请选择抽中领主',
|
||
`king_user_id` int(11) DEFAULT '0' COMMENT '当前领主',
|
||
`lian_ji_num` int(11) DEFAULT '0' COMMENT '连击赏连击次数',
|
||
`lian_ji_shang_id` int(11) DEFAULT '0' COMMENT '连击赏赏id',
|
||
`is_shou_zhe` tinyint(1) unsigned DEFAULT '0' COMMENT '是否首抽五折 1是 0否',
|
||
`new_is` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '最新开关0关闭 1开启',
|
||
`goods_describe` varchar(300) DEFAULT NULL COMMENT '描述',
|
||
`quanju_xiangou` int(11) DEFAULT '0' COMMENT '全局赏限购次数',
|
||
`day_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '需要的流水',
|
||
`mouth_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '月总流水',
|
||
`mouth_pay_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '月实付',
|
||
`day_pay_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '日实付',
|
||
`user_lv` int(11) NOT NULL DEFAULT '-1' COMMENT '多少级之下能买',
|
||
`is_flw` int(1) NOT NULL DEFAULT '0' COMMENT '是否福利屋',
|
||
`flw_start_time` int(10) NOT NULL DEFAULT '0' COMMENT '福利屋开始时间',
|
||
`flw_end_time` int(10) NOT NULL DEFAULT '0' COMMENT '福利屋结束时间',
|
||
`open_time` int(10) NOT NULL DEFAULT '0' COMMENT '开奖时间',
|
||
`is_open` int(2) NOT NULL DEFAULT '0' COMMENT '0未开奖 1已开奖',
|
||
`choujiang_xianzhi` int(11) NOT NULL DEFAULT '0' COMMENT '抽奖门槛',
|
||
`async_code` varchar(64) DEFAULT NULL COMMENT '同步编码，guid',
|
||
`async_date` datetime DEFAULT NULL COMMENT '最后一次同步时间',
|
||
`is_auto_xiajia` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否自动下架',
|
||
`xiajia_lirun` int(11) NOT NULL DEFAULT '0' COMMENT '下架利润率',
|
||
`xiajia_auto_coushu` int(11) NOT NULL DEFAULT '0' COMMENT '下架生效抽数',
|
||
`unlock_amount` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '消费多少额度解锁盒子',
|
||
`daily_xiangou` int(11) NOT NULL DEFAULT '0' COMMENT '每日限购次数',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `id` (`id`) USING BTREE,
|
||
KEY `status` (`status`) USING BTREE,
|
||
KEY `type` (`type`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=1046 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='盒子';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `goods_extend`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `goods_extend`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `goods_extend` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`goods_id` int(11) NOT NULL COMMENT '奖品Id',
|
||
`pay_wechat` tinyint(1) NOT NULL DEFAULT '1' COMMENT '微信支付',
|
||
`pay_balance` tinyint(1) NOT NULL DEFAULT '1' COMMENT '余额支付',
|
||
`pay_currency` tinyint(1) NOT NULL DEFAULT '1' COMMENT '货币支付',
|
||
`pay_currency2` tinyint(1) NOT NULL DEFAULT '1' COMMENT '货币2支付',
|
||
`pay_coupon` tinyint(1) NOT NULL DEFAULT '1' COMMENT '优惠券支付',
|
||
`is_deduction` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否抵扣 1:抵扣 0:支付',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='盒子扩展表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `goods_king_rank`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `goods_king_rank`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `goods_king_rank` (
|
||
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(11) unsigned NOT NULL DEFAULT '0',
|
||
`goods_id` int(11) NOT NULL,
|
||
`count` int(11) DEFAULT '0' COMMENT '多少发升级为领主',
|
||
`z_nums` int(11) unsigned DEFAULT '0' COMMENT '占领了多少发',
|
||
`money` decimal(10,2) unsigned DEFAULT '0.00',
|
||
`order_list_id` int(11) DEFAULT '0' COMMENT '奖品ID',
|
||
`addtime` int(11) DEFAULT NULL COMMENT '开始时间',
|
||
`end_time` int(11) DEFAULT NULL COMMENT '结束时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='无限赏领主';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `goods_list`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `goods_list`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `goods_list` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
`goods_id` int(11) NOT NULL DEFAULT '0' COMMENT '盲盒id 0无限令 -1周榜 -2月榜',
|
||
`num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '第几套',
|
||
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '奖品名称',
|
||
`imgurl` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '奖品图片',
|
||
`stock` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '库存',
|
||
`surplus_stock` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '剩余库存',
|
||
`price` decimal(10,2) unsigned NOT NULL COMMENT '奖品价值',
|
||
`money` decimal(10,2) unsigned NOT NULL COMMENT '奖品兑换价',
|
||
`sc_money` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '市场参考价',
|
||
`real_pro` decimal(10,5) unsigned NOT NULL DEFAULT '0.00000' COMMENT '真实概率',
|
||
`goods_type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '1现货 2预售',
|
||
`sale_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '预售时间',
|
||
`sort` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
|
||
`shang_id` int(255) DEFAULT NULL COMMENT '赏ID',
|
||
`reward_num` int(11) unsigned NOT NULL DEFAULT '0',
|
||
`rank` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '榜单排名',
|
||
`give_money` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '消费阀值',
|
||
`special_stock` int(10) NOT NULL DEFAULT '-100' COMMENT '抽卡机特殊库存',
|
||
`card_no` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '奖品赠送编号',
|
||
`prize_code` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '奖品编号',
|
||
`addtime` int(10) DEFAULT NULL COMMENT '添加时间',
|
||
`update_time` int(11) unsigned NOT NULL DEFAULT '0',
|
||
`prize_num` int(11) DEFAULT '0' COMMENT '擂台赏抽全局赏数量',
|
||
`type` tinyint(1) DEFAULT '0' COMMENT '7抽奖券的奖品',
|
||
`lian_ji_type` tinyint(1) DEFAULT '0' COMMENT '连击赏奖池分类 1秘宝池 0否',
|
||
`reward_id` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '发放奖励id',
|
||
`imgurl_detail` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '商品详情图',
|
||
`doubling` int(11) NOT NULL DEFAULT '0' COMMENT '倍率',
|
||
`goods_list_id` int(11) NOT NULL DEFAULT '0' COMMENT '父节点id',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `id` (`id`) USING BTREE,
|
||
KEY `num` (`num`) USING BTREE,
|
||
KEY `goods_id` (`num`) USING BTREE,
|
||
KEY `shang_id` (`shang_id`) USING BTREE,
|
||
KEY `real_pro` (`real_pro`) USING BTREE,
|
||
KEY `stock` (`stock`) USING BTREE,
|
||
KEY `surplus_stock` (`surplus_stock`) USING BTREE,
|
||
KEY `prize_code` (`prize_code`) USING BTREE,
|
||
KEY `card_no` (`card_no`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=533 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='盒子奖品';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `goods_lock`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `goods_lock`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `goods_lock` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
|
||
`goods_id_num` varchar(20) NOT NULL COMMENT '盒子id_num',
|
||
`endtime` int(11) unsigned NOT NULL COMMENT '过期时间',
|
||
`update_time` int(11) unsigned NOT NULL DEFAULT '0',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `id` (`id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='盒子锁箱信息';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `goods_offshelf_log`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `goods_offshelf_log`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `goods_offshelf_log` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`goods_id` int(11) NOT NULL COMMENT '盒子ID',
|
||
`profit_rate` decimal(10,2) NOT NULL COMMENT '当前利润率',
|
||
`xiajia_lirun` decimal(10,2) NOT NULL COMMENT '配置的下架利润阈值',
|
||
`order_total` decimal(10,2) NOT NULL COMMENT '订单总价值',
|
||
`goods_total` decimal(10,2) NOT NULL COMMENT '出货总价值',
|
||
`create_time` int(11) NOT NULL COMMENT '下架时间',
|
||
PRIMARY KEY (`id`),
|
||
KEY `idx_goods_id` (`goods_id`),
|
||
KEY `idx_create_time` (`create_time`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COMMENT='盒子自动下架日志表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `goods_type`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `goods_type`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `goods_type` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`name` varchar(30) NOT NULL COMMENT '名称',
|
||
`value` int(11) NOT NULL COMMENT 'key',
|
||
`sort_order` int(11) NOT NULL COMMENT '排序字段',
|
||
`is_show` tinyint(1) NOT NULL COMMENT '是否首页显示',
|
||
`remark` varchar(255) DEFAULT NULL COMMENT '备注',
|
||
`pay_wechat` tinyint(1) NOT NULL DEFAULT '1' COMMENT '微信支付',
|
||
`pay_balance` tinyint(1) NOT NULL DEFAULT '1' COMMENT '余额支付',
|
||
`pay_currency` tinyint(1) NOT NULL DEFAULT '1' COMMENT '货币支付',
|
||
`pay_currency2` tinyint(1) NOT NULL DEFAULT '1' COMMENT '货币2支付',
|
||
`pay_coupon` tinyint(1) NOT NULL DEFAULT '1' COMMENT '优惠券支付',
|
||
`is_deduction` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否抵扣 1:抵扣 0:支付',
|
||
`is_fenlei` tinyint(4) NOT NULL COMMENT '是否显示在分类中',
|
||
`fl_name` varchar(30) NOT NULL COMMENT '分类名称',
|
||
`corner_text` varchar(255) DEFAULT NULL COMMENT '角标文字',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `item_card`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `item_card`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `item_card` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
`type` tinyint(1) unsigned DEFAULT '0' COMMENT '1重抽卡',
|
||
`title` varchar(255) NOT NULL COMMENT '名称',
|
||
`sort` int(10) unsigned DEFAULT '1' COMMENT '排序值',
|
||
`status` tinyint(1) DEFAULT '0' COMMENT '1正常 2下架 3删除',
|
||
`addtime` int(10) unsigned NOT NULL COMMENT '添加时间',
|
||
`updatetime` int(11) NOT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `id` (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='道具卡';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `kk_order`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `kk_order`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `kk_order` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(10) unsigned NOT NULL COMMENT '会员id',
|
||
`order_no` varchar(100) NOT NULL COMMENT '订单号',
|
||
`total_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '商品总金额',
|
||
`price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '实付金额',
|
||
`money` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '余额抵扣',
|
||
`integral` decimal(10,2) unsigned DEFAULT '0.00' COMMENT 'Woo币抵扣',
|
||
`freight_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '运费金额',
|
||
`status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0待付款 1待发货 2待收货 3确认收货',
|
||
`content` varchar(200) NOT NULL COMMENT '留言',
|
||
`addtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
|
||
`pay_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '支付时间',
|
||
`deliver_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '发货时间',
|
||
`confirm_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '收货时间',
|
||
`update_time` int(11) DEFAULT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `id` (`id`) USING BTREE,
|
||
UNIQUE KEY `order_no` (`order_no`) USING BTREE,
|
||
KEY `user_id` (`user_id`) USING BTREE,
|
||
KEY `status` (`status`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='发货订单表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `kk_order_good`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `kk_order_good`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `kk_order_good` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(10) unsigned NOT NULL COMMENT '会员id',
|
||
`order_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '订单id',
|
||
`goods_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '商品id',
|
||
`goods_name` varchar(255) NOT NULL COMMENT '商品名称',
|
||
`goods_image` varchar(255) NOT NULL COMMENT '商品主图',
|
||
`goods_spec_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '商品规格id',
|
||
`goods_spec` varchar(255) NOT NULL COMMENT '商品规格',
|
||
`goods_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '商品售价',
|
||
`goods_seckill_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '商品秒杀价',
|
||
`goods_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '数量',
|
||
`addtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='订单商品';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `kk_order_send`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `kk_order_send`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `kk_order_send` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员id',
|
||
`order_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '订单ID',
|
||
`shou_name` varchar(255) DEFAULT NULL COMMENT '收货人姓名',
|
||
`shou_mobile` varchar(255) DEFAULT NULL COMMENT '收货人手机号',
|
||
`shou_region` varchar(255) DEFAULT NULL COMMENT '所在地区 省/市/区(名称)',
|
||
`address` varchar(255) DEFAULT NULL COMMENT '详细地址',
|
||
`delivery_name` varchar(255) DEFAULT NULL COMMENT '物流名称',
|
||
`delivery_no` varchar(255) DEFAULT NULL COMMENT '物流单号',
|
||
`update_time` int(11) DEFAULT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `id` (`id`) USING BTREE,
|
||
UNIQUE KEY `order_id` (`order_id`) USING BTREE,
|
||
KEY `user_id` (`user_id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='发货订单地址物流信息';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `kk_product`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `kk_product`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `kk_product` (
|
||
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
|
||
`seckill_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '秒杀时间段id',
|
||
`cate_id1` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '分类父级id',
|
||
`cate_id2` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '分类子级id',
|
||
`title` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '商品名称',
|
||
`image` varchar(200) COLLATE utf8_unicode_ci NOT NULL COMMENT '商品主图',
|
||
`detail_image` text COLLATE utf8_unicode_ci NOT NULL COMMENT '详情图',
|
||
`content` longtext COLLATE utf8_unicode_ci COMMENT '商品详情',
|
||
`freight` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '运费',
|
||
`sale_num` int(9) unsigned NOT NULL DEFAULT '0' COMMENT '销量',
|
||
`sort` int(7) unsigned NOT NULL DEFAULT '0' COMMENT '商品排序',
|
||
`status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0上架 1下架',
|
||
`spec_data` longtext COLLATE utf8_unicode_ci COMMENT '规格信息',
|
||
`addtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `id` (`id`) USING BTREE,
|
||
KEY `title` (`title`) USING BTREE,
|
||
KEY `status` (`status`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='商品表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `kk_product_cate`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `kk_product_cate`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `kk_product_cate` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
`title` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '分类标题',
|
||
`imgurl` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '分类图片',
|
||
`sort` int(5) unsigned DEFAULT '1' COMMENT '排序值',
|
||
`status` tinyint(1) unsigned DEFAULT '1' COMMENT '1 正常 2 删除',
|
||
`pid` int(11) DEFAULT '0' COMMENT '上级id',
|
||
`addtime` int(10) unsigned NOT NULL COMMENT '添加时间',
|
||
`title2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '英文标题',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='商品分类';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `kk_product_category`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `kk_product_category`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `kk_product_category` (
|
||
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
|
||
`pid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '父级id',
|
||
`title` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '商品名称',
|
||
`imgurl` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '分类图片',
|
||
`status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '1显示 0隐藏',
|
||
`sort` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '0',
|
||
`addtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `id` (`id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='普通商城商品分类';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `kk_product_spec`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `kk_product_spec`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `kk_product_spec` (
|
||
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
|
||
`pro_id` int(11) NOT NULL COMMENT '商品id',
|
||
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '名称',
|
||
`price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '售价',
|
||
`seckill_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '秒杀价',
|
||
`stock` int(9) unsigned NOT NULL DEFAULT '0' COMMENT '库存',
|
||
`pic` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '图片',
|
||
`ks` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '标识',
|
||
`time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `id` (`id`) USING BTREE,
|
||
KEY `pro_id` (`pro_id`) USING BTREE,
|
||
KEY `ks` (`ks`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='商品规格';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `kk_seckill`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `kk_seckill`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `kk_seckill` (
|
||
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
|
||
`seckill_time` varchar(100) COLLATE utf8_unicode_ci NOT NULL COMMENT '秒杀时间段',
|
||
`goods_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '商品限购数量',
|
||
`addtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='秒杀设置';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `kk_share`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `kk_share`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `kk_share` (
|
||
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '点击人ID',
|
||
`goods_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '商品id',
|
||
`share_user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '分享用户id',
|
||
`addtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `id` (`id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='商品分享记录表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `market`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `market`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `market` (
|
||
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(11) NOT NULL,
|
||
`order_num` varchar(255) NOT NULL COMMENT '挂售单号',
|
||
`price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '价格',
|
||
`order_list_ids` longtext NOT NULL COMMENT 'id字符串',
|
||
`status` tinyint(1) unsigned DEFAULT '0' COMMENT '0在售 1已售 2已撤回',
|
||
`stock` tinyint(1) unsigned NOT NULL DEFAULT '1',
|
||
`addtime` int(11) NOT NULL,
|
||
`update_time` int(11) NOT NULL,
|
||
`deltime` int(11) DEFAULT NULL,
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='集市';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `market_order`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `market_order`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `market_order` (
|
||
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
|
||
`market_id` int(11) NOT NULL,
|
||
`user_id` int(11) NOT NULL,
|
||
`order_num` varchar(255) NOT NULL COMMENT '挂售单号',
|
||
`price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '价格',
|
||
`order_list_ids` longtext NOT NULL COMMENT 'id字符串',
|
||
`status` tinyint(1) unsigned DEFAULT '0' COMMENT '1未支付 2已支付 3卡单',
|
||
`pay_time` int(11) DEFAULT NULL,
|
||
`total` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '总价',
|
||
`total_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '实际支付',
|
||
`money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '支付了多少市集余额',
|
||
`addtime` int(11) NOT NULL,
|
||
`update_time` int(11) NOT NULL,
|
||
`deltime` int(11) DEFAULT NULL,
|
||
`zdfh_is` tinyint(1) unsigned NOT NULL DEFAULT '0',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='集市订单';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `migrations`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `migrations`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `migrations` (
|
||
`version` bigint(20) NOT NULL,
|
||
`migration_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`start_time` timestamp NULL DEFAULT NULL,
|
||
`end_time` timestamp NULL DEFAULT NULL,
|
||
`breakpoint` tinyint(1) NOT NULL DEFAULT '0',
|
||
PRIMARY KEY (`version`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `notify_log`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `notify_log`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `notify_log` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`order_no` varchar(40) NOT NULL,
|
||
`addtime` int(11) NOT NULL,
|
||
`xml` text,
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `order`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `order`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `order` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
|
||
`order_num` varchar(60) NOT NULL COMMENT '订单号',
|
||
`order_total` decimal(10,2) unsigned NOT NULL COMMENT '订单总金额',
|
||
`order_zhe_total` decimal(10,2) unsigned NOT NULL COMMENT '订单折扣金额',
|
||
`price` decimal(10,2) unsigned NOT NULL COMMENT '微信支付',
|
||
`use_money` decimal(10,2) unsigned NOT NULL COMMENT '钻石支付',
|
||
`use_integral` decimal(10,2) unsigned NOT NULL COMMENT 'UU币支付',
|
||
`use_score` decimal(10,2) unsigned NOT NULL COMMENT '积分抵扣，未使用',
|
||
`use_draw` int(11) DEFAULT '0' COMMENT '抽奖券抵扣',
|
||
`use_item_card` int(11) DEFAULT '0' COMMENT '道具卡抵扣 (使用的数量)',
|
||
`zhe` decimal(10,2) unsigned NOT NULL COMMENT '折扣',
|
||
`goods_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '盒子id',
|
||
`num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '第几套',
|
||
`goods_price` decimal(10,2) unsigned NOT NULL COMMENT '盒子单价',
|
||
`goods_title` varchar(100) DEFAULT NULL COMMENT '盒子标题',
|
||
`goods_imgurl` varchar(200) DEFAULT NULL COMMENT '盒子图片',
|
||
`prize_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '抽奖数量',
|
||
`prize_card_set` text COMMENT '抽卡机必出设置',
|
||
`status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0未支付 1支付',
|
||
`addtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '下单时间',
|
||
`pay_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '付款时间',
|
||
`pay_type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '1微信 2支付宝',
|
||
`order_type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '盒子类型',
|
||
`kd_is` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '1卡单',
|
||
`coupon_id` int(11) DEFAULT '0' COMMENT '优惠券id',
|
||
`use_coupon` decimal(10,2) DEFAULT '0.00' COMMENT '优惠券抵扣',
|
||
`is_mibao` tinyint(1) DEFAULT '0' COMMENT '连击赏下 是否是抽的秘宝池 1是 0否',
|
||
`is_shou_zhe` tinyint(1) DEFAULT '0' COMMENT '是否首抽五折',
|
||
`zdfh_is` tinyint(1) unsigned NOT NULL DEFAULT '0',
|
||
`ad_id` int(11) DEFAULT '0' COMMENT '广告id',
|
||
`click_id` int(11) DEFAULT NULL,
|
||
`is_flw` int(1) NOT NULL DEFAULT '0' COMMENT '是否为福利屋',
|
||
`zdfh_time` int(10) DEFAULT '0' COMMENT '自动发货时间',
|
||
`use_money2` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '达达卷支付',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `id` (`id`) USING BTREE,
|
||
UNIQUE KEY `order_num` (`order_num`) USING BTREE,
|
||
KEY `user_id` (`user_id`) USING BTREE,
|
||
KEY `goods_id` (`goods_id`) USING BTREE,
|
||
KEY `num` (`num`) USING BTREE,
|
||
KEY `status` (`status`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=246 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='订单表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `order_list`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `order_list`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `order_list` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
`order_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '订单id',
|
||
`user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
|
||
`recovery_num` varchar(100) DEFAULT NULL COMMENT '回收订单',
|
||
`send_num` varchar(100) DEFAULT NULL COMMENT '发货订单号',
|
||
`status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0待选择 1回收 2选择发货 3发布集市',
|
||
`goods_id` int(11) DEFAULT '0' COMMENT '盒子ID',
|
||
`num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '第几箱',
|
||
`shang_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '赏ID',
|
||
`goodslist_id` int(10) unsigned NOT NULL COMMENT '奖品id',
|
||
`goodslist_title` varchar(100) DEFAULT NULL COMMENT '奖品名称',
|
||
`goodslist_imgurl` varchar(255) DEFAULT NULL COMMENT '奖品封面图',
|
||
`goodslist_price` decimal(10,2) unsigned NOT NULL COMMENT '奖品价值',
|
||
`goodslist_money` decimal(10,2) unsigned NOT NULL COMMENT '奖品回收',
|
||
`goodslist_type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '1现货 2预售，3货币，4 宝箱',
|
||
`goodslist_sale_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '预售时间',
|
||
`addtime` int(10) unsigned NOT NULL COMMENT '创建时间',
|
||
`choice_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '选择发货/回收时间',
|
||
`insurance_is` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '保险柜0否 1是',
|
||
`order_type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '盒子类型',
|
||
`order_list_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '特殊奖品中奖订单id',
|
||
`luck_no` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '抽奖序号',
|
||
`prize_code` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '奖品code',
|
||
`is_chong` tinyint(1) DEFAULT '0' COMMENT '是否使用重抽卡 0否 1是',
|
||
`deltime` int(11) DEFAULT NULL,
|
||
`source` tinyint(1) unsigned DEFAULT '1' COMMENT '1抽奖 2集市购买',
|
||
`fh_status` int(11) NOT NULL DEFAULT '0' COMMENT '发货状态，1已发货，2未发货',
|
||
`fh_remarks` varchar(255) DEFAULT NULL COMMENT '发货备注',
|
||
`doubling` int(11) NOT NULL DEFAULT '0' COMMENT '抽奖倍率',
|
||
`parent_goods_list_id` int(11) NOT NULL DEFAULT '0' COMMENT '所属宝箱id',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `id` (`id`) USING BTREE,
|
||
KEY `user_id` (`user_id`) USING BTREE,
|
||
KEY `order_id` (`order_id`) USING BTREE,
|
||
KEY `num` (`num`) USING BTREE,
|
||
KEY `goods_id` (`goods_id`) USING BTREE,
|
||
KEY `recovery_num` (`recovery_num`) USING BTREE,
|
||
KEY `send_num` (`send_num`) USING BTREE,
|
||
KEY `prize_code` (`prize_code`) USING BTREE,
|
||
KEY `order_type` (`order_type`) USING BTREE,
|
||
KEY `status` (`status`) USING BTREE,
|
||
KEY `insurance_is` (`insurance_is`) USING BTREE,
|
||
KEY `goodslist_type` (`goodslist_type`) USING BTREE,
|
||
KEY `shang_id` (`shang_id`) USING BTREE,
|
||
KEY `goodslist_id` (`goodslist_id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=2259 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='订单明细';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `order_list_recovery`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `order_list_recovery`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `order_list_recovery` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(11) unsigned NOT NULL DEFAULT '0',
|
||
`recovery_num` varchar(100) NOT NULL COMMENT '打包订单号',
|
||
`money` decimal(10,2) unsigned NOT NULL COMMENT '打包金额',
|
||
`count` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '打包数量',
|
||
`addtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '打包时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `id` (`id`) USING BTREE,
|
||
UNIQUE KEY `recovery_num` (`recovery_num`) USING BTREE,
|
||
KEY `user_id` (`user_id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='打包记录';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `order_list_send`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `order_list_send`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `order_list_send` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
|
||
`send_num` varchar(100) NOT NULL COMMENT '发货订单号',
|
||
`freight` decimal(10,2) unsigned NOT NULL COMMENT '运费',
|
||
`status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '0待支付 1待发货 2待收货 3已完成 4后台取消',
|
||
`count` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '发货数量',
|
||
`name` varchar(255) DEFAULT NULL COMMENT '收货人姓名',
|
||
`mobile` varchar(255) DEFAULT NULL COMMENT '收货人电话',
|
||
`address` varchar(255) DEFAULT NULL COMMENT '收货地址',
|
||
`message` varchar(255) DEFAULT NULL COMMENT '备注',
|
||
`courier_number` varchar(50) DEFAULT NULL COMMENT '快递单号',
|
||
`courier_name` varchar(255) DEFAULT NULL COMMENT '快递名称',
|
||
`courier_code` varchar(50) DEFAULT NULL COMMENT '快递code',
|
||
`delivery_list` text COMMENT '物流轨迹信息',
|
||
`delivery_status` tinyint(1) NOT NULL DEFAULT '-1' COMMENT '物流状态',
|
||
`delivery_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '物流请求时间',
|
||
`addtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '下单时间',
|
||
`pay_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '支付时间',
|
||
`send_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '发货时间',
|
||
`shou_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '收货时间',
|
||
`cancel_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '取消时间',
|
||
`admin_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '管理员id',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `id` (`id`) USING BTREE,
|
||
UNIQUE KEY `send_num` (`send_num`) USING BTREE,
|
||
KEY `user_id` (`user_id`) USING BTREE,
|
||
KEY `status` (`status`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='发货记录';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `picture`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `picture`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `picture` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
`imgurl` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
|
||
`token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
|
||
`addtime` int(10) unsigned NOT NULL,
|
||
`status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '1 正常 2 删除',
|
||
`type` tinyint(1) DEFAULT NULL COMMENT '存储位置 1=本地 2= 阿里云',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=221 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `profit_draw`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `profit_draw`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `profit_draw` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
|
||
`change_money` decimal(10,2) NOT NULL COMMENT '变化的金额',
|
||
`money` decimal(10,2) unsigned NOT NULL COMMENT '变化后的金额',
|
||
`type` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '1后台充值 2在线充值 3抽赏消费 4背包回收 5推荐奖励',
|
||
`content` varchar(255) NOT NULL COMMENT '描述',
|
||
`addtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`share_uid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '来源ID',
|
||
`other` varchar(255) DEFAULT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `id` (`id`) USING BTREE,
|
||
KEY `user_id` (`user_id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='财务明细';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `profit_expenses`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `profit_expenses`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `profit_expenses` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`expense_type` int(10) NOT NULL COMMENT '支出类型',
|
||
`amount` decimal(10,2) NOT NULL COMMENT '支出金额',
|
||
`description` varchar(255) DEFAULT NULL COMMENT '说明',
|
||
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
|
||
`profit_date` date NOT NULL COMMENT '账单日期',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='利润支出表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `profit_integral`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `profit_integral`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `profit_integral` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
|
||
`change_money` decimal(10,2) NOT NULL COMMENT '变化的金额',
|
||
`money` decimal(10,2) unsigned NOT NULL COMMENT '变化后的金额',
|
||
`type` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '1后台充值 2抽赏消费 3开券获得 4领主返币 5分享欧气券',
|
||
`content` varchar(255) NOT NULL COMMENT '描述',
|
||
`addtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`share_uid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '来源ID',
|
||
`other` varchar(255) DEFAULT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `id` (`id`) USING BTREE,
|
||
KEY `user_id` (`user_id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='财务明细';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `profit_money`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `profit_money`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `profit_money` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
|
||
`change_money` decimal(10,2) NOT NULL COMMENT '变化的金额',
|
||
`money` decimal(10,2) unsigned NOT NULL COMMENT '变化后的金额',
|
||
`type` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '1后台充值 2在线充值 3抽赏消费 4背包回收 5推荐奖励',
|
||
`content` varchar(255) NOT NULL COMMENT '描述',
|
||
`addtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`share_uid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '来源ID',
|
||
`other` varchar(255) DEFAULT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `id` (`id`) USING BTREE,
|
||
KEY `user_id` (`user_id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=217 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='财务明细';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `profit_money2`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `profit_money2`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `profit_money2` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
|
||
`change_money` decimal(10,2) NOT NULL COMMENT '变化的金额',
|
||
`money` decimal(10,2) unsigned NOT NULL COMMENT '变化后的金额',
|
||
`type` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '1后台充值 2在线充值 3市集消费 4市集售卖 5提现 6提现驳回 7提现手续费',
|
||
`content` varchar(255) NOT NULL COMMENT '描述',
|
||
`addtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`share_uid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '来源ID',
|
||
`other` varchar(255) DEFAULT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `id` (`id`) USING BTREE,
|
||
KEY `user_id` (`user_id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='财务明细';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `profit_ou_qi`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `profit_ou_qi`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `profit_ou_qi` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
|
||
`change_money` decimal(10,2) NOT NULL COMMENT '变化的金额',
|
||
`money` decimal(10,2) unsigned NOT NULL COMMENT '变化后的金额',
|
||
`type` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '1完成任务 2消费赠送 3升级清空 4升级后多出',
|
||
`content` varchar(255) NOT NULL COMMENT '描述',
|
||
`addtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`other` varchar(255) DEFAULT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `id` (`id`) USING BTREE,
|
||
KEY `user_id` (`user_id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='欧气值明细';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `profit_pay`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `profit_pay`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `profit_pay` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
|
||
`order_num` varchar(100) NOT NULL COMMENT '订单号',
|
||
`change_money` decimal(10,2) NOT NULL COMMENT '变化的金额',
|
||
`content` varchar(255) NOT NULL COMMENT '描述',
|
||
`pay_type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '1微信 2支付宝',
|
||
`addtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `id` (`id`) USING BTREE,
|
||
KEY `user_id` (`user_id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='(微信/支付宝)支付';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `profit_revenue`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `profit_revenue`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `profit_revenue` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`expense_type` int(10) NOT NULL COMMENT '收入类型',
|
||
`price` decimal(10,2) NOT NULL COMMENT '收入金额',
|
||
`user_id` int(10) NOT NULL COMMENT '用户id',
|
||
`amount` decimal(10,2) NOT NULL COMMENT '发放货币',
|
||
`description` varchar(255) DEFAULT NULL COMMENT '说明',
|
||
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
|
||
`profit_date` date NOT NULL COMMENT '账单日期',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='利润收入表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `profit_score`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `profit_score`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `profit_score` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
|
||
`change_money` decimal(10,2) NOT NULL COMMENT '变化的金额',
|
||
`money` decimal(10,2) unsigned NOT NULL COMMENT '变化后的金额',
|
||
`type` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '1后台充值 2抽赏消费 3升级获得 4抽赏奖励',
|
||
`content` varchar(255) NOT NULL COMMENT '描述',
|
||
`addtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`share_uid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '来源ID',
|
||
`other` varchar(255) DEFAULT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `id` (`id`) USING BTREE,
|
||
KEY `user_id` (`user_id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='财务明细';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `quan_yi_level`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `quan_yi_level`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `quan_yi_level` (
|
||
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
|
||
`level` int(11) NOT NULL,
|
||
`title` varchar(255) NOT NULL,
|
||
`number` int(11) NOT NULL COMMENT '需要多少欧气值',
|
||
`addtime` int(11) NOT NULL,
|
||
`updatetime` int(11) NOT NULL,
|
||
`deltime` int(11) DEFAULT NULL,
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=utf8mb4 COMMENT='权益等级表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `quan_yi_level_jiang`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `quan_yi_level_jiang`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `quan_yi_level_jiang` (
|
||
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
|
||
`qy_level_id` int(11) NOT NULL,
|
||
`qy_level` int(11) DEFAULT NULL,
|
||
`type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1普通降临(优惠券) 2高级奖励(奖品)',
|
||
`title` varchar(255) NOT NULL,
|
||
`jian_price` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '减多少',
|
||
`coupon_id` int(11) unsigned DEFAULT '0',
|
||
`man_price` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '满多少',
|
||
`probability` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '概率',
|
||
`effective_day` int(11) DEFAULT NULL COMMENT '有效时间(天)',
|
||
`z_num` int(11) unsigned DEFAULT '0' COMMENT '优惠券赠送多少',
|
||
`imgurl` varchar(255) DEFAULT NULL COMMENT '奖品图片',
|
||
`shang_id` int(11) DEFAULT NULL,
|
||
`jiang_price` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '奖品价值',
|
||
`money` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '奖品兑换价',
|
||
`sc_money` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '市场参考价',
|
||
`prize_code` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '奖品编号',
|
||
`addtime` int(11) NOT NULL,
|
||
`updatetime` int(11) NOT NULL,
|
||
`deltime` int(11) DEFAULT NULL,
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=226 DEFAULT CHARSET=utf8mb4 COMMENT='权益中心等级奖品';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `rank_month`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `rank_month`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `rank_month` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
|
||
`rank` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '排名',
|
||
`money` decimal(10,2) unsigned NOT NULL COMMENT '消费金额',
|
||
`month_time` varchar(100) COLLATE utf8_unicode_ci NOT NULL COMMENT '统计范围',
|
||
`addtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`order_list_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '奖品ID',
|
||
`prize_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
|
||
`prize_imgurl` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `user_id` (`user_id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='排行榜月榜';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `rank_week`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `rank_week`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `rank_week` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
|
||
`rank` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '排名',
|
||
`money` decimal(10,2) unsigned NOT NULL COMMENT '消费金额',
|
||
`week_time` varchar(100) COLLATE utf8_unicode_ci NOT NULL COMMENT '统计范围',
|
||
`addtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`order_list_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '奖品ID',
|
||
`prize_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
|
||
`prize_imgurl` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `user_id` (`user_id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='排行榜周榜';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `reward`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `reward`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `reward` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`reward_type` int(11) NOT NULL COMMENT '奖励类型(1:钻石,2:货币1,3:货币2,4:优惠券)',
|
||
`reward_extend` int(11) DEFAULT NULL COMMENT '奖励ID(当reward_type=1时为优惠券ID)',
|
||
`reward_value` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '奖励值',
|
||
`description` varchar(255) DEFAULT NULL COMMENT '奖励描述',
|
||
`create_time` int(11) DEFAULT NULL,
|
||
`update_time` int(11) DEFAULT NULL,
|
||
`reward_id` varchar(64) NOT NULL COMMENT '关联表id',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=152 DEFAULT CHARSET=utf8mb4 COMMENT='奖励表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `shang`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `shang`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `shang` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
`title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
|
||
`pro` decimal(10,2) unsigned NOT NULL,
|
||
`imgurl` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
|
||
`color` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
|
||
`goods_id` int(11) unsigned NOT NULL DEFAULT '0',
|
||
`special_imgurl` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`sort` int(11) unsigned NOT NULL DEFAULT '0',
|
||
`update_time` int(11) unsigned DEFAULT '0',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=116 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `sign_config`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `sign_config`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `sign_config` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`type` tinyint(1) NOT NULL COMMENT '配置类型(1:累计签到配置,2:每日签到配置)',
|
||
`day` tinyint(1) DEFAULT NULL COMMENT '指定星期几(type=2时有效，1-7代表周一到周日)',
|
||
`title` varchar(100) DEFAULT NULL COMMENT '配置标题',
|
||
`icon` varchar(255) DEFAULT NULL COMMENT '图标',
|
||
`status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态(0禁用,1启用)',
|
||
`sort` int(11) DEFAULT '0' COMMENT '排序',
|
||
`create_time` int(11) DEFAULT NULL,
|
||
`update_time` int(11) DEFAULT NULL,
|
||
`reward_id` varchar(64) NOT NULL COMMENT '奖励id',
|
||
`description` varchar(255) DEFAULT NULL COMMENT '备注',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COMMENT='签到配置表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `task_list`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `task_list`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `task_list` (
|
||
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
|
||
`title` varchar(255) NOT NULL COMMENT '任务名称',
|
||
`type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1每日任务 2每周任务',
|
||
`cate` tinyint(1) NOT NULL DEFAULT '0' COMMENT '任务分类 1邀请好友注册 2抽赏任务 ',
|
||
`is_important` tinyint(1) DEFAULT '0' COMMENT '是否是重要任务 1是 0否',
|
||
`number` int(11) DEFAULT '0' COMMENT '需要完成任务几次',
|
||
`z_number` int(11) unsigned DEFAULT '0' COMMENT '赠送多少欧气值',
|
||
`sort` int(11) unsigned DEFAULT '0' COMMENT '排序',
|
||
`addtime` int(11) NOT NULL,
|
||
`updatetime` int(11) NOT NULL,
|
||
`deltime` int(11) DEFAULT NULL,
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COMMENT='任务表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `user`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `user`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `user` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
`openid` varchar(50) NOT NULL DEFAULT '' COMMENT '微信openid',
|
||
`mobile` varchar(11) DEFAULT NULL COMMENT '手机号',
|
||
`nickname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '昵称',
|
||
`headimg` varchar(255) NOT NULL COMMENT '头像',
|
||
`pid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '父级id',
|
||
`money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '余额',
|
||
`money2` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '集市余额',
|
||
`integral` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '幸运币',
|
||
`score` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '积分',
|
||
`ou_qi` int(11) unsigned DEFAULT '0' COMMENT '欧气值',
|
||
`ou_qi_level` int(11) unsigned DEFAULT '0' COMMENT '欧气值等级',
|
||
`vip` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT 'vip等级',
|
||
`share_image` varchar(255) DEFAULT NULL COMMENT '分享海报',
|
||
`status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态：1正常，2禁用',
|
||
`addtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
|
||
`last_login_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '最后操作时间',
|
||
`draw_num` int(11) DEFAULT '0' COMMENT '优惠券的数量',
|
||
`is_use_coupon` tinyint(3) DEFAULT '0' COMMENT '0未领取1已领取',
|
||
`mb_number` int(11) unsigned DEFAULT '0' COMMENT '连击赏秘宝池抽奖次数',
|
||
`click_id` int(11) DEFAULT '0',
|
||
`unionid` varchar(255) DEFAULT NULL COMMENT '用户唯一id',
|
||
`gzh_openid` varchar(255) DEFAULT NULL COMMENT '公众号openid',
|
||
`password` varchar(40) DEFAULT NULL,
|
||
`istest` int(11) NOT NULL DEFAULT '0' COMMENT '是否测试账号',
|
||
`uid` varchar(16) NOT NULL COMMENT '唯一编号',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `id` (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=21547 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `user_account`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `user_account`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `user_account` (
|
||
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(11) unsigned NOT NULL DEFAULT '0',
|
||
`account_token` varchar(255) NOT NULL COMMENT '登陆秘钥',
|
||
`token_num` varchar(50) NOT NULL COMMENT '秘钥随机数',
|
||
`token_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '秘钥时间戳',
|
||
`last_login_time` int(11) unsigned NOT NULL DEFAULT '0',
|
||
`last_login_ip` varchar(50) NOT NULL,
|
||
`last_login_ip1` varchar(255) DEFAULT NULL COMMENT 'ip',
|
||
`ip_adcode` varchar(255) DEFAULT NULL COMMENT 'ip邮编',
|
||
`ip_province` varchar(50) DEFAULT NULL,
|
||
`ip_city` varchar(50) DEFAULT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `id` (`id`) USING BTREE
|
||
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `user_coupon`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `user_coupon`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `user_coupon` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户的id',
|
||
`level` int(11) unsigned DEFAULT '0' COMMENT '1特级赏券 2终极赏券 3高级赏券 4普通赏券',
|
||
`num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '开奖总金额',
|
||
`l_num` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '领取多少',
|
||
`status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '1未分享 2已分享 3已领取 4被消耗融合',
|
||
`type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '1下单赠送 2领取 3融合得到',
|
||
`title` varchar(255) NOT NULL COMMENT '劵名称',
|
||
`from_id` varchar(50) NOT NULL DEFAULT '0' COMMENT '来源id （订单、领取）',
|
||
`share_time` int(11) DEFAULT NULL COMMENT '分享时间',
|
||
`addtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '获取时间',
|
||
`updatetime` int(11) DEFAULT NULL,
|
||
`own` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '自己可以获得多少',
|
||
`own2` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '自己可以获得多少',
|
||
`other` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '其他人可以获得多少',
|
||
`other2` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '其他人可以获得多少',
|
||
`kl_num` int(11) unsigned DEFAULT '0' COMMENT '最多可参与人数',
|
||
`kl_num2` int(11) unsigned DEFAULT '0' COMMENT '最多可参与人数',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `id` (`id`) USING BTREE,
|
||
KEY `user_id` (`user_id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='欧气劵';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `user_goods_lian_ji`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `user_goods_lian_ji`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `user_goods_lian_ji` (
|
||
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(11) NOT NULL,
|
||
`goods_id` int(11) NOT NULL,
|
||
`number` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '连击次数',
|
||
`addtime` int(11) NOT NULL,
|
||
`updatetime` int(11) NOT NULL,
|
||
`deltime` int(11) DEFAULT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='用户连击赏连击次数';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `user_item_card`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `user_item_card`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `user_item_card` (
|
||
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(11) NOT NULL,
|
||
`type` tinyint(1) unsigned DEFAULT '0' COMMENT '类型',
|
||
`item_card_id` int(11) NOT NULL,
|
||
`title` varchar(255) NOT NULL COMMENT '名称',
|
||
`status` tinyint(1) DEFAULT '0' COMMENT '1未使用 2已使用',
|
||
`order_id` int(11) DEFAULT '0' COMMENT '抵扣的订单ID',
|
||
`addtime` int(11) unsigned NOT NULL,
|
||
`updatetime` int(11) NOT NULL,
|
||
`deltime` int(11) DEFAULT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `id` (`id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户的道具卡';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `user_login_ip`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `user_login_ip`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `user_login_ip` (
|
||
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(11) unsigned NOT NULL DEFAULT '0',
|
||
`last_login_time` int(11) unsigned NOT NULL DEFAULT '0',
|
||
`last_login_ip` varchar(50) NOT NULL,
|
||
`last_login_ip1` varchar(255) DEFAULT NULL COMMENT 'ip',
|
||
`ip_adcode` varchar(255) DEFAULT NULL COMMENT 'ip邮编',
|
||
`ip_province` varchar(50) DEFAULT NULL,
|
||
`ip_city` varchar(50) DEFAULT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `id` (`id`) USING BTREE
|
||
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `user_login_log`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `user_login_log`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `user_login_log` (
|
||
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
|
||
`login_date` date NOT NULL COMMENT '登录日期',
|
||
`login_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '登录时间戳',
|
||
`device` varchar(50) DEFAULT '' COMMENT '登录设备',
|
||
`ip` varchar(50) DEFAULT '' COMMENT '登录IP',
|
||
`location` varchar(100) DEFAULT '' COMMENT '登录地点',
|
||
`year` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '年份',
|
||
`month` int(2) unsigned NOT NULL DEFAULT '0' COMMENT '月份',
|
||
`week` int(2) unsigned NOT NULL DEFAULT '0' COMMENT '周数',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `idx_user_date` (`user_id`,`login_date`) USING BTREE,
|
||
KEY `idx_date` (`login_date`) USING BTREE,
|
||
KEY `idx_year_month` (`year`,`month`) USING BTREE,
|
||
KEY `idx_year_week` (`year`,`week`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='用户登录记录表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `user_quan_yi_level_jiang`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `user_quan_yi_level_jiang`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `user_quan_yi_level_jiang` (
|
||
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(11) DEFAULT NULL,
|
||
`qy_level_id` int(11) NOT NULL,
|
||
`qy_level` int(11) DEFAULT '0',
|
||
`coupon_id` int(11) unsigned DEFAULT '0',
|
||
`type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1普通降临(优惠券) 2高级奖励(奖品)',
|
||
`title` varchar(255) NOT NULL,
|
||
`jian_price` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '减多少',
|
||
`man_price` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '满多少',
|
||
`effective_day` int(11) DEFAULT NULL COMMENT '有效时间(天)',
|
||
`end_time` int(11) DEFAULT NULL,
|
||
`z_num` int(11) unsigned DEFAULT '0' COMMENT '优惠券赠送多少',
|
||
`imgurl` varchar(255) DEFAULT NULL COMMENT '奖品图片',
|
||
`shang_id` int(11) DEFAULT NULL,
|
||
`jiang_price` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '奖品价值',
|
||
`money` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '奖品兑换价',
|
||
`sc_money` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '市场参考价',
|
||
`prize_code` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '奖品编号',
|
||
`probability` decimal(10,2) unsigned DEFAULT NULL COMMENT '概率',
|
||
`addtime` int(11) NOT NULL,
|
||
`updatetime` int(11) NOT NULL,
|
||
`deltime` int(11) DEFAULT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='用户领取的权益中心等级奖品';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `user_rage`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `user_rage`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `user_rage` (
|
||
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(11) NOT NULL,
|
||
`goods_id` int(11) NOT NULL,
|
||
`rage` int(11) NOT NULL DEFAULT '0' COMMENT '怒气值',
|
||
`addtime` int(11) NOT NULL,
|
||
`updatetime` int(11) NOT NULL,
|
||
`deltime` int(11) DEFAULT NULL,
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户的怒气值';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `user_recharge`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `user_recharge`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `user_recharge` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
|
||
`order_num` varchar(100) COLLATE utf8_unicode_ci NOT NULL COMMENT '订单号',
|
||
`money` decimal(10,2) unsigned NOT NULL COMMENT '充值金额',
|
||
`status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '1待支付 2已完成',
|
||
`addtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建订单时间',
|
||
`pay_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '支付时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `order_num` (`order_num`) USING BTREE,
|
||
KEY `user_id` (`user_id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='用户充值表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `user_sign`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `user_sign`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `user_sign` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
||
`user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
|
||
`sign_date` varchar(24) NOT NULL DEFAULT '' COMMENT '签到日期',
|
||
`sign_day` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '签到当月天数',
|
||
`days` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '连续签到天数',
|
||
`month` int(11) DEFAULT NULL COMMENT '签到月份',
|
||
`year` int(11) DEFAULT NULL COMMENT '签到年份',
|
||
`num` int(128) NOT NULL DEFAULT '0' COMMENT '签到数量',
|
||
`create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '签到时间',
|
||
`update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`sign_type` tinyint(2) NOT NULL DEFAULT '0' COMMENT '月签到还是累计签到',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户签到表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `user_statistics`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `user_statistics`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `user_statistics` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`login_count` int(11) DEFAULT '0' COMMENT '登录人数',
|
||
`register_count` int(11) DEFAULT '0' COMMENT '注册人数',
|
||
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
|
||
`record_date` date NOT NULL COMMENT '记录日期',
|
||
`recharge_amount` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '充值金额',
|
||
`consume_user_count` int(11) NOT NULL DEFAULT '0' COMMENT '记录当天消费的用户人数（去重）',
|
||
`balance_consume` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '记录当天用户使用余额消费的总金额（单位：元）。',
|
||
`balance_issue` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '记录当天系统发放给用户的余额总金额',
|
||
`consume_order_count` int(11) NOT NULL DEFAULT '0' COMMENT '支付的订单笔数',
|
||
`consume_rmb_count` int(11) NOT NULL DEFAULT '0' COMMENT '消费rmb人数',
|
||
`recharge_sum` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '今日总收入',
|
||
`shipment_money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '出货价值',
|
||
`send_money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '发货价值',
|
||
`recycle_money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '回收价值',
|
||
`profit_money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '利润率',
|
||
`all_shipment_money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '总支出',
|
||
`all_recycle_money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '总收入',
|
||
`all_money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '总利润',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='用户统计表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `user_task_list`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `user_task_list`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `user_task_list` (
|
||
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(11) NOT NULL,
|
||
`task_list_id` int(11) NOT NULL,
|
||
`type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1每日任务 2每周任务',
|
||
`cate` tinyint(1) NOT NULL DEFAULT '0' COMMENT '任务分类 1邀请好友注册 2抽赏任务 ',
|
||
`is_important` tinyint(1) DEFAULT '0' COMMENT '是否是重要任务 1是 0否',
|
||
`number` int(11) DEFAULT '0' COMMENT '需要完成任务几次',
|
||
`z_number` int(11) unsigned DEFAULT '0' COMMENT '赠送多少欧气值',
|
||
`addtime` int(11) NOT NULL,
|
||
`updatetime` int(11) NOT NULL,
|
||
`deltime` int(11) DEFAULT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='用户完成任务记录表';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `user_vip`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `user_vip`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `user_vip` (
|
||
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
|
||
`title` varchar(50) NOT NULL DEFAULT '0' COMMENT '等级名称',
|
||
`imgurl` varchar(200) NOT NULL COMMENT '图标',
|
||
`condition` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '升级消费',
|
||
`discount` decimal(10,2) unsigned NOT NULL COMMENT '享受折扣',
|
||
`notice` varchar(255) NOT NULL COMMENT '权益说明',
|
||
`update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='会员vip';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `welfare_house`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `welfare_house`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `welfare_house` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`name` varchar(100) NOT NULL COMMENT '名称',
|
||
`image` varchar(255) NOT NULL COMMENT '图片路径',
|
||
`url` varchar(255) NOT NULL COMMENT '跳转路径',
|
||
`sort` int(11) DEFAULT '0' COMMENT '排序（数字越小越靠前）',
|
||
`status` tinyint(1) DEFAULT '1' COMMENT '状态：0=禁用，1=启用',
|
||
`create_time` int(11) DEFAULT NULL COMMENT '创建时间',
|
||
`update_time` int(11) DEFAULT NULL COMMENT '更新时间',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COMMENT='福利屋管理';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `withdraw`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `withdraw`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `withdraw` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(10) unsigned DEFAULT NULL COMMENT '提现人',
|
||
`status` tinyint(2) unsigned DEFAULT '0' COMMENT '提现:1=未审核,2=已通过3=未通过',
|
||
`addtime` int(11) unsigned DEFAULT NULL COMMENT '提现时间',
|
||
`end_time` int(10) unsigned DEFAULT NULL COMMENT '审核时间',
|
||
`reason` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '原因',
|
||
`tal_money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '提现金额',
|
||
`money` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '到账金额',
|
||
`sxf` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '手续费',
|
||
`type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '提现方式:1=微信,2=银行卡 3支付宝',
|
||
`imgurl` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '收款二维码',
|
||
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '提现姓名/银行户名',
|
||
`number` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '支付宝账号/银行卡号',
|
||
`bank` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '开户行',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `wxpay_log`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `wxpay_log`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `wxpay_log` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
|
||
`order_no` varchar(100) DEFAULT NULL COMMENT '订单号',
|
||
`content` text COMMENT '说明',
|
||
`type` tinyint(1) unsigned DEFAULT '1',
|
||
`channel` int(1) NOT NULL DEFAULT '1' COMMENT '1微信 2支付宝 ',
|
||
`addtime` int(14) unsigned DEFAULT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `order_no` (`order_no`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='微信/支付宝支付信息';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Table structure for table `yushou`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `yushou`;
|
||
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
/*!40101 SET character_set_client = utf8 */;
|
||
CREATE TABLE `yushou` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
`title` varchar(255) NOT NULL COMMENT '标题',
|
||
`imgurl` varchar(255) NOT NULL COMMENT '图片',
|
||
`goods_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '商品id',
|
||
`sale_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '预售日期',
|
||
`sort` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
|
||
`addtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`update_time` int(11) NOT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `id` (`id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='预售日历';
|
||
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
||
--
|
||
-- Dumping routines for database 'youda_test'
|
||
--
|
||
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
|
||
|
||
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
|
||
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
|
||
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
|
||
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
||
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
||
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||
|
||
-- Dump completed on 2025-04-10 22:23:48
|