blog.sql · 斑/Blog

Fetch the repository succeeded.

Scan WeChat QR to Pay

Cancel

Complete

richgiteeai

Watch

Unwatch Watching Releases Only Ignoring

1 Star 0 Fork 2

斑/Blog

forked from wangxy/Blog

Code Issues 0 Pull Requests 0 Wiki Insights Pipelines

Service

Tencent Cloud Serverless

Create your Gitee Account

Explore and code with more than 14 million developers,Free private repositories !:)

Already have an account? Sign in

文件

master

Branches (1)

Manage

master

Clone or Download

Clone/Download

HTTPS SSH SVN SVN+SSH Download ZIP

Prompt

To download the code, please copy the following command and execute it in the terminal

To ensure that your submitted code identity is correctly recognized by Gitee, please execute the following command.

git config --global user.name userName 
git config --global user.email userEmail

When using the SSH protocol for the first time to clone or push code, follow the prompts below to complete the SSH configuration.

1 Generate RSA keys.

2 Obtain the content of the RSA public key and configure it in SSH Public Keys

To use SVN on Gitee, please visit the usage guide

When using the HTTPS protocol, the command line will prompt for account and password verification as follows. For security reasons, Gitee recommends configure and use personal access tokens instead of login passwords for cloning, pushing, and other operations.

Username for 'https://gitee.com': userName

Password for 'https://userName@gitee.com': # Private Token

Branches 1

Tags 0

Blog

blog.sql

blog.sql 6.72 KB

SET NAMES utf8mb4;

-- ----------------------------
-- Table structure for article
-- ----------------------------
DROP TABLE IF EXISTS `article`;
CREATE TABLE `article` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
 `synopsis` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
 `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
 `category_id` int(11) NULL DEFAULT NULL,
 `created_time` datetime(0) NULL DEFAULT NULL,
 `view_count` int(11) NULL DEFAULT 0,
 `comment_count` int(11) NULL DEFAULT 0,
 PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for category
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `icon` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
 `name` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
 `sequence` int(11) NULL DEFAULT NULL,
 PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 33 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of category
-- ----------------------------
INSERT INTO `category` VALUES (1, '/icon/java.png', 'JAVA', 1);
INSERT INTO `category` VALUES (2, '/icon/cpp.png', 'C++', 2);
INSERT INTO `category` VALUES (3, '/icon/python.png', 'Python', 3);
INSERT INTO `category` VALUES (4, '/icon/golang.png', 'Golang', 4);
INSERT INTO `category` VALUES (5, '/icon/android.png', 'Android', 5);
INSERT INTO `category` VALUES (6, '/icon/linux.png', 'Linux', 6);
INSERT INTO `category` VALUES (7, '/icon/windows.png', 'Windows', 7);
INSERT INTO `category` VALUES (8, '/icon/miniprogram.png', '小程序', 8);
INSERT INTO `category` VALUES (9, '/icon/spring.png', 'Spring', 9);
INSERT INTO `category` VALUES (10, '/icon/springboot.png', 'SpringBoot', 10);
INSERT INTO `category` VALUES (11, '/icon/springcloud.png', 'SpringCloud', 11);
INSERT INTO `category` VALUES (12, '/icon/springsecurity.png', 'SpringSecurity', 12);
INSERT INTO `category` VALUES (13, '/icon/mybatis.png', 'Mybatis', 13);
INSERT INTO `category` VALUES (14, '/icon/hibernate.png', 'Hibernate', 14);
INSERT INTO `category` VALUES (15, '/icon/kafka.png', 'Kafka', 15);
INSERT INTO `category` VALUES (16, '/icon/zookeeper.png', 'Zookeeper', 16);
INSERT INTO `category` VALUES (17, '/icon/html.png', 'HTML', 17);
INSERT INTO `category` VALUES (18, '/icon/css.png', 'CSS', 18);
INSERT INTO `category` VALUES (19, '/icon/javascript.png', 'JavaScript', 19);
INSERT INTO `category` VALUES (20, '/icon/typescript.png', 'TypeScript', 20);
INSERT INTO `category` VALUES (21, '/icon/vue.png', 'Vue', 21);
INSERT INTO `category` VALUES (22, '/icon/nuxt.png', 'Nuxt', 22);
INSERT INTO `category` VALUES (23, '/icon/elementui.png', 'ElementUI', 23);
INSERT INTO `category` VALUES (24, '/icon/bootstrap.png', 'Bootstrap', 24);
INSERT INTO `category` VALUES (25, '/icon/nginx.png', 'Nginx', 25);
INSERT INTO `category` VALUES (26, '/icon/nodejs.png', 'Nodejs', 26);
INSERT INTO `category` VALUES (27, '/icon/mysql.png', 'Mysql', 27);
INSERT INTO `category` VALUES (28, '/icon/redis.png', 'Redis', 28);
INSERT INTO `category` VALUES (29, '/icon/git.png', 'Git', 29);
INSERT INTO `category` VALUES (30, '/icon/maven.png', 'Maven', 30);
INSERT INTO `category` VALUES (31, '/icon/docker.png', 'Docker', 31);
INSERT INTO `category` VALUES (32, '/icon/algorithm.png', '算法题解', 32);

-- ----------------------------
-- Table structure for comment
-- ----------------------------
DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
 `user_id` int(11) NULL DEFAULT NULL,
 `article_id` int(11) NULL DEFAULT NULL,
 `created_time` datetime(0) NULL DEFAULT NULL,
 PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for persistent_logins
-- ----------------------------
DROP TABLE IF EXISTS `persistent_logins`;
CREATE TABLE `persistent_logins` (
 `username` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
 `series` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
 `token` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
 `last_used` timestamp(0) NOT NULL,
 PRIMARY KEY (`series`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `name` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
 PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of role
-- ----------------------------
INSERT INTO `role` VALUES (1, 'admin');
INSERT INTO `role` VALUES (2, 'member');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `email` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
 `username` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
 `password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
 PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, 'admin@linter.cn', 'Linter', '2ドルa10ドル$Bvh6sSkAdNgwIgEyHvTY5OVcmyEfiss3LcJDYUNygeuYZtBArewHK');

