text: -- MySQL dump 10.13  Distrib 5.7.17, for Win64 (x86_64)
  --
  -- Host: 127.0.0.1    Database: litemall
  -- ------------------------------------------------------
  -- Server version	5.7.21-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 `litemall_ad`
  --
  
  DROP TABLE IF EXISTS `litemall_ad`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `litemall_ad` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(63) NOT NULL DEFAULT '' COMMENT '广告标题',
    `link` varchar(255) NOT NULL DEFAULT '' COMMENT '所广告的商品页面或者活动页面链接地址',
    `url` varchar(255) NOT NULL COMMENT '广告宣传图片',
    `position` tinyint(3) DEFAULT '1' COMMENT '广告位置：1则是首页',
    `content` varchar(255) DEFAULT '' COMMENT '活动内容',
    `start_time` datetime DEFAULT NULL COMMENT '广告开始时间',
    `end_time` datetime DEFAULT NULL COMMENT '广告结束时间',
    `enabled` tinyint(1) DEFAULT '0' COMMENT '是否启动',
    `add_time` datetime DEFAULT NULL COMMENT '创建时间',
    `deleted` tinyint(1) DEFAULT '0' COMMENT '逻辑删除',
    `version` int(11) DEFAULT '0' COMMENT '乐观锁字段',
    PRIMARY KEY (`id`),
    KEY `enabled` (`enabled`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='广告表';
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `litemall_address`
  --
  
  DROP TABLE IF EXISTS `litemall_address`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `litemall_address` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(63) NOT NULL DEFAULT '' COMMENT '收货人名称',
    `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '用户表的用户ID',
    `province_id` int(11) NOT NULL DEFAULT '0' COMMENT '行政区域表的省ID',
    `city_id` int(11) NOT NULL DEFAULT '0' COMMENT '行政区域表的市ID',
    `area_id` int(11) NOT NULL DEFAULT '0' COMMENT '行政区域表的区县ID',
    `address` varchar(127) NOT NULL DEFAULT '' COMMENT '具体收货地址',
    `mobile` varchar(20) NOT NULL DEFAULT '' COMMENT '手机号码',
    `is_default` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否默认地址',
    `add_time` datetime DEFAULT NULL COMMENT '创建时间',
    `deleted` tinyint(1) DEFAULT '0' COMMENT '逻辑删除',
    `version` int(11) DEFAULT '0' COMMENT '乐观锁字段',
    PRIMARY KEY (`id`),
    KEY `user_id` (`user_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='收货地址表';
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `litemall_admin`
  --
  
  DROP TABLE IF EXISTS `litemall_admin`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `litemall_admin` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `username` varchar(63) NOT NULL DEFAULT '' COMMENT '管理员名称',
    `password` varchar(63) NOT NULL DEFAULT '' COMMENT '管理员密码',
    `last_login_ip` varchar(63) DEFAULT '' COMMENT '最近一次登录IP地址',
    `last_login_time` datetime DEFAULT NULL COMMENT '最近一次登录时间',
    `avatar` varchar(255) DEFAULT '''' COMMENT '头像图片',
    `add_time` datetime DEFAULT NULL COMMENT '创建时间',
    `deleted` tinyint(1) DEFAULT '0' COMMENT '逻辑删除',
    `version` int(11) DEFAULT '0' COMMENT '乐观锁字段',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='管理员表';
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `litemall_brand`
  --
  
  DROP TABLE IF EXISTS `litemall_brand`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `litemall_brand` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) NOT NULL DEFAULT '' COMMENT '品牌商名称',
    `desc` varchar(255) NOT NULL DEFAULT '' COMMENT '品牌商简介',
    `pic_url` varchar(255) NOT NULL DEFAULT '' COMMENT '品牌商页的品牌商图片',
    `sort_order` tinyint(3) DEFAULT '50',
    `floor_price` decimal(10,2) DEFAULT '0.00' COMMENT '品牌商的商品低价，仅用于页面展示',
    `add_time` datetime DEFAULT NULL COMMENT '创建时间',
    `deleted` tinyint(1) DEFAULT '0' COMMENT '逻辑删除',
    `version` int(11) DEFAULT '0' COMMENT '乐观锁字段',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=1046001 DEFAULT CHARSET=utf8mb4 COMMENT='品牌商表';
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `litemall_cart`
  --
  
  DROP TABLE IF EXISTS `litemall_cart`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `litemall_cart` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `user_id` int(11) DEFAULT NULL COMMENT '用户表的用户ID',
    `goods_id` int(11) DEFAULT NULL COMMENT '商品表的商品ID',
    `goods_sn` varchar(63) DEFAULT NULL COMMENT '商品编号',
    `goods_name` varchar(127) DEFAULT NULL COMMENT '商品名称',
    `product_id` int(11) DEFAULT NULL COMMENT '商品货品表的货品ID',
    `price` decimal(10,2) DEFAULT '0.00' COMMENT '商品货品的价格',
    `number` smallint(5) DEFAULT '0' COMMENT '商品货品的数量',
    `specifications` varchar(1023) DEFAULT NULL COMMENT '商品规格值列表，采用JSON数组格式',
    `checked` tinyint(1) DEFAULT '1' COMMENT '购物车中商品是否选择状态',
    `pic_url` varchar(255) DEFAULT NULL COMMENT '商品图片或者商品货品图片',
    `add_time` datetime DEFAULT NULL COMMENT '创建时间',
    `deleted` tinyint(1) DEFAULT '0' COMMENT '逻辑删除',
    `version` int(11) DEFAULT '0' COMMENT '乐观锁字段',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='购物车商品表';
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `litemall_category`
  --
  
  DROP TABLE IF EXISTS `litemall_category`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `litemall_category` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(63) NOT NULL DEFAULT '' COMMENT '类目名称',
    `keywords` varchar(1023) NOT NULL DEFAULT '' COMMENT '类目关键字，以JSON数组格式',
    `desc` varchar(255) DEFAULT '' COMMENT '类目广告语介绍',
    `pid` int(11) NOT NULL DEFAULT '0' COMMENT '父类目ID',
    `icon_url` varchar(255) DEFAULT '' COMMENT '类目图标',
    `pic_url` varchar(255) DEFAULT '' COMMENT '类目图片',
    `level` varchar(255) DEFAULT 'L1',
    `sort_order` tinyint(3) DEFAULT '50' COMMENT '排序',
    `add_time` datetime DEFAULT NULL COMMENT '创建时间',
    `deleted` tinyint(1) DEFAULT '0' COMMENT '逻辑删除',
    `version` int(11) DEFAULT '0' COMMENT '乐观锁字段',
    PRIMARY KEY (`id`),
    KEY `parent_id` (`pid`)
  ) ENGINE=InnoDB AUTO_INCREMENT=1036005 DEFAULT CHARSET=utf8mb4 COMMENT='类目表';
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `litemall_collect`
  --
  
  DROP TABLE IF EXISTS `litemall_collect`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `litemall_collect` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '用户表的用户ID',
    `value_id` int(11) NOT NULL DEFAULT '0' COMMENT '如果type=0，则是商品ID；如果type=1，则是专题ID',
    `type` tinyint(3) NOT NULL DEFAULT '0' COMMENT '收藏类型，如果type=0，则是商品ID；如果type=1，则是专题ID',
    `add_time` datetime DEFAULT NULL COMMENT '创建时间',
    `deleted` tinyint(1) DEFAULT '0' COMMENT '逻辑删除',
    `version` int(11) DEFAULT '0' COMMENT '乐观锁字段',
    PRIMARY KEY (`id`),
    KEY `user_id` (`user_id`),
    KEY `goods_id` (`value_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='收藏表';
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `litemall_comment`
  --
  
  DROP TABLE IF EXISTS `litemall_comment`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `litemall_comment` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `value_id` int(11) NOT NULL DEFAULT '0' COMMENT '如果type=0，则是商品评论；如果是type=1，则是专题评论。',
    `type` tinyint(3) NOT NULL DEFAULT '0' COMMENT '评论类型，如果type=0，则是商品评论；如果是type=1，则是专题评论。',
    `content` varchar(1023) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '评论内容',
    `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '用户表的用户ID',
    `has_picture` tinyint(1) DEFAULT '0' COMMENT '是否含有图片',
    `pic_urls` varchar(1023) DEFAULT NULL COMMENT '图片地址列表，采用JSON数组格式',
    `star` smallint(6) DEFAULT '1' COMMENT '评分， 1-5',
    `add_time` datetime DEFAULT NULL COMMENT '创建时间',
    `deleted` tinyint(1) DEFAULT '0' COMMENT '逻辑删除',
    `version` int(11) DEFAULT '0' COMMENT '乐观锁字段',
    PRIMARY KEY (`id`),
    KEY `id_value` (`value_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=1002 DEFAULT CHARSET=utf8 COMMENT='评论表';
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `litemall_footprint`
  --
  
  DROP TABLE IF EXISTS `litemall_footprint`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `litemall_footprint` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '用户表的用户ID',
    `goods_id` int(11) NOT NULL DEFAULT '0' COMMENT '浏览商品ID',
    `add_time` datetime DEFAULT NULL COMMENT '创建时间',
    `deleted` tinyint(1) DEFAULT '0' COMMENT '逻辑删除',
    `version` int(11) DEFAULT '0' COMMENT '乐观锁字段',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户浏览足迹表';
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `litemall_goods`
  --
  
  DROP TABLE IF EXISTS `litemall_goods`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `litemall_goods` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `goods_sn` varchar(63) NOT NULL DEFAULT '' COMMENT '商品编号',
    `name` varchar(127) NOT NULL DEFAULT '' COMMENT '商品名称',
    `category_id` int(11) DEFAULT '0' COMMENT '商品所属类目ID',
    `brand_id` int(11) DEFAULT '0',
    `gallery` varchar(1023) DEFAULT NULL COMMENT '商品宣传图片列表，采用JSON数组格式',
    `keywords` varchar(255) DEFAULT '' COMMENT '商品关键字，采用逗号间隔',
    `brief` varchar(255) DEFAULT '' COMMENT '商品简介',
    `is_on_sale` tinyint(1) DEFAULT '1' COMMENT '是否上架',
    `sort_order` smallint(4) DEFAULT '100',
    `pic_url` varchar(255) DEFAULT NULL COMMENT '商品页面商品图片',
    `is_new` tinyint(1) DEFAULT '0' COMMENT '是否新品首发，如果设置则可以在新品首发页面展示',
    `is_hot` tinyint(1) DEFAULT '0' COMMENT '是否人气推荐，如果设置则可以在人气推荐页面展示',
    `unit` varchar(31) DEFAULT '’件‘' COMMENT '商品单位，例如件、盒',
    `counter_price` decimal(10,2) DEFAULT '0.00' COMMENT '专柜价格',
    `retail_price` decimal(10,2) DEFAULT '100000.00' COMMENT '零售价格',
    `detail` text COMMENT '商品详细介绍，是富文本格式',
    `add_time` datetime DEFAULT NULL COMMENT '创建时间',
    `deleted` tinyint(1) DEFAULT '0' COMMENT '逻辑删除',
    `version` int(11) DEFAULT '0' COMMENT '乐观锁字段',
    PRIMARY KEY (`id`),
    KEY `goods_sn` (`goods_sn`),
    KEY `cat_id` (`category_id`),
    KEY `brand_id` (`brand_id`),
    KEY `sort_order` (`sort_order`)
  ) ENGINE=InnoDB AUTO_INCREMENT=1181003 DEFAULT CHARSET=utf8mb4 COMMENT='商品基本信息表';
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `litemall_goods_attribute`
  --
  
  DROP TABLE IF EXISTS `litemall_goods_attribute`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `litemall_goods_attribute` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `goods_id` int(11) NOT NULL DEFAULT '0' COMMENT '商品表的商品ID',
    `attribute` varchar(255) NOT NULL COMMENT '商品参数名称',
    `value` varchar(255) NOT NULL COMMENT '商品参数值',
    `add_time` datetime DEFAULT NULL COMMENT '创建时间',
    `deleted` tinyint(1) DEFAULT '0' COMMENT '逻辑删除',
    `version` int(11) DEFAULT '0' COMMENT '乐观锁字段',
    PRIMARY KEY (`id`),
    KEY `goods_id` (`goods_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=874 DEFAULT CHARSET=utf8mb4 COMMENT='商品参数表';
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `litemall_goods_specification`
  --
  
  DROP TABLE IF EXISTS `litemall_goods_specification`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `litemall_goods_specification` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `goods_id` int(11) NOT NULL DEFAULT '0' COMMENT '商品表的商品ID',
    `specification` varchar(255) NOT NULL DEFAULT '' COMMENT '商品规格名称',
    `value` varchar(255) NOT NULL DEFAULT '' COMMENT '商品规格值',
    `pic_url` varchar(255) NOT NULL DEFAULT '' COMMENT '商品规格图片',
    `add_time` datetime DEFAULT NULL COMMENT '创建时间',
    `deleted` tinyint(1) DEFAULT '0' COMMENT '逻辑删除',
    `version` int(11) DEFAULT '0' COMMENT '乐观锁字段',
    PRIMARY KEY (`id`),
    KEY `goods_id` (`goods_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=260 DEFAULT CHARSET=utf8mb4 COMMENT='商品规格表';
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `litemall_issue`
  --
  
  DROP TABLE IF EXISTS `litemall_issue`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `litemall_issue` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `question` varchar(255) DEFAULT NULL COMMENT '问题标题',
    `answer` varchar(255) DEFAULT NULL COMMENT '问题答案',
    `add_time` datetime DEFAULT NULL COMMENT '创建时间',
    `deleted` tinyint(1) DEFAULT '0' COMMENT '逻辑删除',
    `version` int(11) DEFAULT '0' COMMENT '乐观锁字段',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COMMENT='常见问题表';
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `litemall_keyword`
  --
  
  DROP TABLE IF EXISTS `litemall_keyword`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `litemall_keyword` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `keyword` varchar(127) NOT NULL DEFAULT '' COMMENT '关键字',
    `url` varchar(255) NOT NULL DEFAULT '' COMMENT '关键字的跳转链接',
    `is_hot` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否是热门关键字',
    `is_default` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否是默认关键字',
    `sort_order` int(11) NOT NULL DEFAULT '100' COMMENT '排序',
    `add_time` datetime DEFAULT NULL COMMENT '创建时间',
    `deleted` tinyint(1) DEFAULT '0' COMMENT '逻辑删除',
    `version` int(11) DEFAULT '0' COMMENT '乐观锁字段',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COMMENT='关键字表';
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `litemall_order`
  --
  
  DROP TABLE IF EXISTS `litemall_order`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `litemall_order` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `user_id` int(11) NOT NULL COMMENT '用户表的用户ID',
    `order_sn` varchar(63) NOT NULL COMMENT '订单编号',
    `order_status` smallint(6) NOT NULL COMMENT '订单状态',
    `consignee` varchar(63) NOT NULL COMMENT '收货人名称',
    `mobile` varchar(63) NOT NULL COMMENT '收货人手机号',
    `address` varchar(127) NOT NULL COMMENT '收货具体地址',
    `goods_price` decimal(10,2) NOT NULL COMMENT '商品总费用',
    `freight_price` decimal(10,2) NOT NULL COMMENT '配送费用',
    `coupon_price` decimal(10,2) NOT NULL COMMENT '优惠券减免',
    `integral_price` decimal(10,2) NOT NULL COMMENT '用户积分减免',
    `order_price` decimal(10,2) NOT NULL COMMENT '订单费用， = goods_price + freight_price - coupon_price',
    `actual_price` decimal(10,2) NOT NULL COMMENT '实付费用， = order_price - integral_price',
    `pay_id` varchar(63) DEFAULT NULL COMMENT '微信付款编号',
    `pay_time` datetime DEFAULT NULL COMMENT '微信付款时间',
    `ship_sn` varchar(63) DEFAULT NULL COMMENT '发货编号',
    `ship_channel` varchar(63) DEFAULT NULL COMMENT '发货快递公司',
    `ship_time` datetime DEFAULT NULL COMMENT '发货开始时间',
    `confirm_time` datetime DEFAULT NULL COMMENT '用户确认收货时间',
    `end_time` datetime DEFAULT NULL COMMENT '订单关闭时间',
    `add_time` datetime DEFAULT NULL COMMENT '创建时间',
    `deleted` tinyint(1) DEFAULT '0' COMMENT '逻辑删除',
    `version` int(11) DEFAULT '0' COMMENT '乐观锁字段',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单表';
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `litemall_order_goods`
  --
  
  DROP TABLE IF EXISTS `litemall_order_goods`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `litemall_order_goods` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `order_id` int(11) NOT NULL DEFAULT '0' COMMENT '订单表的订单ID',
    `goods_id` int(11) NOT NULL DEFAULT '0' COMMENT '商品表的商品ID',
    `goods_name` varchar(127) NOT NULL DEFAULT '' COMMENT '商品名称',
    `goods_sn` varchar(63) NOT NULL DEFAULT '' COMMENT '商品编号',
    `product_id` int(11) NOT NULL DEFAULT '0' COMMENT '商品货品表的货品ID',
    `number` smallint(5) NOT NULL DEFAULT '0' COMMENT '商品货品的购买数量',
    `price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '商品货品的售价',
    `specifications` varchar(1023) NOT NULL COMMENT '商品货品的规格列表',
    `pic_url` varchar(255) NOT NULL DEFAULT '' COMMENT '商品货品图片或者商品图片',
    `add_time` datetime DEFAULT NULL COMMENT '创建时间',
    `deleted` tinyint(1) DEFAULT '0' COMMENT '逻辑删除',
    `version` int(11) DEFAULT '0' COMMENT '乐观锁字段',
    PRIMARY KEY (`id`),
    KEY `order_id` (`order_id`),
    KEY `goods_id` (`goods_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='订单商品表';
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `litemall_product`
  --
  
  DROP TABLE IF EXISTS `litemall_product`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `litemall_product` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `goods_id` int(11) NOT NULL DEFAULT '0' COMMENT '商品表的商品ID',
    `specifications` varchar(1023) NOT NULL COMMENT '商品规格值列表，采用JSON数组格式',
    `price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '商品货品价格',
    `number` int(11) NOT NULL DEFAULT '0' COMMENT '商品货品数量',
    `url` varchar(125) DEFAULT NULL COMMENT '商品货品图片',
    `add_time` datetime DEFAULT NULL COMMENT '创建时间',
    `deleted` tinyint(1) DEFAULT '0' COMMENT '逻辑删除',
    `version` int(11) DEFAULT '0' COMMENT '乐观锁字段',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=259 DEFAULT CHARSET=utf8mb4 COMMENT='商品货品表';
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `litemall_region`
  --
  
  DROP TABLE IF EXISTS `litemall_region`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `litemall_region` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `pid` int(11) NOT NULL DEFAULT '0' COMMENT '行政区域父ID，例如区县的pid指向市，市的pid指向省，省的pid则是0',
    `name` varchar(120) NOT NULL DEFAULT '' COMMENT '行政区域名称',
    `type` tinyint(3) NOT NULL DEFAULT '0' COMMENT '行政区域类型，如如1则是省， 如果是2则是市，如果是3则是区县',
    `code` int(11) NOT NULL DEFAULT '0' COMMENT '行政区域编码',
    PRIMARY KEY (`id`),
    KEY `parent_id` (`pid`),
    KEY `region_type` (`type`),
    KEY `agency_id` (`code`)
  ) ENGINE=InnoDB AUTO_INCREMENT=46183 DEFAULT CHARSET=utf8mb4 COMMENT='行政区域表';
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `litemall_search_history`
  --
  
  DROP TABLE IF EXISTS `litemall_search_history`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `litemall_search_history` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `user_id` int(11) NOT NULL COMMENT '用户表的用户ID',
    `keyword` varchar(63) NOT NULL COMMENT '搜索关键字',
    `from` varchar(63) NOT NULL DEFAULT '' COMMENT '搜索来源，如pc、wx、app',
    `add_time` datetime DEFAULT NULL COMMENT '创建时间',
    `deleted` tinyint(1) DEFAULT '0' COMMENT '逻辑删除',
    `version` int(11) DEFAULT '0' COMMENT '乐观锁字段',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='搜索历史表';
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `litemall_storage`
  --
  
  DROP TABLE IF EXISTS `litemall_storage`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `litemall_storage` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `key` varchar(63) NOT NULL COMMENT '文件的唯一索引',
    `name` varchar(255) NOT NULL COMMENT '文件名',
    `type` varchar(20) NOT NULL COMMENT '文件类型',
    `size` int(11) NOT NULL COMMENT '文件大小',
    `modified` datetime DEFAULT NULL COMMENT '最后更新时间',
    `url` varchar(255) DEFAULT NULL COMMENT '文件访问链接',
    `add_time` datetime DEFAULT NULL COMMENT '创建时间',
    `deleted` tinyint(1) DEFAULT '0' COMMENT '逻辑删除',
    `version` int(11) DEFAULT '0' COMMENT '乐观锁字段',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 COMMENT='文件存储表';
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `litemall_system`
  --
  
  DROP TABLE IF EXISTS `litemall_system`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `litemall_system` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `key_name` varchar(255) NOT NULL COMMENT '系统配置名',
    `key_value` varchar(255) NOT NULL COMMENT '系统配置值',
    `deleted` tinyint(1) DEFAULT '0' COMMENT '逻辑删除',
    `version` int(11) DEFAULT '0' COMMENT '乐观锁字段',
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='系统配置表';
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `litemall_topic`
  --
  
  DROP TABLE IF EXISTS `litemall_topic`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `litemall_topic` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `title` varchar(255) NOT NULL DEFAULT '''' COMMENT '专题标题',
    `subtitle` varchar(255) DEFAULT '''' COMMENT '专题子标题',
    `content` text COMMENT '专题内容，富文本格式',
    `price` decimal(10,2) DEFAULT '0.00' COMMENT '专题相关商品最低价',
    `read_count` varchar(255) DEFAULT '1k' COMMENT '专题阅读量',
    `pic_url` varchar(255) DEFAULT '' COMMENT '专题图片',
    `sort_order` int(11) DEFAULT '100' COMMENT '排序',
    `goods` varchar(1023) DEFAULT '' COMMENT '专题相关商品，采用JSON数组格式',
    `add_time` datetime DEFAULT NULL COMMENT '创建时间',
    `deleted` tinyint(1) DEFAULT '0' COMMENT '逻辑删除',
    `version` int(11) DEFAULT '0' COMMENT '乐观锁字段',
    PRIMARY KEY (`id`),
    KEY `topic_id` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=315 DEFAULT CHARSET=utf8mb4 COMMENT='专题表';
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `litemall_user`
  --
  
  DROP TABLE IF EXISTS `litemall_user`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `litemall_user` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `username` varchar(63) NOT NULL COMMENT '用户名称',
    `password` varchar(63) NOT NULL DEFAULT '' COMMENT '用户密码',
    `gender` tinyint(3) NOT NULL DEFAULT '0' COMMENT '性别：0 未知， 1男， 1 女',
    `birthday` date DEFAULT NULL COMMENT '生日',
    `last_login_time` datetime DEFAULT NULL COMMENT '最近一次登录时间',
    `last_login_ip` varchar(63) NOT NULL DEFAULT '' COMMENT '最近一次登录IP地址',
    `user_level` tinyint(3) DEFAULT '0' COMMENT '0 普通用户，1 VIP用户，2 高级VIP用户',
    `nickname` varchar(63) NOT NULL DEFAULT '' COMMENT '用户昵称或网络名称',
    `mobile` varchar(20) NOT NULL DEFAULT '' COMMENT '用户手机号码',
    `avatar` varchar(255) NOT NULL DEFAULT '' COMMENT '用户头像图片',
    `weixin_openid` varchar(63) NOT NULL DEFAULT '' COMMENT '微信登录openid',
    `status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '0 可用, 1 禁用, 2 注销',
    `add_time` datetime DEFAULT NULL COMMENT '创建时间',
    `deleted` tinyint(1) DEFAULT '0' COMMENT '逻辑删除',
    `version` int(11) DEFAULT '0' COMMENT '乐观锁字段',
    PRIMARY KEY (`id`),
    UNIQUE KEY `user_name` (`username`)
  ) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COMMENT='用户表';
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `litemall_user_formid`
  --
  
  DROP TABLE IF EXISTS `litemall_user_formid`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `litemall_user_formid` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `formId` varchar(63) NOT NULL COMMENT '缓存的FormId',
    `isprepay` tinyint(1) NOT NULL COMMENT '是FormId还是prepayId',
    `useAmount` int(2) NOT NULL COMMENT '可用次数，fromId为1，prepay为3，用1次减1',
    `expire_time` datetime NOT NULL COMMENT '过期时间，腾讯规定为7天',
    `openId` varchar(63) NOT NULL COMMENT '微信登录openid',
    `version` int(11) DEFAULT '0' COMMENT '乐观锁字段',
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
  /*!40101 SET character_set_client = @saved_cs_client */;
  /*!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 2018-07-24 23:42:36
  