开发语言：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′,”,'<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′,’所在区县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′,’所在区县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′,’所在区县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 */;