(源码)基于Spring Boot框架的旅游网站管理系统.zip

/* SQLyog Ultimate v11.3 (64 bit) MySQL - 5.7.32-log : Database - lvyouwangzhan ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; CREATE DATABASE /*!32312 IF NOT EXISTS*/`lvyouwangzhan` /*!40100 DEFAULT CHARACTER SET utf8 */; USE `lvyouwangzhan`; /*Table structure for table `config` */ DROP TABLE IF EXISTS `config`; CREATE TABLE `config` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `name` varchar(100) NOT NULL COMMENT '配置参数名称', `value` varchar(100) DEFAULT NULL COMMENT '配置参数值', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='配置文件'; /*Data for the table `config` */ insert into `config`(`id`,`name`,`value`) values (3,'轮播图1','http://localhost:8080/lvyouwangzhan/upload/1617365740377.jpg'),(4,'轮播图2','http://localhost:8080/lvyouwangzhan/upload/1617365747639.jpg'); /*Table structure for table `dictionary` */ DROP TABLE IF EXISTS `dictionary`; CREATE TABLE `dictionary` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `dic_code` varchar(200) DEFAULT NULL COMMENT '字段', `dic_name` varchar(200) DEFAULT NULL COMMENT '字段名', `code_index` int(11) DEFAULT NULL COMMENT '编码', `index_name` varchar(200) DEFAULT NULL COMMENT '编码名字 ', `super_id` int(11) DEFAULT NULL COMMENT '父字段id', `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 COMMENT='字典表'; /*Data for the table `dictionary` */ insert into `dictionary`(`id`,`dic_code`,`dic_name`,`code_index`,`index_name`,`super_id`,`create_time`) values (1,'sex_types','性别',1,'男',NULL,'2021-04-01 11:45:17'),(2,'sex_types','性别',2,'女',NULL,'2021-04-01 11:45:17'),(3,'jingdian_types','景点类型名称',3,'公园',NULL,'2021-04-01 11:45:17'),(4,'jingdian_types','景点类型名称',2,'山脉',NULL,'2021-04-01 11:45:17'),(5,'jingdian_types','景点类型名称',1,'其他',NULL,'2021-04-01 11:45:17'),(6,'jingdian_dengji_types','景点等级名称',1,'五A景点',NULL,'2021-04-01 11:45:17'),(7,'jingdian_dengji_types','景点等级名称',2,'国家景点',NULL,'2021-04-01 11:45:17'),(8,'jingdian_dengji_types','景点等级名称',3,'市级景点',NULL,'2021-04-01 11:45:17'),(9,'jingdian_dengji_types','景点等级名称',4,'其他',NULL,'2021-04-01 11:45:17'),(10,'luxian_types','路线类型名称',1,'穷游路线',NULL,'2021-04-01 11:45:17'),(11,'luxian_types','路线类型名称',2,'最短路线',NULL,'2021-04-01 11:45:17'),(12,'luxian_types','路线类型名称',3,'其他',NULL,'2021-04-01 11:45:17'),(13,'gonglve_types','攻略类型名称',1,'类型一',NULL,'2021-04-01 11:45:17'),(14,'gonglve_types','攻略类型名称',2,'类型二',NULL,'2021-04-01 11:45:17'),(15,'gonglve_types','攻略类型名称',3,'类型三',NULL,'2021-04-01 11:45:17'),(16,'jiudian_types','酒店星级名称',1,'一星酒店',NULL,'2021-04-01 11:45:17'),(17,'jiudian_types','酒店星级名称',2,'二星酒店',NULL,'2021-04-01 11:45:18'),(18,'jiudian_types','酒店星级名称',3,'三星酒店',NULL,'2021-04-01 11:45:18'),(19,'jiudian_types','酒店星级名称',4,'四星酒店',NULL,'2021-04-01 11:45:18'),(20,'jiudian_types','酒店星级名称',5,'五星酒店',NULL,'2021-04-01 11:45:18'),(21,'news_types','新闻类型名称',1,'日常新闻',NULL,'2021-04-01 11:45:18'),(22,'news_types','新闻类型名称',2,'紧急新闻',NULL,'2021-04-01 11:45:18'); /*Table structure for table `gonglve` */ DROP TABLE IF EXISTS `gonglve`; CREATE TABLE `gonglve` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键', `gonglve_name` varchar(200) DEFAULT NULL COMMENT '攻略名 ', `gonglve_types` int(11) DEFAULT NULL COMMENT '攻略类型 ', `gonglve_photo` varchar(200) DEFAULT NULL COMMENT '攻略照片', `gonglve_content` text COMMENT '攻略详情', `insert_time` timestamp NULL DEFAULT NULL COMMENT '攻略发表时间', `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 ', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='自驾游攻略'; /*Data for the table `gonglve` */ insert into `gonglve`(`id`,`gonglve_name`,`gonglve_types`,`gonglve_photo`,`gonglve_content`,`insert_time`,`create_time`) values (1,'攻略1',3,'http://localhost:8080/lvyouwangzhan/file/download?fileName=1617365770676.jpg','硕大的撒大萨达是\r\n','2021-04-02 19:52:05','2021-04-02 19:52:05'),(2,'攻略2',1,'http://localhost:8080/lvyouwangzhan/file/download?fileName=1617365762769.jfif','硕大的撒萨达\r\n','2021-04-02 19:52:40','2021-04-02 19:52:40'),(3,'攻略5',2,'http://localhost:8080/lvyouwangzhan/file/download?fileName=1617369787748.jpg','为我去饿我去我去饿q\'w\r\n','2021-04-02 21:23:10','2021-04-02 21:23:10'); /*Table structure for table `jingdian` */ DROP TABLE IF EXISTS `jingdian`; CREATE TABLE `jingdian` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键', `jingdian_name` varchar(200) DEFAULT NULL COMMENT '景点名 ', `jingdian_types` int(11) DEFAULT NULL COMMENT '景点类型 ', `jingdian_dengji_types` int(11) DEFAULT NULL COMMENT '景点等级 ', `jingdian_photo` varchar(200) DEFAULT NULL COMMENT '景点缩略图', `jingdian_content` text COMMENT '景点详情', `jingdian_new_money` int(11) DEFAULT NULL COMMENT '参考门票价格', `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 ', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='景点'; /*Data for the table `jingdian` */ insert into `jingdian`(`id`,`jingdian_name`,`jingdian_types`,`jingdian_dengji_types`,`jingdian_photo`,`jingdian_content`,`jingdian_new_money`,`create_time`) values (1,'景点1',2,3,'http://localhost:8080/lvyouwangzhan/file/download?fileName=1617361096149.jpg','ss \r\n',99,'2021-04-02 13:19:43'),(2,'景点2',3,3,'http://localhost:8080/lvyouwangzhan/file/download?fileName=1617360934975.jpg','景点1的详情\r\n',333,'2021-04-02 18:55:44'),(3,'景点3',3,3,'http://localhost:8080/lvyouwangzhan/file/download?fileName=1617360957516.jfif','王企鹅无群额温枪\r\n',747,'2021-04-02 18:56:04'),(4,'景点4',2,1,'http://localhost:8080/lvyouwangzhan/file/download?fileName=1617360984950.jpg','委托维尔而\r\n',77,'2021-04-02 18:56:29'),(5,'景点5',3,4,'http://localhost:8080/lvyouwangzhan/file/download?fileName=1617361519603.jpg','<img src=\"http://localhost:8080/lvyouwangzhan/upload/1617361527322.jpg\" width=\"900\" height=\"560\" _src=\"http://localhost:8080/lvyouwangzhan/upload/1617361527322.jpg\"><img src=\"http://localhost:8080/lvyouwangzhan/upload/1617361530400.jpg\" width=\"900\" height=\"560\" _src=\"http://localhost:8080/lvyouwangzhan/upload/1617361530400.jpg\"><img src=\"http://localhost:8080/lvyouwangzhan/upload/1617361534871.jpg\" width=\"900\" height=\"560\" _src=\"http://localhost:8080/lvyouwangzhan/upload/1617361534871.jpg\">9689898\r\n',77,'2021-04-02 18:57:00'),(6,'景点6',2,3,'http://localhost:8080/lvyouwangzhan/file/download?fileName=1617361033139.jpg','无色大所大萨达\r\n',77,'2021-04-02 18:57:18'),(7,'景点7',2,2,'http://localhost:8080/lvyouwangzhan/file/download?fileName=1617361052993.jpg','77777<img src=\"http://localhost:8080/lvyouwangzhan/upload/1617361062598.jpg\" width=\"900\" height=\"560\" _src=\"http://localhost:8080/lvyouwangzhan/upload/1617361062598.jpg\">为爱而萨达奥恩万千瓦 \r\n',777,'2021-04-02 18:57:50'); /*Table structure for table `jingdian_collection` */ DROP TABLE IF EXISTS `