/*
Navicat Premium Data Transfer
Source Server : 本地数据库
Source Server Type : MySQL
Source Server Version : 50633
Source Host : localhost:3306
Source Schema : test
Target Server Type : MySQL
Target Server Version : 50633
File Encoding : 65001
Date: 08/12/2017 17:08:01
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for salaries
-- ----------------------------
DROP TABLE IF EXISTS `salaries`;
CREATE TABLE `salaries` (
`emp_no` int(11) NOT NULL,
`salary` int(11) NOT NULL,
`from_date` date NOT NULL,
`to_date` date NOT NULL,
PRIMARY KEY (`emp_no`, `from_date`) USING BTREE,
CONSTRAINT `salaries_ibfk_1` FOREIGN KEY (`emp_no`) REFERENCES `employees` (`emp_no`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of salaries
-- ----------------------------
INSERT INTO `salaries` VALUES (10001, 60117, '1986-06-26', '1987-06-26');
INSERT INTO `salaries` VALUES (10001, 62102, '1987-06-26', '1988-06-25');
INSERT INTO `salaries` VALUES (10001, 66074, '1988-06-25', '1989-06-25');
INSERT INTO `salaries` VALUES (10001, 66596, '1989-06-25', '1990-06-25');
INSERT INTO `salaries` VALUES (10001, 66961, '1990-06-25', '1991-06-25');
INSERT INTO `salaries` VALUES (10001, 71046, '1991-06-25', '1992-06-24');
INSERT INTO `salaries` VALUES (10001, 74333, '1992-06-24', '1993-06-24');
INSERT INTO `salaries` VALUES (10001, 75286, '1993-06-24', '1994-06-24');
INSERT INTO `salaries` VALUES (10001, 75994, '1994-06-24', '1995-06-24');
INSERT INTO `salaries` VALUES (10001, 76884, '1995-06-24', '1996-06-23');
INSERT INTO `salaries` VALUES (10001, 80013, '1996-06-23', '1997-06-23');
INSERT INTO `salaries` VALUES (10001, 81025, '1997-06-23', '1998-06-23');
INSERT INTO `salaries` VALUES (10001, 81097, '1998-06-23', '1999-06-23');
INSERT INTO `salaries` VALUES (10001, 84917, '1999-06-23', '2000-06-22');
INSERT INTO `salaries` VALUES (10001, 85112, '2000-06-22', '2001-06-22');
INSERT INTO `salaries` VALUES (10001, 85097, '2001-06-22', '2002-06-22');
INSERT INTO `salaries` VALUES (10001, 88958, '2002-06-22', '9999-01-01');
INSERT INTO `salaries` VALUES (10002, 65828, '1996-08-03', '1997-08-03');
INSERT INTO `salaries` VALUES (10002, 65909, '1997-08-03', '1998-08-03');
INSERT INTO `salaries` VALUES (10002, 67534, '1998-08-03', '1999-08-03');
INSERT INTO `salaries` VALUES (10002, 69366, '1999-08-03', '2000-08-02');
INSERT INTO `salaries` VALUES (10002, 71963, '2000-08-02', '2001-08-02');
INSERT INTO `salaries` VALUES (10002, 72527, '2001-08-02', '9999-01-01');
INSERT INTO `salaries` VALUES (10003, 40006, '1995-12-03', '1996-12-02');
INSERT INTO `salaries` VALUES (10003, 43616, '1996-12-02', '1997-12-02');
INSERT INTO `salaries` VALUES (10003, 43466, '1997-12-02', '1998-12-02');
INSERT INTO `salaries` VALUES (10003, 43636, '1998-12-02', '1999-12-02');
INSERT INTO `salaries` VALUES (10003, 43478, '1999-12-02', '2000-12-01');
INSERT INTO `salaries` VALUES (10003, 43699, '2000-12-01', '2001-12-01');
INSERT INTO `salaries` VALUES (10003, 43311, '2001-12-01', '9999-01-01');
INSERT INTO `salaries` VALUES (10004, 40054, '1986-12-01', '1987-12-01');
INSERT INTO `salaries` VALUES (10004, 42283, '1987-12-01', '1988-11-30');
INSERT INTO `salaries` VALUES (10004, 42542, '1988-11-30', '1989-11-30');
INSERT INTO `salaries` VALUES (10004, 46065, '1989-11-30', '1990-11-30');
INSERT INTO `salaries` VALUES (10004, 48271, '1990-11-30', '1991-11-30');
INSERT INTO `salaries` VALUES (10004, 50594, '1991-11-30', '1992-11-29');
INSERT INTO `salaries` VALUES (10004, 52119, '1992-11-29', '1993-11-29');
INSERT INTO `salaries` VALUES (10004, 54693, '1993-11-29', '1994-11-29');
INSERT INTO `salaries` VALUES (10004, 58326, '1994-11-29', '1995-11-29');
INSERT INTO `salaries` VALUES (10004, 60770, '1995-11-29', '1996-11-28');
INSERT INTO `salaries` VALUES (10004, 62566, '1996-11-28', '1997-11-28');
INSERT INTO `salaries` VALUES (10004, 64340, '1997-11-28', '1998-11-28');
INSERT INTO `salaries` VALUES (10004, 67096, '1998-11-28', '1999-11-28');
INSERT INTO `salaries` VALUES (10004, 69722, '1999-11-28', '2000-11-27');
INSERT INTO `salaries` VALUES (10004, 70698, '2000-11-27', '2001-11-27');
INSERT INTO `salaries` VALUES (10004, 74057, '2001-11-27', '9999-01-01');
INSERT INTO `salaries` VALUES (10005, 78228, '1989-09-12', '1990-09-12');
INSERT INTO `salaries` VALUES (10005, 82621, '1990-09-12', '1991-09-12');
INSERT INTO `salaries` VALUES (10005, 83735, '1991-09-12', '1992-09-11');
INSERT INTO `salaries` VALUES (10005, 85572, '1992-09-11', '1993-09-11');
INSERT INTO `salaries` VALUES (10005, 85076, '1993-09-11', '1994-09-11');
INSERT INTO `salaries` VALUES (10005, 86050, '1994-09-11', '1995-09-11');
INSERT INTO `salaries` VALUES (10005, 88448, '1995-09-11', '1996-09-10');
INSERT INTO `salaries` VALUES (10005, 88063, '1996-09-10', '1997-09-10');
INSERT INTO `salaries` VALUES (10005, 89724, '1997-09-10', '1998-09-10');
INSERT INTO `salaries` VALUES (10005, 90392, '1998-09-10', '1999-09-10');
INSERT INTO `salaries` VALUES (10005, 90531, '1999-09-10', '2000-09-09');
INSERT INTO `salaries` VALUES (10005, 91453, '2000-09-09', '2001-09-09');
INSERT INTO `salaries` VALUES (10005, 94692, '2001-09-09', '9999-01-01');
INSERT INTO `salaries` VALUES (10006, 40000, '1990-08-05', '1991-08-05');
INSERT INTO `salaries` VALUES (10006, 42085, '1991-08-05', '1992-08-04');
INSERT INTO `salaries` VALUES (10006, 42629, '1992-08-04', '1993-08-04');
INSERT INTO `salaries` VALUES (10006, 45844, '1993-08-04', '1994-08-04');
INSERT INTO `salaries` VALUES (10006, 47518, '1994-08-04', '1995-08-04');
INSERT INTO `salaries` VALUES (10006, 47917, '1995-08-04', '1996-08-03');
INSERT INTO `salaries` VALUES (10006, 52255, '1996-08-03', '1997-08-03');
INSERT INTO `salaries` VALUES (10006, 53747, '1997-08-03', '1998-08-03');
INSERT INTO `salaries` VALUES (10006, 56032, '1998-08-03', '1999-08-03');
INSERT INTO `salaries` VALUES (10006, 58299, '1999-08-03', '2000-08-02');
INSERT INTO `salaries` VALUES (10006, 60098, '2000-08-02', '2001-08-02');
INSERT INTO `salaries` VALUES (10006, 59755, '2001-08-02', '9999-01-01');
INSERT INTO `salaries` VALUES (10007, 56724, '1989-02-10', '1990-02-10');
INSERT INTO `salaries` VALUES (10007, 60740, '1990-02-10', '1991-02-10');
INSERT INTO `salaries` VALUES (10007, 62745, '1991-02-10', '1992-02-10');
INSERT INTO `salaries` VALUES (10007, 63475, '1992-02-10', '1993-02-09');
INSERT INTO `salaries` VALUES (10007, 63208, '1993-02-09', '1994-02-09');
INSERT INTO `salaries` VALUES (10007, 64563, '1994-02-09', '1995-02-09');
INSERT INTO `salaries` VALUES (10007, 68833, '1995-02-09', '1996-02-09');
INSERT INTO `salaries` VALUES (10007, 70220, '1996-02-09', '1997-02-08');
INSERT INTO `salaries` VALUES (10007, 73362, '1997-02-08', '1998-02-08');
INSERT INTO `salaries` VALUES (10007, 75582, '1998-02-08', '1999-02-08');
INSERT INTO `salaries` VALUES (10007, 79513, '1999-02-08', '2000-02-08');
INSERT INTO `salaries` VALUES (10007, 80083, '2000-02-08', '2001-02-07');
INSERT INTO `salaries` VALUES (10007, 84456, '2001-02-07', '2002-02-07');
INSERT INTO `salaries` VALUES (10007, 88070, '2002-02-07', '9999-01-01');
INSERT INTO `salaries` VALUES (10008, 46671, '1998-03-11', '1999-03-11');
INSERT INTO `salaries` VALUES (10008, 48584, '1999-03-11', '2000-03-10');
INSERT INTO `salaries` VALUES (10008, 52668, '2000-03-10', '2000-07-31');
INSERT INTO `salaries` VALUES (10009, 60929, '1985-02-18', '1986-02-18');
INSERT INTO `salaries` VALUES (10009, 64604, '1986-02-18', '1987-02-18');
INSERT INTO `salaries` VALUES (10009, 64780, '1987-02-18', '1988-02-18');
INSERT INTO `salaries` VALUES (10009, 66302, '1988-02-18', '1989-02-17');
INSERT INTO `salaries` VALUES (10009, 69042, '1989-02-17',