API tools faq
paste
Advertisement
Guest User

Filling_db_Airport

a guest
Mar 20th, 2017
98
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 41.04 KB | None | 0 0
raw download clone embed print report
  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);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!