text: -- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  -- /*!40101 SET NAMES utf8mb4 */;
  -- /*!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' */;
  
  
  -- CREATE DATABASE IF NOT EXISTS `soft_uni` /*!40100 DEFAULT CHARACTER SET utf8 */;
  -- USE `soft_uni`;
  
  
  -- CREATE TABLE IF NOT EXISTS `addresses` (
  --   `address_id` int(10) NOT NULL AUTO_INCREMENT,
  --   `address_text` varchar(100) NOT NULL,
  --   `town_id` int(10) DEFAULT NULL,
  --   PRIMARY KEY (`address_id`),
  --   UNIQUE KEY `PK_Addresses` (`address_id`),
  --   KEY `fk_addresses_towns` (`town_id`),
  --   CONSTRAINT `fk_addresses_towns` FOREIGN KEY (`town_id`) REFERENCES `towns` (`town_id`)
  -- ) ENGINE=InnoDB AUTO_INCREMENT=292 DEFAULT CHARSET=utf8;
  
  
  -- /*!40000 ALTER TABLE `addresses` DISABLE KEYS */;
  -- INSERT INTO `addresses` (`address_id`, `address_text`, `town_id`) VALUES
  -- 	(1, '108 Lakeside Court', 5),
  -- 	(2, '1343 Prospect St', 5),
  -- 	(3, '1648 Eastgate Lane', 5),
  -- 	(4, '2284 Azalea Avenue', 5),
  -- 	(5, '2947 Vine Lane', 5),
  -- 	(6, '3067 Maya', 5),
  -- 	(7, '3197 Thornhill Place', 5),
  -- 	(8, '3284 S. Blank Avenue', 5),
  -- 	(9, '332 Laguna Niguel', 5),
  -- 	(10, '3454 Bel Air Drive', 5),
  -- 	(11, '3670 All Ways Drive', 5),
  -- 	(12, '3708 Montana', 5),
  -- 	(13, '3711 Rollingwood Dr', 5),
  -- 	(14, '3919 Pinto Road', 5),
  -- 	(15, '4311 Clay Rd', 5),
  -- 	(16, '4777 Rockne Drive', 5),
  -- 	(17, '5678 Clear Court', 5),
  -- 	(18, '5863 Sierra', 5),
  -- 	(19, '6058 Hill Street', 5),
  -- 	(20, '6118 Grasswood Circle', 5),
  -- 	(21, '620 Woodside Ct.', 5),
  -- 	(22, '6307 Greenbelt Way', 5),
  -- 	(23, '6448 Castle Court', 5),
  -- 	(24, '6774 Bonanza', 5),
  -- 	(25, '6968 Wren Ave.', 5),
  -- 	(26, '7221 Peachwillow Street', 5),
  -- 	(27, '7270 Pepper Way', 5),
  -- 	(28, '7396 Stratton Circle', 5),
  -- 	(29, '7808 Brown St.', 5),
  -- 	(30, '7902 Grammercy Lane', 5),
  -- 	(31, '8668 Via Neruda', 5),
  -- 	(32, '8684 Military East', 5),
  -- 	(33, '8751 Norse Drive', 5),
  -- 	(34, '9320 Teakwood Dr.', 5),
  -- 	(35, '9435 Breck Court', 5),
  -- 	(36, '9745 Bonita Ct.', 5),
  -- 	(37, 'Pascalstr 951', 31),
  -- 	(38, '94, rue Descartes', 30),
  -- 	(39, '1226 Shoe St.', 8),
  -- 	(40, '1399 Firestone Drive', 8),
  -- 	(41, '1902 Santa Cruz', 8),
  -- 	(42, '1970 Napa Ct.', 8),
  -- 	(43, '250 Race Court', 8),
  -- 	(44, '5672 Hale Dr.', 8),
  -- 	(45, '5747 Shirley Drive', 8),
  -- 	(46, '6387 Scenic Avenue', 8),
  -- 	(47, '6872 Thornwood Dr.', 8),
  -- 	(48, '7484 Roundtree Drive', 8),
  -- 	(49, '8157 W. Book', 8),
  -- 	(50, '9539 Glenside Dr', 8),
  -- 	(51, '9833 Mt. Dias Blv.', 8),
  -- 	(52, '10203 Acorn Avenue', 2),
  -- 	(53, '3997 Via De Luna', 23),
  -- 	(54, 'Downshire Way', 23),
  -- 	(55, '1411 Ranch Drive', 15),
  -- 	(56, '3074 Arbor Drive', 15),
  -- 	(57, '390 Ridgewood Ct.', 15),
  -- 	(58, '9666 Northridge Ct.', 15),
  -- 	(59, '9752 Jeanne Circle', 15),
  -- 	(60, '8154 Via Mexico', 27),
  -- 	(61, '80 Sunview Terrace', 26),
  -- 	(62, '1825 Corte Del Prado', 17),
  -- 	(63, '2598 La Vista Circle', 17),
  -- 	(64, '3421 Bouncing Road', 17),
  -- 	(65, '3977 Central Avenue', 17),
  -- 	(66, '5086 Nottingham Place', 17),
  -- 	(67, '5379 Treasure Island Way', 17),
  -- 	(68, '8209 Green View Court', 17),
  -- 	(69, '8463 Vista Avenue', 17),
  -- 	(70, '9693 Mellowood Street', 17),
  -- 	(71, '991 Vista Verde', 17),
  -- 	(72, '1061 Buskrik Avenue', 3),
  -- 	(73, '172 Turning Dr.', 3),
  -- 	(74, '2038 Encino Drive', 3),
  -- 	(75, '2046 Las Palmas', 3),
  -- 	(76, '2059 Clay Rd', 3),
  -- 	(77, '207 Berry Court', 3),
  -- 	(78, '2080 Sycamore Drive', 3),
  -- 	(79, '2466 Clearland Circle', 3),
  -- 	(80, '2687 Ridge Road', 3),
  -- 	(81, '2812 Mazatlan', 3),
  -- 	(82, '3026 Anchor Drive', 3),
  -- 	(83, '3281 Hillview Dr.', 3),
  -- 	(84, '3632 Bank Way', 3),
  -- 	(85, '371 Apple Dr.', 3),
  -- 	(86, '504 O St.', 3),
  -- 	(87, '5423 Champion Rd.', 3),
  -- 	(88, '6057 Hill Street', 3),
  -- 	(89, '6870 D Bel Air Drive', 3),
  -- 	(90, '7338 Green St.', 3),
  -- 	(91, '7511 Cooper Dr.', 3),
  -- 	(92, '8152 Claudia Dr.', 3),
  -- 	(93, '8411 Mt. Orange Place', 3),
  -- 	(94, '9277 Country View Lane', 3),
  -- 	(95, '9784 Mt Etna Drive', 3),
  -- 	(96, '9825 Coralie Drive', 3),
  -- 	(97, '1185 Dallas Drive', 7),
  -- 	(98, '1362 Somerset Place', 7),
  -- 	(99, '181 Gaining Drive', 7),
  -- 	(100, '1962 Cotton Ct.', 7),
  -- 	(101, '2176 Apollo Way', 7),
  -- 	(102, '2294 West 39th St.', 7),
  -- 	(103, '3238 Laguna Circle', 7),
  -- 	(104, '3385 Crestview Drive', 7),
  -- 	(105, '3665 Oak Creek Ct.', 7),
  -- 	(106, '3928 San Francisco', 7),
  -- 	(107, '475 Santa Maria', 7),
  -- 	(108, '5242 Marvelle Ln.', 7),
  -- 	(109, '5452 Corte Gilberto', 7),
  -- 	(110, '6629 Polson Circle', 7),
  -- 	(111, '7640 First Ave.', 7),
  -- 	(112, '7883 Missing Canyon Court', 7),
  -- 	(113, '8624 Pepper Way', 7),
  -- 	(114, '9241 St George Dr.', 7),
  -- 	(115, '213 Stonewood Drive', 18),
  -- 	(116, '2425 Notre Dame Ave', 18),
  -- 	(117, '3884 Beauty Street', 18),
  -- 	(118, '8036 Summit View Dr.', 18),
  -- 	(119, '9605 Pheasant Circle', 18),
  -- 	(120, '1245 Clay Road', 10),
  -- 	(121, '1748 Bird Drive', 10),
  -- 	(122, '310 Winter Lane', 10),
  -- 	(123, '3127 El Camino Drive', 10),
  -- 	(124, '3514 Sunshine', 10),
  -- 	(125, '1144 Paradise Ct.', 6),
  -- 	(126, '1921 Ranch Road', 6),
  -- 	(127, '3333 Madhatter Circle', 6),
  -- 	(128, '342 San Simeon', 6),
  -- 	(129, '3848 East 39th Street', 6),
  -- 	(130, '5256 Chickpea Ct.', 6),
  -- 	(131, '5979 El Pueblo', 6),
  -- 	(132, '6580 Poor Ridge Court', 6),
  -- 	(133, '7435 Ricardo', 6),
  -- 	(134, '7691 Benedict Ct.', 6),
  -- 	(135, '7772 Golden Meadow', 6),
  -- 	(136, '8585 Los Gatos Ct.', 6),
  -- 	(137, '9314 Icicle Way', 6),
  -- 	(138, '9530 Vine Lane', 6),
  -- 	(139, '989 Crown Ct', 6),
  -- 	(140, '25 95th Ave NE', 20),
  -- 	(141, '4095 Cooper Dr.', 20),
  -- 	(142, '4155 Working Drive', 20),
  -- 	(143, '463 H Stagecoach Rd.', 20),
  -- 	(144, '5050 Mt. Wilson Way', 20),
  -- 	(145, '5203 Virginia Lane', 20),
  -- 	(146, '5458 Gladstone Drive', 20),
  -- 	(147, '5553 Cash Avenue', 20),
  -- 	(148, '5669 Ironwood Way', 20),
  -- 	(149, '6697 Ridge Park Drive', 20),
  -- 	(150, '7048 Laurel', 20),
  -- 	(151, '8192 Seagull Court', 20),
  -- 	(152, '350 Pastel Drive', 22),
  -- 	(153, '34 Waterloo Road', 21),
  -- 	(154, '8291 Crossbow Way', 28),
  -- 	(155, '5678 Lakeview Blvd.', 24),
  -- 	(156, '1356 Grove Way', 12),
  -- 	(157, '158 Walnut Ave', 12),
  -- 	(158, '1792 Belmont Rd.', 12),
  -- 	(159, '2275 Valley Blvd.', 12),
  -- 	(160, '3747 W. Landing Avenue', 12),
  -- 	(161, '3841 Silver Oaks Place', 12),
  -- 	(162, '4566 La Jolla', 12),
  -- 	(163, '4734 Sycamore Court', 12),
  -- 	(164, '5030 Blue Ridge Dr.', 12),
  -- 	(165, '5734 Ashford Court', 12),
  -- 	(166, '7726 Driftwood Drive', 12),
  -- 	(167, '8310 Ridge Circle', 12),
  -- 	(168, '896 Southdale', 12),
  -- 	(169, '9652 Los Angeles', 12),
  -- 	(170, '2487 Riverside Drive', 19),
  -- 	(171, '1397 Paradise Ct.', 14),
  -- 	(172, '1400 Gate Drive', 14),
  -- 	(173, '3030 Blackburn Ct.', 14),
  -- 	(174, '4350 Minute Dr.', 14),
  -- 	(175, '8967 Hamilton Ave.', 14),
  -- 	(176, '9297 Kenston Dr.', 14),
  -- 	(177, '9687 Shakespeare Drive', 14),
  -- 	(178, '9100 Sheppard Avenue North', 29),
  -- 	(179, '636 Vine Hill Way', 25),
  -- 	(180, '101 Candy Rd.', 1),
  -- 	(181, '1275 West Street', 1),
  -- 	(182, '2137 Birchwood Dr', 1),
  -- 	(183, '2383 Pepper Drive', 1),
  -- 	(184, '2427 Notre Dame Ave.', 1),
  -- 	(185, '2482 Buckingham Dr.', 1),
  -- 	(186, '3066 Wallace Dr.', 1),
  -- 	(187, '3397 Rancho View Drive', 1),
  -- 	(188, '3768 Door Way', 1),
  -- 	(189, '4909 Poco Lane', 1),
  -- 	(190, '6369 Ellis Street', 1),
  -- 	(191, '6891 Ham Drive', 1),
  -- 	(192, '7297 RisingView', 1),
  -- 	(193, '8000 Crane Court', 1),
  -- 	(194, '8040 Hill Ct', 1),
  -- 	(195, '8467 Clifford Court', 1),
  -- 	(196, '9006 Woodside Way', 1),
  -- 	(197, '9322 Driving Drive', 1),
  -- 	(198, '9863 Ridge Place', 1),
  -- 	(199, '9882 Clay Rde', 1),
  -- 	(200, '9906 Oak Grove Road', 1),
  -- 	(201, '1378 String Dr', 13),
  -- 	(202, '1803 Olive Hill', 13),
  -- 	(203, '2176 Brown Street', 13),
  -- 	(204, '2266 Greenwood Circle', 13),
  -- 	(205, '2598 Breck Court', 13),
  -- 	(206, '2736 Scramble Rd', 13),
  -- 	(207, '4312 Cambridge Drive', 13),
  -- 	(208, '5009 Orange Street', 13),
  -- 	(209, '5670 Bel Air Dr.', 13),
  -- 	(210, '5980 Icicle Circle', 13),
  -- 	(211, '6510 Hacienda Drive', 13),
  -- 	(212, '6937 E. 42nd Street', 13),
  -- 	(213, '7165 Brock Lane', 13),
  -- 	(214, '7559 Worth Ct.', 13),
  -- 	(215, '7985 Center Street', 13),
  -- 	(216, '9495 Limewood Place', 13),
  -- 	(217, '9533 Working Drive', 13),
  -- 	(218, '177 11th Ave', 16),
  -- 	(219, '1962 Ferndale Lane', 16),
  -- 	(220, '2473 Orchard Way', 16),
  -- 	(221, '4096 San Remo', 16),
  -- 	(222, '4310 Kenston Dr.', 16),
  -- 	(223, '4444 Pepper Way', 16),
  -- 	(224, '4525 Benedict Ct.', 16),
  -- 	(225, '5263 Etcheverry Dr', 16),
  -- 	(226, '535 Greendell Pl', 16),
  -- 	(227, '6871 Thornwood Dr.', 16),
  -- 	(228, '6951 Harmony Way', 16),
  -- 	(229, '7086 O St.', 16),
  -- 	(230, '7145 Matchstick Drive', 16),
  -- 	(231, '7820 Bird Drive', 16),
  -- 	(232, '7939 Bayview Court', 16),
  -- 	(233, '8316 La Salle St.', 16),
  -- 	(234, '9104 Mt. Sequoia Ct.', 16),
  -- 	(235, '1234 Seaside Way', 9),
  -- 	(236, '5725 Glaze Drive', 9),
  -- 	(237, '1064 Slow Creek Road', 4),
  -- 	(238, '1102 Ravenwood', 4),
  -- 	(239, '1220 Bradford Way', 4),
  -- 	(240, '1349 Steven Way', 4),
  -- 	(241, '136 Balboa Court', 4),
  -- 	(242, '137 Mazatlan', 4),
  -- 	(243, '1398 Yorba Linda', 4),
  -- 	(244, '1619 Stillman Court', 4),
  -- 	(245, '2144 San Rafael', 4),
  -- 	(246, '2354 Frame Ln.', 4),
  -- 	(247, '2639 Anchor Court', 4),
  -- 	(248, '3029 Pastime Dr', 4),
  -- 	(249, '3243 Buckingham Dr.', 4),
  -- 	(250, '426 San Rafael', 4),
  -- 	(251, '4598 Manila Avenue', 4),
  -- 	(252, '4948 West 4th St', 4),
  -- 	(253, '502 Alexander Pl.', 4),
  -- 	(254, '5025 Holiday Hills', 4),
  -- 	(255, '5125 Cotton Ct.', 4),
  -- 	(256, '5375 Clearland Circle', 4),
  -- 	(257, '5376 Catanzaro Way', 4),
  -- 	(258, '5407 Cougar Way', 4),
  -- 	(259, '5666 Hazelnut Lane', 4),
  -- 	(260, '5802 Ampersand Drive', 4),
  -- 	(261, '6498 Mining Rd.', 4),
  -- 	(262, '6578 Woodhaven Ln.', 4),
  -- 	(263, '6657 Sand Pointe Lane', 4),
  -- 	(264, '6843 San Simeon Dr.', 4),
  -- 	(265, '7126 Ending Ct.', 4),
  -- 	(266, '7127 Los Gatos Court', 4),
  -- 	(267, '7166 Brock Lane', 4),
  -- 	(268, '7403 N. Broadway', 4),
  -- 	(269, '7439 Laguna Niguel', 4),
  -- 	(270, '7594 Alexander Pl.', 4),
  -- 	(271, '7616 Honey Court', 4),
  -- 	(272, '77 Birchwood', 4),
  -- 	(273, '7765 Sunsine Drive', 4),
  -- 	(274, '7842 Ygnacio Valley Road', 4),
  -- 	(275, '8290 Margaret Ct.', 4),
  -- 	(276, '8656 Lakespring Place', 4),
  -- 	(277, '874 Olivera Road', 4),
  -- 	(278, '931 Corte De Luna', 4),
  -- 	(279, '9537 Ridgewood Drive', 4),
  -- 	(280, '9964 North Ridge Drive', 4),
  -- 	(281, '1285 Greenbrier Street', 11),
  -- 	(282, '2115 Passing', 11),
  -- 	(283, '2601 Cambridge Drive', 11),
  -- 	(284, '3114 Notre Dame Ave.', 11),
  -- 	(285, '3280 Pheasant Circle', 11),
  -- 	(286, '4231 Spar Court', 11),
  -- 	(287, '4852 Chaparral Court', 11),
  -- 	(288, '5724 Victory Lane', 11),
  -- 	(289, '591 Merriewood Drive', 11),
  -- 	(290, '7230 Vine Maple Street', 11),
  -- 	(291, '163 Nishava Str, ent A, apt. 1', 32);
  -- /*!40000 ALTER TABLE `addresses` ENABLE KEYS */;
  
  
  -- CREATE TABLE IF NOT EXISTS `departments` (
  --   `department_id` int(10) NOT NULL AUTO_INCREMENT,
  --   `name` varchar(50) NOT NULL,
  --   `manager_id` int(10) NOT NULL,
  --   PRIMARY KEY (`department_id`),
  --   UNIQUE KEY `PK_Departments` (`department_id`),
  --   KEY `fk_departments_employees` (`manager_id`),
  --   CONSTRAINT `fk_departments_employees` FOREIGN KEY (`manager_id`) REFERENCES `employees` (`employee_id`)
  -- ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
  
  
  -- /*!40000 ALTER TABLE `departments` DISABLE KEYS */;
  -- INSERT INTO `departments` (`department_id`, `name`, `manager_id`) VALUES
  -- 	(1, 'Engineering', 12),
  -- 	(2, 'Tool Design', 4),
  -- 	(3, 'Sales', 273),
  -- 	(4, 'Marketing', 46),
  -- 	(5, 'Purchasing', 6),
  -- 	(6, 'Research and Development', 42),
  -- 	(7, 'Production', 148),
  -- 	(8, 'Production Control', 21),
  -- 	(9, 'Human Resources', 30),
  -- 	(10, 'Finance', 3),
  -- 	(11, 'Information Services', 42),
  -- 	(12, 'Document Control', 90),
  -- 	(13, 'Quality Assurance', 274),
  -- 	(14, 'Facilities and Maintenance', 218),
  -- 	(15, 'Shipping and Receiving', 85),
  -- 	(16, 'Executive', 109);
  -- /*!40000 ALTER TABLE `departments` ENABLE KEYS */;
  
  
  
  -- CREATE TABLE IF NOT EXISTS `employees` (
  --   `employee_id` int(10) NOT NULL AUTO_INCREMENT,
  --   `first_name` varchar(50) NOT NULL,
  --   `last_name` varchar(50) NOT NULL,
  --   `middle_name` varchar(50) DEFAULT NULL,
  --   `job_title` varchar(50) NOT NULL,
  --   `department_id` int(10) NOT NULL,
  --   `manager_id` int(10) DEFAULT NULL,
  --   `hire_date` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  --   `salary` decimal(19,4) NOT NULL,
  --   `address_id` int(10) DEFAULT NULL,
  --   PRIMARY KEY (`employee_id`),
  --   UNIQUE KEY `PK_Employees` (`employee_id`),
  --   KEY `CL_FirstName` (`first_name`),
  --   KEY `fk_employees_departments` (`department_id`),
  --   KEY `fk_employees_employees` (`manager_id`),
  --   KEY `fk_employees_addresses` (`address_id`),
  --   CONSTRAINT `fk_employees_addresses` FOREIGN KEY (`address_id`) REFERENCES `addresses` (`address_id`),
  --   CONSTRAINT `fk_employees_departments` FOREIGN KEY (`department_id`) REFERENCES `departments` (`department_id`),
  --   CONSTRAINT `fk_employees_employees` FOREIGN KEY (`manager_id`) REFERENCES `employees` (`employee_id`)
  -- ) ENGINE=InnoDB AUTO_INCREMENT=294 DEFAULT CHARSET=utf8;
  
  
  -- /*!40000 ALTER TABLE `employees` DISABLE KEYS */;
  -- INSERT INTO `employees` (`employee_id`, `first_name`, `last_name`, `middle_name`, `job_title`, `department_id`, `manager_id`, `hire_date`, `salary`, `address_id`) VALUES
  -- 	(1, 'Guy', 'Gilbert', 'R', 'Production Technician', 7, 16, '1998-07-31 00:00:00.000000', 12500.0000, 166),
  -- 	(2, 'Kevin', 'Brown', 'F', 'Marketing Assistant', 4, 6, '1999-02-26 00:00:00.000000', 13500.0000, 102),
  -- 	(3, 'Roberto', 'Tamburello', NULL, 'Engineering Manager', 1, 12, '1999-12-12 00:00:00.000000', 43300.0000, 193),
  -- 	(4, 'Rob', 'Walters', NULL, 'Senior Tool Designer', 2, 3, '2000-01-05 00:00:00.000000', 29800.0000, 155),
  -- 	(5, 'Thierry', 'D\'Hers', 'B', 'Tool Designer', 2, 263, '2000-01-11 00:00:00.000000', 25000.0000, 40),
  -- 	(6, 'David', 'Bradley', 'M', 'Marketing Manager', 5, 109, '2000-01-20 00:00:00.000000', 37500.0000, 199),
  -- 	(7, 'JoLynn', 'Dobney', 'M', 'Production Supervisor', 7, 21, '2000-01-26 00:00:00.000000', 25000.0000, 275),
  -- 	(8, 'Ruth', 'Ellerbrock', 'Ann', 'Production Technician', 7, 185, '2000-02-06 00:00:00.000000', 13500.0000, 108),
  -- 	(9, 'Gail', 'Erickson', 'A', 'Design Engineer', 1, 3, '2000-02-06 00:00:00.000000', 32700.0000, 22),
  -- 	(10, 'Barry', 'Johnson', 'K', 'Production Technician', 7, 185, '2000-02-07 00:00:00.000000', 13500.0000, 285),
  -- 	(11, 'Jossef', 'Goldberg', 'H', 'Design Engineer', 1, 3, '2000-02-24 00:00:00.000000', 32700.0000, 214),
  -- 	(12, 'Terri', 'Duffy', 'Lee', 'Vice President of Engineering', 1, 109, '2000-03-03 00:00:00.000000', 63500.0000, 209),
  -- 	(13, 'Sidney', 'Higa', 'M', 'Production Technician', 7, 185, '2000-03-05 00:00:00.000000', 13500.0000, 73),
  -- 	(14, 'Taylor', 'Maxwell', 'R', 'Production Supervisor', 7, 21, '2000-03-11 00:00:00.000000', 25000.0000, 82),
  -- 	(15, 'Jeffrey', 'Ford', 'L', 'Production Technician', 7, 185, '2000-03-23 00:00:00.000000', 13500.0000, 156),
  -- 	(16, 'Jo', 'Brown', 'A', 'Production Supervisor', 7, 21, '2000-03-30 00:00:00.000000', 25000.0000, 70),
  -- 	(17, 'Doris', 'Hartwig', 'M', 'Production Technician', 7, 185, '2000-04-11 00:00:00.000000', 13500.0000, 144),
  -- 	(18, 'John', 'Campbell', 'T', 'Production Supervisor', 7, 21, '2000-04-18 00:00:00.000000', 25000.0000, 245),
  -- 	(19, 'Diane', 'Glimp', 'R', 'Production Technician', 7, 185, '2000-04-29 00:00:00.000000', 13500.0000, 184),
  -- 	(20, 'Steven', 'Selikoff', 'T', 'Production Technician', 7, 173, '2001-01-02 00:00:00.000000', 9500.0000, 104),
  -- 	(21, 'Peter', 'Krebs', 'J', 'Production Control Manager', 8, 148, '2001-01-02 00:00:00.000000', 24500.0000, 11),
  -- 	(22, 'Stuart', 'Munson', 'V', 'Production Technician', 7, 197, '2001-01-03 00:00:00.000000', 10000.0000, 36),
  -- 	(23, 'Greg', 'Alderson', 'F', 'Production Technician', 7, 197, '2001-01-03 00:00:00.000000', 10000.0000, 18),
  -- 	(24, 'David', 'Johnson', '', 'Production Technician', 7, 184, '2001-01-03 00:00:00.000000', 9500.0000, 142),
  -- 	(25, 'Zheng', 'Mu', 'W', 'Production Supervisor', 7, 21, '2001-01-04 00:00:00.000000', 25000.0000, 278),
  -- 	(26, 'Ivo', 'Salmre', 'William', 'Production Technician', 7, 108, '2001-01-05 00:00:00.000000', 14000.0000, 165),
  -- 	(27, 'Paul', 'Komosinski', 'B', 'Production Technician', 7, 87, '2001-01-05 00:00:00.000000', 15000.0000, 32),
  -- 	(28, 'Ashvini', 'Sharma', 'R', 'Network Administrator', 11, 150, '2001-01-05 00:00:00.000000', 32500.0000, 133),
  -- 	(29, 'Kendall', 'Keil', 'C', 'Production Technician', 7, 14, '2001-01-06 00:00:00.000000', 11000.0000, 257),
  -- 	(30, 'Paula', 'Barreto de Mattos', 'M', 'Human Resources Manager', 9, 140, '2001-01-07 00:00:00.000000', 27100.0000, 2),
  -- 	(31, 'Alejandro', 'McGuel', 'E', 'Production Technician', 7, 210, '2001-01-07 00:00:00.000000', 15000.0000, 274),
  -- 	(32, 'Garrett', 'Young', 'R', 'Production Technician', 7, 184, '2001-01-08 00:00:00.000000', 9500.0000, 283),
  -- 	(33, 'Jian Shuo', 'Wang', NULL, 'Production Technician', 7, 135, '2001-01-08 00:00:00.000000', 9500.0000, 160),
  -- 	(34, 'Susan', 'Eaton', 'W', 'Stocker', 15, 85, '2001-01-08 00:00:00.000000', 9000.0000, 204),
  -- 	(35, 'Vamsi', 'Kuppa', '', 'Shipping and Receiving Clerk', 15, 85, '2001-01-08 00:00:00.000000', 9500.0000, 51),
  -- 	(36, 'Alice', 'Ciccu', 'O', 'Production Technician', 7, 38, '2001-01-08 00:00:00.000000', 11000.0000, 284),
  -- 	(37, 'Simon', 'Rapier', 'D', 'Production Technician', 7, 7, '2001-01-09 00:00:00.000000', 12500.0000, 64),
  -- 	(38, 'Jinghao', 'Liu', 'K', 'Production Supervisor', 7, 21, '2001-01-09 00:00:00.000000', 25000.0000, 55),
  -- 	(39, 'Michael', 'Hines', 'T', 'Production Technician', 7, 182, '2001-01-10 00:00:00.000000', 14000.0000, 168),
  -- 	(40, 'Yvonne', 'McKay', 'S', 'Production Technician', 7, 159, '2001-01-10 00:00:00.000000', 10000.0000, 107),
  -- 	(41, 'Peng', 'Wu', 'J', 'Quality Assurance Supervisor', 13, 200, '2001-01-10 00:00:00.000000', 21600.0000, 39),
  -- 	(42, 'Jean', 'Trenary', 'E', 'Information Services Manager', 11, 109, '2001-01-12 00:00:00.000000', 50500.0000, 194),
  -- 	(43, 'Russell', 'Hunter', NULL, 'Production Technician', 7, 74, '2001-01-13 00:00:00.000000', 11000.0000, 258),
  -- 	(44, 'A. Scott', 'Wright', NULL, 'Master Scheduler', 8, 148, '2001-01-13 00:00:00.000000', 23600.0000, 172),
  -- 	(45, 'Fred', 'Northup', 'T', 'Production Technician', 7, 210, '2001-01-13 00:00:00.000000', 15000.0000, 282),
  -- 	(46, 'Sariya', 'Harnpadoungsataya', 'E', 'Marketing Specialist', 4, 6, '2001-01-13 00:00:00.000000', 14400.0000, 106),
  -- 	(47, 'Willis', 'Johnson', 'T', 'Recruiter', 9, 30, '2001-01-14 00:00:00.000000', 18300.0000, 99),
  -- 	(48, 'Jun', 'Cao', 'T', 'Production Technician', 7, 38, '2001-01-15 00:00:00.000000', 11000.0000, 197),
  -- 	(49, 'Christian', 'Kleinerman', 'E', 'Maintenance Supervisor', 14, 218, '2001-01-15 00:00:00.000000', 20400.0000, 118),
  -- 	(50, 'Susan', 'Metters', 'A', 'Production Technician', 7, 184, '2001-01-15 00:00:00.000000', 9500.0000, 224),
  -- 	(51, 'Reuben', 'D\'sa', 'H', 'Production Supervisor', 7, 21, '2001-01-16 00:00:00.000000', 25000.0000, 249),
  -- 	(52, 'Kirk', 'Koenigsbauer', 'J', 'Production Technician', 7, 123, '2001-01-16 00:00:00.000000', 10000.0000, 250),
  -- 	(53, 'David', 'Ortiz', 'J', 'Production Technician', 7, 18, '2001-01-16 00:00:00.000000', 12500.0000, 267),
  -- 	(54, 'Tengiz', 'Kharatishvili', '', 'Control Specialist', 12, 90, '2001-01-17 00:00:00.000000', 16800.0000, 129),
  -- 	(55, 'Hanying', 'Feng', 'P', 'Production Technician', 7, 143, '2001-01-17 00:00:00.000000', 14000.0000, 182),
  -- 	(56, 'Kevin', 'Liu', 'H', 'Production Technician', 7, 210, '2001-01-18 00:00:00.000000', 15000.0000, 259),
  -- 	(57, 'Annik', 'Stahl', 'O', 'Production Technician', 7, 16, '2001-01-18 00:00:00.000000', 12500.0000, 262),
  -- 	(58, 'Suroor', 'Fatima', 'R', 'Production Technician', 7, 38, '2001-01-18 00:00:00.000000', 11000.0000, 86),
  -- 	(59, 'Deborah', 'Poe', 'E', 'Accounts Receivable Specialist', 10, 139, '2001-01-19 00:00:00.000000', 19000.0000, 103),
  -- 	(60, 'Jim', 'Scardelis', 'H', 'Production Technician', 7, 74, '2001-01-20 00:00:00.000000', 11000.0000, 88),
  -- 	(61, 'Carole', 'Poland', 'M', 'Production Technician', 7, 173, '2001-01-20 00:00:00.000000', 9500.0000, 72),
  -- 	(62, 'George', 'Li', 'Z', 'Production Technician', 7, 184, '2001-01-22 00:00:00.000000', 9500.0000, 58),
  -- 	(63, 'Gary', 'Yukish', 'W', 'Production Technician', 7, 87, '2001-01-23 00:00:00.000000', 15000.0000, 80),
  -- 	(64, 'Cristian', 'Petculescu', 'K', 'Production Supervisor', 7, 21, '2001-01-23 00:00:00.000000', 25000.0000, 276),
  -- 	(65, 'Raymond', 'Sam', 'K', 'Production Technician', 7, 143, '2001-01-24 00:00:00.000000', 14000.0000, 75),
  -- 	(66, 'Janaina', 'Bueno', 'Barreiro Gambaro', 'Application Specialist', 11, 42, '2001-01-24 00:00:00.000000', 27400.0000, 131),
  -- 	(67, 'Bob', 'Hohman', '', 'Production Technician', 7, 14, '2001-01-25 00:00:00.000000', 11000.0000, 44),
  -- 	(68, 'Shammi', 'Mohamed', 'G', 'Production Technician', 7, 210, '2001-01-25 00:00:00.000000', 15000.0000, 4),
  -- 	(69, 'Linda', 'Moschell', 'K', 'Production Technician', 7, 38, '2001-01-26 00:00:00.000000', 11000.0000, 5),
  -- 	(70, 'Mindy', 'Martin', 'C', 'Benefits Specialist', 9, 30, '2001-01-26 00:00:00.000000', 16600.0000, 171),
  -- 	(71, 'Wendy', 'Kahn', 'Beth', 'Finance Manager', 10, 140, '2001-01-26 00:00:00.000000', 43300.0000, 232),
  -- 	(72, 'Kim', 'Ralls', 'T', 'Stocker', 15, 85, '2001-01-27 00:00:00.000000', 9000.0000, 42),
  -- 	(73, 'Sandra', 'Reategui Alayo', NULL, 'Production Technician', 7, 135, '2001-01-27 00:00:00.000000', 9500.0000, 255),
  -- 	(74, 'Kok-Ho', 'Loh', 'T', 'Production Supervisor', 7, 21, '2001-01-28 00:00:00.000000', 25000.0000, 10),
  -- 	(75, 'Douglas', 'Hite', 'B', 'Production Technician', 7, 159, '2001-01-28 00:00:00.000000', 10000.0000, 57),
  -- 	(76, 'James', 'Kramer', 'D', 'Production Technician', 7, 7, '2001-01-28 00:00:00.000000', 12500.0000, 162),
  -- 	(77, 'Sean', 'Alexander', 'P', 'Quality Assurance Technician', 13, 41, '2001-01-29 00:00:00.000000', 10600.0000, 210),
  -- 	(78, 'Nitin', 'Mirchandani', 'S', 'Production Technician', 7, 182, '2001-01-29 00:00:00.000000', 14000.0000, 231),
  -- 	(79, 'Diane', 'Margheim', 'L', 'Research and Development Engineer', 6, 158, '2001-01-30 00:00:00.000000', 40900.0000, 111),
  -- 	(80, 'Rebecca', 'Laszlo', 'A', 'Production Technician', 7, 16, '2001-01-30 00:00:00.000000', 12500.0000, 6),
  -- 	(81, 'Rajesh', 'Patel', 'M', 'Production Technician', 7, 210, '2001-02-01 00:00:00.000000', 15000.0000, 81),
  -- 	(82, 'Vidur', 'Luthra', 'X', 'Recruiter', 9, 30, '2001-02-02 00:00:00.000000', 18300.0000, 176),
  -- 	(83, 'John', 'Evans', 'P', 'Production Technician', 7, 38, '2001-02-02 00:00:00.000000', 11000.0000, 253),
  -- 	(84, 'Nancy', 'Anderson', 'A', 'Production Technician', 7, 7, '2001-02-03 00:00:00.000000', 12500.0000, 227),
  -- 	(85, 'Pilar', 'Ackerman', 'G', 'Shipping and Receiving Supervisor', 15, 21, '2001-02-03 00:00:00.000000', 19200.0000, 269),
  -- 	(86, 'David', 'Yalovsky', 'A', 'Production Technician', 7, 184, '2001-02-03 00:00:00.000000', 9500.0000, 241),
  -- 	(87, 'David', 'Hamilton', 'P', 'Production Supervisor', 7, 21, '2001-02-04 00:00:00.000000', 25000.0000, 150),
  -- 	(88, 'Laura', 'Steele', 'C', 'Production Technician', 7, 123, '2001-02-04 00:00:00.000000', 10000.0000, 62),
  -- 	(89, 'Margie', 'Shoop', 'W', 'Production Technician', 7, 16, '2001-02-05 00:00:00.000000', 12500.0000, 92),
  -- 	(90, 'Zainal', 'Arifin', 'T', 'Document Control Manager', 12, 200, '2001-02-05 00:00:00.000000', 17800.0000, 128),
  -- 	(91, 'Lorraine', 'Nay', 'O', 'Production Technician', 7, 210, '2001-02-05 00:00:00.000000', 15000.0000, 94),
  -- 	(92, 'Fadi', 'Fakhouri', 'K', 'Production Technician', 7, 143, '2001-02-05 00:00:00.000000', 14000.0000, 281),
  -- 	(93, 'Ryan', 'Cornelsen', 'L', 'Production Technician', 7, 51, '2001-02-06 00:00:00.000000', 15000.0000, 228),
  -- 	(94, 'Candy', 'Spoon', 'L', 'Accounts Receivable Specialist', 10, 139, '2001-02-07 00:00:00.000000', 19000.0000, 122),
  -- 	(95, 'Nuan', 'Yu', NULL, 'Production Technician', 7, 74, '2001-02-07 00:00:00.000000', 11000.0000, 12),
  -- 	(96, 'William', 'Vong', 'S', 'Scheduling Assistant', 8, 44, '2001-02-08 00:00:00.000000', 16000.0000, 35),
  -- 	(97, 'Bjorn', 'Rettig', 'M', 'Production Technician', 7, 173, '2001-02-08 00:00:00.000000', 9500.0000, 268),
  -- 	(98, 'Scott', 'Gode', 'R', 'Production Technician', 7, 197, '2001-02-09 00:00:00.000000', 10000.0000, 256),
  -- 	(99, 'Michael', 'Rothkugel', 'L', 'Production Technician', 7, 87, '2001-02-11 00:00:00.000000', 15000.0000, 93),
  -- 	(100, 'Lane', 'Sacksteder', 'M', 'Production Technician', 7, 143, '2001-02-12 00:00:00.000000', 14000.0000, 239),
  -- 	(101, 'Pete', 'Male', 'C', 'Production Technician', 7, 14, '2001-02-12 00:00:00.000000', 11000.0000, 273),
  -- 	(102, 'Dan', 'Bacon', 'K', 'Application Specialist', 11, 42, '2001-02-12 00:00:00.000000', 27400.0000, 126),
  -- 	(103, 'David', 'Barber', 'M', 'Assistant to the Chief Financial Officer', 10, 140, '2001-02-13 00:00:00.000000', 13500.0000, 173),
  -- 	(104, 'Lolan', 'Song', 'B', 'Production Technician', 7, 74, '2001-02-13 00:00:00.000000', 11000.0000, 77),
  -- 	(105, 'Paula', 'Nartker', 'R', 'Production Technician', 7, 210, '2001-02-13 00:00:00.000000', 15000.0000, 247),
  -- 	(106, 'Mary', 'Gibson', 'E', 'Marketing Specialist', 4, 6, '2001-02-13 00:00:00.000000', 14400.0000, 110),
  -- 	(107, 'Mindaugas', 'Krapauskas', 'J', 'Production Technician', 7, 38, '2001-02-14 00:00:00.000000', 11000.0000, 74),
  -- 	(108, 'Eric', 'Gubbels', NULL, 'Production Supervisor', 7, 21, '2001-02-15 00:00:00.000000', 25000.0000, 85),
  -- 	(109, 'Ken', 'Sanchez', 'J', 'Chief Executive Officer', 16, NULL, '2001-02-15 00:00:00.000000', 125500.0000, 177),
  -- 	(110, 'Jason', 'Watters', 'M', 'Production Technician', 7, 135, '2001-02-15 00:00:00.000000', 9500.0000, 21),
  -- 	(111, 'Mark', 'Harrington', 'L', 'Quality Assurance Technician', 13, 41, '2001-02-16 00:00:00.000000', 10600.0000, 139),
  -- 	(112, 'Janeth', 'Esteves', 'M', 'Production Technician', 7, 159, '2001-02-16 00:00:00.000000', 10000.0000, 163),
  -- 	(113, 'Marc', 'Ingle', 'J', 'Production Technician', 7, 184, '2001-02-17 00:00:00.000000', 9500.0000, 230),
  -- 	(114, 'Gigi', 'Matthew', '', 'Research and Development Engineer', 6, 158, '2001-02-17 00:00:00.000000', 40900.0000, 23),
  -- 	(115, 'Paul', 'Singh', 'R', 'Production Technician', 7, 108, '2001-02-18 00:00:00.000000', 14000.0000, 16),
  -- 	(116, 'Frank', 'Lee', 'T', 'Production Technician', 7, 210, '2001-02-18 00:00:00.000000', 15000.0000, 263),
  -- 	(117, 'Francois', 'Ajenstat', 'P', 'Database Administrator', 11, 42, '2001-02-18 00:00:00.000000', 38500.0000, 127),
  -- 	(118, 'Diane', 'Tibbott', 'H', 'Production Technician', 7, 14, '2001-02-19 00:00:00.000000', 11000.0000, 140),
  -- 	(119, 'Jill', 'Williams', 'A', 'Marketing Specialist', 4, 6, '2001-02-19 00:00:00.000000', 14400.0000, 114),
  -- 	(120, 'Angela', 'Barbariol', 'W', 'Production Technician', 7, 38, '2001-02-21 00:00:00.000000', 11000.0000, 91),
  -- 	(121, 'Matthias', 'Berndt', 'T', 'Shipping and Receiving Clerk', 15, 85, '2001-02-21 00:00:00.000000', 9500.0000, 201),
  -- 	(122, 'Bryan', 'Baker', NULL, 'Production Technician', 7, 7, '2001-02-22 00:00:00.000000', 12500.0000, 166),
  -- 	(123, 'Jeff', 'Hay', 'V', 'Production Supervisor', 7, 21, '2001-02-22 00:00:00.000000', 25000.0000, 113),
  -- 	(124, 'Eugene', 'Zabokritski', 'R', 'Production Technician', 7, 184, '2001-02-22 00:00:00.000000', 9500.0000, 226),
  -- 	(125, 'Barbara', 'Decker', 'S', 'Production Technician', 7, 182, '2001-02-23 00:00:00.000000', 14000.0000, 219),
  -- 	(126, 'Chris', 'Preston', 'T', 'Production Technician', 7, 123, '2001-02-23 00:00:00.000000', 10000.0000, 279),
  -- 	(127, 'Sean', 'Chai', '', 'Document Control Assistant', 12, 90, '2001-02-23 00:00:00.000000', 10300.0000, 138),
  -- 	(128, 'Dan', 'Wilson', 'B', 'Database Administrator', 11, 42, '2001-02-23 00:00:00.000000', 38500.0000, 30),
  -- 	(129, 'Mark', 'McArthur', 'K', 'Production Technician', 7, 16, '2001-02-24 00:00:00.000000', 12500.0000, 186),
  -- 	(130, 'Bryan', 'Walton', 'A', 'Accounts Receivable Specialist', 10, 139, '2001-02-25 00:00:00.000000', 19000.0000, 175),
  -- 	(131, 'Houman', 'Pournasseh', '', 'Production Technician', 7, 74, '2001-02-26 00:00:00.000000', 11000.0000, 185),
  -- 	(132, 'Sairaj', 'Uddin', 'L', 'Scheduling Assistant', 8, 44, '2001-02-27 00:00:00.000000', 16000.0000, 190),
  -- 	(133, 'Michiko', 'Osada', 'F', 'Production Technician', 7, 173, '2001-02-27 00:00:00.000000', 9500.0000, 229),
  -- 	(134, 'Benjamin', 'Martin', 'R', 'Production Technician', 7, 184, '2001-02-28 00:00:00.000000', 9500.0000, 286),
  -- 	(135, 'Cynthia', 'Randall', 'S', 'Production Supervisor', 7, 21, '2001-02-28 00:00:00.000000', 25000.0000, 147),
  -- 	(136, 'Kathie', 'Flood', 'E', 'Production Technician', 7, 197, '2001-02-28 00:00:00.000000', 10000.0000, 100),
  -- 	(137, 'Britta', 'Simon', 'L', 'Production Technician', 7, 16, '2001-03-02 00:00:00.000000', 12500.0000, 95),
  -- 	(138, 'Brian', 'Lloyd', 'T', 'Production Technician', 7, 210, '2001-03-02 00:00:00.000000', 15000.0000, 288),
  -- 	(139, 'David', 'Liu', 'J', 'Accounts Manager', 10, 140, '2001-03-03 00:00:00.000000', 34700.0000, 119),
  -- 	(140, 'Laura', 'Norman', 'F', 'Chief Financial Officer', 16, 109, '2001-03-04 00:00:00.000000', 60100.0000, 215),
  -- 	(141, 'Michael', 'Patten', 'W', 'Production Technician', 7, 38, '2001-03-04 00:00:00.000000', 11000.0000, 96),
  -- 	(142, 'Andy', 'Ruth', 'M', 'Production Technician', 7, 135, '2001-03-04 00:00:00.000000', 9500.0000, 1),
  -- 	(143, 'Yuhong', 'Li', 'L', 'Production Supervisor', 7, 21, '2001-03-05 00:00:00.000000', 25000.0000, 242),
  -- 	(144, 'Robert', 'Rounthwaite', 'J', 'Production Technician', 7, 159, '2001-03-06 00:00:00.000000', 10000.0000, 280),
  -- 	(145, 'Andreas', 'Berglund', 'T', 'Quality Assurance Technician', 13, 41, '2001-03-06 00:00:00.000000', 10600.0000, 208),
  -- 	(146, 'Reed', 'Koch', 'T', 'Production Technician', 7, 184, '2001-03-06 00:00:00.000000', 9500.0000, 191),
  -- 	(147, 'Linda', 'Randall', 'A', 'Production Technician', 7, 143, '2001-03-07 00:00:00.000000', 14000.0000, 260),
  -- 	(148, 'James', 'Hamilton', 'R', 'Vice President of Production', 7, 109, '2001-03-07 00:00:00.000000', 84100.0000, 158),
  -- 	(149, 'Ramesh', 'Meyyappan', 'V', 'Application Specialist', 11, 42, '2001-03-07 00:00:00.000000', 27400.0000, 130),
  -- 	(150, 'Stephanie', 'Conroy', 'A', 'Network Manager', 11, 42, '2001-03-08 00:00:00.000000', 39700.0000, 136),
  -- 	(151, 'Samantha', 'Smith', 'H', 'Production Technician', 7, 108, '2001-03-08 00:00:00.000000', 14000.0000, 14),
  -- 	(152, 'Tawana', 'Nusbaum', 'G', 'Production Technician', 7, 210, '2001-03-09 00:00:00.000000', 15000.0000, 237),
  -- 	(153, 'Denise', 'Smith', 'H', 'Production Technician', 7, 14, '2001-03-09 00:00:00.000000', 11000.0000, 143),
  -- 	(154, 'Hao', 'Chen', 'O', 'Human Resources Administrative Assistant', 9, 30, '2001-03-10 00:00:00.000000', 13900.0000, 135),
  -- 	(155, 'Alex', 'Nayberg', 'M', 'Production Technician', 7, 123, '2001-03-12 00:00:00.000000', 10000.0000, 174),
  -- 	(156, 'Eugene', 'Kogan', 'O', 'Production Technician', 7, 7, '2001-03-12 00:00:00.000000', 12500.0000, 71),
  -- 	(157, 'Brandon', 'Heidepriem', 'G', 'Production Technician', 7, 16, '2001-03-12 00:00:00.000000', 12500.0000, 189),
  -- 	(158, 'Dylan', 'Miller', 'A', 'Research and Development Manager', 6, 3, '2001-03-12 00:00:00.000000', 50500.0000, 141),
  -- 	(159, 'Shane', 'Kim', 'S', 'Production Supervisor', 7, 21, '2001-03-12 00:00:00.000000', 25000.0000, 20),
  -- 	(160, 'John', 'Chen', 'Y', 'Production Technician', 7, 182, '2001-03-13 00:00:00.000000', 14000.0000, 65),
  -- 	(161, 'Karen', 'Berge', 'R', 'Document Control Assistant', 12, 90, '2001-03-13 00:00:00.000000', 10300.0000, 123),
  -- 	(162, 'Jose', 'Lugo', 'R', 'Production Technician', 7, 16, '2001-03-14 00:00:00.000000', 12500.0000, 271),
  -- 	(163, 'Mandar', 'Samant', 'H', 'Production Technician', 7, 74, '2001-03-14 00:00:00.000000', 11000.0000, 63),
  -- 	(164, 'Mikael', 'Sandberg', 'Q', 'Buyer', 5, 274, '2001-03-14 00:00:00.000000', 18300.0000, 50),
  -- 	(165, 'Sameer', 'Tejani', 'A', 'Production Technician', 7, 74, '2001-03-15 00:00:00.000000', 11000.0000, 66),
  -- 	(166, 'Dragan', 'Tomic', 'K', 'Accounts Payable Specialist', 10, 139, '2001-03-15 00:00:00.000000', 19000.0000, 115),
  -- 	(167, 'Carol', 'Philips', 'M', 'Production Technician', 7, 173, '2001-03-16 00:00:00.000000', 9500.0000, 45),
  -- 	(168, 'Rob', 'Caron', 'T', 'Production Technician', 7, 87, '2001-03-17 00:00:00.000000', 15000.0000, 161),
  -- 	(169, 'Don', 'Hall', 'L', 'Production Technician', 7, 38, '2001-03-17 00:00:00.000000', 11000.0000, 59),
  -- 	(170, 'Alan', 'Brewer', 'J', 'Scheduling Assistant', 8, 44, '2001-03-17 00:00:00.000000', 16000.0000, 151),
  -- 	(171, 'David', 'Lawrence', 'Oliver', 'Production Technician', 7, 184, '2001-03-18 00:00:00.000000', 9500.0000, 167),
  -- 	(172, 'Baris', 'Cetinok', 'F', 'Production Technician', 7, 87, '2001-03-19 00:00:00.000000', 15000.0000, 244),
  -- 	(173, 'Michael', 'Ray', 'Sean', 'Production Supervisor', 7, 21, '2001-03-19 00:00:00.000000', 25000.0000, 277),
  -- 	(174, 'Steve', 'Masters', 'F', 'Production Technician', 7, 18, '2001-03-19 00:00:00.000000', 12500.0000, 252),
  -- 	(175, 'Suchitra', 'Mohan', 'O', 'Production Technician', 7, 16, '2001-03-20 00:00:00.000000', 12500.0000, 31),
  -- 	(176, 'Karen', 'Berg', 'A', 'Application Specialist', 11, 42, '2001-03-20 00:00:00.000000', 27400.0000, 132),
  -- 	(177, 'Terrence', 'Earls', 'W', 'Production Technician', 7, 143, '2001-03-20 00:00:00.000000', 14000.0000, 34),
  -- 	(178, 'Barbara', 'Moreland', 'C', 'Accountant', 10, 139, '2001-03-22 00:00:00.000000', 26400.0000, 254),
  -- 	(179, 'Chad', 'Niswonger', 'W', 'Production Technician', 7, 38, '2001-03-22 00:00:00.000000', 11000.0000, 46),
  -- 	(180, 'Rostislav', 'Shabalin', 'E', 'Production Technician', 7, 135, '2001-03-23 00:00:00.000000', 9500.0000, 9),
  -- 	(181, 'Belinda', 'Newman', 'M', 'Production Technician', 7, 197, '2001-03-24 00:00:00.000000', 10000.0000, 43),
  -- 	(182, 'Katie', 'McAskill-White', 'L', 'Production Supervisor', 7, 21, '2001-03-24 00:00:00.000000', 25000.0000, 240),
  -- 	(183, 'Russell', 'King', 'M', 'Production Technician', 7, 184, '2001-03-25 00:00:00.000000', 9500.0000, 3),
  -- 	(184, 'Jack', 'Richins', 'S', 'Production Supervisor', 7, 21, '2001-03-25 00:00:00.000000', 25000.0000, 169),
  -- 	(185, 'Andrew', 'Hill', 'R', 'Production Supervisor', 7, 21, '2001-03-26 00:00:00.000000', 25000.0000, 97),
  -- 	(186, 'Nicole', 'Holliday', 'B', 'Production Technician', 7, 87, '2001-03-26 00:00:00.000000', 15000.0000, 238),
  -- 	(187, 'Frank', 'Miller', 'T', 'Production Technician', 7, 14, '2001-03-27 00:00:00.000000', 11000.0000, 289),
  -- 	(188, 'Peter', 'Connelly', 'I', 'Network Administrator', 11, 150, '2001-03-27 00:00:00.000000', 32500.0000, 137),
  -- 	(189, 'Anibal', 'Sousa', 'T', 'Production Technician', 7, 108, '2001-03-27 00:00:00.000000', 14000.0000, 183),
  -- 	(190, 'Ken', 'Myer', 'L', 'Production Technician', 7, 210, '2001-03-28 00:00:00.000000', 15000.0000, 105),
  -- 	(191, 'Grant', 'Culbertson', '', 'Human Resources Administrative Assistant', 9, 30, '2001-03-29 00:00:00.000000', 13900.0000, 117),
  -- 	(192, 'Michael', 'Entin', 'T', 'Production Technician', 7, 38, '2001-03-29 00:00:00.000000', 11000.0000, 195),
  -- 	(193, 'Lionel', 'Penuchot', 'C', 'Production Technician', 7, 159, '2001-03-30 00:00:00.000000', 10000.0000, 261),
  -- 	(194, 'Thomas', 'Michaels', 'R', 'Production Technician', 7, 7, '2001-03-30 00:00:00.000000', 12500.0000, 78),
  -- 	(195, 'Jimmy', 'Bischoff', 'T', 'Stocker', 15, 85, '2001-03-30 00:00:00.000000', 9000.0000, 206),
  -- 	(196, 'Michael', 'Vanderhyde', 'T', 'Production Technician', 7, 135, '2001-03-30 00:00:00.000000', 9500.0000, 90),
  -- 	(197, 'Lori', 'Kane', 'A', 'Production Supervisor', 7, 21, '2001-03-30 00:00:00.000000', 25000.0000, 198),
  -- 	(198, 'Arvind', 'Rao', 'B', 'Buyer', 5, 274, '2001-04-01 00:00:00.000000', 18300.0000, 212),
  -- 	(199, 'Stefen', 'Hesse', 'A', 'Production Technician', 7, 182, '2001-04-01 00:00:00.000000', 14000.0000, 68),
  -- 	(200, 'Hazem', 'Abolrous', 'E', 'Quality Assurance Manager', 13, 148, '2001-04-01 00:00:00.000000', 28800.0000, 148),
  -- 	(201, 'Janet', 'Sheperdigian', 'L', 'Accounts Payable Specialist', 10, 139, '2001-04-02 00:00:00.000000', 19000.0000, 218),
  -- 	(202, 'Elizabeth', 'Keyser', 'I', 'Production Technician', 7, 74, '2001-04-03 00:00:00.000000', 11000.0000, 152),
  -- 	(203, 'Terry', 'Eminhizer', 'J', 'Marketing Specialist', 4, 6, '2001-04-03 00:00:00.000000', 14400.0000, 19),
  -- 	(204, 'John', 'Frum', '', 'Production Technician', 7, 184, '2001-04-04 00:00:00.000000', 9500.0000, 112),
  -- 	(205, 'Merav', 'Netz', 'A', 'Production Technician', 7, 173, '2001-04-04 00:00:00.000000', 9500.0000, 270),
  -- 	(206, 'Brian', 'LaMee', 'P', 'Scheduling Assistant', 8, 44, '2001-04-04 00:00:00.000000', 16000.0000, 109),
  -- 	(207, 'Kitti', 'Lertpiriyasuwat', 'H', 'Production Technician', 7, 38, '2001-04-05 00:00:00.000000', 11000.0000, 272),
  -- 	(208, 'Jay', 'Adams', 'G', 'Production Technician', 7, 18, '2001-04-06 00:00:00.000000', 12500.0000, 157),
  -- 	(209, 'Jan', 'Miksovsky', 'S', 'Production Technician', 7, 184, '2001-04-06 00:00:00.000000', 9500.0000, 101),
  -- 	(210, 'Brenda', 'Diaz', 'M', 'Production Supervisor', 7, 21, '2001-04-06 00:00:00.000000', 25000.0000, 251),
  -- 	(211, 'Andrew', 'Cencini', 'M', 'Production Technician', 7, 123, '2001-04-07 00:00:00.000000', 10000.0000, 233),
  -- 	(212, 'Chris', 'Norred', 'K', 'Control Specialist', 12, 90, '2001-04-07 00:00:00.000000', 16800.0000, 125),
  -- 	(213, 'Chris', 'Okelberry', 'O', 'Production Technician', 7, 16, '2001-04-08 00:00:00.000000', 12500.0000, 188),
  -- 	(214, 'Shelley', 'Dyck', '', 'Production Technician', 7, 143, '2001-04-08 00:00:00.000000', 14000.0000, 164),
  -- 	(215, 'Gabe', 'Mares', 'B', 'Production Technician', 7, 210, '2001-04-09 00:00:00.000000', 15000.0000, 87),
  -- 	(216, 'Mike', 'Seamans', 'K', 'Accountant', 10, 139, '2001-04-09 00:00:00.000000', 26400.0000, 120),
  -- 	(217, 'Michael', 'Raheem', NULL, 'Research and Development Manager', 6, 158, '2001-06-04 00:00:00.000000', 42500.0000, 236),
  -- 	(218, 'Gary', 'Altman', 'E.', 'Facilities Manager', 14, 148, '2002-01-03 00:00:00.000000', 24000.0000, 203),
  -- 	(219, 'Charles', 'Fitzgerald', 'B', 'Production Technician', 7, 18, '2002-01-04 00:00:00.000000', 12500.0000, 223),
  -- 	(220, 'Ebru', 'Ersan', '', 'Production Technician', 7, 25, '2002-01-07 00:00:00.000000', 13500.0000, 225),
  -- 	(221, 'Sylvester', 'Valdez', 'A', 'Production Technician', 7, 108, '2002-01-12 00:00:00.000000', 14000.0000, 25),
  -- 	(222, 'Brian', 'Goldstein', 'Richard', 'Production Technician', 7, 51, '2002-01-12 00:00:00.000000', 15000.0000, 48),
  -- 	(223, 'Linda', 'Meisner', 'P', 'Buyer', 5, 274, '2002-01-18 00:00:00.000000', 18300.0000, 28),
  -- 	(224, 'Betsy', 'Stadick', 'A', 'Production Technician', 7, 64, '2002-01-19 00:00:00.000000', 13500.0000, 47),
  -- 	(225, 'Magnus', 'Hedlund', 'E', 'Facilities Administrative Assistant', 14, 218, '2002-01-22 00:00:00.000000', 9800.0000, 211),
  -- 	(226, 'Karan', 'Khanna', 'R', 'Production Technician', 7, 18, '2002-01-23 00:00:00.000000', 12500.0000, 248),
  -- 	(227, 'Mary', 'Baker', 'R', 'Production Technician', 7, 25, '2002-01-26 00:00:00.000000', 13500.0000, 246),
  -- 	(228, 'Kevin', 'Homer', 'M', 'Production Technician', 7, 25, '2002-01-26 00:00:00.000000', 13500.0000, 29),
  -- 	(229, 'Mihail', 'Frintu', 'U', 'Production Technician', 7, 51, '2002-01-30 00:00:00.000000', 15000.0000, 89),
  -- 	(230, 'Bonnie', 'Kearney', '', 'Production Technician', 7, 185, '2002-02-02 00:00:00.000000', 13500.0000, 287),
  -- 	(231, 'Fukiko', 'Ogisu', 'J', 'Buyer', 5, 274, '2002-02-05 00:00:00.000000', 18300.0000, 17),
  -- 	(232, 'Hung-Fu', 'Ting', 'T', 'Production Technician', 7, 108, '2002-02-07 00:00:00.000000', 14000.0000, 220),
  -- 	(233, 'Gordon', 'Hee', 'L', 'Buyer', 5, 274, '2002-02-12 00:00:00.000000', 18300.0000, 15),
  -- 	(234, 'Kimberly', 'Zimmerman', 'B', 'Production Technician', 7, 64, '2002-02-13 00:00:00.000000', 13500.0000, 266),
  -- 	(235, 'Kim', 'Abercrombie', 'B', 'Production Technician', 7, 16, '2002-02-17 00:00:00.000000', 12500.0000, 56),
  -- 	(236, 'Sandeep', 'Kaliyath', 'P', 'Production Technician', 7, 51, '2002-02-18 00:00:00.000000', 15000.0000, 234),
  -- 	(237, 'Prasanna', 'Samarawickrama', 'E', 'Production Technician', 7, 108, '2002-02-23 00:00:00.000000', 14000.0000, 187),
  -- 	(238, 'Frank', 'Pellow', 'S', 'Buyer', 5, 274, '2002-02-24 00:00:00.000000', 18300.0000, 213),
  -- 	(239, 'Min', 'Su', 'G', 'Production Technician', 7, 108, '2002-02-25 00:00:00.000000', 14000.0000, 24),
  -- 	(240, 'Eric', 'Brown', 'L', 'Production Technician', 7, 51, '2002-02-25 00:00:00.000000', 15000.0000, 67),
  -- 	(241, 'Eric', 'Kurjan', 'S', 'Buyer', 5, 274, '2002-02-28 00:00:00.000000', 18300.0000, 207),
  -- 	(242, 'Pat', 'Coleman', 'H', 'Janitor', 14, 49, '2002-02-28 00:00:00.000000', 9300.0000, 116),
  -- 	(243, 'Maciej', 'Dusza', 'W', 'Production Technician', 7, 18, '2002-03-01 00:00:00.000000', 12500.0000, 83),
  -- 	(244, 'Erin', 'Hagens', 'M', 'Buyer', 5, 274, '2002-03-03 00:00:00.000000', 18300.0000, 8),
  -- 	(245, 'Patrick', 'Wedge', 'C', 'Production Technician', 7, 64, '2002-03-04 00:00:00.000000', 13500.0000, 7),
  -- 	(246, 'Frank', 'Martinez', 'R', 'Production Technician', 7, 51, '2002-03-08 00:00:00.000000', 15000.0000, 290),
  -- 	(247, 'Ed', 'Dudenhoefer', 'R', 'Production Technician', 7, 16, '2002-03-08 00:00:00.000000', 12500.0000, 243),
  -- 	(248, 'Christopher', 'Hill', 'E', 'Production Technician', 7, 25, '2002-03-11 00:00:00.000000', 13500.0000, 41),
  -- 	(249, 'Patrick', 'Cook', 'M', 'Production Technician', 7, 51, '2002-03-15 00:00:00.000000', 15000.0000, 264),
  -- 	(250, 'Krishna', 'Sunkammurali', NULL, 'Production Technician', 7, 108, '2002-03-16 00:00:00.000000', 14000.0000, 79),
  -- 	(251, 'Lori', 'Penor', 'K', 'Janitor', 14, 49, '2002-03-19 00:00:00.000000', 9300.0000, 124),
  -- 	(252, 'Danielle', 'Tiedt', 'C', 'Production Technician', 7, 64, '2002-03-23 00:00:00.000000', 13500.0000, 146),
  -- 	(253, 'Sootha', 'Charncherngkha', 'T', 'Quality Assurance Technician', 13, 41, '2002-03-26 00:00:00.000000', 10600.0000, 149),
  -- 	(254, 'Michael', 'Zwilling', 'J', 'Production Technician', 7, 18, '2002-03-26 00:00:00.000000', 12500.0000, 76),
  -- 	(255, 'Randy', 'Reeves', 'T', 'Production Technician', 7, 18, '2002-03-26 00:00:00.000000', 12500.0000, 84),
  -- 	(256, 'John', 'Kane', 'T', 'Production Technician', 7, 25, '2002-03-30 00:00:00.000000', 13500.0000, 69),
  -- 	(257, 'Jack', 'Creasey', 'T', 'Production Technician', 7, 51, '2002-04-03 00:00:00.000000', 15000.0000, 265),
  -- 	(258, 'Olinda', 'Turner', 'C', 'Production Technician', 7, 108, '2002-04-04 00:00:00.000000', 14000.0000, 33),
  -- 	(259, 'Stuart', 'Macrae', 'J', 'Janitor', 14, 49, '2002-04-05 00:00:00.000000', 9300.0000, 205),
  -- 	(260, 'Jo', 'Berry', 'L', 'Janitor', 14, 49, '2002-04-07 00:00:00.000000', 9300.0000, 121),
  -- 	(261, 'Ben', 'Miller', 'T', 'Buyer', 5, 274, '2002-04-09 00:00:00.000000', 18300.0000, 192),
  -- 	(262, 'Tom', 'Vande Velde', 'M', 'Production Technician', 7, 64, '2002-04-10 00:00:00.000000', 13500.0000, 98),
  -- 	(263, 'Ovidiu', 'Cracium', 'V', 'Senior Tool Designer', 2, 3, '2003-01-05 00:00:00.000000', 28800.0000, 145),
  -- 	(264, 'Annette', 'Hill', 'L', 'Purchasing Assistant', 5, 274, '2003-01-06 00:00:00.000000', 12800.0000, 181),
  -- 	(265, 'Janice', 'Galvin', 'M', 'Tool Designer', 2, 263, '2003-01-23 00:00:00.000000', 25000.0000, 200),
  -- 	(266, 'Reinout', 'Hillmann', '', 'Purchasing Assistant', 5, 274, '2003-01-25 00:00:00.000000', 12800.0000, 27),
  -- 	(267, 'Michael', 'Sullivan', 'I', 'Senior Design Engineer', 1, 3, '2003-01-30 00:00:00.000000', 36100.0000, 217),
  -- 	(268, 'Stephen', 'Jiang', 'Y', 'North American Sales Manager', 3, 273, '2003-02-04 00:00:00.000000', 48100.0000, 196),
  -- 	(269, 'Wanida', 'Benshoof', 'M', 'Marketing Assistant', 4, 6, '2003-02-07 00:00:00.000000', 13500.0000, 221),
  -- 	(270, 'Sharon', 'Salavaria', 'B', 'Design Engineer', 1, 3, '2003-02-18 00:00:00.000000', 32700.0000, 216),
  -- 	(271, 'John', 'Wood', 'L', 'Marketing Specialist', 4, 6, '2003-03-10 00:00:00.000000', 14400.0000, 180),
  -- 	(272, 'Mary', 'Dempsey', 'A', 'Marketing Assistant', 4, 6, '2003-03-17 00:00:00.000000', 13500.0000, 26),
  -- 	(273, 'Brian', 'Welcker', 'S', 'Vice President of Sales', 3, 109, '2003-03-18 00:00:00.000000', 72100.0000, 134),
  -- 	(274, 'Sheela', 'Word', 'H', 'Purchasing Manager', 13, 71, '2003-03-28 00:00:00.000000', 30000.0000, 222),
  -- 	(275, 'Michael', 'Blythe', 'G', 'Sales Representative', 3, 268, '2003-07-01 00:00:00.000000', 23100.0000, 60),
  -- 	(276, 'Linda', 'Mitchell', 'C', 'Sales Representative', 3, 268, '2003-07-01 00:00:00.000000', 23100.0000, 170),
  -- 	(277, 'Jillian', 'Carson', NULL, 'Sales Representative', 3, 268, '2003-07-01 00:00:00.000000', 23100.0000, 61),
  -- 	(278, 'Garrett', 'Vargas', 'R', 'Sales Representative', 3, 268, '2003-07-01 00:00:00.000000', 23100.0000, 52),
  -- 	(279, 'Tsvi', 'Reiter', 'Michael', 'Sales Representative', 3, 268, '2003-07-01 00:00:00.000000', 23100.0000, 154),
  -- 	(280, 'Pamela', 'Ansman-Wolfe', 'O', 'Sales Representative', 3, 268, '2003-07-01 00:00:00.000000', 23100.0000, 179),
  -- 	(281, 'Shu', 'Ito', 'K', 'Sales Representative', 3, 268, '2003-07-01 00:00:00.000000', 23100.0000, 235),
  -- 	(282, 'Jose', 'Saraiva', 'Edvaldo', 'Sales Representative', 3, 268, '2003-07-01 00:00:00.000000', 23100.0000, 178),
  -- 	(283, 'David', 'Campbell', 'R', 'Sales Representative', 3, 268, '2003-07-01 00:00:00.000000', 23100.0000, 13),
  -- 	(284, 'Amy', 'Alberts', 'E', 'European Sales Manager', 3, 273, '2004-05-18 00:00:00.000000', 48100.0000, 202),
  -- 	(285, 'Jae', 'Pak', 'B', 'Sales Representative', 3, 284, '2004-07-01 00:00:00.000000', 23100.0000, 54),
  -- 	(286, 'Ranjit', 'Varkey Chudukatil', 'R', 'Sales Representative', 3, 284, '2004-07-01 00:00:00.000000', 23100.0000, 38),
  -- 	(287, 'Tete', 'Mensa-Annan', 'A', 'Sales Representative', 3, 268, '2004-11-01 00:00:00.000000', 23100.0000, 53),
  -- 	(288, 'Syed', 'Abbas', 'E', 'Pacific Sales Manager', 3, 273, '2005-04-15 00:00:00.000000', 48100.0000, 49),
  -- 	(289, 'Rachel', 'Valdez', 'B', 'Sales Representative', 3, 284, '2005-07-01 00:00:00.000000', 23100.0000, 37),
  -- 	(290, 'Lynn', 'Tsoflias', '', 'Sales Representative', 3, 288, '2005-07-01 00:00:00.000000', 23100.0000, 153),
  -- 	(291, 'Svetlin', 'Nakov', 'Ivanov', 'Independent Software Development  Consultant', 6, NULL, '2005-03-01 00:00:00.000000', 48000.0000, 291),
  -- 	(292, 'Martin', 'Kulov', NULL, 'Independent .NET Consultant', 6, NULL, '2005-03-01 00:00:00.000000', 48000.0000, 291),
  -- 	(293, 'George', 'Denchev', NULL, 'Independent Java Consultant', 6, NULL, '2005-03-01 00:00:00.000000', 48000.0000, 291);
  -- /*!40000 ALTER TABLE `employees` ENABLE KEYS */;
  
  
  
  -- CREATE TABLE IF NOT EXISTS `employees_projects` (
  --   `employee_id` int(10) NOT NULL,
  --   `project_id` int(10) NOT NULL,
  --   PRIMARY KEY (`employee_id`,`project_id`),
  --   UNIQUE KEY `PK_EmployeesProjects` (`employee_id`,`project_id`),
  --   KEY `fk_employees_projects_projects` (`project_id`),
  --   CONSTRAINT `fk_employees_projects_employees` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`employee_id`),
  --   CONSTRAINT `fk_employees_projects_projects` FOREIGN KEY (`project_id`) REFERENCES `projects` (`project_id`)
  -- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  -- /*!40000 ALTER TABLE `employees_projects` DISABLE KEYS */;
  -- INSERT INTO `employees_projects` (`employee_id`, `project_id`) VALUES
  -- 	(3, 1),
  -- 	(15, 1),
  -- 	(18, 1),
  -- 	(36, 1),
  -- 	(66, 1),
  -- 	(68, 1),
  -- 	(81, 1),
  -- 	(112, 1),
  -- 	(162, 1),
  -- 	(182, 1),
  -- 	(235, 1),
  -- 	(246, 1),
  -- 	(8, 2),
  -- 	(37, 2),
  -- 	(38, 2),
  -- 	(69, 2),
  -- 	(88, 2),
  -- 	(102, 2),
  -- 	(113, 2),
  -- 	(163, 2),
  -- 	(197, 2),
  -- 	(10, 3),
  -- 	(39, 3),
  -- 	(51, 3),
  -- 	(89, 3),
  -- 	(115, 3),
  -- 	(149, 3),
  -- 	(167, 3),
  -- 	(200, 3),
  -- 	(210, 3),
  -- 	(218, 3),
  -- 	(237, 3),
  -- 	(248, 3),
  -- 	(1, 4),
  -- 	(40, 4),
  -- 	(41, 4),
  -- 	(64, 4),
  -- 	(83, 4),
  -- 	(116, 4),
  -- 	(168, 4),
  -- 	(176, 4),
  -- 	(191, 4),
  -- 	(211, 4),
  -- 	(226, 4),
  -- 	(249, 4),
  -- 	(26, 5),
  -- 	(45, 5),
  -- 	(65, 5),
  -- 	(84, 5),
  -- 	(103, 5),
  -- 	(123, 5),
  -- 	(145, 5),
  -- 	(154, 5),
  -- 	(169, 5),
  -- 	(29, 7),
  -- 	(42, 7),
  -- 	(50, 7),
  -- 	(53, 7),
  -- 	(54, 7),
  -- 	(77, 7),
  -- 	(92, 7),
  -- 	(135, 7),
  -- 	(152, 7),
  -- 	(221, 7),
  -- 	(229, 7),
  -- 	(255, 7),
  -- 	(22, 8),
  -- 	(49, 8),
  -- 	(55, 8),
  -- 	(60, 8),
  -- 	(93, 8),
  -- 	(108, 8),
  -- 	(153, 8),
  -- 	(212, 8),
  -- 	(222, 8),
  -- 	(230, 8),
  -- 	(253, 8),
  -- 	(256, 8),
  -- 	(9, 9),
  -- 	(23, 9),
  -- 	(44, 9),
  -- 	(56, 9),
  -- 	(61, 9),
  -- 	(79, 9),
  -- 	(86, 9),
  -- 	(87, 9),
  -- 	(155, 9),
  -- 	(213, 9),
  -- 	(11, 10),
  -- 	(21, 10),
  -- 	(24, 10),
  -- 	(57, 10),
  -- 	(62, 10),
  -- 	(74, 10),
  -- 	(110, 10),
  -- 	(114, 10),
  -- 	(156, 10),
  -- 	(214, 10),
  -- 	(224, 10),
  -- 	(258, 10),
  -- 	(25, 11),
  -- 	(31, 11),
  -- 	(58, 11),
  -- 	(63, 11),
  -- 	(75, 11),
  -- 	(107, 11),
  -- 	(157, 11),
  -- 	(159, 11),
  -- 	(215, 11),
  -- 	(7, 12),
  -- 	(19, 12),
  -- 	(32, 12),
  -- 	(48, 12),
  -- 	(76, 12),
  -- 	(95, 12),
  -- 	(158, 12),
  -- 	(161, 12),
  -- 	(173, 12),
  -- 	(202, 12),
  -- 	(239, 12),
  -- 	(252, 12),
  -- 	(14, 19),
  -- 	(20, 19),
  -- 	(33, 19),
  -- 	(73, 19),
  -- 	(78, 19),
  -- 	(104, 19),
  -- 	(127, 19),
  -- 	(170, 19),
  -- 	(184, 19),
  -- 	(207, 19),
  -- 	(13, 20),
  -- 	(16, 20),
  -- 	(17, 20),
  -- 	(67, 20),
  -- 	(80, 20),
  -- 	(90, 20),
  -- 	(105, 20),
  -- 	(185, 20),
  -- 	(206, 20),
  -- 	(208, 20),
  -- 	(234, 20),
  -- 	(245, 20),
  -- 	(3, 21),
  -- 	(15, 21),
  -- 	(18, 21),
  -- 	(36, 21),
  -- 	(68, 21),
  -- 	(81, 21),
  -- 	(97, 21),
  -- 	(132, 21),
  -- 	(182, 21),
  -- 	(209, 21),
  -- 	(235, 21),
  -- 	(246, 21),
  -- 	(8, 22),
  -- 	(37, 22),
  -- 	(38, 22),
  -- 	(69, 22),
  -- 	(88, 22),
  -- 	(96, 22),
  -- 	(98, 22),
  -- 	(196, 22),
  -- 	(197, 22),
  -- 	(225, 22),
  -- 	(236, 22),
  -- 	(247, 22),
  -- 	(10, 23),
  -- 	(39, 23),
  -- 	(51, 23),
  -- 	(89, 23),
  -- 	(99, 23),
  -- 	(199, 23),
  -- 	(200, 23),
  -- 	(210, 23),
  -- 	(218, 23),
  -- 	(237, 23),
  -- 	(248, 23),
  -- 	(1, 24),
  -- 	(40, 24),
  -- 	(41, 24),
  -- 	(64, 24),
  -- 	(83, 24),
  -- 	(100, 24),
  -- 	(191, 24),
  -- 	(204, 24),
  -- 	(211, 24),
  -- 	(226, 24),
  -- 	(249, 24),
  -- 	(263, 24),
  -- 	(4, 25),
  -- 	(26, 25),
  -- 	(45, 25),
  -- 	(84, 25),
  -- 	(101, 25),
  -- 	(123, 25),
  -- 	(145, 25),
  -- 	(154, 25),
  -- 	(205, 25),
  -- 	(27, 26),
  -- 	(30, 26),
  -- 	(43, 26),
  -- 	(91, 26),
  -- 	(111, 26),
  -- 	(136, 26),
  -- 	(143, 26),
  -- 	(183, 26),
  -- 	(220, 26),
  -- 	(228, 26),
  -- 	(254, 26),
  -- 	(5, 27),
  -- 	(29, 27),
  -- 	(42, 27),
  -- 	(50, 27),
  -- 	(77, 27),
  -- 	(92, 27),
  -- 	(135, 27),
  -- 	(137, 27),
  -- 	(189, 27),
  -- 	(221, 27),
  -- 	(229, 27),
  -- 	(255, 27),
  -- 	(12, 28),
  -- 	(22, 28),
  -- 	(49, 28),
  -- 	(55, 28),
  -- 	(93, 28),
  -- 	(108, 28),
  -- 	(138, 28),
  -- 	(190, 28),
  -- 	(23, 29),
  -- 	(44, 29),
  -- 	(56, 29),
  -- 	(79, 29),
  -- 	(86, 29),
  -- 	(87, 29),
  -- 	(131, 29),
  -- 	(148, 29),
  -- 	(192, 29),
  -- 	(213, 29),
  -- 	(232, 29),
  -- 	(257, 29),
  -- 	(21, 30),
  -- 	(24, 30),
  -- 	(57, 30),
  -- 	(74, 30),
  -- 	(110, 30),
  -- 	(114, 30),
  -- 	(133, 30),
  -- 	(193, 30),
  -- 	(214, 30),
  -- 	(25, 31),
  -- 	(31, 31),
  -- 	(58, 31),
  -- 	(75, 31),
  -- 	(107, 31),
  -- 	(134, 31),
  -- 	(159, 31),
  -- 	(194, 31),
  -- 	(215, 31),
  -- 	(217, 31),
  -- 	(243, 31),
  -- 	(7, 32),
  -- 	(19, 32),
  -- 	(32, 32),
  -- 	(76, 32),
  -- 	(95, 32),
  -- 	(144, 32),
  -- 	(158, 32),
  -- 	(173, 32),
  -- 	(186, 32),
  -- 	(202, 32),
  -- 	(239, 32),
  -- 	(14, 33),
  -- 	(20, 33),
  -- 	(33, 33),
  -- 	(78, 33),
  -- 	(104, 33),
  -- 	(146, 33),
  -- 	(170, 33),
  -- 	(184, 33),
  -- 	(187, 33),
  -- 	(207, 33),
  -- 	(13, 34),
  -- 	(16, 34),
  -- 	(17, 34),
  -- 	(80, 34),
  -- 	(105, 34),
  -- 	(147, 34),
  -- 	(179, 34),
  -- 	(185, 34),
  -- 	(206, 34),
  -- 	(208, 34),
  -- 	(234, 34),
  -- 	(15, 35),
  -- 	(18, 35),
  -- 	(36, 35),
  -- 	(81, 35),
  -- 	(97, 35),
  -- 	(132, 35),
  -- 	(141, 35),
  -- 	(180, 35),
  -- 	(182, 35),
  -- 	(209, 35),
  -- 	(235, 35),
  -- 	(8, 36),
  -- 	(37, 36),
  -- 	(38, 36),
  -- 	(88, 36),
  -- 	(96, 36),
  -- 	(98, 36),
  -- 	(142, 36),
  -- 	(181, 36),
  -- 	(196, 36),
  -- 	(197, 36),
  -- 	(236, 36),
  -- 	(10, 37),
  -- 	(51, 37),
  -- 	(89, 37),
  -- 	(99, 37),
  -- 	(124, 37),
  -- 	(174, 37),
  -- 	(199, 37),
  -- 	(200, 37),
  -- 	(210, 37),
  -- 	(237, 37),
  -- 	(267, 37),
  -- 	(1, 38),
  -- 	(41, 38),
  -- 	(64, 38),
  -- 	(83, 38),
  -- 	(100, 38),
  -- 	(125, 38),
  -- 	(175, 38),
  -- 	(204, 38),
  -- 	(211, 38),
  -- 	(226, 38),
  -- 	(4, 39),
  -- 	(26, 39),
  -- 	(84, 39),
  -- 	(101, 39),
  -- 	(123, 39),
  -- 	(126, 39),
  -- 	(145, 39),
  -- 	(177, 39),
  -- 	(205, 39),
  -- 	(27, 40),
  -- 	(91, 40),
  -- 	(111, 40),
  -- 	(122, 40),
  -- 	(136, 40),
  -- 	(143, 40),
  -- 	(165, 40),
  -- 	(183, 40),
  -- 	(220, 40),
  -- 	(228, 40),
  -- 	(5, 41),
  -- 	(29, 41),
  -- 	(77, 41),
  -- 	(92, 41),
  -- 	(129, 41),
  -- 	(135, 41),
  -- 	(137, 41),
  -- 	(171, 41),
  -- 	(189, 41),
  -- 	(221, 41),
  -- 	(229, 41),
  -- 	(12, 42),
  -- 	(22, 42),
  -- 	(93, 42),
  -- 	(108, 42),
  -- 	(120, 42),
  -- 	(138, 42),
  -- 	(172, 42),
  -- 	(190, 42),
  -- 	(222, 42),
  -- 	(230, 42),
  -- 	(253, 42),
  -- 	(23, 43),
  -- 	(79, 43),
  -- 	(86, 43),
  -- 	(87, 43),
  -- 	(118, 43),
  -- 	(131, 43),
  -- 	(148, 43),
  -- 	(160, 43),
  -- 	(192, 43),
  -- 	(213, 43),
  -- 	(232, 43),
  -- 	(24, 44),
  -- 	(66, 44),
  -- 	(74, 44),
  -- 	(110, 44),
  -- 	(112, 44),
  -- 	(114, 44),
  -- 	(133, 44),
  -- 	(162, 44),
  -- 	(193, 44),
  -- 	(214, 44),
  -- 	(224, 44),
  -- 	(31, 45),
  -- 	(75, 45),
  -- 	(102, 45),
  -- 	(107, 45),
  -- 	(113, 45),
  -- 	(134, 45),
  -- 	(159, 45),
  -- 	(163, 45),
  -- 	(194, 45),
  -- 	(215, 45),
  -- 	(217, 45),
  -- 	(32, 46),
  -- 	(76, 46),
  -- 	(95, 46),
  -- 	(115, 46),
  -- 	(144, 46),
  -- 	(149, 46),
  -- 	(158, 46),
  -- 	(167, 46),
  -- 	(173, 46),
  -- 	(186, 46),
  -- 	(202, 46),
  -- 	(33, 47),
  -- 	(78, 47),
  -- 	(104, 47),
  -- 	(116, 47),
  -- 	(146, 47),
  -- 	(168, 47),
  -- 	(170, 47),
  -- 	(176, 47),
  -- 	(184, 47),
  -- 	(187, 47),
  -- 	(207, 47),
  -- 	(13, 48),
  -- 	(65, 48),
  -- 	(80, 48),
  -- 	(103, 48),
  -- 	(105, 48),
  -- 	(147, 48),
  -- 	(169, 48),
  -- 	(179, 48),
  -- 	(185, 48),
  -- 	(206, 48),
  -- 	(208, 48),
  -- 	(36, 49),
  -- 	(52, 49),
  -- 	(70, 49),
  -- 	(81, 49),
  -- 	(97, 49),
  -- 	(132, 49),
  -- 	(141, 49),
  -- 	(151, 49),
  -- 	(180, 49),
  -- 	(182, 49),
  -- 	(209, 49),
  -- 	(37, 50),
  -- 	(53, 50),
  -- 	(54, 50),
  -- 	(88, 50),
  -- 	(96, 50),
  -- 	(98, 50),
  -- 	(142, 50),
  -- 	(152, 50),
  -- 	(181, 50),
  -- 	(196, 50),
  -- 	(197, 50),
  -- 	(60, 51),
  -- 	(89, 51),
  -- 	(99, 51),
  -- 	(124, 51),
  -- 	(153, 51),
  -- 	(174, 51),
  -- 	(199, 51),
  -- 	(200, 51),
  -- 	(210, 51),
  -- 	(212, 51),
  -- 	(9, 52),
  -- 	(41, 52),
  -- 	(61, 52),
  -- 	(83, 52),
  -- 	(100, 52),
  -- 	(125, 52),
  -- 	(155, 52),
  -- 	(175, 52),
  -- 	(204, 52),
  -- 	(211, 52),
  -- 	(4, 53),
  -- 	(11, 53),
  -- 	(62, 53),
  -- 	(84, 53),
  -- 	(101, 53),
  -- 	(126, 53),
  -- 	(145, 53),
  -- 	(156, 53),
  -- 	(177, 53),
  -- 	(205, 53),
  -- 	(219, 53),
  -- 	(63, 54),
  -- 	(91, 54),
  -- 	(111, 54),
  -- 	(122, 54),
  -- 	(136, 54),
  -- 	(157, 54),
  -- 	(165, 54),
  -- 	(183, 54),
  -- 	(220, 54),
  -- 	(5, 55),
  -- 	(48, 55),
  -- 	(77, 55),
  -- 	(92, 55),
  -- 	(129, 55),
  -- 	(137, 55),
  -- 	(161, 55),
  -- 	(171, 55),
  -- 	(189, 55),
  -- 	(221, 55),
  -- 	(252, 55),
  -- 	(12, 56),
  -- 	(73, 56),
  -- 	(93, 56),
  -- 	(120, 56),
  -- 	(127, 56),
  -- 	(138, 56),
  -- 	(172, 56),
  -- 	(190, 56),
  -- 	(222, 56),
  -- 	(253, 56),
  -- 	(262, 56),
  -- 	(67, 57),
  -- 	(79, 57),
  -- 	(86, 57),
  -- 	(90, 57),
  -- 	(118, 57),
  -- 	(131, 57),
  -- 	(148, 57),
  -- 	(160, 57),
  -- 	(192, 57),
  -- 	(213, 57),
  -- 	(245, 57),
  -- 	(3, 58),
  -- 	(66, 58),
  -- 	(68, 58),
  -- 	(110, 58),
  -- 	(112, 58),
  -- 	(114, 58),
  -- 	(133, 58),
  -- 	(162, 58),
  -- 	(193, 58),
  -- 	(214, 58),
  -- 	(246, 58),
  -- 	(69, 59),
  -- 	(102, 59),
  -- 	(107, 59),
  -- 	(113, 59),
  -- 	(134, 59),
  -- 	(163, 59),
  -- 	(194, 59),
  -- 	(215, 59),
  -- 	(217, 59),
  -- 	(225, 59),
  -- 	(247, 59),
  -- 	(39, 60),
  -- 	(95, 60),
  -- 	(115, 60),
  -- 	(144, 60),
  -- 	(149, 60),
  -- 	(158, 60),
  -- 	(167, 60),
  -- 	(186, 60),
  -- 	(202, 60),
  -- 	(218, 60),
  -- 	(248, 60),
  -- 	(40, 61),
  -- 	(104, 61),
  -- 	(116, 61),
  -- 	(146, 61),
  -- 	(168, 61),
  -- 	(170, 61),
  -- 	(176, 61),
  -- 	(187, 61),
  -- 	(191, 61),
  -- 	(207, 61),
  -- 	(249, 61),
  -- 	(45, 77),
  -- 	(65, 77),
  -- 	(103, 77),
  -- 	(105, 77),
  -- 	(147, 77),
  -- 	(154, 77),
  -- 	(169, 77),
  -- 	(179, 77),
  -- 	(206, 77),
  -- 	(208, 77),
  -- 	(250, 77),
  -- 	(30, 78),
  -- 	(43, 78),
  -- 	(52, 78),
  -- 	(70, 78),
  -- 	(97, 78),
  -- 	(132, 78),
  -- 	(141, 78),
  -- 	(151, 78),
  -- 	(180, 78),
  -- 	(209, 78),
  -- 	(254, 78),
  -- 	(42, 79),
  -- 	(50, 79),
  -- 	(53, 79),
  -- 	(54, 79),
  -- 	(96, 79),
  -- 	(98, 79),
  -- 	(142, 79),
  -- 	(152, 79),
  -- 	(181, 79),
  -- 	(196, 79),
  -- 	(255, 79),
  -- 	(49, 80),
  -- 	(55, 80),
  -- 	(60, 80),
  -- 	(99, 80),
  -- 	(124, 80),
  -- 	(153, 80),
  -- 	(174, 80),
  -- 	(199, 80),
  -- 	(212, 80),
  -- 	(256, 80),
  -- 	(267, 80),
  -- 	(9, 104),
  -- 	(44, 104),
  -- 	(56, 104),
  -- 	(61, 104),
  -- 	(100, 104),
  -- 	(125, 104),
  -- 	(155, 104),
  -- 	(175, 104),
  -- 	(204, 104),
  -- 	(257, 104),
  -- 	(4, 105),
  -- 	(11, 105),
  -- 	(21, 105),
  -- 	(57, 105),
  -- 	(62, 105),
  -- 	(101, 105),
  -- 	(126, 105),
  -- 	(156, 105),
  -- 	(177, 105),
  -- 	(205, 105),
  -- 	(258, 105),
  -- 	(25, 106),
  -- 	(58, 106),
  -- 	(63, 106),
  -- 	(122, 106),
  -- 	(136, 106),
  -- 	(157, 106),
  -- 	(165, 106),
  -- 	(183, 106),
  -- 	(243, 106),
  -- 	(5, 107),
  -- 	(7, 107),
  -- 	(19, 107),
  -- 	(48, 107),
  -- 	(129, 107),
  -- 	(137, 107),
  -- 	(161, 107),
  -- 	(171, 107),
  -- 	(189, 107),
  -- 	(239, 107),
  -- 	(252, 107),
  -- 	(12, 108),
  -- 	(14, 108),
  -- 	(20, 108),
  -- 	(73, 108),
  -- 	(120, 108),
  -- 	(127, 108),
  -- 	(138, 108),
  -- 	(172, 108),
  -- 	(190, 108),
  -- 	(240, 108),
  -- 	(262, 108),
  -- 	(16, 109),
  -- 	(17, 109),
  -- 	(67, 109),
  -- 	(90, 109),
  -- 	(118, 109),
  -- 	(131, 109),
  -- 	(148, 109),
  -- 	(160, 109),
  -- 	(192, 109),
  -- 	(234, 109),
  -- 	(245, 109),
  -- 	(3, 110),
  -- 	(15, 110),
  -- 	(18, 110),
  -- 	(66, 110),
  -- 	(68, 110),
  -- 	(112, 110),
  -- 	(133, 110),
  -- 	(162, 110),
  -- 	(193, 110),
  -- 	(235, 110),
  -- 	(246, 110),
  -- 	(8, 111),
  -- 	(38, 111),
  -- 	(69, 111),
  -- 	(102, 111),
  -- 	(113, 111),
  -- 	(134, 111),
  -- 	(163, 111),
  -- 	(194, 111),
  -- 	(225, 111),
  -- 	(236, 111),
  -- 	(247, 111),
  -- 	(10, 112),
  -- 	(39, 112),
  -- 	(51, 112),
  -- 	(115, 112),
  -- 	(144, 112),
  -- 	(149, 112),
  -- 	(167, 112),
  -- 	(186, 112),
  -- 	(218, 112),
  -- 	(237, 112),
  -- 	(248, 112),
  -- 	(1, 113),
  -- 	(40, 113),
  -- 	(64, 113),
  -- 	(116, 113),
  -- 	(146, 113),
  -- 	(168, 113),
  -- 	(176, 113),
  -- 	(187, 113),
  -- 	(191, 113),
  -- 	(226, 113),
  -- 	(249, 113),
  -- 	(26, 114),
  -- 	(45, 114),
  -- 	(65, 114),
  -- 	(103, 114),
  -- 	(123, 114),
  -- 	(147, 114),
  -- 	(154, 114),
  -- 	(169, 114),
  -- 	(179, 114),
  -- 	(227, 114),
  -- 	(250, 114),
  -- 	(27, 115),
  -- 	(30, 115),
  -- 	(43, 115),
  -- 	(52, 115),
  -- 	(70, 115),
  -- 	(141, 115),
  -- 	(143, 115),
  -- 	(151, 115),
  -- 	(180, 115),
  -- 	(228, 115),
  -- 	(254, 115),
  -- 	(29, 116),
  -- 	(42, 116),
  -- 	(50, 116),
  -- 	(53, 116),
  -- 	(54, 116),
  -- 	(135, 116),
  -- 	(142, 116),
  -- 	(152, 116),
  -- 	(181, 116),
  -- 	(229, 116),
  -- 	(255, 116),
  -- 	(22, 117),
  -- 	(49, 117),
  -- 	(55, 117),
  -- 	(60, 117),
  -- 	(108, 117),
  -- 	(124, 117),
  -- 	(153, 117),
  -- 	(174, 117),
  -- 	(212, 117),
  -- 	(230, 117),
  -- 	(256, 117),
  -- 	(9, 118),
  -- 	(23, 118),
  -- 	(44, 118),
  -- 	(56, 118),
  -- 	(61, 118),
  -- 	(87, 118),
  -- 	(125, 118),
  -- 	(155, 118),
  -- 	(175, 118),
  -- 	(232, 118),
  -- 	(257, 118),
  -- 	(11, 119),
  -- 	(21, 119),
  -- 	(24, 119),
  -- 	(57, 119),
  -- 	(62, 119),
  -- 	(74, 119),
  -- 	(126, 119),
  -- 	(156, 119),
  -- 	(177, 119),
  -- 	(224, 119),
  -- 	(258, 119),
  -- 	(25, 120),
  -- 	(31, 120),
  -- 	(58, 120),
  -- 	(63, 120),
  -- 	(75, 120),
  -- 	(122, 120),
  -- 	(157, 120),
  -- 	(159, 120),
  -- 	(165, 120),
  -- 	(243, 120),
  -- 	(7, 121),
  -- 	(19, 121),
  -- 	(32, 121),
  -- 	(48, 121),
  -- 	(76, 121),
  -- 	(129, 121),
  -- 	(161, 121),
  -- 	(171, 121),
  -- 	(173, 121),
  -- 	(239, 121),
  -- 	(252, 121),
  -- 	(14, 122),
  -- 	(20, 122),
  -- 	(33, 122),
  -- 	(73, 122),
  -- 	(78, 122),
  -- 	(120, 122),
  -- 	(127, 122),
  -- 	(172, 122),
  -- 	(184, 122),
  -- 	(240, 122),
  -- 	(262, 122),
  -- 	(13, 127),
  -- 	(16, 127),
  -- 	(17, 127),
  -- 	(67, 127),
  -- 	(80, 127),
  -- 	(90, 127),
  -- 	(118, 127),
  -- 	(160, 127),
  -- 	(185, 127),
  -- 	(234, 127),
  -- 	(245, 127);
  -- /*!40000 ALTER TABLE `employees_projects` ENABLE KEYS */;
  
  
  
  -- CREATE TABLE IF NOT EXISTS `projects` (
  --   `project_id` int(10) NOT NULL AUTO_INCREMENT,
  --   `name` varchar(50) NOT NULL,
  --   `description` text,
  --   `start_date` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  --   `end_date` timestamp(6) NULL DEFAULT NULL,
  --   PRIMARY KEY (`project_id`),
  --   UNIQUE KEY `PK_Projects` (`project_id`)
  -- ) ENGINE=InnoDB AUTO_INCREMENT=128 DEFAULT CHARSET=utf8;
  
  
  -- /*!40000 ALTER TABLE `projects` DISABLE KEYS */;
  -- INSERT INTO `projects` (`project_id`, `name`, `description`, `start_date`, `end_date`) VALUES
  -- 	(1, 'Classic Vest', 'Research, design and development of Classic Vest. Light-weight, wind-resistant, packs to fit into a pocket.', '2003-06-01 00:00:00.000000', NULL),
  -- 	(2, 'Cycling Cap', 'Research, design and development of Cycling Cap. Traditional style with a flip-up brim; one-size fits all.', '2001-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(3, 'Full-Finger Gloves', 'Research, design and development of Full-Finger Gloves. Synthetic palm, flexible knuckles, breathable mesh upper. Worn by the AWC team riders.', '2002-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(4, 'Half-Finger Gloves', 'Research, design and development of Half-Finger Gloves. Full padding, improved finger flex, durable palm, adjustable closure.', '2002-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(5, 'HL Mountain Frame', 'Research, design and development of HL Mountain Frame. Each frame is hand-crafted in our Bothell facility to the optimum diameter and wall-thickness required of a premium mountain frame. The heat-treated welded aluminum frame has a larger diameter tube that absorbs the bumps.', '2001-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(6, 'HL Road Frame', 'Research, design and development of HL Road Frame. Our lightest and best quality aluminum frame made from the newest alloy; it is welded and heat-treated for strength. Our innovative design results in maximum comfort and performance.', '1998-05-02 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(7, 'HL Touring Frame', 'Research, design and development of HL Touring Frame. The HL aluminum frame is custom-shaped for both good looks and strength; it will withstand the most rigorous challenges of daily riding. Men\'s version.', '2005-05-16 16:34:00.000000', NULL),
  -- 	(8, 'LL Mountain Frame', 'Research, design and development of LL Mountain Frame. Our best value utilizing the same, ground-breaking frame technology as the ML aluminum frame.', '2002-11-20 09:57:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(9, 'LL Road Frame', 'Research, design and development of LL Road Frame. The LL Frame provides a safe comfortable ride, while offering superior bump absorption in a value-priced aluminum frame.', '2001-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(10, 'LL Touring Frame', 'Research, design and development of LL Touring Frame. Lightweight butted aluminum frame provides a more upright riding position for a trip around town.  Our ground-breaking design provides optimum comfort.', '2005-05-16 16:34:00.000000', NULL),
  -- 	(11, 'Long-Sleeve Logo Jersey', 'Research, design and development of Long-Sleeve Logo Jersey. Unisex long-sleeve AWC logo microfiber cycling jersey', '2001-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(12, 'Men\'s Bib-Shorts', 'Research, design and development of Men\'s Bib-Shorts. Designed for the AWC team with stay-put straps, moisture-control, chamois padding, and leg grippers.', '2002-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(19, 'Mountain-100', 'Research, design and development of Mountain-100. Top-of-the-line competition mountain bike. Performance-enhancing options include the innovative HL Frame, super-smooth front suspension, and traction for all terrain.', '2001-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(20, 'Mountain-200', 'Research, design and development of Mountain-200. Serious back-country riding. Perfect for all levels of competition. Uses the same HL Frame as the Mountain-100.', '2002-06-01 00:00:00.000000', '2004-03-11 10:32:00.000000'),
  -- 	(21, 'Mountain-300', 'Research, design and development of Mountain-300. For true trail addicts.  An extremely durable bike that will go anywhere and keep you in control on challenging terrain - without breaking your budget.', '2002-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(22, 'Mountain-400-W', 'Research, design and development of Mountain-400-W. This bike delivers a high-level of performance on a budget. It is responsive and maneuverable, and offers peace-of-mind when you decide to go off-road.', '2006-02-22 00:00:00.000000', NULL),
  -- 	(23, 'Mountain-500', 'Research, design and development of Mountain-500. Suitable for any type of riding, on or off-road. Fits any budget. Smooth-shifting with a comfortable ride.', '2002-11-20 09:57:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(24, 'Racing Socks', 'Research, design and development of Racing Socks. Thin, lightweight and durable with cuffs that stay up.', '2005-11-22 00:00:00.000000', NULL),
  -- 	(25, 'Road-150', 'Research, design and development of Road-150. This bike is ridden by race winners. Developed with the Adventure Works Cycles professional race team, it has a extremely light heat-treated aluminum frame, and steering that allows precision control.', '2001-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(26, 'Road-250', 'Research, design and development of Road-250. Alluminum-alloy frame provides a light, stiff ride, whether you are racing in the velodrome or on a demanding club ride on country roads.', '2002-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(27, 'Road-350-W', 'Research, design and development of Road-350-W. Cross-train, race, or just socialize on a sleek, aerodynamic bike designed for a woman.  Advanced seat technology provides comfort all day.', '2003-06-01 00:00:00.000000', NULL),
  -- 	(28, 'Road-450', 'Research, design and development of Road-450. A true multi-sport bike that offers streamlined riding and a revolutionary design. Aerodynamic design lets you ride with the pros, and the gearing will conquer hilly roads.', '2001-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(29, 'Road-550-W', 'Research, design and development of Road-550-W. Same technology as all of our Road series bikes, but the frame is sized for a woman.  Perfect all-around bike for road or racing.', '2002-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(30, 'Road-650', 'Research, design and development of Road-650. Value-priced bike with many features of our top-of-the-line models. Has the same light, stiff frame, and the quick acceleration we\'re famous for.', '2001-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(31, 'Road-750', 'Research, design and development of Road-750. Entry level adult bike; offers a comfortable ride cross-country or down the block. Quick-release hubs and rims.', '2002-11-20 09:57:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(32, 'Short-Sleeve Classic Jersey', 'Research, design and development of Short-Sleeve Classic Jersey. Short sleeve classic breathable jersey with superior moisture control, front zipper, and 3 back pockets.', '2003-06-01 00:00:00.000000', NULL),
  -- 	(33, 'Sport-100', 'Research, design and development of Sport-100. Universal fit, well-vented, lightweight , snap-on visor.', '2001-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(34, 'Touring-1000', 'Research, design and development of Touring-1000. Travel in style and comfort. Designed for maximum comfort and safety. Wide gear range takes on all hills. High-tech aluminum alloy construction provides durability without added weight.', '2002-11-20 09:57:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(35, 'Touring-2000', 'Research, design and development of Touring-2000. The plush custom saddle keeps you riding all day,  and there\'s plenty of space to add panniers and bike bags to the newly-redesigned carrier.  This bike has stability when fully-loaded.', '2002-11-20 09:57:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(36, 'Touring-3000', 'Research, design and development of Touring-3000. All-occasion value bike with our basic comfort and safety features. Offers wider, more stable tires for a ride around town or weekend trip.', '2002-11-20 09:57:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(37, 'Women\'s Mountain Shorts', 'Research, design and development of Women\'s Mountain Shorts. Heavy duty, abrasion-resistant shorts feature seamless, lycra inner shorts with anti-bacterial chamois for comfort.', '2003-06-01 00:00:00.000000', NULL),
  -- 	(38, 'Women\'s Tights', 'Research, design and development of Women\'s Tights. Warm spandex tights for winter riding; seamless chamois construction eliminates pressure points.', '2002-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(39, 'Mountain-400', 'Research, design and development of Mountain-400. Suitable for any type of off-road trip. Fits any budget.', '2001-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(40, 'Road-550', 'Research, design and development of Road-550. Same technology as all of our Road series bikes.  Perfect all-around bike for road or racing.', '2002-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(41, 'Road-350', 'Research, design and development of Road-350. Cross-train, race, or just socialize on a sleek, aerodynamic bike.  Advanced seat technology provides comfort all day.', '2002-11-20 09:57:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(42, 'LL Mountain Front Wheel', 'Research, design and development of LL Mountain Front Wheel. Replacement mountain wheel for entry-level rider.', '2002-11-20 09:57:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(43, 'Touring Rear Wheel', 'Research, design and development of Touring Rear Wheel. Excellent aerodynamic rims guarantee a smooth ride.', '2005-05-16 16:34:00.000000', NULL),
  -- 	(44, 'Touring Front Wheel', 'Research, design and development of Touring Front Wheel. Aerodynamic rims for smooth riding.', '2005-05-16 16:34:00.000000', NULL),
  -- 	(45, 'ML Mountain Front Wheel', 'Research, design and development of ML Mountain Front Wheel. Replacement mountain wheel for the casual to serious rider.', '2002-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(46, 'HL Mountain Front Wheel', 'Research, design and development of HL Mountain Front Wheel. High-performance mountain replacement wheel.', '2002-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(47, 'LL Touring Handlebars', 'Research, design and development of LL Touring Handlebars. Unique shape reduces fatigue for entry level riders.', '2005-05-16 16:34:00.000000', NULL),
  -- 	(48, 'HL Touring Handlebars', 'Research, design and development of HL Touring Handlebars. A light yet stiff aluminum bar for long distance riding.', '2005-05-16 16:34:00.000000', NULL),
  -- 	(49, 'LL Road Front Wheel', 'Research, design and development of LL Road Front Wheel. Replacement road front wheel for entry-level cyclist.', '2002-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(50, 'ML Road Front Wheel', 'Research, design and development of ML Road Front Wheel. Sturdy alloy features a quick-release hub.', '2002-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(51, 'HL Road Front Wheel', 'Research, design and development of HL Road Front Wheel. Strong wheel with double-walled rim.', '2002-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(52, 'LL Mountain Handlebars', 'Research, design and development of LL Mountain Handlebars. All-purpose bar for on or off-road.', '2002-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(53, 'Touring Pedal', 'Research, design and development of Touring Pedal. A stable pedal for all-day riding.', '2005-05-16 16:34:00.000000', NULL),
  -- 	(54, 'ML Mountain Handlebars', 'Research, design and development of ML Mountain Handlebars. Tough aluminum alloy bars for downhill.', '2002-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(55, 'HL Mountain Handlebars', 'Research, design and development of HL Mountain Handlebars. Flat bar strong enough for the pro circuit.', '2002-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(56, 'LL Road Handlebars', 'Research, design and development of LL Road Handlebars. Unique shape provides easier reach to the levers.', '2002-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(57, 'ML Road Handlebars', 'Research, design and development of ML Road Handlebars. Anatomically shaped aluminum tube bar will suit all riders.', '2002-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(58, 'HL Road Handlebars', 'Research, design and development of HL Road Handlebars. Designed for racers; high-end anatomically shaped bar from aluminum alloy.', '2002-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(59, 'LL Headset', 'Research, design and development of LL Headset. Threadless headset provides quality at an economical price.', '2002-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(60, 'ML Headset', 'Research, design and development of ML Headset. Sealed cartridge keeps dirt out.', '2002-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(61, 'HL Headset', 'Research, design and development of HL Headset. High-quality 1" threadless headset with a grease port for quick lubrication.', '2002-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(77, 'ML Road Rear Wheel', 'Research, design and development of ML Road Rear Wheel. Aluminum alloy rim with stainless steel spokes; built for speed.', '2002-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(78, 'HL Road Rear Wheel', 'Research, design and development of HL Road Rear Wheel. Strong rear wheel with double-walled rim.', '2002-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(79, 'LL Mountain Seat/Saddle 2', 'Research, design and development of LL Mountain Seat/Saddle 2. Synthetic leather. Features gel for increased comfort.', '2003-06-01 00:00:00.000000', NULL),
  -- 	(80, 'ML Mountain Seat/Saddle 2', 'Research, design and development of ML Mountain Seat/Saddle 2. Designed to absorb shock.', '2003-06-01 00:00:00.000000', '2004-03-11 10:32:00.000000'),
  -- 	(104, 'LL Fork', 'Research, design and development of LL Fork. Stout design absorbs shock and offers more precise steering.', '2002-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(105, 'ML Fork', 'Research, design and development of ML Fork. Composite road fork with an aluminum steerer tube.', '2002-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(106, 'HL Fork', 'Research, design and development of HL Fork. High-performance carbon road fork with curved legs.', '2002-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(107, 'Hydration Pack', 'Research, design and development of Hydration Pack. Versatile 70 oz hydration pack offers extra storage, easy-fill access, and a waist belt.', '2003-06-01 00:00:00.000000', NULL),
  -- 	(108, 'Taillight', 'Research, design and development of Taillight. Affordable light for safe night riding - uses 3 AAA batteries', '2002-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(109, 'Headlights - Dual-Beam', 'Research, design and development of Headlights - Dual-Beam. Rechargeable dual-beam headlight.', '2002-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(110, 'Headlights - Weatherproof', 'Research, design and development of Headlights - Weatherproof. Rugged weatherproof headlight.', '2002-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(111, 'Water Bottle', 'Research, design and development of Water Bottle. AWC logo water bottle - holds 30 oz; leak-proof.', '2003-06-01 00:00:00.000000', NULL),
  -- 	(112, 'Mountain Bottle Cage', 'Research, design and development of Mountain Bottle Cage. Tough aluminum cage holds bottle securly on tough terrain.', '2003-06-01 00:00:00.000000', NULL),
  -- 	(113, 'Road Bottle Cage', 'Research, design and development of Road Bottle Cage. Aluminum cage is lighter than our mountain version; perfect for long distance trips.', '2004-02-21 00:00:00.000000', NULL),
  -- 	(114, 'Patch kit', 'Research, design and development of Patch kit. Includes 8 different size patches, glue and sandpaper.', '2003-06-01 00:00:00.000000', NULL),
  -- 	(115, 'Cable Lock', 'Research, design and development of Cable Lock. Wraps to fit front and rear tires, carrier and 2 keys included.', '2002-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(116, 'Minipump', 'Research, design and development of Minipump. Designed for convenience. Fits in your pocket. Aluminum barrel. 160psi rated.', '2002-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(117, 'Mountain Pump', 'Research, design and development of Mountain Pump. Simple and light-weight. Emergency patches stored in handle.', '2002-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(118, 'Hitch Rack - 4-Bike', 'Research, design and development of Hitch Rack - 4-Bike. Carries 4 bikes securely; steel construction, fits 2" receiver hitch.', '2003-06-01 00:00:00.000000', NULL),
  -- 	(119, 'Bike Wash', 'Research, design and development of Bike Wash. Washes off the toughest road grime; dissolves grease, environmentally safe. 1-liter bottle.', '2005-08-01 00:00:00.000000', NULL),
  -- 	(120, 'Touring-Panniers', 'Research, design and development of Touring-Panniers. Durable, water-proof nylon construction with easy access. Large enough for weekend trips.', '2002-06-01 00:00:00.000000', '2003-06-01 00:00:00.000000'),
  -- 	(121, 'Fender Set - Mountain', 'Research, design and development of Fender Set - Mountain. Clip-on fenders fit most mountain bikes.', '2003-06-01 00:00:00.000000', NULL),
  -- 	(122, 'All-Purpose Bike Stand', 'Research, design and development of All-Purpose Bike Stand. Perfect all-purpose bike stand for working on your bike at home. Quick-adjusting clamps and steel construction.', '2005-09-01 00:00:00.000000', NULL),
  -- 	(127, 'Rear Derailleur', 'Research, design and development of Rear Derailleur. Wide-link design.', '2003-06-01 00:00:00.000000', NULL);
  -- /*!40000 ALTER TABLE `projects` ENABLE KEYS */;
  
  
  
  -- CREATE TABLE IF NOT EXISTS `towns` (
  --   `town_id` int(10) NOT NULL AUTO_INCREMENT,
  --   `name` varchar(50) NOT NULL,
  --   PRIMARY KEY (`town_id`),
  --   UNIQUE KEY `PK_Towns` (`town_id`)
  -- ) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;
  
  
  -- /*!40000 ALTER TABLE `towns` DISABLE KEYS */;
  -- INSERT INTO `towns` (`town_id`, `name`) VALUES
  -- 	(1, 'Redmond'),
  -- 	(2, 'Calgary'),
  -- 	(3, 'Edmonds'),
  -- 	(4, 'Seattle'),
  -- 	(5, 'Bellevue'),
  -- 	(6, 'Issaquah'),
  -- 	(7, 'Everett'),
  -- 	(8, 'Bothell'),
  -- 	(9, 'San Francisco'),
  -- 	(10, 'Index'),
  -- 	(11, 'Snohomish'),
  -- 	(12, 'Monroe'),
  -- 	(13, 'Renton'),
  -- 	(14, 'Newport Hills'),
  -- 	(15, 'Carnation'),
  -- 	(16, 'Sammamish'),
  -- 	(17, 'Duvall'),
  -- 	(18, 'Gold Bar'),
  -- 	(19, 'Nevada'),
  -- 	(20, 'Kenmore'),
  -- 	(21, 'Melbourne'),
  -- 	(22, 'Kent'),
  -- 	(23, 'Cambridge'),
  -- 	(24, 'Minneapolis'),
  -- 	(25, 'Portland'),
  -- 	(26, 'Duluth'),
  -- 	(27, 'Detroit'),
  -- 	(28, 'Memphis'),
  -- 	(29, 'Ottawa'),
  -- 	(30, 'Bordeaux'),
  -- 	(31, 'Berlin'),
  -- 	(32, 'Sofia');
  -- /*!40000 ALTER TABLE `towns` ENABLE KEYS */;
  -- /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
  -- /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
  -- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  