开发语言：Python 框架：django Python版本：python3.7.7 数据库：mysql 5.7（一定要5.7版本） 数据库工具：Navicat11 开发软件：PyCharm 浏览器：谷歌浏览器
DROP TABLE IF EXISTS 08375_menpiaoxinxi;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE 08375_menpiaoxinxi (
id bigint(20) NOT NULL DEFAULT '0' COMMENT '主键',
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
laiyuan longtext CHARACTER SET utf8 COMMENT '来源',
biaoti varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '标题',
fengmian longtext CHARACTER SET utf8 COMMENT '封面',
miaoshu longtext CHARACTER SET utf8 COMMENT '描述',
weizhi varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '位置',
dianping varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '点评',
pinglun varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '评论',
jiage varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '价格',
tese longtext CHARACTER SET utf8 COMMENT '特色',
kaifangshijian longtext CHARACTER SET utf8 COMMENT '开放时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS 08375_tejiajipiao;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE 08375_tejiajipiao (
id bigint(20) NOT NULL DEFAULT '0' COMMENT '主键',
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
chufadi varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '出发地',
mudidi varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '目的地',
fengjingtu longtext CHARACTER SET utf8 COMMENT '风景图',
chufashijian varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '出发时间',
jiage varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '价格',
redu varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '热度',
biaoqian varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '标签',
miaoshu longtext CHARACTER SET utf8 COMMENT '描述'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS mingsuxinxi;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE mingsuxinxi (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
biaoti varchar(200) DEFAULT NULL COMMENT '标题',
fengmian longtext COMMENT '封面',
dizhi varchar(200) DEFAULT NULL COMMENT '地址',
pinglun varchar(200) DEFAULT NULL COMMENT '评论',
fenlei varchar(200) DEFAULT NULL COMMENT '分类',
jiage int(11) DEFAULT NULL COMMENT '价格',
pingfen float DEFAULT NULL COMMENT '评分',
pinglunshu int(11) DEFAULT NULL COMMENT '评论数',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=146 DEFAULT CHARSET=utf8 COMMENT='名宿信息';
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table mingsuxinxi
--
DROP TABLE IF EXISTS systemintro;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE systemintro (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
title varchar(200) NOT NULL COMMENT '标题',
subtitle varchar(200) DEFAULT NULL COMMENT '副标题',
content longtext NOT NULL COMMENT '内容',
picture1 longtext COMMENT '图片1',
picture2 longtext COMMENT '图片2',
picture3 longtext COMMENT '图片3',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='关于我们';
/!40101 SET character_set_client = @saved_cs_client */;
