pho6e2qjw
/
xian
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'ranyujun'
${ noResults }
xian/travel.sql

235 lines
17 KiB
Raw Permalink Normal View History Unescape

MySQL
5 months ago
/*
Navicat MySQL Data Transfer
Source Server : localhost_3306
Source Server Version : 80023
Source Host : localhost:3306
Source Database : travel
Target Server Type : MYSQL
Target Server Version : 80023
File Encoding : 65001
Date: 2024-06-16 14:05:34
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for attractions
-- ----------------------------
DROP TABLE IF EXISTS `attractions`;
CREATE TABLE `attractions` (
`id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`attractions_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`attractions_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`attractions_describe` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`attractions_status` int DEFAULT '0',
`create_date` datetime DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
-- ----------------------------
-- Records of attractions
-- ----------------------------
INSERT INTO `attractions` VALUES ('1', 'MY_jingdian_06', '大唐不夜城', '西安市雁塔区慈恩路46号', '大唐不夜城的中轴景观大道是一条约1500米横贯南北的中央雕塑景观步行街，其上分布着盛世帝王、历史人物、英雄故事等九组主题群雕，立体展现大唐帝国在宗教、文学、艺术、科技等领域的地位并彰显大国气象。\r\n大唐不夜城以大雁塔为依托，北起玄奘广场、南至唐城墙遗址公园、东起慈恩东路、西至慈恩西路，贯穿玄奘广场、贞观文化广场、开元庆典广场三个主题广场，拥有六个仿唐街区和西安音乐厅、西安大剧院、曲江电影城、陕西艺术家展廊四大文化建筑。', '0', '2024-01-01 16:07:09');
INSERT INTO `attractions` VALUES ('9', 'MY_jingdian_08', '秦始皇帝陵博物院(兵马俑)', '陕西省西安市临潼区秦陵北路与秦俑馆公路交叉口', '秦始皇兵马俑博物馆又称兵马俑、秦兵马俑。它是秦始皇陵的陪葬坑，与秦始皇帝陵一同组成了：秦始皇帝陵博物院。\r\n\r\n秦始皇兵马俑素有世界第八大奇迹之称。这里出土的一千多个士兵陶俑，形象各不相同，神态生动，是中国古代雕塑艺术史上的一颗璀璨明珠，被誉为“二十世纪考古史上的伟大发现之一”。\r\n\r\n\r\n', '0', '2024-01-01 16:08:16');
-- ----------------------------
-- Table structure for hotel
-- ----------------------------
DROP TABLE IF EXISTS `hotel`;
CREATE TABLE `hotel` (
`id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`hotel_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`hotel_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`hotel_describe` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`hotel_status` int DEFAULT '0',
`create_date` datetime DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
-- ----------------------------
-- Records of hotel
-- ----------------------------
INSERT INTO `hotel` VALUES ('11', 'MY_kezhan_01', '君悦大酒店', '高新区的核心中央商务区', '酒店位于高新区的核心中央商务区，周边汇集200余家世界500强企业。酒店毗邻茑屋书店及地铁六号线丈八一路站；约十五分钟可到达丝路起点大唐西市，搭乘地铁六号线半小时既可直达钟鼓楼、回民街；仅需一次换乘可达大雁塔及曲江新区多个景点，交通便利；步行路程可到西安绿地缤纷荟购物中心、万达One购物中心及木塔寺公园，驱车约3分钟可上西安绕城高速丈八路口。', '0', '2024-01-02 10:22:04');
INSERT INTO `hotel` VALUES ('29', 'MY_kezhan_04', '西安大唐西市酒店', '西安大唐西市酒店位于国家4A级景区大唐西市九宫坊内', '西安大唐西市酒店拥有完善的会议设施，中餐、西餐、日式铁板烧等风格迥异的特色餐饮。拥有多间精致舒适客房，每个房间均配备了液晶电视，宽带上网，无线上网和迷你吧等设施。套房内摆放高档红木家具，房间整体设计将现代的舒适感与传统的唐文化元素相糅合。\r\n西安大唐西市酒店拥有室内泳池以及SPA康体部，提供全方位的优健服务，专属的配方疗程，为您在享受SPA的芳香旅程中得到身、心、灵的放松及升华。', '0', '2024-01-02 16:37:36');
-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
`id` int NOT NULL AUTO_INCREMENT,
`username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO `sys_user` VALUES ('1', 'admin', 'admin');
-- ----------------------------
-- Table structure for travel_route
-- ----------------------------
DROP TABLE IF EXISTS `travel_route`;
CREATE TABLE `travel_route` (
`id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`route_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`route_describe` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`route_status` int NOT NULL DEFAULT '0',
`route_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`collect_number` int NOT NULL DEFAULT '0',
`create_date` datetime DEFAULT NULL,
`update_date` datetime DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
-- ----------------------------
-- Records of travel_route
-- ----------------------------
INSERT INTO `travel_route` VALUES ('10', '西安博物馆旅游路线', '打车：从沙金桥打车前往西安博物馆，全程约需20分钟左右，车费大约在30元左右。总的来说，公共交通是比较方便和经济的选择，但需要注意地铁和公交车的运营时间。\r\n公交：市区乘坐游7路、18路、21路等到“小雁塔”站下车，步行5分钟可达、地铁：乘坐地铁2号线在“南稍门”站下车，步行7分钟可达。', '0', '西安博物馆', '0', '2024-01-01 13:37:40', null);
INSERT INTO `travel_route` VALUES ('11', '西安兵马俑旅游路线', '公交307路：大唐芙蓉园南门－大雁抚－赛格电脑城－西部家具城－沙坡－互助路立交－轻工市场－万寿路－半坡公交枢纽站－堡子村－纺北路－新寺－灞桥－豁口－邵平店－冷冻厂－斜口－西安工程大学临潼校区－西安科技大学临潼校区－陆军疗养院－骊山索道－华清池－临潼博物馆－临潼东关－东三岔－兵马俑－陕鼓集团', '0', '西安兵马俑', '0', '2024-01-01 13:38:37', null);
INSERT INTO `travel_route` VALUES ('15', '大唐不夜城旅游路线', '公交：乘坐曲江旅游环线、5、21、27、30、41、224、271、401、408、501、601、606、715、920(汤峪)、920(焦岱)、游6、游8(610)公交，在大雁塔南广场站下车，步行即可到达大唐不夜城。\r\n　　地铁：乘坐地铁3号线、地铁4号线在大雁塔站下车，然后步行至大唐不夜城。', '0', '大唐不夜城', '0', '2024-01-01 13:39:02', null);
-- ----------------------------
-- Table structure for travel_strategy
-- ----------------------------
DROP TABLE IF EXISTS `travel_strategy`;
CREATE TABLE `travel_strategy` (
`id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '旅游攻略strategy',
`user_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`strategy_describe` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`strategy_status` int DEFAULT NULL COMMENT '0是审核通过,1是未审核,2是审核未通过',
`create_date` datetime DEFAULT NULL,
`title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`error_message` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
KEY `user_id` (`user_id`) USING BTREE,
CONSTRAINT `travel_strategy_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
-- ----------------------------
-- Records of travel_strategy
-- ----------------------------
INSERT INTO `travel_strategy` VALUES ('0150845ffc794469b876ae5a1923b91d', 'afcede479a4646de8dda29db8a5d6c6c', '111', '1', '2024-01-10 01:54:32', '111', null);
INSERT INTO `travel_strategy` VALUES ('49f189d973864e32af92609e304f4274', '2679e68453794ca8a3669571ccb5c730', '免费开放时间：周二至周日9：00-17：30\r\n到古都必去的地方一定是博物馆，人文历史的满足感是刻在骨子里的，记得先在某众号上预约～', '1', '2024-06-16 05:19:04', '陕西历史博物馆', null);
INSERT INTO `travel_strategy` VALUES ('4ebd501d70354429bc9dccb96ccf6464', '2679e68453794ca8a3669571ccb5c730', null, '1', '2024-01-03 02:03:43', null, null);
INSERT INTO `travel_strategy` VALUES ('7c7f034c0682452d9e5c92232ac795c3', '2679e68453794ca8a3669571ccb5c730', '如果想乘坐索道上山，到达玉泉院后，需于此乘坐华山景区内的中巴车前往索道站(也是“智取华山路”登山口所在地)，票价10元/人。同样，若选择乘坐索道或“智取华山路”下山，也需先乘中巴车到玉泉院，才有汽车返回西安。这段路程步行20分钟左右。要是没有赶上游1路当日返回西安的班车，玉泉院周围有很多私人拉客车，都是上满人才会走。旅游专线车在客流量大时，每天发车不少于7辆；客流量小时，每天发车不少于4辆，约2小时到达华山。', '1', '2024-01-02 05:41:48', '西安华山旅游攻略', null);
INSERT INTO `travel_strategy` VALUES ('8d7f2bdc80e1413db54ec559bb33d34e', null, null, '1', '2024-01-03 02:03:33', null, null);
INSERT INTO `travel_strategy` VALUES ('bd2cbc4285774cc3898e1130032f5b16', '0bc85e2aa9ac44fbb6cb415271bb5014', '1、南普陀请香与别处不同：小木屋可免费请一支清香（不可多取），功德随意投入，一元二元不拘，不投也无妨； 　　2、烧香的地方在天王殿外，香烛不可带进寺院里面；如随身带有香烛的，可以寄放在天王殿门口的义工处，出来时取； 旅行攻略8： 鼓浪屿攻略 至于游玩鼓浪屿的线路，建议走经典线路：龙头路+八卦楼+菽庄花园', '0', '2024-01-02 12:17:54', 'test', null);
INSERT INTO `travel_strategy` VALUES ('d9b05e29c91942f9859a9621286421a0', '123123123', '东方明珠塔的陈列馆还是非常值得一逛哦，特别是对于上海宁，这里是上海城市历史发展陈列馆 里面很多的历史场景，也许还都是你爷爷奶奶外公外婆辈的呢呢，所以也很值得带长辈来玩 就是可能会走比较累。 　　登塔时间： 　　如果想看白天的上海那就下午去，最好1点-3点。如果要看太阳西落及夜景，那就5点再去（必然会排队）去之前我查过很多攻略，都说登塔排队拍了好几个小时，我下午3点去的（本来定的2点，但买喜茶耽误到3点了）排队15分钟。', '2', '2024-01-02 17:15:39', '上海东方明珠攻略', '攻略写的不够详细');
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('0bc85e2aa9ac44fbb6cb415271bb5014', 'qwe', '1234', '老杜');
INSERT INTO `user` VALUES ('123123123', 'user', '123456', '老杨');
INSERT INTO `user` VALUES ('2679e68453794ca8a3669571ccb5c730', 'admin', 'admin', null);
INSERT INTO `user` VALUES ('afcede479a4646de8dda29db8a5d6c6c', 'ryj', '123456', null);
INSERT INTO `user` VALUES ('d41e561ff23b422894e72ff9e2bdae70', 'yy', '123456', null);
-- ----------------------------
-- Table structure for user_attractions
-- ----------------------------
DROP TABLE IF EXISTS `user_attractions`;
CREATE TABLE `user_attractions` (
`id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`user_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`attractions_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`user_attractions_describe` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`create_date` datetime DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
KEY `attractions_id` (`attractions_id`) USING BTREE,
KEY `user_id` (`user_id`) USING BTREE,
CONSTRAINT `user_attractions_ibfk_1` FOREIGN KEY (`attractions_id`) REFERENCES `attractions` (`id`) ON UPDATE RESTRICT,
CONSTRAINT `user_attractions_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
-- ----------------------------
-- Records of user_attractions
-- ----------------------------
INSERT INTO `user_attractions` VALUES ('3b753a46dccb427c85aa2a1583fbe37a', '123123123', '1', null, '2024-01-01 12:22:21');
INSERT INTO `user_attractions` VALUES ('97ef290e1a0945238fbb75dcc1c06df3', '2679e68453794ca8a3669571ccb5c730', '1', null, '2024-01-01 11:08:34');
-- ----------------------------
-- Table structure for user_hotel
-- ----------------------------
DROP TABLE IF EXISTS `user_hotel`;
CREATE TABLE `user_hotel` (
`id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`user_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
`hotel_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
`user_hotel_describe` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`create_date` datetime DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
KEY `user_hotel_ibfk_1` (`user_id`) USING BTREE,
KEY `user_hotel_ibfk_2` (`hotel_id`) USING BTREE,
CONSTRAINT `user_hotel_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `user_hotel_ibfk_2` FOREIGN KEY (`hotel_id`) REFERENCES `hotel` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
-- ----------------------------
-- Records of user_hotel
-- ----------------------------
INSERT INTO `user_hotel` VALUES ('8aac034f162d4154b9606927c304377c', '123123123', '29', null, '2024-01-01 12:22:04');
-- ----------------------------
-- Table structure for user_route
-- ----------------------------
DROP TABLE IF EXISTS `user_route`;
CREATE TABLE `user_route` (
`id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`user_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`route_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`create_date` datetime DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
KEY `user_id` (`user_id`) USING BTREE,
KEY `route_id` (`route_id`) USING BTREE,
CONSTRAINT `user_route_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `user_route_ibfk_2` FOREIGN KEY (`route_id`) REFERENCES `travel_route` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
-- ----------------------------
-- Records of user_route
-- ----------------------------
INSERT INTO `user_route` VALUES ('ae51c1397b3b4782a028c1119e4413c7', '123123123', '15', '2024-01-02 12:19:27');
-- ----------------------------
-- Table structure for user_strategy
-- ----------------------------
DROP TABLE IF EXISTS `user_strategy`;
CREATE TABLE `user_strategy` (
`id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`user_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
`strategy_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
`create_date` datetime DEFAULT NULL,
`update_date` datetime DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
KEY `user_hotel_ibfk_1` (`user_id`) USING BTREE,
KEY `user_hotel_ibfk_2` (`strategy_id`) USING BTREE,
CONSTRAINT `user_strategy_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `user_strategy_ibfk_2` FOREIGN KEY (`strategy_id`) REFERENCES `travel_strategy` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
-- ----------------------------
-- Records of user_strategy
-- ----------------------------
INSERT INTO `user_strategy` VALUES ('d2ee2a844c364b74931b4184f091f6ca', '123123123', 'bd2cbc4285774cc3898e1130032f5b16', '2024-01-02 12:28:33', null);