/*
Navicat MySQL Data Transfer
Source Server : dd
Source Server Version : 50541
Source Host : localhost:3309
Source Database : db_travel
Target Server Type : MYSQL
Target Server Version : 50541
File Encoding : 65001
Date: 2022-05-11 16:02:00
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for ads
-- ----------------------------
DROP TABLE IF EXISTS `ads`;
CREATE TABLE `ads` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) DEFAULT NULL,
`subTitle` varchar(255) DEFAULT NULL,
`pic` varchar(255) DEFAULT NULL,
`ptime` datetime DEFAULT NULL,
`stage` int(11) DEFAULT NULL,
`describle` text,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
-- ----------------------------
-- Records of ads
-- ----------------------------
INSERT INTO `ads` VALUES ('1', '2018年江西国际旅游节圆满成功', '让世界爱上江西', 'ads/banner1.jpg', '2019-04-02 16:04:19', '1', null);
INSERT INTO `ads` VALUES ('2', '江西庐山风景区', '让世界爱上庐山', 'ads/banner2.jpg', '2020-05-02 16:05:20', '0', null);
INSERT INTO `ads` VALUES ('3', '江西三清山', '让世界爱上三清山', 'ads/banner3.jpg', '2018-04-02 16:06:25', '1', null);
INSERT INTO `ads` VALUES ('4', '滕王阁', '落霞与孤鹜齐飞', 'ads/9a41309b-2820-41a2-a576-fbd0b5c33159.png', '2021-04-23 19:03:44', '1', null);
INSERT INTO `ads` VALUES ('5', '听，风的声音！！', '来和大自然亲密接触吧！！', 'ads/67abf8f5-52a5-4474-b9d1-7074406f67c1.png', '2022-01-13 19:13:10', '1', '听，风的声音！！来和大自然亲密接触吧！！');
-- ----------------------------
-- Table structure for area
-- ----------------------------
DROP TABLE IF EXISTS `area`;
CREATE TABLE `area` (
`aid` int(11) NOT NULL AUTO_INCREMENT,
`areaNum` int(11) DEFAULT NULL,
`areaName` varchar(255) DEFAULT NULL,
`areaDescrible` text,
PRIMARY KEY (`aid`) USING BTREE,
KEY `areaNum` (`areaNum`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
-- ----------------------------
-- Records of area
-- ----------------------------
INSERT INTO `area` VALUES ('1', '1101', '南昌', '南昌很美丽');
INSERT INTO `area` VALUES ('2', '1102', '九江', '九江很美丽');
INSERT INTO `area` VALUES ('3', '1103', '赣州', '赣州很美丽');
INSERT INTO `area` VALUES ('4', '1104', '上饶', '上饶很美丽');
INSERT INTO `area` VALUES ('5', '1105', '宜春', '宜春很美丽');
INSERT INTO `area` VALUES ('6', '1106', '吉安', '吉安很美丽');
INSERT INTO `area` VALUES ('7', '1107', '抚州', '抚州很美丽');
INSERT INTO `area` VALUES ('8', '1108', '鹰潭', '鹰潭很美丽');
INSERT INTO `area` VALUES ('9', '1109', '萍乡', '萍乡很美丽');
INSERT INTO `area` VALUES ('10', '1110', '新余', '新余很美丽');
INSERT INTO `area` VALUES ('11', '1111', '景德镇', '景德镇很美丽');
-- ----------------------------
-- Table structure for content
-- ----------------------------
DROP TABLE IF EXISTS `content`;
CREATE TABLE `content` (
`cid` int(11) NOT NULL AUTO_INCREMENT,
`contentId` int(11) NOT NULL,
`areanum` int(11) DEFAULT NULL,
`categoryId` int(11) NOT NULL,
`title` varchar(255) NOT NULL,
`pic` varchar(255) NOT NULL,
`created` datetime DEFAULT NULL,
`stage` int(11) DEFAULT NULL,
PRIMARY KEY (`cid`) USING BTREE,
KEY `contentId` (`contentId`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
-- ----------------------------
-- Records of content
-- ----------------------------
INSERT INTO `content` VALUES ('1', '1', '1101', '0', '醉美滕王阁', 'area/scenic/1.jpg', '2022-03-13 03:10:00', '1');
INSERT INTO `content` VALUES ('2', '2', '1101', '0', '醉美秋水', 'area/scenic/2.jpg', '2022-04-26 10:00:00', '1');
INSERT INTO `content` VALUES ('3', '3', '1101', '0', '英雄的号角', 'area/scenic/3.jpg', '2022-04-17 00:40:00', '1');
INSERT INTO `content` VALUES ('4', '4', '1101', '0', '南昌万达海洋乐园', 'area/scenic/4.jpg', '2022-04-25 00:00:00', '1');
INSERT INTO `content` VALUES ('5', '5', '1101', '0', '南昌之星摩天轮', 'area/scenic/5.jpg', '2021-04-09 00:00:00', '1');
INSERT INTO `content` VALUES ('6', '6', '1101', '0', '梅岭国家级风景名胜区', 'area/scenic/6.jpg', '2021-04-04 00:05:00', '1');
INSERT INTO `content` VALUES ('7', '7', '1101', '0', '朱德旧居', 'area/scenic/7.jpg', '2021-04-02 00:00:00', '1');
INSERT INTO `content` VALUES ('8', '8', '1101', '0', '八一南昌起义纪念塔', 'area/scenic/8.jpg', '2019-04-02 00:04:00', '1');
INSERT INTO `content` VALUES ('9', '9', '1101', '0', '江西革命烈士纪念堂', 'area/scenic/9.jpg', '2020-04-02 00:00:00', '1');
INSERT INTO `content` VALUES ('10', '10', '1101', '0', '新四军军部旧址', 'area/scenic/10.jpg', '2022-04-02 00:10:00', '1');
INSERT INTO `content` VALUES ('11', '1', '1102', '1', '真的好吃', 'area/specialty/65de48c9-7596-4c1a-bd97-cec1b5a0bc34.jpg', '2022-04-24 00:00:00', '1');
INSERT INTO `content` VALUES ('12', '2', '1101', '1', '多种氨基酸', 'area/specialty/2.jpg', '2019-04-02 00:00:00', '1');
INSERT INTO `content` VALUES ('13', '3', '1101', '1', '好吃的鸡', 'area/specialty/3.jpg', '2018-04-02 00:00:00', '1');
INSERT INTO `content` VALUES ('14', '4', '1101', '1', '好吃的鸡腿！', 'area/specialty/5469ae34-7db6-4929-8040-c720ee7695ac.jpg', '2018-04-24 00:00:00', '1');
INSERT INTO `content` VALUES ('15', '5', '1101', '1', '香喷喷', 'area/specialty/5.jpg', '2018-04-25 00:03:00', '1');
INSERT INTO `content` VALUES ('16', '6', '1101', '0', '梅岭', 'area/scenic/6.jpg', '2018-04-27 11:25:26', '1');
INSERT INTO `content` VALUES ('17', '6', '1101', '0', '梅岭', 'area/scenic/6.jpg', '2018-04-27 11:26:50', '1');
INSERT INTO `content` VALUES ('18', '11', '1102', '1', '西港化红', 'area/specialty/10.png', '2018-04-27 13:50:10', '1');
INSERT INTO `content` VALUES ('19', '16', '1103', '1', '南安板鸭', 'area/specialty/1.png', '2018-04-27 13:51:12', '1');
INSERT INTO `content` VALUES ('20', '24', '1103', '1', '牛皮糖薯干', 'area/specialty/09732345-3db9-4b8e-b7bd-42cc413c85b7.png', '2018-04-27 21:35:55', '1');
INSERT INTO `content` VALUES ('21', '27', '1104', '1', '荷包红鲤鱼', 'area/specialty/ed1eac79-386f-4c92-91c7-d328f28af16e.png', '2018-04-27 21:47:35', '1');
INSERT INTO `content` VALUES ('22', '28', '1104', '1', '横峰葛', 'area/specialty/a0c4706d-3375-46e8-9437-b42511fac716.png', '2018-04-27 21:50:54', '1');
INSERT INTO `content` VALUES ('23', '30', '1104', '1', '上饶白眉', 'area/specialty/7025c8ad-2979-4f92-9ecc-ad396a809630.png', '2018-04-27 21:58:44', '1');
INSERT INTO `content` VALUES ('24', '24', '1104', '0', '清贫园', 'area/scenic/e3efa7c3-1414-4bda-b68d-1cf2cafc512c.png', '2018-04-28 10:36:10', '1');
INSERT INTO `content` VALUES ('25', '27', '1104', '0', '三清山', 'area/scenic/bb9e1a70-1e4f-4101-9303-d6ffc3e31793.png', '2018-04-28 10:59:58', '1');
INSERT INTO `content` VALUES ('26', '31', '1105', '0', '宜春明月山', 'area/scenic/b80891de-34ee-4027-b03a-7f2a75db26c1.png', '2018-04-28 14:21:58', '1');
INSERT INTO `content` VALUES ('27', '37', '1106', '1', '安福火腿', 'area/specialty/cb99449f-5db6-40f3-b2f8-c59fcb091f62.png', '2018-04-28 14:36:35', '1');
INSERT INTO `content` VALUES ('28', '43', '1108', '1', '上清豆腐', 'area/specialty/b935f998-6f45-45cf-9954-236cf2896c38.png', '2018-04-28 16:32:09', '1');
INSERT INTO `content` VALUES ('29', '47', '1109', '1', '手撕狗肉', 'area/specialty/bc907f9b-5fb5-484c-b889-8c72e7e61886.png', '2018-04-28 18:38:44', '1');
INSERT INTO `content` VALUES ('30', '46', '1109', '0', '武功山', 'area/scenic/5d98f3eb-c95c-4c6d-80f4-b010b7695d33.png', '2018-04-28 19:18:06', '1');
INSERT INTO `content` VALUES ('31', '49', '1110', '1
评论0