基于Python的邯鄲地標(biāo)美食導(dǎo)游平臺(tái)設(shè)計(jì)與實(shí)現(xiàn)-計(jì)算機(jī)畢業(yè)設(shè)計(jì)源碼+LW文檔
開(kāi)發(fā)語(yǔ)言：Python
框架：django
Python版本：python3.7.7
數(shù)據(jù)庫(kù)：mysql 5.7（一定要5.7版本）
數(shù)據(jù)庫(kù)工具：Navicat11
開(kāi)發(fā)軟件：PyCharm?
瀏覽器：谷歌瀏覽器
數(shù)據(jù)庫(kù)：
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 '配置參數(shù)名稱',
? `value` varchar(100) DEFAULT NULL COMMENT '配置參數(shù)值',
? 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 '創(chuàng)建時(shí)間',
? `refid` bigint(20) NOT NULL COMMENT '關(guān)聯(lián)表id',
? `userid` bigint(20) NOT NULL COMMENT '用戶id',
? `nickname` varchar(200) DEFAULT NULL COMMENT '用戶名',
? `content` longtext NOT NULL COMMENT '評(píng)論內(nèi)容',
? `reply` longtext COMMENT '回復(fù)內(nèi)容',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8 COMMENT='邯鄲美景評(píng)論表';
/*!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','評(píng)論內(nèi)容1','回復(fù)內(nèi)容1'),(102,'2022-02-23 11:44:16',2,2,'用戶名2','評(píng)論內(nèi)容2','回復(fù)內(nèi)容2'),(103,'2022-02-23 11:44:16',3,3,'用戶名3','評(píng)論內(nèi)容3','回復(fù)內(nèi)容3'),(104,'2022-02-23 11:44:16',4,4,'用戶名4','評(píng)論內(nèi)容4','回復(fù)內(nèi)容4'),(105,'2022-02-23 11:44:16',5,5,'用戶名5','評(píng)論內(nèi)容5','回復(fù)內(nèi)容5'),(106,'2022-02-23 11:44:16',6,6,'用戶名6','評(píng)論內(nèi)容6','回復(fù)內(nèi)容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 '創(chuàng)建時(shí)間',
? `refid` bigint(20) NOT NULL COMMENT '關(guān)聯(lián)表id',
? `userid` bigint(20) NOT NULL COMMENT '用戶id',
? `nickname` varchar(200) DEFAULT NULL COMMENT '用戶名',
? `content` longtext NOT NULL COMMENT '評(píng)論內(nèi)容',
? `reply` longtext COMMENT '回復(fù)內(nèi)容',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8 COMMENT='邯鄲美食評(píng)論表';
/*!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','評(píng)論內(nèi)容1','回復(fù)內(nèi)容1'),(112,'2022-02-23 11:44:16',2,2,'用戶名2','評(píng)論內(nèi)容2','回復(fù)內(nèi)容2'),(113,'2022-02-23 11:44:16',3,3,'用戶名3','評(píng)論內(nèi)容3','回復(fù)內(nèi)容3'),(114,'2022-02-23 11:44:16',4,4,'用戶名4','評(píng)論內(nèi)容4','回復(fù)內(nèi)容4'),(115,'2022-02-23 11:44:16',5,5,'用戶名5','評(píng)論內(nèi)容5','回復(fù)內(nèi)容5'),(116,'2022-02-23 11:44:16',6,6,'用戶名6','評(píng)論內(nèi)容6','回復(fù)內(nèi)容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 '創(chuàng)建時(shí)間',
? `refid` bigint(20) NOT NULL COMMENT '關(guān)聯(lián)表id',
? `userid` bigint(20) NOT NULL COMMENT '用戶id',
? `nickname` varchar(200) DEFAULT NULL COMMENT '用戶名',
? `content` longtext NOT NULL COMMENT '評(píng)論內(nèi)容',
? `reply` longtext COMMENT '回復(fù)內(nèi)容',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8 COMMENT='用戶分享評(píng)論表';
/*!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','評(píng)論內(nèi)容1','回復(fù)內(nèi)容1'),(122,'2022-02-23 11:44:16',2,2,'用戶名2','評(píng)論內(nèi)容2','回復(fù)內(nèi)容2'),(123,'2022-02-23 11:44:16',3,3,'用戶名3','評(píng)論內(nèi)容3','回復(fù)內(nèi)容3'),(124,'2022-02-23 11:44:16',4,4,'用戶名4','評(píng)論內(nèi)容4','回復(fù)內(nèi)容4'),(125,'2022-02-23 11:44:16',5,5,'用戶名5','評(píng)論內(nèi)容5','回復(fù)內(nèi)容5'),(126,'2022-02-23 11:44:16',6,6,'用戶名6','評(píng)論內(nèi)容6','回復(fù)內(nèi)容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 '創(chuàng)建時(shí)間',
? `title` varchar(200) DEFAULT NULL COMMENT '帖子標(biāo)題',
? `content` longtext NOT NULL COMMENT '帖子內(nèi)容',
? `parentid` bigint(20) DEFAULT NULL COMMENT '父節(jié)點(diǎn)id',
? `userid` bigint(20) NOT NULL COMMENT '用戶id',
? `username` varchar(200) DEFAULT NULL COMMENT '用戶名',
? `isdone` varchar(200) DEFAULT NULL COMMENT '狀態(tài)',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8 COMMENT='組團(tuán)同游';
/*!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','帖子標(biāo)題1','帖子內(nèi)容1',0,1,'用戶名1','開(kāi)放'),(72,'2022-02-23 11:44:16','帖子標(biāo)題2','帖子內(nèi)容2',0,2,'用戶名2','開(kāi)放'),(73,'2022-02-23 11:44:16','帖子標(biāo)題3','帖子內(nèi)容3',0,3,'用戶名3','開(kāi)放'),(74,'2022-02-23 11:44:16','帖子標(biāo)題4','帖子內(nèi)容4',0,4,'用戶名4','開(kāi)放'),(75,'2022-02-23 11:44:16','帖子標(biāo)題5','帖子內(nèi)容5',0,5,'用戶名5','開(kāi)放'),(76,'2022-02-23 11:44:16','帖子標(biāo)題6','帖子內(nèi)容6',0,6,'用戶名6','開(kāi)放');
/*!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 '創(chuàng)建時(shí)間',
? `jingdianmingcheng` varchar(200) NOT NULL COMMENT '景點(diǎn)名稱',
? `jingdianfenlei` varchar(200) NOT NULL COMMENT '景點(diǎn)分類',
? `jingdianxingji` varchar(200) DEFAULT NULL COMMENT '景點(diǎn)星級(jí)',
? `jingdiantupian` varchar(200) DEFAULT NULL COMMENT '景點(diǎn)圖片',
? `menpiaojiage` int(11) NOT NULL COMMENT '門票價(jià)格',
? `suoshudiqu` varchar(200) DEFAULT NULL COMMENT '所屬地區(qū)',
? `jutiweizhi` varchar(200) DEFAULT NULL COMMENT '具體位置',
? `yonghupingjia` varchar(200) NOT NULL COMMENT '用戶評(píng)價(jià)',
? `yingyeshijian` varchar(200) DEFAULT NULL COMMENT '營(yíng)業(yè)時(shí)間',
? `xuanchuanshipin` varchar(200) DEFAULT NULL COMMENT '宣傳視頻',
? `zixunrexian` varchar(200) DEFAULT NULL COMMENT '咨詢熱線',
? `jingdianjieshao` longtext COMMENT '景點(diǎn)介紹',
? `clicktime` datetime DEFAULT NULL COMMENT '最近點(diǎn)擊時(shí)間',
? 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','景點(diǎn)名稱1','景點(diǎn)分類1','A','upload/handanmeijing_jingdiantupian1.jpg',1,'所屬地區(qū)1','具體位置1','一星','營(yíng)業(yè)時(shí)間1','','020-89819991','景點(diǎn)介紹1','2022-02-23 19:44:16'),(42,'2022-02-23 11:44:16','景點(diǎn)名稱2','景點(diǎn)分類2','A','upload/handanmeijing_jingdiantupian2.jpg',2,'所屬地區(qū)2','具體位置2','一星','營(yíng)業(yè)時(shí)間2','','020-89819992','景點(diǎn)介紹2','2022-02-23 19:44:16'),(43,'2022-02-23 11:44:16','景點(diǎn)名稱3','景點(diǎn)分類3','A','upload/handanmeijing_jingdiantupian3.jpg',3,'所屬地區(qū)3','具體位置3','一星','營(yíng)業(yè)時(shí)間3','','020-89819993','景點(diǎn)介紹3','2022-02-23 19:44:16'),(44,'2022-02-23 11:44:16','景點(diǎn)名稱4','景點(diǎn)分類4','A','upload/handanmeijing_jingdiantupian4.jpg',4,'所屬地區(qū)4','具體位置4','一星','營(yíng)業(yè)時(shí)間4','','020-89819994','景點(diǎn)介紹4','2022-02-23 19:44:16'),(45,'2022-02-23 11:44:16','景點(diǎn)名稱5','景點(diǎn)分類5','A','upload/handanmeijing_jingdiantupian5.jpg',5,'所屬地區(qū)5','具體位置5','一星','營(yíng)業(yè)時(shí)間5','','020-89819995','景點(diǎn)介紹5','2022-02-23 19:44:16'),(46,'2022-02-23 11:44:16','景點(diǎn)名稱6','景點(diǎn)分類6','A','upload/handanmeijing_jingdiantupian6.jpg',6,'所屬地區(qū)6','具體位置6','一星','營(yíng)業(yè)時(shí)間6','','020-89819996','景點(diǎn)介紹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 '創(chuàng)建時(shí)間',
? `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 '所在區(qū)縣',
? `jutiweizhi` varchar(200) DEFAULT NULL COMMENT '具體位置',
? `yonghupingjia` varchar(200) NOT NULL COMMENT '用戶評(píng)價(jià)',
? `meishitese` varchar(200) DEFAULT NULL COMMENT '美食特色',
? `meishishipin` varchar(200) DEFAULT NULL COMMENT '美食視頻',
? `xiangqingjieshao` longtext COMMENT '詳情介紹',
? `faburiqi` date DEFAULT NULL COMMENT '發(fā)布日期',
? `clicktime` datetime DEFAULT NULL COMMENT '最近點(diǎn)擊時(shí)間',
? 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','所在區(qū)縣1','具體位置1','一星','美食特色1','','<p>詳情介紹1</p>','2022-02-23','2022-02-23 19:44:16'),(52,'2022-02-23 11:44:16','美食名稱2','周邊餐館','upload/handanmeishi_meishitupian2.jpg','美食口味2','所在區(qū)縣2','具體位置2','一星','美食特色2','','<p>詳情介紹2</p>','2022-02-23','2022-02-23 19:44:16'),(53,'2022-02-23 11:44:16','美食名稱3','周邊餐館','upload/handanmeishi_meishitupian3.jpg','美食口味3','所在區(qū)縣3','具體位置3','一星','美食特色3','','<p>詳情介紹3</p>','2022-02-23','2022-02-23 19:44:16'),(54,'2022-02-23 11:44:16','美食名稱4','美食分類4','upload/handanmeishi_meishitupian4.jpg','美食口味4','所在區(qū)縣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','所在區(qū)縣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','所在區(qū)縣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 '創(chuàng)建時(shí)間',
? `jingdianfenlei` varchar(200) NOT NULL COMMENT '景點(diǎn)分類',
? PRIMARY KEY (`id`),
? UNIQUE KEY `jingdianfenlei` (`jingdianfenlei`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COMMENT='景點(diǎn)分類';
/*!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','景點(diǎn)分類1'),(22,'2022-02-23 11:44:16','景點(diǎn)分類2'),(23,'2022-02-23 11:44:16','景點(diǎn)分類3'),(24,'2022-02-23 11:44:16','景點(diǎn)分類4'),(25,'2022-02-23 11:44:16','景點(diǎn)分類5'),(26,'2022-02-23 11:44:16','景點(diǎn)分類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 '創(chuàng)建時(shí)間',
? `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','甜點(diǎn)'),(34,'2022-02-23 11:44:16','糕點(diǎn)'),(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 '創(chuàng)建時(shí)間',
? `title` varchar(200) NOT NULL COMMENT '標(biāo)題',
? `introduction` longtext COMMENT '簡(jiǎn)介',
? `picture` varchar(200) NOT NULL COMMENT '圖片',
? `content` longtext NOT NULL COMMENT '內(nèi)容',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8 COMMENT='邯鄲資訊';
/*!40101 SET character_set_client = @saved_cs_client */;
