bookstore_1
/
bookstore2220221030.sql

-- MariaDB dump 10.19  Distrib 10.5.17-MariaDB, for Win64 (AMD64)
--
-- Host: localhost    Database: bookstore2
-- ------------------------------------------------------
-- Server version	10.5.17-MariaDB

/*!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 utf8mb4 */;
/*!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` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
  `username` varchar(50) DEFAULT NULL COMMENT '用户名',
  `password` char(60) DEFAULT NULL COMMENT '密码',
  `nickname` varchar(50) DEFAULT NULL COMMENT '昵称',
  `avatar` varchar(255) DEFAULT NULL COMMENT '头像url',
  `phone` varchar(50) DEFAULT NULL COMMENT '手机号码',
  `email` varchar(50) DEFAULT NULL COMMENT '电子邮箱',
  `description` varchar(255) DEFAULT NULL COMMENT '描述',
  `enable` tinyint(3) unsigned DEFAULT NULL COMMENT '是否启用',
  `last_login_ip` varchar(50) DEFAULT NULL COMMENT '最后登录IP地址',
  `login_count` int(10) unsigned DEFAULT NULL COMMENT '累计登录次数',
  `gmt_created` datetime DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT NULL COMMENT '最后修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='管理员表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `admin`
--

LOCK TABLES `admin` WRITE;
/*!40000 ALTER TABLE `admin` DISABLE KEYS */;
/*!40000 ALTER TABLE `admin` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `albun`
--

DROP TABLE IF EXISTS `albun`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `albun` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
  `name` varchar(50) DEFAULT NULL COMMENT '相册名称',
  `description` varchar(255) DEFAULT NULL COMMENT '相册介绍',
  `sort` tinyint(4) DEFAULT NULL COMMENT '自定义排序序号',
  `gmt_created` datetime DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT NULL COMMENT '最后修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='相册表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `albun`
--

LOCK TABLES `albun` WRITE;
/*!40000 ALTER TABLE `albun` DISABLE KEYS */;
/*!40000 ALTER TABLE `albun` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `banner`
--

DROP TABLE IF EXISTS `banner`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `banner` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `url` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='轮播表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `banner`
--

LOCK TABLES `banner` WRITE;
/*!40000 ALTER TABLE `banner` DISABLE KEYS */;
/*!40000 ALTER TABLE `banner` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `book_attribute`
--

DROP TABLE IF EXISTS `book_attribute`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `book_attribute` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '图书id',
  `name` varchar(50) DEFAULT NULL COMMENT '图书名称',
  `pinyin` varchar(50) DEFAULT NULL COMMENT '拼音',
  `author` varchar(50) DEFAULT NULL COMMENT '作者',
  `publisher` varchar(50) DEFAULT NULL COMMENT '出版社',
  `isbn` varchar(20) DEFAULT NULL COMMENT '国际标准书号号码',
  `gmt_create` datetime DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT NULL COMMENT '最后修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='图书属性表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `book_attribute`
--

LOCK TABLES `book_attribute` WRITE;
/*!40000 ALTER TABLE `book_attribute` DISABLE KEYS */;
/*!40000 ALTER TABLE `book_attribute` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `book_category`
--

DROP TABLE IF EXISTS `book_category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `book_category` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
  `book_id` bigint(20) DEFAULT NULL COMMENT '图书id',
  `category_id` bigint(20) DEFAULT NULL COMMENT '类别id',
  `gmt_created` datetime DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT NULL COMMENT '最后修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='图书类别关联表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `book_category`
--

LOCK TABLES `book_category` WRITE;
/*!40000 ALTER TABLE `book_category` DISABLE KEYS */;
/*!40000 ALTER TABLE `book_category` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `book_details`
--

DROP TABLE IF EXISTS `book_details`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `book_details` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '图书编号',
  `book_id` bigint(20) unsigned DEFAULT NULL COMMENT '图书id',
  `album_id` bigint(20) unsigned DEFAULT NULL COMMENT '相册id',
  `type_id` bigint(20) unsigned DEFAULT NULL COMMENT '类型id',
  `keywords` varchar(50) DEFAULT NULL COMMENT '关键词',
  `publication_date` datetime DEFAULT NULL COMMENT '出版日期',
  `description` datetime DEFAULT NULL COMMENT '简介',
  `old_price` double DEFAULT NULL COMMENT '原价',
  `price` double DEFAULT NULL COMMENT '现价',
  `number` int(11) DEFAULT NULL COMMENT '库存',
  `sales` bigint(20) DEFAULT NULL COMMENT '销量',
  `total_comment` bigint(20) DEFAULT NULL COMMENT '卖家评论数量总和',
  `total_good_comment` bigint(20) DEFAULT NULL COMMENT '买家好评数量总和',
  `view_number` bigint(20) DEFAULT NULL COMMENT '浏览量',
  `comment_number` bigint(20) DEFAULT NULL COMMENT '评论数量',
  `favorite_rate` int(11) DEFAULT NULL COMMENT '好评率',
  `enable` tinyint(3) DEFAULT NULL COMMENT '是否启用',
  `sort` tinyint(3) DEFAULT NULL COMMENT '自定义排序序号',
  `gmt_created` datetime DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT NULL COMMENT '最后修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='图书详情表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `book_details`
--

LOCK TABLES `book_details` WRITE;
/*!40000 ALTER TABLE `book_details` DISABLE KEYS */;
/*!40000 ALTER TABLE `book_details` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `book_order`
--

DROP TABLE IF EXISTS `book_order`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `book_order` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '自动编号',
  `order_no` int(11) DEFAULT NULL COMMENT '订单单号的唯一值 供客户查询',
  `order_status` tinyint(4) DEFAULT NULL COMMENT '订单状态',
  `product_count` int(11) DEFAULT NULL COMMENT '商品数量',
  `product_amount_total` double(12,2) DEFAULT NULL COMMENT '商品总价',
  `order_amount_total` double(12,2) DEFAULT NULL COMMENT '订单金额',
  `logistics_fee` double(12,2) DEFAULT NULL COMMENT '运费金额',
  `address_id` bigint(20) DEFAULT NULL COMMENT '收货地址编号',
  `pay_channel` tinyint(4) DEFAULT NULL COMMENT '订单支付渠道',
  `out_trade_no` int(11) DEFAULT NULL COMMENT '订单支付单号',
  `pay_time` datetime DEFAULT NULL COMMENT '付款时间',
  `delivery_time` datetime DEFAULT NULL COMMENT '发货时间',
  `user_id` bigint(20) DEFAULT NULL COMMENT '客户编号',
  `remark` varchar(255) DEFAULT NULL COMMENT '客户备注',
  `order_settlement_time` datetime DEFAULT NULL COMMENT '订单结算时间',
  `gmt_created` datetime DEFAULT NULL COMMENT '创建时间(下单时间)',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='订单表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `book_order`
--

LOCK TABLES `book_order` WRITE;
/*!40000 ALTER TABLE `book_order` DISABLE KEYS */;
/*!40000 ALTER TABLE `book_order` ENABLE KEYS */;
UNLOCK TABLES;

