201912G05/kui.sql

/*
Navicat MySQL Data Transfer

Source Server         : 123
Source Server Version : 80016
Source Host           : localhost:3306
Source Database       : kui

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

Date: 2019-12-19 09:45:30
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for bar
-- ----------------------------
DROP TABLE IF EXISTS `bar`;
CREATE TABLE `bar` (
  `score` float DEFAULT NULL,
  `year` int(8) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of bar
-- ----------------------------
INSERT INTO `bar` VALUES ('26.4', '2016');
INSERT INTO `bar` VALUES ('27.5', '2017');
INSERT INTO `bar` VALUES ('27.4', '2018');
INSERT INTO `bar` VALUES ('25.9', '2019');

-- ----------------------------
-- Table structure for evaporation
-- ----------------------------
DROP TABLE IF EXISTS `evaporation`;
CREATE TABLE `evaporation` (
  `id` int(11) DEFAULT NULL,
  `num` int(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of evaporation
-- ----------------------------
INSERT INTO `evaporation` VALUES ('1', '20');
INSERT INTO `evaporation` VALUES ('2', '555');
INSERT INTO `evaporation` VALUES ('3', '543');
INSERT INTO `evaporation` VALUES ('4', '34');
INSERT INTO `evaporation` VALUES ('5', '54');
INSERT INTO `evaporation` VALUES ('6', '65');
INSERT INTO `evaporation` VALUES ('7', '65');
INSERT INTO `evaporation` VALUES ('8', '765');
INSERT INTO `evaporation` VALUES ('9', '67');
INSERT INTO `evaporation` VALUES ('10', '765');
INSERT INTO `evaporation` VALUES ('11', '57');
INSERT INTO `evaporation` VALUES ('12', '34');

-- ----------------------------
-- Table structure for line
-- ----------------------------
DROP TABLE IF EXISTS `line`;
CREATE TABLE `line` (
  `name` varchar(50) DEFAULT NULL,
  `year` int(8) DEFAULT NULL,
  `score` float DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of line
-- ----------------------------
INSERT INTO `line` VALUES ('詹皇', '2016', '26');
INSERT INTO `line` VALUES ('戴维斯', '2016', '28');
INSERT INTO `line` VALUES ('联盟平均分', '2016', '10.4');
INSERT INTO `line` VALUES ('詹皇', '2017', '27.5');
INSERT INTO `line` VALUES ('戴维斯', '2017', '28.1');
INSERT INTO `line` VALUES ('联盟平均分', '2017', '9.8');
INSERT INTO `line` VALUES ('詹皇', '2018', '27.4');
INSERT INTO `line` VALUES ('戴维斯', '2018', '25.9');
INSERT INTO `line` VALUES ('联盟平均分', '2018', '12.1');
INSERT INTO `line` VALUES ('戴维斯', '2019', '27.4');
INSERT INTO `line` VALUES ('联盟平均分', '2019', '11.8');
INSERT INTO `line` VALUES ('蔡徐坤', '2019', '5');
INSERT INTO `line` VALUES ('蔡徐坤', '2013', '44');
INSERT INTO `line` VALUES ('詹皇', '2019', '25');
INSERT INTO `line` VALUES ('詹皇', '11', '11');
INSERT INTO `line` VALUES ('詹皇', '11', '11');
INSERT INTO `line` VALUES ('詹皇', '11', '11');

-- ----------------------------
-- Table structure for long
-- ----------------------------
DROP TABLE IF EXISTS `long`;
CREATE TABLE `long` (
  `年份` varchar(255) DEFAULT NULL,
  `詹皇` varchar(255) DEFAULT NULL,
  `戴维斯` varchar(255) DEFAULT NULL,
  `联盟平均得分` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records of long
-- ----------------------------
INSERT INTO `long` VALUES ('2016', '27.5', '27.4', '25.9');
INSERT INTO `long` VALUES ('2018', '27.5', '27.4', '25.9');
INSERT INTO `long` VALUES ('2017', '27.5', '27.4', '25.9');
INSERT INTO `long` VALUES ('2019', '27.5', '27.4', '25.9');

-- ----------------------------
-- Table structure for pie
-- ----------------------------
DROP TABLE IF EXISTS `pie`;
CREATE TABLE `pie` (
  `name` varchar(50) DEFAULT NULL,
  `score` float DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of pie
-- ----------------------------
INSERT INTO `pie` VALUES ('詹皇', '2045');
INSERT INTO `pie` VALUES ('戴维斯', '2211');
INSERT INTO `pie` VALUES ('其他成员', '4756');

-- ----------------------------
-- Table structure for rainfall
-- ----------------------------
DROP TABLE IF EXISTS `rainfall`;
CREATE TABLE `rainfall` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `num` int(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of rainfall
-- ----------------------------
INSERT INTO `rainfall` VALUES ('1', '121');
INSERT INTO `rainfall` VALUES ('2', '232');
INSERT INTO `rainfall` VALUES ('3', '231');
INSERT INTO `rainfall` VALUES ('4', '431');
INSERT INTO `rainfall` VALUES ('5', '121');
INSERT INTO `rainfall` VALUES ('6', '121');
INSERT INTO `rainfall` VALUES ('7', '211');
INSERT INTO `rainfall` VALUES ('8', '122');
INSERT INTO `rainfall` VALUES ('9', '233');
INSERT INTO `rainfall` VALUES ('10', '234');
INSERT INTO `rainfall` VALUES ('11', '231');
INSERT INTO `rainfall` VALUES ('12', '234');

-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
  `name` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci DEFAULT NULL,
  `calssGrent` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci DEFAULT NULL,
  `result` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records of student
-- ----------------------------
INSERT INTO `student` VALUES ('惠普暗影精灵5 ', '5454', '4599');
INSERT INTO `student` VALUES ('Alienware 18', '4571', '4K');
INSERT INTO `student` VALUES ('iPhone XS Max22', '1ee', 'eeee');
INSERT INTO `student` VALUES ('第三方发斯蒂芬n', '23', '23');