-- ----------------------------
-- Table structure for user_role
-- ----------------------------
DROP TABLE IF EXISTS `user_role`;
CREATE TABLE `user_role` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `user_id` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
 `role_id` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
 PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user_role
-- ----------------------------
INSERT INTO `user_role` VALUES (1, '1', '1');

Copy Edit Raw Blame History

wangxiaoyang authored 2020年08月16日 15:59 +08:00 . 修改初始账号信息

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 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139

SET NAMES utf8mb4;

-- ----------------------------
-- Table structure for article
-- ----------------------------
DROP TABLE IF EXISTS `article`;
CREATE TABLE `article` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
 `synopsis` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
 `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
 `category_id` int(11) NULL DEFAULT NULL,
 `created_time` datetime(0) NULL DEFAULT NULL,
 `view_count` int(11) NULL DEFAULT 0,
 `comment_count` int(11) NULL DEFAULT 0,
 PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for category
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `icon` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
 `name` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
 `sequence` int(11) NULL DEFAULT NULL,
 PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 33 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of category
-- ----------------------------
INSERT INTO `category` VALUES (1, '/icon/java.png', 'JAVA', 1);
INSERT INTO `category` VALUES (2, '/icon/cpp.png', 'C++', 2);
INSERT INTO `category` VALUES (3, '/icon/python.png', 'Python', 3);
INSERT INTO `category` VALUES (4, '/icon/golang.png', 'Golang', 4);
INSERT INTO `category` VALUES (5, '/icon/android.png', 'Android', 5);
INSERT INTO `category` VALUES (6, '/icon/linux.png', 'Linux', 6);
INSERT INTO `category` VALUES (7, '/icon/windows.png', 'Windows', 7);
INSERT INTO `category` VALUES (8, '/icon/miniprogram.png', '小程序', 8);
INSERT INTO `category` VALUES (9, '/icon/spring.png', 'Spring', 9);
INSERT INTO `category` VALUES (10, '/icon/springboot.png', 'SpringBoot', 10);
INSERT INTO `category` VALUES (11, '/icon/springcloud.png', 'SpringCloud', 11);
INSERT INTO `category` VALUES (12, '/icon/springsecurity.png', 'SpringSecurity', 12);
INSERT INTO `category` VALUES (13, '/icon/mybatis.png', 'Mybatis', 13);
INSERT INTO `category` VALUES (14, '/icon/hibernate.png', 'Hibernate', 14);
INSERT INTO `category` VALUES (15, '/icon/kafka.png', 'Kafka', 15);
INSERT INTO `category` VALUES (16, '/icon/zookeeper.png', 'Zookeeper', 16);
INSERT INTO `category` VALUES (17, '/icon/html.png', 'HTML', 17);
INSERT INTO `category` VALUES (18, '/icon/css.png', 'CSS', 18);
INSERT INTO `category` VALUES (19, '/icon/javascript.png', 'JavaScript', 19);
INSERT INTO `category` VALUES (20, '/icon/typescript.png', 'TypeScript', 20);
INSERT INTO `category` VALUES (21, '/icon/vue.png', 'Vue', 21);
INSERT INTO `category` VALUES (22, '/icon/nuxt.png', 'Nuxt', 22);
INSERT INTO `category` VALUES (23, '/icon/elementui.png', 'ElementUI', 23);
INSERT INTO `category` VALUES (24, '/icon/bootstrap.png', 'Bootstrap', 24);
INSERT INTO `category` VALUES (25, '/icon/nginx.png', 'Nginx', 25);
INSERT INTO `category` VALUES (26, '/icon/nodejs.png', 'Nodejs', 26);
INSERT INTO `category` VALUES (27, '/icon/mysql.png', 'Mysql', 27);
INSERT INTO `category` VALUES (28, '/icon/redis.png', 'Redis', 28);
INSERT INTO `category` VALUES (29, '/icon/git.png', 'Git', 29);
INSERT INTO `category` VALUES (30, '/icon/maven.png', 'Maven', 30);
INSERT INTO `category` VALUES (31, '/icon/docker.png', 'Docker', 31);
INSERT INTO `category` VALUES (32, '/icon/algorithm.png', '算法题解', 32);

-- ----------------------------
-- Table structure for comment
-- ----------------------------
DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
 `user_id` int(11) NULL DEFAULT NULL,
 `article_id` int(11) NULL DEFAULT NULL,
 `created_time` datetime(0) NULL DEFAULT NULL,
 PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for persistent_logins
-- ----------------------------
DROP TABLE IF EXISTS `persistent_logins`;
CREATE TABLE `persistent_logins` (
 `username` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
 `series` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
 `token` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
 `last_used` timestamp(0) NOT NULL,
 PRIMARY KEY (`series`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `name` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
 PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of role
-- ----------------------------
INSERT INTO `role` VALUES (1, 'admin');
INSERT INTO `role` VALUES (2, 'member');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `email` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
 `username` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
 `password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
 PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, 'admin@linter.cn', 'Linter', '2ドルa10ドル$Bvh6sSkAdNgwIgEyHvTY5OVcmyEfiss3LcJDYUNygeuYZtBArewHK');

-- ----------------------------
-- Table structure for user_role
-- ----------------------------
DROP TABLE IF EXISTS `user_role`;
CREATE TABLE `user_role` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `user_id` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
 `role_id` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
 PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user_role
-- ----------------------------
INSERT INTO `user_role` VALUES (1, '1', '1');