lvyouwang.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

/*
Navicat MySQL Data Transfer

Source Server         : 127.0.0.1
Source Server Version : 50714
Source Host           : localhost:3306
Source Database       : lvyouwang

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

Date: 2020-03-03 20:28:23
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for t_admin
-- ----------------------------
DROP TABLE IF EXISTS `t_admin`;
CREATE TABLE `t_admin` (
  `userId` int(11) DEFAULT NULL,
  `userName` varchar(255) DEFAULT NULL,
  `userPw` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of t_admin
-- ----------------------------
INSERT INTO `t_admin` VALUES ('1', 'a', 'a');

-- ----------------------------
-- Table structure for t_jingdian
-- ----------------------------
DROP TABLE IF EXISTS `t_jingdian`;
CREATE TABLE `t_jingdian` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mingcheng` varchar(255) DEFAULT NULL,
  `chengshi` varchar(255) DEFAULT NULL,
  `weizhi` varchar(255) DEFAULT NULL,
  `tese` varchar(255) DEFAULT NULL,
  `jieshao` text,
  `jiage` varchar(255) DEFAULT NULL,
  `tianshu` varchar(255) DEFAULT NULL,
  `fujian` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of t_jingdian
-- ----------------------------
INSERT INTO `t_jingdian` VALUES ('2', '丽江古城', '云南丽江', '云南省丽江市大研镇', '世界文化遗产', '<span style=\"text-align: left; color: rgb(18, 18, 18); text-transform: none; text-indent: 24px; letter-spacing: normal; font-family: 微软雅黑, 宋体, Arial, Helvetica, sans-serif, 宋体; font-size: 12px; font-style: normal; font-weight: 400; word-spacing: 0px; float: none; display: inline !important; white-space: normal; orphans: 2; widows: 2; background-color: rgb(255, 255, 255); font-variant-ligatures: normal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial;\">丽江古城始建于南宋，距今约有800年的历史。历代均为滇西北的政治，军事重镇和纳西，汉，藏等各民族经济文化交往的枢纽。元初，忽必烈南征大理，革囊渡金沙江进入丽江，曾在古城一带驻军整训，至今仍留下许多相关的纳西语地名。元初，古城居民至少已有千余户，明初，古城街道建设和集市贸易已初具规模，至明末已呈繁荣景象</span>', '200', '2\"', '/upload/1583230977150.jpg');
INSERT INTO `t_jingdian` VALUES ('3', '八达岭长城', '北京', '北京', '全程优秀挂牌导游服务', '<span style=\"color: rgb(85, 85, 85); text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: tahoma, arial, 宋体, sans-serif; font-size: 14px; font-style: normal; font-weight: 400; word-spacing: 0px; float: none; display: inline !important; white-space: normal; orphans: 2; widows: 2; font-variant-ligatures: normal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial;\">门票：八达岭长城、十三陵定陵；<span>&nbsp;</span></span><br style=\"color: rgb(85, 85, 85); text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: tahoma, arial, 宋体, sans-serif; font-size: 14px; font-style: normal; font-weight: 400; word-spacing: 0px; white-space: normal; orphans: 2; widows: 2; font-variant-ligatures: normal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial;\" />\r\n<span style=\"color: rgb(85, 85, 85); text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: tahoma, arial, 宋体, sans-serif; font-size: 14px; font-style: normal; font-weight: 400; word-spacing: 0px; float: none; display: inline !important; white-space: normal; orphans: 2; widows: 2; font-variant-ligatures: normal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial;\">用餐：行程中1个午餐；<span>&nbsp;</span></span><br style=\"color: rgb(85, 85, 85); text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: tahoma, arial, 宋体, sans-serif; font-size: 14px; font-style: normal; font-weight: 400; word-spacing: 0px; white-space: normal; orphans: 2; widows: 2; font-variant-ligatures: normal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial;\" />\r\n<span style=\"color: rgb(85, 85, 85); text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: tahoma, arial, 宋体, sans-serif; font-size: 14px; font-style: normal; font-weight: 400; word-spacing: 0px; float: none; display: inline !important; white-space: normal; orphans: 2; widows: 2; font-variant-ligatures: normal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial;\">用车：全程空调旅游车；<span>&nbsp;</span></span><br style=\"color: rgb(85, 85, 85); text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: tahoma, arial, 宋体, sans-serif; font-size: 14px; font-style: normal; font-weight: 400; word-spacing: 0px; white-space: normal; orphans: 2; widows: 2; font-variant-ligatures: normal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial;\" />\r\n<span style=\"color: rgb(85, 85, 85); text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: tahoma, arial, 宋体, sans-serif; font-size: 14px; font-style: normal; font-weight: 400; word-spacing: 0px; float: none; display: inline !important; white-space: normal; orphans: 2; widows: 2; font-variant-ligatures: normal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial;\">导游：全程优秀挂牌导游服务；<span>&nbsp;</span></span><br style=\"color: rgb(85, 85, 85); text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: tahoma, arial, 宋体, sans-serif; font-size: 14px; font-style: normal; font-weight: 400; word-spacing: 0px; white-space: normal; orphans: 2; widows: 2; font-variant-ligatures: normal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial;\" />\r\n<span style=\"color: rgb(85, 85, 85); text-transform: none; text-indent: 0px; letter-spacing: normal; font-family: tahoma, arial, 宋体, sans-serif; font-size: 14px; font-style: normal; font-weight: 400; word-spacing: 0px; float: none; display: inline !important; white-space: normal; orphans: 2; widows: 2; font-variant-ligatures: normal; font-variant-caps: normal; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial;\">保险：旅行社责任险；<span>&nbsp;</span></span>', '200', '1\"', '/upload/1583220108215.jpg');

-- ----------------------------
-- Table structure for t_jingdianpinglun
-- ----------------------------
DROP TABLE IF EXISTS `t_jingdianpinglun`;
CREATE TABLE `t_jingdianpinglun` (