master

分支 (1)

管理

管理

master

layui_springboot
/
sql

/*
 Navicat Premium Data Transfer

 Source Server         : study
 Source Server Type    : MySQL
 Source Server Version : 80020
 Source Host           : localhost:3306
 Source Schema         : m_blog

 Target Server Type    : MySQL
 Target Server Version : 80020
 File Encoding         : 65001

 Date: 30/10/2020 19:54:49
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for m_blog
-- ----------------------------
DROP TABLE IF EXISTS `m_blog`;
CREATE TABLE `m_blog`  (
  `bid` bigint(0) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(0) NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `begintime` datetime(0) NOT NULL ON UPDATE CURRENT_TIMESTAMP(0),
  `updatetime` datetime(0) DEFAULT NULL,
  `deleted` int(0) DEFAULT NULL,
  PRIMARY KEY (`bid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 127 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of m_blog
-- ----------------------------
INSERT INTO `m_blog` VALUES (126, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', NULL);
INSERT INTO `m_blog` VALUES (177, 1, '你好', '2.jpg', '          1231231      ', '2020-10-02 16:29:22', '2020-10-14 18:02:38', NULL);
INSERT INTO `m_blog` VALUES (178, 1, 'cccc', '2.jpg', '          1231231      ', '2020-10-14 18:08:37', '2020-10-23 18:02:38', 0);
INSERT INTO `m_blog` VALUES (179, 1, 'bbb', '2.jpg', '          1231231      ', '2020-10-30 18:08:35', '2020-10-30 18:02:38', 0);
INSERT INTO `m_blog` VALUES (180, 1, 'aaa', '2.jpg', '          1231231      ', '2020-10-14 18:08:32', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (181, 1, '你好', '2.jpg', '          1231231      ', '2020-10-22 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (182, 1, '你好', '2.jpg', '          1231231      ', '2020-10-22 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (183, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (184, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (185, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (186, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (187, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (188, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (189, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (190, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (191, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (192, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (193, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (194, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (195, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (196, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (197, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (198, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (199, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (200, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (201, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (202, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (203, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (204, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (205, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (206, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (207, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (208, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (209, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (210, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (211, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (212, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (213, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (214, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (215, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (216, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (217, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (218, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (219, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (220, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (221, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (222, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (223, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (224, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (225, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);
INSERT INTO `m_blog` VALUES (226, 1, '你好', '2.jpg', '          1231231      ', '2020-10-01 16:29:22', '2020-10-22 18:02:38', 0);

-- ----------------------------
-- Table structure for m_user
-- ----------------------------
DROP TABLE IF EXISTS `m_user`;
CREATE TABLE `m_user`  (
  `id` bigint(0) NOT NULL AUTO_INCREMENT,
  `username` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `avatar` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `email` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `password` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `status` int(0) NOT NULL,
  `created` datetime(0) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `UK_USERNAME`(`username`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of m_user
-- ----------------------------
INSERT INTO `m_user` VALUES (1, 'zhangsan', '2.jpg', '你好         ', '484235492@qq.com', '123', 1, '2020-10-28 09:21:10');

SET FOREIGN_KEY_CHECKS = 1;