/*
Navicat MySQL Data Transfer

Source Server         : mysql
Source Server Version : 50729
Source Host           : 192.168.1.200:3306
Source Database       : tourmanage

Target Server Type    : MYSQL
Target Server Version : 50729
File Encoding         : 65001

Date: 2020-05-01 15:04:04
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for car
-- ----------------------------
DROP TABLE IF EXISTS `car`;
CREATE TABLE `car` (
  `car_id` int(11) NOT NULL AUTO_INCREMENT,
  `car_price` int(11) DEFAULT NULL,
  `car_seats` int(11) DEFAULT NULL,
  `car_Location` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`car_id`)
) ENGINE=InnoDB AUTO_INCREMENT=82 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of car
-- ----------------------------
INSERT INTO `car` VALUES ('36', '321231', '321', 'dsadsa');
INSERT INTO `car` VALUES ('52', '321231', '321', '321');
INSERT INTO `car` VALUES ('53', '321231', '321', 'drar');
INSERT INTO `car` VALUES ('55', '321231', '321', 'dsadsadas');
INSERT INTO `car` VALUES ('56', '321231', '321', '321');
INSERT INTO `car` VALUES ('62', '321231', '321', '321');
INSERT INTO `car` VALUES ('64', '321231', '321', '321');
INSERT INTO `car` VALUES ('69', '321231', '1', 'zhanghaolong');
INSERT INTO `car` VALUES ('70', '20', '12', '龙');
INSERT INTO `car` VALUES ('71', '4', '14', 'dsdadsadsa');
INSERT INTO `car` VALUES ('72', '321231', '321', '321');
INSERT INTO `car` VALUES ('73', '321231', '321', 'dsadsa');
INSERT INTO `car` VALUES ('74', '321231', '321', 'dsadsadas');
INSERT INTO `car` VALUES ('75', '321231', '321', '321');
INSERT INTO `car` VALUES ('76', '321231', '321', 'fafsa撒法发');
INSERT INTO `car` VALUES ('77', '321231', '321', 'dragon');
INSERT INTO `car` VALUES ('78', '321231', '321', 'zhanghaolong');
INSERT INTO `car` VALUES ('79', '20', '4', '龙');
INSERT INTO `car` VALUES ('80', '2', '231', 'dass');
INSERT INTO `car` VALUES ('81', '324', '3243', '2dra');

-- ----------------------------
-- Table structure for comment
-- ----------------------------
DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment` (
  `comment_id` int(11) NOT NULL AUTO_INCREMENT,
  `comment_content` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `user_name` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`comment_id`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of comment
-- ----------------------------
INSERT INTO `comment` VALUES ('14', '测试', 'ewq', '2020-04-24 20:21:38');
INSERT INTO `comment` VALUES ('21', '这是测试内容2', 'user2', '2020-04-24 17:17:31');
INSERT INTO `comment` VALUES ('27', '这是测试内容1', 'user1', '2020-04-24 17:17:28');
INSERT INTO `comment` VALUES ('30', '这是测试内容2', 'user2', '2020-04-24 17:17:31');
INSERT INTO `comment` VALUES ('31', '这是测试内容1', 'user1', '2020-04-24 17:17:28');
INSERT INTO `comment` VALUES ('32', '这是测试内容2', 'user2', '2020-04-24 17:17:31');
INSERT INTO `comment` VALUES ('33', '这是测试内容1', 'user1', '2020-04-24 17:17:28');
INSERT INTO `comment` VALUES ('34', '这是测试内容2', 'user2', '2020-04-24 17:17:31');
INSERT INTO `comment` VALUES ('35', '这是测试内容1', 'user1', '2020-04-24 17:17:28');
INSERT INTO `comment` VALUES ('36', '这是测试内容2', 'user2', '2020-04-24 17:17:31');
INSERT INTO `comment` VALUES ('37', '这是测试内容1', 'user1', '2020-04-24 17:17:28');
INSERT INTO `comment` VALUES ('38', '这是测试内容2', 'user2', '2020-04-24 17:17:31');
INSERT INTO `comment` VALUES ('39', '这是测试内容1', 'user1', '2020-04-24 17:17:28');
INSERT INTO `comment` VALUES ('40', '这是测试内容2', 'user2', '2020-04-24 17:17:31');
INSERT INTO `comment` VALUES ('41', '这是测试内容1', 'user1', '2020-04-24 17:17:28');
INSERT INTO `comment` VALUES ('42', '这是测试内容2', 'user2', '2020-04-24 17:17:31');
INSERT INTO `comment` VALUES ('43', '这是测试内容1', 'user1', '2020-04-24 17:17:28');
INSERT INTO `comment` VALUES ('44', '这是测试内容2', 'user2', '2020-04-24 17:17:31');
INSERT INTO `comment` VALUES ('45', '这是测试内容1', 'user1', '2020-04-24 17:17:28');
INSERT INTO `comment` VALUES ('46', '这是测试内容2', 'user2', '2020-04-24 17:17:31');
INSERT INTO `comment` VALUES ('47', '这是测试内容1', 'user1', '2020-04-24 17:17:28');
INSERT INTO `comment` VALUES ('48', '这是测试内容2', 'user2', '2020-04-24 17:17:31');
INSERT INTO `comment` VALUES ('49', '这是测试内容1', 'user1', '2020-04-24 17:17:28');
INSERT INTO `comment` VALUES ('50', '这是测试内容2', 'user2', '2020-04-24 17:17:31');
INSERT INTO `comment` VALUES ('51', '这是测试内容1', 'user1', '2020-04-24 17:17:28');
INSERT INTO `comment` VALUES ('52', '这是测试内容2', 'user2', '2020-04-24 17:17:31');
INSERT INTO `comment` VALUES ('53', '这是测试内容1', 'user1', '2020-04-24 17:17:28');
INSERT INTO `comment` VALUES ('54', '这是测试内容2', 'user2', '2020-04-24 17:17:31');
INSERT INTO `comment` VALUES ('55', '这是测试内容1', 'user1', '2020-04-24 17:17:28');
INSERT INTO `comment` VALUES ('56', '这是测试内容2', 'user2', '2020-04-24 17:17:31');
INSERT INTO `comment` VALUES ('57', '这是测试内容1', 'user1', '2020-04-24 17:17:28');
INSERT INTO `comment` VALUES ('60', '这是测试内容2', 'ds', '2020-04-24 20:22:22');
INSERT INTO `comment` VALUES ('62', '这是测试内容2', 'user2', '2020-04-24 17:17:31');
INSERT INTO `comment` VALUES ('63', '你好，这是测试', '张', '2020-04-24 19:40:32');
INSERT INTO `comment` VALUES ('65', '这是测试啊啊啊啊啊啊啊啊啊啊啊啊', 'dragon', '2020-04-24 20:22:05');
INSERT INTO `comment` VALUES ('66', '231', '31', '2020-05-01 10:17:19');

-- ----------------------------
-- Table structure for flight
-- ----------------------------
DROP TABLE IF EXISTS `flight`;
CREATE TABLE `flight` (
  `flight_id` int(11) NOT NULL AUTO_INCREMENT,
  `flight_price` int(11) DEFAULT NULL,
  `flight_seats` int(11) DEFAULT NULL,
  `flight_from_city` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `flight_to_city` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`flight_id`)
) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of flight
-- ----------------------------
INSERT INTO `flight` VALUES ('1', '2131', '3', 'dsads', 'sda');
INSERT INTO `flight` VALUES ('2', '432', '342', '43', '2342');
INSERT INTO `flight` VALUES ('3', '32', '432', '432', '432');
INSERT INTO `flight` VALUES ('4', '342', '432', '432', '432');
INSERT INTO `flight` VALUES ('5', '432', '432', '342', 'd');
INSERT INTO `flight` VALUES ('6', '43234', '42', '342', '432');
INSERT INTO `flight` VALUES ('7', '432', '432', '432', '3');
INSERT INTO `flight` VALUES ('8', '342', '432', '432', '32r32');
INSERT INTO `flight` VALUES ('9', '32', '332', 'r32', 'r32');
INSERT INTO `flight` VALUES ('10', '32', '32', '3r2', '23r23r2');
INSERT INTO `flight` VALUES ('11', '232', '32352', '532c', 'c32');
INSERT INTO `flight` VALUES ('12', '32', '232', 'cc', 'cc');
INSERT INTO `flight` VALUES ('14', '1000', '58', '北京', '上海');
INSERT INTO `flight` VALUES ('15', '667', '156', '西安', '新疆');
INSERT INTO `flight` VALUES ('16', '1000', '58', '北京', '上海');
INSERT INTO `flight` VALUES ('17', '667', '156', '西安', '新疆');
INSERT INTO `flight` VALUES ('18', '1000', '58', '北京', '上海');
INSERT INTO `flight` VALUES ('19', '667', '156', '西安', '新疆');
INSERT INTO `flight` VALUES ('20', '1000', '58', '北京', '上海');
INSERT INTO `flight` VALUES ('21', '667', '156', '西安', '新疆');
INSERT INTO `flight` VALUES ('22', '1000', '58', '北京', '上海');
INSERT INTO `flight` VALUES ('23', '667', '156', '西安', '新疆');
INSERT INTO `flight` VALUES ('24', '1000', '58', '北京', '上海');
INSERT INTO `flight` VALUES ('25', '667', '156', '西安', '新疆');
INSERT INTO `flight` VALUES ('26', '1000', '58', '北京', '上海');
INSERT INTO `flight` VALUES ('27', '667', '156', '西安', '新疆');
INSERT INTO `flight` VALUES ('28', '1000', '58', '北京', '上海');
INSERT INTO `flight` VALUES ('29', '667', '156', '西安', '新疆');
INSERT INTO `flight` VALUES ('30', '1000', '58', '北京', '上海');
INSERT INTO `flight` VALUES ('31', '667', '156', '西安', '新疆');
INSERT INTO `flight` VALUES ('32', '1000', '58', '北京', '上海');
INSERT INTO `flight` VALUES ('33', '667', '156', '西安', '新疆');
INSERT INTO `flight` VALUES ('34', '1000', '58', '北京', '上海');
INSERT INTO `flight` VALUES ('35', '667', '156', '西安', '新疆');
INSERT INTO `flight` VALUES ('36', '1000', '58', '北京', '上海');
INSERT INTO `flight` VALUES ('37', '667', '156', '西安', '新疆');
INSERT INTO `flight` VALUES ('38', '1000', '58', '北京', '上海');
INSERT INTO `flight` VALUES ('39', '667', '156', '西安', '新疆');
INSERT INTO `flight` VALUES ('40', '1000', '58', '北京', '上海');
INSERT INTO `flight` VALUES ('41', '667', '156', '西安', '新疆');
INSERT INTO `flight` VALUES ('42', '1000', '58', '北京', '上海');
INSERT INTO `flight` VALUES ('43', '667', '156', '西安', '新疆');
INSERT INTO `flight` VALUES ('44', '1000', '58', '北京', '上海');
INSERT INTO `flight` VALUES ('45', '667', '156', '西安', '新疆');
INSERT INTO `flight` VALUES ('46', '1000', '58', '北京', '上海');
INSERT INTO `flight` VALUES ('47', '667', '156', '西安', '新疆');
INSERT INTO `flight` VALUES ('48', '1000', '58', '北京', '上海');
INSERT INTO `flight` VALUES ('49', '667', '156', '西安', '新疆');
INSERT INTO `flight` VALUES ('50', '1000', '58', '北京', '上海');
INSERT INTO `flight` VALUES ('51', '667', '156', '西安', '新疆');
INSERT INTO `flight` VALUES ('52', '1000', '58', '北京', '上海');
INSERT INTO `flight` VALUES ('53', '667', '156', '西安', '新疆');
INSERT INTO `flight` VALUES ('54', '1000', '58', '北京', '上海');
INSERT INTO `flight` VALUES ('55', '667', '156', '西安', '新疆');
INSERT INTO `flight` VALUES ('56', '1000', '58', '北京', '上海');
INSERT INTO `flight` VALUES ('57', '667', '156', '西安', '新疆');
INSERT INTO `flight` VALUES ('58', '1000', '58', '北京', '上海');
INSERT INTO `flight` VALUES ('59', '667', '156', '西安', '新疆');
INSERT INTO `flight` VALUES ('60', '1000', '58', '北京', '上海');
INSERT INTO `flight` VALUES ('61', '667', '156', '西安', '新疆');
INSERT INTO `flight` VALUES ('62', '1000', '58', '北京', '上海');
INSERT INTO `flight` VALUES ('63', '667', '156', '西安', '新疆');
INSERT INTO `flight` VALUES ('64', '1000', '58', '北京', '上海');
INSERT INTO `flight` VALUES ('65', '667', '156', '西安', '新疆');
INSERT INTO `flight` VALUES ('66', '1000', '58', '北京', '上海');
INSERT INTO `flight` VALUES ('67', '667', '156', '西安', '新疆');
INSERT INTO `flight` VALUES ('68', '1000', '58', '北京', '上海');
INSERT INTO `flight` VALUES ('69', '667', '156', '西安', '新疆');
INSERT INTO `flight` VALUES ('70', '1000', '58', '北京', '上海');
INSERT INTO `flight` VALUES ('71', '667', '156', '西安', '新疆');
INSERT INTO `flight` VALUES ('72', '1000', '58', '北京', '上海');
INSERT INTO `flight` VALUES ('73', '667', '156', '西安', '新疆');
INSERT INTO `flight` VALUES ('74', '1000', '58', '北京', '上海');
INSERT INTO `flight` VALUES ('75', '667', '156', '西安', '新疆');
INSERT INTO `flight` VALUES ('76', '1000', '58', '北京', '上海');
INSERT INTO `flight` VALUES ('77', '667', '156', '西安', '新疆');
INSERT INTO `flight` VALUES ('78', '1000', '58', '北京', '上海');
INSERT INTO `flight` VALUES ('79', '667', '156', '西安', '新疆');

-- ----------------------------
-- Table structure for hotel
-- ----------------------------
DROP TABLE IF EXISTS `hotel`;
CREATE TABLE `hotel` (
  `hotel_id` int(11) NOT NULL AUTO_INCREMENT,
  `hotel_name` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `hotel_price` int(11) DEFAULT NULL,
  `hotel_location` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `hotel_rooms` int(11) DEFAULT NULL,
  PRIMARY KEY (`hotel_id`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of hotel
-- ----------------------------
INSERT INTO `hotel` VALUES ('3', '七天', '1', '安徽', '68');
INSERT INTO `hotel` VALUES ('6', '速八', '64', '郑州', '165');
INSERT INTO `hotel` VALUES ('7', '七天', '253', '安徽', '68');
INSERT INTO `hotel` VALUES ('9', '七天', '253', '安徽', '68');
INSERT INTO `hotel` VALUES ('10', '速八', '64', '郑州', '165');
INSERT INTO `hotel` VALUES ('11', '七天', '253', '安徽', '68');
INSERT INTO `hotel` VALUES ('13', '七天', '253', '安徽', '68');
INSERT INTO `hotel` VALUES ('14', '速八', '64', '郑州', '165');
INSERT INTO `hotel` VALUES ('15', '七天', '253', '安徽', '68');
INSERT INTO `hotel` VALUES ('16', '速八', '64', '郑州', '165');
INSERT INTO `hotel` VALUES ('17', '七天', '253', '安徽', '68');
INSERT INTO `hotel` VALUES ('18', '速八', '64', '郑州', '165');
INSERT INTO `hotel` VALUES ('19', '七天', '253', '安徽', '68');
INSERT INTO `hotel` VALUES ('20', '速八', '64', '郑州', '165');
INSERT INTO `hotel` VALUES ('21', '七天', '253', '安徽', '68');
INSERT INTO `hotel` VALUES ('22', '速八', '64', '郑州', '165');
INSERT INTO `hotel` VALUES ('23', '七天', '253', '安徽', '68');
INSERT INTO `hotel` VALUES ('24', '速八', '64', '郑州', '165');
INSERT INTO `hotel` VALUES ('25', '七天', '253', '安徽', '68');
INSERT INTO `hotel` VALUES ('26', '速八', '64', '郑州', '165');
INSERT INTO `hotel` VALUES ('27', '七天', '253', '安徽', '68');
INSERT INTO `hotel` VALUES ('28', '速八', '64', '郑州', '165');
INSERT INTO `hotel` VALUES ('29', '七天', '253', '安徽', '68');
INSERT INTO `hotel` VALUES ('30', '速八', '64', '郑州', '165');
INSERT INTO `hotel` VALUES ('31', '七天', '253', '安徽', '68');
INSERT INTO `hotel` VALUES ('32', '速八', '64', '郑州', '165');
INSERT INTO `hotel` VALUES ('33', '七天', '253', '安徽', '68');
INSERT INTO `hotel` VALUES ('34', '速八', '64', '郑州', '165');
INSERT INTO `hotel` VALUES ('35', '七天', '253', '安徽', '68');
INSERT INTO `hotel` VALUES ('36', '速八', '64', '郑州', '165');
INSERT INTO `hotel` VALUES ('37', '七天', '253', '安徽', '68');
INSERT INTO `hotel` VALUES ('38', '速八', '64', '郑州', '165');
INSERT INTO `hotel` VALUES ('39', '七天', '253', '安徽', '68');
INSERT INTO `hotel` VALUES ('40', '速八', '64', '郑州', '165');
INSERT INTO `hotel` VALUES ('41', '七天', '253', '安徽', '68');
INSERT INTO `hotel` VALUES ('42', '速八', '64', '郑州', '165');
INSERT INTO `hotel` VALUES ('43', '七天', '253', '安徽', '68');
INSERT INTO `hotel` VALUES ('44', '速八', '64', '郑州', '165');
INSERT INTO `hotel` VALUES ('45', '七天', '253', '安徽', '68');
INSERT INTO `hotel` VALUES ('46', '速八', '64', '郑州', '165');
INSERT INTO `hotel` VALUES ('47', '七天', '253', '安徽', '68');
INSERT INTO `hotel` VALUES ('48', '速八', '64', '郑州', '165');
INSERT INTO `hotel` VALUES ('49', '七天', '253', '安徽', '68');
INSERT INTO `hotel` VALUES ('50', '速八', '64', '郑州', '165');
INSERT INTO `hotel` VALUES ('51', '七天', '253', '安徽', '68');
INSERT INTO `hotel` VALUES ('52', '速八', '64', '郑州', '165');
INSERT INTO `hotel` VALUES ('53', '七天', '253', '安徽', '68');
INSERT INTO `hotel` VALUES ('54', '速八', '64', '郑州', '165');
INSERT INTO `hotel` VALUES ('55', '七天', '253', '安徽', '68');
INSERT INTO `hotel` VALUES ('56', '速八', '64', '郑州', '165');
INSERT INTO `hotel` VALUES ('57', '七天', '253', '安徽', '68');
INSERT INTO `hotel` VALUES ('58', '速八', '64', '郑州', '165');
INSERT INTO `hotel` VALUES ('59', '七天', '253', '安徽', '68');
INSERT INTO `hotel` VALUES ('60', '速八', '64', '郑州', '165');
INSERT INTO `hotel` VALUES ('61', '七天', '253', '安徽', '68');
INSERT INTO `hotel` VALUES ('62', '速八', '64', '郑州', '165');
INSERT INTO `hotel` VALUES ('63', '七天', '253', '安徽', '68');
INSERT INTO `hotel` VALUES ('64', '速八', '64', '郑州', '165');
INSERT INTO `hotel` VALUES ('65', '七天', '253', '安徽', '68');
INSERT INTO `hotel` VALUES ('66', '速八', '64', '郑州', '165');

-- ----------------------------
-- Table structure for scenery
-- ----------------------------
DROP TABLE IF EXISTS `scenery`;
CREATE TABLE `scenery` (
  `scenery_id` int(11) NOT NULL AUTO_INCREMENT,
  `scenery_city` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `scenery_title` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `scenery_price` int(11) DEFAULT NULL,
  `scenery_route` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`scenery_id`)
) ENGINE=InnoDB AUTO_INCREMENT=83 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of scenery
-- ----------------------------
INSERT INTO `scenery` VALUES ('1', '四川', '四川之旅', '168', '郑州-四川');
INSERT INTO `scenery` VALUES ('2', '成都', '成都一日游', '254', '河南-成都');
INSERT INTO `scenery` VALUES ('3', '四川', '四川之旅', '168', '郑州-四川');
INSERT INTO `scenery` VALUES ('4', '成都', '成都一日游', '254', '河南-成都');
INSERT INTO `scenery` VALUES ('5', '四川', '四川之旅', '168', '郑州-四川');
INSERT INTO `scenery` VALUES ('6', '成都', '成都一日游', '254', '河南-成都');
INSERT INTO `scenery` VALUES ('7', '四川', '四川之旅', '168', '郑州-四川');
INSERT INTO `scenery` VALUES ('8', '成都', '成都一日游', '254', '河南-成都');
INSERT INTO `scenery` VALUES ('9', '四川', '四川之旅', '168', '郑州-四川');
INSERT INTO `scenery` VALUES ('10', '成都', '成都一日游', '254', '河南-成都');
INSERT INTO `scenery` VALUES ('11', '四川', '四川之旅', '168', '郑州-四川');
INSERT INTO `scenery` VALUES ('12', '成都', '成都一日游', '254', '河南-成都');
INSERT INTO `scenery` VALUES ('13', '四川', '四川之旅', '168', '郑州-四川');
INSERT INTO `scenery` VALUES ('14', '成都', '成都一日游', '254', '河南-成都');
INSERT INTO `scenery` VALUES ('15', '四川', '四川之旅', '168', '郑州-四川');
INSERT INTO `scenery` VALUES ('16', '成都', '成都一日游', '254', '河南-成都');
INSERT INTO `scenery` VALUES ('17', '四川', '四川之旅', '168', '郑州-四川');
INSERT INTO `scenery` VALUES ('18', '成都', '成都一日游', '254', '河南-成都');
INSERT INTO `scenery` VALUES ('19', '四川', '四川之旅', '168', '郑州-四川');
INSERT INTO `scenery` VALUES ('20', '成都', '成都一日游', '254', '河南-成都');
INSERT INTO `scenery` VALUES ('21', '四川', '四川之旅', '168', '郑州-四川');
INSERT INTO `scenery` VALUES ('22', '成都', '成都一日游', '254', '河南-成都');
INSERT INTO `scenery` VALUES ('23', '四川', '四川之旅', '168', '郑州-四川');
INSERT INTO `scenery` VALUES ('24', '成都', '成都一日游', '254', '河南-成都');
INSERT INTO `scenery` VALUES ('25', '四川', '四川之旅', '168', '郑州-四川');
INSERT INTO `scenery` VALUES ('26', '成都', '成都一日游', '254', '河南-成都');
INSERT INTO `scenery` VALUES ('27', '四川', '四川之旅', '168', '郑州-四川');
INSERT INTO `scenery` VALUES ('28', '成都', '成都一日游', '254', '河南-成都');
INSERT INTO `scenery` VALUES ('29', '四川', '四川之旅', '168', '郑州-四川');
INSERT INTO `scenery` VALUES ('30', '成都', '成都一日游', '254', '河南-成都');
INSERT INTO `scenery` VALUES ('31', '四川', '四川之旅', '168', '郑州-四川');
INSERT INTO `scenery` VALUES ('32', '成都', '成都一日游', '254', '河南-成都');
INSERT INTO `scenery` VALUES ('33', '四川', '四川之旅', '168', '郑州-四川');
INSERT INTO `scenery` VALUES ('34', '成都', '成都一日游', '254', '河南-成都');
INSERT INTO `scenery` VALUES ('35', '四川', '四川之旅', '168', '郑州-四川');
INSERT INTO `scenery` VALUES ('36', '成都', '成都一日游', '254', '河南-成都');
INSERT INTO `scenery` VALUES ('37', '四川', '四川之旅', '168', '郑州-四川');
INSERT INTO `scenery` VALUES ('38', '成都', '成都一日游', '254', '河南-成都');
INSERT INTO `scenery` VALUES ('39', '四川', '四川之旅', '168', '郑州-四川');
INSERT INTO `scenery` VALUES ('40', '成都', '成都一日游', '254', '河南-成都');
INSERT INTO `scenery` VALUES ('41', '四川', '四川之旅', '168', '郑州-四川');
INSERT INTO `scenery` VALUES ('42', '成都', '成都一日游', '254', '河南-成都');
INSERT INTO `scenery` VALUES ('43', '四川', '四川之旅', '168', '郑州-四川');
INSERT INTO `scenery` VALUES ('44', '成都', '成都一日游', '254', '河南-成都');
INSERT INTO `scenery` VALUES ('45', '四川', '四川之旅', '168', '郑州-四川');
INSERT INTO `scenery` VALUES ('46', '成都', '成都一日游', '254', '河南-成都');
INSERT INTO `scenery` VALUES ('47', '四川', '四川之旅', '168', '郑州-四川');
INSERT INTO `scenery` VALUES ('48', '成都', '成都一日游', '254', '河南-成都');
INSERT INTO `scenery` VALUES ('49', '四川', '四川之旅', '168', '郑州-四川');
INSERT INTO `scenery` VALUES ('50', '成都', '成都一日游', '254', '河南-成都');
INSERT INTO `scenery` VALUES ('51', '四川', '四川之旅', '168', '郑州-四川');
INSERT INTO `scenery` VALUES ('52', '成都', '成都一日游', '254', '河南-成都');
INSERT INTO `scenery` VALUES ('53', '四川', '四川之旅', '168', '郑州-四川');
INSERT INTO `scenery` VALUES ('54', '成都', '成都一日游', '254', '河南-成都');
INSERT INTO `scenery` VALUES ('55', '四川', '四川之旅', '168', '郑州-四川');
INSERT INTO `scenery` VALUES ('56', '成都', '成都一日游', '254', '河南-成都');
INSERT INTO `scenery` VALUES ('57', '四川', '四川之旅', '168', '郑州-四川');
INSERT INTO `scenery` VALUES ('58', '成都', '成都一日游', '254', '河南-成都');
INSERT INTO `scenery` VALUES ('59', '四川', '四川之旅', '168', '郑州-四川');
INSERT INTO `scenery` VALUES ('60', '成都', '成都一日游', '254', '河南-成都');
INSERT INTO `scenery` VALUES ('61', '四川', '四川之旅', '168', '郑州-四川');
INSERT INTO `scenery` VALUES ('62', '成都', '成都一日游', '254', '河南-成都');
INSERT INTO `scenery` VALUES ('63', '四川', '四川之旅', '168', '郑州-四川');
INSERT INTO `scenery` VALUES ('64', '成都', '成都一日游', '254', '河南-成都');
INSERT INTO `scenery` VALUES ('65', '四川', '四川之旅', '168', '郑州-四川');
INSERT INTO `scenery` VALUES ('66', '成都', '成都一日游', '254', '河南-成都');
INSERT INTO `scenery` VALUES ('67', '四川', '四川之旅', '168', '郑州-四川');
INSERT INTO `scenery` VALUES ('68', '成都', '成都一日游', '254', '河南-成都');
INSERT INTO `scenery` VALUES ('69', '四川', '四川之旅', '168', '郑州-四川');
INSERT INTO `scenery` VALUES ('70', '成都', '成都一日游', '254', '河南-成都');
INSERT INTO `scenery` VALUES ('71', '四川', '四川之旅', '168', '郑州-四川');
INSERT INTO `scenery` VALUES ('72', '成都', '成都一日游', '254', '河南-成都');
INSERT INTO `scenery` VALUES ('73', '四川', '四川之旅', '168', '郑州-四川');
INSERT INTO `scenery` VALUES ('74', '成都', '成都一日游', '254', '河南-成都');
INSERT INTO `scenery` VALUES ('75', '四川', '四川之旅', '168', '郑州-四川');
INSERT INTO `scenery` VALUES ('76', '成都', '成都一日游', '254', '河南-成都');
INSERT INTO `scenery` VALUES ('77', '四川', '四川之旅', '168', '郑州-四川');
INSERT INTO `scenery` VALUES ('78', '成都', '成都一日游', '254', '河南-成都');
INSERT INTO `scenery` VALUES ('79', '四川', '四川之旅', '168', '郑州-四川');
INSERT INTO `scenery` VALUES ('80', '成都', '成都一日游', '254', '河南-成都');
INSERT INTO `scenery` VALUES ('81', '四川', '四川之旅', '168', '郑州-四川');
INSERT INTO `scenery` VALUES ('82', '成都', '成都一日游', '254', '河南-成都');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_name` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `user_password` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', 'dragon', '123456');
INSERT INTO `user` VALUES ('2', 'root', '123456');

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `users_id` int(11) NOT NULL AUTO_INCREMENT,
  `users_name` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `users_password` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `users_sex` int(11) DEFAULT NULL,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`users_id`)
) ENGINE=InnoDB AUTO_INCREMENT=85 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES ('3', '张三sdadsa', '123456dsa', '1', '2020-04-29 14:51:48');
INSERT INTO `users` VALUES ('4', '李四', '36515', '1', '2020-04-24 21:43:46');
INSERT INTO `users` VALUES ('6', '李四', '36515', '1', '2020-04-24 21:43:46');
INSERT INTO `users` VALUES ('8', '李四', '36515', '1', '2020-04-24 21:43:46');
INSERT INTO `users` VALUES ('9', '张三', '123456', '2', '2020-04-24 21:43:31');
INSERT INTO `users` VALUES ('10', '李四', '36515', '1', '2020-04-24 21:43:46');
INSERT INTO `users` VALUES ('11', '张三', '123456', '2', '2020-04-24 21:43:31');
INSERT INTO `users` VALUES ('12', '李四', '36515', '1', '2020-04-24 21:43:46');
INSERT INTO `users` VALUES ('13', '张三', '123456', '2', '2020-04-24 21:43:31');
INSERT INTO `users` VALUES ('14', '李四', '36515', '1', '2020-04-24 21:43:46');
INSERT INTO `users` VALUES ('15', '张三', '123456', '2', '2020-04-24 21:43:31');
INSERT INTO `users` VALUES ('16', '李四', '36515', '1', '2020-04-24 21:43:46');
INSERT INTO `users` VALUES ('17', '张三', '123456', '2', '2020-04-24 21:43:31');
INSERT INTO `users` VALUES ('18', '李四', '36515', '1', '2020-04-24 21:43:46');
INSERT INTO `users` VALUES ('19', '张三', '123456', '2', '2020-04-24 21:43:31');
INSERT INTO `users` VALUES ('20', '李四', '36515', '1', '2020-04-24 21:43:46');
INSERT INTO `users` VALUES ('21', '张三', '123456', '2', '2020-04-24 21:43:31');
INSERT INTO `users` VALUES ('22', '李四', '36515', '1', '2020-04-24 21:43:46');
INSERT INTO `users` VALUES ('23', '张三', '123456', '2', '2020-04-24 21:43:31');
INSERT INTO `users` VALUES ('24', '李四', '36515', '1', '2020-04-24 21:43:46');
INSERT INTO `users` VALUES ('25', '张三', '123456', '2', '2020-04-24 21:43:31');
INSERT INTO `users` VALUES ('26', '李四', '36515', '1', '2020-04-24 21:43:46');
INSERT INTO `users` VALUES ('27', '张三', '123456', '2', '2020-04-24 21:43:31');
INSERT INTO `users` VALUES ('28', '李四', '36515', '1', '2020-04-24 21:43:46');
INSERT INTO `users` VALUES ('29', '张三', '123456', '2', '2020-04-24 21:43:31');
INSERT INTO `users` VALUES ('30', '李四', '36515', '1', '2020-04-24 21:43:46');
INSERT INTO `users` VALUES ('31', '张三', '123456', '2', '2020-04-24 21:43:31');
INSERT INTO `users` VALUES ('32', '李四', '36515', '1', '2020-04-24 21:43:46');
INSERT INTO `users` VALUES ('33', '张三', '123456', '2', '2020-04-24 21:43:31');
INSERT INTO `users` VALUES ('34', '李四', '36515', '1', '2020-04-24 21:43:46');
INSERT INTO `users` VALUES ('35', '张三', '123456', '2', '2020-04-24 21:43:31');
INSERT INTO `users` VALUES ('36', '李四', '36515', '1', '2020-04-24 21:43:46');
INSERT INTO `users` VALUES ('37', '张三', '123456', '2', '2020-04-24 21:43:31');
INSERT INTO `users` VALUES ('38', '李四', '36515', '1', '2020-04-24 21:43:46');
INSERT INTO `users` VALUES ('39', '张三', '123456', '2', '2020-04-24 21:43:31');
INSERT INTO `users` VALUES ('40', '李四', '36515', '1', '2020-04-24 21:43:46');
INSERT INTO `users` VALUES ('41', '张三', '123456', '2', '2020-04-24 21:43:31');
INSERT INTO `users` VALUES ('42', '李四', '36515', '1', '2020-04-24 21:43:46');
INSERT INTO `users` VALUES ('43', '张三', '123456', '2', '2020-04-24 21:43:31');
INSERT INTO `users` VALUES ('44', '李四', '36515', '1', '2020-04-24 21:43:46');
INSERT INTO `users` VALUES ('45', '张三', '123456', '2', '2020-04-24 21:43:31');
INSERT INTO `users` VALUES ('46', '李四', '36515', '1', '2020-04-24 21:43:46');
INSERT INTO `users` VALUES ('47', '张三', '123456', '2', '2020-04-24 21:43:31');
INSERT INTO `users` VALUES ('48', '李四', '36515', '1', '2020-04-24 21:43:46');
INSERT INTO `users` VALUES ('49', '张三', '123456', '2', '2020-04-24 21:43:31');
INSERT INTO `users` VALUES ('50', '李四', '36515', '1', '2020-04-24 21:43:46');
INSERT INTO `users` VALUES ('51', '张三', '123456', '2', '2020-04-24 21:43:31');
INSERT INTO `users` VALUES ('52', '李四', '36515', '1', '2020-04-24 21:43:46');
INSERT INTO `users` VALUES ('53', '张三', '123456', '2', '2020-04-24 21:43:31');
INSERT INTO `users` VALUES ('54', '李四', '36515', '1', '2020-04-24 21:43:46');
INSERT INTO `users` VALUES ('55', '张三', '123456', '2', '2020-04-24 21:43:31');
INSERT INTO `users` VALUES ('56', '李四', '36515', '1', '2020-04-24 21:43:46');
INSERT INTO `users` VALUES ('57', '张三', '123456', '2', '2020-04-24 21:43:31');
INSERT INTO `users` VALUES ('58', '李四', '36515', '1', '2020-04-24 21:43:46');
INSERT INTO `users` VALUES ('59', '张三', '123456', '2', '2020-04-24 21:43:31');
INSERT INTO `users` VALUES ('60', '李四', '36515', '1', '2020-04-24 21:43:46');
INSERT INTO `users` VALUES ('61', '张三', '123456', '2', '2020-04-24 21:43:31');
INSERT INTO `users` VALUES ('62', '李四', '36515', '1', '2020-04-24 21:43:46');
INSERT INTO `users` VALUES ('63', '张三', '123456', '2', '2020-04-24 21:43:31');
INSERT INTO `users` VALUES ('64', '李四', '36515', '1', '2020-04-24 21:43:46');
INSERT INTO `users` VALUES ('65', '张三', '123456', '2', '2020-04-24 21:43:31');
INSERT INTO `users` VALUES ('66', '李四', '36515', '1', '2020-04-24 21:43:46');
INSERT INTO `users` VALUES ('67', '张三', '123456', '2', '2020-04-24 21:43:31');
INSERT INTO `users` VALUES ('68', '李四', '36515', '1', '2020-04-24 21:43:46');
INSERT INTO `users` VALUES ('69', '张三', '123456', '2', '2020-04-24 21:43:31');
INSERT INTO `users` VALUES ('70', '李四', '36515', '1', '2020-04-24 21:43:46');
INSERT INTO `users` VALUES ('71', '张三', '123456', '2', '2020-04-24 21:43:31');
INSERT INTO `users` VALUES ('72', '李四', '36515', '1', '2020-04-24 21:43:46');
INSERT INTO `users` VALUES ('73', '张三', '123456', '2', '2020-04-24 21:43:31');
INSERT INTO `users` VALUES ('74', '李四', '36515', '1', '2020-04-24 21:43:46');
INSERT INTO `users` VALUES ('75', '张三', '123456', '2', '2020-04-24 21:43:31');
INSERT INTO `users` VALUES ('76', '李四', '36515', '1', '2020-04-24 21:43:46');
INSERT INTO `users` VALUES ('77', '张三', '123456', '2', '2020-04-24 21:43:31');
INSERT INTO `users` VALUES ('78', '李四', '36515', '1', '2020-04-24 21:43:46');
INSERT INTO `users` VALUES ('79', '张三', '123456', '2', '2020-04-24 21:43:31');
INSERT INTO `users` VALUES ('80', '李四', '36515', '1', '2020-04-24 21:43:46');
INSERT INTO `users` VALUES ('81', '张三', '123456', '2', '2020-04-24 21:43:31');
INSERT INTO `users` VALUES ('82', '李四', '36515', '1', '2020-04-24 21:43:46');
INSERT INTO `users` VALUES ('83', '张三', '123456', '2', '2020-04-24 21:43:31');
INSERT INTO `users` VALUES ('84', '李四', '36515', '1', '2020-04-24 21:43:46');