--
-- 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` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '类别',
  `name` varchar(50) DEFAULT NULL COMMENT '类别名称',
  `parent_id` bigint(20) DEFAULT NULL COMMENT '父级类别id 无父级为0',
  `depth` tinyint(3) unsigned DEFAULT NULL COMMENT '深度(最顶级类别的深度为1)',
  `keywords` varchar(255) DEFAULT NULL COMMENT '关键词列表',
  `sort` tinyint(3) unsigned DEFAULT NULL COMMENT '自定义排序序号',
  `icon` varchar(255) DEFAULT NULL COMMENT '图标图片的url',
  `enable` tinyint(3) unsigned DEFAULT NULL COMMENT '是否启用',
  `is_parent` tinyint(3) unsigned DEFAULT NULL COMMENT '是否为父级 1是父级 0不是父级',
  `is_display` tinyint(3) unsigned DEFAULT NULL COMMENT '是否显示在导航栏中(1显示 0不显示)',
  `gmt_created` datetime DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT NULL COMMENT '最后修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='图书分类表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `category`
--

LOCK TABLES `category` WRITE;
/*!40000 ALTER TABLE `category` DISABLE KEYS */;
/*!40000 ALTER TABLE `category` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `comment`
--

DROP TABLE IF EXISTS `comment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `comment` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
  `book_id` bigint(20) DEFAULT NULL COMMENT '图书id',
  `user_id` bigint(20) DEFAULT NULL COMMENT '用户id',
  `user_nick` varchar(50) DEFAULT NULL COMMENT '用户昵称',
  `comment` varchar(500) DEFAULT NULL COMMENT '评论',
  `is_display` tinyint(4) DEFAULT NULL COMMENT '是否显示',
  `is_delete` tinyint(4) DEFAULT NULL COMMENT '是否标记为已删除',
  `gmt_created` datetime DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT NULL COMMENT '最后修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='评论表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `comment`
