三、飞鹅开源博客SQL语句

飞鹅官方账号
• 阅读 1156

以下是飞鹅数据库的SQL，直接连接mysql8.0 ，执行即可

默认admin表会插入一个管理员 手机号：12345678901 密码：123456

mysql SQL语句如下：

/*
 Navicat Premium Data Transfer

 Source Server         : hw-dev
 Source Server Type    : MySQL
 Source Server Version : 80019 (8.0.19)
 Source Host           : 192.168.168.166:3306
 Source Schema         : db_09

 Target Server Type    : MySQL
 Target Server Version : 80019 (8.0.19)
 File Encoding         : 65001

 Date: 21/08/2024 22:53:43
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `phone` longtext,
  `password` longtext,
  `nicker` longtext,
  `avatar` longtext,
  `token` longtext,
  `create_time` datetime(3) DEFAULT NULL,
  `valid_time` datetime(3) DEFAULT NULL,
  `login_time` datetime(3) DEFAULT NULL,
  `status` bigint DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of admin
-- ----------------------------
BEGIN;
INSERT INTO `admin` (`id`, `phone`, `password`, `nicker`, `avatar`, `token`, `create_time`, `valid_time`, `login_time`, `status`) VALUES (1, '12345678901', '21232f297a57a5a743894a0e4a801fc3', 'admin', 'https://img-hello-world.oss-cn-beijing.aliyuncs.com/imgs/b3e9e8fb50b3eba780178256a21234ec.jpg', '', '2024-07-19 23:03:49.563', '2024-07-19 23:03:49.563', '2024-07-19 23:03:49.563', 1);
COMMIT;

-- ----------------------------
-- Table structure for banner
-- ----------------------------
DROP TABLE IF EXISTS `banner`;
CREATE TABLE `banner` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `title` longtext,
  `url` longtext,
  `target_url` longtext,
  `seq` bigint DEFAULT NULL,
  `create_time` datetime(3) DEFAULT NULL,
  `status` bigint DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of banner
-- ----------------------------
BEGIN;
INSERT INTO `banner` (`id`, `title`, `url`, `target_url`, `seq`, `create_time`, `status`) VALUES (1, '1', 'https://test-blog.helloworld.net/static/img/674393665395.webp', '', 2, '2024-08-16 06:49:25.045', 1);
INSERT INTO `banner` (`id`, `title`, `url`, `target_url`, `seq`, `create_time`, `status`) VALUES (2, '2', 'https://test-blog.helloworld.net/static/img/029171992223.jpeg', '', 1, '2024-08-16 06:49:30.329', 1);
INSERT INTO `banner` (`id`, `title`, `url`, `target_url`, `seq`, `create_time`, `status`) VALUES (3, '--', 'https://flygoose-admin.helloworld.net/static/img/291510643911.jpeg', '', 3, '2024-08-18 01:47:38.625', 0);
COMMIT;

-- ----------------------------
-- Table structure for blog
-- ----------------------------
DROP TABLE IF EXISTS `blog`;
CREATE TABLE `blog` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `title` longtext,
  `intro` longtext,
  `content` longtext,
  `html` longtext,
  `is_html` bigint DEFAULT NULL,
  `is_top` bigint DEFAULT NULL,
  `read_count` bigint DEFAULT NULL,
  `create_time` datetime(3) DEFAULT NULL,
  `update_time` datetime(3) DEFAULT NULL,
  `publish_time` datetime(3) DEFAULT NULL,
  `thumbnail` longtext,
  `status` bigint DEFAULT NULL,
  `cate_id` bigint DEFAULT NULL,
  `tags` longtext,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of blog
-- ----------------------------
BEGIN;
INSERT INTO `blog` (`id`, `title`, `intro`, `content`, `html`, `is_html`, `is_top`, `read_count`, `create_time`, `update_time`, `publish_time`, `thumbnail`, `status`, `cate_id`, `tags`) VALUES (1, '测试测试', '测试测试', '测试测试', '', 0, 1, 0, '2024-08-10 02:03:13.449', '2024-08-16 08:11:52.416', '2024-08-10 02:03:13.449', 'https://test-blog.helloworld.net/static/img/413880491197.heic', 30, 1, '1,2,3,4');
INSERT INTO `blog` (`id`, `title`, `intro`, `content`, `html`, `is_html`, `is_top`, `read_count`, `create_time`, `update_time`, `publish_time`, `thumbnail`, `status`, `cate_id`, `tags`) VALUES (2, '1', '1', '1', '', 0, 0, 0, '2024-08-16 09:02:56.997', '2024-08-16 09:20:59.228', '2024-08-16 09:02:56.997', '', 30, 1, '');
INSERT INTO `blog` (`id`, `title`, `intro`, `content`, `html`, `is_html`, `is_top`, `read_count`, `create_time`, `update_time`, `publish_time`, `thumbnail`, `status`, `cate_id`, `tags`) VALUES (3, '2', '2', '2', '', 0, 0, 0, '2024-08-16 09:03:23.777', '2024-08-16 09:23:55.301', '2024-08-16 09:03:23.777', '', 30, 2, '');
INSERT INTO `blog` (`id`, `title`, `intro`, `content`, `html`, `is_html`, `is_top`, `read_count`, `create_time`, `update_time`, `publish_time`, `thumbnail`, `status`, `cate_id`, `tags`) VALUES (4, '3', '3', '3', '', 0, 1, 0, '2024-08-16 09:03:33.546', '2024-08-16 09:14:06.028', '2024-08-16 09:03:33.546', '', 20, 1, '');
INSERT INTO `blog` (`id`, `title`, `intro`, `content`, `html`, `is_html`, `is_top`, `read_count`, `create_time`, `update_time`, `publish_time`, `thumbnail`, `status`, `cate_id`, `tags`) VALUES (5, '4', '4', '4', '', 0, 1, 0, '2024-08-16 09:03:41.377', '2024-08-16 09:13:58.514', '2024-08-16 09:03:41.377', '', 20, 1, '');
INSERT INTO `blog` (`id`, `title`, `intro`, `content`, `html`, `is_html`, `is_top`, `read_count`, `create_time`, `update_time`, `publish_time`, `thumbnail`, `status`, `cate_id`, `tags`) VALUES (6, '5', '5', '5', '', 0, 1, 0, '2024-08-16 09:03:48.737', '2024-08-16 09:13:37.553', '2024-08-16 09:03:48.737', '', 20, 1, '');
INSERT INTO `blog` (`id`, `title`, `intro`, `content`, `html`, `is_html`, `is_top`, `read_count`, `create_time`, `update_time`, `publish_time`, `thumbnail`, `status`, `cate_id`, `tags`) VALUES (7, '6', '6', '6', '', 0, 1, 0, '2024-08-16 09:03:57.137', '2024-08-16 09:13:31.690', '2024-08-16 09:03:57.137', '', 20, 1, '');
INSERT INTO `blog` (`id`, `title`, `intro`, `content`, `html`, `is_html`, `is_top`, `read_count`, `create_time`, `update_time`, `publish_time`, `thumbnail`, `status`, `cate_id`, `tags`) VALUES (8, '7', '7', '7', '', 0, 0, 0, '2024-08-16 09:04:06.025', '2024-08-16 09:22:21.785', '2024-08-16 09:04:06.025', '', 10, 1, '');
INSERT INTO `blog` (`id`, `title`, `intro`, `content`, `html`, `is_html`, `is_top`, `read_count`, `create_time`, `update_time`, `publish_time`, `thumbnail`, `status`, `cate_id`, `tags`) VALUES (9, '8', '8', '8', '', 0, 1, 0, '2024-08-16 09:04:16.359', '2024-08-16 09:19:53.864', '2024-08-16 09:04:16.359', '', 20, 1, '');
INSERT INTO `blog` (`id`, `title`, `intro`, `content`, `html`, `is_html`, `is_top`, `read_count`, `create_time`, `update_time`, `publish_time`, `thumbnail`, `status`, `cate_id`, `tags`) VALUES (10, '9', '9', '9', '', 0, 1, 0, '2024-08-16 09:04:25.064', '2024-08-16 09:19:50.903', '2024-08-16 09:04:25.064', '', 20, 1, '');
INSERT INTO `blog` (`id`, `title`, `intro`, `content`, `html`, `is_html`, `is_top`, `read_count`, `create_time`, `update_time`, `publish_time`, `thumbnail`, `status`, `cate_id`, `tags`) VALUES (11, '00', '0', '00', '', 0, 1, 0, '2024-08-16 09:04:36.837', '2024-08-16 09:19:47.383', '2024-08-16 09:04:36.837', '', 20, 1, '');
COMMIT;

-- ----------------------------
-- Table structure for category
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` longtext,
  `seq` bigint DEFAULT NULL,
  `icon` longtext,
  `font` longtext,
  `color` longtext,
  `create_time` datetime(3) DEFAULT NULL,
  `update_time` datetime(3) DEFAULT NULL,
  `status` bigint DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of category
-- ----------------------------
BEGIN;
INSERT INTO `category` (`id`, `name`, `seq`, `icon`, `font`, `color`, `create_time`, `update_time`, `status`) VALUES (1, 'web前端', 0, '', '', 'red', '2024-08-10 02:02:52.081', '2024-08-10 02:02:52.081', 1);
INSERT INTO `category` (`id`, `name`, `seq`, `icon`, `font`, `color`, `create_time`, `update_time`, `status`) VALUES (2, 'H5', 2, '', '', 'red', '2024-08-16 09:02:43.388', '2024-08-16 09:02:43.388', 1);
COMMIT;

-- ----------------------------
-- Table structure for link
-- ----------------------------
DROP TABLE IF EXISTS `link`;
CREATE TABLE `link` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `title` longtext,
  `url` longtext,
  `seq` bigint DEFAULT NULL,
  `create_time` datetime(3) DEFAULT NULL,
  `update_time` datetime(3) DEFAULT NULL,
  `valid_time` datetime(3) DEFAULT NULL,
  `remark` longtext,
  `status` bigint DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of link
-- ----------------------------
BEGIN;
INSERT INTO `link` (`id`, `title`, `url`, `seq`, `create_time`, `update_time`, `valid_time`, `remark`, `status`) VALUES (1, '111', 'https://www.baidu.com/', 0, '2024-08-10 06:13:46.673', '2024-08-16 07:58:43.425', '2099-12-31 23:59:59.000', '', 1);
COMMIT;

-- ----------------------------
-- Table structure for notice
-- ----------------------------
DROP TABLE IF EXISTS `notice`;
CREATE TABLE `notice` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `title` longtext,
  `content` longtext,
  `create_time` datetime(3) DEFAULT NULL,
  `update_time` datetime(3) DEFAULT NULL,
  `valid_time` datetime(3) DEFAULT NULL,
  `status` bigint DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of notice
-- ----------------------------
BEGIN;
INSERT INTO `notice` (`id`, `title`, `content`, `create_time`, `update_time`, `valid_time`, `status`) VALUES (1, '飞鹅博客开源了', '轻量化部署，快速搭建自己的专属博客', '2024-08-10 06:15:03.751', '2024-08-10 06:15:03.751', '2024-08-10 06:14:59.000', 1);
COMMIT;

-- ----------------------------
-- Table structure for section
-- ----------------------------
DROP TABLE IF EXISTS `section`;
CREATE TABLE `section` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `title` longtext,
  `intro` longtext,
  `content` longtext,
  `html` longtext,
  `tags` longtext,
  `is_html` bigint DEFAULT NULL,
  `read_count` bigint DEFAULT NULL,
  `special_id` bigint DEFAULT NULL,
  `seq` bigint DEFAULT NULL,
  `create_time` datetime(3) DEFAULT NULL,
  `update_time` datetime(3) DEFAULT NULL,
  `publish_time` datetime(3) DEFAULT NULL,
  `status` bigint DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15739452 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of section
-- ----------------------------
BEGIN;
INSERT INTO `section` (`id`, `title`, `intro`, `content`, `html`, `tags`, `is_html`, `read_count`, `special_id`, `seq`, `create_time`, `update_time`, `publish_time`, `status`) VALUES (3542419, '213', '', 'w\'q\'w\'e\'q', '', '', 0, 0, 50585244, 2, '2024-08-16 08:02:53.713', '2024-08-16 08:03:02.035', '2024-08-16 08:03:02.035', 30);
INSERT INTO `section` (`id`, `title`, `intro`, `content`, `html`, `tags`, `is_html`, `read_count`, `special_id`, `seq`, `create_time`, `update_time`, `publish_time`, `status`) VALUES (15739451, '测试小结1', '', '测试小结1测试小结1测试小结1测试小结1测试小结1测试小结1测试小结1测试小结1', '', '', 0, 0, 50585244, 1, '2024-08-16 07:56:06.646', '2024-08-16 07:56:23.648', '2024-08-16 07:56:23.648', 30);
COMMIT;

-- ----------------------------
-- Table structure for site
-- ----------------------------
DROP TABLE IF EXISTS `site`;
CREATE TABLE `site` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `title` longtext,
  `intro` longtext,
  `slogan` longtext,
  `cover` longtext,
  `copyright` longtext,
  `icp` longtext,
  `update_time` datetime(3) DEFAULT NULL,
  `extra` longtext,
  `status` bigint DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of site
-- ----------------------------
BEGIN;
INSERT INTO `site` (`id`, `title`, `intro`, `slogan`, `cover`, `copyright`, `icp`, `update_time`, `extra`, `status`) VALUES (1, 'test', 'test', 'test', 'https://flygoose-admin.helloworld.net/static/img/909099273827.png', '1', '1', '2024-08-21 18:56:09.000', '1', 1);
COMMIT;

-- ----------------------------
-- Table structure for special
-- ----------------------------
DROP TABLE IF EXISTS `special`;
CREATE TABLE `special` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `title` longtext,
  `intro` longtext,
  `cover` longtext,
  `create_time` datetime(3) DEFAULT NULL,
  `update_time` datetime(3) DEFAULT NULL,
  `publish_time` datetime(3) DEFAULT NULL,
  `status` bigint DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=50585245 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of special
-- ----------------------------
BEGIN;
INSERT INTO `special` (`id`, `title`, `intro`, `cover`, `create_time`, `update_time`, `publish_time`, `status`) VALUES (10315865, '测试专栏', '测试专栏', 'https://test-blog.helloworld.net/static/img/840803494584.heic', '2024-08-10 06:12:39.416', '2024-08-16 07:52:14.340', '2024-08-10 06:12:39.416', 30);
INSERT INTO `special` (`id`, `title`, `intro`, `cover`, `create_time`, `update_time`, `publish_time`, `status`) VALUES (50585244, '测试专栏', '测试专栏', 'https://test-blog.helloworld.net/static/img/281818326311.heic', '2024-08-16 07:51:14.189', '2024-08-16 07:52:09.015', '2024-08-16 07:51:14.189', 30);
COMMIT;

-- ----------------------------
-- Table structure for webmaster
-- ----------------------------
DROP TABLE IF EXISTS `webmaster`;
CREATE TABLE `webmaster` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `intro` longtext,
  `slogan` longtext,
  `nicker` longtext,
  `avatar` longtext,
  `job` longtext,
  `email` longtext,
  `qq` longtext,
  `wechat` longtext,
  `reward_code` longtext,
  `status` bigint DEFAULT NULL,
  `update_time` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of webmaster
-- ----------------------------
BEGIN;
INSERT INTO `webmaster` (`id`, `intro`, `slogan`, `nicker`, `avatar`, `job`, `email`, `qq`, `wechat`, `reward_code`, `status`, `update_time`) VALUES (1, '萌萌的博客', '做有价值的产品才是王道', '萌萌', 'https://test-blog.helloworld.net/static/img/435237564518.heic', '总裁', '123456@163.com', '1232132132', '12312312312', 'https://test-blog.helloworld.net/static/img/347000360279.heic', 1, '2024-08-16 09:08:26.662');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
后端软件开发
点赞
收藏
评论区
推荐文章
飞鹅官方账号 飞鹅官方账号
•
3个月前
二、飞鹅博客如何部署？
飞鹅博客如何部署？本文讲一下如何部署飞鹅系统，首先需要明白飞鹅系统的架构首先先熟悉一下飞鹅的特点一、飞鹅系统的特点飞鹅是一个前后端分离的项目飞鹅前端用vue技术栈，后端go技术栈，数据库为mysql飞鹅总共有3个源码库，分别是博客https://githu
2126
0
0
飞鹅官方账号 飞鹅官方账号
•
3个月前
一、关于飞鹅开源博客系统
飞鹅，会飞的鹅，寓意着对梦想的坚持，所以，我们的开源博客系统，就起名叫做飞鹅，英文名：flygoose下面正式介绍飞鹅开源博客项目飞鹅是什么？飞鹅是开发并且完全免费开源的一个项目，源码随便用随便改，没有任何限制，这个项目主要是为了帮助程序员能快速的搭建一个
1642
0
0
Wesley13 Wesley13
•
3年前
PPDB：今晚老齐直播
【今晚老齐直播】今晚（本周三晚）20:0021:00小白开始“用”飞桨(https://www.oschina.net/action/visit/ad?id1185)由PPDE（飞桨(https://www.oschina.net/action/visit/ad?id1185)开发者专家计划）成员老齐，为深度学习小白指点迷津。
1005
0
0
Peter20 Peter20
•
3年前
mysql中like用法
like的通配符有两种%（百分号）：代表零个、一个或者多个字符。\（下划线）：代表一个数字或者字符。1\.name以"李"开头wherenamelike'李%'2\.name中包含"云"，“云”可以在任何位置wherenamelike'%云%'3\.第二个和第三个字符是0的值wheresalarylike'\00%'4\
1601
0
0
Wesley13 Wesley13
•
3年前
VBox 启动虚拟机失败
在Vbox（5.0.8版本）启动Ubuntu的虚拟机时，遇到错误信息：NtCreateFile(\\Device\\VBoxDrvStub)failed:0xc000000034STATUS\_OBJECT\_NAME\_NOT\_FOUND(0retries) (rc101)Makesurethekern
994
0
0
Wesley13 Wesley13
•
3年前
FLV文件格式
1.        FLV文件对齐方式FLV文件以大端对齐方式存放多字节整型。如存放数字无符号16位的数字300（0x012C），那么在FLV文件中存放的顺序是：|0x01|0x2C|。如果是无符号32位数字300（0x0000012C），那么在FLV文件中的存放顺序是：|0x00|0x00|0x00|0x01|0x2C。2.  
1183
0
0
Wesley13 Wesley13
•
3年前
mysql设置时区
mysql设置时区mysql\_query("SETtime\_zone'8:00'")ordie('时区设置失败，请联系管理员！');中国在东8区所以加8方法二：selectcount(user\_id)asdevice,CONVERT\_TZ(FROM\_UNIXTIME(reg\_time),'08:00','0
1317
0
0
Wesley13 Wesley13
•
3年前
PHP创建多级树型结构
<!lang:php<?php$areaarray(array('id'1,'pid'0,'name''中国'),array('id'5,'pid'0,'name''美国'),array('id'2,'pid'1,'name''吉林'),array('id'4,'pid'2,'n
1239
0
0
Wesley13 Wesley13
•
3年前
MySQL部分从库上面因为大量的临时表tmp_table造成慢查询
背景描述Time:20190124T00:08:14.70572408:00User@Host:@Id:Schema:sentrymetaLast_errno:0Killed:0Query_time:0.315758Lock_
1519
0
0
京东云开发者 京东云开发者
•
1年前
为什么mysql不推荐使用雪花ID作为主键
作者：毛辰飞背景在mysql中设计表的时候，mysql官方推荐不要使用uuid或者不连续不重复的雪花id(long形且唯一)，而是推荐连续自增的主键id，官方的推荐是auto_increment，那么为什么不建议采用uuid，使用uuid究
1038
0
0
飞鹅官方账号
飞鹅官方账号
Lv1
男 · 上海待兔科技有限责任公司 · CTO
飞鹅开源博客系统，帮助开发者建立自己的独立博客，官方网站：https://flygoose.helloworld.net
文章
5
粉丝
11
获赞
0
热门文章
二、飞鹅博客如何部署？
一、关于飞鹅开源博客系统
四、飞鹅后端管理系统API接口文档
五、飞鹅官网API接口文档