FILLING

set DATEFORMAT dmy

IF OBJECT_ID('Airline', 'U') IS NOT NULL
DELETE FROM Airline;
DBCC CHECKIDENT ('Airline', RESEED, 1);
IF OBJECT_ID('Airport', 'U') IS NOT NULL
DELETE FROM Airport;
DBCC CHECKIDENT ('Airport', RESEED, 1);
IF OBJECT_ID('City', 'U') IS NOT NULL
DELETE FROM City;
DBCC CHECKIDENT ('City', RESEED, 1);
IF OBJECT_ID('Country', 'U') IS NOT NULL
DELETE FROM Country;
DBCC CHECKIDENT ('Country', RESEED, 1);

INSERT INTO Country (name) VALUES ('Russia');
INSERT INTO Country (name) VALUES ('USA');
INSERT INTO Country (name) VALUES ('Ukraine');
INSERT INTO Country (name) VALUES ('China');
INSERT INTO Country (name) VALUES ('Australia');
INSERT INTO Country (name) VALUES ('Germany');
INSERT INTO Country (name) VALUES ('France');
INSERT INTO Country (name) VALUES ('United Kingdom');
INSERT INTO Country (name) VALUES ('Greece');
INSERT INTO Country (name) VALUES ('Italy');
INSERT INTO Country (name) VALUES ('Canada');

INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('Moscow', 3, dbo.id_of_country('Russia'));
INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('Omsk', 6, dbo.id_of_country('Russia'));
INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('Novosibirsk', 6, dbo.id_of_country('Russia'));
INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('Tyumen', 5, dbo.id_of_country('Russia'));
INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('Yekaterinburg', 5, dbo.id_of_country('Russia'));
INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('Krasnoyarsk', 7, dbo.id_of_country('Russia'));
INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('Vladivostok', 10, dbo.id_of_country('Russia'));
INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('Vancouver', -8, dbo.id_of_country('Canada'));
INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('Chicago', -6, dbo.id_of_country('USA'));
INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('Los Angeles', -8, dbo.id_of_country('USA'));
INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('New York', -5, dbo.id_of_country('USA'));
INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('Kiev', 2, dbo.id_of_country('Ukraine'));
INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('Beijing', 8, dbo.id_of_country('China'));
INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('Sydney', 10, dbo.id_of_country('Australia'));
INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('Berlin', 1, dbo.id_of_country('Germany'));
INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('Munich', 1, dbo.id_of_country('Germany'));
INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('Paris', 1, dbo.id_of_country('France'));
INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('London', 0, dbo.id_of_country('United Kingdom'));
INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('Athens', 2, dbo.id_of_country('Greece'));
INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('Rome', 1, dbo.id_of_country('Italy'));
INSERT INTO City (name, difference_with_the_UTC, country_id) VALUES ('Sochi', 3, dbo.id_of_country('Russia'));

INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Domodedovo', 'UUDD', dbo.id_of_city('Moscow'));
INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Sheremetyevo', 'UUEE', dbo.id_of_city('Moscow'));
INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Vnukovo', 'UUWW', dbo.id_of_city('Moscow'));
INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Tsentralnyy', 'UNOO', dbo.id_of_city('Omsk'));
INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Tolmachevo', 'UNNT', dbo.id_of_city('Novosibirsk'));
INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Roschino', 'USTR', dbo.id_of_city('Tyumen'));
INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Koltsovo', 'UNKE', dbo.id_of_city('Yekaterinburg'));
INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Emelyanovo', 'UNKL', dbo.id_of_city('Krasnoyarsk'));
INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Knevichi', 'UHWW', dbo.id_of_city('Vladivostok'));
INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Sochi', 'URSS', dbo.id_of_city('Sochi'));
INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Boundary Bay', 'CZBB', dbo.id_of_city('Vancouver'));
INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Chicago FSS', 'KCHI', dbo.id_of_city('Chicago'));
INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Los Angeles International', 'KLAX', dbo.id_of_city('Los Angeles'));
INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('New York John F. Kennedy International Airport', 'KJFK', dbo.id_of_city('New York'));
INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Zhulhany', 'UKKK', dbo.id_of_city('Kiev'));
INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Beijing Capital Int.', 'ZBAA', dbo.id_of_city('Beijing'));
INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Kingsford Smith Airport', 'YSSY', dbo.id_of_city('Sydney'));
INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Schoenefeld', 'EDDB', dbo.id_of_city('Berlin'));
INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Le Bourget', 'LFPB', dbo.id_of_city('Paris'));
INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Paris Orly Airport', 'LFPO', dbo.id_of_city('Paris'));
INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('London Heathrow', 'EGLL', dbo.id_of_city('London'));
INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('London Luton Airport', 'EGGW', dbo.id_of_city('London'));
INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Athens', 'KAHN', dbo.id_of_city('Athens'));
INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Leonardo da Vinci International', 'LIRF', dbo.id_of_city('Rome'));
INSERT INTO Airport (name, ICAO_code, city_id) VALUES ('Munich Airport', 'EDDM', dbo.id_of_city('Munich'));

INSERT INTO Airline (name, base_airport_id) VALUES ('S7 Airlines', dbo.id_of_airport('Tolmachevo'));
INSERT INTO Airline (name, base_airport_id) VALUES ('Aeroflot - Russian Airlines', dbo.id_of_airport('Sheremetyevo'));
INSERT INTO Airline (name, base_airport_id) VALUES ('Transaero', dbo.id_of_airport('Domodedovo'));
INSERT INTO Airline (name, base_airport_id) VALUES ('Red Wings', dbo.id_of_airport('Domodedovo'));
INSERT INTO Airline (name, base_airport_id) VALUES ('UTair', dbo.id_of_airport('Roschino'));
INSERT INTO Airline (name, base_airport_id) VALUES ('Pobeda', dbo.id_of_airport('Vnukovo'));
INSERT INTO Airline (name, base_airport_id) VALUES ('Lufthansa', dbo.id_of_airport('Munich Airport'));
INSERT INTO Airline (name, base_airport_id) VALUES ('Air France', dbo.id_of_airport('Paris Orly Airport'));
INSERT INTO Airline (name, base_airport_id) VALUES ('EasyJet', dbo.id_of_airport('London Luton Airport'));
INSERT INTO Airline (name, base_airport_id) VALUES ('Delta Air Lines', dbo.id_of_airport('New York John F. Kennedy International Airport'));
INSERT INTO Airline (name, base_airport_id) VALUES ('American Airlines', dbo.id_of_airport('New York John F. Kennedy International Airport'));
INSERT INTO Airline (name, base_airport_id) VALUES ('Qantas', dbo.id_of_airport('Kingsford Smith Airport'));