黑马旅游网数据库

  1 /*
  2 Navicat MySQL Data Transfer
  3 
  4 Source Server         : m_web
  5 Source Server Version : 50540
  6 Source Host           : localhost:3307
  7 Source Database       : travel
  8 
  9 Target Server Type    : MYSQL
 10 Target Server Version : 50540
 11 File Encoding         : 65001
 12 
 13 Date: 2019-05-28 15:31:54
 14 */
 15 
 16 SET FOREIGN_KEY_CHECKS=0;
 17 
 18 -- ----------------------------
 19 -- Table structure for tab_category
 20 -- ----------------------------
 21 DROP TABLE IF EXISTS `tab_category`;
 22 CREATE TABLE `tab_category` (
 23   `cid` int(11) NOT NULL AUTO_INCREMENT,
 24   `cname` varchar(100) NOT NULL,
 25   PRIMARY KEY (`cid`),
 26   UNIQUE KEY `AK_nq_categoryname` (`cname`)
 27 ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
 28 
 29 -- ----------------------------
 30 -- Records of tab_category
 31 -- ----------------------------
 32 INSERT INTO `tab_category` VALUES (‘8‘, ‘全球自由行‘);
 33 INSERT INTO `tab_category` VALUES (‘5‘, ‘国内游‘);
 34 INSERT INTO `tab_category` VALUES (‘4‘, ‘处境游‘);
 35 INSERT INTO `tab_category` VALUES (‘7‘, ‘抱团定制‘);
 36 INSERT INTO `tab_category` VALUES (‘6‘, ‘港澳游‘);
 37 INSERT INTO `tab_category` VALUES (‘2‘, ‘酒店‘);
 38 INSERT INTO `tab_category` VALUES (‘1‘, ‘门票‘);
 39 INSERT INTO `tab_category` VALUES (‘3‘, ‘香港车票‘);
 40 
 41 -- ----------------------------
 42 -- Table structure for tab_favorite
 43 -- ----------------------------
 44 DROP TABLE IF EXISTS `tab_favorite`;
 45 CREATE TABLE `tab_favorite` (
 46   `rid` int(11) NOT NULL,
 47   `date` date NOT NULL,
 48   `uid` int(11) NOT NULL,
 49   PRIMARY KEY (`rid`,`uid`),
 50   KEY `FK_user_favorite` (`uid`),
 51   CONSTRAINT `FK_route_favorite` FOREIGN KEY (`rid`) REFERENCES `tab_route` (`rid`),
 52   CONSTRAINT `FK_user_favorite` FOREIGN KEY (`uid`) REFERENCES `tab_user` (`uid`)
 53 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 54 
 55 -- ----------------------------
 56 -- Records of tab_favorite
 57 -- ----------------------------
 58 INSERT INTO `tab_favorite` VALUES (‘10‘, ‘2019-05-23‘, ‘1‘);
 59 INSERT INTO `tab_favorite` VALUES (‘10‘, ‘2019-05-25‘, ‘2‘);
 60 INSERT INTO `tab_favorite` VALUES (‘234‘, ‘2019-05-25‘, ‘2‘);
 61 INSERT INTO `tab_favorite` VALUES (‘234‘, ‘2019-05-25‘, ‘3‘);
 62 
 63 -- ----------------------------
 64 -- Table structure for tab_route
 65 -- ----------------------------
 66 DROP TABLE IF EXISTS `tab_route`;
 67 CREATE TABLE `tab_route` (
 68   `rid` int(11) NOT NULL AUTO_INCREMENT,
 69   `rname` varchar(500) NOT NULL,
 70   `price` double NOT NULL,
 71   `routeIntroduce` varchar(1000) DEFAULT NULL,
 72   `rflag` char(1) NOT NULL,
 73   `rdate` varchar(19) DEFAULT NULL,
 74   `isThemeTour` char(1) NOT NULL,
 75   `count` int(11) DEFAULT ‘0‘,
 76   `cid` int(11) NOT NULL,
 77   `rimage` varchar(200) DEFAULT NULL,
 78   `sid` int(11) DEFAULT NULL,
 79   `sourceId` varchar(50) DEFAULT NULL,
 80   PRIMARY KEY (`rid`),
 81   UNIQUE KEY `AK_nq_sourceId` (`sourceId`),
 82   KEY `FK_category_route` (`cid`),
 83   KEY `FK_seller_route` (`sid`),
 84   CONSTRAINT `FK_category_route` FOREIGN KEY (`cid`) REFERENCES `tab_category` (`cid`),
 85   CONSTRAINT `FK_seller_route` FOREIGN KEY (`sid`) REFERENCES `tab_seller` (`sid`)
 86 ) ENGINE=InnoDB AUTO_INCREMENT=514 DEFAULT CHARSET=utf8;
 87 
 88 -- ----------------------------
 89 -- Records of tab_route
 90 -- ----------------------------
 91 INSERT INTO `tab_route` VALUES (‘1‘, ‘【旅展 半价特惠 重走丝路•漫游宁夏 双飞4天】银川西部影视城 穆民新村 中卫沙坡头【品美酒 回族学唱花儿 感悟民俗】‘, ‘999‘, ‘走进【宁夏沙坡头】，感受西北大漠风情、体会“大漠孤烟直，长河落日圆”的塞上风光！‘, ‘1‘, ‘2018-02-09 01:13:16‘, ‘0‘, ‘0‘, ‘5‘, ‘img/product/small/m304b69a4c8328f7d6b8d5dadef020fe07.jpg‘, ‘1‘, ‘23677‘);
 92 INSERT INTO `tab_route` VALUES (‘2‘, ‘【官网专享 立减¥500 张家界天门山+大峡谷+凤凰古城+玻璃栈道+玻璃桥 高铁4天 无自费5钻】印象鲵宴-赶年宴+2晚蓝湾博格酒店‘, ‘1799‘, ‘官网专线，顶级品质！全程超豪华住宿，2晚入住超豪华铂金-蓝湾博格国际酒店，独家尊享金马VIP贵宾专用楼层。‘, ‘1‘, ‘2018-02-09 01:13:17‘, ‘0‘, ‘990‘, ‘5‘, ‘img/product/small/m34866f055de8630e94e25c40f277a79ba.jpg‘, ‘1‘, ‘22066‘);
 93 INSERT INTO `tab_route` VALUES (‘3‘, ‘【官网专享 5折预售 越南下龙湾+河内+芒街 高铁4天 高级团】双导游服务 免收服务小费【越超值·美食越南】‘, ‘1199‘, ‘双导游服务，免收服务小费，周全照顾贴心服务随心出游！品尝越南特色国宝美食，升级一餐越式炸鸡火锅宴！‘, ‘1‘, ‘2018-02-09 01:13:17‘, ‘0‘, ‘0‘, ‘5‘, ‘img/product/small/m3db4d2277b5df3d98597f79082ef92d6d.jpg‘, ‘1‘, ‘21998‘);
 94 INSERT INTO `tab_route` VALUES (‘4‘, ‘【官网专享 送箱 ¥1099秒杀 华东五市+乌镇+南浔 双飞6天 南京进上海出】升级1晚豪华酒店 漫步西湖【水墨江南】‘, ‘1099‘, ‘升级入住1晚豪华酒店；畅玩江南两大经典水乡——乌镇水乡和南浔水乡，体验这里的历史文化底蕴、清丽婉约的水乡古镇风貌。‘, ‘1‘, ‘2018-02-09 01:13:17‘, ‘0‘, ‘0‘, ‘5‘, ‘img/product/small/m3d91ef60e0c7fdeee97a4e2d3e5a42e84.jpg‘, ‘1‘, ‘21943‘);
 95 INSERT INTO `tab_route` VALUES (‘5‘, ‘梅州 双飞3天2晚 自由行套票【含广州直飞梅州早对晚含税往返机票+2晚梅州市区酒店】‘, ‘999‘, ‘含广州直飞梅州早对晚含税往返机票+2晚梅州市区酒店！‘, ‘1‘, ‘2018-02-09 01:13:17‘, ‘0‘, ‘0‘, ‘5‘, ‘img/product/small/m3ac1aa10b493b4b22221e19ba39f7e6a1.jpg‘, ‘1‘, ‘21917‘);
 96 INSERT INTO `tab_route` VALUES (‘6‘, ‘【宁夏银川 双飞4天】 银川中华回乡文化园 中卫沙坡头 宁夏回族自治区博物馆 西关清真寺‘, ‘1299‘, ‘中卫升级1晚豪华酒店！走进【宁夏沙坡头】，感受西北大漠风情、体会“大漠孤烟直，长河落日圆”的塞上风光！‘, ‘1‘, ‘2018-02-09 01:13:17‘, ‘0‘, ‘0‘, ‘5‘, ‘img/product/small/m312cf97538027a813a4fb0bd6980a7fea.jpg‘, ‘1‘, ‘16968‘);
 97 INSERT INTO `tab_route` VALUES (‘7‘, ‘【¥1099秒杀 约惠华东五市+乌镇+木渎+灵山大佛 双飞6天 无锡进上海出】升级2晚豪华酒店‘, ‘1099‘, ‘畅玩乌镇水乡和木渎水乡，游览上海迪士尼小镇，其中升级入住2晚豪华酒店，品尝杭州特色宴“乾隆御茶宴”，送品尝金秋肥美大闸蟹一只！‘, ‘1‘, ‘2018-02-09 01:13:17‘, ‘0‘, ‘0‘, ‘5‘, ‘img/product/small/m370365f2ea91b638695218a6df13e3819.jpg‘, ‘1‘, ‘14974‘);
 98 INSERT INTO `tab_route` VALUES (‘8‘, ‘【¥1099秒杀 特惠华东五市+乌镇+木渎+灵山大佛 双飞6天 上海进杭州出】升级2晚豪华酒店‘, ‘1099‘, ‘升级两晚豪华酒店，畅游双水乡乌镇+木渎古镇，南京中山陵，杭州西湖！‘, ‘1‘, ‘2018-02-09 01:13:17‘, ‘0‘, ‘0‘, ‘5‘, ‘img/product/small/m30971b3d22ab37242636088780cfb8eb5.jpg‘, ‘1‘, ‘13580‘);
 99 INSERT INTO `tab_route` VALUES (‘9‘, ‘【豪叹喜来登 桂林 阳朔西街高铁4天纯玩 高级团】漓江 西山公园 象鼻山 银子岩‘, ‘1299‘, ‘1晚指定入住福朋喜来登酒店，船游全程大漓江，游览世界溶洞奇观银子岩‘, ‘1‘, ‘2018-02-09 01:13:17‘, ‘0‘, ‘0‘, ‘5‘, ‘img/product/small/m35c17b5b73d618bbdd2abe231f1307838.jpg‘, ‘1‘, ‘2702‘);
100 INSERT INTO `tab_route` VALUES (‘10‘, ‘【春节 湖南郴州莽山+东江湖+冰雪森林温泉 高铁3天 顶贵团】欢迎年宴+温泉养生宴+农家菜【金狗闹郴晚·冰天雪地泡温泉】‘, ‘2399‘, ‘莽山景区入住“森林中的皇宫”之美誉的莽山森林温泉酒店；市区入住享“酒店就是景区”美誉的国际奢华品牌酒店---温德姆至尊豪庭酒店！‘, ‘1‘, ‘2018-02-09 01:13:17‘, ‘0‘, ‘0‘, ‘5‘, ‘img/product/small/m3c9823bc50368af0fe83eff14a5587c0a.jpg‘, ‘1‘, ‘20523‘);
101 INSERT INTO `tab_route` VALUES (‘11‘, ‘【春节 莽山+东江湖+冰雪森林温泉 高铁3天 贵宾团】年夜欢迎晚宴+温泉养身宴+特色火锅+湘南风味餐+莽山农家菜‘, ‘1999‘, ‘独家首创“画中游”游览方式—-徒步醉美小东江景区，颁发徒步证书；特别赠送：美味·东江鱼品尝装礼盒！‘, ‘1‘, ‘2018-02-09 01:13:17‘, ‘0‘, ‘0‘, ‘5‘, ‘img/product/small/m3501326413840ce82b9ba14db3a3a5eea.jpg‘, ‘1‘, ‘20517‘);
102 INSERT INTO `tab_route` VALUES (‘12‘, ‘【立减¥400 桃花季包列 西藏拉萨+日喀则+林芝 双卧12天】青藏铁路 布达拉宫 东方瑞士鲁朗 圣湖羊卓雍措 扎什伦布寺‘, ‘5599‘, ‘【包列进藏】乘坐世界最先进的青藏列车，观世界坐标级景观带，有氧车厢进入西藏，由低海拔至高海拔逐步适应，安全保障。畅享拉林高等级公路沿途“颜值担当”雪域江南风光！‘, ‘1‘, ‘2018-02-09 01:13:17‘, ‘0‘, ‘0‘, ‘5‘, ‘img/product/small/m32bdf1849b307712c4a0843b89ed83b5f.jpg‘, ‘1‘, ‘20060‘);
103 INSERT INTO `tab_route` VALUES (‘13‘, ‘【立减¥200 桃花季包列 西藏拉萨+林芝桃花季双卧10天】青藏铁路景观带 布达拉宫 东方瑞士鲁朗 嘎拉桃花村‘, ‘4399‘, ‘【包列进藏】乘坐世界最先进的青藏列车，观世界坐标级景观带，有氧车厢进入西藏，由低海拔至高海拔逐步适应，安全保障。畅享拉林高等级公路沿途“颜值担当”雪域江南风光！‘, ‘1‘, ‘2018-02-09 01:13:17‘, ‘0‘, ‘0‘, ‘5‘, ‘img/product/small/m3f535b6065c0085e6e69d1df7337bc60c.jpg‘, ‘1‘, ‘20059‘);
104 INSERT INTO `tab_route` VALUES (‘14‘, ‘【¥999/2人 广西北海双飞4天 南航往返】北海银滩 北海海景大道 北部湾广场 侨港镇 南迈渔村‘, ‘999‘, ‘南航飞机直达北海不用1个半小时，畅游真正“天下第一滩”北海十里银滩！漫步北海老街，探秘南迈渔村！‘, ‘1‘, ‘2018-02-09 01:13:17‘, ‘0‘, ‘0‘, ‘5‘, ‘img/product/small/m3d62aa9f19c84f99a8b700f12824b195b.jpg‘, ‘1‘, ‘13498‘);
105 INSERT INTO `tab_route` VALUES (‘15‘, ‘【¥1999秒杀 新疆乌鲁木齐+天山天池+鄯善+火焰山 双飞5天 超贵团】库姆塔格沙漠 坎儿井‘, ‘1999‘, ‘升级一晚超豪华酒店！鄯善沙漠哈密瓜的故乡，沙漠中的绿洲吐 鲁 番，畅游天山天池！‘, ‘1‘, ‘2018-02-09 01:13:17‘, ‘0‘, ‘0‘, ‘5‘, ‘img/product/small/m3b73ad0712746ef03019e34fb9757401d.jpg‘, ‘1‘, ‘13344‘);
106 INSERT INTO `tab_route` VALUES (‘16‘, ‘【越南下龙湾+巡洲岛+吉婆岛+河内 高铁5天 纯玩贵宾团】0购物0自费 尊享1晚国际品牌超豪华酒店+1晚巡洲岛豪华海边度假酒店海景房‘, ‘1899‘, ‘畅游·下龙湾，登陆巡洲岛，游恬静的北越明珠吉婆岛！尊享1晚国际品牌超豪华酒店+1晚巡洲岛豪华海边度假酒店海景房‘, ‘1‘, ‘2018-02-09 01:13:19‘, ‘0‘, ‘0‘, ‘5‘, ‘img/product/small/m391ef27749fd523c757403de0a5d033d5.jpg‘, ‘1‘, ‘4947‘);
107 INSERT INTO `tab_route` VALUES (‘17‘, ‘【海南三亚+兴隆+海口+蜈支洲岛+西岛+亚龙湾+天涯海角双飞4天 超贵团】海口/三亚进 三亚/海口出 不走回头路【经典皇牌 至尊双岛】‘, ‘1899‘, ‘不走回头路，劲省4小时车程，升级三亚一晚超豪华度假酒店，畅游天涯海角+亚龙湾沙滩+椰田古寨！‘, ‘1‘, ‘2018-02-09 01:13:19‘, ‘0‘, ‘0‘, ‘5‘, ‘img/product/small/m3552ce9d728ca8c85323df5395e8de1a2.jpg‘, ‘1‘, ‘886‘);
108 INSERT INTO `tab_route` VALUES (‘18‘, ‘【江西井冈山双飞4天】笔架山 游菖蒲古村 穿红军服走红军路‘, ‘1199‘, ‘广州直飞井冈山机场，车程劲省2小时；乘坐十公里长的亚洲第一索道——笔架山索道；‘, ‘1‘, ‘2018-02-09 01:13:19‘, ‘0‘, ‘0‘, ‘5‘, ‘img/product/small/m3bc92ed09dc80f91641ea195983bf1284.jpg‘, ‘1‘, ‘17800‘);
109 INSERT INTO `tab_route` VALUES (‘19‘, ‘【湘西360°全景 张家界高铁5天】韶山 天子山 袁家界 天门山 玻璃栈道 大峡谷景区玻璃桥 凤凰古城‘, ‘2099‘, ‘挑战天门山玻璃栈道、大峡谷玻璃桥，享侗族才家合拢宴 ，特色蘑菇宴，土家风味宴，游览韶山毛主席故里！‘, ‘1‘, ‘2018-02-09 01:13:19‘, ‘0‘, ‘0‘, ‘5‘, ‘img/product/small/m3d69b0ea3165d04302cc068ac14192bd1.jpg‘, ‘1‘, ‘13866‘);
110 INSERT INTO `tab_route` VALUES (‘20‘, ‘【莽山+森林温泉+东江湖高铁3天 纯玩顶贵团5钻】湖南郴州 鬼子寨 天台山 猴王寨 自然博物馆【醉美4A郴州莽山·雾漫5A东江湖】‘, ‘1499‘, ‘全程 不进“旅游特色”购物场所，行摄布置撒网、捕鱼的场景，享用游水三文鱼+野生东江鱼‘, ‘1‘, ‘2018-02-09 01:13:19‘, ‘0‘, ‘0‘, ‘5‘, ‘img/product/small/m30e5efc21e11e76fbf0e75da4b7b9d97e.jpg‘, ‘1‘, ‘646‘);
111 
112 
113 -- ----------------------------
114 -- Table structure for tab_route_img
115 -- ----------------------------
116 DROP TABLE IF EXISTS `tab_route_img`;
117 CREATE TABLE `tab_route_img` (
118   `rgid` int(11) NOT NULL AUTO_INCREMENT,
119   `rid` int(11) NOT NULL,
120   `bigPic` varchar(200) NOT NULL,
121   `smallPic` varchar(200) DEFAULT NULL,
122   PRIMARY KEY (`rgid`),
123   KEY `FK_route_routeimg` (`rid`),
124   CONSTRAINT `FK_route_routeimg` FOREIGN KEY (`rid`) REFERENCES `tab_route` (`rid`)
125 ) ENGINE=InnoDB AUTO_INCREMENT=2091 DEFAULT CHARSET=utf8;
126 
127 -- ----------------------------
128 -- Records of tab_route_img
129 -- ----------------------------
130 INSERT INTO `tab_route_img` VALUES (‘1‘, ‘1‘, ‘img/product/size4/m421d66d4446940b1c80a0092c91e75184.jpg‘, ‘img/product/size2/m221d66d4446940b1c80a0092c91e75184.jpg‘);
131 INSERT INTO `tab_route_img` VALUES (‘2‘, ‘1‘, ‘img/product/size4/m4227f0cde1b021a77c56c1c18a8f2e7fd.jpg‘, ‘img/product/size2/m2227f0cde1b021a77c56c1c18a8f2e7fd.jpg‘);
132 INSERT INTO `tab_route_img` VALUES (‘3‘, ‘1‘, ‘img/product/size4/m412cf97538027a813a4fb0bd6980a7fea.jpg‘, ‘img/product/size2/m212cf97538027a813a4fb0bd6980a7fea.jpg‘);
133 INSERT INTO `tab_route_img` VALUES (‘4‘, ‘1‘, ‘img/product/size4/m47fe3031a3df75ab5e6711ae2338c18f7.jpg‘, ‘img/product/size2/m27fe3031a3df75ab5e6711ae2338c18f7.jpg‘);
134 INSERT INTO `tab_route_img` VALUES (‘5‘, ‘2‘, ‘img/product/size4/m44866f055de8630e94e25c40f277a79ba.jpg‘, ‘img/product/size2/m24866f055de8630e94e25c40f277a79ba.jpg‘);
135 INSERT INTO `tab_route_img` VALUES (‘6‘, ‘3‘, ‘img/product/size4/m4db4d2277b5df3d98597f79082ef92d6d.jpg‘, ‘img/product/size2/m2db4d2277b5df3d98597f79082ef92d6d.jpg‘);
136 INSERT INTO `tab_route_img` VALUES (‘7‘, ‘4‘, ‘img/product/size4/m4d91ef60e0c7fdeee97a4e2d3e5a42e84.jpg‘, ‘img/product/size2/m2d91ef60e0c7fdeee97a4e2d3e5a42e84.jpg‘);
137 INSERT INTO `tab_route_img` VALUES (‘8‘, ‘5‘, ‘img/product/size4/m4ac1aa10b493b4b22221e19ba39f7e6a1.jpg‘, ‘img/product/size2/m2ac1aa10b493b4b22221e19ba39f7e6a1.jpg‘);
138 INSERT INTO `tab_route_img` VALUES (‘9‘, ‘5‘, ‘img/product/size4/m4a3f85cf3b49c183ea3cc5cd4b0424532.jpg‘, ‘img/product/size2/m2a3f85cf3b49c183ea3cc5cd4b0424532.jpg‘);
139 
140 
141 -- ----------------------------
142 -- Table structure for tab_seller
143 -- ----------------------------
144 DROP TABLE IF EXISTS `tab_seller`;
145 CREATE TABLE `tab_seller` (
146   `sid` int(11) NOT NULL AUTO_INCREMENT,
147   `sname` varchar(200) NOT NULL,
148   `consphone` varchar(20) NOT NULL,
149   `address` varchar(200) DEFAULT NULL,
150   PRIMARY KEY (`sid`),
151   UNIQUE KEY `AK_Key_2` (`sname`)
152 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
153 
154 -- ----------------------------
155 -- Records of tab_seller
156 -- ----------------------------
157 INSERT INTO `tab_seller` VALUES (‘1‘, ‘黑马程序员‘, ‘12345678901‘, ‘传智播客javaEE学院‘);
158 
159 -- ----------------------------
160 -- Table structure for tab_user
161 -- ----------------------------
162 DROP TABLE IF EXISTS `tab_user`;
163 CREATE TABLE `tab_user` (
164   `uid` int(11) NOT NULL AUTO_INCREMENT,
165   `username` varchar(100) NOT NULL,
166   `password` varchar(32) NOT NULL,
167   `name` varchar(100) DEFAULT NULL,
168   `birthday` date DEFAULT NULL,
169   `sex` char(1) DEFAULT NULL,
170   `telephone` varchar(11) DEFAULT NULL,
171   `email` varchar(100) DEFAULT NULL,
172   `status` char(1) DEFAULT NULL,
173   `code` varchar(50) DEFAULT NULL,
174   PRIMARY KEY (`uid`),
175   UNIQUE KEY `AK_nq_username` (`username`),
176   UNIQUE KEY `AK_nq_code` (`code`)
177 ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
178 
179 -- ----------------------------
180 -- Records of tab_user
181 -- ----------------------------
182 INSERT INTO `tab_user` VALUES (‘1‘, ‘关羽‘, ‘1234‘, ‘关羽‘, ‘2019-05-16‘, ‘男‘, ‘18392895235‘, ‘1215135027@qq.com‘, ‘N‘, null);
183 INSERT INTO `tab_user` VALUES (‘2‘, ‘liubei‘, ‘1234‘, ‘刘备‘, ‘2019-05-02‘, ‘男‘, ‘18392895235‘, ‘1215135027@qq.com‘, ‘Y‘, ‘7f3a8f7319ea420abc4b38e9a9d25438‘);
184 INSERT INTO `tab_user` VALUES (‘3‘, ‘小乔‘, ‘1234‘, ‘小乔‘, ‘2019-05-11‘, ‘女‘, ‘18392895235‘, ‘1215135027@qq.com‘, ‘Y‘, ‘c1284fcc9b484d35aafcd7d9882f98a6‘);