开发语言：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/1636082628989.jpg’),(2,’picture2′,’upload/picture2.jpg’),(3,’picture3′,’upload/picture3.jpg’);
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `jianduyuan`
—
DROP TABLE IF EXISTS `jianduyuan`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jianduyuan` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`jianduyuanzhanghao` varchar(200) NOT NULL COMMENT ‘监督员账号’,
`jianduyuanxingming` varchar(200) NOT NULL COMMENT ‘监督员姓名’,
`mima` varchar(200) NOT NULL COMMENT ‘密码’,
`xingbie` varchar(200) DEFAULT NULL COMMENT ‘性别’,
`nianling` int(11) DEFAULT NULL COMMENT ‘年龄’,
`lianxidianhua` varchar(200) DEFAULT NULL COMMENT ‘联系电话’,
PRIMARY KEY (`id`),
UNIQUE KEY `jianduyuanzhanghao` (`jianduyuanzhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=1636082361704 DEFAULT CHARSET=utf8 COMMENT=’监督员’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `jianduyuan`
—
LOCK TABLES `jianduyuan` WRITE;
/*!40000 ALTER TABLE `jianduyuan` DISABLE KEYS */;
INSERT INTO `jianduyuan` VALUES (11,’2021-11-05 02:57:31′,’监督员账号1′,’监督员姓名1′,’123456′,’男’,1,’13823888881′),(12,’2021-11-05 02:57:31′,’监督员账号2′,’监督员姓名2′,’123456′,’女’,2,’13823888882′),(13,’2021-11-05 02:57:31′,’监督员账号3′,’监督员姓名3′,’123456′,’男’,3,’13823888883′),(14,’2021-11-05 02:57:31′,’监督员账号4′,’监督员姓名4′,’123456′,’男’,4,’13823888884′),(15,’2021-11-05 02:57:31′,’监督员账号5′,’监督员姓名5′,’123456′,’男’,5,’13823888885′),(16,’2021-11-05 02:57:31′,’监督员账号6′,’监督员姓名6′,’123456′,’男’,6,’13823888886′),(1636081983823,’2021-11-05 03:13:03′,’11’,’依依’,’111′,’女’,25,’13823813811′),(1636082361703,’2021-11-05 03:19:21′,’88’,’杨毅’,’88’,’男’,30,’13813813822′);
/*!40000 ALTER TABLE `jianduyuan` 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=77 DEFAULT CHARSET=utf8 COMMENT=’药物公告’;
/*!40101 SET character_set_client = @saved_cs_client */;