--

LOCK TABLES `comment` WRITE;
/*!40000 ALTER TABLE `comment` DISABLE KEYS */;
/*!40000 ALTER TABLE `comment` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `order_exchange`
--

DROP TABLE IF EXISTS `order_exchange`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `order_exchange` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
  `order_id` bigint(20) DEFAULT NULL COMMENT '订单id',
  `company_address_id` bigint(20) DEFAULT NULL COMMENT '收货地址表id',
  `product_id` bigint(20) DEFAULT NULL COMMENT '换货商品id',
  `order_sn` varchar(64) DEFAULT NULL COMMENT '订单单号',
  `return_name` varchar(100) DEFAULT NULL COMMENT '换货人姓名',
  `return_phone` varchar(100) DEFAULT NULL COMMENT '换货人电话',
  `status` int(1) DEFAULT NULL COMMENT '申请状态：0->待处理；1->换货中；2->已完成；3->已拒绝',
  `product_pic` varchar(500) DEFAULT NULL COMMENT '商品图片',
  `product_name` varchar(200) DEFAULT NULL COMMENT '商品名称',
  `product_brand` varchar(200) DEFAULT NULL COMMENT '商品分类',
  `product_count` int(11) DEFAULT NULL COMMENT '换货数量',
  `product_price` double(10,2) DEFAULT NULL COMMENT '商品单价',
  `product_real_price` double(10,2) DEFAULT NULL COMMENT '商品实际支付单价',
  `reason` varchar(200) DEFAULT NULL COMMENT '原因',
  `receive_man` varchar(100) DEFAULT NULL COMMENT '收货人',
  `receive_time` datetime DEFAULT NULL COMMENT '收货时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='订单换货表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `order_exchange`
--

LOCK TABLES `order_exchange` WRITE;
/*!40000 ALTER TABLE `order_exchange` DISABLE KEYS */;
/*!40000 ALTER TABLE `order_exchange` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `order_return`
--

DROP TABLE IF EXISTS `order_return`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `order_return` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
  `order_id` bigint(20) DEFAULT NULL COMMENT '订单id',
  `company_address_id` bigint(20) DEFAULT NULL COMMENT '收货地址id',
  `product_id` bigint(20) DEFAULT NULL COMMENT '退货商品id',
  `order_sn` varchar(64) DEFAULT NULL COMMENT '订单单号',
  `return_amount` double(10,2) DEFAULT NULL COMMENT '退货金额',
  `return_name` varchar(100) DEFAULT NULL COMMENT '退货人姓名',
  `return_phone` varchar(100) DEFAULT NULL COMMENT '退货人电话',
  `status` int(1) DEFAULT NULL COMMENT '申请状态：0->待处理；1->换货中；2->已完成；3->已拒绝',
  `product_pic` varchar(500) DEFAULT NULL COMMENT '商品图片',
  `product_name` varchar(200) DEFAULT NULL COMMENT '商品名称',
  `product_category` varchar(200) DEFAULT NULL COMMENT '商品分类',
  `product_count` int(11) DEFAULT NULL COMMENT '退货数量',
  `product_price` double(10,2) DEFAULT NULL COMMENT '商品单价',
  `product_real_price` double(10,2) DEFAULT NULL COMMENT '商品实际支付单价',
  `reason` varchar(200) DEFAULT NULL COMMENT '原因',
  `receive_man` varchar(100) DEFAULT NULL COMMENT '收货人',
  `receive_time` datetime DEFAULT NULL COMMENT '收货时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='订单退货表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `order_return`
--

LOCK TABLES `order_return` WRITE;
/*!40000 ALTER TABLE `order_return` DISABLE KEYS */;
/*!40000 ALTER TABLE `order_return` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pay_running_number`
--

DROP TABLE IF EXISTS `pay_running_number`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pay_running_number` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
  `user_id` bigint(20) unsigned DEFAULT NULL COMMENT '用户id',
  `money` int(11) DEFAULT NULL COMMENT '交易金额用正负表示退款还是转账',
  `type` tinyint(4) DEFAULT NULL COMMENT '类型微信、支付宝、现金等',
  `gmt_created` datetime DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT NULL COMMENT '最后修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='支付流水表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pay_running_number`
--

LOCK TABLES `pay_running_number` WRITE;
/*!40000 ALTER TABLE `pay_running_number` DISABLE KEYS */;
/*!40000 ALTER TABLE `pay_running_number` ENABLE KEYS */;
UNLOCK TABLES;

