基于Python的邯郸地标美食导游平台设计与实现-计算机毕业设计源码+LW文档

开发语言：Python
框架：django
Python版本：python3.7.7
数据库：mysql 5.7（一定要5.7版本）
数据库工具：Navicat11
开发软件：PyCharm 
浏览器：谷歌浏览器

数据库：

DROP TABLE IF EXISTS `config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `config` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(100) NOT NULL COMMENT '配置参数名称',
  `value` varchar(100) DEFAULT NULL COMMENT '配置参数值',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='配置文件';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `config`
--

LOCK TABLES `config` WRITE;
/*!40000 ALTER TABLE `config` DISABLE KEYS */;
INSERT INTO `config` VALUES (1,'picture1','upload/picture1.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg');
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `discusshandanmeijing`
--

DROP TABLE IF EXISTS `discusshandanmeijing`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discusshandanmeijing` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `refid` bigint(20) NOT NULL COMMENT '关联表id',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  `nickname` varchar(200) DEFAULT NULL COMMENT '用户名',
  `content` longtext NOT NULL COMMENT '评论内容',
  `reply` longtext COMMENT '回复内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8 COMMENT='邯郸美景评论表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `discusshandanmeijing`
--

LOCK TABLES `discusshandanmeijing` WRITE;
/*!40000 ALTER TABLE `discusshandanmeijing` DISABLE KEYS */;
INSERT INTO `discusshandanmeijing` VALUES (101,'2022-02-23 11:44:16',1,1,'用户名1','评论内容1','回复内容1'),(102,'2022-02-23 11:44:16',2,2,'用户名2','评论内容2','回复内容2'),(103,'2022-02-23 11:44:16',3,3,'用户名3','评论内容3','回复内容3'),(104,'2022-02-23 11:44:16',4,4,'用户名4','评论内容4','回复内容4'),(105,'2022-02-23 11:44:16',5,5,'用户名5','评论内容5','回复内容5'),(106,'2022-02-23 11:44:16',6,6,'用户名6','评论内容6','回复内容6');
/*!40000 ALTER TABLE `discusshandanmeijing` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `discusshandanmeishi`
--

DROP TABLE IF EXISTS `discusshandanmeishi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discusshandanmeishi` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `refid` bigint(20) NOT NULL COMMENT '关联表id',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  `nickname` varchar(200) DEFAULT NULL COMMENT '用户名',
  `content` longtext NOT NULL COMMENT '评论内容',
  `reply` longtext COMMENT '回复内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8 COMMENT='邯郸美食评论表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `discusshandanmeishi`
--

LOCK TABLES `discusshandanmeishi` WRITE;
/*!40000 ALTER TABLE `discusshandanmeishi` DISABLE KEYS */;
INSERT INTO `discusshandanmeishi` VALUES (111,'2022-02-23 11:44:16',1,1,'用户名1','评论内容1','回复内容1'),(112,'2022-02-23 11:44:16',2,2,'用户名2','评论内容2','回复内容2'),(113,'2022-02-23 11:44:16',3,3,'用户名3','评论内容3','回复内容3'),(114,'2022-02-23 11:44:16',4,4,'用户名4','评论内容4','回复内容4'),(115,'2022-02-23 11:44:16',5,5,'用户名5','评论内容5','回复内容5'),(116,'2022-02-23 11:44:16',6,6,'用户名6','评论内容6','回复内容6');
/*!40000 ALTER TABLE `discusshandanmeishi` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `discussyonghufenxiang`
--

DROP TABLE IF EXISTS `discussyonghufenxiang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discussyonghufenxiang` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `refid` bigint(20) NOT NULL COMMENT '关联表id',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  `nickname` varchar(200) DEFAULT NULL COMMENT '用户名',
  `content` longtext NOT NULL COMMENT '评论内容',
  `reply` longtext COMMENT '回复内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8 COMMENT='用户分享评论表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `discussyonghufenxiang`
--

LOCK TABLES `discussyonghufenxiang` WRITE;
/*!40000 ALTER TABLE `discussyonghufenxiang` DISABLE KEYS */;
INSERT INTO `discussyonghufenxiang` VALUES (121,'2022-02-23 11:44:16',1,1,'用户名1','评论内容1','回复内容1'),(122,'2022-02-23 11:44:16',2,2,'用户名2','评论内容2','回复内容2'),(123,'2022-02-23 11:44:16',3,3,'用户名3','评论内容3','回复内容3'),(124,'2022-02-23 11:44:16',4,4,'用户名4','评论内容4','回复内容4'),(125,'2022-02-23 11:44:16',5,5,'用户名5','评论内容5','回复内容5'),(126,'2022-02-23 11:44:16',6,6,'用户名6','评论内容6','回复内容6');
/*!40000 ALTER TABLE `discussyonghufenxiang` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `forum`
--

DROP TABLE IF EXISTS `forum`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `forum` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `title` varchar(200) DEFAULT NULL COMMENT '帖子标题',
  `content` longtext NOT NULL COMMENT '帖子内容',
  `parentid` bigint(20) DEFAULT NULL COMMENT '父节点id',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  `username` varchar(200) DEFAULT NULL COMMENT '用户名',
  `isdone` varchar(200) DEFAULT NULL COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8 COMMENT='组团同游';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `forum`
--

LOCK TABLES `forum` WRITE;
/*!40000 ALTER TABLE `forum` DISABLE KEYS */;
INSERT INTO `forum` VALUES (71,'2022-02-23 11:44:16','帖子标题1','帖子内容1',0,1,'用户名1','开放'),(72,'2022-02-23 11:44:16','帖子标题2','帖子内容2',0,2,'用户名2','开放'),(73,'2022-02-23 11:44:16','帖子标题3','帖子内容3',0,3,'用户名3','开放'),(74,'2022-02-23 11:44:16','帖子标题4','帖子内容4',0,4,'用户名4','开放'),(75,'2022-02-23 11:44:16','帖子标题5','帖子内容5',0,5,'用户名5','开放'),(76,'2022-02-23 11:44:16','帖子标题6','帖子内容6',0,6,'用户名6','开放');
/*!40000 ALTER TABLE `forum` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `handanmeijing`
--

DROP TABLE IF EXISTS `handanmeijing`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `handanmeijing` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `jingdianmingcheng` varchar(200) NOT NULL COMMENT '景点名称',
  `jingdianfenlei` varchar(200) NOT NULL COMMENT '景点分类',
  `jingdianxingji` varchar(200) DEFAULT NULL COMMENT '景点星级',
  `jingdiantupian` varchar(200) DEFAULT NULL COMMENT '景点图片',
  `menpiaojiage` int(11) NOT NULL COMMENT '门票价格',
  `suoshudiqu` varchar(200) DEFAULT NULL COMMENT '所属地区',
  `jutiweizhi` varchar(200) DEFAULT NULL COMMENT '具体位置',
  `yonghupingjia` varchar(200) NOT NULL COMMENT '用户评价',
  `yingyeshijian` varchar(200) DEFAULT NULL COMMENT '营业时间',
  `xuanchuanshipin` varchar(200) DEFAULT NULL COMMENT '宣传视频',
  `zixunrexian` varchar(200) DEFAULT NULL COMMENT '咨询热线',
  `jingdianjieshao` longtext COMMENT '景点介绍',
  `clicktime` datetime DEFAULT NULL COMMENT '最近点击时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT='邯郸美景';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `handanmeijing`
--

LOCK TABLES `handanmeijing` WRITE;
/*!40000 ALTER TABLE `handanmeijing` DISABLE KEYS */;
INSERT INTO `handanmeijing` VALUES (41,'2022-02-23 11:44:16','景点名称1','景点分类1','A','upload/handanmeijing_jingdiantupian1.jpg',1,'所属地区1','具体位置1','一星','营业时间1','','020-89819991','景点介绍1','2022-02-23 19:44:16'),(42,'2022-02-23 11:44:16','景点名称2','景点分类2','A','upload/handanmeijing_jingdiantupian2.jpg',2,'所属地区2','具体位置2','一星','营业时间2','','020-89819992','景点介绍2','2022-02-23 19:44:16'),(43,'2022-02-23 11:44:16','景点名称3','景点分类3','A','upload/handanmeijing_jingdiantupian3.jpg',3,'所属地区3','具体位置3','一星','营业时间3','','020-89819993','景点介绍3','2022-02-23 19:44:16'),(44,'2022-02-23 11:44:16','景点名称4','景点分类4','A','upload/handanmeijing_jingdiantupian4.jpg',4,'所属地区4','具体位置4','一星','营业时间4','','020-89819994','景点介绍4','2022-02-23 19:44:16'),(45,'2022-02-23 11:44:16','景点名称5','景点分类5','A','upload/handanmeijing_jingdiantupian5.jpg',5,'所属地区5','具体位置5','一星','营业时间5','','020-89819995','景点介绍5','2022-02-23 19:44:16'),(46,'2022-02-23 11:44:16','景点名称6','景点分类6','A','upload/handanmeijing_jingdiantupian6.jpg',6,'所属地区6','具体位置6','一星','营业时间6','','020-89819996','景点介绍6','2022-02-23 19:44:16');
/*!40000 ALTER TABLE `handanmeijing` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `handanmeishi`
--

DROP TABLE IF EXISTS `handanmeishi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `handanmeishi` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `meishimingcheng` varchar(200) NOT NULL COMMENT '美食名称',
  `meishifenlei` varchar(200) NOT NULL COMMENT '美食分类',
  `meishitupian` varchar(200) DEFAULT NULL COMMENT '美食图片',
  `meishikouwei` varchar(200) DEFAULT NULL COMMENT '美食口味',
  `suozaiquxian` varchar(200) DEFAULT NULL COMMENT '所在区县',
  `jutiweizhi` varchar(200) DEFAULT NULL COMMENT '具体位置',
  `yonghupingjia` varchar(200) NOT NULL COMMENT '用户评价',
  `meishitese` varchar(200) DEFAULT NULL COMMENT '美食特色',
  `meishishipin` varchar(200) DEFAULT NULL COMMENT '美食视频',
  `xiangqingjieshao` longtext COMMENT '详情介绍',
  `faburiqi` date DEFAULT NULL COMMENT '发布日期',
  `clicktime` datetime DEFAULT NULL COMMENT '最近点击时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT='邯郸美食';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `handanmeishi`
--

LOCK TABLES `handanmeishi` WRITE;
/*!40000 ALTER TABLE `handanmeishi` DISABLE KEYS */;
INSERT INTO `handanmeishi` VALUES (51,'2022-02-23 11:44:16','美食名称1','周边餐馆','upload/handanmeishi_meishitupian1.jpg','美食口味1','所在区县1','具体位置1','一星','美食特色1','','

详情介绍1

','2022-02-23','2022-02-23 19:44:16'),(52,'2022-02-23 11:44:16','美食名称2','周边餐馆','upload/handanmeishi_meishitupian2.jpg','美食口味2','所在区县2','具体位置2','一星','美食特色2','','

详情介绍2

','2022-02-23','2022-02-23 19:44:16'),(53,'2022-02-23 11:44:16','美食名称3','周边餐馆','upload/handanmeishi_meishitupian3.jpg','美食口味3','所在区县3','具体位置3','一星','美食特色3','','

详情介绍3

','2022-02-23','2022-02-23 19:44:16'),(54,'2022-02-23 11:44:16','美食名称4','美食分类4','upload/handanmeishi_meishitupian4.jpg','美食口味4','所在区县4','具体位置4','一星','美食特色4','','详情介绍4','2022-02-23','2022-02-23 19:44:16'),(55,'2022-02-23 11:44:16','美食名称5','美食分类5','upload/handanmeishi_meishitupian5.jpg','美食口味5','所在区县5','具体位置5','一星','美食特色5','','详情介绍5','2022-02-23','2022-02-23 19:44:16'),(56,'2022-02-23 11:44:16','美食名称6','美食分类6','upload/handanmeishi_meishitupian6.jpg','美食口味6','所在区县6','具体位置6','一星','美食特色6','','详情介绍6','2022-02-23','2022-02-23 19:44:16');
/*!40000 ALTER TABLE `handanmeishi` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jingdianfenlei`
--

DROP TABLE IF EXISTS `jingdianfenlei`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jingdianfenlei` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `jingdianfenlei` varchar(200) NOT NULL COMMENT '景点分类',
  PRIMARY KEY (`id`),
  UNIQUE KEY `jingdianfenlei` (`jingdianfenlei`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COMMENT='景点分类';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `jingdianfenlei`
--

LOCK TABLES `jingdianfenlei` WRITE;
/*!40000 ALTER TABLE `jingdianfenlei` DISABLE KEYS */;
INSERT INTO `jingdianfenlei` VALUES (21,'2022-02-23 11:44:16','景点分类1'),(22,'2022-02-23 11:44:16','景点分类2'),(23,'2022-02-23 11:44:16','景点分类3'),(24,'2022-02-23 11:44:16','景点分类4'),(25,'2022-02-23 11:44:16','景点分类5'),(26,'2022-02-23 11:44:16','景点分类6');
/*!40000 ALTER TABLE `jingdianfenlei` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `meishifenlei`
--

DROP TABLE IF EXISTS `meishifenlei`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `meishifenlei` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `meishifenlei` varchar(200) NOT NULL COMMENT '美食分类',
  PRIMARY KEY (`id`),
  UNIQUE KEY `meishifenlei` (`meishifenlei`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COMMENT='美食分类';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `meishifenlei`
--

LOCK TABLES `meishifenlei` WRITE;
/*!40000 ALTER TABLE `meishifenlei` DISABLE KEYS */;
INSERT INTO `meishifenlei` VALUES (31,'2022-02-23 11:44:16','主食'),(32,'2022-02-23 11:44:16','小吃'),(33,'2022-02-23 11:44:16','甜点'),(34,'2022-02-23 11:44:16','糕点'),(35,'2022-02-23 11:44:16','周边餐馆');
/*!40000 ALTER TABLE `meishifenlei` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `news`
--

DROP TABLE IF EXISTS `news`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `title` varchar(200) NOT NULL COMMENT '标题',
  `introduction` longtext COMMENT '简介',
  `picture` varchar(200) NOT NULL COMMENT '图片',
  `content` longtext NOT NULL COMMENT '内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8 COMMENT='邯郸资讯';
/*!40101 SET character_set_client = @saved_cs_client */;