path: root/src/main/resources/sql/testdata.sql

insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (1, 'Bess Peak', '1961-03-01', 'NKA', false, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (2, 'Maryrose Farriar', '1970-11-16', 'RS', false, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (3, 'Hannis MacLardie', '1970-12-20', 'RS', false, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (4, 'Major Folbige', '1959-12-09', 'NKV', true, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (5, 'Bronny Nel', '1966-03-07', 'NFS', false, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (6, 'Fransisco Labadini', '1963-09-01', 'NKI', true, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (7, 'Dannie Skeldon', '1969-12-25', 'RS', false, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (8, 'Pippa Sickert', '1987-02-28', 'NKA', true, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (9, 'Gwendolyn Grigolon', '1975-03-05', 'RS', true, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (10, 'Aileen McGuinley', '1988-01-08', 'NFS', false, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (11, 'Barbra Izon', '1984-11-14', 'NFS', true, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (12, 'Ailsun Nestoruk', '1969-12-25', 'NKA', false, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (13, 'Ulrika Choake', '1975-06-17', 'RS', false, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (14, 'Myrtia Elsmor', '1974-05-23', 'RS', false, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (15, 'Brade Hurst', '1980-12-14', 'RS', true, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (16, 'Valli Fancet', '1955-11-11', 'NFS', false, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (17, 'Dana Nixon', '1973-08-19', 'RS', true, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (18, 'Anjela Orrice', '1986-04-21', 'RS', true, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (19, 'Normie Martinie', '1988-09-30', 'RS', true, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (20, 'Martelle Tunnick', '1972-01-29', 'RS', false, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (21, 'Laurent Janouch', '1990-05-25', 'RS', true, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (22, 'Scarface Portchmouth', '1970-04-26', 'NKA', false, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (23, 'Anatola McHugh', '1972-03-08', 'NFS', true, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (24, 'Tatum Flaonier', '1979-01-26', 'RS', true, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (25, 'Dianna Philo', '1998-09-07', 'NKI', true, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (26, 'Ave Thow', '1965-07-30', 'NKV', false, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (27, 'Vail Naptine', '1986-08-28', 'RS', false, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (28, 'Gaven Gainsbury', '1991-01-21', 'NFS', false, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (29, 'Kaile Hartill', '1970-06-30', 'RS', false, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (30, 'Floria Trevaskis', '1955-01-14', 'NKA', false, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (31, 'Bidget Dukelow', '1969-12-14', 'NKI', true, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (32, 'Reece Mushet', '1989-07-18', 'RS', true, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (33, 'Rafaellle Hurdle', '1968-04-25', 'NFS', false, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (34, 'Kristoforo Boner', '1960-11-26', 'RS', false, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (35, 'Carree Marquot', '1982-10-29', 'NKA', false, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (36, 'Max Maldin', '1955-08-30', 'RS', false, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (37, 'Betsy Urion', '1999-01-09', 'RS', true, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (38, 'Jud Levey', '1986-08-28', 'NFS', true, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (39, 'Stepha Adriani', '1964-06-26', 'NA', true, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (40, 'Jodie Yeskin', '1963-06-22', 'NKV', false, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (41, 'Viole Heritege', '1999-11-27', 'RS', false, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (42, 'Mort Dudson', '1973-07-28', 'RS', true, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (43, 'Brittney Srawley', '1955-04-12', 'NKI', true, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (44, 'Tod Plevey', '1994-09-28', 'RS', true, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (45, 'Rhianon Lawday', '1963-11-15', 'RS', true, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (46, 'Hill Jachtym', '1972-10-02', 'NFS', true, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (47, 'Gregory Sheavills', '1971-08-14', 'NKI', true, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (48, 'Linnea Castlake', '1966-03-31', 'RS', true, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (49, 'Curr Robertz', '1983-09-24', 'RS', false, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (50, 'Ricki Trevillion', '1972-08-17', 'NFS', true, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (51, 'Haily Gloyens', '1975-08-24', 'RS', true, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (52, 'Sherwynd Bugbird', '1966-01-16', 'NFS', true, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (53, 'Cathrin Hamlen', '1973-01-15', 'RS', false, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (54, 'Oliver Ropars', '1964-02-28', 'NKA', true, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (55, 'Mersey Suerz', '1988-03-03', 'RS', true, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (56, 'Fabio Mapes', '1986-01-01', 'NKA', true, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (57, 'Devondra Jonsson', '1969-10-01', 'NKI', false, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (58, 'Malva Pulver', '1984-06-11', 'RS', false, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (59, 'Petronella MacCorkell', '1990-01-25', 'NFS', true, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (60, 'Letty McKag', '1989-02-05', 'RS', false, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (61, 'Nikoletta McLeish', '1956-09-19', 'NKV', false, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (62, 'Mella Gerred', '1963-04-28', 'RS', true, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (63, 'Banky Bradforth', '1983-12-23', 'RS', true, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (64, 'Etta Curnow', '1993-06-29', 'RS', false, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (65, 'Bobina Fernez', '1956-12-14', 'NKV', false, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (66, 'Dreddy Pessold', '1972-02-25', 'NA', true, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (67, 'Maxie Speedy', '1984-04-19', 'RS', false, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (68, 'Benetta Jent', '1969-12-27', 'NA', false, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (69, 'Caro Szanto', '1957-06-14', 'RS', false, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (70, 'Carmela Alejandre', '1979-12-05', 'NFS', true, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (71, 'Merrile Doig', '1992-08-07', 'RS', false, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (72, 'Michell Sanney', '1959-08-11', 'NFS', false, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (73, 'Kata Spark', '1988-12-18', 'NFS', false, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (74, 'Chelsie Normanville', '1972-04-14', 'NFS', true, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (75, 'Ciro Grigg', '1957-02-18', 'NFS', false, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (76, 'Shela Larkcum', '1979-12-14', 'NFS', false, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (77, 'Myrvyn Denyukin', '1976-07-07', 'NKA', false, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (78, 'Lethia Glede', '1972-12-10', 'RS', true, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (79, 'Malchy Chiverton', '1971-08-14', 'RS', false, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (80, 'Dario Rasor', '1997-10-05', 'RS', false, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (81, 'Anni Baldacco', '1961-08-05', 'RS', true, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (82, 'Brigit Wheelband', '1966-06-21', 'RS', false, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (83, 'Niki Tynemouth', '1968-09-17', 'NFS', true, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (84, 'Nikki Mea', '1965-08-14', 'NFS', false, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (85, 'Dania Garrique', '1986-03-25', 'NA', false, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (86, 'Dorelia Leggs', '1960-12-16', 'NKI', true, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (87, 'Cristin Carous', '1999-10-21', 'NFS', true, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (88, 'Clare Caustick', '1969-09-27', 'RS', true, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (89, 'Conant Gallo', '1993-11-19', 'RS', false, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (90, 'Gwyneth Cavie', '1956-04-12', 'NFS', false, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (91, 'Mabel Meadley', '1966-11-25', 'RS', true, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (92, 'Mona Bonafant', '1957-06-12', 'RS', true, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (93, 'Clarita Fealty', '1987-12-22', 'NFS', false, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (94, 'Elie Jardin', '1986-01-10', 'NKA', false, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (95, 'Pacorro Dobing', '1988-01-04', 'NFS', true, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (96, 'Marci Wloch', '1973-08-23', 'NKA', false, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (97, 'Micky Fossett', '2000-01-13', 'NFS', false, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (98, 'Bil Rangall', '1979-05-06', 'RS', true, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (99, 'Athena Matteoni', '1980-11-08', 'RS', true, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (100, 'Molly Fennelly', '1980-06-14', 'RS', false, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (101, 'Dylan Fordyce', '1983-12-03', 'NFS', false, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (102, 'Onida Betjeman', '1993-01-12', 'NKI', false, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (103, 'Brietta Biswell', '1956-09-18', 'NFS', false, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (104, 'Elna Boyton', '1983-04-08', 'RS', false, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (105, 'Zsazsa Robertazzi', '1967-08-28', 'RS', true, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (106, 'Brook Bleier', '1976-12-04', 'RS', true, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (107, 'Kaleena Fosh', '1987-08-04', 'NFS', true, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (108, 'Julee Polamontayne', '1988-09-30', 'RS', true, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (109, 'Arte Elliss', '1965-08-30', 'NA', true, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (110, 'Celia Skelcher', '1965-01-31', 'NKA', false, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (111, 'Kelsey Luetkemeyer', '1976-07-27', 'RS', true, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (112, 'Pedro Jakubowski', '1982-07-10', 'NA', false, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (113, 'Licha Slatten', '1985-03-19', 'RS', false, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (114, 'Adella Sisson', '1997-06-02', 'NFS', false, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (115, 'Hagan Senett', '1979-09-25', 'RS', true, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (116, 'Jecho Beilby', '1993-12-27', 'RS', false, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (117, 'Karoly Toolin', '1988-06-11', 'RS', true, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (118, 'Madelon Steart', '1987-08-04', 'NKA', false, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (119, 'Laverne Yelland', '1980-11-09', 'RS', false, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (120, 'Murry Bottoner', '1955-04-21', 'NKA', true, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (121, 'Sianna Tomney', '1987-04-14', 'NFS', true, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (122, 'Dulcea Squirrell', '1967-03-07', 'NFS', false, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (123, 'Bengt Durbridge', '1966-04-15', 'RS', false, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (124, 'Cletus Akenhead', '1974-06-13', 'RS', true, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (125, 'Huntington McKeand', '1988-12-21', 'NA', true, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (126, 'Carolin Doget', '1974-05-02', 'RS', true, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (127, 'Bobby Iredell', '1974-01-25', 'RS', false, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (128, 'Preston Pidgeon', '1987-06-17', 'RS', false, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (129, 'Gretta Darnbrough', '1996-05-22', 'NKI', true, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (130, 'Justen Hearley', '1976-08-09', 'RS', false, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (131, 'Davon Baser', '1987-03-02', 'RS', true, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (132, 'Alasdair Clancy', '1993-05-24', 'RS', false, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (133, 'Hattie Kareman', '1997-07-07', 'NKA', true, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (134, 'Ignaz Buddell', '1986-02-07', 'RS', true, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (135, 'Ashil Kanter', '1977-06-17', 'NFS', true, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (136, 'Daniele Mallam', '1969-01-26', 'RS', false, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (137, 'Eugenius Stuehmeier', '1961-10-16', 'RS', false, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (138, 'Jdavie Acey', '1991-11-21', 'RS', false, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (139, 'Jaynell Fossord', '1967-10-15', 'RS', true, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (140, 'Roarke Peascod', '1956-12-01', 'NKA', true, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (141, 'Horacio Boxer', '1990-02-12', 'NKA', true, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (142, 'Bard Thyng', '1979-01-25', 'NKI', false, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (143, 'Nadia Fayre', '1979-03-02', 'NFS', true, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (144, 'Garrot Fry', '1960-12-30', 'NKV', true, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (145, 'Kristal Hammor', '1975-09-05', 'RS', true, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (146, 'Barnebas Kinsell', '2000-10-11', 'NFS', false, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (147, 'Marleen Entwhistle', '1960-04-08', 'NFS', false, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (148, 'Paule Kettlestring', '1978-04-04', 'RS', false, false);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (149, 'Valentin Nerval', '1999-06-01', 'RS', false, true);
insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (150, 'Zitella Bywaters', '1966-11-11', 'NKA', true, true);


insert into Employee (id, version) values (1, 1);
insert into Employee (id, version) values (2, 2);
insert into Employee (id, version) values (3, 3);
insert into Employee (id, version) values (4, 4);
insert into Employee (id, version) values (5, 5);
insert into Employee (id, version) values (6, 6);
insert into Employee (id, version) values (7, 7);
insert into Employee (id, version) values (8, 8);
insert into Employee (id, version) values (9, 9);
insert into Employee (id, version) values (10, 10);
insert into Employee (id, version) values (11, 11);
insert into Employee (id, version) values (12, 12);
insert into Employee (id, version) values (13, 13);
insert into Employee (id, version) values (14, 14);
insert into Employee (id, version) values (15, 15);
insert into Employee (id, version) values (16, 16);
insert into Employee (id, version) values (17, 17);
insert into Employee (id, version) values (18, 18);
insert into Employee (id, version) values (19, 19);
insert into Employee (id, version) values (20, 20);
insert into Employee (id, version) values (21, 21);
insert into Employee (id, version) values (22, 22);
insert into Employee (id, version) values (23, 23);
insert into Employee (id, version) values (24, 24);
insert into Employee (id, version) values (25, 25);
insert into Employee (id, version) values (26, 26);
insert into Employee (id, version) values (27, 27);
insert into Employee (id, version) values (28, 28);
insert into Employee (id, version) values (29, 29);
insert into Employee (id, version) values (30, 30);
insert into Employee (id, version) values (31, 31);
insert into Employee (id, version) values (32, 32);
insert into Employee (id, version) values (33, 33);
insert into Employee (id, version) values (34, 34);
insert into Employee (id, version) values (35, 35);
insert into Employee (id, version) values (36, 36);
insert into Employee (id, version) values (37, 37);
insert into Employee (id, version) values (38, 38);
insert into Employee (id, version) values (39, 39);
insert into Employee (id, version) values (40, 40);
insert into Employee (id, version) values (41, 41);
insert into Employee (id, version) values (42, 42);
insert into Employee (id, version) values (43, 43);
insert into Employee (id, version) values (44, 44);
insert into Employee (id, version) values (45, 45);
insert into Employee (id, version) values (46, 46);
insert into Employee (id, version) values (47, 47);
insert into Employee (id, version) values (48, 48);
insert into Employee (id, version) values (49, 49);
insert into Employee (id, version) values (50, 50);
insert into Employee (id, version) values (51, 51);
insert into Employee (id, version) values (52, 52);
insert into Employee (id, version) values (53, 53);
insert into Employee (id, version) values (54, 54);
insert into Employee (id, version) values (55, 55);
insert into Employee (id, version) values (56, 56);
insert into Employee (id, version) values (57, 57);
insert into Employee (id, version) values (58, 58);
insert into Employee (id, version) values (59, 59);
insert into Employee (id, version) values (60, 60);
insert into Employee (id, version) values (61, 61);
insert into Employee (id, version) values (62, 62);
insert into Employee (id, version) values (63, 63);
insert into Employee (id, version) values (64, 64);
insert into Employee (id, version) values (65, 65);
insert into Employee (id, version) values (66, 66);
insert into Employee (id, version) values (67, 67);
insert into Employee (id, version) values (68, 68);
insert into Employee (id, version) values (69, 69);
insert into Employee (id, version) values (70, 70);
insert into Employee (id, version) values (71, 71);
insert into Employee (id, version) values (72, 72);
insert into Employee (id, version) values (73, 73);
insert into Employee (id, version) values (74, 74);
insert into Employee (id, version) values (75, 75);
insert into Employee (id, version) values (76, 76);
insert into Employee (id, version) values (77, 77);
insert into Employee (id, version) values (78, 78);
insert into Employee (id, version) values (79, 79);
insert into Employee (id, version) values (80, 80);
insert into Employee (id, version) values (81, 81);
insert into Employee (id, version) values (82, 82);
insert into Employee (id, version) values (83, 83);
insert into Employee (id, version) values (84, 84);
insert into Employee (id, version) values (85, 85);
insert into Employee (id, version) values (86, 86);
insert into Employee (id, version) values (87, 87);
insert into Employee (id, version) values (88, 88);
insert into Employee (id, version) values (89, 89);
insert into Employee (id, version) values (90, 90);
insert into Employee (id, version) values (91, 91);
insert into Employee (id, version) values (92, 92);
insert into Employee (id, version) values (93, 93);
insert into Employee (id, version) values (94, 94);
insert into Employee (id, version) values (95, 95);
insert into Employee (id, version) values (96, 96);
insert into Employee (id, version) values (97, 97);
insert into Employee (id, version) values (98, 98);
insert into Employee (id, version) values (99, 99);
insert into Employee (id, version) values (100, 100);
insert into Employee (id, version) values (101, 101);
insert into Employee (id, version) values (102, 102);
insert into Employee (id, version) values (103, 103);
insert into Employee (id, version) values (104, 104);
insert into Employee (id, version) values (105, 105);
insert into Employee (id, version) values (106, 106);
insert into Employee (id, version) values (107, 107);
insert into Employee (id, version) values (108, 108);
insert into Employee (id, version) values (109, 109);
insert into Employee (id, version) values (110, 110);
insert into Employee (id, version) values (111, 111);
insert into Employee (id, version) values (112, 112);
insert into Employee (id, version) values (113, 113);
insert into Employee (id, version) values (114, 114);
insert into Employee (id, version) values (115, 115);
insert into Employee (id, version) values (116, 116);
insert into Employee (id, version) values (117, 117);
insert into Employee (id, version) values (118, 118);
insert into Employee (id, version) values (119, 119);
insert into Employee (id, version) values (120, 120);
insert into Employee (id, version) values (121, 121);
insert into Employee (id, version) values (122, 122);
insert into Employee (id, version) values (123, 123);
insert into Employee (id, version) values (124, 124);
insert into Employee (id, version) values (125, 125);
insert into Employee (id, version) values (126, 126);
insert into Employee (id, version) values (127, 127);
insert into Employee (id, version) values (128, 128);
insert into Employee (id, version) values (129, 129);
insert into Employee (id, version) values (130, 130);
insert into Employee (id, version) values (131, 131);
insert into Employee (id, version) values (132, 132);
insert into Employee (id, version) values (133, 133);
insert into Employee (id, version) values (134, 134);
insert into Employee (id, version) values (135, 135);
insert into Employee (id, version) values (136, 136);
insert into Employee (id, version) values (137, 137);
insert into Employee (id, version) values (138, 138);
insert into Employee (id, version) values (139, 139);
insert into Employee (id, version) values (140, 140);
insert into Employee (id, version) values (141, 141);
insert into Employee (id, version) values (142, 142);
insert into Employee (id, version) values (143, 143);
insert into Employee (id, version) values (144, 144);
insert into Employee (id, version) values (145, 145);
insert into Employee (id, version) values (146, 146);
insert into Employee (id, version) values (147, 147);
insert into Employee (id, version) values (148, 148);
insert into Employee (id, version) values (149, 149);
insert into Employee (id, version) values (150, 150);


insert into VehicleVersion (id, type, constructionType, name, hasNef) values (1, 'BKTW', 'NORMAL', 'BKTW-1', true);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (2, 'KTW', 'MITTELHOCHDACH', 'KTW-2', false);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (3, 'KTW', 'MITTELHOCHDACH', 'KTW-3', false);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (4, 'BKTW', 'NORMAL', 'BKTW-4', true);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (5, 'RTW', 'HOCHDACH', 'RTW-5', false);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (6, 'RTW', 'HOCHDACH', 'RTW-6', false);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (7, 'BKTW', 'NORMAL', 'BKTW-7', false);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (8, 'KTW_B', 'MITTELHOCHDACH', 'KTW_B-8', false);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (9, 'RTW', 'HOCHDACH', 'RTW-9', true);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (10, 'RTW', 'HOCHDACH', 'RTW-10', true);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (11, 'RTW', 'HOCHDACH', 'RTW-11', true);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (12, 'RTW', 'HOCHDACH', 'RTW-12', false);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (13, 'KTW_B', 'MITTELHOCHDACH', 'KTW_B-13', false);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (14, 'KTW_B', 'MITTELHOCHDACH', 'KTW_B-14', true);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (15, 'BKTW', 'NORMAL', 'BKTW-15', true);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (16, 'KTW_B', 'MITTELHOCHDACH', 'KTW_B-16', false);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (17, 'KTW', 'MITTELHOCHDACH', 'KTW-17', false);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (18, 'KTW_B', 'MITTELHOCHDACH', 'KTW_B-18', false);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (19, 'RTW', 'HOCHDACH', 'RTW-19', false);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (20, 'RTW', 'HOCHDACH', 'RTW-20', false);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (21, 'RTW', 'HOCHDACH', 'RTW-21', true);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (22, 'BKTW', 'NORMAL', 'BKTW-22', true);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (23, 'RTW', 'HOCHDACH', 'RTW-23', false);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (24, 'KTW_B', 'MITTELHOCHDACH', 'KTW_B-24', false);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (25, 'KTW', 'MITTELHOCHDACH', 'KTW-25', true);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (26, 'RTW', 'HOCHDACH', 'RTW-26', false);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (27, 'KTW', 'MITTELHOCHDACH', 'KTW-27', false);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (28, 'KTW', 'MITTELHOCHDACH', 'KTW-28', false);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (29, 'BKTW', 'NORMAL', 'BKTW-29', false);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (30, 'RTW', 'HOCHDACH', 'RTW-30', false);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (31, 'RTW', 'HOCHDACH', 'RTW-31', true);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (32, 'RTW', 'HOCHDACH', 'RTW-32', false);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (33, 'RTW', 'HOCHDACH', 'RTW-33', false);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (34, 'KTW', 'MITTELHOCHDACH', 'KTW-34', true);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (35, 'KTW_B', 'MITTELHOCHDACH', 'KTW_B-35', true);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (36, 'RTW', 'HOCHDACH', 'RTW-36', true);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (37, 'RTW', 'HOCHDACH', 'RTW-37', true);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (38, 'BKTW', 'NORMAL', 'BKTW-38', false);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (39, 'KTW_B', 'MITTELHOCHDACH', 'KTW_B-39', true);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (40, 'RTW', 'HOCHDACH', 'RTW-40', false);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (41, 'RTW', 'HOCHDACH', 'RTW-41', true);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (42, 'KTW', 'MITTELHOCHDACH', 'KTW-42', false);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (43, 'RTW', 'HOCHDACH', 'RTW-43', true);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (44, 'RTW', 'HOCHDACH', 'RTW-44', true);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (45, 'RTW', 'HOCHDACH', 'RTW-45', true);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (46, 'RTW', 'HOCHDACH', 'RTW-46', false);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (47, 'KTW', 'MITTELHOCHDACH', 'KTW-47', false);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (48, 'BKTW', 'NORMAL', 'BKTW-48', false);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (49, 'RTW', 'HOCHDACH', 'RTW-49', false);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (50, 'RTW', 'HOCHDACH', 'RTW-50', true);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (51, 'NEF', 'NORMAL', 'NEF-51', false);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (52, 'NEF', 'NORMAL', 'NEF-52', false);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (53, 'NEF', 'NORMAL', 'NEF-53', false);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (54, 'NEF', 'NORMAL', 'NEF-54', false);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (55, 'NEF', 'NORMAL', 'NEF-55', false);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (56, 'NEF', 'NORMAL', 'NEF-56', false);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (57, 'NEF', 'NORMAL', 'NEF-57', false);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (58, 'NEF', 'NORMAL', 'NEF-58', false);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (59, 'NAH', 'NORMAL', 'NAH-59', true);
insert into VehicleVersion (id, type, constructionType, name, hasNef) values (60, 'NAH', 'NORMAL', 'NAH-60', true);


insert into Vehicle (id, version, status) values (1, 1, 'ABGEMELDET');
insert into Vehicle (id, version, status) values (2, 2, 'AM_BERUFUNGSORT');
insert into Vehicle (id, version, status) values (3, 3, 'ABGEMELDET');
insert into Vehicle (id, version, status) values (4, 4, 'ABGEMELDET');
insert into Vehicle (id, version, status) values (5, 5, 'FREI_WACHE');
insert into Vehicle (id, version, status) values (6, 6, 'ABGEMELDET');
insert into Vehicle (id, version, status) values (7, 7, 'ABGEMELDET');
insert into Vehicle (id, version, status) values (8, 8, 'ABGEMELDET');
insert into Vehicle (id, version, status) values (9, 9, 'FREI_WACHE');
insert into Vehicle (id, version, status) values (10, 10, 'ZUM_ZIELORT');
insert into Vehicle (id, version, status) values (11, 11, 'FREI_WACHE');
insert into Vehicle (id, version, status) values (12, 12, 'FREI_WACHE');
insert into Vehicle (id, version, status) values (13, 13, 'ABGEMELDET');
insert into Vehicle (id, version, status) values (14, 14, 'FREI_WACHE');
insert into Vehicle (id, version, status) values (15, 15, 'ABGEMELDET');
insert into Vehicle (id, version, status) values (16, 16, 'ABGEMELDET');
insert into Vehicle (id, version, status) values (17, 17, 'ZUM_BERUFUNGSORT');
insert into Vehicle (id, version, status) values (18, 18, 'ABGEMELDET');
insert into Vehicle (id, version, status) values (19, 19, 'ABGEMELDET');
insert into Vehicle (id, version, status) values (20, 20, 'FREI_WACHE');
insert into Vehicle (id, version, status) values (21, 21, 'ABGEMELDET');
insert into Vehicle (id, version, status) values (22, 22, 'FREI_WACHE');
insert into Vehicle (id, version, status) values (23, 23, 'FREI_WACHE');
insert into Vehicle (id, version, status) values (24, 24, 'ABGEMELDET');
insert into Vehicle (id, version, status) values (25, 25, 'ABGEMELDET');
insert into Vehicle (id, version, status) values (26, 26, 'FREI_WACHE');
insert into Vehicle (id, version, status) values (27, 27, 'AM_ZIELORT');
insert into Vehicle (id, version, status) values (28, 28, 'AM_BERUFUNGSORT');
insert into Vehicle (id, version, status) values (29, 29, 'ABGEMELDET');
insert into Vehicle (id, version, status) values (30, 30, 'ABGEMELDET');
insert into Vehicle (id, version, status) values (31, 31, 'ZUM_BERUFUNGSORT');
insert into Vehicle (id, version, status) values (32, 32, 'FREI_WACHE');
insert into Vehicle (id, version, status) values (33, 33, 'ABGEMELDET');
insert into Vehicle (id, version, status) values (34, 34, 'AM_ZIELORT');
insert into Vehicle (id, version, status) values (35, 35, 'ABGEMELDET');
insert into Vehicle (id, version, status) values (36, 36, 'FREI_WACHE');
insert into Vehicle (id, version, status) values (37, 37, 'FREI_WACHE');
insert into Vehicle (id, version, status) values (38, 38, 'FREI_WACHE');
insert into Vehicle (id, version, status) values (39, 39, 'ABGEMELDET');
insert into Vehicle (id, version, status) values (40, 40, 'FREI_WACHE');
insert into Vehicle (id, version, status) values (41, 41, 'FREI_WACHE');
insert into Vehicle (id, version, status) values (42, 42, 'FREI_WACHE');
insert into Vehicle (id, version, status) values (43, 43, 'ABGEMELDET');
insert into Vehicle (id, version, status) values (44, 44, 'FREI_WACHE');
insert into Vehicle (id, version, status) values (45, 45, 'FREI_WACHE');
insert into Vehicle (id, version, status) values (46, 46, 'FREI_WACHE');
insert into Vehicle (id, version, status) values (47, 47, 'FREI_WACHE');
insert into Vehicle (id, version, status) values (48, 48, 'ABGEMELDET');
insert into Vehicle (id, version, status) values (49, 49, 'AM_BERUFUNGSORT');
insert into Vehicle (id, version, status) values (50, 50, 'FREI_WACHE');
insert into Vehicle (id, version, status) values (51, 51, 'ZUM_ZIELORT');
insert into Vehicle (id, version, status) values (52, 52, 'FREI_WACHE');
insert into Vehicle (id, version, status) values (53, 53, 'FREI_WACHE');
insert into Vehicle (id, version, status) values (54, 54, 'ABGEMELDET');
insert into Vehicle (id, version, status) values (55, 55, 'ABGEMELDET');
insert into Vehicle (id, version, status) values (56, 56, 'ABGEMELDET');
insert into Vehicle (id, version, status) values (57, 57, 'ABGEMELDET');
insert into Vehicle (id, version, status) values (58, 58, 'ABGEMELDET');
insert into Vehicle (id, version, status) values (59, 59, 'FREI_WACHE');
insert into Vehicle (id, version, status) values (60, 60, 'FREI_WACHE');


insert into Registration (id, vehicleId, employeeId, start, end, active) values (1, 5, 2, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (2, 5, 4, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (3, 46, 13, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (4, 46, 32, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (5, 32, 44, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (6, 32, 51, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (7, 45, 37, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (8, 45, 49, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (9, 14, 34, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (10, 14, 9, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (11, 11, 78, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (12, 11, 84, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (13, 47, 62, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (14, 47, 63, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (15, 41, 92, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (16, 41, 93, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (17, 50, 117, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (18, 50, 116, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (19, 17, 134, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (20, 17, 135, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (21, 42, 149, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (22, 42, 150, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (23, 12, 139, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (24, 12, 140, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (25, 34, 111, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (26, 34, 113, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (27, 22, 131, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (28, 31, 70, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (29, 31, 69, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (30, 38, 88, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (31, 49, 19, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (32, 49, 20, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (33, 40, 55, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (34, 40, 56, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (35, 26, 42, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (36, 26, 67, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (37, 36, 11, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (38, 36, 12, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (39, 37, 33, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (40, 37, 34, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (41, 37, 15, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (42, 20, 65, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (43, 20, 74, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (44, 44, 123, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (45, 44, 124, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (46, 28, 126, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (47, 28, 127, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (48, 10, 144, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (49, 10, 145, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (50, 2, 71, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (51, 2, 4, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (52, 23, 7, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (53, 23, 8, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (54, 9, 10, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (55, 9, 31, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (56, 59, 6, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (57, 59, 22, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (58, 59, 39, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (59, 60, 53, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (60, 60, 54, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (61, 60, 66, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (62, 51, 83, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (63, 51, 112, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (64, 52, 129, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (65, 52, 125, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (66, 53, 38, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (67, 53, 85, '2018-06-14 14:00:00.0', '2018-06-23 14:00:00.0', true);
/*insert into Registration (id, vehicleId, employeeId, start, end, active) values (68, , , , , true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (69, , , , , true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (70, , , , , true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (71, , , , , true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (72, , , , , true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (73, , , , , true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (74, , , , , true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (75, , , , , true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (76, , , , , true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (77, , , , , true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (78, , , , , true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (79, , , , , true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (80, , , , , true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (81, , , , , true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (82, , , , , true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (83, , , , , true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (84, , , , , true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (85, , , , , true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (86, , , , , true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (87, , , , , true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (88, , , , , true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (89, , , , , true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (90, , , , , true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (91, , , , , true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (92, , , , , true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (93, , , , , true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (94, , , , , true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (95, , , , , true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (96, , , , , true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (97, , , , , true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (98, , , , , true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (99, , , , , true);
insert into Registration (id, vehicleId, employeeId, start, end, active) values (100, , , , , true);*/

insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (1, 'A', 'RD-10A4V', '2017-12-02T06:12:21Z', '0121 Golf Course Crossing', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (2, 'A', 'RD-26A6J', '2017-11-13T00:12:45Z', '75 Straubel Drive', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (3, 'C', 'RD-65C9M', '2017-07-31T19:08:42Z', '3468 Lawn Trail', 'Junction', 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (4, 'A', 'RD-51A8F', '2018-04-15T08:45:33Z', '11752 Farragut Pass', 'Park', 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (5, 'C', 'RD-18C3J', '2017-07-25T03:15:18Z', '546 Nova Place', 'Parkway', 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (6, 'A', 'RD-93A4D', '2017-11-07T22:33:38Z', '1 Shasta Crossing', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (7, 'O', 'RD-70O3C', '2017-08-16T20:18:10Z', '20076 Surrey Crossing', 'Point', 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (8, 'B', 'RD-76B9M', '2017-12-24T18:59:08Z', '214 Nova Hill', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (9, 'E', 'RD-40E5B', '2017-11-15T02:23:19Z', '3492 Atwood Alley', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (10, 'O', 'RD-70O2F', '2018-05-20T10:57:13Z', '655 Helena Junction', 'Park', 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (11, 'A', 'RD-35A7U', '2018-05-27T04:41:52Z', '200 Florence Drive', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (12, 'A', 'RD-22A8J', '2017-08-11T07:22:54Z', '017 Cambridge Drive', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (13, 'A', 'RD-43A6K', '2017-06-29T00:40:23Z', '59960 Longview Way', 'Lane', 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (14, 'C', 'RD-74C8K', '2018-04-03T04:38:37Z', '5083 Luster Hill', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (15, 'C', 'RD-93C6T', '2017-11-30T18:39:02Z', '2 Moose Parkway', 'Place', 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (16, 'D', 'RD-35D8P', '2017-12-08T23:39:15Z', '9 Utah Trail', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (17, 'A', 'RD-26A9L', '2017-08-05T18:25:13Z', '7468 Commercial Pass', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (18, 'E', 'RD-57E7X', '2017-08-12T06:26:53Z', '0 Eliot Alley', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (19, 'B', 'RD-84B8A', '2018-06-09T07:45:21Z', '05447 Division Plaza', 'Street', 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (20, 'C', 'RD-99C9L', '2018-04-28T16:41:06Z', '7 Jenifer Place', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (21, 'C', 'RD-85C9X', '2017-11-01T11:30:21Z', '350 Packers Avenue', 'Street', 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (22, 'A', 'RD-16A4K', '2018-05-03T01:57:10Z', '45577 Park Meadow Circle', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (23, 'B', 'RD-59B5Y', '2017-12-01T13:41:55Z', '7666 Grayhawk Terrace', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (24, 'C', 'RD-36C4V', '2018-05-02T14:45:08Z', '1520 Montana Court', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (25, 'A', 'RD-54A3B', '2018-01-27T13:02:43Z', '5478 Blackbird Street', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (26, 'A', 'RD-00A0Z', '2017-07-05T10:36:42Z', '668 Kenwood Pass', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (27, 'B', 'RD-99B3Z', '2017-10-31T13:58:54Z', '4528 Meadow Ridge Way', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (28, 'E', 'RD-21E4B', '2018-03-06T15:19:53Z', '8269 Anthes Park', 'Alley', 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (29, 'A', 'RD-68A4E', '2017-07-16T11:54:29Z', '34466 Mariners Cove Lane', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (30, 'A', 'RD-44A9N', '2017-11-16T22:07:30Z', '39 Shoshone Parkway', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (31, 'B', 'RD-28B1U', '2017-10-31T23:40:33Z', '9 Butternut Place', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (32, 'A', 'RD-19A8V', '2017-07-13T02:46:28Z', '9427 Clove Pass', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (33, 'B', 'RD-03B9Q', '2017-08-21T06:54:03Z', '08242 Hintze Street', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (34, 'A', 'RD-33A0C', '2017-12-16T13:31:21Z', '9 Russell Terrace', 'Parkway', 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (35, 'A', 'RD-54A1E', '2017-11-18T01:08:02Z', '40776 Kings Street', 'Street', 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (36, 'B', 'RD-11B9D', '2017-07-16T14:58:14Z', '4379 Grover Pass', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (37, 'A', 'RD-20A7H', '2018-04-12T17:25:55Z', '51626 Paget Drive', 'Lane', 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (38, 'B', 'RD-74B2N', '2018-06-15T15:33:35Z', '4039 Northwestern Terrace', 'Circle', 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (39, 'A', 'RD-14A2U', '2018-04-13T11:12:04Z', '174 Twin Pines Road', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (40, 'O', 'RD-85O8J', '2018-04-07T17:02:42Z', '15 Schiller Plaza', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (41, 'B', 'RD-17B8G', '2017-11-12T07:42:07Z', '446 Elka Drive', 'Center', 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (42, 'B', 'RD-16B1V', '2017-12-14T20:35:48Z', '0493 4th Road', 'Center', 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (43, 'A', 'RD-99A7V', '2017-06-29T17:17:53Z', '7815 Harper Place', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (44, 'O', 'RD-61O2F', '2017-07-15T08:41:09Z', '1388 Steensland Junction', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (45, 'A', 'RD-18A8M', '2017-12-05T14:06:22Z', '72 Golf Course Drive', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (46, 'A', 'RD-97A2W', '2017-08-28T20:48:22Z', '7333 Alpine Street', 'Lane', 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (47, 'A', 'RD-30A3J', '2018-01-26T00:15:01Z', '884 Stoughton Trail', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (48, 'O', 'RD-34O4J', '2018-06-01T01:21:24Z', '26 Riverside Lane', 'Pass', 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (49, 'B', 'RD-18B6R', '2017-07-15T08:15:06Z', '04291 Dakota Way', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (50, 'A', 'RD-36A2Y', '2017-12-29T01:36:29Z', '403 Forest Run Park', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (51, 'A', 'RD-07A3U', '2017-10-23T11:03:53Z', '00758 Di Loreto Terrace', 'Place', 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (52, 'O', 'RD-62O3Y', '2018-04-05T00:45:16Z', '8 Orin Court', 'Center', 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (53, 'A', 'RD-18A7D', '2017-10-17T00:32:46Z', '98788 Golf Course Court', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (54, 'A', 'RD-11A4A', '2017-09-20T03:12:38Z', '567 Oak Valley Drive', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (55, 'A', 'RD-30A2Y', '2017-11-06T08:00:24Z', '53 Fair Oaks Center', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (56, 'A', 'RD-17A3R', '2017-12-30T16:55:12Z', '075 Lighthouse Bay Junction', 'Parkway', 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (57, 'O', 'RD-18O4D', '2018-02-04T12:33:46Z', '54 Eagan Circle', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (58, 'A', 'RD-25A8I', '2017-09-26T20:36:01Z', '29 Troy Center', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (59, 'B', 'RD-20B1G', '2018-04-05T04:58:38Z', '8892 Kensington Way', 'Point', 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (60, 'A', 'RD-14A9B', '2017-06-27T04:49:09Z', '031 Cody Junction', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (61, 'A', 'RD-03A6S', '2017-09-10T00:46:34Z', '21 Steensland Place', 'Place', 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (62, 'O', 'RD-41O3V', '2017-07-06T02:08:29Z', '27757 Sycamore Point', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (63, 'O', 'RD-36O6T', '2018-04-20T08:06:43Z', '876 Service Pass', 'Park', 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (64, 'A', 'RD-42A2T', '2017-09-24T16:11:48Z', '1 Mitchell Park', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (65, 'A', 'RD-21A9L', '2018-06-11T06:03:37Z', '73686 Merrick Trail', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (66, 'C', 'RD-89C5M', '2018-03-10T16:46:56Z', '5168 Pine View Park', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (67, 'A', 'RD-10A6K', '2018-05-18T15:17:28Z', '304 Dunning Park', 'Way', 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (68, 'C', 'RD-09C7S', '2018-03-08T18:52:12Z', '0 Londonderry Street', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (69, 'B', 'RD-75B8D', '2017-09-26T00:11:54Z', '00 Elgar Alley', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (70, 'O', 'RD-43O2V', '2017-09-02T02:56:49Z', '5969 Elmside Street', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (71, 'A', 'RD-24A0R', '2017-09-04T14:27:20Z', '865 Autumn Leaf Circle', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (72, 'B', 'RD-82B3A', '2018-06-03T20:09:15Z', '449 Commercial Street', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (73, 'A', 'RD-59A3A', '2017-11-11T20:43:16Z', '3 Banding Hill', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (74, 'B', 'RD-98B1G', '2017-06-20T12:39:45Z', '4303 Barby Road', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (75, 'A', 'RD-61A5L', '2018-03-09T18:55:16Z', '0 Macpherson Lane', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (76, 'B', 'RD-72B8U', '2018-04-27T22:48:48Z', '4 Boyd Court', 'Point', 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (77, 'C', 'RD-63C3M', '2018-04-18T02:49:03Z', '3596 Miller Drive', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (78, 'A', 'RD-03A9D', '2017-10-20T16:01:25Z', '2 Crescent Oaks Park', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (79, 'A', 'RD-62A5V', '2018-01-02T14:59:58Z', '0089 Jackson Plaza', 'Street', 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (80, 'B', 'RD-36B2C', '2018-04-11T00:56:22Z', '3741 Spaight Circle', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (81, 'A', 'RD-19A7E', '2018-05-05T00:17:49Z', '90 Fair Oaks Place', 'Avenue', 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (82, 'B', 'RD-90B8G', '2017-08-06T00:47:06Z', '6 Fremont Street', 'Circle', 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (83, 'A', 'RD-28A0V', '2018-01-19T13:36:34Z', '20 Arrowood Parkway', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (84, 'A', 'RD-71A0B', '2018-01-09T15:30:57Z', '060 Badeau Park', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (85, 'B', 'RD-49B7X', '2018-02-07T18:46:02Z', '97261 Burning Wood Hill', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (86, 'B', 'RD-55B0F', '2018-02-02T03:23:51Z', '13987 Corscot Way', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (87, 'A', 'RD-79A5X', '2017-08-02T02:50:44Z', '90 Dexter Pass', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (88, 'A', 'RD-04A7T', '2017-11-06T07:18:03Z', '619 Graedel Court', 'Way', 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (89, 'C', 'RD-85C1G', '2017-12-17T18:50:36Z', '7 Fremont Avenue', 'Place', 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (90, 'O', 'RD-40O9Z', '2017-11-19T08:07:26Z', '79953 Fair Oaks Drive', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (91, 'C', 'RD-08C4Z', '2018-03-21T02:49:58Z', '7779 Monterey Street', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (92, 'A', 'RD-13A5U', '2017-09-29T05:21:06Z', '7 Little Fleur Road', 'Circle', 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (93, 'B', 'RD-02B2E', '2017-08-04T17:00:43Z', '34572 Old Shore Crossing', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (94, 'A', 'RD-11A9X', '2017-08-27T23:59:41Z', '858 Spenser Drive', 'Avenue', 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (95, 'B', 'RD-95B6D', '2018-01-07T01:49:50Z', '98 Jenifer Terrace', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (96, 'A', 'RD-47A7T', '2017-07-02T09:57:56Z', '209 Talmadge Lane', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (97, 'O', 'RD-78O1Z', '2017-12-10T15:02:21Z', '5348 Blackbird Pass', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (98, 'A', 'RD-72A5Y', '2017-12-23T10:48:06Z', '394 Anzinger Avenue', 'Point', 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (99, 'C', 'RD-78C4D', '2017-12-26T03:29:27Z', '115 Petterle Crossing', null, 'COMPLETED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (100, 'A', 'RD-17A9I', '2017-10-05T17:45:19Z', '533 Transport Way', 'Crossing', 'COMPLETED');


insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (101, 'A', 'RD-74A1G', '2018-02-05T15:37:44Z', '625 Veith Center', null, 'CANCELLED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (102, 'B', 'RD-15B1U', '2017-10-20T04:54:38Z', '9 Westport Alley', null, 'CANCELLED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (103, 'O', 'RD-62O0B', '2018-02-05T12:18:43Z', '87559 Sherman Terrace', 'Court', 'CANCELLED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (104, 'A', 'RD-45A0Y', '2018-05-17T17:08:18Z', '8 Delladonna Lane', null, 'CANCELLED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (105, 'A', 'RD-42A8G', '2018-05-03T01:52:39Z', '7 Superior Drive', null, 'CANCELLED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (106, 'O', 'RD-03O0G', '2018-01-21T17:21:12Z', '72 Darwin Point', null, 'CANCELLED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (107, 'A', 'RD-94A0W', '2017-11-08T06:11:31Z', '7168 Anniversary Way', null, 'CANCELLED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (108, 'A', 'RD-18A1E', '2018-02-20T15:51:48Z', '2023 Barby Road', null, 'CANCELLED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (109, 'A', 'RD-11A2I', '2018-02-07T06:42:04Z', '1901 Mesta Street', null, 'CANCELLED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (110, 'O', 'RD-78O0A', '2018-01-02T21:11:05Z', '6 David Trail', null, 'CANCELLED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (111, 'B', 'RD-70B6R', '2017-11-23T11:35:51Z', '188 Golden Leaf Avenue', 'Road', 'CANCELLED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (112, 'B', 'RD-95B9K', '2018-02-03T06:44:16Z', '805 Jenna Alley', null, 'CANCELLED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (113, 'A', 'RD-58A3E', '2017-08-18T08:46:01Z', '954 Oriole Hill', null, 'CANCELLED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (114, 'B', 'RD-58B5V', '2017-06-19T12:47:16Z', '2503 East Road', null, 'CANCELLED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (115, 'A', 'RD-93A3V', '2018-03-04T16:46:37Z', '2 Northview Terrace', null, 'CANCELLED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (116, 'B', 'RD-25B6N', '2018-01-05T13:49:50Z', '43459 Crownhardt Crossing', null, 'CANCELLED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (117, 'A', 'RD-01A3J', '2017-08-08T05:23:13Z', '13 Kedzie Road', null, 'CANCELLED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (118, 'B', 'RD-70B9E', '2017-09-25T14:22:46Z', '49 Westridge Point', null, 'CANCELLED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (119, 'A', 'RD-18A6U', '2018-01-15T22:08:09Z', '6109 Kennedy Court', null, 'CANCELLED');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (120, 'O', 'RD-27O6C', '2017-10-06T11:55:04Z', '590 Golf Terrace', null, 'CANCELLED');

insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (121, 'C', 'RD-34C5U', '2018-06-18T02:58:38Z', '1909 Cascade Drive', 'Hill', 'ACTIVE');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (122, 'B', 'RD-55B4X', '2018-06-18T03:55:21Z', '7 Rigney Parkway', null, 'ACTIVE');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (123, 'C', 'RD-41C0X', '2018-06-18T06:35:58Z', '86986 Mcbride Court', null, 'ACTIVE');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (124, 'A', 'RD-60A5T', '2018-06-18T14:33:37Z', '14649 Manley Park', null, 'ACTIVE');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (125, 'D', 'RD-95D8H', '2018-06-18T09:15:13Z', '50 Magdeline Road', null, 'ACTIVE');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (126, 'A', 'RD-16A9F', '2018-06-18T01:28:09Z', '25241 Bowman Alley', null, 'ACTIVE');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (127, 'A', 'RD-33A1C', '2018-06-18T16:49:43Z', '59864 Rutledge Avenue', null, 'ACTIVE');
insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (128, 'B', 'RD-49B4F', '2018-06-18T06:10:37Z', '43 Longview Crossing', null, 'ACTIVE');

--(51|52|53|59|60|2|5|9|10|11|12|14|17|20|22|23|26|28|31|32|34|36|37|38|40|41|42|44|45|46|47|49|50)

INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (40,1);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (9,2);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (34,3);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (45,4);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (40,5);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (34,6);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (46,7);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (9,8);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (47,9);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (59,10);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (20,11);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (11,12);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (31,13);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (23,14);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (22,15);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (34,16);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (51,17);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (12,18);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (9,19);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (50,20);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (45,21);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (34,22);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (2,23);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (60,24);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (20,25);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (40,26);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (5,27);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (42,28);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (12,29);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (38,30);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (36,31);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (59,32);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (37,33);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (2,34);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (12,35);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (40,36);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (31,37);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (9,38);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (26,39);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (50,40);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (41,41);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (23,42);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (53,43);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (36,44);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (23,45);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (20,46);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (36,47);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (60,48);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (37,49);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (42,50);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (60,51);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (47,52);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (47,53);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (45,54);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (26,55);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (28,56);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (49,57);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (31,58);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (32,59);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (40,60);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (45,61);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (5,62);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (26,63);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (45,64);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (59,65);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (40,66);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (38,67);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (40,68);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (2,69);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (14,70);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (52,71);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (34,72);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (28,73);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (26,74);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (49,75);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (50,76);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (12,77);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (10,78);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (41,79);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (22,80);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (2,81);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (41,82);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (37,83);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (50,84);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (36,85);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (41,86);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (49,87);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (31,88);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (51,89);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (60,90);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (47,91);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (47,92);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (11,93);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (53,94);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (38,95);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (28,96);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (32,97);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (59,98);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (10,99);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (20,100);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (46,101);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (12,102);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (28,103);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (42,104);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (49,105);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (9,106);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (34,107);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (34,108);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (59,109);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (59,110);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (40,111);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (17,112);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (28,113);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (23,114);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (40,115);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (31,116);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (36,117);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (51,118);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (11,119);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (9,120);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (31,121);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (2,122);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (49,123);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (28,124);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (51,125);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (10,125);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (34,126);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (27,127);
INSERT INTO VehicleOperation (vehicleId,operationId) VALUES (17,128);