--
-- 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` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
  `album_id` bigint(20) unsigned DEFAULT NULL COMMENT '相册id',
  `url` varchar(255) DEFAULT NULL COMMENT '图片路径',
  `description` varchar(255) DEFAULT NULL COMMENT '图片简介',
  `width` smallint(5) unsigned DEFAULT NULL COMMENT '图片宽度',
  `height` smallint(5) unsigned DEFAULT NULL COMMENT '图片高度',
  `is_cover` tinyint(3) unsigned DEFAULT NULL COMMENT '是否为封面图片',
  `sort` int(11) DEFAULT NULL COMMENT '自定义排序序号',
  `gmt_created` datetime DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT NULL COMMENT '最后修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='图片表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `picture`
--

LOCK TABLES `picture` WRITE;
/*!40000 ALTER TABLE `picture` DISABLE KEYS */;
/*!40000 ALTER TABLE `picture` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `region`
--

DROP TABLE IF EXISTS `region`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `region` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
  `name` varchar(40) DEFAULT NULL COMMENT '区域名称',
  `pid` int(11) DEFAULT NULL COMMENT '区域上级标识',
  `sname` varchar(40) DEFAULT NULL COMMENT '地名简称',
  `level` int(11) DEFAULT NULL COMMENT '区域等级',
  `pinyin` varchar(100) DEFAULT NULL COMMENT '拼音',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='收货地址表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `region`
--

LOCK TABLES `region` WRITE;
/*!40000 ALTER TABLE `region` DISABLE KEYS */;
/*!40000 ALTER TABLE `region` ENABLE KEYS */;
UNLOCK TABLES;

--
-- 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` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
  `username` varchar(50) DEFAULT NULL COMMENT '用户名',
  `password` char(60) DEFAULT NULL COMMENT '密码',
  `nickname` varchar(50) DEFAULT NULL COMMENT '昵称',
  `name` varchar(50) DEFAULT NULL COMMENT '姓名',
  `gender` varchar(5) DEFAULT NULL COMMENT '性别',
  `address` varchar(255) DEFAULT NULL COMMENT '地址',
  `vip_grade` tinyint(3) unsigned DEFAULT NULL COMMENT '会员初级读者 会员',
  `avatar` varchar(255) DEFAULT NULL COMMENT '头像url',
  `phone` varchar(50) DEFAULT NULL COMMENT '手机号码',
  `email` varchar(50) DEFAULT NULL COMMENT '电子邮箱',
  `description` varchar(255) DEFAULT NULL COMMENT '描述',
  `enable` tinyint(3) unsigned DEFAULT NULL COMMENT '是否启用',
  `last_login_ip` varchar(50) DEFAULT NULL COMMENT '最后登录ip地址',
  `login_count` int(10) unsigned DEFAULT NULL COMMENT '累计登录次数',
  `gmt_created` datetime DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT NULL COMMENT '最后修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user`
--

LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;
/*!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 2022-10-30 17:01:38