三、飞鹅开源博客SQL语句

以下是飞鹅数据库的SQL，直接连接mysql8.0 ，执行即可
默认admin表会插入一个管理员手机号：12345678901 密码：123456
mysql SQL语句如下：

1/*
2 Navicat Premium Data Transfer
3
4 Source Server         : hw-dev
5 Source Server Type    : MySQL
6 Source Server Version : 80019 (8.0.19)
7 Source Host           : 192.168.168.166:3306
8 Source Schema         : db_09
9
10 Target Server Type    : MySQL
11 Target Server Version : 80019 (8.0.19)
12 File Encoding         : 65001
13
14 Date: 21/08/2024 22:53:43
15*/
16
17SET NAMES utf8mb4;
18SET FOREIGN_KEY_CHECKS = 0;
19
20-- ----------------------------
21-- Table structure for admin
22-- ----------------------------
23DROP TABLE IF EXISTS `admin`;
24CREATE TABLE `admin` (
25  `id` bigint NOT NULL AUTO_INCREMENT,
26  `phone` longtext,
27  `password` longtext,
28  `nicker` longtext,
29  `avatar` longtext,
30  `token` longtext,
31  `create_time` datetime(3) DEFAULT NULL,
32  `valid_time` datetime(3) DEFAULT NULL,
33  `login_time` datetime(3) DEFAULT NULL,
34  `status` bigint DEFAULT NULL,
35  PRIMARY KEY (`id`)
36) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
37
38-- ----------------------------
39-- Records of admin
40-- ----------------------------
41BEGIN;
42INSERT 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);
43COMMIT;
44
45-- ----------------------------
46-- Table structure for banner
47-- ----------------------------
48DROP TABLE IF EXISTS `banner`;
49CREATE TABLE `banner` (
50  `id` bigint NOT NULL AUTO_INCREMENT,
51  `title` longtext,
52  `url` longtext,
53  `target_url` longtext,
54  `seq` bigint DEFAULT NULL,
55  `create_time` datetime(3) DEFAULT NULL,
56  `status` bigint DEFAULT NULL,
57  PRIMARY KEY (`id`)
58) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
59
60-- ----------------------------
61-- Records of banner
62-- ----------------------------
63BEGIN;
64INSERT 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);
65INSERT 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);
66INSERT 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);
67COMMIT;
68
69-- ----------------------------
70-- Table structure for blog
71-- ----------------------------
72DROP TABLE IF EXISTS `blog`;
73CREATE TABLE `blog` (
74  `id` bigint NOT NULL AUTO_INCREMENT,
75  `title` longtext,
76  `intro` longtext,
77  `content` longtext,
78  `html` longtext,
79  `is_html` bigint DEFAULT NULL,
80  `is_top` bigint DEFAULT NULL,
81  `read_count` bigint DEFAULT NULL,
82  `create_time` datetime(3) DEFAULT NULL,
83  `update_time` datetime(3) DEFAULT NULL,
84  `publish_time` datetime(3) DEFAULT NULL,
85  `thumbnail` longtext,
86  `status` bigint DEFAULT NULL,
87  `cate_id` bigint DEFAULT NULL,
88  `tags` longtext,
89  PRIMARY KEY (`id`)
90) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
91
92-- ----------------------------
93-- Records of blog
94-- ----------------------------
95BEGIN;
96INSERT 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');
97INSERT 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, '');
98INSERT 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, '');
99INSERT 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, '');
100INSERT 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, '');
101INSERT 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, '');
102INSERT 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, '');
103INSERT 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, '');
104INSERT 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, '');
105INSERT 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, '');
106INSERT 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, '');
107COMMIT;
108
109-- ----------------------------
110-- Table structure for category
111-- ----------------------------
112DROP TABLE IF EXISTS `category`;
113CREATE TABLE `category` (
114  `id` bigint NOT NULL AUTO_INCREMENT,
115  `name` longtext,
116  `seq` bigint DEFAULT NULL,
117  `icon` longtext,
118  `font` longtext,
119  `color` longtext,
120  `create_time` datetime(3) DEFAULT NULL,
121  `update_time` datetime(3) DEFAULT NULL,
122  `status` bigint DEFAULT NULL,
123  PRIMARY KEY (`id`)
124) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
125
126-- ----------------------------
127-- Records of category
128-- ----------------------------
129BEGIN;
130INSERT 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);
131INSERT 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);
132COMMIT;
133
134-- ----------------------------
135-- Table structure for link
136-- ----------------------------
137DROP TABLE IF EXISTS `link`;
138CREATE TABLE `link` (
139  `id` bigint NOT NULL AUTO_INCREMENT,
140  `title` longtext,
141  `url` longtext,
142  `seq` bigint DEFAULT NULL,
143  `create_time` datetime(3) DEFAULT NULL,
144  `update_time` datetime(3) DEFAULT NULL,
145  `valid_time` datetime(3) DEFAULT NULL,
146  `remark` longtext,
147  `status` bigint DEFAULT NULL,
148  PRIMARY KEY (`id`)
149) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
150
151-- ----------------------------
152-- Records of link
153-- ----------------------------
154BEGIN;
155INSERT 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);
156COMMIT;
157
158-- ----------------------------
159-- Table structure for notice
160-- ----------------------------
161DROP TABLE IF EXISTS `notice`;
162CREATE TABLE `notice` (
163  `id` bigint NOT NULL AUTO_INCREMENT,
164  `title` longtext,
165  `content` longtext,
166  `create_time` datetime(3) DEFAULT NULL,
167  `update_time` datetime(3) DEFAULT NULL,
168  `valid_time` datetime(3) DEFAULT NULL,
169  `status` bigint DEFAULT NULL,
170  PRIMARY KEY (`id`)
171) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
172
173-- ----------------------------
174-- Records of notice
175-- ----------------------------
176BEGIN;
177INSERT 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);
178COMMIT;
179
180-- ----------------------------
181-- Table structure for section
182-- ----------------------------
183DROP TABLE IF EXISTS `section`;
184CREATE TABLE `section` (
185  `id` bigint NOT NULL AUTO_INCREMENT,
186  `title` longtext,
187  `intro` longtext,
188  `content` longtext,
189  `html` longtext,
190  `tags` longtext,
191  `is_html` bigint DEFAULT NULL,
192  `read_count` bigint DEFAULT NULL,
193  `special_id` bigint DEFAULT NULL,
194  `seq` bigint DEFAULT NULL,
195  `create_time` datetime(3) DEFAULT NULL,
196  `update_time` datetime(3) DEFAULT NULL,
197  `publish_time` datetime(3) DEFAULT NULL,
198  `status` bigint DEFAULT NULL,
199  PRIMARY KEY (`id`)
200) ENGINE=InnoDB AUTO_INCREMENT=15739452 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
201
202-- ----------------------------
203-- Records of section
204-- ----------------------------
205BEGIN;
206INSERT 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);
207INSERT 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);
208COMMIT;
209
210-- ----------------------------
211-- Table structure for site
212-- ----------------------------
213DROP TABLE IF EXISTS `site`;
214CREATE TABLE `site` (
215  `id` bigint NOT NULL AUTO_INCREMENT,
216  `title` longtext,
217  `intro` longtext,
218  `slogan` longtext,
219  `cover` longtext,
220  `copyright` longtext,
221  `icp` longtext,
222  `update_time` datetime(3) DEFAULT NULL,
223  `extra` longtext,
224  `status` bigint DEFAULT NULL,
225  PRIMARY KEY (`id`)
226) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
227
228-- ----------------------------
229-- Records of site
230-- ----------------------------
231BEGIN;
232INSERT 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);
233COMMIT;
234
235-- ----------------------------
236-- Table structure for special
237-- ----------------------------
238DROP TABLE IF EXISTS `special`;
239CREATE TABLE `special` (
240  `id` bigint NOT NULL AUTO_INCREMENT,
241  `title` longtext,
242  `intro` longtext,
243  `cover` longtext,
244  `create_time` datetime(3) DEFAULT NULL,
245  `update_time` datetime(3) DEFAULT NULL,
246  `publish_time` datetime(3) DEFAULT NULL,
247  `status` bigint DEFAULT NULL,
248  PRIMARY KEY (`id`)
249) ENGINE=InnoDB AUTO_INCREMENT=50585245 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
250
251-- ----------------------------
252-- Records of special
253-- ----------------------------
254BEGIN;
255INSERT 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);
256INSERT 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);
257COMMIT;
258
259-- ----------------------------
260-- Table structure for webmaster
261-- ----------------------------
262DROP TABLE IF EXISTS `webmaster`;
263CREATE TABLE `webmaster` (
264  `id` bigint NOT NULL AUTO_INCREMENT,
265  `intro` longtext,
266  `slogan` longtext,
267  `nicker` longtext,
268  `avatar` longtext,
269  `job` longtext,
270  `email` longtext,
271  `qq` longtext,
272  `wechat` longtext,
273  `reward_code` longtext,
274  `status` bigint DEFAULT NULL,
275  `update_time` datetime(3) DEFAULT NULL,
276  PRIMARY KEY (`id`)
277) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
278
279-- ----------------------------
280-- Records of webmaster
281-- ----------------------------
282BEGIN;
283INSERT 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');
284COMMIT;
285
286SET FOREIGN_KEY_CHECKS = 1;
287
三、飞鹅开源博客SQL语句

mysql SQL语句如下：

评论区

相关推荐
