HelloWorld
登录

三、飞鹅开源博客SQL语句

飞鹅官方账号

2024-08-21

2158 1 0

以下是飞鹅数据库的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;
点赞
收藏

评论区

加载中...

相关推荐

Oracle 分组与拼接字符串同时使用

SELECTT.,ROWNUMIDFROM(SELECTT.EMPLID,T.NAME,T.BU,T.REALDEPART,T.FORMATDATE,SUM(T.S0)S0,MAX(UPDATETIME)CREATETIME,LISTAGG(TOCHAR(

MySQL部分从库上面因为大量的临时表tmp_table造成慢查询

背景描述Time:20190124T00:08:14.70572408:00User@Host:@Id:Schema:sentrymetaLast_errno:0Killed:0Query_time:0.315758Lock_

一、关于飞鹅开源博客系统

飞鹅，会飞的鹅，寓意着对梦想的坚持，所以，我们的开源博客系统，就起名叫做飞鹅，英文名：flygoose下面正式介绍飞鹅开源博客项目飞鹅是什么？飞鹅是开发并且完全免费开源的一个项目，源码随便用随便改，没有任何限制，这个项目主要是为了帮助程序员能快速的搭建一个

二、飞鹅博客如何部署？

飞鹅博客如何部署？本文讲一下如何部署飞鹅系统，首先需要明白飞鹅系统的架构首先先熟悉一下飞鹅的特点一、飞鹅系统的特点飞鹅是一个前后端分离的项目飞鹅前端用vue技术栈，后端go技术栈，数据库为mysql飞鹅总共有3个源码库，分别是博客https://githu

PPDB：今晚老齐直播

【今晚老齐直播】今晚（本周三晚）20:0021:00小白开始“用”飞桨(https://www.oschina.net/action/visit/ad?id1185)由PPDE（飞桨(https://www.oschina.net/action/visit/ad?id1185)开发者专家计划）成员老齐，为深度学习小白指点迷津。

mysql中like用法

like的通配符有两种%（百分号）：代表零个、一个或者多个字符。\（下划线）：代表一个数字或者字符。1\.name以"李"开头wherenamelike'李%'2\.name中包含"云"，“云”可以在任何位置wherenamelike'%云%'3\.第二个和第三个字符是0的值wheresalarylike'\00%'4\