CREATE TABLE `dummy_employees` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `firstname` varchar(255) default NULL,
  `lastname` varchar(255) default NULL,
  `birthdate` DATE,
  `date_hired` DATE,
  `position` varchar(255) default NULL,
  PRIMARY KEY (`id`)
) AUTO_INCREMENT=1;

INSERT INTO `dummy_employees` (`firstname`,`lastname`,`birthdate`,`date_hired`,`position`) VALUES ("Conan","Hurst","1970-07-07 04:51:41","2014-09-14 00:03:30","Office manager"),("Honorato","Richmond","1967-03-10 17:24:52","2015-02-08 10:49:25","Secretary"),("Ivory","Schmidt","1989-05-29 18:58:43","2015-01-08 03:53:48","Designer"),("Quintessa","Odonnell","1982-01-02 22:39:07","2014-07-20 16:15:35","Junior Java developer"),("Jocelyn","Hicks","1976-04-29 05:11:31","2015-02-20 20:20:45","Designer"),("Thaddeus","Gay","1970-01-09 12:44:09","2014-11-21 06:31:58","Lead developer"),("Taylor","Solis","1969-09-21 10:43:16","2015-03-11 13:20:42","Designer"),("Yardley","Kirk","1992-06-11 18:54:14","2015-04-16 06:31:54","Freelance designer"),("Bryar","Vasquez","1986-11-11 16:46:16","2015-01-15 18:53:10","Secretary"),("Caryn","Suarez","1994-06-28 02:55:51","2014-07-20 04:00:37","Lead developer");
INSERT INTO `dummy_employees` (`firstname`,`lastname`,`birthdate`,`date_hired`,`position`) VALUES ("Perry","Sanchez","1993-08-27 16:00:27","2014-10-29 01:25:04","Project manager"),("Patience","Moses","1983-11-18 04:16:29","2014-08-14 11:26:36","Office manager"),("Shaine","Jarvis","1974-03-19 05:14:17","2015-02-16 06:50:21","Designer"),("Rashad","Chan","1971-07-21 11:04:18","2014-08-18 07:57:42","Project manager"),("Lillian","Figueroa","1982-12-15 15:51:48","2015-01-09 22:03:08","Designer"),("Wade","Walker","1977-06-03 03:29:35","2014-08-09 20:53:47","Junior Java developer"),("Zia","Montoya","1988-11-09 20:52:24","2015-04-19 09:13:40","Project manager"),("Helen","Lyons","1991-07-31 17:33:26","2014-11-13 07:25:39","Senior Java developer"),("Dominic","Whitehead","1968-01-13 14:11:54","2014-12-03 08:15:46","Office manager"),("Desiree","Brennan","1973-10-10 11:02:24","2015-04-12 08:41:00","Junior C++ developer");
INSERT INTO `dummy_employees` (`firstname`,`lastname`,`birthdate`,`date_hired`,`position`) VALUES ("Daniel","Gonzalez","1990-11-10 06:06:33","2014-07-28 16:34:54","Junior Android developer"),("Holly","Wilson","1972-11-06 00:36:54","2015-02-24 02:30:00","Key account manager"),("Gary","Carney","1968-02-10 07:10:47","2015-02-25 04:23:41","MySQL DB manager"),("Hannah","Wilson","1982-02-19 13:18:48","2014-08-02 19:00:35","Project manager"),("Carter","Watson","1994-03-19 04:03:28","2014-09-29 13:03:16","Secretary"),("Ria","Gould","1979-03-05 14:18:42","2014-08-13 17:23:02","MySQL DB manager"),("Rhonda","Wiggins","1989-02-15 04:32:29","2015-02-23 07:32:37","Freelance developer"),("Signe","Wyatt","1972-08-28 13:16:50","2015-01-18 05:20:55","Project manager"),("Abigail","Joyner","1976-08-27 11:18:08","2014-06-24 00:31:57","Junior Android developer"),("Nerea","Bond","1969-11-02 02:50:42","2015-03-18 09:11:39","Project manager");
INSERT INTO `dummy_employees` (`firstname`,`lastname`,`birthdate`,`date_hired`,`position`) VALUES ("Fay","Hutchinson","1981-12-09 13:05:20","2014-06-19 09:51:31","Freelance designer"),("Gillian","Miles","1972-01-25 19:54:13","2014-08-01 03:08:26","Junior Android developer"),("Brynne","Barnes","1990-12-15 07:43:51","2014-08-20 07:53:19","Senior Java developer"),("Jasmine","Cross","1969-03-27 06:40:44","2015-01-24 08:00:56","MySQL DB manager"),("Abdul","Gates","1969-12-04 07:55:57","2015-04-19 10:29:28","Designer"),("Cameron","Hubbard","1992-07-10 19:43:47","2015-02-21 00:01:58","Lead developer"),("Meredith","Peck","1973-11-16 10:03:49","2014-12-25 07:33:13","Senior Java developer"),("Buckminster","Torres","1978-11-23 02:42:27","2014-10-09 06:55:25","Lead developer"),("Fulton","Vance","1993-11-13 11:05:13","2014-12-28 08:18:56","Freelance designer"),("Cadman","Page","1975-02-24 17:38:13","2014-10-28 20:33:00","Senior Java developer");
INSERT INTO `dummy_employees` (`firstname`,`lastname`,`birthdate`,`date_hired`,`position`) VALUES ("Sharon","Wilkins","1993-03-13 02:44:19","2014-07-15 12:43:39","Designer"),("Diana","Sellers","1990-04-13 22:09:31","2014-07-15 07:02:57","MySQL DB manager"),("Buckminster","Hinton","1991-03-18 04:51:50","2014-07-03 15:15:38","Freelance developer"),("Uriah","Simpson","1988-12-25 23:33:12","2015-02-25 05:07:01","Senior Java developer"),("Ainsley","Torres","1987-01-21 17:57:59","2015-01-09 21:18:50","Key account manager"),("Ivory","Sanders","1978-07-04 15:11:12","2014-08-22 15:06:18","Junior C++ developer"),("Amaya","Johnston","1972-02-20 07:30:00","2014-08-15 02:51:53","Freelance designer"),("Sylvia","Mckay","1968-06-03 21:57:04","2014-11-19 07:56:52","Senior PHP developer"),("Leila","Guzman","1973-08-23 03:28:25","2014-10-07 00:33:44","Project manager"),("Caryn","Talley","1983-11-19 00:49:28","2014-07-21 17:13:53","Junior C++ developer");
INSERT INTO `dummy_employees` (`firstname`,`lastname`,`birthdate`,`date_hired`,`position`) VALUES ("Acton","Waller","1971-08-27 10:01:45","2014-12-31 17:53:22","Office manager"),("Yael","Long","1994-11-11 05:26:07","2014-07-25 14:13:46","Senior C++ developer"),("Kerry","Sharpe","1993-11-28 16:12:40","2014-08-15 07:06:44","Junior C++ developer"),("Cadman","Wagner","1973-05-10 13:36:55","2014-07-12 00:38:36","Junior PHP developer"),("Anthony","Deleon","1975-07-09 22:24:02","2015-03-22 23:54:47","Freelance designer"),("Mercedes","Ballard","1971-05-12 01:08:45","2014-10-30 00:30:34","Designer"),("Nevada","Harper","1990-04-11 20:10:26","2014-08-26 03:50:30","Secretary"),("Yoshi","Acevedo","1971-07-31 17:17:32","2014-11-09 08:10:51","Secretary"),("Len","Gaines","1968-09-04 00:08:18","2014-07-04 21:17:36","Senior C++ developer"),("Farrah","Trujillo","1977-02-22 15:07:25","2014-11-20 20:22:29","Junior PHP developer");
INSERT INTO `dummy_employees` (`firstname`,`lastname`,`birthdate`,`date_hired`,`position`) VALUES ("Alexis","Foster","1987-02-12 03:10:30","2015-03-13 03:07:49","Junior C++ developer"),("Sara","Yates","1981-08-11 14:45:17","2014-12-07 09:54:58","Key account manager"),("Lane","Hinton","1987-08-12 05:01:24","2015-01-07 23:01:54","Senior PHP developer"),("Evan","Decker","1980-01-23 06:39:44","2014-06-16 18:13:46","Project manager"),("Hillary","Valdez","1970-01-04 19:13:13","2015-03-03 17:34:21","Freelance designer"),("Dawn","Wheeler","1982-03-02 06:10:18","2014-11-20 02:54:01","Project manager"),("Basil","Adams","1983-01-23 09:46:07","2015-01-04 06:18:34","Lead developer"),("Bertha","Bradshaw","1982-06-12 23:44:25","2014-07-09 18:54:54","Freelance designer"),("Ingrid","Maynard","1983-12-02 08:21:53","2015-02-03 12:42:23","Senior Java developer"),("Lionel","Woodward","1973-01-07 21:04:40","2014-07-25 20:25:35","Lead developer");
INSERT INTO `dummy_employees` (`firstname`,`lastname`,`birthdate`,`date_hired`,`position`) VALUES ("Ingrid","Hancock","1965-02-15 11:24:40","2015-03-05 17:28:22","Senior PHP developer"),("Galena","Hanson","1974-06-15 16:01:57","2015-03-10 05:18:19","Junior C++ developer"),("Kiara","Reid","1982-09-24 18:37:02","2014-06-01 15:54:51","Junior PHP developer"),("Mohammad","Abbott","1988-02-13 07:22:19","2015-01-14 08:47:14","Junior C++ developer"),("Victor","Le","1977-10-22 11:29:53","2014-07-02 02:33:51","MySQL DB manager"),("Calvin","Emerson","1984-04-29 07:36:35","2015-02-02 15:45:14","Key account manager"),("Madison","Phelps","1992-08-19 22:43:25","2015-04-15 13:54:25","Office manager"),("Liberty","Hinton","1989-07-12 09:17:23","2014-11-05 16:52:36","Junior PHP developer"),("Sigourney","Harper","1983-04-24 15:37:49","2014-08-30 03:30:40","Freelance designer"),("Daquan","Beard","1966-08-21 11:39:12","2014-10-08 02:09:34","Junior Java developer");
INSERT INTO `dummy_employees` (`firstname`,`lastname`,`birthdate`,`date_hired`,`position`) VALUES ("Neil","Drake","1987-01-13 10:28:54","2014-08-24 07:28:02","Lead developer"),("Harriet","Mann","1971-10-27 02:57:48","2015-03-10 04:23:48","Project manager"),("Amethyst","Baxter","1982-12-29 03:20:17","2015-02-07 02:06:19","Designer"),("Joy","Duke","1966-02-03 12:27:34","2014-11-27 05:57:04","Junior PHP developer"),("David","Aguirre","1983-09-28 20:22:48","2014-07-26 07:28:23","Office manager"),("Nigel","Brown","1983-04-06 03:11:05","2014-07-22 15:24:36","Senior C++ developer"),("Raphael","Thornton","1982-12-29 12:44:20","2014-07-11 05:24:45","Key account manager"),("Basil","Garrison","1989-09-16 07:21:41","2014-07-01 15:40:11","MySQL DB manager"),("Nicholas","Miller","1967-08-17 08:42:16","2015-02-20 02:52:23","Junior Java developer"),("Cameran","Aguirre","1979-07-14 17:17:21","2014-10-17 19:47:33","Senior PHP developer");
INSERT INTO `dummy_employees` (`firstname`,`lastname`,`birthdate`,`date_hired`,`position`) VALUES ("Baker","Albert","1974-01-28 13:49:36","2014-09-08 06:16:05","Freelance developer"),("Alec","Davidson","1971-11-22 01:31:38","2014-11-16 21:38:42","Office manager"),("Martena","Pratt","1994-09-04 13:48:30","2015-02-24 22:37:25","Junior PHP developer"),("Donovan","Horn","1986-02-27 08:36:25","2014-11-24 01:04:04","Project manager"),("Tatum","Chandler","1981-08-04 19:27:31","2014-12-18 05:30:52","Junior C++ developer"),("Ayanna","Talley","1994-04-01 17:56:36","2014-09-26 13:47:27","Senior Java developer"),("Walter","Leach","1967-02-21 10:33:43","2014-06-17 16:02:41","Project manager"),("Shelby","Dunlap","1993-06-15 09:17:57","2014-10-28 11:00:53","Junior C++ developer"),("Leilani","Nieves","1973-07-29 16:01:01","2014-11-03 04:49:49","Project manager"),("Alexandra","Reilly","1980-09-03 13:57:02","2015-02-01 02:45:54","Junior PHP developer");
