-- MySQL dump 10.13  Distrib 5.7.27, for Linux (x86_64)
--
-- Host: localhost    Database: book
-- ------------------------------------------------------
-- Server version	5.7.27-0ubuntu0.16.04.1

/*!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 `article_body`
--

DROP TABLE IF EXISTS `article_body`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `article_body` (
  `article_number` bigint(40) NOT NULL COMMENT '文章编号',
  `content` text NOT NULL COMMENT '文章内容',
  `update_by` bigint(40) DEFAULT '0' COMMENT '更新者Id',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`article_number`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='文章体';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `article_body`
--

LOCK TABLES `article_body` WRITE;
/*!40000 ALTER TABLE `article_body` DISABLE KEYS */;
INSERT INTO `article_body` VALUES (159,'<p>这个系统的构想，设计，与实现到目前为止总共花费了我五天的时间（不得不说，这时间有够长的)</p><h3>虽然不够尽善尽美，但这仍然是帮杰的心血之作</h3><p>功能模块展示<img src=\"http://www.bjtang.com:8001/book/39f0a592-30bd-4c5f-acac-81872e8f595eScreenshot_20200402_185830_com.huawei.browser.jpg\" style=\"max-width: 100%;\"></p><p>一共这么多模块，尚未完成的有商品管理和订单。没事，近在咫尺了。</p><p>你可以通过点击这个连接，查看项目的swagger</p><p><a href=\"http://www.bjtang.com:8001/book/swagger-ui.html\" target=\"_blank\">项目swagger页面</a><br></p><p>其实细节上也有很多值得修改的地方</p><p><span style=\"text-decoration-line: line-through;\">其实是帮杰前端实在过分垃圾，不能更好更快的写出漂亮页面</span><br></p><p><span style=\"font-style: italic;\">不过没事！又不是不能用！你说对吧？</span><span style=\"text-decoration-line: line-through;\"><br></span></p><p><span style=\"text-decoration-line: underline;\">值得一提的是，目前版本不太完善，甚至需要注册登录才能看见这篇文章</span><span style=\"font-style: italic;\"><br></span></p><blockquote><span style=\"text-decoration-line: underline;\">不过没关系，系统会逐渐完善的</span></blockquote><p style=\"text-align: center;\">总的来说，毕竟是自己写的，</p><p style=\"text-align: center;\">再难看再难用也得受着，对吧？</p><p style=\"text-align: center;\"><img src=\"http://www.bjtang.com:8001/book/27d22300-b22f-4846-879a-d472286a95d3484ca06e65130bf.png\" style=\"max-width:30%;\"><br></p><p style=\"text-align: center;\">再会！</p><p style=\"text-align: center;\"><br></p>',0,'2020-04-02 19:08:01'),(160,'<p><br></p>',0,'2020-04-02 19:26:19'),(161,'<p>首先，你得写好标题，写好文章简介</p><p>然后上传题图。题图可以通过url粘贴的方式，也可以采用本地上传的方式。推荐本地上传！</p><p>选择商品这个是后面留着带货用的口子。你可以填个0，也可以不填，丝毫不影响创建！</p><p>随便打一段话，提交试试吧。</p><p><img src=\"http://www.bjtang.com:8001/book/7ea22f10-2a17-45bd-a5d5-591f9a8c51d36c29e0ce162c9eb9.jpg\" style=\"max-width:70%;\"><br></p><p>当你在博文添加图片时，可以再按一下，即可调整大小哦</p><p><img src=\"http://www.bjtang.com:8001/book/68f41d19-dbbd-4d94-8c02-3f74bc579269Screenshot_20200402_193208_com.huawei.browser.jpg\" style=\"max-width:50%;\"><br></p>',0,'2020-04-02 19:33:15'),(162,'<p>可以可以，</p>',0,'2020-04-02 19:47:14'),(163,'<p>可以可以，</p>',0,'2020-04-02 19:47:30'),(164,'<p>可以可以，</p>',0,'2020-04-02 19:47:35'),(169,'<p>部署到服务器后发现,每次更新请求时总会时间+8,可以看第一个博文,创建时间已经是超前十几二十天了.</p><p>通过对本地时间,服务器时间进行比对,并未发现问题</p><p>本地mysql和服务器mysql时间比对,也没有发现问题</p><p>由于后端项目部署于docker服务器,前端项目部署于nginx.发现nginx和docker服务器的时区都是+0.<span style=\"font-weight: bold;\">而我们中国时区应该是+8 通过修改后端项目部署的时区解决这个部署问题</span></p><p>nginx服务器仍然没有更改时区,原因:涉及到创建时间,更改时间,都以mysql数据库时间为准 .时间的生成也由mysql完成,确保时间统一性.前端向后端发送请求时,也没有时间相关参数,所以规避了此bug<span style=\"font-weight: bold;\"><br></span></p>',0,'2020-04-03 16:42:00'),(170,'<p>在本地测试的时候,注册发送邮箱是好好的,但到了云端之后(使用阿里云服务器)就炸了,无法发送email验证码出来,经过搜索得知是阿里云的25端口禁用问题,通过发送加密的ssl邮件,通过465端口,发送正常</p>',0,'2020-04-07 10:27:20'),(188,'<blockquote>这个版本应该就是最终版本了(如果没有bug的话)</blockquote><p>总体来说令我满意</p><blockquote>本项目实现的功能有</blockquote><p>1.基本的用户登录注册,权限管理</p><p>2.基本的图像验证码,email验证等安全验证手段</p><p>3.基本的文件上传访问,图床管理</p><p>4.基本的交易模块,含商品创建,购买,发货,收货,取消等</p><p>5.基本的文章模块,含文章发布,修改,高级查询等</p><p>6.基本的社交模块,含用户关注,分享文章等</p><p>7.基本的错误管理模块</p><blockquote>令人失望的有</blockquote><p>1.开发工期超时,原计划3天&nbsp; &nbsp;实际用时5天,共计5*10 50个工作时</p><p>2.没有后台管理模块</p><p>3,没有pc桌面版本(对于文章书写来说,桌面版确实要舒服得多</p><p>4.页面过分丑陋,怪我前端没学好</p><blockquote>使用的技术有</blockquote><p>1.数据库 mysql</p><p>2.后端 spring boot +mybatis-plus</p><p>3.前端 vue + vant移动组件库</p><p>4.开发方式 前后端分离开发</p><p>5.部署方式 前后端分离部署 前端docker+nginx,后端docker+spring boot jar包</p><p>6.密码加密 rsa加密</p><p>7.安全验证手段&nbsp; 图像验证码生成,email邮件发送</p><p>8.使用restful api,面向接口编程</p><p><a href=\"http://www.bjtang.com:8001/book/swagger-ui.html#/\" target=\"_blank\">这个链接跳转至这个项目的swagger</a><br></p><blockquote>后续的想法有</blockquote><p>1. 完善管理模块</p><p>2.完成pc版</p><p>3.根据此项目重构mikoyang个人博客</p><p>4.优化页面</p><p>以上想法预计6月份开始实施</p><p>到此,结束</p><p><img src=\"http://www.bjtang.com:8001/book/27d22300-b22f-4846-879a-d472286a95d3484ca06e65130bf.png\" style=\"max-width:50%;\"><br></p>',1,'2020-04-08 00:45:37'),(189,'<p>&lt;script&gt;alert(\"123\");&lt;/script&gt;</p>',0,'2020-04-08 09:12:48'),(190,'<p><span style=\"text-decoration: line-through;\"><a href=\"\" target=\"_blank\"><script>alert(\"123\");</script>随便写点什么吧</a></span></p>',0,'2020-04-08 09:16:43'),(191,'',0,'2020-04-08 09:16:46'),(192,'',0,'2020-04-08 09:16:47'),(193,'',0,'2020-04-08 09:16:47'),(194,'',0,'2020-04-08 09:16:47'),(195,'',0,'2020-04-08 09:16:47'),(196,'<p>123123</p><p><br><img src=\"\"><script>alert(document.cookie)</script>\" style=\"max-width:100%;\"/&gt;</p><p><a href=\"\"><script>alert(document.cookie)</script>\" target=\"_blank\"&gt;1</a><br><br></p>',0,'2020-04-08 09:30:34'),(198,'<p>随便写点什么吧</p>',0,'2020-04-08 09:32:06'),(199,'',0,'2020-04-08 09:32:10'),(200,'<p>随便写点什么吧</p>',0,'2020-04-13 15:12:02'),(201,'<p>随便写点什么吧12312asdasdasd</p>',1,'2022-04-14 14:40:53'),(202,'<p>随便写点什么吧</p>',0,'2022-04-14 14:39:27');
/*!40000 ALTER TABLE `article_body` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `article_head`
--

DROP TABLE IF EXISTS `article_head`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `article_head` (
  `article_number` bigint(40) NOT NULL AUTO_INCREMENT COMMENT '文章编号',
  `title` varchar(120) NOT NULL DEFAULT '' COMMENT '文章标题',
  `summary` varchar(1000) NOT NULL DEFAULT '' COMMENT '文章简介，默认100个汉字以内',
  `picture_url` varchar(1000) NOT NULL DEFAULT '' COMMENT '文章题图url',
  `traffic` bigint(40) NOT NULL DEFAULT '0' COMMENT '文章访问量',
  `up_number` bigint(40) NOT NULL DEFAULT '0' COMMENT '点赞量',
  `down_number` bigint(40) NOT NULL DEFAULT '0' COMMENT '点踩量',
  `book_number` bigint(40) NOT NULL DEFAULT '0' COMMENT '相关商品',
  `recommend_number` bigint(40) NOT NULL DEFAULT '0' COMMENT '推荐次数',
  `founder` bigint(40) DEFAULT '0' COMMENT '创建者Id',
  `creation_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `status` int(1) DEFAULT '0' COMMENT '文章状态（0正常 1停用）',
  `deleted` int(1) NOT NULL DEFAULT '0' COMMENT '删除标志（0代表存在 1代表删除）',
  PRIMARY KEY (`article_number`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=203 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='文章头';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `article_head`
--

LOCK TABLES `article_head` WRITE;
/*!40000 ALTER TABLE `article_head` DISABLE KEYS */;
INSERT INTO `article_head` VALUES (159,'欢迎来到book','这是帮杰的第一条卖书带货文','http://www.bjtang.com:8001/book/47df9015-77da-4515-b19c-71afeca6c882mobile_wallpaper.jpg',135,4,5,0,0,1,'2020-05-01 19:08:01',0,0),(161,'来，和我一起尝试新建博文','傻瓜无脑式操作，一看就会','http://www.bjtang.com:8001/book/4fb730f2-896f-4172-9a41-2e0687f5f5f2Screenshot_20200402_192843.jpg',32,2,1,0,0,1,'2020-04-08 19:33:15',0,0),(169,'更新日志4月3日','本次更新了时区相关问题','http://www.bjtang.com:8001/book/638d5018-73e5-414f-bb28-9f8ecc3eea3dSunset_of_the_Lake_Nam_by_Wang_Jinyu.jpg',25,0,0,0,0,1,'2020-04-06 00:42:00',0,0),(170,'更新日志4月7日','本次更新了email相关问题','http://www.bjtang.com:8001/book/72a70ef8-dc36-4a68-9dfd-355f5fcaf596Grassland_Scenery_by_Shi_Yuejun.jpg',25,1,1,0,0,1,'2020-04-09 10:27:20',0,0),(188,'更新日志4月8日','本次更新了文章相关模块，商品模块，分享模块等一系列功能与细节实现。不出bug的话，应该是最终版本','http://www.bjtang.com:8001/book/67f94e14-1f04-4b85-a729-b2d296c2e429Flying_Whale_by_Shu_Le.jpg',48,1,1,0,0,1,'2020-04-11 08:08:55',0,0),(189,'<script>alert(\"123\");</script>','<script>alert(\"测试\");</script>','<script>alert(\"123\");</script>',16,1,1,0,0,1,'2020-04-09 09:12:48',0,1),(190,'','','http://www.bjtang.com:8001/book/86c2d972-bbc4-4af5-a153-000ad20187faQQ图片20200319103728.png',16,0,0,0,0,1,'2020-04-09 01:16:43',0,0),(191,'','','',2,0,0,0,0,1,'2020-04-08 09:16:46',0,1),(192,'','','',0,0,0,0,0,1,'2020-04-08 09:16:47',0,1),(193,'','','',0,0,0,0,0,1,'2020-04-08 09:16:47',0,1),(194,'','','',4,0,0,0,0,1,'2020-04-08 09:16:47',0,1),(195,'','','',1,0,0,0,0,1,'2020-04-08 09:16:47',0,1),(196,'\"/><script>alert(document.cookie)</script>','\"/><script>alert(document.cookie)</script>','\"/><script>alert(document.cookie)</script>',5,0,0,0,0,1,'2020-04-08 09:30:34',0,1),(198,'','','\"/><script>alert(document.cookie)</script>',2,0,0,0,0,1,'2020-04-08 09:32:06',0,1),(199,'','','',4,0,0,0,0,1,'2020-04-08 09:32:10',0,1),(200,'测试商品挂载','这篇文章挂载了一个商品。可以购买','',21,0,0,372,0,1,'2020-04-17 07:12:02',0,0),(201,'1','1','1',20,0,1,373,0,1,'2020-05-21 11:01:10',0,1),(202,'12312','321312312','http://www.bjtang.com:8001/book/1983ae3c-fa89-4ffd-ab73-c2d373c6df7014b21bd6139f4712a2c7cc54b1bf0aab.jpg',7,0,0,0,0,1,'2022-04-16 22:39:27',0,0);
/*!40000 ALTER TABLE `article_head` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `attention_table`
--

DROP TABLE IF EXISTS `attention_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `attention_table` (
  `attention_number` bigint(40) NOT NULL AUTO_INCREMENT COMMENT '关注编号',
  `user_number` bigint(40) NOT NULL COMMENT '被关注人编号',
  `founder` bigint(40) DEFAULT '0' COMMENT '创建者Id',
  `creation_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`attention_number`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=381 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='用户关注表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `attention_table`
--

LOCK TABLES `attention_table` WRITE;
/*!40000 ALTER TABLE `attention_table` DISABLE KEYS */;
INSERT INTO `attention_table` VALUES (380,1,1,'2020-04-05 17:55:13');
/*!40000 ALTER TABLE `attention_table` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `book_table`
--

DROP TABLE IF EXISTS `book_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `book_table` (
  `book_number` bigint(40) NOT NULL AUTO_INCREMENT COMMENT '图书编号',
  `status` int(1) DEFAULT '0' COMMENT '图书状态0创建中 1已被购买 2发货中 3交易成功 4.取消订单',
  `name` varchar(200) NOT NULL DEFAULT '' COMMENT '图书名称，默认100个汉字以内',
  `summary` varchar(1000) NOT NULL DEFAULT '' COMMENT '图书简介，默认200个汉字以内',
  `picture_url` varchar(1000) NOT NULL DEFAULT '' COMMENT '图书图片',
  `book_price` double(8,2) NOT NULL DEFAULT '0.00' COMMENT '图书价格',
  `buyer_number` bigint(40) NOT NULL DEFAULT '0' COMMENT '购买者编号',
  `buyer_time` datetime DEFAULT NULL COMMENT '购买时间',
  `founder` bigint(40) DEFAULT '0' COMMENT '创建者Id',
  `tracking_number` varchar(40) DEFAULT '' COMMENT '快递单号',
  `creation_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `deleted` int(1) NOT NULL DEFAULT '0' COMMENT '删除标志（0代表存在 1代表删除）',
  PRIMARY KEY (`book_number`)
) ENGINE=InnoDB AUTO_INCREMENT=374 DEFAULT CHARSET=utf8 COMMENT='图书商品表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `book_table`
--

LOCK TABLES `book_table` WRITE;
/*!40000 ALTER TABLE `book_table` DISABLE KEYS */;
INSERT INTO `book_table` VALUES (364,4,'\"/><script>alert(document.cookie)</script>','\"/><script>alert(document.cookie)</script>','',0.00,1,'2020-04-08 09:31:46',1,'','2020-04-08 09:31:02',0),(365,0,'','','',0.00,0,NULL,1,'','2020-04-08 09:31:05',1),(366,0,'','','\"/><script>alert(document.cookie)</script>',0.00,0,NULL,1,'','2020-04-08 09:31:07',1),(367,0,'','','',123.00,0,NULL,1,'','2020-04-08 09:31:22',1),(368,0,'','','',0.33,0,NULL,1,'','2020-04-08 09:31:29',1),(369,0,'','','',0.00,0,NULL,1,'','2020-04-08 09:32:21',1),(370,0,'','','',1.00,0,NULL,1,'','2020-04-08 09:33:55',1),(371,0,'','','Where 1=1',0.00,0,NULL,1,'','2020-04-08 09:33:58',1),(372,1,'一包泡椒花生','这是一包美味的花生，便宜实惠，好吃不贵','http://www.bjtang.com:8001/book/4581e4ea-73db-4d68-88bb-736e5657718ewx_camera_1576148498269.jpg',4.00,1,'2020-04-13 15:12:44',1,'','2020-04-13 15:07:50',0),(373,1,'1','1','',100.00,1,'2020-05-16 03:01:22',1,'','2020-05-16 03:00:56',0);
/*!40000 ALTER TABLE `book_table` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `browse_table`
--

DROP TABLE IF EXISTS `browse_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `browse_table` (
  `browse_id` bigint(40) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `up_down_is` int(1) DEFAULT '0' COMMENT '点赞0还是点踩1',
  `article_number` bigint(40) NOT NULL COMMENT '文章编号',
  `founder` bigint(40) DEFAULT '0' COMMENT '创建者Id',
  `creation_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`browse_id`)
) ENGINE=InnoDB AUTO_INCREMENT=238 DEFAULT CHARSET=utf8 COMMENT='浏览表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `browse_table`
--

LOCK TABLES `browse_table` WRITE;
/*!40000 ALTER TABLE `browse_table` DISABLE KEYS */;
INSERT INTO `browse_table` VALUES (1,2,170,0,'2020-04-07 23:41:57'),(2,0,170,1,'2020-04-07 23:41:59'),(3,1,170,1,'2020-04-07 23:42:00'),(4,2,170,0,'2020-04-07 23:42:29'),(5,2,159,1,'2020-04-07 23:42:32'),(6,2,170,0,'2020-04-07 23:42:34'),(7,2,170,0,'2020-04-07 23:44:59'),(8,2,170,0,'2020-04-07 23:45:47'),(9,2,169,0,'2020-04-07 23:54:59'),(10,2,170,0,'2020-04-07 23:55:26'),(11,2,170,0,'2020-04-08 00:00:22'),(12,2,169,0,'2020-04-08 00:00:28'),(13,2,161,0,'2020-04-08 00:00:31'),(14,2,159,0,'2020-04-08 00:00:35'),(15,2,170,0,'2020-04-08 00:00:47'),(16,2,188,0,'2020-04-08 00:09:26'),(17,2,188,0,'2020-04-08 00:10:23'),(18,0,188,1,'2020-04-08 00:10:27'),(19,1,188,1,'2020-04-08 00:10:28'),(20,2,188,0,'2020-04-08 00:11:15'),(21,2,188,0,'2020-04-08 00:11:22'),(22,2,188,0,'2020-04-08 00:27:36'),(23,2,188,0,'2020-04-08 00:29:21'),(24,2,188,0,'2020-04-08 00:31:12'),(25,2,188,0,'2020-04-08 00:31:20'),(26,2,188,0,'2020-04-08 00:31:25'),(27,2,188,0,'2020-04-08 00:31:36'),(28,2,188,0,'2020-04-08 00:32:05'),(29,2,161,0,'2020-04-08 00:39:16'),(30,2,188,0,'2020-04-08 00:45:48'),(31,2,188,0,'2020-04-08 00:45:56'),(32,2,188,0,'2020-04-08 00:46:37'),(33,2,188,0,'2020-04-08 00:46:54'),(34,2,188,0,'2020-04-08 00:47:16'),(35,2,170,0,'2020-04-08 00:47:36'),(36,2,169,0,'2020-04-08 00:47:40'),(37,2,159,0,'2020-04-08 00:47:42'),(38,2,169,0,'2020-04-08 00:47:45'),(39,2,161,0,'2020-04-08 00:47:47'),(40,2,188,0,'2020-04-08 00:48:04'),(41,2,188,0,'2020-04-08 01:34:24'),(42,2,161,0,'2020-04-08 01:36:18'),(43,2,188,0,'2020-04-08 01:36:45'),(44,2,169,0,'2020-04-08 02:30:33'),(45,2,159,0,'2020-04-08 02:30:41'),(46,2,188,0,'2020-04-08 06:44:20'),(47,2,159,0,'2020-04-08 08:20:20'),(48,2,188,0,'2020-04-08 08:20:24'),(49,2,161,0,'2020-04-08 08:22:03'),(50,2,189,0,'2020-04-08 09:12:56'),(51,0,189,1,'2020-04-08 09:13:05'),(52,1,189,1,'2020-04-08 09:13:09'),(53,2,189,0,'2020-04-08 09:13:22'),(54,2,189,0,'2020-04-08 09:13:56'),(55,2,189,0,'2020-04-08 09:16:26'),(56,2,189,0,'2020-04-08 09:16:52'),(57,2,170,0,'2020-04-08 09:16:54'),(58,2,170,0,'2020-04-08 09:17:51'),(59,2,190,0,'2020-04-08 09:18:46'),(60,2,190,0,'2020-04-08 09:18:50'),(61,2,190,0,'2020-04-08 09:18:51'),(62,2,159,0,'2020-04-08 09:18:57'),(63,2,189,0,'2020-04-08 09:20:00'),(64,2,188,0,'2020-04-08 09:24:47'),(65,2,194,0,'2020-04-08 09:27:19'),(66,2,195,0,'2020-04-08 09:27:22'),(67,2,159,0,'2020-04-08 09:27:31'),(68,2,189,0,'2020-04-08 09:28:13'),(69,2,194,0,'2020-04-08 09:28:34'),(70,2,194,0,'2020-04-08 09:29:31'),(71,2,196,0,'2020-04-08 09:30:38'),(72,2,196,0,'2020-04-08 09:30:40'),(73,2,196,0,'2020-04-08 09:30:41'),(74,2,199,0,'2020-04-08 09:36:35'),(75,2,189,0,'2020-04-08 10:07:44'),(76,2,198,0,'2020-04-08 10:07:53'),(77,2,196,0,'2020-04-08 10:07:56'),(78,2,198,0,'2020-04-08 10:07:58'),(79,2,199,0,'2020-04-08 10:08:01'),(80,2,190,0,'2020-04-08 10:08:06'),(81,2,188,0,'2020-04-08 10:08:57'),(82,2,188,0,'2020-04-08 11:16:10'),(83,2,199,0,'2020-04-08 14:22:01'),(84,2,188,0,'2020-04-08 14:22:33'),(85,2,199,0,'2020-04-08 14:23:58'),(86,2,196,0,'2020-04-08 14:24:09'),(87,2,170,0,'2020-04-08 14:24:19'),(88,2,159,0,'2020-04-08 14:24:47'),(89,2,159,0,'2020-04-08 14:25:59'),(90,2,190,0,'2020-04-08 15:08:21'),(91,2,189,0,'2020-04-08 15:08:43'),(92,2,190,0,'2020-04-08 15:08:46'),(93,2,190,0,'2020-04-08 15:08:48'),(94,2,190,0,'2020-04-08 15:08:52'),(95,2,190,0,'2020-04-08 15:08:53'),(96,2,190,0,'2020-04-08 15:08:57'),(97,2,190,0,'2020-04-08 15:09:13'),(98,2,191,0,'2020-04-08 15:09:37'),(99,2,191,0,'2020-04-08 15:09:48'),(100,2,194,0,'2020-04-08 15:09:57'),(101,2,189,0,'2020-04-08 15:10:09'),(102,2,170,0,'2020-04-08 15:12:22'),(103,2,170,0,'2020-04-08 15:13:36'),(104,2,188,0,'2020-04-08 15:14:40'),(105,2,161,0,'2020-04-09 13:57:00'),(106,2,190,0,'2020-04-09 13:57:03'),(107,2,189,0,'2020-04-09 13:57:06'),(108,2,169,0,'2020-04-09 13:57:09'),(109,2,159,0,'2020-04-09 13:57:26'),(110,2,188,0,'2020-04-10 11:26:21'),(111,2,159,0,'2020-04-10 11:31:28'),(112,2,200,0,'2020-04-13 15:12:11'),(113,2,200,0,'2020-04-13 15:12:48'),(114,2,200,0,'2020-04-13 15:13:06'),(115,2,200,0,'2020-04-13 17:31:58'),(116,2,200,0,'2020-04-13 17:33:03'),(117,2,159,0,'2020-04-13 22:00:29'),(118,2,188,0,'2020-04-16 10:34:57'),(119,2,188,0,'2020-04-16 21:14:28'),(120,2,188,0,'2020-05-15 14:59:10'),(121,2,188,0,'2020-05-16 02:36:51'),(122,2,189,0,'2020-05-16 02:37:57'),(123,2,189,0,'2020-05-16 02:40:18'),(124,2,188,0,'2020-05-16 02:41:16'),(125,2,188,0,'2020-05-16 02:42:35'),(126,2,200,0,'2020-05-16 02:49:50'),(127,2,170,0,'2020-05-16 02:51:22'),(128,2,161,0,'2020-05-16 02:51:25'),(129,2,200,0,'2020-05-16 02:51:54'),(130,2,200,0,'2020-05-16 02:52:10'),(131,2,188,0,'2020-05-16 02:53:01'),(132,2,188,0,'2020-05-16 02:55:47'),(133,2,159,0,'2020-05-16 02:56:36'),(134,2,190,0,'2020-05-16 02:58:59'),(135,2,188,0,'2020-05-16 02:59:06'),(136,2,201,0,'2020-05-16 03:01:13'),(137,2,201,0,'2020-05-16 03:01:24'),(138,2,188,0,'2020-05-16 03:05:11'),(139,2,170,0,'2020-05-16 05:34:34'),(140,2,161,0,'2020-05-16 05:34:58'),(141,2,188,0,'2020-05-16 05:47:49'),(142,2,200,0,'2020-05-16 06:32:31'),(143,2,201,0,'2020-05-16 06:52:50'),(144,2,169,0,'2020-05-16 07:22:37'),(145,2,159,0,'2020-05-16 08:34:37'),(146,2,200,0,'2020-05-16 08:34:58'),(147,2,201,0,'2020-05-16 08:35:04'),(148,2,170,0,'2020-05-16 08:35:07'),(149,2,169,0,'2020-05-16 08:35:24'),(150,2,161,0,'2020-05-16 08:35:38'),(151,2,170,0,'2020-05-16 09:27:25'),(152,2,159,0,'2020-05-16 10:50:10'),(153,2,161,0,'2020-06-02 21:38:03'),(154,2,170,0,'2020-06-02 21:39:02'),(155,2,161,0,'2020-06-02 21:49:40'),(156,2,190,0,'2020-06-29 15:16:50'),(157,2,201,0,'2020-06-29 15:16:57'),(158,2,188,0,'2020-12-19 00:59:10'),(159,2,159,0,'2020-12-19 00:59:21'),(160,2,188,0,'2020-12-19 01:00:49'),(161,2,189,0,'2020-12-19 01:11:10'),(162,2,188,0,'2020-12-19 01:15:46'),(163,2,159,0,'2020-12-19 01:40:01'),(164,2,201,0,'2022-04-14 11:22:07'),(165,2,201,0,'2022-04-14 11:22:13'),(166,2,201,0,'2022-04-14 11:22:16'),(167,2,200,0,'2022-04-14 11:22:17'),(168,2,190,0,'2022-04-14 11:22:24'),(169,2,190,0,'2022-04-14 11:22:28'),(170,2,189,0,'2022-04-14 11:22:40'),(171,2,201,0,'2022-04-14 11:32:07'),(172,2,200,0,'2022-04-14 11:32:32'),(173,2,200,0,'2022-04-14 14:15:39'),(174,2,200,0,'2022-04-14 14:15:45'),(175,2,159,0,'2022-04-14 14:18:01'),(176,2,159,0,'2022-04-14 14:37:10'),(177,2,169,0,'2022-04-14 14:37:41'),(178,2,169,0,'2022-04-14 14:37:51'),(179,2,159,0,'2022-04-14 14:38:02'),(180,2,201,0,'2022-04-14 14:38:58'),(181,2,201,0,'2022-04-14 14:39:03'),(182,2,201,0,'2022-04-14 14:39:06'),(183,2,188,0,'2022-04-14 14:39:45'),(184,2,201,0,'2022-04-14 14:40:14'),(185,2,201,0,'2022-04-14 14:40:26'),(186,2,201,0,'2022-04-14 14:40:40'),(187,2,201,0,'2022-04-14 14:40:49'),(188,2,201,0,'2022-04-14 14:41:02'),(189,2,201,0,'2022-04-14 14:41:11'),(190,2,201,0,'2022-04-14 14:41:24'),(191,2,201,0,'2022-04-14 14:41:34'),(192,1,201,1,'2022-04-14 14:41:37'),(193,2,170,0,'2022-04-14 14:41:55'),(194,2,200,0,'2022-04-14 14:42:05'),(195,2,200,0,'2022-04-14 14:42:42'),(196,2,200,0,'2022-04-14 14:42:45'),(197,2,200,0,'2022-04-14 14:42:48'),(198,2,200,0,'2022-04-14 14:42:52'),(199,2,189,0,'2022-04-14 14:42:54'),(200,2,188,0,'2022-04-14 14:42:58'),(201,2,202,0,'2022-04-14 14:43:22'),(202,2,202,0,'2022-04-14 14:43:27'),(203,2,202,0,'2022-04-14 14:43:30'),(204,2,188,0,'2022-04-14 14:43:58'),(205,2,170,0,'2022-04-14 14:44:01'),(206,2,159,0,'2022-04-14 14:45:29'),(207,2,200,0,'2022-04-14 14:47:11'),(208,2,202,0,'2022-04-14 14:47:17'),(209,2,200,0,'2022-04-14 14:47:19'),(210,2,159,0,'2022-04-14 14:47:34'),(211,2,161,0,'2022-04-14 15:22:20'),(212,2,170,0,'2022-04-14 18:36:54'),(213,2,169,0,'2022-04-14 18:37:45'),(214,2,188,0,'2022-04-14 19:35:34'),(215,2,188,0,'2022-04-14 19:39:26'),(216,2,169,0,'2022-04-14 19:50:56'),(217,2,161,0,'2022-04-15 15:36:45'),(218,2,202,0,'2022-05-11 20:55:16'),(219,2,170,0,'2022-05-13 10:45:48'),(220,2,202,0,'2022-05-14 23:33:57'),(221,2,159,0,'2022-05-30 21:10:23'),(222,2,159,0,'2022-05-30 21:10:41'),(223,2,159,0,'2022-11-29 08:52:00'),(224,0,159,1,'2022-11-29 08:52:41'),(225,1,159,1,'2022-11-29 08:52:55'),(226,2,170,0,'2022-11-29 08:56:36'),(227,2,188,0,'2022-11-29 08:56:53'),(228,2,169,0,'2022-11-29 08:57:28'),(229,2,161,0,'2022-11-29 08:58:02'),(230,2,202,0,'2022-11-29 08:58:42'),(231,2,159,0,'2022-11-29 08:58:45'),(232,2,159,0,'2022-11-29 08:58:48'),(233,2,159,0,'2022-11-29 08:58:51'),(234,2,159,0,'2022-11-29 08:58:55'),(235,2,188,0,'2022-11-29 08:59:03'),(236,2,169,0,'2022-11-29 20:18:43'),(237,2,159,0,'2022-12-01 15:27:20');
/*!40000 ALTER TABLE `browse_table` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `picture_table`
--

DROP TABLE IF EXISTS `picture_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `picture_table` (
  `picture_number` bigint(40) NOT NULL AUTO_INCREMENT COMMENT '图片编号',
  `picture_name` varchar(512) NOT NULL COMMENT '图片名称',
  `picture_path` varchar(550) NOT NULL COMMENT '图片路径',
  `founder` bigint(40) DEFAULT '0' COMMENT '创建者Id',
  `creation_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`picture_number`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=214 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='图片表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `picture_table`
--

LOCK TABLES `picture_table` WRITE;
/*!40000 ALTER TABLE `picture_table` DISABLE KEYS */;
INSERT INTO `picture_table` VALUES (198,'mobile_wallpaper.jpg','47df9015-77da-4515-b19c-71afeca6c882mobile_wallpaper.jpg',1,'2020-04-02 18:53:56'),(199,'Screenshot_20200402_185830_com.huawei.browser.jpg','39f0a592-30bd-4c5f-acac-81872e8f595eScreenshot_20200402_185830_com.huawei.browser.jpg',1,'2020-04-02 18:58:54'),(200,'Screenshot_20200331_114053_com.eg.android.AlipayGphone.jpg','4d284931-caac-4094-9025-4edbacbb2424Screenshot_20200331_114053_com.eg.android.AlipayGphone.jpg',1,'2020-04-02 19:06:25'),(201,'484ca06e65130bf.png','27d22300-b22f-4846-879a-d472286a95d3484ca06e65130bf.png',1,'2020-04-02 19:07:38'),(202,'Screenshot_20200402_192843.jpg','4fb730f2-896f-4172-9a41-2e0687f5f5f2Screenshot_20200402_192843.jpg',1,'2020-04-02 19:28:50'),(203,'6c29e0ce162c9eb9.jpg','7ea22f10-2a17-45bd-a5d5-591f9a8c51d36c29e0ce162c9eb9.jpg',1,'2020-04-02 19:31:53'),(204,'Screenshot_20200402_193208_com.huawei.browser.jpg','68f41d19-dbbd-4d94-8c02-3f74bc579269Screenshot_20200402_193208_com.huawei.browser.jpg',1,'2020-04-02 19:32:57'),(205,'Sunset_of_the_Lake_Nam_by_Wang_Jinyu.jpg','638d5018-73e5-414f-bb28-9f8ecc3eea3dSunset_of_the_Lake_Nam_by_Wang_Jinyu.jpg',1,'2020-04-03 16:35:41'),(206,'Grassland_Scenery_by_Shi_Yuejun.jpg','72a70ef8-dc36-4a68-9dfd-355f5fcaf596Grassland_Scenery_by_Shi_Yuejun.jpg',1,'2020-04-07 10:25:12'),(212,'14b21bd6139f4712a2c7cc54b1bf0aab.jpg','1983ae3c-fa89-4ffd-ab73-c2d373c6df7014b21bd6139f4712a2c7cc54b1bf0aab.jpg',1,'2022-04-14 14:39:15'),(213,'14b21bd6139f4712a2c7cc54b1bf0aab.jpg','f6096f15-adb0-4da4-8232-04200c9974fb14b21bd6139f4712a2c7cc54b1bf0aab.jpg',1,'2022-04-14 15:22:37');
/*!40000 ALTER TABLE `picture_table` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `share_table`
--

DROP TABLE IF EXISTS `share_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `share_table` (
  `share_number` bigint(40) NOT NULL AUTO_INCREMENT COMMENT '分享编号',
  `article_number` bigint(40) NOT NULL COMMENT '文章编号',
  `share_feeling` varchar(512) NOT NULL COMMENT '分享感言',
  `founder` bigint(40) DEFAULT '0' COMMENT '创建者Id',
  `creation_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`share_number`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='文章分享表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `share_table`
--

LOCK TABLES `share_table` WRITE;
/*!40000 ALTER TABLE `share_table` DISABLE KEYS */;
INSERT INTO `share_table` VALUES (28,170,'',1,'2020-04-07 23:42:02'),(29,188,'最终版本还是可以',1,'2020-04-08 00:10:43');
/*!40000 ALTER TABLE `share_table` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_user`
--

DROP TABLE IF EXISTS `sys_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_user` (
  `user_id` bigint(40) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(50) NOT NULL COMMENT '姓名',
  `email` varchar(128) NOT NULL COMMENT '邮箱',
  `phone` varchar(20) DEFAULT NULL COMMENT '手机',
  `user_address` varchar(500) DEFAULT NULL COMMENT '地址',
  `login_name` varchar(64) NOT NULL COMMENT '登陆名',
  `password` varchar(1024) NOT NULL COMMENT '密码',
  `founder` bigint(40) DEFAULT '0' COMMENT '创建者Id',
  `creation_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_by` bigint(40) DEFAULT '0' COMMENT '更新者Id',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `status` int(1) DEFAULT '0' COMMENT '用户状态（0正常 1停用）',
  `deleted` int(1) NOT NULL DEFAULT '0' COMMENT '删除标志（0代表存在 1代表删除）',
  PRIMARY KEY (`user_id`) USING BTREE,
  UNIQUE KEY `login_name` (`login_name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='用户表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_user`
--

LOCK TABLES `sys_user` WRITE;
/*!40000 ALTER TABLE `sys_user` DISABLE KEYS */;
INSERT INTO `sys_user` VALUES (1,'邦杰','bjtang@bjtang.com','150123','重庆市大渡口区蓝一街道三栋','bj-tang','11802622712967428304700392722216864897256243727692267750714149356350260890647182910405722574094842202998748183025662905604251525636558694822854943379311828049101686414823754988896798575060150454424995907895336403504250133535176013951644512195809439408359900106969760812971688830926459853007593437935648481400424182838508010956476315117133765930679488541708861902846255293075506004575084502355248053344242289750517095792823995814377181876297954086047651636841217798152181462645374843146024653383251200737526557033600867792905875560049683747065978229101365695067900709022730937457061275532686233635351207099239814825121',0,'2020-03-27 18:42:30',0,'2020-04-05 18:16:30',0,0);
/*!40000 ALTER TABLE `sys_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-12-03 17:07:54