diff options
| -rw-r--r-- | src/main/resources/sql/testdata.sql | 556 |
1 files changed, 278 insertions, 278 deletions
diff --git a/src/main/resources/sql/testdata.sql b/src/main/resources/sql/testdata.sql index 3cfb0ee..2f9e31e 100644 --- a/src/main/resources/sql/testdata.sql +++ b/src/main/resources/sql/testdata.sql @@ -1,153 +1,153 @@ -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 EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (1, 'Klara Steiner', '1961-03-01', 'NKA', false, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (2, 'Theo Schneider', '1970-11-16', 'RS', false, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (3, 'Cristiano Moser', '1970-12-20', 'RS', false, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (4, 'Ahmad Schneider', '1959-12-09', 'NKV', true, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (5, 'Angel Auer', '1966-03-07', 'NFS', false, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (6, 'Levin Winter', '1963-09-01', 'NKI', true, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (7, 'Koray Bauer', '1969-12-25', 'RS', false, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (8, 'Ceren Steiner', '1987-02-28', 'NKA', true, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (9, 'Eren Schwarz', '1975-03-05', 'RS', true, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (10, 'Sofie Ebner', '1988-01-08', 'NFS', false, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (11, 'Timo Ebner', '1984-11-14', 'NFS', true, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (12, 'Otto Schmidt', '1969-12-25', 'NKA', false, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (13, 'Franz Auer', '1975-06-17', 'RS', false, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (14, 'Livia Schmid', '1974-05-23', 'RS', false, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (15, 'Levin Müller', '1980-12-14', 'RS', true, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (16, 'Ronja Haas', '1955-11-11', 'NFS', false, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (17, 'Alan Maier', '1973-08-19', 'RS', true, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (18, 'Melissa Wieser', '1986-04-21', 'RS', true, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (19, 'Mina Stadler', '1988-09-30', 'RS', true, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (20, 'August Holzer', '1972-01-29', 'RS', false, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (21, 'Gloria Hofer', '1990-05-25', 'RS', true, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (22, 'Mahmud Müller', '1970-04-26', 'NKA', false, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (23, 'Magdalena Koller', '1972-03-08', 'NFS', true, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (24, 'Zoé Moser', '1979-01-26', 'RS', true, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (25, 'Jasper Strasser', '1998-09-07', 'NKI', true, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (26, 'Hannah Leitner', '1965-07-30', 'NKV', false, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (27, 'Metehan Auer', '1986-08-28', 'RS', false, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (28, 'Hüseyin Eder', '1991-01-21', 'NFS', false, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (29, 'Gabriel Pichler', '1970-06-30', 'RS', false, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (30, 'Melina Wimmer', '1955-01-14', 'NKA', false, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (31, 'Felix Holzer', '1969-12-14', 'NKI', true, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (32, 'Leonit Lang', '1989-07-18', 'RS', true, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (33, 'Lorena Maier', '1968-04-25', 'NFS', false, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (34, 'Alejandro Gruber', '1960-11-26', 'RS', false, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (35, 'Angel Lechner', '1982-10-29', 'NKA', false, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (36, 'Natalia Maurer', '1955-08-30', 'RS', false, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (37, 'Iris Schmidt', '1999-01-09', 'RS', true, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (38, 'Lejla Huber', '1986-08-28', 'NFS', true, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (39, 'Bernadette Lechner', '1964-06-26', 'NA', true, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (40, 'Leonis Baumgartner', '1963-06-22', 'NKV', false, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (41, 'Zuzanna Lehner', '1999-11-27', 'RS', false, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (42, 'Charlotte Wieser', '1973-07-28', 'RS', true, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (43, 'Emre Müller', '1955-04-12', 'NKI', true, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (44, 'Ferhat Müller', '1994-09-28', 'RS', true, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (45, 'Eliza Haas', '1963-11-15', 'RS', true, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (46, 'Nils Riegler', '1972-10-02', 'NFS', true, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (47, 'Henry Holzer', '1971-08-14', 'NKI', true, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (48, 'Elise Gruber', '1966-03-31', 'RS', true, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (49, 'Amina Schneider', '1983-09-24', 'RS', false, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (50, 'Halima Holzer', '1972-08-17', 'NFS', true, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (51, 'Laetitia Wieser', '1975-08-24', 'RS', true, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (52, 'Zuzanna Schwarz', '1966-01-16', 'NFS', true, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (53, 'Antonia Reiter', '1973-01-15', 'RS', false, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (54, 'Wojciech Strasser', '1964-02-28', 'NKA', true, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (55, 'Samuel Mayr', '1988-03-03', 'RS', true, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (56, 'Marla Ebner', '1986-01-01', 'NKA', true, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (57, 'Vasilije Mayr', '1969-10-01', 'NKI', false, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (58, 'Simon Reiter', '1984-06-11', 'RS', false, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (59, 'Brian Müller', '1990-01-25', 'NFS', true, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (60, 'Lieselotte Lehner', '1989-02-05', 'RS', false, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (61, 'Aaron Wimmer', '1956-09-19', 'NKV', false, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (62, 'Mahdi Mair', '1963-04-28', 'RS', true, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (63, 'Bogdan Haider', '1983-12-23', 'RS', true, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (64, 'Olivier Schmidt', '1993-06-29', 'RS', false, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (65, 'Anita Stadler', '1956-12-14', 'NKV', false, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (66, 'Stella Riegler', '1972-02-25', 'NA', true, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (67, 'Niklas Ebner', '1984-04-19', 'RS', false, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (68, 'Artur Bauer', '1969-12-27', 'NA', false, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (69, 'Florian Eder', '1957-06-14', 'RS', false, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (70, 'Jennifer Hofer', '1979-12-05', 'NFS', true, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (71, 'Kian Baumgartner', '1992-08-07', 'RS', false, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (72, 'Jakub Mayr', '1959-08-11', 'NFS', false, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (73, 'Melissa Maier', '1988-12-18', 'NFS', false, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (74, 'Agnes Schneider', '1972-04-14', 'NFS', true, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (75, 'Nadin Riegler', '1957-02-18', 'NFS', false, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (76, 'Lian Gruber', '1979-12-14', 'NFS', false, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (77, 'Farhan Mair', '1976-07-07', 'NKA', false, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (78, 'Nicole Haider', '1972-12-10', 'RS', true, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (79, 'Jason Lechner', '1971-08-14', 'RS', false, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (80, 'Amelie Huber', '1997-10-05', 'RS', false, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (81, 'Angelo Holzer', '1961-08-05', 'RS', true, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (82, 'Eda Fischer', '1966-06-21', 'RS', false, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (83, 'Meyra Gruber', '1968-09-17', 'NFS', true, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (84, 'Jelena Haas', '1965-08-14', 'NFS', false, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (85, 'Luca Winter', '1986-03-25', 'NA', false, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (86, 'Ilyas Lechner', '1960-12-16', 'NKI', true, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (87, 'Ayse Wieser', '1999-10-21', 'NFS', true, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (88, 'Esther Leitner', '1969-09-27', 'RS', true, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (89, 'Carl Winkler', '1993-11-19', 'RS', false, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (90, 'Ayleen Gruber', '1956-04-12', 'NFS', false, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (91, 'Lieselotte Müller', '1966-11-25', 'RS', true, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (92, 'Leyla Riegler', '1957-06-12', 'RS', true, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (93, 'Hugo Wieser', '1987-12-22', 'NFS', false, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (94, 'Batuhan Hofer', '1986-01-10', 'NKA', false, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (95, 'Isa Baumgartner', '1988-01-04', 'NFS', true, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (96, 'Johann Fischer', '1973-08-23', 'NKA', false, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (97, 'Kalina Haider', '2000-01-13', 'NFS', false, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (98, 'Alicia Weiss', '1979-05-06', 'RS', true, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (99, 'Amir Winkler', '1980-11-08', 'RS', true, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (100, 'Harun Wolf', '1980-06-14', 'RS', false, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (101, 'Luise Brunner', '1983-12-03', 'NFS', false, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (102, 'Kardelen Ebner', '1993-01-12', 'NKI', false, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (103, 'Katharina Binder', '1956-09-18', 'NFS', false, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (104, 'Hatice Reiter', '1983-04-08', 'RS', false, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (105, 'Tiana Wolf', '1967-08-28', 'RS', true, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (106, 'Tom Reiter', '1976-12-04', 'RS', true, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (107, 'Stella Egger', '1987-08-04', 'NFS', true, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (108, 'Ilyas Huber', '1988-09-30', 'RS', true, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (109, 'Dawid Aigner', '1965-08-30', 'NA', true, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (110, 'Serafina Hofer', '1965-01-31', 'NKA', false, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (111, 'Noel Schwarz', '1976-07-27', 'RS', true, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (112, 'Tarik Eder', '1982-07-10', 'NA', false, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (113, 'Alisa Maurer', '1985-03-19', 'RS', false, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (114, 'Leonora Steiner', '1997-06-02', 'NFS', false, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (115, 'Eldar Baumgartner', '1979-09-25', 'RS', true, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (116, 'Violetta Bauer', '1993-12-27', 'RS', false, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (117, 'Adele Wagner', '1988-06-11', 'RS', true, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (118, 'Eleonore Holzer', '1987-08-04', 'NKA', false, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (119, 'Lias Maier', '1980-11-09', 'RS', false, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (120, 'Noam Wagner', '1955-04-21', 'NKA', true, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (121, 'Amely Maurer', '1987-04-14', 'NFS', true, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (122, 'Mateo Moser', '1967-03-07', 'NFS', false, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (123, 'Anas Weiss', '1966-04-15', 'RS', false, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (124, 'Cansu Schwarz', '1974-06-13', 'RS', true, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (125, 'Hacai Schwarz', '1988-12-21', 'NA', true, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (126, 'Samuel Bauer', '1974-05-02', 'RS', true, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (127, 'Niko Pichler', '1974-01-25', 'RS', false, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (128, 'Romeo Bauer', '1987-06-17', 'RS', false, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (129, 'Marie Koller', '1996-05-22', 'NKI', true, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (130, 'Albert Huber', '1976-08-09', 'RS', false, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (131, 'Isabella Schwarz', '1987-03-02', 'RS', true, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (132, 'Hava Brunner', '1993-05-24', 'RS', false, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (133, 'Ricardo Winter', '1997-07-07', 'NKA', true, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (134, 'Hugo Schuster', '1986-02-07', 'RS', true, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (135, 'Elin Auer', '1977-06-17', 'NFS', true, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (136, 'Philipp Egger', '1969-01-26', 'RS', false, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (137, 'Iva Auer', '1961-10-16', 'RS', false, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (138, 'Elif Brunner', '1991-11-21', 'RS', false, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (139, 'Teresa Schneider', '1967-10-15', 'RS', true, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (140, 'Nour Haider', '1956-12-01', 'NKA', true, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (141, 'Nathalie Winter', '1990-02-12', 'NKA', true, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (142, 'Vladimir Winkler', '1979-01-25', 'NKI', false, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (143, 'Joshua Fuchs', '1979-03-02', 'NFS', true, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (144, 'Yannis Wallner', '1960-12-30', 'NKV', true, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (145, 'Nikola Wagner', '1975-09-05', 'RS', true, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (146, 'Antonia Bauer', '2000-10-11', 'NFS', false, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (147, 'Solomon Lehner', '1960-04-08', 'NFS', false, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (148, 'Youssef Riegler', '1978-04-04', 'RS', false, false); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (149, 'Umut Strasser', '1999-06-01', 'RS', false, true); +insert into EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) values (150, 'Ensar Eder', '1966-11-11', 'NKA', true, true); insert into Employee (id, version) values (1, 1); @@ -527,137 +527,137 @@ insert into Registration (id, vehicleId, employeeId, start, end, active) values 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 (1, 'A', 'RD-10A4V', '2017-12-02T06:12:21Z', 'Ing.-Etzel-Straße 103', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (2, 'A', 'RD-26A6J', '2017-11-13T00:12:45Z', 'Fuggergasse 96', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (3, 'C', 'RD-65C9M', '2017-07-31T19:08:42Z', 'Gsetzbichlweg 128', 'Junction', 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (4, 'A', 'RD-51A8F', '2018-04-15T08:45:33Z', 'Gutenbergstraße 143', 'Park', 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (5, 'C', 'RD-18C3J', '2017-07-25T03:15:18Z', 'Karl-Kapferer-Straße 87', 'Parkway', 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (6, 'A', 'RD-93A4D', '2017-11-07T22:33:38Z', 'Griesauweg 109', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (7, 'O', 'RD-70O3C', '2017-08-16T20:18:10Z', 'Ing.-Etzel-Straße 16', 'Point', 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (8, 'B', 'RD-76B9M', '2017-12-24T18:59:08Z', 'Erlerstraße 52', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (9, 'E', 'RD-40E5B', '2017-11-15T02:23:19Z', 'Gsetzbichlweg 29', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (10, 'O', 'RD-70O2F', '2018-05-20T10:57:13Z', 'Fennerstraße 83', 'Park', 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (11, 'A', 'RD-35A7U', '2018-05-27T04:41:52Z', 'Meinhardstraße 18', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (12, 'A', 'RD-22A8J', '2017-08-11T07:22:54Z', 'Botenthalweg 92', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (13, 'A', 'RD-43A6K', '2017-06-29T00:40:23Z', 'Arzler Straße 148', 'Lane', 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (14, 'C', 'RD-74C8K', '2018-04-03T04:38:37Z', 'Schlerngasse 36', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (15, 'C', 'RD-93C6T', '2017-11-30T18:39:02Z', 'Am Roßsprung 79', 'Place', 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (16, 'D', 'RD-35D8P', '2017-12-08T23:39:15Z', 'Dörrstraße 124', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (17, 'A', 'RD-26A9L', '2017-08-05T18:25:13Z', 'Fallmerayerstraße 105', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (18, 'E', 'RD-57E7X', '2017-08-12T06:26:53Z', 'Feldstraße 67', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (19, 'B', 'RD-84B8A', '2018-06-09T07:45:21Z', 'Philippine-Welser-Straße 16', 'Street', 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (20, 'C', 'RD-99C9L', '2018-04-28T16:41:06Z', 'Schwindstraße 138', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (21, 'C', 'RD-85C9X', '2017-11-01T11:30:21Z', 'Hocheggweg 18', 'Street', 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (22, 'A', 'RD-16A4K', '2018-05-03T01:57:10Z', 'Siegmairstraße 61', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (23, 'B', 'RD-59B5Y', '2017-12-01T13:41:55Z', 'Dr.-Ferdinand-Kogler-Straße 36', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (24, 'C', 'RD-36C4V', '2018-05-02T14:45:08Z', 'Finkenbergweg 83', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (25, 'A', 'RD-54A3B', '2018-01-27T13:02:43Z', 'Innbrücke 116', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (26, 'A', 'RD-00A0Z', '2017-07-05T10:36:42Z', 'Mentlgasse 132', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (27, 'B', 'RD-99B3Z', '2017-10-31T13:58:54Z', 'Brixner Straße 70', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (28, 'E', 'RD-21E4B', '2018-03-06T15:19:53Z', 'Höttinger Gasse 116', 'Alley', 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (29, 'A', 'RD-68A4E', '2017-07-16T11:54:29Z', 'Hirschberggasse 70', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (30, 'A', 'RD-44A9N', '2017-11-16T22:07:30Z', 'Etrichgasse 144', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (31, 'B', 'RD-28B1U', '2017-10-31T23:40:33Z', 'Karl-Rahner-Platz 135', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (32, 'A', 'RD-19A8V', '2017-07-13T02:46:28Z', 'Pechestraße 103', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (33, 'B', 'RD-03B9Q', '2017-08-21T06:54:03Z', 'Luis-Zuegg-Straße 118', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (34, 'A', 'RD-33A0C', '2017-12-16T13:31:21Z', 'Hutterweg 63', 'Parkway', 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (35, 'A', 'RD-54A1E', '2017-11-18T01:08:02Z', 'Universitätsstraße 53', 'Street', 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (36, 'B', 'RD-11B9D', '2017-07-16T14:58:14Z', 'Heiligwasserwiese 6', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (37, 'A', 'RD-20A7H', '2018-04-12T17:25:55Z', 'Ing.-Sigl-Straße 41', 'Lane', 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (38, 'B', 'RD-74B2N', '2018-06-15T15:33:35Z', 'Gumppstraße 78', 'Circle', 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (39, 'A', 'RD-14A2U', '2018-04-13T11:12:04Z', 'Kohlstattgasse 84', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (40, 'O', 'RD-85O8J', '2018-04-07T17:02:42Z', 'Renkstraße 100', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (41, 'B', 'RD-17B8G', '2017-11-12T07:42:07Z', 'Maria-Theresien-Straße 22', 'Center', 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (42, 'B', 'RD-16B1V', '2017-12-14T20:35:48Z', 'Hans-Maier-Straße 103', 'Center', 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (43, 'A', 'RD-99A7V', '2017-06-29T17:17:53Z', 'Glasmalereistraße 124', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (44, 'O', 'RD-61O2F', '2017-07-15T08:41:09Z', 'Angergasse 142', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (45, 'A', 'RD-18A8M', '2017-12-05T14:06:22Z', 'Glasmalereistraße 5', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (46, 'A', 'RD-97A2W', '2017-08-28T20:48:22Z', 'Fritz-Konzert-Straße 99', 'Lane', 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (47, 'A', 'RD-30A3J', '2018-01-26T00:15:01Z', 'Türingstraße 122', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (48, 'O', 'RD-34O4J', '2018-06-01T01:21:24Z', 'Gänsbacherstraße 25', 'Pass', 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (49, 'B', 'RD-18B6R', '2017-07-15T08:15:06Z', 'Bachgasse 39', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (50, 'A', 'RD-36A2Y', '2017-12-29T01:36:29Z', 'Karmelweg 52', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (51, 'A', 'RD-07A3U', '2017-10-23T11:03:53Z', 'Gsturnsteig 81', 'Place', 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (52, 'O', 'RD-62O3Y', '2018-04-05T00:45:16Z', 'Klostergasse 17', 'Center', 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (53, 'A', 'RD-18A7D', '2017-10-17T00:32:46Z', 'Hugo-Wolf-Straße 29', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (54, 'A', 'RD-11A4A', '2017-09-20T03:12:38Z', 'Grenobler Brücke 133', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (55, 'A', 'RD-30A2Y', '2017-11-06T08:00:24Z', 'Montessoristraße 83', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (56, 'A', 'RD-17A3R', '2017-12-30T16:55:12Z', 'Technikerstraße 128', 'Parkway', 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (57, 'O', 'RD-18O4D', '2018-02-04T12:33:46Z', 'Weingartnerstraße 137', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (58, 'A', 'RD-25A8I', '2017-09-26T20:36:01Z', 'Badgasse 116', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (59, 'B', 'RD-20B1G', '2018-04-05T04:58:38Z', 'Ing.-Thommen-Straße 12', 'Point', 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (60, 'A', 'RD-14A9B', '2017-06-27T04:49:09Z', 'Domanigweg 32', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (61, 'A', 'RD-03A6S', '2017-09-10T00:46:34Z', 'Schmerlingstraße 43', 'Place', 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (62, 'O', 'RD-41O3V', '2017-07-06T02:08:29Z', 'Gerhild-Diesner-Straße 84', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (63, 'O', 'RD-36O6T', '2018-04-20T08:06:43Z', 'Nageletal 81', 'Park', 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (64, 'A', 'RD-42A2T', '2017-09-24T16:11:48Z', 'Herzog-Siegmund-Ufer 127', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (65, 'A', 'RD-21A9L', '2018-06-11T06:03:37Z', 'Anni-Kraus-Weg 72', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (66, 'C', 'RD-89C5M', '2018-03-10T16:46:56Z', 'Schmelzergasse 100', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (67, 'A', 'RD-10A6K', '2018-05-18T15:17:28Z', 'Alois-Schrott-Straße 83', 'Way', 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (68, 'C', 'RD-09C7S', '2018-03-08T18:52:12Z', 'Falkstraße 97', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (69, 'B', 'RD-75B8D', '2017-09-26T00:11:54Z', 'Olympiabrücke 145', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (70, 'O', 'RD-43O2V', '2017-09-02T02:56:49Z', 'Gilmstraße 126', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (71, 'A', 'RD-24A0R', '2017-09-04T14:27:20Z', 'Wurmbachweg 98', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (72, 'B', 'RD-82B3A', '2018-06-03T20:09:15Z', 'Helfentalweg 148', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (73, 'A', 'RD-59A3A', '2017-11-11T20:43:16Z', 'Gehrnweg 102', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (74, 'B', 'RD-98B1G', '2017-06-20T12:39:45Z', 'Ing.-Thommen-Straße 77', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (75, 'A', 'RD-61A5L', '2018-03-09T18:55:16Z', 'Feldstraße 138', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (76, 'B', 'RD-72B8U', '2018-04-27T22:48:48Z', 'Schullernstraße 91', 'Point', 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (77, 'C', 'RD-63C3M', '2018-04-18T02:49:03Z', 'Stadtpark Rapoldi 26', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (78, 'A', 'RD-03A9D', '2017-10-20T16:01:25Z', 'Heiligwasserweg 38', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (79, 'A', 'RD-62A5V', '2018-01-02T14:59:58Z', 'Grätschenwinkelweg 146', 'Street', 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (80, 'B', 'RD-36B2C', '2018-04-11T00:56:22Z', 'Mandelsbergerstraße 46', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (81, 'A', 'RD-19A7E', '2018-05-05T00:17:49Z', 'Helga-Krismer-Platz 131', 'Avenue', 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (82, 'B', 'RD-90B8G', '2017-08-06T00:47:06Z', 'Schlachthofgasse 122', 'Circle', 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (83, 'A', 'RD-28A0V', '2018-01-19T13:36:34Z', 'Haydnplatz 18', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (84, 'A', 'RD-71A0B', '2018-01-09T15:30:57Z', 'Rennweg 47', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (85, 'B', 'RD-49B7X', '2018-02-07T18:46:02Z', 'Otto-Gamper-Weg 34', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (86, 'B', 'RD-55B0F', '2018-02-02T03:23:51Z', 'Ing.-Sigl-Straße 104', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (87, 'A', 'RD-79A5X', '2017-08-02T02:50:44Z', 'Brixner Straße 123', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (88, 'A', 'RD-04A7T', '2017-11-06T07:18:03Z', 'Wilhelm-Greil-Straße 40', 'Way', 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (89, 'C', 'RD-85C1G', '2017-12-17T18:50:36Z', 'Stiftgasse 48', 'Place', 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (90, 'O', 'RD-40O9Z', '2017-11-19T08:07:26Z', 'Europaratsallee 73', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (91, 'C', 'RD-08C4Z', '2018-03-21T02:49:58Z', 'Mühlauer Brücke 76', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (92, 'A', 'RD-13A5U', '2017-09-29T05:21:06Z', 'Habichtstraße 92', 'Circle', 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (93, 'B', 'RD-02B2E', '2017-08-04T17:00:43Z', 'Brandjochstraße 134', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (94, 'A', 'RD-11A9X', '2017-08-27T23:59:41Z', 'Gaswerkstraße 53', 'Avenue', 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (95, 'B', 'RD-95B6D', '2018-01-07T01:49:50Z', 'Wiesengasse 131', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (96, 'A', 'RD-47A7T', '2017-07-02T09:57:56Z', 'Hocheggweg 32', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (97, 'O', 'RD-78O1Z', '2017-12-10T15:02:21Z', 'Robert-Stolz-Weg 22', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (98, 'A', 'RD-72A5Y', '2017-12-23T10:48:06Z', 'Klammstraße 111', 'Point', 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (99, 'C', 'RD-78C4D', '2017-12-26T03:29:27Z', 'Karmelitergasse 56', null, 'COMPLETED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (100, 'A', 'RD-17A9I', '2017-10-05T17:45:19Z', 'Lohbachweg C 97', '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 (101, 'A', 'RD-74A1G', '2018-02-05T15:37:44Z', 'Etrichgasse 109', null, 'CANCELLED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (102, 'B', 'RD-15B1U', '2017-10-20T04:54:38Z', 'Lindenhof 14', null, 'CANCELLED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (103, 'O', 'RD-62O0B', '2018-02-05T12:18:43Z', 'Sillgasse 113', 'Court', 'CANCELLED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (104, 'A', 'RD-45A0Y', '2018-05-17T17:08:18Z', 'Schlerngasse 7', null, 'CANCELLED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (105, 'A', 'RD-42A8G', '2018-05-03T01:52:39Z', 'König-Laurin-Straße 65', null, 'CANCELLED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (106, 'O', 'RD-03O0G', '2018-01-21T17:21:12Z', 'Maria-Theresien-Straße 25', null, 'CANCELLED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (107, 'A', 'RD-94A0W', '2017-11-08T06:11:31Z', 'Kirchgasse 43', null, 'CANCELLED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (108, 'A', 'RD-18A1E', '2018-02-20T15:51:48Z', 'Dreiheiligenstraße 50', null, 'CANCELLED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (109, 'A', 'RD-11A2I', '2018-02-07T06:42:04Z', 'Höttinger Au 123', null, 'CANCELLED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (110, 'O', 'RD-78O0A', '2018-01-02T21:11:05Z', 'Hans-Brenner-Platz 68', null, 'CANCELLED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (111, 'B', 'RD-70B6R', '2017-11-23T11:35:51Z', 'Girglweg 49', 'Road', 'CANCELLED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (112, 'B', 'RD-95B9K', '2018-02-03T06:44:16Z', 'Johannesgasse 77', null, 'CANCELLED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (113, 'A', 'RD-58A3E', '2017-08-18T08:46:01Z', 'Gsetzbichlweg 91', null, 'CANCELLED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (114, 'B', 'RD-58B5V', '2017-06-19T12:47:16Z', 'Knollerstraße 146', null, 'CANCELLED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (115, 'A', 'RD-93A3V', '2018-03-04T16:46:37Z', 'Oberntalweg 10', null, 'CANCELLED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (116, 'B', 'RD-25B6N', '2018-01-05T13:49:50Z', 'Josef-Franz-Huter-Straße 5', null, 'CANCELLED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (117, 'A', 'RD-01A3J', '2017-08-08T05:23:13Z', 'Bürgerstraße 113', null, 'CANCELLED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (118, 'B', 'RD-70B9E', '2017-09-25T14:22:46Z', 'Montessoristraße 146', null, 'CANCELLED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (119, 'A', 'RD-18A6U', '2018-01-15T22:08:09Z', 'Gänsbacherstraße 148', null, 'CANCELLED'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (120, 'O', 'RD-27O6C', '2017-10-06T11:55:04Z', 'Arthur-Haidl-Promenade 17', 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'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (121, 'C', 'RD-34C5U', '2018-06-18T02:58:38Z', 'Schulgasse 23', 'Hill', 'ACTIVE'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (122, 'B', 'RD-55B4X', '2018-06-18T03:55:21Z', 'Gerhart-Hauptmann-Straße 85', null, 'ACTIVE'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (123, 'C', 'RD-41C0X', '2018-06-18T06:35:58Z', 'Hafelekar 132', null, 'ACTIVE'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (124, 'A', 'RD-60A5T', '2018-06-18T14:33:37Z', 'Renkstraße 120', null, 'ACTIVE'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (125, 'D', 'RD-95D8H', '2018-06-18T09:15:13Z', 'Herzog-Friedrich-Straße 81', null, 'ACTIVE'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (126, 'A', 'RD-16A9F', '2018-06-18T01:28:09Z', 'Josef-Wilberger-Straße 7', null, 'ACTIVE'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (127, 'A', 'RD-33A1C', '2018-06-18T16:49:43Z', 'Sparkassenplatz 133', null, 'ACTIVE'); +insert into Operation (id, severity, opCode, created, destination, additionalInfo, status) values (128, 'B', 'RD-49B4F', '2018-06-18T06:10:37Z', 'Höhenstraße 27', 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) |