-
Notifications
You must be signed in to change notification settings - Fork 0
/
table.sql
98 lines (87 loc) · 4.84 KB
/
table.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
/*
Navicat Premium Data Transfer
Source Server : golang
Source Server Type : MySQL
Source Server Version : 80011
Source Host : localhost:3306
Source Schema : blogger
Target Server Type : MySQL
Target Server Version : 80011
File Encoding : 65001
Date: 12/08/2018 16:54:50
*/
DROP DATABASE IF EXISTS `oblog`;
CREATE DATABASE IF NOT EXISTS `oblog` DEFAULT CHARACTER SET 'utf8mb4' DEFAULT COLLATE 'utf8mb4_unicode_ci';
USE `oblog`;
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for article
-- ----------------------------
DROP TABLE IF EXISTS `article`;
CREATE TABLE `article` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '文章id',
`category_id` bigint(20) UNSIGNED NOT NULL COMMENT '分类id',
`content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文章内容',
`title` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文章标题',
`view_count` int(255) UNSIGNED NOT NULL COMMENT '阅读次数',
`comment_count` int(255) UNSIGNED NOT NULL COMMENT '评论次数',
`username` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '作者',
`status` int(10) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态',
`summary` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文章摘要',
`create_at` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '发布时间',
`update_at` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_view_count`(`view_count`) USING BTREE COMMENT '阅读次数索引',
INDEX `idx_comment_count`(`comment_count`) USING BTREE COMMENT '评论数索引',
INDEX `idx_category_id`(`category_id`) USING BTREE COMMENT '分类id索引'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for category
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '分类名字',
`number` int(10) UNSIGNED NOT NULL COMMENT '分类排序',
`create_at` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP,
`update_at` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0),
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of category
-- ----------------------------
INSERT INTO `category` VALUES (1, 'css/html', 1, '2018-08-12 10:55:45', '2018-08-12 10:59:00');
INSERT INTO `category` VALUES (2, '后端开发', 2, '2018-08-12 10:56:07', '2018-08-12 10:59:03');
INSERT INTO `category` VALUES (3, 'Java开发', 3, '2018-08-12 10:56:16', '2018-08-12 10:59:05');
INSERT INTO `category` VALUES (4, 'C++开发', 4, '2018-08-12 10:56:24', '2018-08-12 10:59:08');
INSERT INTO `category` VALUES (5, '架构剖析', 5, '2018-08-12 10:56:36', '2018-08-12 10:59:10');
INSERT INTO `category` VALUES (6, 'Golang开发', 6, '2018-08-12 10:56:45', '2018-08-12 10:59:14');
-- ----------------------------
-- Table structure for comment
-- ----------------------------
DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment` (
`id` bigint(20) UNSIGNED NOT NULL COMMENT '评论id',
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '评论内容',
`username` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '评论作者',
`create_at` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '评论发布时间',
`status` int(255) UNSIGNED NOT NULL COMMENT '评论状态: 0, 删除;1, 正常',
`article_id` bigint(20) UNSIGNED NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for leave
-- ----------------------------
DROP TABLE IF EXISTS `leave`;
CREATE TABLE `leave` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`create_at` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_at` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0),
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
SET FOREIGN_KEY_CHECKS = 1;
grant all on oblog.* to oblog@'%' identified by 'qwe123!@#QWE';