SHARE
TWEET

Filling_db_Airport

a guest Mar 20th, 2017 63 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. set DATEFORMAT dmy
  2.  
  3. IF OBJECT_ID('Flight', 'U') IS NOT NULL
  4. DELETE FROM Flight;
  5. DBCC CHECKIDENT ('Flight', RESEED, 1);
  6. IF OBJECT_ID('Airline', 'U') IS NOT NULL
  7. DELETE FROM Airline;
  8. DBCC CHECKIDENT ('Airline', RESEED, 1);
  9. IF OBJECT_ID('Airport', 'U') IS NOT NULL
  10. DELETE FROM Airport;
  11. DBCC CHECKIDENT ('Airport', RESEED, 1);
  12. IF OBJECT_ID('City', 'U') IS NOT NULL
  13. DELETE FROM City;
  14. DBCC CHECKIDENT ('City', RESEED, 1);
  15. IF OBJECT_ID('Country', 'U') IS NOT NULL
  16. DELETE FROM Country;
  17. DBCC CHECKIDENT ('Country', RESEED, 1);
  18. IF OBJECT_ID('Configuration_names', 'U') IS NOT NULL
  19. DELETE FROM Configuration_names;
  20. DBCC CHECKIDENT ('Configuration_names', RESEED, 1);
  21. IF OBJECT_ID('Types_of_classes', 'U') IS NOT NULL
  22. DELETE FROM Types_of_classes;
  23. DBCC CHECKIDENT ('Types_of_classes', RESEED, 1);
  24. IF OBJECT_ID('Status_characteristics', 'U') IS NOT NULL
  25. DELETE FROM Status_characteristics;
  26. DBCC CHECKIDENT ('Status_characteristics', RESEED, 1);
  27.  
  28. INSERT INTO Country (name) VALUES ('Russia');
  29. INSERT INTO Country (name) VALUES ('USA');
  30. INSERT INTO Country (name) VALUES ('Ukraine');
  31. INSERT INTO Country (name) VALUES ('China');
  32. INSERT INTO Country (name) VALUES ('Australia');
  33. INSERT INTO Country (name) VALUES ('Germany');
  34. INSERT INTO Country (name) VALUES ('France');
  35. INSERT INTO Country (name) VALUES ('United Kingdom');
  36. INSERT INTO Country (name) VALUES ('Greece');
  37. INSERT INTO Country (name) VALUES ('Italy');
  38. INSERT INTO Country (name) VALUES ('Canada');
  39.  
  40. INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('Moscow', 3, dbo.id_of_country('Russia'));
  41. INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('Omsk', 6, dbo.id_of_country('Russia'));
  42. INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('Novosibirsk', 6, dbo.id_of_country('Russia'));
  43. INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('Tyumen', 5, dbo.id_of_country('Russia'));
  44. INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('Yekaterinburg', 5, dbo.id_of_country('Russia'));
  45. INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('Krasnoyarsk', 7, dbo.id_of_country('Russia'));
  46. INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('Vladivostok', 10, dbo.id_of_country('Russia'));
  47. INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('Vancouver', -8, dbo.id_of_country('Canada'));
  48. INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('Chicago', -6, dbo.id_of_country('USA'));
  49. INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('Los Angeles', -8, dbo.id_of_country('USA'));
  50. INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('New York', -5, dbo.id_of_country('USA'));
  51. INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('Kiev', 2, dbo.id_of_country('Ukraine'));
  52. INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('Beijing', 8, dbo.id_of_country('China'));
  53. INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('Sydney', 10, dbo.id_of_country('Australia'));
  54. INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('Berlin', 1, dbo.id_of_country('Germany'));
  55. INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('Munich', 1, dbo.id_of_country('Germany'));
  56. INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('Paris', 1, dbo.id_of_country('France'));
  57. INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('London', 0, dbo.id_of_country('United Kingdom'));
  58. INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('Athens', 2, dbo.id_of_country('Greece'));
  59. INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('Rome', 1, dbo.id_of_country('Italy'));
  60. INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('Sochi', 3, dbo.id_of_country('Russia'));
  61.  
  62. INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Domodedovo', 'UUDD', dbo.id_of_city('Moscow'));
  63. INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Sheremetyevo', 'UUEE', dbo.id_of_city('Moscow'));
  64. INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Vnukovo', 'UUWW', dbo.id_of_city('Moscow'));
  65. INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Tsentralnyy', 'UNOO', dbo.id_of_city('Omsk'));
  66. INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Tolmachevo', 'UNNT', dbo.id_of_city('Novosibirsk'));
  67. INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Roschino', 'USTR', dbo.id_of_city('Tyumen'));
  68. INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Koltsovo', 'UNKE', dbo.id_of_city('Yekaterinburg'));
  69. INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Emelyanovo', 'UNKL', dbo.id_of_city('Krasnoyarsk'));
  70. INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Knevichi', 'UHWW', dbo.id_of_city('Vladivostok'));
  71. INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Sochi', 'URSS', dbo.id_of_city('Sochi'));
  72. INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Boundary Bay', 'CZBB', dbo.id_of_city('Vancouver'));
  73. INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Chicago FSS', 'KCHI', dbo.id_of_city('Chicago'));
  74. INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Los Angeles International', 'KLAX', dbo.id_of_city('Los Angeles'));
  75. INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('New York John F. Kennedy International Airport', 'KJFK', dbo.id_of_city('New York'));
  76. INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Zhulhany', 'UKKK', dbo.id_of_city('Kiev'));
  77. INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Beijing Capital Int.', 'ZBAA', dbo.id_of_city('Beijing'));
  78. INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Kingsford Smith Airport', 'YSSY', dbo.id_of_city('Sydney'));
  79. INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Schoenefeld', 'EDDB', dbo.id_of_city('Berlin'));
  80. INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Le Bourget', 'LFPB', dbo.id_of_city('Paris'));
  81. INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Paris Orly Airport', 'LFPO', dbo.id_of_city('Paris'));
  82. INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('London Heathrow', 'EGLL', dbo.id_of_city('London'));
  83. INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('London Luton Airport', 'EGGW', dbo.id_of_city('London'));
  84. INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Athens', 'KAHN', dbo.id_of_city('Athens'));
  85. INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Leonardo da Vinci International', 'LIRF', dbo.id_of_city('Rome'));
  86. INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Munich Airport', 'EDDM', dbo.id_of_city('Munich'));
  87.  
  88. INSERT INTO Airline (name, base_airport_id) VALUES ('S7 Airlines', dbo.id_of_airport('Tolmachevo'));
  89. INSERT INTO Airline (name, base_airport_id) VALUES ('Aeroflot - Russian Airlines', dbo.id_of_airport('Sheremetyevo'));
  90. INSERT INTO Airline (name, base_airport_id) VALUES ('Transaero', dbo.id_of_airport('Domodedovo'));
  91. INSERT INTO Airline (name, base_airport_id) VALUES ('Red Wings', dbo.id_of_airport('Domodedovo'));
  92. INSERT INTO Airline (name, base_airport_id) VALUES ('UTair', dbo.id_of_airport('Roschino'));
  93. INSERT INTO Airline (name, base_airport_id) VALUES ('Pobeda', dbo.id_of_airport('Vnukovo'));
  94. INSERT INTO Airline (name, base_airport_id) VALUES ('Lufthansa', dbo.id_of_airport('Munich Airport'));
  95. INSERT INTO Airline (name, base_airport_id) VALUES ('Air France', dbo.id_of_airport('Paris Orly Airport'));
  96. INSERT INTO Airline (name, base_airport_id) VALUES ('EasyJet', dbo.id_of_airport('London Luton Airport'));
  97. INSERT INTO Airline (name, base_airport_id) VALUES ('Delta Air Lines', dbo.id_of_airport('New York John F. Kennedy International Airport'));
  98. INSERT INTO Airline (name, base_airport_id) VALUES ('American Airlines', dbo.id_of_airport('New York John F. Kennedy International Airport'));
  99. INSERT INTO Airline (name, base_airport_id) VALUES ('Qantas', dbo.id_of_airport('Kingsford Smith Airport'));
  100.  
  101. INSERT INTO Types_of_classes (name) VALUES ('Economy');
  102. INSERT INTO Types_of_classes (name) VALUES ('Premium economy');
  103. INSERT INTO Types_of_classes (name) VALUES ('Business');
  104. INSERT INTO Types_of_classes (name) VALUES ('First');
  105.  
  106. INSERT INTO Configuration_names (name_of_configuration) VALUES ('A319_1');
  107. INSERT INTO Configuration_names (name_of_configuration) VALUES ('A319_2');
  108. INSERT INTO Configuration_names (name_of_configuration) VALUES ('A320_1');
  109. INSERT INTO Configuration_names (name_of_configuration) VALUES ('A320_2');
  110. INSERT INTO Configuration_names (name_of_configuration) VALUES ('A320_3');
  111. INSERT INTO Configuration_names (name_of_configuration) VALUES ('A330-200_1');
  112. INSERT INTO Configuration_names (name_of_configuration) VALUES ('A330-200_2');
  113. INSERT INTO Configuration_names (name_of_configuration) VALUES ('A330-200_3');
  114. INSERT INTO Configuration_names (name_of_configuration) VALUES ('A330-300_1');
  115. INSERT INTO Configuration_names (name_of_configuration) VALUES ('A330-300_2');
  116. INSERT INTO Configuration_names (name_of_configuration) VALUES ('A330-300_3');
  117. INSERT INTO Configuration_names (name_of_configuration) VALUES ('A380_1');
  118. INSERT INTO Configuration_names (name_of_configuration) VALUES ('A380_2');
  119. INSERT INTO Configuration_names (name_of_configuration) VALUES ('B737-300_1');
  120. INSERT INTO Configuration_names (name_of_configuration) VALUES ('B737-300_2');
  121. INSERT INTO Configuration_names (name_of_configuration) VALUES ('B737-900_1');
  122. INSERT INTO Configuration_names (name_of_configuration) VALUES ('B737-900_2');
  123. INSERT INTO Configuration_names (name_of_configuration) VALUES ('B747-400_1');
  124. INSERT INTO Configuration_names (name_of_configuration) VALUES ('B747-400_2');
  125. INSERT INTO Configuration_names (name_of_configuration) VALUES ('B747-400_3');
  126. INSERT INTO Configuration_names (name_of_configuration) VALUES ('B767-300_1');
  127. INSERT INTO Configuration_names (name_of_configuration) VALUES ('B767-300_2');
  128. INSERT INTO Configuration_names (name_of_configuration) VALUES ('B767-300_3');
  129. INSERT INTO Configuration_names (name_of_configuration) VALUES ('B777-300_1');
  130. INSERT INTO Configuration_names (name_of_configuration) VALUES ('B777-300_2');
  131. INSERT INTO Configuration_names (name_of_configuration) VALUES ('B777-300_3');
  132. INSERT INTO Configuration_names (name_of_configuration) VALUES ('B787-9_1');
  133. INSERT INTO Configuration_names (name_of_configuration) VALUES ('B787-9_2');
  134. INSERT INTO Configuration_names (name_of_configuration) VALUES ('B787-9_3');
  135. INSERT INTO Configuration_names (name_of_configuration) VALUES ('Ту-204-100_1');
  136. INSERT INTO Configuration_names (name_of_configuration) VALUES ('Ту-204-100_2');
  137. INSERT INTO Configuration_names (name_of_configuration) VALUES ('Ту-204-100_3');
  138.  
  139.  
  140.  
  141. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('A319_1'), dbo.id_of_type('Business'), 20);
  142. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('A319_1'), dbo.id_of_type('Economy'), 96);
  143. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('A319_2'), dbo.id_of_type('Economy'), 156);
  144. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('A320_1'), dbo.id_of_type('Business'), 20);
  145. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('A320_1'), dbo.id_of_type('Economy'), 120);
  146. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('A320_2'), dbo.id_of_type('Business'), 12);
  147. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('A320_2'), dbo.id_of_type('Economy'), 138);
  148. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('A320_3'), dbo.id_of_type('Economy'), 174);
  149. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('A330_200_1'), dbo.id_of_type('Economy'), 406);
  150. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('A330_200_2'), dbo.id_of_type('Business'), 34);
  151. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('A330_200_2'), dbo.id_of_type('Economy'), 259);
  152. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('A330_200_3'), dbo.id_of_type('First'), 8);
  153. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('A330_200_3'), dbo.id_of_type('Business'), 28);
  154. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('A330_200_3'), dbo.id_of_type('Economy'), 217);
  155. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('A330_300_1'), dbo.id_of_type('Economy'), 440);
  156. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('A330_300_2'), dbo.id_of_type('Business'), 42);
  157. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('A330_300_2'), dbo.id_of_type('Economy'), 293);
  158. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('A330_300_3'), dbo.id_of_type('First'), 8);
  159. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('A330_300_3'), dbo.id_of_type('Business'), 36);
  160. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('A330_300_3'), dbo.id_of_type('Economy'), 249);
  161. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('A380_1'), dbo.id_of_type('Economy'), 700);
  162. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('A380_2'), dbo.id_of_type('First'), 14);
  163. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('A380_2'), dbo.id_of_type('Business'), 72);
  164. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('A380_2'), dbo.id_of_type('Premium economy'), 26);
  165. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('A380_2'), dbo.id_of_type('Economy'), 433);
  166. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('B737-300_1'), dbo.id_of_type('Business'), 20);
  167. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('B737-300_1'), dbo.id_of_type('Economy'), 108);
  168. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('B737-300_2'), dbo.id_of_type('Economy'), 149);
  169. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('B737-900_1'), dbo.id_of_type('Business'), 10);
  170. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('B737-900_1'), dbo.id_of_type('Economy'), 167);
  171. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('B737-900_2'), dbo.id_of_type('Economy'), 189);
  172. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('B747-400_1'), dbo.id_of_type('Economy'), 660);
  173. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('B747-400_2'), dbo.id_of_type('Business'), 34);
  174. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('B747-400_2'), dbo.id_of_type('Economy'), 490);
  175. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('B747-400_3'), dbo.id_of_type('First'), 8);
  176. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('B747-400_3'), dbo.id_of_type('Business'), 28);
  177. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('B747-400_3'), dbo.id_of_type('Economy'), 380);
  178. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('B767-300_1'), dbo.id_of_type('Economy'), 328);
  179. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('B767-300_2'), dbo.id_of_type('Business'), 18);
  180. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('B767-300_2'), dbo.id_of_type('Economy'), 251);
  181. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('B767-300_3'), dbo.id_of_type('First'), 10);
  182. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('B767-300_3'), dbo.id_of_type('Business'), 18);
  183. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('B767-300_3'), dbo.id_of_type('Economy'), 190);
  184. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('B777-300_1'), dbo.id_of_type('Economy'), 550);
  185. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('B777-300_2'), dbo.id_of_type('Business'), 20);
  186. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('B777-300_2'), dbo.id_of_type('Economy'), 459);
  187. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('B777-300_3'), dbo.id_of_type('First'), 10);
  188. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('B777-300_3'), dbo.id_of_type('Business'), 16);
  189. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('B777-300_3'), dbo.id_of_type('Economy'), 342);
  190. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('B787-9_1'), dbo.id_of_type('Economy'), 406);
  191. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('B787-9_2'), dbo.id_of_type('Business'), 40);
  192. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('B787-9_2'), dbo.id_of_type('Economy'), 250);
  193. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('B787-9_3'), dbo.id_of_type('First'), 4);
  194. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('B787-9_3'), dbo.id_of_type('Business'), 32);
  195. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('B787-9_3'), dbo.id_of_type('Economy'), 244);
  196. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('Ту-204-100_1'), dbo.id_of_type('Economy'), 214);
  197. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('Ту-204-100_2'), dbo.id_of_type('Business'), 24);
  198. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('Ту-204-100_2'), dbo.id_of_type('Economy'), 172);
  199. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('Ту-204-100_3'), dbo.id_of_type('First'), 4);
  200. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('Ту-204-100_3'), dbo.id_of_type('Business'), 16);
  201. INSERT INTO Configuration (configuration_id, [type_id], number_of_seats) VALUES (dbo.id_of_configuration_name('Ту-204-100_3'), dbo.id_of_type('Economy'), 170);
  202.  
  203.  
  204. INSERT INTO Aircraft (aircarft_model, cruising_speed, range_of_flight, max_takeoff_weight) VALUES ('Airbus A319', 900, 6800, 68000);
  205. INSERT INTO Aircraft (aircarft_model, cruising_speed, range_of_flight, max_takeoff_weight) VALUES ('Airbus A320', 840, 5550, 77000);
  206. INSERT INTO Aircraft (aircarft_model, cruising_speed, range_of_flight, max_takeoff_weight) VALUES ('Airbus A330-200', 870, 12100, 233000);
  207. INSERT INTO Aircraft (aircarft_model, cruising_speed, range_of_flight, max_takeoff_weight) VALUES ('Airbus A330-300', 870, 10400, 233000);
  208. INSERT INTO Aircraft (aircarft_model, cruising_speed, range_of_flight, max_takeoff_weight) VALUES ('Airbus A380', 905, 15000, 560000);
  209. INSERT INTO Aircraft (aircarft_model, cruising_speed, range_of_flight, max_takeoff_weight) VALUES ('Boeing 737-300', 795, 2900, 63000);
  210. INSERT INTO Aircraft (aircarft_model, cruising_speed, range_of_flight, max_takeoff_weight) VALUES ('Boeing 737-900', 850, 5080, 79000);
  211. INSERT INTO Aircraft (aircarft_model, cruising_speed, range_of_flight, max_takeoff_weight) VALUES ('Boeing 747-400', 920, 13430, 396000);
  212. INSERT INTO Aircraft (aircarft_model, cruising_speed, range_of_flight, max_takeoff_weight) VALUES ('Boeing 767-300', 850, 9700, 158000);
  213. INSERT INTO Aircraft (aircarft_model, cruising_speed, range_of_flight, max_takeoff_weight) VALUES ('Boeing 777-300', 905, 11000, 299000);
  214. INSERT INTO Aircraft (aircarft_model, cruising_speed, range_of_flight, max_takeoff_weight) VALUES ('Boeing 787-9', 900, 14100, 254000);
  215. INSERT INTO Aircraft (aircarft_model, cruising_speed, range_of_flight, max_takeoff_weight) VALUES ('Туполев Ту-204-100', 810, 6900, 103000);
  216.  
  217. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('RA-00001', 'Airbus A319', dbo.id_of_configuration_name('A319_1'));
  218. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('D-AAAA', 'Airbus A319', dbo.id_of_configuration_name('A319_1'));
  219. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('RA-00003', 'Airbus A319', dbo.id_of_configuration_name('A319_2'));
  220. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('F-AAAA', 'Airbus A319', dbo.id_of_configuration_name('A319_1'));
  221. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('RA-00005', 'Airbus A319', dbo.id_of_configuration_name('A319_2'));
  222. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('RA-00006', 'Airbus A320', dbo.id_of_configuration_name('A320_1'));
  223. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('RA-00007', 'Airbus A320', dbo.id_of_configuration_name('A320_2'));
  224. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('G-AAAA', 'Airbus A320', dbo.id_of_configuration_name('A320_3'));
  225. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('RA-00009', 'Airbus A320', dbo.id_of_configuration_name('A320_3'));
  226. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('RA-00010', 'Airbus A320', dbo.id_of_configuration_name('A320_2'));
  227. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('N1', 'Airbus A330-200', dbo.id_of_configuration_name('A330-200_1'));
  228. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('RA-00012', 'Airbus A330-200', dbo.id_of_configuration_name('A330-200_2'));
  229. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('RA-00013', 'Airbus A330-200', dbo.id_of_configuration_name('A330-200_3'));
  230. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('VH-AAA', 'Airbus A330-300', dbo.id_of_configuration_name('A330-300_1'));
  231. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('RA-00015', 'Airbus A330-300', dbo.id_of_configuration_name('A330-300_2'));
  232. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('F-AAAB', 'Airbus A330-300', dbo.id_of_configuration_name('A330-300_3'));
  233. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('N2', 'Airbus A380', dbo.id_of_configuration_name('A380_1'));
  234. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('RA-00018', 'Airbus A380', dbo.id_of_configuration_name('A380_2'));
  235. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('D-AAAB', 'Airbus A380', dbo.id_of_configuration_name('A380_1'));
  236. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('RA-00101', 'Boeing 737-300', dbo.id_of_configuration_name('B737-300_1'));
  237. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('G-AABB', 'Boeing 737-300', dbo.id_of_configuration_name('B737-300_1'));
  238. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('F-ABAB', 'Boeing 737-300', dbo.id_of_configuration_name('B737-300_2'));
  239. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('N101', 'Boeing 737-300', dbo.id_of_configuration_name('B737-300_2'));
  240. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('RA-00102', 'Boeing 737-300', dbo.id_of_configuration_name('B737-300_1'));
  241. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('RA-00115', 'Boeing 737-900', dbo.id_of_configuration_name('B737-900_2'));
  242. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('G-AABC', 'Boeing 737-900', dbo.id_of_configuration_name('B737-900_1'));
  243. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('F-ABAC', 'Boeing 737-900', dbo.id_of_configuration_name('B737-900_1'));
  244. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('N105', 'Boeing 737-900', dbo.id_of_configuration_name('B737-900_2'));
  245. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('D-AABA', 'Boeing 737-900', dbo.id_of_configuration_name('B737-900_2'));
  246. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('RA-01105', 'Boeing 747-400', dbo.id_of_configuration_name('B747-400_1'));
  247. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('G-CCBB', 'Boeing 747-400', dbo.id_of_configuration_name('B747-400_2'));
  248. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('F-ABCB', 'Boeing 747-400', dbo.id_of_configuration_name('B747-400_3'));
  249. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('N108', 'Boeing 747-400', dbo.id_of_configuration_name('B747-400_2'));
  250. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('VH-AAB', 'Boeing 747-400', dbo.id_of_configuration_name('B747-400_1'));
  251. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('RA-00125', 'Boeing 767-300', dbo.id_of_configuration_name('B767-300_3'));
  252. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('D-ACBB', 'Boeing 767-300', dbo.id_of_configuration_name('B767-300_3'));
  253. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('F-ACAB', 'Boeing 767-300', dbo.id_of_configuration_name('B767-300_2'));
  254. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('N151', 'Boeing 767-300', dbo.id_of_configuration_name('B767-300_1'));
  255. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('RA-00126', 'Boeing 767-300', dbo.id_of_configuration_name('B767-300_2'));
  256. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('RA-00131', 'Boeing 777-300', dbo.id_of_configuration_name('B777-300_3'));
  257. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('VH-ABC', 'Boeing 777-300', dbo.id_of_configuration_name('B777-300_1'));
  258. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('D-ACCB', 'Boeing 777-300', dbo.id_of_configuration_name('B777-300_1'));
  259. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('N180', 'Boeing 777-300', dbo.id_of_configuration_name('B777-300_3'));
  260. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('RA-00180', 'Boeing 777-300', dbo.id_of_configuration_name('B777-300_2'));
  261. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('RA-00201', 'Boeing 787-9', dbo.id_of_configuration_name('B787-9_1'));
  262. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('D-ACCC', 'Boeing 787-9', dbo.id_of_configuration_name('B787-9_2'));
  263. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('N-210', 'Boeing 787-9', dbo.id_of_configuration_name('B787-9_3'));
  264. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('N205', 'Boeing 787-9', dbo.id_of_configuration_name('B787-9_3'));
  265. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('RA-00202', 'Boeing 787-9', dbo.id_of_configuration_name('B787-9_3'));
  266. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('RA-01001', 'Туполев Ту-204-100', dbo.id_of_configuration_name('Ту-204-100_1'));
  267. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('RA-01003', 'Туполев Ту-204-100', dbo.id_of_configuration_name('Ту-204-100_1'));
  268. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('RA-01540', 'Туполев Ту-204-100', dbo.id_of_configuration_name('Ту-204-100_1'));
  269. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('RA-01210', 'Туполев Ту-204-100', dbo.id_of_configuration_name('Ту-204-100_2'));
  270. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('RA-01305', 'Туполев Ту-204-100', dbo.id_of_configuration_name('Ту-204-100_1'));
  271. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('RA-01546', 'Туполев Ту-204-100', dbo.id_of_configuration_name('Ту-204-100_3'));
  272. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('RA-02038', 'Туполев Ту-204-100', dbo.id_of_configuration_name('Ту-204-100_2'));
  273. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('RA-03021', 'Туполев Ту-204-100', dbo.id_of_configuration_name('Ту-204-100_2'));
  274. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('RA-05400', 'Туполев Ту-204-100', dbo.id_of_configuration_name('Ту-204-100_2'));
  275. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('RA-06840', 'Туполев Ту-204-100', dbo.id_of_configuration_name('Ту-204-100_3'));
  276. INSERT INTO Airplane (airplane_id, aircarft_model, configuration_id) VALUES ('RA-00568', 'Туполев Ту-204-100', dbo.id_of_configuration_name('Ту-204-100_1'));
  277.  
  278. INSERT INTO Status_characteristics (сompleteness_of_filling) VALUES ('full');
  279. INSERT INTO Status_characteristics (сompleteness_of_filling) VALUES ('full');
  280. INSERT INTO Status_characteristics (сompleteness_of_filling) VALUES ('full');
  281. INSERT INTO Status_characteristics (сompleteness_of_filling) VALUES ('full');
  282. INSERT INTO Status_characteristics (сompleteness_of_filling) VALUES ('full');
  283. INSERT INTO Status_characteristics (сompleteness_of_filling) VALUES ('almost full');
  284. INSERT INTO Status_characteristics (сompleteness_of_filling) VALUES ('almost full');
  285. INSERT INTO Status_characteristics (сompleteness_of_filling) VALUES ('almost full');
  286. INSERT INTO Status_characteristics (сompleteness_of_filling) VALUES ('almost full');
  287. INSERT INTO Status_characteristics (сompleteness_of_filling) VALUES ('almost full');
  288. INSERT INTO Status_characteristics (сompleteness_of_filling) VALUES ('almost empty');
  289. INSERT INTO Status_characteristics (сompleteness_of_filling) VALUES ('almost empty');
  290. INSERT INTO Status_characteristics (сompleteness_of_filling) VALUES ('almost empty');
  291. INSERT INTO Status_characteristics (сompleteness_of_filling) VALUES ('almost empty');
  292. INSERT INTO Status_characteristics (сompleteness_of_filling) VALUES ('almost empty');
  293. INSERT INTO Status_characteristics (сompleteness_of_filling) VALUES ('almost empty');
  294. INSERT INTO Status_characteristics (сompleteness_of_filling) VALUES ('almost empty');
  295. INSERT INTO Status_characteristics (сompleteness_of_filling) VALUES ('half full');
  296. INSERT INTO Status_characteristics (сompleteness_of_filling) VALUES ('half full');
  297. INSERT INTO Status_characteristics (сompleteness_of_filling) VALUES ('half full');
  298. INSERT INTO Status_characteristics (сompleteness_of_filling) VALUES ('half full');
  299. INSERT INTO Status_characteristics (сompleteness_of_filling) VALUES ('half full');
  300.  
  301. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (1, dbo.id_of_type('Economy'), 2, 3000);
  302. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (1, dbo.id_of_type('Business'), 0, 6000);
  303. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (2, dbo.id_of_type('Economy'), 2, 12000);
  304. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (2, dbo.id_of_type('Business'), 0, 16000);
  305. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (2, dbo.id_of_type('First'), 1, 22000);
  306. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (3, dbo.id_of_type('Economy'), 3, 3500);
  307. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (3, dbo.id_of_type('Business'), 1, 6500);
  308. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (4, dbo.id_of_type('Economy'), 5, 2000);
  309. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (5, dbo.id_of_type('Economy'), 6, 5500);
  310. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (5, dbo.id_of_type('Business'), 2, 9000);
  311. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (6, dbo.id_of_type('Economy'), 25, 1500);
  312. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (6, dbo.id_of_type('Business'), 3, 3200);
  313. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (7, dbo.id_of_type('Economy'), 32, 19000);
  314. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (7, dbo.id_of_type('Business'), 2, 28000);
  315. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (7, dbo.id_of_type('First'), 5, 38000);
  316. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (8, dbo.id_of_type('Economy'), 42, 4200);
  317. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (8, dbo.id_of_type('Business'), 4, 7300);
  318. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (9, dbo.id_of_type('Economy'), 33, 3900);
  319. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (10, dbo.id_of_type('Economy'), 38, 6000);
  320. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (10, dbo.id_of_type('Business'), 1, 9500);
  321. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (11, dbo.id_of_type('Economy'), 120, 2800);
  322. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (11, dbo.id_of_type('Business'), 9, 5400);
  323. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (12, dbo.id_of_type('Economy'), 238, 15000);
  324. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (12, dbo.id_of_type('Business'), 12, 28000);
  325. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (12, dbo.id_of_type('First'), 10, 33000);
  326. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (12, dbo.id_of_type('Premium economy'), 23, 22000);
  327. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (13, dbo.id_of_type('Economy'), 124, 4990);
  328. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (13, dbo.id_of_type('Business'), 2, 7100);
  329. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (14, dbo.id_of_type('Economy'), 150, 3200);
  330. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (15, dbo.id_of_type('Economy'), 110, 6800);
  331. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (15, dbo.id_of_type('Business'), 4, 11200);
  332. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (16, dbo.id_of_type('Economy'), 61, 8400);
  333. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (16, dbo.id_of_type('Business'), 4, 12300);
  334. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (17, dbo.id_of_type('Economy'), 72, 5900);
  335. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (17, dbo.id_of_type('Business'), 5, 9900);
  336. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (18, dbo.id_of_type('Economy'), 180, 14500);
  337. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (18, dbo.id_of_type('Business'), 3, 25000);
  338. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (18, dbo.id_of_type('First'), 4, 29200);
  339. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (18, dbo.id_of_type('Premium economy'), 10, 18300);
  340. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (19, dbo.id_of_type('Economy'), 75, 3700);
  341. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (20, dbo.id_of_type('Business'), 5, 17500);
  342. INSERT INTO [Status] (status_id, [type_id], left_seats, price) VALUES (20, dbo.id_of_type('Economy'), 68, 11200);
  343.  
  344. INSERT INTO Flight (flight_number, departure_airport, departure_date_and_time, arrival_airport, arrival_date_and_time,
  345.                         airline_id, airplane_id, distance, status_id)
  346.             VALUES (350, dbo.id_of_airport('Domodedovo'), '23/08/2003 22:30', dbo.id_of_airport('Tolmachevo'), '24/08/2003 03:20',
  347.                         dbo.id_of_airline('S7 Airlines'), 'RA-00202', 2300, 1);
  348.  
  349. INSERT INTO Flight (flight_number, departure_airport, departure_date_and_time, arrival_airport, arrival_date_and_time,
  350.                         airline_id, airplane_id, distance, status_id)
  351.             VALUES (354, dbo.id_of_airport('Tsentralnyy'), '23/08/2003 08:30', dbo.id_of_airport('Vnukovo'), '23/08/2003 08:40',
  352.                         dbo.id_of_airline('S7 Airlines'), 'RA-00001', 2700, 2);
  353. INSERT INTO Flight (flight_number, departure_airport, departure_date_and_time, arrival_airport, arrival_date_and_time,
  354.                         airline_id, airplane_id, distance, status_id)
  355.             VALUES (354, dbo.id_of_airport('Vnukovo'), '23/08/2003 11:30', dbo.id_of_airport('Munich Airport'), '23/08/2003 12:10',
  356.                         dbo.id_of_airline('Aeroflot - Russian Airlines'), 'RA-00015', 2400, 5);
  357.  
  358. INSERT INTO Flight (flight_number, departure_airport, departure_date_and_time, arrival_airport, arrival_date_and_time,
  359.                         airline_id, airplane_id, distance, status_id)
  360.             VALUES (368, dbo.id_of_airport('Sheremetyevo'), '24/08/2003 07:30', dbo.id_of_airport('Leonardo da Vinci International'), '24/08/2003 09:20',
  361.                         dbo.id_of_airline('Transaero'), 'RA-01105', 3100, 3);
  362.  
  363. INSERT INTO Flight (flight_number, departure_airport, departure_date_and_time, arrival_airport, arrival_date_and_time,
  364.                         airline_id, airplane_id, distance, status_id)
  365.             VALUES (435, dbo.id_of_airport('Munich Airport'), '23/08/2003 14:10', dbo.id_of_airport('Paris Orly Airport'), '23/08/2003 15:20',
  366.                         dbo.id_of_airline('Lufthansa'), 'D-AAAA', 1200, 10);
  367.  
  368. INSERT INTO Flight (flight_number, departure_airport, departure_date_and_time, arrival_airport, arrival_date_and_time,
  369.                         airline_id, airplane_id, distance, status_id)
  370.             VALUES (384, dbo.id_of_airport('New York John F. Kennedy International Airport'), '24/08/2003 02:50', dbo.id_of_airport('Sheremetyevo'), '24/08/2003 12:10',
  371.                         dbo.id_of_airline('S7 Airlines'), 'RA-00202', 2300, 1);
  372.  
  373. INSERT INTO Flight (flight_number, departure_airport, departure_date_and_time, arrival_airport, arrival_date_and_time,
  374.                         airline_id, airplane_id, distance, status_id)
  375.             VALUES (392, dbo.id_of_airport('Sheremetyevo'), '23/08/2003 22:30', dbo.id_of_airport('Paris Orly Airport'), '24/08/2003 03:20',
  376.                         dbo.id_of_airline('American Airlines'), 'N2', 11000, 18);
  377.  
  378. INSERT INTO Flight (flight_number, departure_airport, departure_date_and_time, arrival_airport, arrival_date_and_time,
  379.                         airline_id, airplane_id, distance, status_id)
  380.             VALUES (431, dbo.id_of_airport('Paris Orly Airport'), '22/08/2003 19:00', dbo.id_of_airport('New York John F. Kennedy International Airport'), '22/08/2003 20:10',
  381.                         dbo.id_of_airline('Air France'), 'F-ABCB', 9000, 12);
  382.  
  383. INSERT INTO Flight (flight_number, departure_airport, departure_date_and_time, arrival_airport, arrival_date_and_time,
  384.                         airline_id, airplane_id, distance, status_id)
  385.             VALUES (398, dbo.id_of_airport('London Luton Airport'), '23/08/2003 17:40', dbo.id_of_airport('Munich Airport'), '23/08/2003 20:20',
  386.                         dbo.id_of_airline('EasyJet'), 'G-AABB', 1500, 11);
  387. INSERT INTO Flight (flight_number, departure_airport, departure_date_and_time, arrival_airport, arrival_date_and_time,
  388.                         airline_id, airplane_id, distance, status_id)
  389.             VALUES (398, dbo.id_of_airport('Munich Airport'), '23/08/2003 23:40', dbo.id_of_airport('Sheremetyevo'), '24/08/2003 02:50',
  390.                         dbo.id_of_airline('S7 Airlines'), 'RA-00131', 2400, 10);
RAW Paste Data
Top