/*
 Navicat MySQL Data Transfer

 Source Server         : mysql
 Source Server Type    : MySQL
 Source Server Version : 80030
 Source Host           : localhost:3306
 Source Schema         : visitchina

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

 Date: 31/08/2023 10:50:36
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for attractiontags
-- ----------------------------
DROP TABLE IF EXISTS `attractiontags`;
CREATE TABLE `attractiontags`  (
  `tags_id` int NOT NULL AUTO_INCREMENT COMMENT '标签id',
  `tags_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '标签名称',
  PRIMARY KEY (`tags_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of attractiontags
-- ----------------------------
INSERT INTO `attractiontags` VALUES (1, '湖泊风景');
INSERT INTO `attractiontags` VALUES (2, '山岳风景');
INSERT INTO `attractiontags` VALUES (3, '森林风景');
INSERT INTO `attractiontags` VALUES (4, '人文风景');
INSERT INTO `attractiontags` VALUES (5, '历史建筑');

-- ----------------------------
-- Table structure for blogger
-- ----------------------------
DROP TABLE IF EXISTS `blogger`;
CREATE TABLE `blogger`  (
  `blogger_id` int NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `account_id` int NULL DEFAULT NULL COMMENT '评论的用户id',
  `blogger_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '评论题目',
  `blogger_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '内容',
  `blogger_start_time` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '时间',
  `blogger_pic_path_one` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '图片路径',
  `blogger_pic_path_two` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `blogger_pic_path_three` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `blogger_pic_path_four` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `blogger_pic_path_five` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  PRIMARY KEY (`blogger_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of blogger
-- ----------------------------
INSERT INTO `blogger` VALUES (1, 1, '西安一日游', '今天我们来了西安', '2023-03-22 20:57:18', 'D://pice', NULL, NULL, NULL, NULL);

-- ----------------------------
-- Table structure for blogger_collect
-- ----------------------------
DROP TABLE IF EXISTS `blogger_collect`;
CREATE TABLE `blogger_collect`  (
  `blogger_collect_id` int NOT NULL AUTO_INCREMENT COMMENT '攻略收藏ID',
  `blogger_id` int NULL DEFAULT NULL COMMENT '攻略id',
  `account_id` int NULL DEFAULT NULL COMMENT '收藏者ID（用户ID）',
  `contributor_id` int NULL DEFAULT NULL COMMENT '贡献者id',
  PRIMARY KEY (`blogger_collect_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of blogger_collect
-- ----------------------------
INSERT INTO `blogger_collect` VALUES (1, 1, 2, 1);

-- ----------------------------
-- Table structure for comment
-- ----------------------------
DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment`  (
  `comment_id` int NOT NULL AUTO_INCREMENT COMMENT '评论id',
  `blogger_id` int NULL DEFAULT NULL COMMENT '评论属于那个攻略',
  `account_id` int NULL DEFAULT NULL COMMENT '用户ID',
  `comment_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '评论内容',
  `comment_time` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '评论时间',
  PRIMARY KEY (`comment_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

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

-- ----------------------------
-- Table structure for scenicspot
-- ----------------------------
DROP TABLE IF EXISTS `scenicspot`;
CREATE TABLE `scenicspot`  (
  `scenicspot_id` int NOT NULL AUTO_INCREMENT COMMENT '景点id',
  `scenicspot_provic` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '省份名称',
  `scenicspot_city` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '城市名称',
  `scenicspot_name` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '景点名称',
  `scenicspot_desc` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '景点介绍',
  `scenicspot_imgsrc_one` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '景点图片',
  `scenicspot_imgsrc_two` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `scenicspot_imgsrc_three` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `scenicspot_imgsrc_four` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `scenicspot_imgsrc_five` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `scenicspot_category` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '景点分类',
  `scenicspot_collect_count` int NULL DEFAULT NULL COMMENT '被用户收藏次数（热度）',
  PRIMARY KEY (`scenicspot_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of scenicspot
-- ----------------------------
INSERT INTO `scenicspot` VALUES (1, '陕西', '西安', '大雁塔', '唐朝...', 'D://img', NULL, NULL, NULL, NULL, '历史建筑', 34);
INSERT INTO `scenicspot` VALUES (2, '西安', '咸阳', '咸阳湖', '渭河', 'D://img', NULL, NULL, NULL, NULL, '湖泊风景', 54);
INSERT INTO `scenicspot` VALUES (3, '四川', '成都', '大熊猫', '国宝', 'A://abc', NULL, NULL, NULL, NULL, '动物', 22);
INSERT INTO `scenicspot` VALUES (4, '甘肃', '西安', '兰州山', '山脉', 'B://SJDN', NULL, NULL, NULL, NULL, '山川', 45);
INSERT INTO `scenicspot` VALUES (5, '山西', '太原', '关羽庙', '关羽', 'D://def', NULL, NULL, NULL, NULL, '历史人物', 76);
INSERT INTO `scenicspot` VALUES (6, '山东', '济南', '西安', '咸阳', 'M://min', NULL, NULL, NULL, NULL, '城市', 88);
INSERT INTO `scenicspot` VALUES (7, '湖北', '武汉', '滕王阁', '建筑', 'K://nm', NULL, NULL, NULL, NULL, '西安', 98);

-- ----------------------------
-- Table structure for user_collect
-- ----------------------------
DROP TABLE IF EXISTS `user_collect`;
CREATE TABLE `user_collect`  (
  `collect_id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `account_id` int NULL DEFAULT NULL COMMENT '用户id',
  `scenicspot_id` int NULL DEFAULT NULL COMMENT '收藏的景点id',
  PRIMARY KEY (`collect_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user_collect
-- ----------------------------
INSERT INTO `user_collect` VALUES (1, 2, 2);
INSERT INTO `user_collect` VALUES (2, 1, 1);

-- ----------------------------
-- Table structure for visit_user
-- ----------------------------
DROP TABLE IF EXISTS `visit_user`;
CREATE TABLE `visit_user`  (
  `user_id` int NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `account_id` int NULL DEFAULT NULL COMMENT '账号',
  `user_nike_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户昵称',
  `user_picture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户头像',
  `user_password` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '密码',
  `user_gender` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '性别',
  `user_provic` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '省',
  `user_city` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '市',
  `user_phone_number` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '电话号码',
  `user_category` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '爱好景点类型',
  PRIMARY KEY (`user_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of visit_user
-- ----------------------------
INSERT INTO `visit_user` VALUES (1, 3, '张三', NULL, '123', '男', '陕西', '西安', '45466', '1');
INSERT INTO `visit_user` VALUES (2, 4, '李四', NULL, '1234', '女', '陕西', '咸阳', '56767', '2');

SET FOREIGN_KEY_CHECKS = 1;