homework.sql

/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50725
 Source Host           : localhost:3306
 Source Schema         : homework

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

 Date: 27/11/2022 09:29:47
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for blog
-- ----------------------------
DROP TABLE IF EXISTS `blog`;
CREATE TABLE `blog`  (
  `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `pic` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `des` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `date` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of blog
-- ----------------------------
INSERT INTO `blog` VALUES ('sdsadas', '0.9615902812756949.png', 1, 'dasdas', '2022-11-07 20:02:22');
INSERT INTO `blog` VALUES ('sdsdas', '0.5741128459212652.jpg', 2, 'sdasdas', '2022-11-10 20:07:52');
INSERT INTO `blog` VALUES ('sdasdasd', '0.9754260401667345.jpg', 3, 'sdasdasdas', '2022-11-10 20:38:40');
INSERT INTO `blog` VALUES ('sdasdassdas', '0.49574192224525926.jpg', 4, 'dasdasdasdas', '2022-11-11 16:34:01');
INSERT INTO `blog` VALUES ('sdasdasdasd', '0.5857291008458718.PNG', 5, 'sdasdas', '2022-11-11 21:07:15');
INSERT INTO `blog` VALUES ('ASDASAAA', '0.3365519683071161.jpg', 6, 'DDDDDDD', '2022-11-21 13:20:39');
INSERT INTO `blog` VALUES ('airjordon5', '0.4767036595402554.PNG', 7, 'jorndon5', '2022-11-26 23:50:37');
INSERT INTO `blog` VALUES ('sdsdasda', '0.1429265822790542.png', 8, 'sdasdas', '2022-11-27 00:30:40');

-- ----------------------------
-- Table structure for comment
-- ----------------------------
DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `pic` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `user` int(255) NULL DEFAULT NULL,
  `date` datetime NULL DEFAULT NULL,
  `related` int(255) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `related`(`related`) USING BTREE,
  CONSTRAINT `comment_ibfk_1` FOREIGN KEY (`related`) REFERENCES `topic` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 24 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of comment
-- ----------------------------
INSERT INTO `comment` VALUES (1, 'SDASDASDA', '0.5720315268712344.jpg', 1, '2022-11-11 13:20:19', 3);
INSERT INTO `comment` VALUES (2, 'SSDSDASDASDA', '0.9229349184199207.jpg', 1, '2022-11-11 13:21:56', 3);
INSERT INTO `comment` VALUES (3, 'SSDSDASDASDA', '0.6087980149019281.jpg', 1, '2022-11-11 13:23:59', 3);
INSERT INTO `comment` VALUES (4, 'sdasdas', '0.15137207439211542.PNG', 1, '2022-11-11 13:30:40', 3);
INSERT INTO `comment` VALUES (5, 'sdasdas', '0.9201090504285843.jpg', 1, '2022-11-11 13:31:15', 3);
INSERT INTO `comment` VALUES (6, 'sdasdasd', '0.3255919954200128.PNG', 1, '2022-11-11 13:32:15', 2);
INSERT INTO `comment` VALUES (7, 'sdasdasdsdsa', '0.9165116932515904.png', 1, '2022-11-11 13:32:30', 2);
INSERT INTO `comment` VALUES (8, 'sdasdasdsdsa', '0.24388212318841562.png', 1, '2022-11-11 13:32:35', 2);
INSERT INTO `comment` VALUES (9, 'sdasdasdsdsasdas', '0.3106764085962008.jpg', 1, '2022-11-11 13:32:47', 2);
INSERT INTO `comment` VALUES (10, 'sdasdasdsdsasdasss', '0.6270222446833988.PNG', 1, '2022-11-11 13:32:59', 2);
INSERT INTO `comment` VALUES (11, 'sdasdasdasd', '0.1989723630257263.PNG', 1, '2022-11-11 16:34:30', 4);
INSERT INTO `comment` VALUES (12, 'sdasdasdasdsdasdas', '0.4252273115326404.PNG', 1, '2022-11-11 16:34:35', 4);
INSERT INTO `comment` VALUES (13, 'sdasdasdasdsdasdassdasd', '0.8250482738987601.PNG', 1, '2022-11-11 16:34:51', 4);
INSERT INTO `comment` VALUES (14, 'sdfsdfsd', '0.18353728314348894.PNG', 1, '2022-11-11 21:47:57', 1);
INSERT INTO `comment` VALUES (18, 'wow cool', '0.1538471601492022.png', 1, '2022-11-27 00:16:24', 5);
INSERT INTO `comment` VALUES (19, 'sdsa', '0.3573624307203991.png', 1, '2022-11-27 00:16:45', 5);
INSERT INTO `comment` VALUES (20, 'sdasdas', '0.6396108715037634.PNG', 1, '2022-11-27 00:22:08', 5);
INSERT INTO `comment` VALUES (21, 'weqweq', '0.8001257423691552.png', 1, '2022-11-27 00:23:26', 5);
INSERT INTO `comment` VALUES (22, 'sdasdas', '0.475052725039365.png', 1, '2022-11-27 00:23:48', 3);
INSERT INTO `comment` VALUES (23, 'dsdsadasd', '0.4731907153647903.PNG', 1, '2022-11-27 00:31:41', 6);

-- ----------------------------
-- Table structure for pic
-- ----------------------------
DROP TABLE IF EXISTS `pic`;
CREATE TABLE `pic`  (
  `Pic` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Related` int(255) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `Related`(`Related`) USING BTREE,
  CONSTRAINT `pic_ibfk_1` FOREIGN KEY (`Related`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of pic
-- ----------------------------
INSERT INTO `pic` VALUES ('0.46750863526486786.png', 3, 1);
INSERT INTO `pic` VALUES ('0.8865286234148406.PNG', 4, 1);
INSERT INTO `pic` VALUES ('0.9986945798446911.PNG', 5, 1);
INSERT INTO `pic` VALUES ('0.514375462966981.jpg', 6, 1);
INSERT INTO `pic` VALUES ('0.6179276862480017.jpg', 7, 1);
INSERT INTO `pic` VALUES ('0.3362883455411618.PNG', 8, 1);
INSERT INTO `pic` VALUES ('0.8862599333660208.jpg', 9, 1);
INSERT INTO `pic` VALUES ('0.9374343051303049.PNG', 10, 1);
INSERT INTO `pic` VALUES ('0.2994208593491743.png', 11, 1);
INSERT INTO `pic` VALUES ('0.5299651374814922.png', 12, 1);
INSERT INTO `pic` VALUES ('0.14256595794408256.jpg', 13, 1);
INSERT INTO `pic` VALUES ('0.43817326677573076.jpg', 14, 1);
INSERT INTO `pic` VALUES ('0.6906808285882566.png', 15, 1);
INSERT INTO `pic` VALUES ('0.21773624012988968.png', 16, 1);
INSERT INTO `pic` VALUES ('0.68200137185725.jpg', 17, 1);
INSERT INTO `pic` VALUES ('0.22585363731909247.jpg', 18, 1);
INSERT INTO `pic` VALUES ('0.05872030197894795.png', 19, 1);
INSERT INTO `pic` VALUES ('0.08479015273709822.PNG', 20, 1);

-- ----------------------------
-- Table structure for topic
-- ----------------------------
DROP TABLE IF EXISTS `topic`;
CREATE TABLE `topic`  (
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pic` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `related` int(255) NULL DEFAULT NULL,
  `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `user` int(255) NOT NULL,
  `date` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `related`(`related`) USING BTREE,
  INDEX `user`(`user`) USING BTREE,
  CONSTRAINT `topic_ibfk_1` FOREIGN KEY (`related`) REFERENCES `blog` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `topic_ibfk_2` FOREIGN KEY (`user`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of topic
-- ----------------------------
INSERT INTO `topic` VALUES ('sdasd', 1, '0.6257305663016743.PNG', 1, 'dasdas', 1, '2022-11-08 10:49:10');
INSERT INTO `topic` VALUES ('ssdasdas', 2, '0.6414826830659348.PNG', 2, 'sdsadas', 1, '2022-11-10 20:37:51');
INSERT INTO `topic` VALUES ('zxzxzx', 3, '0.31705022447506925.png', 3, 'zxzx', 1, '2022-11-10 20:42:04');
INSERT INTO `topic` VALUES ('sdasdasdas', 4, '0.3907362936331038.PNG', 4, 'asdasdasdasd', 1, '2022-11-11 16:34:18');
INSERT INTO `topic` VALUES ('aj5 vigil', 5, '0.5812716253430763.PNG', 7, 'with offwhite', 1, '2022-11-26 23:52:19');
INSERT INTO `topic` VALUES ('sdsdas', 6, '0.21124674265374854.PNG', 8, 'sdasdas', 1, '2022-11-27 00:31:19');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('user1', 'p455w0rd', 1, 'user');
INSERT INTO `user` VALUES ('user2', 'sdsdas', 2, 'user');

SET FOREIGN_KEY_CHECKS = 1;