/*
SQLyog Ultimate v12.09 (64 bit)
MySQL - 5.7.25-log : Database - epidemic
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`epidemic` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `epidemic`;

/*Table structure for table `epidemics` */

DROP TABLE IF EXISTS `epidemics`;

CREATE TABLE `epidemics` (
  `serial_id` int(11) NOT NULL AUTO_INCREMENT,
  `province_id` int(11) DEFAULT NULL,
  `data_year` smallint(6) DEFAULT NULL,
  `data_month` smallint(6) DEFAULT NULL,
  `data_day` smallint(6) DEFAULT NULL,
  `affirmed` int(11) DEFAULT NULL,
  `suspected` int(11) DEFAULT NULL,
  `isolated` int(11) DEFAULT NULL,
  `dead` int(11) DEFAULT NULL,
  `cured` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `input_date` datetime DEFAULT NULL,
  PRIMARY KEY (`serial_id`),
  KEY `FK_Reference_1` (`province_id`),
  KEY `FK_Reference_2` (`user_id`),
  CONSTRAINT `FK_Reference_1` FOREIGN KEY (`province_id`) REFERENCES `provinces` (`province_id`),
  CONSTRAINT `FK_Reference_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=155 DEFAULT CHARSET=utf8;

/*Data for the table `epidemics` */

insert  into `epidemics`(`serial_id`,`province_id`,`data_year`,`data_month`,`data_day`,`affirmed`,`suspected`,`isolated`,`dead`,`cured`,`user_id`,`input_date`) values (1,11,2020,9,12,1111,1111,11111,1,11111,1,'2020-09-11 08:26:45'),(2,12,2020,9,12,222,222,2222,2,2222,1,'2020-09-11 08:26:45'),(3,13,2020,9,12,3333,3333,3333,3,333,1,'2020-09-11 08:26:45'),(4,14,2020,9,12,4444,4444,44444,4,4444,1,'2020-09-11 08:26:45'),(5,15,2020,9,12,555,5555,555,5,555,1,'2020-09-11 08:26:45'),(6,21,2020,9,12,5555,5555,555,6,5555,1,'2020-09-11 08:26:45'),(7,11,2020,9,18,1,1,1,1,1,1,'2020-09-18 11:08:55'),(8,12,2020,9,18,2,2,2,2,2,1,'2020-09-18 11:08:55'),(9,13,2020,9,18,3,3,3,4,3,1,'2020-09-18 11:08:55'),(10,14,2020,9,18,6,5,2,0,4,1,'2020-09-18 11:08:55'),(11,15,2020,9,18,7,7,7,7,7,1,'2020-09-18 11:08:55'),(12,21,2020,9,18,1,0,0,0,0,1,'2020-09-18 11:08:55'),(13,22,2020,9,18,1,43,435,32,5435,1,'2020-09-18 11:11:43'),(14,23,2020,9,18,1,323,56,34,534,1,'2020-09-18 11:11:43'),(15,31,2020,9,18,1,423,35,23,534,1,'2020-09-18 11:11:43'),(16,32,2020,9,18,1,455,543,54,333,1,'2020-09-18 11:11:43'),(17,33,2020,9,18,1,423,534,23,45,1,'2020-09-18 11:11:43'),(18,34,2020,9,18,1,346,435,32,534,1,'2020-09-18 11:11:43'),(19,11,2020,9,17,10,0,0,0,0,1,NULL),(20,12,2020,9,17,0,0,0,0,0,1,NULL),(21,13,2020,9,17,0,0,0,0,0,1,NULL),(22,14,2020,9,17,0,0,0,0,0,1,NULL),(23,15,2020,9,17,0,0,0,0,0,1,NULL),(24,21,2020,9,17,0,0,0,0,0,1,NULL),(25,35,2020,9,18,100,4,4,1,4,2,'2020-09-18 09:31:45'),(26,36,2020,9,18,0,0,0,0,0,2,'2020-09-18 09:31:45'),(27,37,2020,9,18,0,0,0,0,0,2,'2020-09-18 09:31:45'),(28,41,2020,9,18,0,0,0,0,0,2,'2020-09-18 09:31:45'),(29,42,2020,9,18,0,0,0,0,0,2,'2020-09-18 09:31:45'),(30,43,2020,9,18,0,0,0,0,0,2,'2020-09-18 09:31:45'),(31,22,2020,9,17,0,0,0,0,0,2,'2020-09-18 09:32:59'),(32,23,2020,9,17,0,0,0,0,0,2,'2020-09-18 09:32:59'),(33,31,2020,9,17,0,0,0,0,0,2,'2020-09-18 09:32:59'),(34,32,2020,9,17,0,0,0,0,0,2,'2020-09-18 09:32:59'),(35,33,2020,9,17,0,0,0,0,0,2,'2020-09-18 09:32:59'),(36,34,2020,9,17,0,0,0,0,0,2,'2020-09-18 09:32:59'),(37,35,2020,9,17,1,1,1,1,1,2,'2020-09-18 09:33:18'),(38,36,2020,9,17,0,0,0,0,0,2,'2020-09-18 09:33:18'),(39,37,2020,9,17,0,0,0,0,0,2,'2020-09-18 09:33:18'),(40,41,2020,9,17,0,0,0,0,0,2,'2020-09-18 09:33:18'),(41,42,2020,9,17,0,0,0,0,0,2,'2020-09-18 09:33:18'),(42,43,2020,9,17,0,0,0,0,0,2,'2020-09-18 09:33:18'),(43,11,2020,9,13,1,1,1,1,1,1,'2020-09-13 12:00:54'),(44,12,2020,9,13,0,0,0,0,0,1,'2020-09-13 12:00:54'),(45,13,2020,9,13,0,0,0,0,0,1,'2020-09-13 12:00:54'),(46,14,2020,9,13,0,0,0,0,0,1,'2020-09-13 12:00:54'),(47,15,2020,9,13,0,0,0,0,0,1,'2020-09-13 12:00:54'),(48,21,2020,9,13,2,2,2,2,2,1,'2020-09-13 12:00:54'),(49,22,2020,9,13,3,3,3,3,3,1,'2020-09-13 12:02:57'),(50,23,2020,9,13,0,0,0,0,0,1,'2020-09-13 12:02:57'),(51,31,2020,9,13,0,0,0,0,0,1,'2020-09-13 12:02:57'),(52,32,2020,9,13,0,0,0,0,0,1,'2020-09-13 12:02:57'),(53,33,2020,9,13,0,0,0,0,0,1,'2020-09-13 12:02:57'),(54,34,2020,9,13,4,4,4,4,4,1,'2020-09-13 12:02:58'),(55,35,2020,9,13,5,5,5,5,5,1,'2020-09-13 12:03:12'),(56,36,2020,9,13,0,0,0,0,0,1,'2020-09-13 12:03:12'),(57,37,2020,9,13,0,0,0,0,0,1,'2020-09-13 12:03:12'),(58,41,2020,9,13,0,0,0,0,0,1,'2020-09-13 12:03:12'),(59,42,2020,9,13,0,0,0,0,0,1,'2020-09-13 12:03:12'),(60,43,2020,9,13,6,6,6,6,6,1,'2020-09-13 12:03:12'),(61,44,2020,9,13,0,0,0,0,0,1,'2020-09-13 12:03:16'),(62,45,2020,9,13,0,0,0,0,0,1,'2020-09-13 12:03:16'),(63,46,2020,9,13,0,0,0,0,0,1,'2020-09-13 12:03:16'),(64,50,2020,9,13,0,0,0,0,0,1,'2020-09-13 12:03:16'),(65,51,2020,9,13,0,0,0,0,0,1,'2020-09-13 12:03:16'),(66,52,2020,9,13,0,0,0,0,0,1,'2020-09-13 12:03:16'),(67,53,2020,9,13,0,0,0,0,0,1,'2020-09-13 12:03:17'),(68,54,2020,9,13,0,0,0,0,0,1,'2020-09-13 12:03:17'),(69,61,2020,9,13,0,0,0,0,0,1,'2020-09-13 12:03:17'),(70,62,2020,9,13,0,0,0,0,0,1,'2020-09-13 12:03:17'),(71,63,2020,9,13,0,0,0,0,0,1,'2020-09-13 12:03:17'),(72,64,2020,9,13,0,0,0,0,0,1,'2020-09-13 12:03:17'),(73,65,2020,9,13,0,0,0,0,0,1,'2020-09-13 12:03:25'),(74,71,2020,9,13,0,0,0,0,0,1,'2020-09-13 12:03:25'),(75,81,2020,9,13,0,0,0,0,0,1,'2020-09-13 12:03:25'),(76,82,2020,9,13,0,0,0,0,0,1,'2020-09-13 12:03:26'),(77,44,2020,9,18,1,1,1,1,1,2,'2020-09-18 11:48:02'),(78,45,2020,9,18,2,2,2,2,2,2,'2020-09-18 11:48:02'),(79,46,2020,9,18,3,3,3,3,3,2,'2020-09-18 11:48:02'),(80,50,2020,9,18,4,4,4,4,4,2,'2020-09-18 11:48:02'),(81,51,2020,9,18,5,5,5,5,5,2,'2020-09-18 11:48:02'),(82,52,2020,9,18,6,6,6,6,6,2,'2020-09-18 11:48:02'),(83,11,2020,9,16,1,1,1,1,1,2,'2020-09-18 11:51:29'),(84,12,2020,9,16,0,0,0,0,0,2,'2020-09-18 11:51:29'),(85,13,2020,9,16,0,0,0,0,0,2,'2020-09-18 11:51:29'),(86,14,2020,9,16,0,0,0,0,0,2,'2020-09-18 11:51:29'),(87,15,2020,9,16,0,0,0,0,0,2,'2020-09-18 11:51:29'),(88,21,2020,9,16,0,0,0,0,0,2,'2020-09-18 11:51:29'),(89,11,2020,9,14,0,0,0,0,0,1,'2020-09-18 09:42:46'),(90,12,2020,9,14,0,0,0,0,0,1,'2020-09-18 09:42:46'),(91,13,2020,9,14,0,0,0,0,0,1,'2020-09-18 09:42:46'),(92,14,2020,9,14,0,0,0,0,0,1,'2020-09-18 09:42:46'),(93,15,2020,9,14,0,0,0,0,0,1,'2020-09-18 09:42:46'),(94,21,2020,9,14,0,0,0,0,0,1,'2020-09-18 09:42:46'),(95,22,2020,9,12,1,1,1,1,1,1,'2020-09-18 10:29:20'),(96,23,2020,9,12,0,0,0,0,0,1,'2020-09-18 10:29:20'),(97,31,2020,9,12,0,0,0,0,0,1,'2020-09-18 10:29:20'),(98,32,2020,9,12,0,0,0,0,0,1,'2020-09-18 10:29:20'),(99,33,2020,9,12,0,0,0,0,0,1,'2020-09-18 10:29:20'),(100,34,2020,9,12,0,0,0,0,0,1,'2020-09-18 10:29:20'),(101,35,2020,9,12,0,0,0,0,0,1,'2020-09-18 10:29:26'),(102,36,2020,9,12,0,0,0,0,0,1,'2020-09-18 10:29:26'),(103,37,2020,9,12,0,0,0,0,0,1,'2020-09-18 10:29:26'),(104,41,2020,9,12,0,0,0,0,0,1,'2020-09-18 10:29:26'),(105,42,2020,9,12,0,0,0,0,0,1,'2020-09-18 10:29:26'),(106,43,2020,9,12,0,0,0,0,0,1,'2020-09-18 10:29:26'),(107,11,2020,11,17,1,1,1,1,1,1,'2020-11-17 11:06:59'),(108,12,2020,11,17,0,0,0,0,0,1,'2020-11-17 11:06:59'),(109,13,2020,11,17,0,0,0,0,0,1,'2020-11-17 11:06:59'),(110,14,2020,11,17,0,0,0,0,0,1,'2020-11-17 11:06:59'),(111,15,2020,11,17,0,0,0,0,0,1,'2020-11-17 11:06:59'),(112,21,2020,11,17,2,2,2,2,2,1,'2020-11-17 11:06:59'),(113,11,2020,11,18,1,1,1,1,1,1,'2020-11-18 14:17:05'),(114,12,2020,11,18,2,2,2,2,2,1,'2020-11-18 14:17:05'),(115,13,2020,11,18,3,3,3,3,3,1,'2020-11-18 14:17:05'),(116,14,2020,11,18,4,4,4,4,4,1,'2020-11-18 14:17:05'),(117,15,2020,11,18,5,5,5,5,5,1,'2020-11-18 14:17:05'),(118,21,2020,11,18,6,6,6,6,6,1,'2020-11-18 14:17:05'),(119,22,2020,11,18,1,0,0,0,0,1,'2020-11-18 15:38:45'),(120,23,2020,11,18,1,0,0,0,0,1,'2020-11-18 15:38:45'),(121,31,2020,11,18,1,0,0,0,0,1,'2020-11-18 15:38:45'),(122,32,2020,11,18,1,0,0,0,0,1,'2020-11-18 15:38:45'),(123,33,2020,11,18,1,0,0,0,0,1,'2020-11-18 15:38:45'),(124,34,2020,11,18,1,0,0,0,0,1,'2020-11-18 15:38:45'),(125,11,2020,11,20,1,1,1,1,1,1,'2020-11-20 14:43:38'),(126,12,2020,11,20,2,2,2,2,2,1,'2020-11-20 14:43:38'),(127,13,2020,11,20,3,0,0,0,0,1,'2020-11-20 14:43:38'),(128,14,2020,11,20,1,0,0,0,0,1,'2020-11-20 14:43:38'),(129,15,2020,11,20,1,0,0,0,0,1,'2020-11-20 14:43:38'),(130,21,2020,11,20,1,0,0,0,0,1,'2020-11-20 14:43:38'),(131,11,2020,11,23,1,0,0,0,0,1,'2020-11-23 14:12:14'),(132,12,2020,11,23,1,0,0,0,0,1,'2020-11-23 14:12:14'),(133,13,2020,11,23,1,0,0,0,0,1,'2020-11-23 14:12:14'),(134,14,2020,11,23,1,0,0,0,0,1,'2020-11-23 14:12:14'),(135,15,2020,11,23,1,0,0,0,0,1,'2020-11-23 14:12:14'),(136,21,2020,11,23,1,0,0,0,0,1,'2020-11-23 14:12:14'),(137,11,2020,11,24,1,0,0,0,0,1,'2020-11-24 14:41:45'),(138,12,2020,11,24,1,0,0,0,0,1,'2020-11-24 14:41:45'),(139,13,2020,11,24,1,0,0,0,0,1,'2020-11-24 14:41:45'),(140,14,2020,11,24,1,0,0,0,0,1,'2020-11-24 14:41:45'),(141,15,2020,11,24,1,0,0,0,0,1,'2020-11-24 14:41:45'),(142,21,2020,11,24,1,0,0,0,0,1,'2020-11-24 14:41:45'),(143,22,2020,11,24,2,0,0,0,0,1,'2020-11-24 15:36:27'),(144,23,2020,11,24,1,0,0,0,0,1,'2020-11-24 15:36:27'),(145,31,2020,11,24,1,0,0,0,0,1,'2020-11-24 15:36:27'),(146,32,2020,11,24,1,0,0,0,0,1,'2020-11-24 15:36:27'),(147,33,2020,11,24,1,0,0,0,0,1,'2020-11-24 15:36:27'),(148,34,2020,11,24,1,0,0,0,0,1,'2020-11-24 15:36:27'),(149,11,2020,11,25,1,0,0,0,0,1,'2020-11-25 17:27:56'),(150,12,2020,11,25,1,0,0,0,0,1,'2020-11-25 17:27:56'),(151,13,2020,11,25,1,0,0,0,0,1,'2020-11-25 17:27:56'),(152,14,2020,11,25,1,0,0,0,0,1,'2020-11-25 17:27:57'),(153,15,2020,11,25,1,0,0,0,0,1,'2020-11-25 17:27:57'),(154,21,2020,11,25,1,0,0,0,0,1,'2020-11-25 17:27:57');

/*Table structure for table `provinces` */

DROP TABLE IF EXISTS `provinces`;

CREATE TABLE `provinces` (
  `province_id` int(11) NOT NULL AUTO_INCREMENT,
  `province_name` varchar(10) DEFAULT NULL,
  `province_py` varchar(30) DEFAULT NULL,
  `del_flag` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`province_id`)
) ENGINE=InnoDB AUTO_INCREMENT=83 DEFAULT CHARSET=utf8;

/*Data for the table `provinces` */

insert  into `provinces`(`province_id`,`province_name`,`province_py`,`del_flag`) values (11,'北京','beijing',NULL),(12,'天津','tianjin',NULL),(13,'河北','hebei',NULL),(14,'山西','shanxi',NULL),(15,'内蒙古','neimenggu',NULL),(21,'辽宁','liaoning',NULL),(22,'吉林','jilin',NULL),(23,'黑龙江','heilongjiang',NULL),(31,'上海','shanghai',NULL),(32,'江苏','jiangsu',NULL),(33,'浙江','zhejiang',NULL),(34,'安徽','anhui',NULL),(35,'福建','fujian',NULL),(36,'江西','jiangxi',NULL),(37,'山东','shandong',NULL),(41,'河南','henan',NULL),(42,'湖北','hubei',NULL),(43,'湖南','hunan',NULL),(44,'广东','guangdong',NULL),(45,'广西','guangxi',NULL),(46,'海南','hainan',NULL),(50,'重庆','chongqing',NULL),(51,'四川','sichuan',NULL),(52,'贵州','guizhou',NULL),(53,'云南','yunnan',NULL),(54,'西藏','xizang',NULL),(61,'陕西','shaanxi',NULL),(62,'甘肃','gansu',NULL),(63,'青海','qinghai',NULL),(64,'宁夏','ningxia',NULL),(65,'新疆','xinjiang',NULL),(71,'台湾','taiwan',NULL),(81,'香港','xianggang',NULL),(82,'澳门','aomen',NULL);

/*Table structure for table `users` */

DROP TABLE IF EXISTS `users`;

CREATE TABLE `users` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `account` varchar(30) DEFAULT NULL,
  `password` varchar(100) DEFAULT NULL,
  `user_name` varchar(30) DEFAULT NULL,
  `del_flag` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

/*Data for the table `users` */

insert  into `users`(`user_id`,`account`,`password`,`user_name`,`del_flag`) values (1,'1','1','admin',0),(2,'zhangsan','23','张三',0),(3,'zhangsan2','232','张三2',0),(4,'lisi','123456','李四',NULL),(7,'wangwu','123','王五',NULL),(18,'2','2','2',NULL);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;