开发语言:Python 框架:django Python版本:python3.7.7 数据库:mysql 5.7(一定要5.7版本) 数据库工具:Navicat11 开发软件:PyCharm 浏览器:谷歌浏览器
DROP TABLE IF EXISTS aboutus
;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE aboutus
(
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 */;
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 gnssdt
--
DROP TABLE IF EXISTS gnssdt
;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE gnssdt
(
id
bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
addtime
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
diqu
varchar(200) DEFAULT NULL COMMENT '地区',
quezhen
int(11) DEFAULT NULL COMMENT '确诊',
zhiyu
int(11) DEFAULT NULL COMMENT '治愈',
siwang
int(11) DEFAULT NULL COMMENT '死亡',
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 COMMENT='国内实时动态';
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table gnssdt
--
LOCK TABLES gnssdt
WRITE;
/*!40000 ALTER TABLE gnssdt
DISABLE KEYS /;
INSERT INTO gnssdt
VALUES (41,'2023-04-17 01:43:05','地区1',1,1,1),(42,'2023-04-17 01:43:05','地区2',2,2,2),(43,'2023-04-17 01:43:05','地区3',3,3,3),(44,'2023-04-17 01:43:05','地区4',4,4,4),(45,'2023-04-17 01:43:05','地区5',5,5,5),(46,'2023-04-17 01:43:05','地区6',6,6,6),(47,'2023-04-17 01:43:05','地区7',7,7,7),(48,'2023-04-17 01:43:05','地区8',8,8,8);
/!40000 ALTER TABLE gnssdt
ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table l720s_gnssdt
--
DROP TABLE IF EXISTS l720s_gnssdt
;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE l720s_gnssdt
(
id
bigint(20) NOT NULL DEFAULT '0' COMMENT '主键',
addtime
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
diqu
varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '地区',
quezhen
varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '确诊',
zhiyu
varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '治愈',
siwang
varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '死亡'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/!40101 SET character_set_client = @saved_cs_client */;