air
/
air.sql

/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50726
Source Host           : localhost:3306
Source Database       : air

Target Server Type    : MYSQL
Target Server Version : 50726
File Encoding         : 65001

Date: 2021-04-22 11:05:47
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `air`
-- ----------------------------
DROP TABLE IF EXISTS `air`;
CREATE TABLE `air` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `district_id` int(11) NOT NULL COMMENT '区域主键',
  `monitor_time` date NOT NULL COMMENT '检测时间',
  `pm10` int(11) NOT NULL COMMENT 'pm10值',
  `pm25` int(11) NOT NULL COMMENT 'pm2.5值',
  `monitoring_station` varchar(32) NOT NULL COMMENT '检测站',
  `last_modify_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间',
  PRIMARY KEY (`id`),
  KEY `normal_pm10` (`pm10`) USING BTREE,
  KEY `fk_district` (`district_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8mb4 COMMENT='空气质量表';

-- ----------------------------
-- Records of air
-- ----------------------------
INSERT INTO `air` VALUES ('2', '3', '2011-11-11', '999', '999', '阿西监测站', '2021-03-27 10:49:58');
INSERT INTO `air` VALUES ('4', '2', '2021-03-23', '13', '323', '阿西阿西监测站', '2021-03-23 17:56:10');
INSERT INTO `air` VALUES ('5', '2', '2021-03-23', '23', '32', '阿杜跟监测站', '2021-03-23 17:56:25');
INSERT INTO `air` VALUES ('6', '5', '2021-03-23', '4', '43', '耗油跟监测站', '2021-03-26 14:50:25');
INSERT INTO `air` VALUES ('7', '3', '2021-03-23', '32', '432', '加加布鲁根监测站', '2021-03-26 14:50:21');
INSERT INTO `air` VALUES ('8', '2', '2021-03-23', '323', '32', '歪比巴卜监测站', '2021-03-23 17:57:10');
INSERT INTO `air` VALUES ('9', '2', '2021-03-23', '323', '32', '歪比巴卜监测站', '2021-03-23 17:57:10');
INSERT INTO `air` VALUES ('10', '1', '2021-03-22', '323', '32', '歪比巴卜监测站', '2021-04-13 13:06:57');
INSERT INTO `air` VALUES ('11', '2', '2021-03-23', '323', '32', '歪比巴卜监测站', '2021-03-23 17:57:10');
INSERT INTO `air` VALUES ('12', '1', '2021-03-23', '32', '432', '加加布鲁根监测站', '2021-03-26 14:50:27');
INSERT INTO `air` VALUES ('13', '2', '2021-03-23', '23', '32', '阿杜跟监测站', '2021-03-23 17:56:25');
INSERT INTO `air` VALUES ('14', '3', '2021-03-23', '23', '32', '阿杜跟监测站', '2021-03-26 14:50:29');
INSERT INTO `air` VALUES ('15', '2', '2021-03-23', '13', '323', '阿西阿西监测站', '2021-03-23 17:56:10');
INSERT INTO `air` VALUES ('16', '2', '2021-03-23', '323', '32', '歪比巴卜监测站', '2021-03-23 17:57:10');
INSERT INTO `air` VALUES ('17', '5', '2021-03-23', '323', '32', '歪比巴卜监测站', '2021-03-26 14:50:30');
INSERT INTO `air` VALUES ('18', '2', '2021-03-23', '323', '32', '歪比巴卜监测站', '2021-03-23 17:57:10');
INSERT INTO `air` VALUES ('19', '4', '2021-03-23', '323', '32', '歪比巴卜监测站', '2021-03-26 14:50:32');
INSERT INTO `air` VALUES ('20', '5', '2021-03-01', '999', '999', '俄罗斯监测站', '2021-03-26 17:04:26');
INSERT INTO `air` VALUES ('21', '5', '2021-03-10', '111', '111', 'H&M监测站', '2021-03-26 17:07:38');
INSERT INTO `air` VALUES ('22', '2', '2021-03-02', '222', '222', 'NIKE监测站', '2021-03-26 17:09:29');
INSERT INTO `air` VALUES ('23', '2', '2021-03-01', '123', '123', '俄罗斯', '2021-03-26 17:12:02');
INSERT INTO `air` VALUES ('24', '1', '2021-03-09', '123', '1233', 'adidas监测站', '2021-03-26 17:13:02');
INSERT INTO `air` VALUES ('25', '1', '2021-03-17', '3123', '123', '123123', '2021-03-26 17:30:45');
INSERT INTO `air` VALUES ('26', '2', '2021-03-16', '11', '11', 'H&M监测站', '2021-03-27 08:49:18');
INSERT INTO `air` VALUES ('27', '1', '2011-11-11', '123', '111', '阿西监测站', '2021-03-26 14:50:20');
INSERT INTO `air` VALUES ('28', '1', '2011-11-11', '123', '111', '阿西监测站', '2021-03-26 14:50:20');
INSERT INTO `air` VALUES ('29', '1', '2011-11-11', '123', '111', '阿西监测站', '2021-03-26 14:50:20');
INSERT INTO `air` VALUES ('30', '1', '2011-11-11', '123', '111', '阿西监测站', '2021-03-26 14:50:20');
INSERT INTO `air` VALUES ('31', '5', '2021-03-23', '4', '43', '耗油跟监测站', '2021-03-26 14:50:25');
INSERT INTO `air` VALUES ('32', '5', '2021-03-23', '4', '43', '耗油跟监测站', '2021-03-26 14:50:25');
INSERT INTO `air` VALUES ('33', '5', '2021-03-23', '4', '43', '耗油跟监测站', '2021-03-26 14:50:25');
INSERT INTO `air` VALUES ('34', '3', '2021-03-23', '32', '432', '加加布鲁根监测站', '2021-03-26 14:50:21');
INSERT INTO `air` VALUES ('35', '3', '2021-03-23', '32', '432', '加加布鲁根监测站', '2021-03-26 14:50:21');
INSERT INTO `air` VALUES ('36', '3', '2021-03-23', '32', '432', '加加布鲁根监测站', '2021-03-26 14:50:21');
INSERT INTO `air` VALUES ('37', '3', '2021-03-23', '32', '432', '加加布鲁根监测站', '2021-03-26 14:50:21');
INSERT INTO `air` VALUES ('38', '5', '2021-03-23', '4', '43', '耗油跟监测站', '2021-03-26 14:50:25');
INSERT INTO `air` VALUES ('39', '5', '2021-03-23', '4', '43', '耗油跟监测站', '2021-03-26 14:50:25');
INSERT INTO `air` VALUES ('40', '3', '2021-03-23', '32', '432', '加加布鲁根监测站', '2021-03-26 14:50:21');
INSERT INTO `air` VALUES ('41', '3', '2021-03-23', '32', '432', '加加布鲁根监测站', '2021-03-26 14:50:21');
INSERT INTO `air` VALUES ('42', '2', '2021-03-23', '323', '32', '歪比巴卜监测站', '2021-03-23 17:57:10');
INSERT INTO `air` VALUES ('43', '1', '2021-03-23', '323', '32', '歪比巴卜监测站', '2021-03-26 14:50:24');
INSERT INTO `air` VALUES ('44', '1', '2021-03-23', '323', '32', '歪比巴卜监测站', '2021-03-26 14:50:24');
INSERT INTO `air` VALUES ('45', '3', '2021-03-23', '23', '32', '阿杜跟监测站', '2021-03-26 14:50:29');
INSERT INTO `air` VALUES ('46', '3', '2021-03-23', '23', '32', '阿杜跟监测站', '2021-03-26 14:50:29');
INSERT INTO `air` VALUES ('47', '4', '2021-03-23', '323', '32', '歪比巴卜监测站', '2021-03-26 14:50:32');
INSERT INTO `air` VALUES ('48', '4', '2021-03-23', '323', '32', '歪比巴卜监测站', '2021-03-26 14:50:32');
INSERT INTO `air` VALUES ('49', '4', '2021-03-23', '323', '32', '歪比巴卜监测站', '2021-03-26 14:50:32');
INSERT INTO `air` VALUES ('50', '4', '2021-03-23', '323', '32', '歪比巴卜监测站', '2021-03-26 14:50:32');
INSERT INTO `air` VALUES ('51', '4', '2021-03-23', '323', '32', '歪比巴卜监测站', '2021-03-26 14:50:32');
INSERT INTO `air` VALUES ('52', '4', '2021-03-23', '323', '32', '歪比巴卜监测站', '2021-03-26 14:50:32');
INSERT INTO `air` VALUES ('53', '5', '2021-03-01', '999', '999', '俄罗斯监测站', '2021-03-26 17:04:26');
INSERT INTO `air` VALUES ('54', '5', '2021-03-10', '111', '111', 'H&M监测站', '2021-03-26 17:07:38');
INSERT INTO `air` VALUES ('55', '2', '2021-03-01', '123', '123', '俄罗斯', '2021-03-26 17:12:02');
INSERT INTO `air` VALUES ('56', '1', '2021-03-17', '3123', '123', '123123', '2021-03-26 17:30:45');
INSERT INTO `air` VALUES ('57', '1', '2021-03-17', '3123', '123', '123123', '2021-03-26 17:30:45');
INSERT INTO `air` VALUES ('58', '4', '2021-03-23', '323', '32', '歪比巴卜监测站', '2021-03-26 14:50:32');
INSERT INTO `air` VALUES ('59', '3', '2021-03-23', '23', '32', '阿杜跟监测站', '2021-03-26 14:50:29');
INSERT INTO `air` VALUES ('60', '3', '2021-03-23', '23', '32', '阿杜跟监测站', '2021-03-26 14:50:29');
INSERT INTO `air` VALUES ('61', '3', '2021-03-23', '32', '432', '加加布鲁根监测站', '2021-03-26 14:50:21');

-- ----------------------------
-- Table structure for `district`
-- ----------------------------
DROP TABLE IF EXISTS `district`;
CREATE TABLE `district` (
  `id` int(11) NOT NULL COMMENT '主键',
  `name` varchar(32) NOT NULL COMMENT '区域信息',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='区域表';

-- ----------------------------
-- Records of district
-- ----------------------------
INSERT INTO `district` VALUES ('1', '西城');
INSERT INTO `district` VALUES ('2', '东城');
INSERT INTO `district` VALUES ('3', '昌平');
INSERT INTO `district` VALUES ('4', '朝阳');
INSERT INTO `district` VALUES ('5', '海淀');

-- ----------------------------
-- Table structure for `user`
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(16) NOT NULL,
  `password` varchar(64) NOT NULL,
  `salt` varchar(64) NOT NULL,
  `nickname` varchar(16) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', 'test', 'd6071646537a87018cd7d04dfc72190d', 'abdcefdsgkudfhgkjdfghdfgdf', '嘿嘿嘿');