· 5 years ago · Feb 06, 2020, 01:52 PM
1CREATE TABLE IF NOT EXISTS experience_extranet_resource.flight
2(
3 airline_code TEXT NOT NULL,
4 airline_name TEXT NOT NULL,
5 is_deleted BOOLEAN NOT NULL,
6 image_url TEXT NOT NULL,
7 _lut TIMESTAMPTZ NOT NULL,
8
9 PRIMARY KEY (airline_code)
10);
11
12DO $$
13BEGIN
14CREATE TRIGGER populate_lut_flight
15 BEFORE INSERT OR UPDATE
16 ON experience_extranet_resource.flight
17 FOR EACH ROW
18EXECUTE PROCEDURE experience_extranet_resource.update_lut();
19EXCEPTION
20 WHEN duplicate_object THEN RAISE NOTICE 'the trigger already exists';
21END;
22$$;
23
24CREATE TABLE IF NOT EXISTS experience_extranet_resource.airport
25(
26 iata TEXT NOT NULL,
27 airport_name TEXT NOT NULL,
28 airport_class TEXT NOT NULL,
29 city TEXT NOT NULL,
30 country TEXT NOT NULL,
31 is_deleted BOOLEAN NOT NULL,
32 _lut TIMESTAMPTZ NOT NULL,
33 PRIMARY KEY (iata)
34);
35
36DO $$
37BEGIN
38CREATE TRIGGER populate_lut_airport
39 BEFORE INSERT OR UPDATE
40 ON experience_extranet_resource.airport
41 FOR EACH ROW
42EXECUTE PROCEDURE experience_extranet_resource.update_lut();
43EXCEPTION
44 WHEN duplicate_object THEN RAISE NOTICE 'the trigger already exists';
45END;
46$$;
47
48-- Init Flight Info
49INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('3K', 'Jetstar', 'imageResource/2019/09/16/1568609975288-7dfcfe6ab642b6aea735912ed3be1c3a.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
50INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('5J', 'Cebu Pacific', 'imageResource/2015/12/17/1450349128712-339bd249975f07a72e9c38b33efae65d.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
51INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('6C', 'Air Timor', 'imageResource/2019/12/12/1576136765648-54b7fa4b82a449fb078680fb090bcfa9.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
52INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('6E', 'IndiGo', 'imageResource/2019/12/12/1576139955468-45e18e831f6d101fbaaf573f2cf8623b.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
53INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('7C', 'Jeju Air', 'imageResource/2019/12/12/1576139975978-a410992edf633b98c8a5c4361ed8534c.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
54INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('7G', 'Star Flyer', 'imageResource/2019/10/28/1572230828785-c1f07e191756828898df97b36921e149.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
55INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('8L', 'Lucky Air', 'imageResource/2018/11/16/1542350440438-d38807ce3cb354fcb20cec1fd015da60.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
56INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('8Y', 'Pan Pacific Airlines', 'imageResource/2019/07/17/1563345512156-ee6ce3a4f95412a26b40106751ec57fa.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
57INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('9C', 'Spring Airlines', 'imageResource/2019/12/12/1576139475687-707f52f91e2a33893dfa751865c8db8b.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
58INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('9W', 'Jet Airways', 'imageResource/2015/12/17/1450349149299-919a89fcec8e74b6a71b1b4951062fc7.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
59INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('A3', 'Aegean Airlines', 'imageResource/2019/12/12/1576139806932-b02865cb4148f8933be888eac22678d4.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
60INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('AA', 'American Airlines', 'imageResource/2016/02/18/1455792439238-52adf5c9af6ac2b209d6bc236a76c2b2.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
61INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('AC', 'Air Canada', 'imageResource/2016/02/18/1455792445950-a037533665894a6b769a7a0db5bf6b5b.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
62INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('AF', 'Air France', 'imageResource/2015/12/17/1450349156379-5f7049fd67d0aa0b5574111ccdfab515.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
63INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('AH', 'Air Algerie', 'imageResource/2020/01/04/1578097903546-b147a3aea4abc06695f7164d616494bf.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
64INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('AI', 'Air India', 'imageResource/2019/12/12/1576136462260-f36c782b85fc5791fd531b1bfd77e2eb.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
65INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('AK', 'Air Asia', 'imageResource/2016/06/20/1466418524477-74783a39da2dd0391ca3e5afba4edf10.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
66INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('AM', 'Aeromexico', 'imageResource/2019/10/23/1571805872505-c8d4adc95c47e6965f7965b1c6f646d4.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
67INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('AR', 'Aerolineas Argentinas', 'imageResource/2019/12/22/1577018000556-1ff34e471e4e184c9bbb0d610a5a626b.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
68INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('AS', 'Alaska Airlines', 'imageResource/2019/12/12/1576139871936-33008c33efa057658da50c4e131f3b8a.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
69INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('AT', 'Royal Air Maroc', 'imageResource/2020/01/04/1578098167784-af563052322b806546928ea225149da2.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
70INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('AV', 'Avianca', 'imageResource/2019/11/06/1573013174993-9abc78f367868e31242023edc29e656d.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
71INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('AY', 'Finnair', 'imageResource/2016/05/16/1463384807854-5e09e7d6fb464fe17e2125f89998463b.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
72INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('AZ', 'Alitalia', 'imageResource/2019/12/12/1576136783714-24e1c7775e4299356d74f55217b7a612.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
73INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('B6', 'jetBlue', 'imageResource/2019/12/12/1576139989167-321f01e9279a40dda8a62d901a928a8e.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
74INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('B7', 'Uni Air', 'imageResource/2019/12/18/1576661440131-dfbc3561addd27cace51f77087fe5650.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
75INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('BA', 'British Airways', 'imageResource/2015/12/17/1450349191484-6109380434e0b70438d8fe6c76c4db0d.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
76INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('BD', 'Bayon Airlines', 'imageResource/2016/09/05/1473036342582-358bcf388d381d6c204b2a6954b09943.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
77INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('BE', 'Flybe', 'imageResource/2019/12/12/1576139916489-7c4dcbdb6d3b999f10e8fe19fe4459f1.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
78INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('BI', 'Royal Brunei Airlines', 'imageResource/2015/12/17/1450349207893-bf233b5a36557c771998ceb952980a00.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
79INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('BR', 'Eva Air', 'imageResource/2017/05/29/1496036467953-07ed58feff4411d62556fc4163e9734b.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
80INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('CA', 'Air China', 'imageResource/2015/12/17/1450349223955-21921640c1361b15fbe1fa8bc361b583.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
81INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('CI', 'China Airlines', 'imageResource/2019/12/12/1576136814235-2d2f0c25d8d6719cf7fdde9e131d6a85.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
82INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('CX', 'Cathay Pacific', 'imageResource/2016/11/17/1479375081019-abaa527e23bc56424390edf666c9055e.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
83INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('CZ', 'China Southern Airlines', 'imageResource/2019/12/12/1576136846144-deaa603090d281bc0fd614895ebb9293.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
84INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('D7', 'Air Asia X', 'imageResource/2015/12/17/1450349272817-6407183d8850c6404cdf10dbc6ac9d41.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
85INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('D8', 'Norwegian Air', 'imageResource/2019/10/04/1570177884248-21931a0243ee873a5b1d256c6a5f1bbc.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
86INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('DL', 'Delta Air Lines', 'imageResource/2019/12/12/1576136864280-e3e0f638566f5d230568f20d1754bddf.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
87INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('DY', 'Norwegian Air Shuttle', 'imageResource/2019/10/04/1570177867147-2f92015d8c94b7f0e490f333a41e4020.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
88INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('EI', 'Aer Lingus', 'imageResource/2019/07/12/1562913242470-4c76906e67ea551038bf49fe1a244a34.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
89INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('EK', 'Emirates', 'imageResource/2015/12/17/1450349712954-072646ca207d5739f8199ef14e6a6464.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
90INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('ET', 'Ethiopian Airlines', 'imageResource/2019/12/12/1576137048364-faafc841a7274e7530f068bd9fa00a2b.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
91INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('EY', 'Etihad Airways', 'imageResource/2019/11/01/1572597075104-30d785eb4ab3f0c682965386331f6d0a.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
92INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('FI', 'Icelandair', 'imageResource/2019/12/12/1576138107142-23c5cfd70daf7f15f4e64e4c1afba460.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
93INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('FZ', 'Fly Dubai', 'imageResource/2019/12/12/1576139929415-0762fa9e3d9ce8397e5e9bc263d51b16.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
94INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('GA', 'Garuda Indonesia', 'imageResource/2019/12/12/1576140134467-906ded3638e9045d664adc40caa8ec47.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
95INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('GF', 'Gulf Air', 'imageResource/2019/07/12/1562913074736-5b8051a86142cba6ddfa67ae2cc25ccb.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
96INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('HA', 'Hawaiian Airlines', 'imageResource/2018/10/17/1539748826434-cc97f5cb8da8765a5cee778c9c9daf54.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
97INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('HX', 'Hong Kong Airlines', 'imageResource/2019/12/12/1576137375123-449cf532d760492e458016fec26a527f.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
98INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('HY', 'Uzbekistan Airways', 'imageResource/2019/07/12/1562913140804-ec171638d9f22f635c3b66910488460d.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
99INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('IB', 'Iberia', 'imageResource/2019/09/12/1568276526922-2317a7eff8e9ab2f853c99847ad5ed1b.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
100INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('ID', 'Batik Air', 'imageResource/2019/12/13/1576208649600-12471f9b7ffa159361f7bbbfb63065ee.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
101INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('IG', 'Meridiana', 'imageResource/2019/11/30/1575098359371-49dd233519e052d7dd85f5a6905ca3a8.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
102INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('IL', 'Trigana Air', 'imageResource/2016/12/27/1482845148999-c4273ca0398aa949d7c6d23cee5ecb5a.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
103INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('IN', 'Nam Air', 'imageResource/2018/10/26/1540524227276-088a6a9a9dd97a7111edb8dec28f2824.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
104INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('IT', 'Tiger Air Taiwan', 'imageResource/2019/12/12/1576140037087-ce5eaae71dd2248d8b0b00caa6bdbb05.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
105INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('IW', 'Wings Air', 'imageResource/2015/12/17/1450349805026-5fecb4ceb5f79e38f2a5ae50f33b813e.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
106INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('JJ', 'TAM Airlines', 'imageResource/2016/06/16/1466063027398-a282e6604554142eae2ce8be60b7a046.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
107INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('JL', 'Japan Airlines', 'imageResource/2015/12/17/1450349813952-78c3d4dc0889e1ec3abb288700f55db6.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
108INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('JQ', 'Jetstar', 'imageResource/2019/09/16/1568610020749-a8479c27aec70ea233fee6f9402549c4.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
109INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('JT', 'Lion Air', 'imageResource/2015/12/17/1450349861201-09ec8f298222a73d66e8e96aa3b918f0.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
110INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('KA', 'Cathay Dragon', 'imageResource/2016/04/04/1459765805039-dc44f0f7b15562c79a8d5984d36a6aa0.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
111INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('KC', 'Air Astana', 'imageResource/2019/11/23/1574473907105-3ab0e7ee2f753be9794ac3715e8f5508.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
112INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('KE', 'Korean Air', 'imageResource/2015/12/17/1450350298291-662d425ad7771e0ce8639643236d504a.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
113INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('KL', 'KLM Royal Dutch Airlines', 'imageResource/2019/12/12/1576141480566-8e51df9bcecd7a682b8c0fb0341a9c0e.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
114INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('KU', 'Kuwait Airways', 'imageResource/2019/05/13/1557722468108-9cbb8ade00bb18b69152da8dc375c88f.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
115INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('LA', 'LAN Colombia', 'imageResource/2019/11/06/1573013620806-ef972b5dac302b7ef6a69c969f7ada32.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
116INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('LH', 'Lufthansa', 'imageResource/2019/12/13/1576209842028-fb9f53ebf45b3b4cd2bd603dec4b057a.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
117INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('LO', 'LOT - Polish Airlines', 'imageResource/2019/09/12/1568276490903-d6317a28cfe828d258038450ea4b0692.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
118INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('LX', 'SWISS International Air Lines', 'imageResource/2015/12/17/1450350324733-42132d4ad6ede9f42f9b0b8cac2ee7c2.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
119INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('LY', 'El Al Israel Airlines', 'imageResource/2019/08/12/1565580696719-9bc090fc221edd73dfad6d6313c9634e.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
120INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('ME', 'Middle East Airlines', 'imageResource/2019/12/22/1577032587159-c1fbefba9025c893a56144cbfb8d164b.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
121INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('MF', 'Xiamen Airlines', 'imageResource/2015/12/17/1450350405567-f0c572c8fecaa46b3a4127b8cb148cbf.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
122INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('MH', 'Malaysia Airlines', 'imageResource/2019/12/12/1576138137652-e7baea7211758472e44037225c9de508.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
123INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('MS', 'Egyptair', 'imageResource/2015/12/17/1450350440116-f6b96e9763fa410fb01b773becf7511c.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
124INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('MU', 'China Eastern Airlines', 'imageResource/2019/12/12/1576136827975-8bc9e8030b58122223b4bc274f600b83.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
125INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('NH', 'All Nippon Airways', 'imageResource/2015/12/17/1450350490730-382d5b8d8b7c9fe2b0429822661832a2.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
126INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('NM', 'NAM Air', 'imageResource/2015/12/17/1450350497772-d343e9b6823d18054324b818b999c394.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
127INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('NZ', 'Air New Zealand', 'imageResource/2016/02/18/1455792452754-aa4e588bf606e8311e4510703f499b84.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
128INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('OD', 'Malindo Air', 'imageResource/2019/12/12/1576138147465-dcd29b6d9aaef8c7867efa94e9885684.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
129INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('OK', 'Czech Airlines', 'imageResource/2019/10/28/1572230540474-c9ff022ac889bfa857972ea36bd67ddf.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
130INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('OS', 'Austrian Airlines', 'imageResource/2019/05/13/1557722562415-2efe7fe2a4e12dfba87f193157e07951.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
131INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('OU', 'Croatia Airlines', 'imageResource/2019/11/06/1573013323317-ed25aac5d8f74e8b8605052d568499cc.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
132INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('OZ', 'Asiana Airlines', 'imageResource/2019/12/12/1576136799116-8f6f7a9ce26bfe202124e0eedb59beed.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
133INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('PG', 'Bangkok Airways', 'imageResource/2015/12/17/1450350527267-fb9dabea524c338d0f9a227f9e342a6e.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
134INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('PS', 'Ukraine International Airlines', 'imageResource/2016/06/06/1465212717591-3fa063afb9e692f9779da5085946eb6f.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
135INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('QF', 'Qantas Airways', 'imageResource/2019/09/03/1567499813005-7847d84035765839b9b5762079819e28.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
136INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('QG', 'Citilink', 'imageResource/2015/12/17/1450350561012-6584b693edd67d75cfc25ecff41c5704.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
137INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('QR', 'Qatar Airways', 'imageResource/2019/12/12/1576138331039-841e01562ec30d228e7d2b149916c67d.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
138INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('RJ', 'Royal Jordanian', 'imageResource/2019/12/12/1576138341206-d5a47b88257c7c0290fa2210b782b973.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
139INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('RO', 'Tarom', 'imageResource/2019/10/28/1572230877365-912d9909bf0a3b8d3885f2c53d4d9d12.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
140INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('S7', 'Siberia Airlines', 'imageResource/2019/07/12/1562913087334-55ae35409d99c5886bc38ae3d7344767.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
141INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('SA', 'South African Airways', 'imageResource/2019/12/12/1576139459956-1d7530b6083ddc030f0c2273ea3349d9.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
142INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('SK', 'Scandinavian Airlines System (SAS)', 'imageResource/2016/06/16/1466063425211-b78f09bb76c205ff1350ec057b29b014.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
143INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('SL', 'Thai Lion Air', 'imageResource/2015/12/17/1450350592719-5aba7dc0f79bd63655904bb1dc803667.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
144INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('SN', 'Brussels Airlines', 'imageResource/2019/09/12/1568276578714-deb0485f10884d59e60ee99302379746.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
145INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('SQ', 'Singapore Airlines', 'imageResource/2015/12/17/1450350610403-aefa15ce3b8e59de9882926d198eb27f.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
146INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('SU', 'Aeroflot Russian Airlines', 'imageResource/2016/05/16/1463384887997-c081bbf122faf71b0dc814b0a71d8753.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
147INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('SV', 'Saudi Arabian Airlines', 'imageResource/2016/02/18/1455792481383-2156667c9fc9ca9a12659b284fa7cb82.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
148INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('TG', 'Thai Airways International', 'imageResource/2019/12/12/1576139625320-418c2ecd61fad1750a5a3c2f1e01361d.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
149INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('TK', 'Turkish Airlines', 'imageResource/2015/12/17/1450350636339-8ef065b228beccbb2d86c7f29cb41ccd.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
150INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('TP', 'TAP Portugal', 'imageResource/2019/11/30/1575097784764-c9ac71a7018cda8746517cd54f29f628.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
151INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('TR', 'Scoot ', 'imageResource/2017/07/27/1501138553075-1329db65f38802a050f34d38a3216235.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
152INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('TT', 'Tiger Air', 'imageResource/2017/05/09/1494305086264-39e70c6e9ae7ed83125a478cf0334102.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
153INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('TZ', 'Scoor Airways', 'imageResource/2017/07/27/1501138573721-160c07575858c7d7e773ea06da4bfdd1.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
154INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('UA', 'United Airlines', 'imageResource/2016/06/06/1465212809472-461429ef97e01775401cfb5e54b58c54.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
155INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('UL', 'SriLankan Airlines', 'imageResource/2019/12/12/1576141501025-a32eacfe82b5ef5311d4c85f5cc53cd1.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
156INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('VA', 'Virgin Airways', 'imageResource/2019/12/12/1576139649131-b14961716288b39e1069148aa118cdf3.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
157INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('VJ', 'Vietjet', 'imageResource/2015/12/17/1450350670702-a9dba44d3e9fe096f83ffe00d56a99ec.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
158INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('VN', 'Vietnam Airlines', 'imageResource/2019/05/08/1557291046676-ad452147a52382b5e9e3f4994cb2a3cf.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
159INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('VY', 'Vueling', 'imageResource/2019/12/12/1576139663824-03c1dcce6a4eab8a5694314238b0050f.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
160INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('WY', 'Oman Air', 'imageResource/2019/12/12/1576138270026-1fe088e2880b67aa4b2102f401e1b39c.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
161INSERT INTO experience_extranet_resource.flight (airline_code, airline_name, image_url, is_deleted) VALUES('default', 'Others', 'imageResource/2015/12/17/1450350710653-f522e35b03adb20da95195584a72713d.png', FALSE) ON CONFLICT(airline_code) DO NOTHING;
162
163INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('AAL', 'Aalborg Airport', 'Large airport', 'Zanzibar' , 'Denmark', FALSE) ON CONFLICT(iata) DO NOTHING;
164INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ZNZ', 'Abeid Amani Karume International Airport', 'Large airport', 'Aberdeen' , 'Tanzania', FALSE) ON CONFLICT(iata) DO NOTHING;
165INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ABZ', 'Aberdeen Dyce Airport', 'Large airport', 'Springfield' , 'United Kingdom', FALSE) ON CONFLICT(iata) DO NOTHING;
166INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SPI', 'Abraham Lincoln Capital Airport', 'Large airport', 'Abu Dhabi' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
167INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('AUH', 'Abu Dhabi International Airport', 'Large airport', 'Adana' , 'United Arab Emirates', FALSE) ON CONFLICT(iata) DO NOTHING;
168INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ADA', 'Adana Airport', 'Large airport', 'Addis Ababa' , 'Turkey', FALSE) ON CONFLICT(iata) DO NOTHING;
169INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ADD', 'Addis Ababa Bole International Airport', 'Large airport', 'Adelaide' , 'Ethiopia', FALSE) ON CONFLICT(iata) DO NOTHING;
170INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ADL', 'Adelaide International Airport', 'Large airport', 'İzmir' , 'Australia', FALSE) ON CONFLICT(iata) DO NOTHING;
171INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ADB', 'Adnan Menderes International Airport', 'Large airport', 'Madrid' , 'Turkey', FALSE) ON CONFLICT(iata) DO NOTHING;
172INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MAD', 'Adolfo Suárez Madrid–Barajas Airport', 'Large airport', 'Curitiba' , 'Spain', FALSE) ON CONFLICT(iata) DO NOTHING;
173INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CWB', 'Afonso Pena Airport', 'Large airport', 'Uyo' , 'Brazil', FALSE) ON CONFLICT(iata) DO NOTHING;
174INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('QUO', 'Akwa Ibom International Airport', 'Large airport', 'Jebel Ali' , 'Nigeria', FALSE) ON CONFLICT(iata) DO NOTHING;
175INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DWC', 'Al Maktoum International Airport', 'Large airport', 'Albuquerque' , 'United Arab Emirates', FALSE) ON CONFLICT(iata) DO NOTHING;
176INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ABQ', 'Albuquerque International Sunport', 'Large airport', 'Cusco' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
177INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CUZ', 'Alejandro Velasco Astete International Airport', 'Large airport', 'Aleppo' , 'Peru', FALSE) ON CONFLICT(iata) DO NOTHING;
178INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ALP', 'Aleppo International Airport', 'Large airport', 'Alicante' , 'Syria', FALSE) ON CONFLICT(iata) DO NOTHING;
179INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ALC', 'Alicante International Airport', 'Large airport', 'Almaty' , 'Spain', FALSE) ON CONFLICT(iata) DO NOTHING;
180INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ALA', 'Almaty Airport', 'Large airport', 'Altus' , 'Kazakhstan', FALSE) ON CONFLICT(iata) DO NOTHING;
181INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('LTS', 'Altus Air Force Base', 'Large airport', 'Espargos' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
182INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SID', 'Amílcar Cabral International Airport', 'Large airport', 'Amsterdam' , 'Cape Verde', FALSE) ON CONFLICT(iata) DO NOTHING;
183INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('AMS', 'Amsterdam Airport Schiphol', 'Large airport', 'Antalya' , 'The Netherlands', FALSE) ON CONFLICT(iata) DO NOTHING;
184INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('AYT', 'Antalya International Airport', 'Large airport', 'Hagåtña, Guam International Airport' , 'Turkey', FALSE) ON CONFLICT(iata) DO NOTHING;
185INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('GUM', 'Antonio B. Won Pat International Airport', 'Large airport', 'Asheville' , 'Guam', FALSE) ON CONFLICT(iata) DO NOTHING;
186INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('AVL', 'Asheville Regional Airport', 'Large airport', 'Ashgabat' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
187INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ASB', 'Ashgabat International Airport', 'Large airport', 'Astana' , 'Turkmenistan', FALSE) ON CONFLICT(iata) DO NOTHING;
188INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('TSE', 'Astana International Airport', 'Large airport', 'Istanbul' , 'Kazakhstan', FALSE) ON CONFLICT(iata) DO NOTHING;
189INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('IST', 'Istanbul Ataturk Airport', 'Large airport', 'Auckland' , 'Turkey', FALSE) ON CONFLICT(iata) DO NOTHING;
190INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('AKL', 'Auckland International Airport', 'Large airport', 'Augusta' , 'New Zealand', FALSE) ON CONFLICT(iata) DO NOTHING;
191INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('AGS', 'Augusta Regional At Bush Field', 'Large airport', 'Austin' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
192INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('AUS', 'Austin Bergstrom International Airport', 'Large airport', 'Green Bay' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
193INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('GRB', 'Austin Straubel International Airport', 'Large airport', 'Baghdad' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
194INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BGW', 'Baghdad International Airport', 'Large airport', 'Manama' , 'Iraq', FALSE) ON CONFLICT(iata) DO NOTHING;
195INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BAH', 'Bahrain International Airport', 'Large airport', 'Hohhot' , 'Bahrain', FALSE) ON CONFLICT(iata) DO NOTHING;
196INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('HET', 'Baita International Airport', 'Large airport', 'Baltimore' , 'China', FALSE) ON CONFLICT(iata) DO NOTHING;
197INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BWI', 'Baltimore/Washington International Thurgood Marshall Airport', 'Large airport', 'Colombo' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
198INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CMB', 'Bandaranaike International Colombo Airport', 'Large airport', 'Bangor' , 'Sri Lanka', FALSE) ON CONFLICT(iata) DO NOTHING;
199INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BGR', 'Bangor International Airport', 'Large airport', 'Barcelona' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
200INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BCN', 'Barcelona–El Prat Airport', 'Large airport', 'Bari' , 'Spain', FALSE) ON CONFLICT(iata) DO NOTHING;
201INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BRI', 'Bari Karol Wojtyła Airport', 'Large airport', 'Bossier City' , 'Italy', FALSE) ON CONFLICT(iata) DO NOTHING;
202INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BAD', 'Barksdale Air Force Base', 'Large airport', 'Basrah' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
203INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BSR', 'Basrah International Airport', 'Large airport', 'Latakia' , 'Iraq', FALSE) ON CONFLICT(iata) DO NOTHING;
204INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('LTK', 'Bassel Al-Assad International Airport', 'Large airport', 'Marysville' , 'Syria', FALSE) ON CONFLICT(iata) DO NOTHING;
205INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BAB', 'Beale Air Force Base', 'Large airport', 'Beijing' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
206INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('PEK', 'Beijing Capital International Airport', 'Large airport', 'Beijing' , 'China', FALSE) ON CONFLICT(iata) DO NOTHING;
207INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('PKX', 'Beijing Daxing International Airport', 'Large airport', 'Beijing' , 'China', FALSE) ON CONFLICT(iata) DO NOTHING;
208INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('NAY', 'Beijing Nanyuan Airport', 'Large airport', 'Beirut' , 'China', FALSE) ON CONFLICT(iata) DO NOTHING;
209INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BEY', 'Beirut Rafic Hariri International Airport', 'Large airport', 'Belfast' , 'Lebanon', FALSE) ON CONFLICT(iata) DO NOTHING;
210INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BFS', 'Belfast International Airport', 'Large airport', 'Belgrade' , 'United Kingdom', FALSE) ON CONFLICT(iata) DO NOTHING;
211INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BEG', 'Belgrade Nikola Tesla Airport', 'Large airport', 'Little Rock' , 'Serbia', FALSE) ON CONFLICT(iata) DO NOTHING;
212INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('LIT', 'Bill & Hillary Clinton National Airport/Adams Field', 'Large airport', 'Billings' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
213INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BIL', 'Billings Logan International Airport', 'Large airport', 'Birmingham' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
214INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BHM', 'Birmingham-Shuttlesworth International Airport', 'Large airport', 'Lexington' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
215INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('LEX', 'Blue Grass Airport', 'Large airport', 'Seattle' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
216INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BFI', 'Boeing Field King County International Airport', 'Large airport', 'Boise' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
217INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BOI', 'Boise Air Terminal/Gowen Field', 'Large airport', 'Hartford' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
218INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BDL', 'Bradley International Airport', 'Large airport', 'Buffalo' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
219INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BUF', 'Buffalo Niagara International Airport', 'Large airport', 'Calgary' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
220INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('YYC', 'Calgary International Airport', 'Large airport', 'Cancún' , 'Canada', FALSE) ON CONFLICT(iata) DO NOTHING;
221INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CUN', 'Cancún International Airport', 'Large airport', 'Clovis' , 'Mexico', FALSE) ON CONFLICT(iata) DO NOTHING;
222INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CVS', 'Cannon Air Force Base', 'Large airport', 'Bloomington/Normal' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
223INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BMI', 'Central Illinois Regional Airport at Bloomington-Normal', 'Large airport', 'Charleston' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
224INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CHS', 'Charleston Air Force Base-International Airport', 'Large airport', 'Charlotte' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
225INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CLT', 'Charlotte Douglas International Airport', 'Large airport', 'Chicago' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
226INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MDW', 'Chicago Midway International Airport', 'Large airport', 'Chicago' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
227INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ORD', 'Chicago O''Hare International Airport', 'Large airport', 'Chicago/Rockford' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
228INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('RFD', 'Chicago Rockford International Airport', 'Large airport', 'Cincinnati' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
229INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CVG', 'Cincinnati/Northern Kentucky International Airport', 'Large airport', 'Colorado Springs' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
230INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('COS', 'City of Colorado Springs Municipal Airport', 'Large airport', 'Cleveland' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
231INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CLE', 'Cleveland Hopkins International Airport', 'Large airport', 'Columbia' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
232INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CAE', 'Columbia Metropolitan Airport', 'Large airport', 'Columbus' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
233INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CBM', 'Columbus Air Force Base', 'Large airport', 'Corpus Christi' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
234INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CRP', 'Corpus Christi International Airport', 'Large airport', 'Dallas-Fort Worth' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
235INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DFW', 'Dallas Fort Worth International Airport', 'Large airport', 'Dallas' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
236INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DAL', 'Dallas Love Field Airport', 'Large airport', 'Madison' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
237INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MSN', 'Dane County Regional Truax Field', 'Large airport', 'Honolulu' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
238INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('HNL', 'Daniel K. Inouye International Airport', 'Large airport', 'Liberia' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
239INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('LIR', 'Daniel Oduber Quiros International Airport', 'Large airport', 'Daytona Beach' , 'Costa Rica', FALSE) ON CONFLICT(iata) DO NOTHING;
240INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DAB', 'Daytona Beach International Airport', 'Large airport', 'Denver' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
241INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DEN', 'Denver International Airport', 'Large airport', 'Des Moines' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
242INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DSM', 'Des Moines International Airport', 'Large airport', 'Valparaiso' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
243INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('VPS', 'Destin-Ft Walton Beach Airport', 'Large airport', 'Detroit' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
244INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DTW', 'Detroit Metropolitan Airport', 'Large airport', 'Del Rio' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
245INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DLF', 'DLF Airport', 'Large airport', 'Marietta' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
246INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MGE', 'Dobbins Air Reserve Base', 'Large airport', 'Guadalajara' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
247INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('GDL', 'Don Miguel Hidalgo Y Costilla International Airport', 'Large airport', 'Dover' , 'Mexico', FALSE) ON CONFLICT(iata) DO NOTHING;
248INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DOV', 'Dover Air Force Base', 'Large airport', 'Dubuque' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
249INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DBQ', 'Dubuque Regional Airport', 'Large airport', 'Duluth' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
250INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DLH', 'Duluth International Airport', 'Large airport', 'Abilene' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
251INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DYS', 'Dyess Air Force Base', 'Large airport', 'Edmonton' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
252INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('YEG', 'Edmonton International Airport', 'Large airport', 'Edwards' , 'Canada', FALSE) ON CONFLICT(iata) DO NOTHING;
253INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('EDW', 'Edwards Air Force Base', 'Large airport', 'Omaha' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
254INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('OMA', 'Eppley Airfield', 'Large airport', 'Erie' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
255INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ERI', 'Erie International Tom Ridge Field', 'Large airport', 'Fairbanks' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
256INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('FAI', 'Fairbanks International Airport', 'Large airport', 'Spokane' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
257INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SKA', 'Fairchild Air Force Base', 'Large airport', 'Fort Lauderdale' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
258INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('FLL', 'Fort Lauderdale Hollywood International Airport', 'Large airport', 'Fort Smith' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
259INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('FSM', 'Fort Smith Regional Airport', 'Large airport', 'Fort Wayne' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
260INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('FWA', 'Fort Wayne International Airport', 'Large airport', 'Fort Worth' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
261INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('AFW', 'Fort Worth Alliance Airport', 'Large airport', 'Fort Worth' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
262INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('FTW', 'Fort Worth Meacham International Airport', 'Large airport', 'Tijuana' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
263INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('TIJ', 'General Abelardo L. Rodríguez International Airport', 'Large airport', 'Boston' , 'Mexico', FALSE) ON CONFLICT(iata) DO NOTHING;
264INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BOS', 'Logan International Airport', 'Large airport', 'Hermosillo' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
265INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('HMO', 'General Ignacio P. Garcia International Airport', 'Large airport', 'Acapulco' , 'Mexico', FALSE) ON CONFLICT(iata) DO NOTHING;
266INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ACA', 'General Juan N Alvarez International Airport', 'Large airport', 'Monterrey' , 'Mexico', FALSE) ON CONFLICT(iata) DO NOTHING;
267INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MTY', 'General Mariano Escobedo International Airport', 'Large airport', 'Milwaukee' , 'Mexico', FALSE) ON CONFLICT(iata) DO NOTHING;
268INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MKE', 'General Mitchell International Airport', 'Large airport', 'Peoria' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
269INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('PIA', 'General Wayne A. Downing Peoria International Airport', 'Large airport', 'Houston' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
270INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('IAH', 'George Bush Intercontinental Airport', 'Large airport', 'Rochester' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
271INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ROC', 'Greater Rochester International Airport', 'Large airport', 'Greenville' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
272INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('GSP', 'Greenville Spartanburg International Airport', 'Large airport', 'Peru' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
273INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('GUS', 'Grissom Air Reserve Base', 'Large airport', 'Gulfport' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
274INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('GPT', 'Gulfport Biloxi International Airport', 'Large airport', 'Halifax' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
275INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('YHZ', 'Halifax / Stanfield International Airport', 'Large airport', 'Atlanta' , 'Canada', FALSE) ON CONFLICT(iata) DO NOTHING;
276INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ATL', 'Hartsfield-Jackson Atlanta International Airport', 'Large airport', 'Alamogordo' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
277INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('HMN', 'Holloman Air Force Base', 'Large airport', 'Huntsville' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
278INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('HSV', 'Huntsville International Carl T Jones Field', 'Large airport', 'Indianapolis' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
279INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('IND', 'Indianapolis International Airport', 'Large airport', 'Jackson' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
280INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('JAN', 'Jackson-Medgar Wiley Evers International Airport', 'Large airport', 'Jacksonville' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
281INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('JAX', 'Jacksonville International Airport', 'Large airport', 'Dayton' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
282INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DAY', 'James M Cox Dayton International Airport', 'Large airport', 'New York' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
283INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('JFK', 'John F. Kennedy International Airport', 'Large airport', 'Columbus' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
284INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CMH', 'John Glenn Columbus International Airport', 'Large airport', 'Santa Ana' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
285INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SNA', 'John Wayne Airport-Orange County Airport', 'Large airport', 'Camp Springs' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
286INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ADW', 'Andrews Air Force Base', 'Large airport', 'Joplin' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
287INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('JLN', 'Joplin Regional Airport', 'Large airport', 'Havana' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
288INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('HAV', 'José Martí International Airport', 'Large airport', 'Varadero' , 'Cuba', FALSE) ON CONFLICT(iata) DO NOTHING;
289INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('VRA', 'Juan Gualberto Gomez International Airport', 'Large airport', 'Kansas City' , 'Cuba', FALSE) ON CONFLICT(iata) DO NOTHING;
290INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MCI', 'Kansas City International Airport', 'Large airport', 'Guatemala City' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
291INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('GUA', 'La Aurora Airport', 'Large airport', 'New York' , 'Guatemala', FALSE) ON CONFLICT(iata) DO NOTHING;
292INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('LGA', 'La Guardia Airport', 'Large airport', 'Lafayette' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
293INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('LFT', 'Lafayette Regional Airport', 'Large airport', 'Hampton' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
294INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('LFI', 'Langley Air Force Base', 'Large airport', 'Santo Domingo' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
295INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SDQ', 'Las Américas International Airport', 'Large airport', 'Toronto' , 'Dominican Republic', FALSE) ON CONFLICT(iata) DO NOTHING;
296INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('YYZ', 'Toronto Pearson International Airport', 'Large airport', 'Mexico City' , 'Canada', FALSE) ON CONFLICT(iata) DO NOTHING;
297INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MEX', 'Mexico City International Airport', 'Large airport', 'Puerto Vallarta' , 'Mexico', FALSE) ON CONFLICT(iata) DO NOTHING;
298INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('PVR', 'Licenciado Gustavo Díaz Ordaz International Airport', 'Large airport', 'Los Angeles' , 'Mexico', FALSE) ON CONFLICT(iata) DO NOTHING;
299INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('LAX', 'Los Angeles International Airport', 'Large airport', 'San José del Cabo' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
300INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SJD', 'Los Cabos International Airport', 'Large airport', 'New Orleans' , 'Mexico', FALSE) ON CONFLICT(iata) DO NOTHING;
301INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MSY', 'Louis Armstrong New Orleans International Airport', 'Large airport', 'Louisville' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
302INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SDF', 'Louisville International Airport', 'Large airport', 'Chattanooga' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
303INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CHA', 'Lovell Field', 'Large airport', 'Lubbock' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
304INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('LBB', 'Lubbock Preston Smith International Airport', 'Large airport', 'San Juan' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
305INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SJU', 'Luis Munoz Marin International Airport', 'Large airport', 'Glendale' , 'Puerto Rico', FALSE) ON CONFLICT(iata) DO NOTHING;
306INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('LUF', 'Luke Air Force Base', 'Large airport', 'Nassau' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
307INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('NAS', 'Lynden Pindling International Airport', 'Large airport', 'Tampa' , 'Bahamas', FALSE) ON CONFLICT(iata) DO NOTHING;
308INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MCF', 'Mac Dill Air Force Base', 'Large airport', 'Manchester' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
309INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MHT', 'Manchester-Boston Regional Airport', 'Large airport', 'Saginaw' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
310INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MBS', 'MBS International Airport', 'Large airport', 'Las Vegas' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
311INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('LAS', 'McCarran International Airport', 'Large airport', 'Tacoma' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
312INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('TCM', 'McChord Air Force Base', 'Large airport', 'Knoxville' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
313INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('TYS', 'McGhee Tyson Airport', 'Large airport', 'Memphis' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
314INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MEM', 'Memphis International Airport', 'Large airport', 'Oakland' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
315INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('OAK', 'Metropolitan Oakland International Airport', 'Large airport', 'Miami' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
316INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MIA', 'Miami International Airport', 'Large airport', 'Minneapolis' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
317INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MSP', 'Minneapolis–Saint Paul International Airport', 'Large airport', 'Mobile' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
318INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MOB', 'Mobile Regional Airport', 'Large airport', 'Monroe' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
319INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MLU', 'Monroe Regional Airport', 'Large airport', 'San Salvador (San Luis Talpa)' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
320INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SAL', 'Monseñor Óscar Arnulfo Romero International Airport', 'Large airport', 'Montgomery' , 'El Salvador', FALSE) ON CONFLICT(iata) DO NOTHING;
321INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MGM', 'Montgomery Regional (Dannelly Field) Airport', 'Large airport', 'Montréal' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
322INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('YUL', 'Montreal / Pierre Elliott Trudeau International Airport', 'Large airport', 'Mountain Home' , 'Canada', FALSE) ON CONFLICT(iata) DO NOTHING;
323INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MUO', 'Mountain Home Air Force Base', 'Large airport', 'Nashville' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
324INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BNA', 'Nashville International Airport', 'Large airport', 'Newark' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
325INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('EWR', 'Newark Liberty International Airport', 'Large airport', 'Newport News' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
326INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('PHF', 'Newport News Williamsburg International Airport', 'Large airport', 'Norfolk' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
327INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ORF', 'Norfolk International Airport', 'Large airport', 'Kingston' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
328INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('KIN', 'Norman Manley International Airport', 'Large airport', 'San Jose' , 'Jamaica', FALSE) ON CONFLICT(iata) DO NOTHING;
329INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SJC', 'Norman Y. Mineta San Jose International Airport', 'Large airport', 'Ontario' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
330INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ONT', 'Ontario International Airport', 'Large airport', 'Orlando' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
331INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MCO', 'Orlando International Airport', 'Large airport', 'Orlando' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
332INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SFB', 'Orlando Sanford International Airport', 'Large airport', 'Ottawa' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
333INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('YOW', 'Ottawa Macdonald-Cartier International Airport', 'Large airport', 'Georgetown' , 'Canada', FALSE) ON CONFLICT(iata) DO NOTHING;
334INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('GCM', 'Owen Roberts International Airport', 'Large airport', 'West Palm Beach' , 'Cayman Islands', FALSE) ON CONFLICT(iata) DO NOTHING;
335INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('PBI', 'Palm Beach International Airport', 'Large airport', 'Philadelphia' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
336INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('PHL', 'Philadelphia International Airport', 'Large airport', 'Belize City' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
337INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BZE', 'Philip S. W. Goldson International Airport', 'Large airport', 'Phoenix' , 'Belize', FALSE) ON CONFLICT(iata) DO NOTHING;
338INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('PHX', 'Phoenix Sky Harbor International Airport', 'Large airport', 'Greensboro' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
339INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('GSO', 'Piedmont Triad International Airport', 'Large airport', 'Pittsburgh' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
340INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('PIT', 'Pittsburgh International Airport', 'Large airport', 'Pointe-à-Pitre' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
341INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('PTP', 'Pointe-à-Pitre Le Raizet', 'Large airport', 'Portland' , 'Guadeloupe', FALSE) ON CONFLICT(iata) DO NOTHING;
342INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('PDX', 'Portland International Airport', 'Large airport', 'Portland' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
343INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('PWM', 'Portland International Jetport Airport', 'Large airport', 'Saint Martin' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
344INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SXM', 'Princess Juliana International Airport', 'Large airport', 'Punta Cana' , 'Sint Maarten', FALSE) ON CONFLICT(iata) DO NOTHING;
345INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('PUJ', 'Punta Cana International Airport', 'Large airport', 'Moline' , 'Dominican Republic', FALSE) ON CONFLICT(iata) DO NOTHING;
346INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MLI', 'Quad City International Airport', 'Large airport', 'Raleigh/Durham' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
347INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('RDU', 'Raleigh Durham International Airport', 'Large airport', 'Universal City' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
348INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('RND', 'Randolph Air Force Base', 'Large airport', 'Hibbing' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
349INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('HIB', 'Range Regional Airport', 'Large airport', 'Reno' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
350INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('RNO', 'Reno Tahoe International Airport', 'Large airport', 'Richmond' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
351INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('RIC', 'Richmond International Airport', 'Large airport', 'Amarillo' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
352INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('AMA', 'Rick Husband Amarillo International Airport', 'Large airport', 'Columbus' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
353INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('LCK', 'Rickenbacker International Airport', 'Large airport', 'Roanoke' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
354INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ROA', 'Roanoke–Blacksburg Regional Airport', 'Large airport', 'Warner Robins' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
355INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('WRB', 'Robins Air Force Base', 'Large airport', 'Rochester' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
356INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('RST', 'Rochester International Airport', 'Large airport', 'Washington' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
357INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DCA', 'Ronald Reagan Washington National Airport', 'Large airport', 'Sacramento' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
358INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SMF', 'Sacramento International Airport', 'Large airport', 'Salt Lake City' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
359INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SLC', 'Salt Lake City International Airport', 'Large airport', 'San Antonio' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
360INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SAT', 'San Antonio International Airport', 'Large airport', 'San Diego' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
361INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SAN', 'San Diego International Airport', 'Large airport', 'San Francisco' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
362INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SFO', 'San Francisco International Airport', 'Large airport', 'Sarasota/Bradenton' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
363INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SRQ', 'Sarasota Bradenton International Airport', 'Large airport', 'Savannah' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
364INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SAV', 'Savannah Hilton Head International Airport', 'Large airport', 'Belleville' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
365INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BLV', 'Scott AFB/Midamerica Airport', 'Large airport', 'Seattle' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
366INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SEA', 'Seattle-Tacoma International Airport', 'Large airport', 'Goldsboro' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
367INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('GSB', 'Seymour Johnson Air Force Base', 'Large airport', 'Sumter' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
368INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SSC', 'Shaw Air Force Base', 'Large airport', 'Wichita Falls' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
369INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SPS', 'Sheppard Air Force Base-Wichita Falls Municipal Airport', 'Large airport', 'Sioux City' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
370INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SUX', 'Sioux Gateway Col. Bud Day Field', 'Large airport', 'South Bend' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
371INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SBN', 'South Bend Regional Airport', 'Large airport', 'Fort Myers' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
372INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('RSW', 'Southwest Florida International Airport', 'Large airport', 'St Louis' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
373INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SUS', 'Spirit of St Louis Airport', 'Large airport', 'Spokane' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
374INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('GEG', 'Spokane International Airport', 'Large airport', 'Springfield' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
375INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SGF', 'Springfield Branson National Airport', 'Large airport', 'St Louis' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
376INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('STL', 'St Louis Lambert International Airport', 'Large airport', 'St. John''s' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
377INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('YYT', 'St. John''s International Airport', 'Large airport', 'Syracuse' , 'Canada', FALSE) ON CONFLICT(iata) DO NOTHING;
378INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SYR', 'Syracuse Hancock International Airport', 'Large airport', 'Tallahassee' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
379INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('TLH', 'Tallahassee Regional Airport', 'Large airport', 'Tampa' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
380INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('TPA', 'Tampa International Airport', 'Large airport', 'Anchorage' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
381INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ANC', 'Ted Stevens Anchorage International Airport', 'Large airport', 'Cedar Rapids' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
382INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CID', 'The Eastern Iowa Airport', 'Large airport', 'Providence' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
383INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('PVD', 'Theodore Francis Green State Airport', 'Large airport', 'Oklahoma City' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
384INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('TIK', 'Tinker Air Force Base', 'Large airport', 'Tocumen' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
385INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('PTY', 'Tocumen International Airport', 'Large airport', 'Toledo' , 'Panama', FALSE) ON CONFLICT(iata) DO NOTHING;
386INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('TOL', 'Toledo Express Airport', 'Large airport', 'Fairfield' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
387INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SUU', 'Travis Air Force Base', 'Large airport', 'Bristol/Johnson/Kingsport' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
388INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('TRI', 'Tri-Cities Regional TN/VA Airport', 'Large airport', 'Huntington' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
389INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('HTS', 'Tri-State/Milton J. Ferguson Field', 'Large airport', 'Tucson' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
390INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('TUS', 'Tucson International Airport', 'Large airport', 'Tulsa' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
391INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('TUL', 'Tulsa International Airport', 'Large airport', 'Panama City' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
392INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('PAM', 'Tyndall Air Force Base', 'Large airport', 'Enid' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
393INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('END', 'Vance Air Force Base', 'Large airport', 'Vancouver' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
394INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('YVR', 'Vancouver International Airport', 'Large airport', 'Lompoc' , 'Canada', FALSE) ON CONFLICT(iata) DO NOTHING;
395INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('VBG', 'Vandenberg Air Force Base', 'Large airport', 'Victoria' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
396INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('YYJ', 'Victoria International Airport', 'Large airport', 'Washington' , 'Canada', FALSE) ON CONFLICT(iata) DO NOTHING;
397INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('IAD', 'Washington Dulles International Airport', 'Large airport', 'Knob Noster' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
398INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SZL', 'Whiteman Air Force Base', 'Large airport', 'Wichita' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
399INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ICT', 'Wichita Eisenhower National Airport', 'Large airport', 'Oklahoma City' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
400INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('OKC', 'Will Rogers World Airport', 'Large airport', 'Houston' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
401INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('HOU', 'William P Hobby Airport', 'Large airport', 'Winnipeg' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
402INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('YWG', 'Winnipeg / James Armstrong Richardson International Airport', 'Large airport', 'Dayton' , 'Canada', FALSE) ON CONFLICT(iata) DO NOTHING;
403INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('FFO', 'Wright-Patterson Air Force Base', 'Large airport', 'Charleston' , 'United States', FALSE) ON CONFLICT(iata) DO NOTHING;
404INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CRW', 'Yeager Airport', 'Large airport', 'Sorong' , 'United State', FALSE) ON CONFLICT(iata) DO NOTHING;
405INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SOQ', 'Dominique Edward Osok Airport', 'Large airport', 'Makassar' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
406INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('UPG', 'Hasanuddin International Airport', 'Large airport', 'Surabaya' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
407INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SUB', 'Juanda International Airport', 'Large airport', 'Medan' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
408INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('KNO', 'Kualanamu International Airport', 'Large airport', 'Bali' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
409INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DPS', 'Ngurah Rai (Bali) International Airport', 'Large airport', 'Jayapura' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
410INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DJJ', 'Sentani International Airport', 'Large airport', 'Jakarta' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
411INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CGK', 'Soekarno-Hatta International Airport', 'Large airport', 'Padang' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
412INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('AEG', 'Aek Godang Airport', 'Medium airport', 'Babo' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
413INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BXB', 'Babo Airport', 'Medium airport', 'Sugapa-Papua Island' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
414INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('UGU', 'Bilogai-Sugapa Airport', 'Medium airport', 'Gunung Sitoli-Nias Island' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
415INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('GNS', 'Binaka Airport', 'Medium airport', 'Langgur-Seram Island' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
416INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('LUV', 'Dumatumbun Airport', 'Medium airport', 'Fakfak-Papua Island' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
417INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('FKQ', 'Fakfak Airport', 'Medium airport', 'Bengkulu-Sumatra Island' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
418INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BKS', 'Fatmawati Soekarno Airport', 'Medium airport', 'Biak-Supiori Island' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
419INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BIK', 'Frans Kaisiepo Airport', 'Medium airport', 'Jakarta Halim' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
420INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('HLP', 'Halim Perdanakusuma International Airport', 'Medium airport', 'Batam' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
421INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BTH', 'Hang Nadim International Airport', 'Medium airport', 'Bandung' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
422INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BDO', 'Husein Sastranegara International Airport', 'Medium airport', 'Rengat' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
423INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('RGT', 'Japura Airport', 'Medium airport', 'Tarakan' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
424INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('TRK', 'Juwata Airport', 'Medium airport', 'Kaimana' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
425INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('KNG', 'Kaimana Airport', 'Medium airport', 'Tanjung Redeb - Borneo Island' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
426INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BEJ', 'Kalimarau Airport', 'Medium airport', 'Poso' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
427INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('PSJ', 'Kasiguncu Airport', 'Medium airport', 'Ketapang-Borneo Island' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
428INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('KTG', 'Ketapang(Rahadi Usman) Airport', 'Medium airport', 'Lhok Sukon-Sumatra Island' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
429INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('LSX', 'Lhok Sukon Airport', 'Medium airport', 'Lombok' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
430INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('LOP', 'Lombok International Airport', 'Medium airport', 'Ketaping/Padang - Sumatra Island' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
431INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('PDG', 'Minangkabau International Airport', 'Medium airport', 'Merauke-Papua Island' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
432INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MKQ', 'Mopah Airport', 'Medium airport', 'Timika-Papua Island' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
433INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('TIM', 'Moses Kilangin Airport', 'Medium airport', 'Palu-Celebes Island' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
434INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('PLW', 'Mutiara Airport', 'Medium airport', 'Nabire-Papua Island' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
435INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('NBX', 'Nabire Airport', 'Medium airport', 'Tahuna-Sangihe Island' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
436INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('NAH', 'Naha Airport', 'Medium airport', 'Nanga Pinoh-Borneo Island' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
437INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('NPO', 'Nanga Pinoh Airport', 'Medium airport', 'Putussibau-Borneo Island' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
438INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('PSU', 'Pangsuma Airport', 'Medium airport', 'Ambon' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
439INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('AMQ', 'Pattimura Airport, Ambon', 'Medium airport', 'Talang Gudang-Sumatra Island' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
440INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('PDO', 'Pendopo Airport', 'Medium airport', 'Dumai' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
441INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DUM', 'Pinang Kampai Airport', 'Medium airport', 'Gotalalamo-Morotai Island' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
442INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('OTI', 'Pitu Airport', 'Medium airport', 'Bandar Lampung-Sumatra Island' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
443INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('TKG', 'Radin Inten II (Branti) Airport', 'Medium airport', 'Ranai-Natuna Besar Island' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
444INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('NTX', 'Ranai Airport', 'Medium airport', 'Manokwari-Papua Island' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
445INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MKW', 'Rendani Airport', 'Medium airport', 'Manado' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
446INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MDC', 'Sam Ratulangi Airport', 'Medium airport', 'Sintang-Borneo Island' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
447INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SQG', 'Sintang(Susilo) Airport', 'Medium airport', 'Medan Soewondo' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
448INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MES', 'Soewondo Air Force Base', 'Medium airport', 'Banda Aceh' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
449INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BTJ', 'Sultan Iskandar Muda International Airport', 'Medium airport', 'Sango-Ternate Island' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
450INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('TTE', 'Sultan Khairun Babullah Airport', 'Medium airport', 'Palembang-Sumatra Island' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
451INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('PLM', 'Sultan Mahmud Badaruddin II Airport', 'Medium airport', 'Pekanbaru-Sumatra Island' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
452INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('PKU', 'Sultan Syarif Kasim Ii (Simpang Tiga) Airport', 'Medium airport', 'Pontianak-Borneo Island' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
453INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('PNK', 'Supadio Airport', 'Medium airport', 'Luwok' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
454INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('LUW', 'Syukuran Aminuddin Amir Airport', 'Medium airport', 'Samarinda' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
455INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SRI', 'Temindung Airport', 'Medium airport', 'Cilacap' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
456INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CXP', 'Tunggul Wulung Airport', 'Medium airport', 'Wamena' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
457INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('WMX', 'Wamena Airport', 'Medium airport', 'Tanita-Tabalong' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
458INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('TJG', 'Warukin Airport', 'Medium airport', 'Shenyang' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
459INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SHE', 'Taoxian Airport', 'Large airport', 'Dalian' , 'China', FALSE) ON CONFLICT(iata) DO NOTHING;
460INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DLC', 'Zhoushuizi Airport', 'Large airport', 'Harbin' , 'China', FALSE) ON CONFLICT(iata) DO NOTHING;
461INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('HRB', 'Taiping Airport', 'Large airport', 'Ürümqi' , 'China', FALSE) ON CONFLICT(iata) DO NOTHING;
462INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('URC', 'Ürümqi Diwopu International Airport', 'Large airport', 'Chengdu' , 'China', FALSE) ON CONFLICT(iata) DO NOTHING;
463INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CTU', 'Chengdu Shuangliu International Airport', 'Large airport', 'Guiyang' , 'China', FALSE) ON CONFLICT(iata) DO NOTHING;
464INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('KWE', 'Longdongbao Airport', 'Large airport', 'Chongqing' , 'China', FALSE) ON CONFLICT(iata) DO NOTHING;
465INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CKG', 'Chongqing Jiangbei International Airport', 'Large airport', 'Wenzhou' , 'China', FALSE) ON CONFLICT(iata) DO NOTHING;
466INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('WNZ', 'Wenzhou Longwan International Airport', 'Large airport', 'Shanghai' , 'China', FALSE) ON CONFLICT(iata) DO NOTHING;
467INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SHA', 'Shanghai Hongqiao International Airport', 'Large airport', 'Shanghai' , 'China', FALSE) ON CONFLICT(iata) DO NOTHING;
468INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('PVG', 'Shanghai Pudong International Airport', 'Large airport', 'Nanjing' , 'China', FALSE) ON CONFLICT(iata) DO NOTHING;
469INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('NKG', 'Nanjing Lukou Airport', 'Large airport', 'Ningbo' , 'China', FALSE) ON CONFLICT(iata) DO NOTHING;
470INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('NGB', 'Ningbo Lishe International Airport', 'Large airport', 'Jinan' , 'China', FALSE) ON CONFLICT(iata) DO NOTHING;
471INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('TNA', 'Yaoqiang Airport', 'Large airport', 'Hangzhou' , 'China', FALSE) ON CONFLICT(iata) DO NOTHING;
472INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('HGH', 'Hangzhou Xiaoshan International Airport', 'Large airport', 'Fuzhou' , 'China', FALSE) ON CONFLICT(iata) DO NOTHING;
473INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('FOC', 'Fuzhou Changle International Airport', 'Large airport', 'Xiamen' , 'China', FALSE) ON CONFLICT(iata) DO NOTHING;
474INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('XMN', 'Xiamen Gaoqi International Airport', 'Large airport', 'Kunming' , 'China', FALSE) ON CONFLICT(iata) DO NOTHING;
475INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('KMG', 'Kunming Changshui International Airport', 'Large airport', 'Ulan Bator' , 'China', FALSE) ON CONFLICT(iata) DO NOTHING;
476INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ULN', 'Chinggis Khaan International Airport', 'Large airport', 'Xi''an' , 'Mongolia', FALSE) ON CONFLICT(iata) DO NOTHING;
477INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('XIY', 'Xi''an Xianyang International Airport', 'Large airport', 'Sanya' , 'China', FALSE) ON CONFLICT(iata) DO NOTHING;
478INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SYX', 'Sanya Phoenix International Airport', 'Large airport', 'Haikou' , 'China', FALSE) ON CONFLICT(iata) DO NOTHING;
479INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('HAK', 'Haikou Meilan International Airport', 'Large airport', 'Wuhan' , 'China', FALSE) ON CONFLICT(iata) DO NOTHING;
480INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('WUH', 'Wuhan Tianhe International Airport', 'Large airport', 'Zhengzhou' , 'China', FALSE) ON CONFLICT(iata) DO NOTHING;
481INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CGO', 'Zhengzhou Xinzheng International Airport', 'Large airport', 'Shenzhen' , 'China', FALSE) ON CONFLICT(iata) DO NOTHING;
482INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SZX', 'Shenzhen Bao''an International Airport', 'Large airport', 'Nanning' , 'China', FALSE) ON CONFLICT(iata) DO NOTHING;
483INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('NNG', 'Nanning Wuxu Airport', 'Large airport', 'Guilin City' , 'China', FALSE) ON CONFLICT(iata) DO NOTHING;
484INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('KWL', 'Guilin Liangjiang International Airport', 'Large airport', 'Changsha' , 'China', FALSE) ON CONFLICT(iata) DO NOTHING;
485INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CSX', 'Changsha Huanghua International Airport', 'Large airport', 'Guangzhou' , 'China', FALSE) ON CONFLICT(iata) DO NOTHING;
486INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CAN', 'Guangzhou Baiyun International Airport', 'Large airport', 'Taiyuan' , 'China', FALSE) ON CONFLICT(iata) DO NOTHING;
487INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('TYN', 'Taiyuan Wusu Airport', 'Large airport', 'Tianjin' , 'China', FALSE) ON CONFLICT(iata) DO NOTHING;
488INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('TSN', 'Tianjin Binhai International Airport', 'Large airport', 'Singapore' , 'China', FALSE) ON CONFLICT(iata) DO NOTHING;
489INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SIN', 'Singapore Changi Airport', 'Large airport', 'Kuala Lumpur' , 'Singapore', FALSE) ON CONFLICT(iata) DO NOTHING;
490INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('KUL', 'Kuala Lumpur International Airport', 'Large airport', 'Bandar Seri Begawan' , 'Malaysia', FALSE) ON CONFLICT(iata) DO NOTHING;
491INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BWN', 'Brunei International Airport', 'Large airport', 'Sorong-Papua Island' , 'Brunei', FALSE) ON CONFLICT(iata) DO NOTHING;
492INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SOQ', 'Dominique Edward Osok Airport', 'Large airport', 'Jayapura-Papua Island' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
493INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DJJ', 'Sentani International Airport', 'Large airport', 'Denpasar-Bali Island' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
494INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DPS', 'Ngurah Rai (Bali) International Airport', 'Large airport', 'Ujung Pandang-Celebes Island' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
495INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('UPG', 'Hasanuddin International Airport', 'Large airport', 'Yangon' , 'Indonesia', FALSE) ON CONFLICT(iata) DO NOTHING;
496INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('RGN', 'Yangon International Airport', 'Large airport', 'Mandalay' , 'Burma', FALSE) ON CONFLICT(iata) DO NOTHING;
497INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MDL', 'Mandalay International Airport', 'Large airport', 'Ho Chi Minh City' , 'Burma', FALSE) ON CONFLICT(iata) DO NOTHING;
498INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SGN', 'Tan Son Nhat International Airport', 'Large airport', 'Hanoi' , 'Vietnam', FALSE) ON CONFLICT(iata) DO NOTHING;
499INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('HAN', 'Noi Bai International Airport', 'Large airport', 'Da Nang' , 'Vietnam', FALSE) ON CONFLICT(iata) DO NOTHING;
500INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DAD', 'Da Nang International Airport', 'Large airport', 'Phuket' , 'Vietnam', FALSE) ON CONFLICT(iata) DO NOTHING;
501INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('HKT', 'Phuket International Airport', 'Large airport', 'Chiang Mai' , 'Thailand', FALSE) ON CONFLICT(iata) DO NOTHING;
502INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CNX', 'Chiang Mai International Airport', 'Large airport', 'Bangkok' , 'Thailand', FALSE) ON CONFLICT(iata) DO NOTHING;
503INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BKK', 'Suvarnabhumi Airport', 'Large airport', 'Bangkok' , 'Thailand', FALSE) ON CONFLICT(iata) DO NOTHING;
504INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DMK', 'Don Mueang International Airport', 'Large airport', 'Malé' , 'Thailand', FALSE) ON CONFLICT(iata) DO NOTHING;
505INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MLE', 'Malé International Airport', 'Large airport', 'Thiruvananthapuram' , 'Maldives', FALSE) ON CONFLICT(iata) DO NOTHING;
506INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('TRV', 'Trivandrum International Airport', 'Large airport', 'Chennai' , 'India', FALSE) ON CONFLICT(iata) DO NOTHING;
507INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MAA', 'Chennai International Airport', 'Large airport', 'Hyderabad' , 'India', FALSE) ON CONFLICT(iata) DO NOTHING;
508INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('HYD', 'Rajiv Gandhi International Airport', 'Large airport', 'Vasco da Gama' , 'India', FALSE) ON CONFLICT(iata) DO NOTHING;
509INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('GOI', 'Dabolim Airport', 'Large airport', 'Calicut' , 'India', FALSE) ON CONFLICT(iata) DO NOTHING;
510INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CCJ', 'Calicut International Airport', 'Large airport', 'Kochi' , 'India', FALSE) ON CONFLICT(iata) DO NOTHING;
511INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('COK', 'Cochin International Airport', 'Large airport', 'Bangalore' , 'India', FALSE) ON CONFLICT(iata) DO NOTHING;
512INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BLR', 'Kempegowda International Airport', 'Large airport', 'Kathmandu' , 'India', FALSE) ON CONFLICT(iata) DO NOTHING;
513INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('KTM', 'Tribhuvan International Airport', 'Large airport', 'Macau' , 'Nepal', FALSE) ON CONFLICT(iata) DO NOTHING;
514INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MFM', 'Macau International Airport', 'Large airport', 'New Delhi' , 'Macau', FALSE) ON CONFLICT(iata) DO NOTHING;
515INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DEL', 'Indira Gandhi International Airport', 'Large airport', 'Amritsar' , 'India', FALSE) ON CONFLICT(iata) DO NOTHING;
516INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ATQ', 'Sri Guru Ram Dass Jee International Airport', 'Large airport', 'Hong Kong' , 'India', FALSE) ON CONFLICT(iata) DO NOTHING;
517INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('HKG', 'Hong Kong International Airport', 'Large airport', 'Dhaka' , 'Hong Kong', FALSE) ON CONFLICT(iata) DO NOTHING;
518INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DAC', 'Hazrat Shahjalal International Airport', 'Large airport', 'Kolkata' , 'Bangladesh', FALSE) ON CONFLICT(iata) DO NOTHING;
519INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CCU', 'Netaji Subhash Chandra Bose International Airport', 'Large airport', 'Siem Reap' , 'India', FALSE) ON CONFLICT(iata) DO NOTHING;
520INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('REP', 'Siem Reap International Airport', 'Large airport', 'Phnom Penh' , 'Cambodia', FALSE) ON CONFLICT(iata) DO NOTHING;
521INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('PNH', 'Phnom Penh International Airport', 'Large airport', 'Mattalla' , 'Cambodia', FALSE) ON CONFLICT(iata) DO NOTHING;
522INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('HRI', 'Mattala Rajapaksa International Airport', 'Large airport', 'Mumbai' , 'Sri Lanka', FALSE) ON CONFLICT(iata) DO NOTHING;
523INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BOM', 'Mumbai International Airport', 'Large airport', 'Tashkent' , 'India', FALSE) ON CONFLICT(iata) DO NOTHING;
524INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('TAS', 'Tashkent International Airport', 'Large airport', 'Yekaterinburg' , 'Uzbekistan', FALSE) ON CONFLICT(iata) DO NOTHING;
525INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SVX', 'Koltsovo Airport', 'Large airport', 'Novosibirsk' , 'Russia', FALSE) ON CONFLICT(iata) DO NOTHING;
526INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('OVB', 'Tolmachevo Airport', 'Large airport', 'Khabarovsk' , 'Russia', FALSE) ON CONFLICT(iata) DO NOTHING;
527INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('KHV', 'Khabarovsk-Novy Airport', 'Large airport', 'Tbilisi' , 'Russia', FALSE) ON CONFLICT(iata) DO NOTHING;
528INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('TBS', 'Tbilisi International Airport', 'Large airport', 'Yerevan' , 'Georgia', FALSE) ON CONFLICT(iata) DO NOTHING;
529INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('EVN', 'Zvartnots International Airport', 'Large airport', 'Bishkek' , 'Armenia', FALSE) ON CONFLICT(iata) DO NOTHING;
530INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('FRU', 'Manas International Airport', 'Large airport', 'Baku' , 'Kyrgyzstan', FALSE) ON CONFLICT(iata) DO NOTHING;
531INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('GYD', 'Heydar Aliyev International Airport', 'Large airport', 'Karaganda' , 'Azerbaijan', FALSE) ON CONFLICT(iata) DO NOTHING;
532INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('KGF', 'Sary-Arka Airport', 'Large airport', 'Lapu-Lapu City' , 'Kazakhstan', FALSE) ON CONFLICT(iata) DO NOTHING;
533INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CEB', 'Mactan Cebu International Airport', 'Large airport', 'Cagayan de Oro City' , 'Philippines', FALSE) ON CONFLICT(iata) DO NOTHING;
534INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CGY', 'Laguindingan Airport', 'Large airport', 'Davao City' , 'Philippines', FALSE) ON CONFLICT(iata) DO NOTHING;
535INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DVO', 'Francisco Bangoy International Airport', 'Large airport', 'Manila' , 'Philippines', FALSE) ON CONFLICT(iata) DO NOTHING;
536INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MNL', 'Ninoy Aquino International Airport', 'Large airport', 'Angeles/Mabalacat' , 'Philippines', FALSE) ON CONFLICT(iata) DO NOTHING;
537INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CRK', 'Diosdado Macapagal International Airport', 'Large airport', 'Nakagami' , 'Philippines', FALSE) ON CONFLICT(iata) DO NOTHING;
538INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DNA', 'Kadena Air Base', 'Large airport', 'Naha' , 'Japan', FALSE) ON CONFLICT(iata) DO NOTHING;
539INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('OKA', 'Naha Airport', 'Large airport', 'Seoul' , 'Japan', FALSE) ON CONFLICT(iata) DO NOTHING;
540INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('GMP', 'Gimpo International Airport', 'Large airport', 'Pyeongtaek' , 'South Korea', FALSE) ON CONFLICT(iata) DO NOTHING;
541INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('OSN', 'Osan Air Base', 'Large airport', 'Seoul' , 'South Korea', FALSE) ON CONFLICT(iata) DO NOTHING;
542INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ICN', 'Seoul Incheon International Airport', 'Large airport', 'Busan' , 'South Korea', FALSE) ON CONFLICT(iata) DO NOTHING;
543INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('PUS', 'Gimhae International Airport', 'Large airport', 'Jeju City' , 'South Korea', FALSE) ON CONFLICT(iata) DO NOTHING;
544INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CJU', 'Jeju International Airport', 'Large airport', 'Kunsan' , 'South Korea', FALSE) ON CONFLICT(iata) DO NOTHING;
545INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('KUV', 'Kunsan Air Base', 'Large airport', 'Piseo-ri (Muan)' , 'South Korea', FALSE) ON CONFLICT(iata) DO NOTHING;
546INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MWX', 'Muan International Airport', 'Large airport', 'Fussa' , 'South Korea', FALSE) ON CONFLICT(iata) DO NOTHING;
547INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('OKO', 'Yokota Air Base', 'Large airport', 'Tokyo' , 'Japan', FALSE) ON CONFLICT(iata) DO NOTHING;
548INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('HND', 'Tokyo Haneda Airport', 'Large airport', 'Osaka' , 'Japan', FALSE) ON CONFLICT(iata) DO NOTHING;
549INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ITM', 'Osaka International Airport', 'Large airport', 'Makinohara / Shimada' , 'Japan', FALSE) ON CONFLICT(iata) DO NOTHING;
550INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('FSZ', 'Mt. Fuji Shizuoka Airport', 'Large airport', 'Tokoname' , 'Japan', FALSE) ON CONFLICT(iata) DO NOTHING;
551INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('NGO', 'Chubu Centrair International Airport', 'Large airport', 'Kagoshima' , 'Japan', FALSE) ON CONFLICT(iata) DO NOTHING;
552INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('KOJ', 'Kagoshima Airport', 'Large airport', 'Fukuoka' , 'Japan', FALSE) ON CONFLICT(iata) DO NOTHING;
553INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('FUK', 'Fukuoka Airport', 'Large airport', 'Chitose / Tomakomai' , 'Japan', FALSE) ON CONFLICT(iata) DO NOTHING;
554INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CTS', 'New Chitose Airport', 'Large airport', 'Osaka' , 'Japan', FALSE) ON CONFLICT(iata) DO NOTHING;
555INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('KIX', 'Kansai International Airport', 'Large airport', 'Tokyo' , 'Japan', FALSE) ON CONFLICT(iata) DO NOTHING;
556INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('NRT', 'Narita International Airport', 'Large airport', 'Taipei' , 'Japan', FALSE) ON CONFLICT(iata) DO NOTHING;
557INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('TPE', 'Taiwan Taoyuan International Airport', 'Large airport', 'Kaohsiung City' , 'Taiwan', FALSE) ON CONFLICT(iata) DO NOTHING;
558INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('KHH', 'Kaohsiung International Airport', 'Large airport', 'Shang-I' , 'Taiwan', FALSE) ON CONFLICT(iata) DO NOTHING;
559INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('KNH', 'Kinmen Airport', 'Large airport', 'Doha' , 'Taiwan', FALSE) ON CONFLICT(iata) DO NOTHING;
560INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DOH', 'Hamad International Airport', 'Large airport', 'Damascus' , 'Qatar', FALSE) ON CONFLICT(iata) DO NOTHING;
561INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DAM', 'Damascus International Airport', 'Large airport', 'Sialkot' , 'Syria', FALSE) ON CONFLICT(iata) DO NOTHING;
562INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SKT', 'Sialkot Airport', 'Large airport', 'Islamabad' , 'Pakistan', FALSE) ON CONFLICT(iata) DO NOTHING;
563INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ISB', 'New Islamabad International Airport', 'Large airport', 'Al Masna''ah' , 'Pakistan', FALSE) ON CONFLICT(iata) DO NOTHING;
564INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MNH', 'Rustaq Airport', 'Large airport', 'Muscat' , 'Oman', FALSE) ON CONFLICT(iata) DO NOTHING;
565INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MCT', 'Muscat International Airport', 'Large airport', 'Duqm' , 'Oman', FALSE) ON CONFLICT(iata) DO NOTHING;
566INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DQM', 'Duqm International Airport', 'Large airport', 'Sharjah' , 'Oman', FALSE) ON CONFLICT(iata) DO NOTHING;
567INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SHJ', 'Sharjah International Airport', 'Large airport', 'Dubai' , 'United Arab Emirates', FALSE) ON CONFLICT(iata) DO NOTHING;
568INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DXB', 'Dubai International Airport', 'Large airport', 'Kuwait City' , 'United Arab Emirates', FALSE) ON CONFLICT(iata) DO NOTHING;
569INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('KWI', 'Kuwait International Airport', 'Large airport', 'Amman' , 'Kuwait', FALSE) ON CONFLICT(iata) DO NOTHING;
570INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('AMM', 'Queen Alia International Airport', 'Large airport', 'Tabriz' , 'Jordan', FALSE) ON CONFLICT(iata) DO NOTHING;
571INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('TBZ', 'Tabriz International Airport', 'Large airport', 'Shiraz' , 'Iran', FALSE) ON CONFLICT(iata) DO NOTHING;
572INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SYZ', 'Shiraz Shahid Dastghaib International Airport', 'Large airport', 'Mashhad' , 'Iran', FALSE) ON CONFLICT(iata) DO NOTHING;
573INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MHD', 'Mashhad International Airport', 'Large airport', 'Tehran' , 'Iran', FALSE) ON CONFLICT(iata) DO NOTHING;
574INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('THR', 'Mehrabad International Airport', 'Large airport', 'Tehran' , 'Iran', FALSE) ON CONFLICT(iata) DO NOTHING;
575INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('IKA', 'Imam Khomeini International Airport', 'Large airport', 'Riyadh' , 'Iran', FALSE) ON CONFLICT(iata) DO NOTHING;
576INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('RUH', 'King Khaled International Airport', 'Large airport', 'Medina' , 'Saudi Arabia', FALSE) ON CONFLICT(iata) DO NOTHING;
577INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MED', 'Prince Mohammad Bin Abdulaziz Airport', 'Large airport', 'Jeddah' , 'Saudi Arabia', FALSE) ON CONFLICT(iata) DO NOTHING;
578INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('JED', 'King Abdulaziz International Airport', 'Large airport', 'Dhahran' , 'Saudi Arabia', FALSE) ON CONFLICT(iata) DO NOTHING;
579INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DHA', 'King Abdulaziz Air Base', 'Large airport', 'Ad Dammam' , 'Saudi Arabia', FALSE) ON CONFLICT(iata) DO NOTHING;
580INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DMM', 'King Fahd International Airport', 'Large airport', 'Istanbul' , 'Saudi Arabia', FALSE) ON CONFLICT(iata) DO NOTHING;
581INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('IST', 'İstanbul New Airport', 'Large airport', 'Istanbul' , 'Turkey', FALSE) ON CONFLICT(iata) DO NOTHING;
582INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SAW', 'Sabiha Gökçen International Airport', 'Large airport', 'Bodrum' , 'Turkey', FALSE) ON CONFLICT(iata) DO NOTHING;
583INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BJV', 'Milas Bodrum Airport', 'Large airport', 'Isparta' , 'Turkey', FALSE) ON CONFLICT(iata) DO NOTHING;
584INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ISE', 'Süleyman Demirel International Airport', 'Large airport', 'Trabzon' , 'Turkey', FALSE) ON CONFLICT(iata) DO NOTHING;
585INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('TZX', 'Trabzon International Airport', 'Large airport', 'Erzurum' , 'Turkey', FALSE) ON CONFLICT(iata) DO NOTHING;
586INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ERZ', 'Erzurum International Airport', 'Large airport', 'Dalaman' , 'Turkey', FALSE) ON CONFLICT(iata) DO NOTHING;
587INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DLM', 'Dalaman International Airport', 'Large airport', 'Gaziantep' , 'Turkey', FALSE) ON CONFLICT(iata) DO NOTHING;
588INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('GZT', 'Gaziantep International Airport', 'Large airport', 'Ankara' , 'Turkey', FALSE) ON CONFLICT(iata) DO NOTHING;
589INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ESB', 'Esenboğa International Airport', 'Large airport', 'Eilat' , 'Turkey', FALSE) ON CONFLICT(iata) DO NOTHING;
590INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('VDA', 'Ovda International Airport', 'Large airport', 'Tel Aviv' , 'Israel', FALSE) ON CONFLICT(iata) DO NOTHING;
591INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('TLV', 'Ben Gurion International Airport', 'Large airport', 'Paphos' , 'Israel', FALSE) ON CONFLICT(iata) DO NOTHING;
592INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('PFO', 'Paphos International Airport', 'Large airport', 'Larnarca' , 'Cyprus', FALSE) ON CONFLICT(iata) DO NOTHING;
593INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('LCA', 'Larnaca International Airport', 'Large airport', 'Bergen' , 'Cyprus', FALSE) ON CONFLICT(iata) DO NOTHING;
594INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BGO', 'Bergen Airport Flesland', 'Large airport', 'Berlin' , 'Norway', FALSE) ON CONFLICT(iata) DO NOTHING;
595INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SXF', 'Berlin-Schönefeld Airport', 'Large airport', 'Berlin' , 'Germany', FALSE) ON CONFLICT(iata) DO NOTHING;
596INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('TXL', 'Berlin-Tegel Airport', 'Large airport', 'Billund' , 'Germany', FALSE) ON CONFLICT(iata) DO NOTHING;
597INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BLL', 'Billund Airport', 'Large airport', 'Birmingham' , 'Denmark', FALSE) ON CONFLICT(iata) DO NOTHING;
598INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BHX', 'Birmingham International Airport', 'Large airport', 'Bodø' , 'United Kingdom', FALSE) ON CONFLICT(iata) DO NOTHING;
599INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BOO', 'Bodø Airport', 'Large airport', 'Bologna' , 'Norway', FALSE) ON CONFLICT(iata) DO NOTHING;
600INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BLQ', 'Bologna Guglielmo Marconi Airport', 'Large airport', 'Bordeaux' , 'Italy', FALSE) ON CONFLICT(iata) DO NOTHING;
601INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BOD', 'Bordeaux-Mérignac Airport', 'Large airport', 'Kiev' , 'France', FALSE) ON CONFLICT(iata) DO NOTHING;
602INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('KBP', 'Boryspil International Airport', 'Large airport', 'Bournemouth' , 'Ukraine', FALSE) ON CONFLICT(iata) DO NOTHING;
603INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BOH', 'Bournemouth Airport', 'Large airport', 'Bremen' , 'United Kingdom', FALSE) ON CONFLICT(iata) DO NOTHING;
604INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BRE', 'Bremen Airport', 'Large airport', 'Bristol' , 'Germany', FALSE) ON CONFLICT(iata) DO NOTHING;
605INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BRS', 'Bristol Airport', 'Large airport', 'Brussels' , 'United Kingdom', FALSE) ON CONFLICT(iata) DO NOTHING;
606INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BRU', 'Brussels Airport', 'Large airport', 'Brussels' , 'Belgium', FALSE) ON CONFLICT(iata) DO NOTHING;
607INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CRL', 'Brussels South Charleroi Airport', 'Large airport', 'Budapest' , 'Belgium', FALSE) ON CONFLICT(iata) DO NOTHING;
608INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BUD', 'Budapest Liszt Ferenc International Airport', 'Large airport', 'Burgas' , 'Hungary', FALSE) ON CONFLICT(iata) DO NOTHING;
609INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BOJ', 'Burgas Airport', 'Large airport', 'Cagliari' , 'Bulgaria', FALSE) ON CONFLICT(iata) DO NOTHING;
610INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CAG', 'Cagliari Elmas Airport', 'Large airport', 'Cardiff' , 'Italy', FALSE) ON CONFLICT(iata) DO NOTHING;
611INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CWL', 'Cardiff International Airport', 'Large airport', 'Catania' , 'United Kingdom', FALSE) ON CONFLICT(iata) DO NOTHING;
612INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CTA', 'Catania-Fontanarossa Airport', 'Large airport', 'Paris' , 'Italy', FALSE) ON CONFLICT(iata) DO NOTHING;
613INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CDG', 'Paris-Charles de Gaulle Airport', 'Large airport', 'Rome' , 'France', FALSE) ON CONFLICT(iata) DO NOTHING;
614INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CIA', 'Rome–Ciampino International Airport "G. B. Pastine"', 'Large airport', 'Cologne' , 'Italy', FALSE) ON CONFLICT(iata) DO NOTHING;
615INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CGN', 'Cologne Bonn Airport', 'Large airport', 'Copenhagen' , 'Germany', FALSE) ON CONFLICT(iata) DO NOTHING;
616INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CPH', 'Copenhagen Kastrup Airport', 'Large airport', 'Wrocław' , 'Denmark', FALSE) ON CONFLICT(iata) DO NOTHING;
617INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('WRO', 'Copernicus Airport Wrocław', 'Large airport', 'Cork' , 'Poland', FALSE) ON CONFLICT(iata) DO NOTHING;
618INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ORK', 'Cork Airport', 'Large airport', 'Moscow' , 'Ireland', FALSE) ON CONFLICT(iata) DO NOTHING;
619INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DME', 'Domodedovo International Airport', 'Large airport', 'Dortmund' , 'Russia', FALSE) ON CONFLICT(iata) DO NOTHING;
620INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DTM', 'Dortmund Airport', 'Large airport', 'Dresden' , 'Germany', FALSE) ON CONFLICT(iata) DO NOTHING;
621INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DRS', 'Dresden Airport', 'Large airport', 'Dublin' , 'Germany', FALSE) ON CONFLICT(iata) DO NOTHING;
622INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DUB', 'Dublin Airport', 'Large airport', 'Düsseldorf' , 'Ireland', FALSE) ON CONFLICT(iata) DO NOTHING;
623INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DUS', 'Düsseldorf Airport', 'Large airport', 'Nottingham' , 'Germany', FALSE) ON CONFLICT(iata) DO NOTHING;
624INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('EMA', 'East Midlands Airport', 'Large airport', 'Edinburgh' , 'United Kingdom', FALSE) ON CONFLICT(iata) DO NOTHING;
625INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('EDI', 'Edinburgh Airport', 'Large airport', 'Eindhoven' , 'United Kingdom', FALSE) ON CONFLICT(iata) DO NOTHING;
626INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('EIN', 'Eindhoven Airport', 'Large airport', 'Athens' , 'The Netherlands', FALSE) ON CONFLICT(iata) DO NOTHING;
627INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ATH', 'Athens International Airport "Eleftherios Venizelos"', 'Large airport', 'Bâle/Mulhouse' , 'Greece', FALSE) ON CONFLICT(iata) DO NOTHING;
628INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BSL', 'EuroAirport Basel-Mulhouse-Freiburg Airport', 'Large airport', 'Exeter' , 'France', FALSE) ON CONFLICT(iata) DO NOTHING;
629INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('EXT', 'Exeter International Airport', 'Large airport', 'Palermo' , 'United Kingdom', FALSE) ON CONFLICT(iata) DO NOTHING;
630INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('PMO', 'Falcone–Borsellino Airport', 'Large airport', 'Faro' , 'Italy', FALSE) ON CONFLICT(iata) DO NOTHING;
631INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('FAO', 'Faro Airport', 'Large airport', 'Porto' , 'Portugal', FALSE) ON CONFLICT(iata) DO NOTHING;
632INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('OPO', 'Francisco de Sá Carneiro Airport', 'Large airport', 'Frankfurt am Main' , 'Portugal', FALSE) ON CONFLICT(iata) DO NOTHING;
633INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('FRA', 'Frankfurt am Main Airport', 'Large airport', 'Gdańsk' , 'Germany', FALSE) ON CONFLICT(iata) DO NOTHING;
634INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('GDN', 'Gdańsk Lech Wałęsa Airport', 'Large airport', 'Geneva' , 'Poland', FALSE) ON CONFLICT(iata) DO NOTHING;
635INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('GVA', 'Geneva Airport', 'Large airport', 'Genova' , 'Switzerland', FALSE) ON CONFLICT(iata) DO NOTHING;
636INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('GOA', 'Genoa Cristoforo Colombo Airport', 'Large airport', 'Belfast' , 'Italy', FALSE) ON CONFLICT(iata) DO NOTHING;
637INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BHD', 'George Best Belfast City Airport', 'Large airport', 'Glasgow' , 'United Kingdom', FALSE) ON CONFLICT(iata) DO NOTHING;
638INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('GLA', 'Glasgow International Airport', 'Large airport', 'Gothenburg' , 'United Kingdom', FALSE) ON CONFLICT(iata) DO NOTHING;
639INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('GOT', 'Gothenburg-Landvetter Airport', 'Large airport', 'Gran Canaria Island' , 'Sweden', FALSE) ON CONFLICT(iata) DO NOTHING;
640INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('LPA', 'Gran Canaria Airport', 'Large airport', 'Grozny' , 'Spain', FALSE) ON CONFLICT(iata) DO NOTHING;
641INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('GRV', 'Grozny North Airport', 'Large airport', 'Hamburg' , 'Russia', FALSE) ON CONFLICT(iata) DO NOTHING;
642INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('HAM', 'Hamburg Airport', 'Large airport', 'Hannover' , 'Germany', FALSE) ON CONFLICT(iata) DO NOTHING;
643INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('HAJ', 'Hannover Airport', 'Large airport', 'Helsinki' , 'Germany', FALSE) ON CONFLICT(iata) DO NOTHING;
644INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('HEL', 'Helsinki Vantaa Airport', 'Large airport', 'Bucharest' , 'Finland', FALSE) ON CONFLICT(iata) DO NOTHING;
645INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('OTP', 'Bucharest Henri Coandă International Airport', 'Large airport', 'Heraklion' , 'Romania', FALSE) ON CONFLICT(iata) DO NOTHING;
646INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('HER', 'Heraklion International Nikos Kazantzakis Airport', 'Large airport', 'Lisbon' , 'Greece', FALSE) ON CONFLICT(iata) DO NOTHING;
647INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('LIS', 'Humberto Delgado Airport (Lisbon Portela Airport)', 'Large airport', 'Bergamo' , 'Portugal', FALSE) ON CONFLICT(iata) DO NOTHING;
648INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BGY', 'Il Caravaggio International Airport', 'Large airport', 'Ponta Delgada' , 'Italy', FALSE) ON CONFLICT(iata) DO NOTHING;
649INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('PDL', 'João Paulo II Airport', 'Large airport', 'Baden-Baden' , 'Portugal', FALSE) ON CONFLICT(iata) DO NOTHING;
650INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('FKB', 'Karlsruhe Baden-Baden Airport', 'Large airport', 'Katowice' , 'Germany', FALSE) ON CONFLICT(iata) DO NOTHING;
651INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('KTW', 'Katowice International Airport', 'Large airport', 'Kazan' , 'Poland', FALSE) ON CONFLICT(iata) DO NOTHING;
652INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('KZN', 'Kazan International Airport', 'Large airport', 'Reykjavík' , 'Russia', FALSE) ON CONFLICT(iata) DO NOTHING;
653INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('KEF', 'Keflavik International Airport', 'Large airport', 'Kharkiv' , 'Iceland', FALSE) ON CONFLICT(iata) DO NOTHING;
654INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('HRK', 'Kharkiv International Airport', 'Large airport', 'Kraków' , 'Ukraine', FALSE) ON CONFLICT(iata) DO NOTHING;
655INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('KRK', 'Kraków John Paul II International Airport', 'Large airport', 'Samara' , 'Poland', FALSE) ON CONFLICT(iata) DO NOTHING;
656INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('KUF', 'Kurumoch International Airport', 'Large airport', 'Sta Cruz de la Palma, La Palma Island' , 'Russia', FALSE) ON CONFLICT(iata) DO NOTHING;
657INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SPC', 'La Palma Airport', 'Large airport', 'Praia da Vitória' , 'Spain', FALSE) ON CONFLICT(iata) DO NOTHING;
658INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('TER', 'Lajes Airport', 'Large airport', 'Leeds' , 'Portugal', FALSE) ON CONFLICT(iata) DO NOTHING;
659INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('LBA', 'Leeds Bradford Airport', 'Large airport', 'Leipzig' , 'United Kingdom', FALSE) ON CONFLICT(iata) DO NOTHING;
660INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('LEJ', 'Leipzig/Halle Airport', 'Large airport', 'Tallinn' , 'Germany', FALSE) ON CONFLICT(iata) DO NOTHING;
661INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('TLL', 'Tallinn Airport', 'Large airport', 'Rome' , 'Estonia', FALSE) ON CONFLICT(iata) DO NOTHING;
662INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('FCO', 'Rome–Fiumicino International Airport "Leonardo da Vinci"', 'Large airport', 'Liège' , 'Italy', FALSE) ON CONFLICT(iata) DO NOTHING;
663INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('LGG', 'Liège Airport', 'Large airport', 'Liverpool' , 'Belgium', FALSE) ON CONFLICT(iata) DO NOTHING;
664INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('LPL', 'Liverpool John Lennon Airport', 'Large airport', 'Ljubljana' , 'United Kingdom', FALSE) ON CONFLICT(iata) DO NOTHING;
665INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('LJU', 'Ljubljana Jože Pučnik Airport', 'Large airport', 'London' , 'Slovenia', FALSE) ON CONFLICT(iata) DO NOTHING;
666INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('LGW', 'London Gatwick Airport', 'Large airport', 'London' , 'United Kingdom', FALSE) ON CONFLICT(iata) DO NOTHING;
667INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('LHR', 'London Heathrow Airport', 'Large airport', 'London' , 'United Kingdom', FALSE) ON CONFLICT(iata) DO NOTHING;
668INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('LTN', 'London Luton Airport', 'Large airport', 'London' , 'United Kingdom', FALSE) ON CONFLICT(iata) DO NOTHING;
669INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('STN', 'London Stansted Airport', 'Large airport', 'Luleå' , 'United Kingdom', FALSE) ON CONFLICT(iata) DO NOTHING;
670INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('LLA', 'Luleå Airport', 'Large airport', 'Luxembourg' , 'Sweden', FALSE) ON CONFLICT(iata) DO NOTHING;
671INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('LUX', 'Luxembourg-Findel International Airport', 'Large airport', 'Lyon' , 'Luxembourg', FALSE) ON CONFLICT(iata) DO NOTHING;
672INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('LYS', 'Lyon Saint-Exupéry Airport', 'Large airport', 'Bratislava' , 'France', FALSE) ON CONFLICT(iata) DO NOTHING;
673INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BTS', 'Bratislava Airport', 'Large airport', 'Málaga' , 'Slovakia', FALSE) ON CONFLICT(iata) DO NOTHING;
674INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('AGP', 'Málaga Airport', 'Large airport', 'Malmö' , 'Spain', FALSE) ON CONFLICT(iata) DO NOTHING;
675INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MMX', 'Malmö Airport', 'Large airport', 'Milan' , 'Sweden', FALSE) ON CONFLICT(iata) DO NOTHING;
676INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MXP', 'Malpensa International Airport', 'Large airport', 'Valletta' , 'Italy', FALSE) ON CONFLICT(iata) DO NOTHING;
677INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MLA', 'Malta International Airport', 'Large airport', 'Manchester' , 'Malta', FALSE) ON CONFLICT(iata) DO NOTHING;
678INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MAN', 'Manchester Airport', 'Large airport', 'Marseille' , 'United Kingdom', FALSE) ON CONFLICT(iata) DO NOTHING;
679INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MRS', 'Marseille Provence Airport', 'Large airport', 'Milan' , 'France', FALSE) ON CONFLICT(iata) DO NOTHING;
680INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('LIN', 'Milano Linate Airport', 'Large airport', 'Minsk' , 'Italy', FALSE) ON CONFLICT(iata) DO NOTHING;
681INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MSQ', 'Minsk National Airport', 'Large airport', 'Warsaw' , 'Belarus', FALSE) ON CONFLICT(iata) DO NOTHING;
682INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('WMI', 'Modlin Airport', 'Large airport', 'Munich' , 'Poland', FALSE) ON CONFLICT(iata) DO NOTHING;
683INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MUC', 'Munich Airport', 'Large airport', 'Münster' , 'Germany', FALSE) ON CONFLICT(iata) DO NOTHING;
684INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('FMO', 'Münster Osnabrück Airport', 'Large airport', 'Nápoli' , 'Germany', FALSE) ON CONFLICT(iata) DO NOTHING;
685INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('NAP', 'Naples International Airport', 'Large airport', 'Newcastle' , 'Italy', FALSE) ON CONFLICT(iata) DO NOTHING;
686INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('NCL', 'Newcastle Airport', 'Large airport', 'Nice' , 'United Kingdom', FALSE) ON CONFLICT(iata) DO NOTHING;
687INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('NCE', 'Nice-Côte d''Azur Airport', 'Large airport', 'Norwich' , 'France', FALSE) ON CONFLICT(iata) DO NOTHING;
688INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('NWI', 'Norwich International Airport', 'Large airport', 'Nuremberg' , 'United Kingdom', FALSE) ON CONFLICT(iata) DO NOTHING;
689INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('NUE', 'Nuremberg Airport', 'Large airport', 'Odessa' , 'Germany', FALSE) ON CONFLICT(iata) DO NOTHING;
690INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ODS', 'Odessa International Airport', 'Large airport', 'Oslo' , 'Ukraine', FALSE) ON CONFLICT(iata) DO NOTHING;
691INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('OSL', 'Oslo Gardermoen Airport', 'Large airport', 'Palma De Mallorca' , 'Norway', FALSE) ON CONFLICT(iata) DO NOTHING;
692INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('PMI', 'Palma De Mallorca Airport', 'Large airport', 'Paris' , 'Spain', FALSE) ON CONFLICT(iata) DO NOTHING;
693INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ORY', 'Paris-Orly Airport', 'Large airport', 'Pisa' , 'France', FALSE) ON CONFLICT(iata) DO NOTHING;
694INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('PSA', 'Pisa International Airport', 'Large airport', 'Rostov-on-Don' , 'Italy', FALSE) ON CONFLICT(iata) DO NOTHING;
695INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ROV', 'Platov International Airport', 'Large airport', 'Podgorica' , 'Russia', FALSE) ON CONFLICT(iata) DO NOTHING;
696INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('TGD', 'Podgorica Airport', 'Large airport', 'Poznań' , 'Montenegro', FALSE) ON CONFLICT(iata) DO NOTHING;
697INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('POZ', 'Poznań-Ławica Airport', 'Large airport', 'Prishtina' , 'Poland', FALSE) ON CONFLICT(iata) DO NOTHING;
698INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('PRN', 'Priština International Airport', 'Large airport', 'St. Petersburg' , 'Kosovo', FALSE) ON CONFLICT(iata) DO NOTHING;
699INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('LED', 'Pulkovo Airport', 'Large airport', 'Akrotiri' , 'Russia', FALSE) ON CONFLICT(iata) DO NOTHING;
700INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('AKT', 'RAF Akrotiri', 'Large airport', 'Brize Norton' , 'United Kingdom', FALSE) ON CONFLICT(iata) DO NOTHING;
701INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BZZ', 'RAF Brize Norton', 'Large airport', 'Fairford' , 'United Kingdom', FALSE) ON CONFLICT(iata) DO NOTHING;
702INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('FFD', 'RAF Fairford', 'Large airport', 'Lakenheath' , 'United Kingdom', FALSE) ON CONFLICT(iata) DO NOTHING;
703INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('LKZ', 'RAF Lakenheath', 'Large airport', 'Mildenhall' , 'United Kingdom', FALSE) ON CONFLICT(iata) DO NOTHING;
704INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MHZ', 'RAF Mildenhall', 'Large airport', 'Ramstein' , 'United Kingdom', FALSE) ON CONFLICT(iata) DO NOTHING;
705INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('RMS', 'Ramstein Air Base', 'Large airport', 'Riga' , 'Germany', FALSE) ON CONFLICT(iata) DO NOTHING;
706INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('RIX', 'Riga International Airport', 'Large airport', 'Doncaster' , 'Latvia', FALSE) ON CONFLICT(iata) DO NOTHING;
707INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DSA', 'Robin Hood Doncaster Sheffield Airport', 'Large airport', 'Santiago de Compostela' , 'United Kingdom', FALSE) ON CONFLICT(iata) DO NOTHING;
708INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SCQ', 'Santiago de Compostela Airport', 'Large airport', 'Sarajevo' , 'Spain', FALSE) ON CONFLICT(iata) DO NOTHING;
709INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SJJ', 'Sarajevo International Airport', 'Large airport', 'Shannon' , 'Bosnia and Herzegovina', FALSE) ON CONFLICT(iata) DO NOTHING;
710INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SNN', 'Shannon Airport', 'Large airport', 'Moscow' , 'Ireland', FALSE) ON CONFLICT(iata) DO NOTHING;
711INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SVO', 'Sheremetyevo International Airport', 'Large airport', 'Simferopol' , 'Russia', FALSE) ON CONFLICT(iata) DO NOTHING;
712INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SIP', 'Simferopol International Airport', 'Large airport', 'Skopje' , 'Ukraine', FALSE) ON CONFLICT(iata) DO NOTHING;
713INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SKP', 'Skopje Alexander the Great Airport', 'Large airport', 'Sochi' , 'Macedonia', FALSE) ON CONFLICT(iata) DO NOTHING;
714INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('AER', 'Sochi International Airport', 'Large airport', 'Sofia' , 'Russia', FALSE) ON CONFLICT(iata) DO NOTHING;
715INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SOF', 'Sofia Airport', 'Large airport', 'Southampton' , 'Bulgaria', FALSE) ON CONFLICT(iata) DO NOTHING;
716INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SOU', 'Southampton Airport', 'Large airport', 'Stavanger' , 'United Kingdom', FALSE) ON CONFLICT(iata) DO NOTHING;
717INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SVG', 'Stavanger Airport Sola', 'Large airport', 'Stockholm' , 'Norway', FALSE) ON CONFLICT(iata) DO NOTHING;
718INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ARN', 'Stockholm Arlanda Airport', 'Large airport', 'Stuttgart' , 'Sweden', FALSE) ON CONFLICT(iata) DO NOTHING;
719INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('STR', 'Stuttgart Airport', 'Large airport', 'Tenerife Island' , 'Germany', FALSE) ON CONFLICT(iata) DO NOTHING;
720INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('TFN', 'Tenerife North Airport', 'Large airport', 'Tenerife Island' , 'Spain', FALSE) ON CONFLICT(iata) DO NOTHING;
721INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('TFS', 'Tenerife South Airport', 'Large airport', 'Thessaloniki' , 'Spain', FALSE) ON CONFLICT(iata) DO NOTHING;
722INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SKG', 'Thessaloniki Macedonia International Airport', 'Large airport', 'Tirana' , 'Greece', FALSE) ON CONFLICT(iata) DO NOTHING;
723INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('TIA', 'Tirana International Airport Mother Teresa', 'Large airport', 'Toulouse/Blagnac' , 'Albania', FALSE) ON CONFLICT(iata) DO NOTHING;
724INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('TLS', 'Toulouse-Blagnac Airport', 'Large airport', 'Treviso' , 'France', FALSE) ON CONFLICT(iata) DO NOTHING;
725INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('TSF', 'Treviso-Sant''Angelo Airport', 'Large airport', 'Tromsø' , 'Italy', FALSE) ON CONFLICT(iata) DO NOTHING;
726INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('TOS', 'Tromsø Airport', 'Large airport', 'Trondheim' , 'Norway', FALSE) ON CONFLICT(iata) DO NOTHING;
727INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('TRD', 'Trondheim Airport Værnes', 'Large airport', 'Torino' , 'Norway', FALSE) ON CONFLICT(iata) DO NOTHING;
728INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('TRN', 'Turin Airport', 'Large airport', 'Ufa' , 'Italy', FALSE) ON CONFLICT(iata) DO NOTHING;
729INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('UFA', 'Ufa International Airport', 'Large airport', 'Prague' , 'Russia', FALSE) ON CONFLICT(iata) DO NOTHING;
730INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('PRG', 'Václav Havel Airport Prague', 'Large airport', 'Varna' , 'Czechia', FALSE) ON CONFLICT(iata) DO NOTHING;
731INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('VAR', 'Varna Airport', 'Large airport', 'Venice' , 'Bulgaria', FALSE) ON CONFLICT(iata) DO NOTHING;
732INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('VCE', 'Venice Marco Polo Airport', 'Large airport', 'Verona' , 'Italy', FALSE) ON CONFLICT(iata) DO NOTHING;
733INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('VRN', 'Verona Villafranca Airport', 'Large airport', 'Vienna' , 'Italy', FALSE) ON CONFLICT(iata) DO NOTHING;
734INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('VIE', 'Vienna International Airport', 'Large airport', 'Vilnius' , 'Austria', FALSE) ON CONFLICT(iata) DO NOTHING;
735INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('VNO', 'Vilnius International Airport', 'Large airport', 'Moscow' , 'Lithuania', FALSE) ON CONFLICT(iata) DO NOTHING;
736INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('VKO', 'Vnukovo International Airport', 'Large airport', 'Warsaw' , 'Russia', FALSE) ON CONFLICT(iata) DO NOTHING;
737INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('WAW', 'Warsaw Chopin Airport', 'Large airport', 'Krasnoyarsk' , 'Poland', FALSE) ON CONFLICT(iata) DO NOTHING;
738INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('KJA', 'Yemelyanovo Airport', 'Large airport', 'Zagreb' , 'Russia', FALSE) ON CONFLICT(iata) DO NOTHING;
739INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ZAG', 'Zagreb Airport', 'Large airport', 'Moscow' , 'Croatia', FALSE) ON CONFLICT(iata) DO NOTHING;
740INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ZIA', 'Zhukovsky International Airport', 'Large airport', 'Zurich' , 'Russia', FALSE) ON CONFLICT(iata) DO NOTHING;
741INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ZRH', 'Zürich Airport', 'Large airport', 'Dakar' , 'Switzerland', FALSE) ON CONFLICT(iata) DO NOTHING;
742INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DSS', 'Diass-Thies Blaise Diagne International Airport', 'Large airport', 'Cairo' , 'Senegal', FALSE) ON CONFLICT(iata) DO NOTHING;
743INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CAI', 'Cairo International Airport', 'Large airport', 'Cape Town' , 'Egypt', FALSE) ON CONFLICT(iata) DO NOTHING;
744INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CPT', 'Cape Town International Airport', 'Large airport', 'Niamey' , 'South Africa', FALSE) ON CONFLICT(iata) DO NOTHING;
745INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('NIM', 'Diori Hamani International Airport', 'Large airport', 'Enfidha' , 'Niger', FALSE) ON CONFLICT(iata) DO NOTHING;
746INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('NBE', 'Enfidha - Hammamet International Airport', 'Large airport', 'Kampala' , 'Tunisia', FALSE) ON CONFLICT(iata) DO NOTHING;
747INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('EBB', 'Entebbe International Airport', 'Large airport', 'George' , 'Uganda', FALSE) ON CONFLICT(iata) DO NOTHING;
748INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('GRJ', 'George Airport', 'Large airport', 'Windhoek' , 'South Africa', FALSE) ON CONFLICT(iata) DO NOTHING;
749INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('WDH', 'Hosea Kutako International Airport', 'Large airport', 'Algiers' , 'Namibia', FALSE) ON CONFLICT(iata) DO NOTHING;
750INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ALG', 'Algiers Houari Boumediene Airport', 'Large airport', 'Hurghada' , 'Algeria', FALSE) ON CONFLICT(iata) DO NOTHING;
751INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('HRG', 'Hurghada International Airport', 'Large airport', 'Antananarivo' , 'Egypt', FALSE) ON CONFLICT(iata) DO NOTHING;
752INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('TNR', 'Ivato Airport', 'Large airport', 'Nairobi' , 'Madagascar', FALSE) ON CONFLICT(iata) DO NOTHING;
753INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('NBO', 'Jomo Kenyatta International Airport', 'Large airport', 'Juba' , 'Kenya', FALSE) ON CONFLICT(iata) DO NOTHING;
754INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('JUB', 'Juba International Airport', 'Large airport', 'Dar es Salaam' , 'South Sudan', FALSE) ON CONFLICT(iata) DO NOTHING;
755INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DAR', 'Julius Nyerere International Airport', 'Large airport', 'Lusaka' , 'Tanzania', FALSE) ON CONFLICT(iata) DO NOTHING;
756INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('LUN', 'Kenneth Kaunda International Airport Lusaka', 'Large airport', 'Khartoum' , 'Zambia', FALSE) ON CONFLICT(iata) DO NOTHING;
757INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('KRT', 'Khartoum International Airport', 'Large airport', 'Kigali' , 'Sudan', FALSE) ON CONFLICT(iata) DO NOTHING;
758INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('KGL', 'Kigali International Airport', 'Large airport', 'Durban' , 'Rwanda', FALSE) ON CONFLICT(iata) DO NOTHING;
759INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DUR', 'King Shaka International Airport', 'Large airport', 'Accra' , 'South Africa', FALSE) ON CONFLICT(iata) DO NOTHING;
760INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ACC', 'Kotoka International Airport', 'Large airport', 'Dakar' , 'Ghana', FALSE) ON CONFLICT(iata) DO NOTHING;
761INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('DKR', 'Léopold Sédar Senghor International Airport', 'Large airport', 'Freetown' , 'Senegal', FALSE) ON CONFLICT(iata) DO NOTHING;
762INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('FNA', 'Lungi International Airport', 'Large airport', 'Luxor' , 'Sierra Leone', FALSE) ON CONFLICT(iata) DO NOTHING;
763INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('LXR', 'Luxor International Airport', 'Large airport', 'Kano' , 'Egypt', FALSE) ON CONFLICT(iata) DO NOTHING;
764INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('KAN', 'Mallam Aminu International Airport', 'Large airport', 'Maputo' , 'Nigeria', FALSE) ON CONFLICT(iata) DO NOTHING;
765INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MPM', 'Maputo Airport', 'Large airport', 'Bamako' , 'Mozambique', FALSE) ON CONFLICT(iata) DO NOTHING;
766INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BKO', 'Modibo Keita International Airport', 'Large airport', 'Casablanca' , 'Mali', FALSE) ON CONFLICT(iata) DO NOTHING;
767INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CMN', 'Mohammed V International Airport', 'Large airport', 'Mombasa' , 'Morocco', FALSE) ON CONFLICT(iata) DO NOTHING;
768INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MBA', 'Mombasa Moi International Airport', 'Large airport', 'Lagos' , 'Kenya', FALSE) ON CONFLICT(iata) DO NOTHING;
769INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('LOS', 'Murtala Muhammed International Airport', 'Large airport', 'N''Djamena' , 'Nigeria', FALSE) ON CONFLICT(iata) DO NOTHING;
770INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('NDJ', 'N''Djamena International Airport', 'Large airport', 'Kinshasa' , 'Chad', FALSE) ON CONFLICT(iata) DO NOTHING;
771INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('FIH', 'Ndjili International Airport', 'Large airport', 'Abuja' , 'Congo (Kinshasa)', FALSE) ON CONFLICT(iata) DO NOTHING;
772INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ABV', 'Nnamdi Azikiwe International Airport', 'Large airport', 'Nouakchott' , 'Nigeria', FALSE) ON CONFLICT(iata) DO NOTHING;
773INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('NKC', 'Nouakchott–Oumtounsy International Airport', 'Large airport', 'Johannesburg' , 'Mauritania', FALSE) ON CONFLICT(iata) DO NOTHING;
774INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('JNB', 'OR Tambo International Airport', 'Large airport', 'Ouagadougou' , 'South Africa', FALSE) ON CONFLICT(iata) DO NOTHING;
775INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('OUA', 'Ouagadougou Airport', 'Large airport', 'Luanda' , 'Burkina Faso', FALSE) ON CONFLICT(iata) DO NOTHING;
776INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('LAD', 'Quatro de Fevereiro Airport', 'Large airport', 'Harare' , 'Angola', FALSE) ON CONFLICT(iata) DO NOTHING;
777INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('HRE', 'Robert Gabriel Mugabe International Airport', 'Large airport', 'Monrovia' , 'Zimbabwe', FALSE) ON CONFLICT(iata) DO NOTHING;
778INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('ROB', 'Roberts International Airport', 'Large airport', 'Mahe Island' , 'Liberia', FALSE) ON CONFLICT(iata) DO NOTHING;
779INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SEZ', 'Seychelles International Airport', 'Large airport', 'Port Louis' , 'Seychelles', FALSE) ON CONFLICT(iata) DO NOTHING;
780INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MRU', 'Sir Seewoosagur Ramgoolam International Airport', 'Large airport', 'Gaborone' , 'Mauritius', FALSE) ON CONFLICT(iata) DO NOTHING;
781INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('GBE', 'Sir Seretse Khama International Airport', 'Large airport', 'Tripoli' , 'Botswana', FALSE) ON CONFLICT(iata) DO NOTHING;
782INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('TIP', 'Tripoli International Airport', 'Large airport', 'Tunis' , 'Libya', FALSE) ON CONFLICT(iata) DO NOTHING;
783INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('TUN', 'Tunis Carthage International Airport', 'Large airport', 'Montevideo' , 'Tunisia', FALSE) ON CONFLICT(iata) DO NOTHING;
784INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MVD', 'Carrasco International /General C L Berisso Airport', 'Large airport', 'Santiago' , 'Uruguay', FALSE) ON CONFLICT(iata) DO NOTHING;
785INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SCL', 'Comodoro Arturo Merino Benítez International Airport', 'Large airport', 'São Paulo' , 'Chile', FALSE) ON CONFLICT(iata) DO NOTHING;
786INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CGH', 'São Paulo–Congonhas Airport', 'Large airport', 'Latacunga' , 'Brazil', FALSE) ON CONFLICT(iata) DO NOTHING;
787INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('LTX', 'Cotopaxi International Airport', 'Large airport', 'Salvador' , 'Ecuador', FALSE) ON CONFLICT(iata) DO NOTHING;
788INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SSA', 'Deputado Luiz Eduardo Magalhães International Airport', 'Large airport', 'Bogota' , 'Brazil', FALSE) ON CONFLICT(iata) DO NOTHING;
789INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BOG', 'El Dorado International Airport', 'Large airport', 'Barcelona' , 'Colombia', FALSE) ON CONFLICT(iata) DO NOTHING;
790INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BLA', 'General José Antonio Anzoategui International Airport', 'Large airport', 'Natal' , 'Venezuela', FALSE) ON CONFLICT(iata) DO NOTHING;
791INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('NAT', 'Governador Aluízio Alves International Airport', 'Large airport', 'Florianópolis' , 'Brazil', FALSE) ON CONFLICT(iata) DO NOTHING;
792INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('FLN', 'Hercílio Luz International Airport', 'Large airport', 'Lima' , 'Brazil', FALSE) ON CONFLICT(iata) DO NOTHING;
793INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('LIM', 'Jorge Chávez International Airport', 'Large airport', 'Quito' , 'Peru', FALSE) ON CONFLICT(iata) DO NOTHING;
794INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('UIO', 'Mariscal Sucre International Airport', 'Large airport', 'Buenos Aires' , 'Ecuador', FALSE) ON CONFLICT(iata) DO NOTHING;
795INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('EZE', 'Ministro Pistarini International Airport', 'Large airport', 'Brasília' , 'Argentina', FALSE) ON CONFLICT(iata) DO NOTHING;
796INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BSB', 'Brasília International Airport', 'Large airport', 'Rio De Janeiro' , 'Brazil', FALSE) ON CONFLICT(iata) DO NOTHING;
797INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('GIG', 'Galeão International Airport', 'Large airport', 'Caracas' , 'Brazil', FALSE) ON CONFLICT(iata) DO NOTHING;
798INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CCS', 'Simón Bolívar International Airport', 'Large airport', 'Belo Horizonte' , 'Venezuela', FALSE) ON CONFLICT(iata) DO NOTHING;
799INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CNF', 'Tancredo Neves International Airport', 'Large airport', 'Belém' , 'Brazil', FALSE) ON CONFLICT(iata) DO NOTHING;
800INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BEL', 'Val de Cans/Júlio Cezar Ribeiro International Airport', 'Large airport', 'Santa Cruz' , 'Brazil', FALSE) ON CONFLICT(iata) DO NOTHING;
801INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('VVI', 'Viru Viru International Airport', 'Large airport', 'Brisbane' , 'Bolivia', FALSE) ON CONFLICT(iata) DO NOTHING;
802INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('BNE', 'Brisbane International Airport', 'Large airport', 'Canberra' , 'Australia', FALSE) ON CONFLICT(iata) DO NOTHING;
803INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CBR', 'Canberra International Airport', 'Large airport', 'Christchurch' , 'Australia', FALSE) ON CONFLICT(iata) DO NOTHING;
804INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('CHC', 'Christchurch International Airport', 'Large airport', 'Papeete' , 'New Zealand', FALSE) ON CONFLICT(iata) DO NOTHING;
805INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('PPT', 'Faa''a International Airport', 'Large airport', 'Melbourne' , 'French Polynesia', FALSE) ON CONFLICT(iata) DO NOTHING;
806INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('MEL', 'Melbourne International Airport', 'Large airport', 'Perth' , 'Australia', FALSE) ON CONFLICT(iata) DO NOTHING;
807INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('PER', 'Perth International Airport', 'Large airport', 'Port Moresby' , 'Australia', FALSE) ON CONFLICT(iata) DO NOTHING;
808INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('POM', 'Port Moresby Jacksons International Airport', 'Large airport', 'Avarua' , 'Papua New Guinea', FALSE) ON CONFLICT(iata) DO NOTHING;
809INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('RAR', 'Rarotonga International Airport', 'Large airport', 'Sydney' , 'Cook Islands', FALSE) ON CONFLICT(iata) DO NOTHING;
810INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('SYD', 'Sydney Airport', 'Large airport', 'Wellington' , 'Australia', FALSE) ON CONFLICT(iata) DO NOTHING;
811INSERT INTO experience_extranet_resource.airport (iata, airport_name, airport_class, city, country, is_deleted) VALUES('WLG', 'Wellington International Airport', 'Large airport', '' , 'New Zealand', FALSE) ON CONFLICT(iata) DO NOTHING;
812
813CREATE OR REPLACE FUNCTION experience_extranet_resource_v1_api.get_flight_list() returns SETOF jsonb
814 security definer
815 language sql
816as $$
817SELECT to_jsonb(res)
818FROM (
819 SELECT *
820 FROM experience_extranet_resource.flight
821 WHERE is_deleted = FALSE
822 ) as res
823$$;
824
825CREATE OR REPLACE FUNCTION experience_extranet_resource_v1_api.get_airport_list() returns SETOF jsonb
826 security definer
827 language sql
828as $$
829SELECT to_jsonb(res)
830FROM (
831 SELECT *
832 FROM experience_extranet_resource.airport
833 WHERE is_deleted = FALSE
834 ) as res
835$$;
836
837CREATE OR REPLACE FUNCTION experience_extranet_resource_v1_helper.get_airport_by_iata(iata_spec TEXT) returns jsonb
838 security definer
839 language sql
840as $$
841SELECT to_jsonb(res)
842FROM (
843 SELECT iata, airport_name, airport_class, city, country
844 FROM experience_extranet_resource.airport
845 WHERE iata = iata_spec AND is_deleted = FALSE
846 ) as res
847$$;
848
849CREATE TABLE IF NOT EXISTS experience_extranet_experience.experience_multi_day_tours_flight
850(
851 flight_id BIGSERIAL NOT NULL PRIMARY KEY,
852 experience_id TEXT NOT NULL,
853 airline_code TEXT NOT NULL,
854 flight_order INTEGER NOT NULL,
855 departure_port TEXT NOT NULL,
856 destination_port TEXT NOT NULL,
857 is_return_flight BOOLEAN NOT NULL,
858 is_deleted BOOLEAN NOT NULL,
859 _lut TIMESTAMPTZ,
860 FOREIGN KEY (experience_id) REFERENCES experience_extranet_experience.experience,
861 FOREIGN KEY (airline_code) REFERENCES experience_extranet_resource.flight
862);
863
864CREATE INDEX IF NOT EXISTS experience__experience_multi_day_tours_flight_idx
865 ON experience_extranet_experience.experience_multi_day_tours_flight (experience_id, airline_code, is_deleted);
866
867DO $$
868BEGIN
869 CREATE TRIGGER populate_lut_experience_multi_day_tours_flight
870 BEFORE INSERT OR UPDATE
871 ON experience_extranet_experience.experience_multi_day_tours_flight
872 FOR EACH ROW
873 EXECUTE PROCEDURE experience_extranet_experience.lut_trigger();
874 EXCEPTION
875 WHEN duplicate_object
876 THEN RAISE NOTICE 'the trigger already exists';
877END;
878$$;
879
880DO $$
881BEGIN
882 BEGIN
883 ALTER TABLE experience_extranet_experience.experience_multi_day_tours
884 ADD COLUMN duration_day INTEGER DEFAULT 0;
885 EXCEPTION
886 WHEN duplicate_column THEN RAISE NOTICE 'column duration_day already exists in experience_extranet_experience.experience_multi_day_tours';
887 END;
888END;
889$$;
890
891DO $$
892BEGIN
893 BEGIN
894 ALTER TABLE experience_extranet_experience.experience_multi_day_tours
895 ADD COLUMN duration_hour INTEGER DEFAULT 0;
896 EXCEPTION
897 WHEN duplicate_column THEN RAISE NOTICE 'column duration_hour already exists in experience_extranet_experience.experience_multi_day_tours';
898 END;
899END;
900$$;
901
902DO $$
903BEGIN
904 BEGIN
905 ALTER TABLE experience_extranet_experience.experience_multi_day_tours
906 ADD COLUMN duration_minute INTEGER DEFAULT 0;
907 EXCEPTION
908 WHEN duplicate_column THEN RAISE NOTICE 'column duration_minute already exists in experience_extranet_experience.experience_multi_day_tours';
909 END;
910END;
911$$;
912
913DO $$
914BEGIN
915 BEGIN
916 ALTER TABLE experience_extranet_experience.experience_multi_day_tours
917 ADD COLUMN flight_included BOOLEAN NOT NULL DEFAULT FALSE;
918 EXCEPTION
919 WHEN duplicate_column THEN RAISE NOTICE 'column flight_included already exists in experience_extranet_experience.experience_multi_day_tours';
920 END;
921END;
922$$;
923
924DO $$
925BEGIN
926 BEGIN
927 ALTER TABLE experience_extranet_experience.experience_multi_day_tours
928 ADD COLUMN additional_inclusions TEXT;
929 EXCEPTION
930 WHEN duplicate_column THEN RAISE NOTICE 'column additional_inclusion already exists in experience_extranet_experience.experience_multi_day_tours';
931 END;
932END;
933$$;
934
935DO $$
936BEGIN
937 BEGIN
938 ALTER TABLE experience_extranet_experience.experience_multi_day_tours
939 ADD COLUMN additional_exclusions TEXT;
940 EXCEPTION
941 WHEN duplicate_column THEN RAISE NOTICE 'column additional_exclusions already exists in experience_extranet_experience.experience_multi_day_tours';
942 END;
943END;
944$$;
945
946DO
947$$
948 BEGIN
949 BEGIN
950 ALTER TABLE experience_extranet_experience.experience_multi_day_tours_flight
951 ADD CONSTRAINT experience_multi_day_tours_flight_departure_port_fkey FOREIGN KEY(departure_port) REFERENCES experience_extranet_resource.airport;
952 END;
953 END;
954$$;
955
956
957DO
958$$
959 BEGIN
960 BEGIN
961 ALTER TABLE experience_extranet_experience.experience_multi_day_tours_flight
962 ADD CONSTRAINT experience_multi_day_tours_flight_destination_port_fkey FOREIGN KEY(destination_port) REFERENCES experience_extranet_resource.airport;
963 END;
964 END;
965$$;
966
967INSERT INTO experience_extranet_experience.experience_category_table_mapping (experience_category, mapping_table_name, mapping_get_function_name, mapping_upsert_function_name)
968VALUES ('MULTI_DAY_TOURS', 'experience_extranet_experience.experience_multi_day_tours', 'experience_extranet_management_v2_helper.get_experience_multi_day_tours_additional_data($1)', 'experience_extranet_management_v2_helper.upsert_experience_multi_day_tours_additional_data($1, $2)') ON CONFLICT (experience_category) DO UPDATE SET mapping_table_name = EXCLUDED.mapping_table_name, mapping_get_function_name = EXCLUDED.mapping_get_function_name, mapping_upsert_function_name = EXCLUDED.mapping_upsert_function_name;
969
970
971--CONTENT SECTION
972ALTER TABLE experience_extranet_content.experience_type DROP CONSTRAINT IF EXISTS experience_type_pkey ;
973
974DO $$
975BEGIN
976 ALTER TABLE experience_extranet_content.experience_type ADD CONSTRAINT experience_type_pkey PRIMARY KEY (experience_type_id, experience_category);
977 EXCEPTION
978WHEN invalid_table_definition THEN RAISE NOTICE 'experience_type_pkey already exists';
979END;
980$$;
981
982CREATE TABLE IF NOT EXISTS experience_extranet_content.experience_sub_type (
983 experience_sub_type_id TEXT NOT NULL,
984 experience_sub_type_name TEXT NOT NULL,
985 experience_type_id TEXT NOT NULL,
986 experience_category TEXT NOT NULL,
987 _lut TIMESTAMPTZ NOT NULL,
988
989 PRIMARY KEY (experience_sub_type_id, experience_type_id, experience_category)
990);
991
992DO $$
993BEGIN
994 CREATE TRIGGER populate_lut_experience_sub_type
995 BEFORE INSERT OR UPDATE
996 ON experience_extranet_content.experience_sub_type
997 FOR EACH ROW
998 EXECUTE PROCEDURE experience_extranet_content.lut_trigger();
999EXCEPTION
1000 WHEN duplicate_object THEN RAISE NOTICE 'the trigger already exists';
1001END;
1002$$;
1003
1004CREATE TABLE IF NOT EXISTS experience_extranet_content.experience_inclusion (
1005 inclusion_id BIGINT NOT NULL,
1006 inclusion TEXT NOT NULL,
1007 inclusion_name TEXT NOT NULL,
1008 is_deleted BOOLEAN NOT NULL,
1009 _lut TIMESTAMPTZ NOT NULL,
1010 PRIMARY KEY (inclusion_id)
1011);
1012
1013DO $$
1014BEGIN
1015 CREATE TRIGGER populate_lut_experience_inclusion
1016 BEFORE INSERT OR UPDATE
1017 ON experience_extranet_content.experience_inclusion
1018 FOR EACH ROW
1019 EXECUTE PROCEDURE experience_extranet_content.lut_trigger();
1020EXCEPTION
1021 WHEN duplicate_object THEN RAISE NOTICE 'the trigger already exists';
1022END;
1023$$;
1024
1025CREATE TABLE IF NOT EXISTS experience_extranet_content.experience_sub_type_mapping (
1026 experience_sub_type_id TEXT NOT NULL,
1027 experience_id TEXT NOT NULL,
1028 _lut TIMESTAMPTZ NOT NULL,
1029
1030 PRIMARY KEY (experience_sub_type_id, experience_id),
1031 FOREIGN KEY (experience_id)
1032 REFERENCES experience_extranet_experience.experience ON UPDATE CASCADE ON DELETE RESTRICT
1033);
1034
1035DO $$
1036BEGIN
1037 CREATE TRIGGER populate_lut_experience_sub_type_mapping
1038 BEFORE INSERT OR UPDATE
1039 ON experience_extranet_content.experience_sub_type_mapping
1040 FOR EACH ROW
1041 EXECUTE PROCEDURE experience_extranet_content.lut_trigger();
1042EXCEPTION
1043 WHEN duplicate_object THEN RAISE NOTICE 'the trigger already exists';
1044END;
1045$$;
1046
1047CREATE TABLE IF NOT EXISTS experience_extranet_content.experience_multi_day_tours_hotel
1048(
1049 hotel_id BIGSERIAL NOT NULL PRIMARY KEY,
1050 experience_id TEXT NOT NULL,
1051 city TEXT NOT NULL,
1052 rating INTEGER,
1053 name TEXT NOT NULL,
1054 photos JSONB,
1055 information TEXT,
1056 is_deleted BOOLEAN NOT NULL,
1057 _lut TIMESTAMPTZ,
1058 FOREIGN KEY (experience_id) REFERENCES experience_extranet_experience.experience
1059);
1060
1061CREATE INDEX IF NOT EXISTS experience_extranet_content_experience_multi_day_tours_hotel
1062ON experience_extranet_content.experience_multi_day_tours_hotel (experience_id, is_deleted);
1063
1064DO $$
1065BEGIN
1066 CREATE TRIGGER populate_lut_experience_multi_day_tours_hotel
1067 BEFORE INSERT OR UPDATE
1068 ON experience_extranet_content.experience_multi_day_tours_hotel
1069 FOR EACH ROW
1070 EXECUTE PROCEDURE experience_extranet_content.lut_trigger();
1071EXCEPTION
1072 WHEN duplicate_object THEN RAISE NOTICE 'the trigger already exists';
1073END;
1074$$;
1075
1076CREATE TABLE IF NOT EXISTS experience_extranet_content.experience_inclusion_mapping
1077(
1078 experience_id TEXT NOT NULL,
1079 inclusion_id BIGINT NOT NULL,
1080 is_deleted BOOLEAN NOT NULL,
1081 _lut TIMESTAMPTZ,
1082 PRIMARY KEY (experience_id, inclusion_id),
1083 FOREIGN KEY (experience_id) REFERENCES experience_extranet_experience.experience,
1084 FOREIGN KEY (inclusion_id) REFERENCES experience_extranet_content.experience_inclusion(inclusion_id)
1085);
1086
1087 CREATE INDEX IF NOT EXISTS experience__experience_inclusion_mapping_idx
1088 ON experience_extranet_content.experience_inclusion_mapping(experience_id, inclusion_id, is_deleted);
1089
1090DO $$
1091BEGIN
1092 CREATE TRIGGER populate_lut_experience_multi_day_tours_hotel
1093 BEFORE INSERT OR UPDATE
1094 ON experience_extranet_content.experience_multi_day_tours_hotel
1095 FOR EACH ROW
1096 EXECUTE PROCEDURE experience_extranet_content.lut_trigger();
1097EXCEPTION
1098 WHEN duplicate_object THEN RAISE NOTICE 'the trigger already exists';
1099END;
1100$$;
1101
1102
1103DO $$
1104BEGIN
1105 CREATE TRIGGER populate_lut_experience_inclusion_mapping
1106 BEFORE INSERT OR UPDATE
1107 ON experience_extranet_content.experience_inclusion_mapping
1108 FOR EACH ROW
1109 EXECUTE PROCEDURE experience_extranet_content.lut_trigger();
1110EXCEPTION
1111 WHEN duplicate_object THEN RAISE NOTICE 'the trigger already exists';
1112END;
1113$$;
1114
1115-- CONTENT DATA
1116INSERT INTO experience_extranet_content.experience_type (experience_type_id, experience_type_name, experience_category) VALUES ('VACATIONS', 'Vacations', 'MULTI_DAY_TOURS') ON CONFLICT (experience_type_id, experience_category) DO UPDATE SET experience_type_name = EXCLUDED.experience_type_name, experience_category = EXCLUDED.experience_category;
1117INSERT INTO experience_extranet_content.experience_type (experience_type_id, experience_type_name, experience_category) VALUES ('UMRAH', 'Umrah', 'MULTI_DAY_TOURS') ON CONFLICT (experience_type_id, experience_category) DO UPDATE SET experience_type_name = EXCLUDED.experience_type_name, experience_category = EXCLUDED.experience_category;
1118INSERT INTO experience_extranet_content.experience_type (experience_type_id, experience_type_name, experience_category) VALUES ('MEDICAL', 'Medical', 'MULTI_DAY_TOURS') ON CONFLICT (experience_type_id, experience_category) DO UPDATE SET experience_type_name = EXCLUDED.experience_type_name, experience_category = EXCLUDED.experience_category;
1119INSERT INTO experience_extranet_content.experience_type (experience_type_id, experience_type_name, experience_category) VALUES ('EVENTS', 'Events', 'MULTI_DAY_TOURS') ON CONFLICT (experience_type_id, experience_category) DO UPDATE SET experience_type_name = EXCLUDED.experience_type_name, experience_category = EXCLUDED.experience_category;
1120INSERT INTO experience_extranet_content.experience_type (experience_type_id, experience_type_name, experience_category) VALUES ('SPORTS', 'Sports', 'MULTI_DAY_TOURS') ON CONFLICT (experience_type_id, experience_category) DO UPDATE SET experience_type_name = EXCLUDED.experience_type_name, experience_category = EXCLUDED.experience_category;
1121INSERT INTO experience_extranet_content.experience_type (experience_type_id, experience_type_name, experience_category) VALUES ('RELIGIOUS_TRIPS', 'Religious Trips', 'MULTI_DAY_TOURS') ON CONFLICT (experience_type_id, experience_category) DO UPDATE SET experience_type_name = EXCLUDED.experience_type_name, experience_category = EXCLUDED.experience_category;
1122
1123INSERT INTO experience_extranet_content.experience_themes (experience_theme_id, theme) VALUES ('RELAX_TOUR', 'Relax Tour') ON CONFLICT (experience_theme_id) DO NOTHING;
1124INSERT INTO experience_extranet_content.experience_themes (experience_theme_id, theme) VALUES ('SIGHTSEEING', 'Sightseeing') ON CONFLICT (experience_theme_id) DO NOTHING;
1125INSERT INTO experience_extranet_content.experience_themes (experience_theme_id, theme) VALUES ('ADVENTURE_OR_NATURE', 'Adventure / Nature') ON CONFLICT (experience_theme_id) DO NOTHING;
1126INSERT INTO experience_extranet_content.experience_themes (experience_theme_id, theme) VALUES ('MUSLIM_FRIENDLY', 'Muslim Friendly') ON CONFLICT (experience_theme_id) DO NOTHING;
1127INSERT INTO experience_extranet_content.experience_themes (experience_theme_id, theme) VALUES ('BUDGET_TOUR_OR_BACKPACKER', 'Budget Tour / Backpacker') ON CONFLICT (experience_theme_id) DO NOTHING;
1128INSERT INTO experience_extranet_content.experience_themes (experience_theme_id, theme) VALUES ('SHOPPING', 'Shopping') ON CONFLICT (experience_theme_id) DO NOTHING;
1129INSERT INTO experience_extranet_content.experience_themes (experience_theme_id, theme) VALUES ('CULINARY', 'Culinary') ON CONFLICT (experience_theme_id) DO NOTHING;
1130INSERT INTO experience_extranet_content.experience_themes (experience_theme_id, theme) VALUES ('FAMILY_FRIENDLY', 'Family Friendly') ON CONFLICT (experience_theme_id) DO NOTHING;
1131INSERT INTO experience_extranet_content.experience_themes (experience_theme_id, theme) VALUES ('CULTURE', 'Culture') ON CONFLICT (experience_theme_id) DO NOTHING; INSERT INTO experience_extranet_content.experience_themes (experience_theme_id, theme) VALUES ('ROMANTIC', 'Romantic') ON CONFLICT (experience_theme_id) DO NOTHING;
1132INSERT INTO experience_extranet_content.experience_themes (experience_theme_id, theme) VALUES ('UNIQUE_EXPERIENCE', 'Unique Experience') ON CONFLICT (experience_theme_id) DO NOTHING;
1133INSERT INTO experience_extranet_content.experience_themes (experience_theme_id, theme) VALUES ('OTHERS', 'Others') ON CONFLICT (experience_theme_id) DO NOTHING;
1134
1135INSERT INTO experience_extranet_content.experience_sub_type (experience_sub_type_id, experience_sub_type_name, experience_type_id, experience_category) VALUES ('GROUP_TOUR', 'Group Tour', 'VACATIONS', 'MULTI_DAY_TOURS') ON CONFLICT (experience_sub_type_id, experience_type_id, experience_category) DO UPDATE SET experience_sub_type_name = EXCLUDED.experience_sub_type_name;
1136INSERT INTO experience_extranet_content.experience_sub_type (experience_sub_type_id, experience_sub_type_name, experience_type_id, experience_category) VALUES ('INDIVIDUAL_TRAVEL', 'Individual Travel', 'VACATIONS', 'MULTI_DAY_TOURS') ON CONFLICT (experience_sub_type_id, experience_type_id, experience_category) DO UPDATE SET experience_sub_type_name = EXCLUDED.experience_sub_type_name;
1137INSERT INTO experience_extranet_content.experience_sub_type (experience_sub_type_id, experience_sub_type_name, experience_type_id, experience_category) VALUES ('OPEN_TRIP', 'Open Trip', 'VACATIONS', 'MULTI_DAY_TOURS') ON CONFLICT (experience_sub_type_id, experience_type_id, experience_category) DO UPDATE SET experience_sub_type_name = EXCLUDED.experience_sub_type_name;
1138INSERT INTO experience_extranet_content.experience_sub_type (experience_sub_type_id, experience_sub_type_name, experience_type_id, experience_category) VALUES ('REGULAR', 'Regular', 'UMRAH', 'MULTI_DAY_TOURS') ON CONFLICT (experience_sub_type_id, experience_type_id, experience_category) DO UPDATE SET experience_sub_type_name = EXCLUDED.experience_sub_type_name;
1139INSERT INTO experience_extranet_content.experience_sub_type (experience_sub_type_id, experience_sub_type_name, experience_type_id, experience_category) VALUES ('RAMADAN', 'Ramadan', 'UMRAH', 'MULTI_DAY_TOURS') ON CONFLICT (experience_sub_type_id, experience_type_id, experience_category) DO UPDATE SET experience_sub_type_name = EXCLUDED.experience_sub_type_name;
1140INSERT INTO experience_extranet_content.experience_sub_type (experience_sub_type_id, experience_sub_type_name, experience_type_id, experience_category) VALUES ('YEAR_END', 'Year End', 'UMRAH', 'MULTI_DAY_TOURS') ON CONFLICT (experience_sub_type_id, experience_type_id, experience_category) DO UPDATE SET experience_sub_type_name = EXCLUDED.experience_sub_type_name;
1141INSERT INTO experience_extranet_content.experience_sub_type (experience_sub_type_id, experience_sub_type_name, experience_type_id, experience_category) VALUES ('PLUS', 'Plus', 'UMRAH', 'MULTI_DAY_TOURS') ON CONFLICT (experience_sub_type_id, experience_type_id, experience_category) DO UPDATE SET experience_sub_type_name = EXCLUDED.experience_sub_type_name;
1142INSERT INTO experience_extranet_content.experience_sub_type (experience_sub_type_id, experience_sub_type_name, experience_type_id, experience_category) VALUES ('RAMADAN_PLUS', 'Ramadan Plus', 'UMRAH', 'MULTI_DAY_TOURS') ON CONFLICT (experience_sub_type_id, experience_type_id, experience_category) DO UPDATE SET experience_sub_type_name = EXCLUDED.experience_sub_type_name;
1143INSERT INTO experience_extranet_content.experience_sub_type (experience_sub_type_id, experience_sub_type_name, experience_type_id, experience_category) VALUES ('YEAR_END_PLUS', 'Year End Plus', 'UMRAH', 'MULTI_DAY_TOURS') ON CONFLICT (experience_sub_type_id, experience_type_id, experience_category) DO UPDATE SET experience_sub_type_name = EXCLUDED.experience_sub_type_name;
1144INSERT INTO experience_extranet_content.experience_sub_type (experience_sub_type_id, experience_sub_type_name, experience_type_id, experience_category) VALUES ('MEDICAL', 'Medical', 'MEDICAL', 'MULTI_DAY_TOURS') ON CONFLICT (experience_sub_type_id, experience_type_id, experience_category) DO UPDATE SET experience_sub_type_name = EXCLUDED.experience_sub_type_name;
1145INSERT INTO experience_extranet_content.experience_sub_type (experience_sub_type_id, experience_sub_type_name, experience_type_id, experience_category) VALUES ('EVENTS', 'Events', 'EVENTS', 'MULTI_DAY_TOURS') ON CONFLICT (experience_sub_type_id, experience_type_id, experience_category) DO UPDATE SET experience_sub_type_name = EXCLUDED.experience_sub_type_name;
1146INSERT INTO experience_extranet_content.experience_sub_type (experience_sub_type_id, experience_sub_type_name, experience_type_id, experience_category) VALUES ('SPORTS', 'Sports', 'SPORTS', 'MULTI_DAY_TOURS') ON CONFLICT (experience_sub_type_id, experience_type_id, experience_category) DO UPDATE SET experience_sub_type_name = EXCLUDED.experience_sub_type_name;
1147INSERT INTO experience_extranet_content.experience_sub_type (experience_sub_type_id, experience_sub_type_name, experience_type_id, experience_category) VALUES ('RELIGIOUS_TRIP', 'Religious Trip', 'RELIGIOUS_TRIP', 'MULTI_DAY_TOURS') ON CONFLICT (experience_sub_type_id, experience_type_id, experience_category) DO UPDATE SET experience_sub_type_name = EXCLUDED.experience_sub_type_name;
1148
1149INSERT INTO experience_extranet_content.experience_inclusion (inclusion_id, inclusion, inclusion_name, is_deleted) values(1,'ROUND_TRIP_FLIGHT','Round-Trip Flight', FALSE) ON CONFLICT (inclusion_id) DO NOTHING;
1150INSERT INTO experience_extranet_content.experience_inclusion (inclusion_id, inclusion, inclusion_name, is_deleted) values(2,'ACCOMMODATION','Accommodations', FALSE) ON CONFLICT (inclusion_id) DO NOTHING;
1151INSERT INTO experience_extranet_content.experience_inclusion (inclusion_id, inclusion, inclusion_name, is_deleted) values(3,'TOUR_GUIDE','Tour Guide', FALSE) ON CONFLICT(inclusion_id) DO NOTHING;
1152INSERT INTO experience_extranet_content.experience_inclusion (inclusion_id, inclusion, inclusion_name, is_deleted) values(4,'GROUND_TRANSPORT','Ground Transport', FALSE) ON CONFLICT (inclusion_id) DO NOTHING;
1153INSERT INTO experience_extranet_content.experience_inclusion (inclusion_id, inclusion, inclusion_name, is_deleted) values(5,'MEALS','Meals', FALSE) ON CONFLICT (inclusion_id) DO NOTHING;
1154INSERT INTO experience_extranet_content.experience_inclusion (inclusion_id, inclusion, inclusion_name, is_deleted) values(6,'ENTRANCE_TO_LOCAL_ATTRACTION','Entrace To Local Attraction', FALSE) ON CONFLICT (inclusion_id) DO NOTHING;
1155INSERT INTO experience_extranet_content.experience_inclusion (inclusion_id, inclusion, inclusion_name, is_deleted) values(7,'MERCHANDISE','Merchandise', FALSE) ON CONFLICT(inclusion_id) DO NOTHING;
1156INSERT INTO experience_extranet_content.experience_inclusion (inclusion_id, inclusion, inclusion_name, is_deleted) values(8,'TRAVEL_INSURANCE','Travel Insurance', FALSE) ON CONFLICT (inclusion_id) DO NOTHING;
1157INSERT INTO experience_extranet_content.experience_inclusion (inclusion_id, inclusion, inclusion_name, is_deleted) values(9,'MEDICAL_REQUIREMENT_OR_VACCINATION','Medical Requirement / Vaccination', FALSE) ON CONFLICT (inclusion_id) DO NOTHING;
1158INSERT INTO experience_extranet_content.experience_inclusion (inclusion_id, inclusion, inclusion_name, is_deleted) values(10,'VISA','Visa', FALSE) ON CONFLICT (inclusion_id) DO NOTHING;
1159INSERT INTO experience_extranet_content.experience_inclusion (inclusion_id, inclusion, inclusion_name, is_deleted) values(11,'PERSONAL_EXPENSES','Personal Expenses', FALSE) ON CONFLICT (inclusion_id) DO NOTHING;
1160INSERT INTO experience_extranet_content.experience_inclusion (inclusion_id, inclusion, inclusion_name, is_deleted) values(12,'AIRPORT_TRANSFER','Airport Transfer', FALSE) ON CONFLICT (inclusion_id) DO NOTHING;
1161
1162--CONTENT V2 API HELPER
1163CREATE OR REPLACE FUNCTION experience_extranet_content_v2_helper.get_experience_hotels_by_experience_id(experience_id_spec TEXT) returns jsonb
1164 security definer
1165 language sql
1166as $$
1167 SELECT jsonb_agg(result)
1168 FROM (
1169 SELECT hotel_id, city, name, information
1170 FROM experience_extranet_content.experience_multi_day_tours_hotel
1171 WHERE experience_id = experience_id_spec AND is_deleted = FALSE
1172 ) AS result
1173$$;
1174
1175CREATE OR REPLACE FUNCTION experience_extranet_content_v2_helper.get_additional_inclusions(experience_id_spec TEXT) returns TEXT
1176 security definer
1177 language sql
1178as $$
1179 SELECT additional_inclusions
1180 FROM experience_extranet_experience.experience_multi_day_tours
1181 WHERE experience_id = experience_id_spec
1182$$;
1183
1184CREATE OR REPLACE FUNCTION experience_extranet_content_v2_helper.get_additional_exclusions(experience_id_spec TEXT) returns TEXT
1185 security definer
1186 language sql
1187as $$
1188 SELECT additional_exclusions
1189 FROM experience_extranet_experience.experience_multi_day_tours
1190 WHERE experience_id = experience_id_spec
1191$$;
1192
1193-- CONTENT V2 API
1194CREATE OR REPLACE FUNCTION experience_extranet_content_v2_api.get_experience_sub_type_by_spec(experience_category_spec TEXT, experience_type_id_spec TEXT) returns SETOF jsonb
1195 security definer
1196 language sql
1197as $$
1198SELECT to_jsonb(res.*)
1199FROM (
1200 SELECT * FROM experience_extranet_content.experience_sub_type
1201 WHERE (experience_category_spec IS NULL OR experience_category_spec = experience_category) AND
1202 (experience_type_id_spec IS NULL OR experience_type_id_spec = experience_type_id)
1203 ) res
1204$$;
1205
1206CREATE OR REPLACE FUNCTION experience_extranet_content_v2_api.upsert_customer_group(customer_group jsonb) returns boolean
1207 security definer
1208 language plpgsql
1209as
1210$$
1211DECLARE
1212 group_unit_id_spec TEXT;
1213 group_id_spec TEXT;
1214 rate_type_object TEXT;
1215 rate_type_array TEXT[];
1216 group_name TEXT;
1217BEGIN
1218 group_unit_id_spec := REPLACE(UPPER(customer_group->>'customer_group_unit'), ' ', '_');
1219 group_id_spec := REPLACE(UPPER(customer_group->>'customer_group_name'), ' ', '_');
1220
1221 INSERT INTO experience_extranet_content.ticket_customer_group_unit (
1222 group_unit_id,
1223 group_unit
1224 )
1225 VALUES (
1226 group_unit_id_spec,
1227 customer_group->>'customer_group_unit'
1228 )
1229 ON CONFLICT (group_unit_id) DO UPDATE
1230 SET
1231 group_unit = EXCLUDED.group_unit;
1232
1233 INSERT INTO experience_extranet_content.ticket_customer_group_predefined (
1234 group_id,
1235 group_unit_id,
1236 group_name,
1237 group_description
1238 )
1239 VALUES (
1240 group_id_spec,
1241 group_unit_id_spec,
1242 customer_group->>'customer_group_name',
1243 customer_group->>'description'
1244 )
1245 ON CONFLICT (group_id, group_unit_id) DO UPDATE
1246 SET
1247 group_name = EXCLUDED.group_name,
1248 group_description = EXCLUDED.group_description;
1249
1250 rate_type_array := ARRAY ['CONTRACT','PUBLISH','PARITY','RECOMMENDED'];
1251FOREACH rate_type_object in ARRAY rate_type_array
1252 LOOP
1253 group_name := REPLACE(customer_group->>'customer_group_name', ' ', '_');
1254 INSERT INTO experience_extranet_content.ticket_customer_group_rate_type (
1255 group_id,
1256 rate_type
1257 )
1258 VALUES (
1259 group_id_spec,
1260 UPPER(group_name) || '_' || rate_type_object
1261 )
1262 ON CONFLICT DO NOTHING ;
1263 END LOOP;
1264 RETURN FOUND;
1265END;
1266$$;
1267
1268-- Commented, because cyclic dependencies
1269CREATE OR REPLACE FUNCTION experience_extranet_content_v2_api.get_contents_by_experience_id(experience_id text) returns jsonb
1270 security definer
1271 language sql
1272as
1273$$
1274SELECT to_jsonb(result)
1275 FROM (
1276 SELECT
1277 experience_extranet_content_v1_helper.get_themes_by_experience_id(experience_id) AS "themes",
1278 experience_extranet_content_v1_helper.get_price_exclusion_by_experience_id(experience_id) AS "exclusion_prices",
1279 experience_extranet_content_v1_helper.get_price_inclusion_by_experience_id(experience_id) AS "inclusion_prices",
1280 experience_extranet_content_v1_helper.get_nearby_facilities_by_experience_id(experience_id) AS "nearby_facilities",
1281 experience_extranet_content_v1_helper.get_facilities_by_experience_id(experience_id) AS "onsite_facilities",
1282 experience_extranet_content_v1_helper.get_clothing_policies_by_experience_id(experience_id) AS "clothing_policies",
1283 experience_extranet_content_v1_helper.get_additional_necessities_by_experience_id(experience_id) AS "additional_necessities",
1284 experience_extranet_content_v1_helper.get_term_conditions_by_experience_id(experience_id) AS "term_conditions",
1285 translate(experience_extranet_content_v1_helper.get_service_languages_by_experience_id(experience_id) :: TEXT,
1286 '\"',
1287 '') :: TEXT [] AS "service_language",
1288 experience_extranet_content_v1_helper.get_attributes_by_experience_id(experience_id) AS "extranet_experience_attributes",
1289 experience_extranet_management_v2_helper.get_experience_itineraries_contents(experience_id) AS "itineraries_base",
1290 experience_extranet_management_v2_helper.get_experience_itineraries_descriptions_contents(experience_id) AS "itineraries",
1291 experience_extranet_content_v2_helper.get_operational_day_content_by_experience_id(experience_id) AS "operational_days",
1292 experience_extranet_content_v2_helper.get_experience_tags_by_experience_id(experience_id) AS "tags",
1293 experience_extranet_management_v2_helper.get_experience_sections_by_experience_id(experience_id) AS "sections",
1294 experience_extranet_content_v2_helper.get_operational_period_content_by_experience_id(experience_id) AS "operational_periods",
1295 experience_extranet_content_v2_helper.get_public_transport_by_experience_id(experience_id) AS "public_transports",
1296 experience_extranet_content_v2_helper.get_shuttle_transport_by_experience_id(experience_id) AS "shuttle_transport",
1297 experience_extranet_content_v2_helper.get_event_schedule_by_experience_id(experience_id) AS "event_schedules",
1298 experience_extranet_content_v2_helper.get_audio_guide_by_experience_id(experience_id) AS "audio_guide",
1299 experience_extranet_content_v2_helper.get_guided_tour_by_experience_id(experience_id) AS "guided_tour",
1300 experience_extranet_content_v2_helper.get_additional_content_data_by_experience_id(experience_id) AS "additional_data_content",
1301 experience_extranet_content_v2_helper.get_experience_hotels_by_experience_id(experience_id) AS "hotels",
1302 experience_extranet_content_v2_helper.get_additional_inclusions(experience_id) AS "additional_inclusions",
1303 experience_extranet_content_v2_helper.get_additional_exclusions(experience_id) AS "additional_exclusions"
1304 ) AS result
1305$$;
1306
1307CREATE OR REPLACE FUNCTION experience_extranet_content_v2_api.get_experience_inclusions() returns SETOF jsonb
1308 security definer
1309 language sql
1310as $$
1311SELECT to_jsonb(res.*)
1312FROM (
1313 SELECT * FROM experience_extranet_content.experience_inclusion
1314 WHERE is_deleted = FALSE
1315 ) res
1316$$;
1317
1318--MANAGEMENT V2 HELPER
1319CREATE OR REPLACE FUNCTION experience_extranet_management_v2_helper.get_experience_multi_day_tours_additional_data(
1320 filter_experience_id TEXT)
1321 RETURNS JSONB
1322SECURITY DEFINER
1323LANGUAGE SQL
1324AS $$
1325WITH get_multi_day_tours_result AS (SELECT duration_day, duration_hour, duration_minute, flight_included, additional_inclusions, additional_exclusions
1326 FROM experience_extranet_experience.experience_multi_day_tours
1327 WHERE experience_id = filter_experience_id),
1328 get_inclusions_result AS (SELECT jsonb_agg(to_jsonb(result))
1329 FROM (SELECT im.experience_id, im.inclusion_id, im._lut, m.inclusion, m.inclusion_name
1330 FROM experience_extranet_content.experience_inclusion_mapping im
1331 JOIN experience_extranet_content.experience_inclusion m ON m.inclusion_id = im.inclusion_id
1332 WHERE im.experience_id = filter_experience_id AND im.is_deleted = FALSE) result),
1333 get_sub_type_result AS (SELECT to_jsonb(result)
1334 FROM (SELECT stm.experience_sub_type_id, stm._lut, st.experience_sub_type_name
1335 FROM experience_extranet_content.experience_sub_type_mapping stm
1336 JOIN experience_extranet_content.experience_sub_type st ON st.experience_sub_type_id = stm.experience_sub_type_id
1337 WHERE stm.experience_id = filter_experience_id) result),
1338 get_hotels_result AS (SELECT jsonb_agg(to_jsonb(result))
1339 FROM (SELECT hotel_id, city, rating, name, photos, information
1340 FROM experience_extranet_content.experience_multi_day_tours_hotel
1341 WHERE experience_id = filter_experience_id
1342 ORDER BY hotel_id ASC) result
1343
1344 ),
1345 get_departure_flights_result AS (SELECT jsonb_agg(to_jsonb(result))
1346 FROM (SELECT mdtf.flight_id, mdtf.airline_code, mdtf.flight_order, experience_extranet_resource_v1_helper.get_airport_by_iata(mdtf.departure_port) AS departure_port, experience_extranet_resource_v1_helper.get_airport_by_iata(mdtf.destination_port) AS destination_port, mdtf._lut, f.airline_name, f.image_url
1347 FROM experience_extranet_experience.experience_multi_day_tours_flight mdtf
1348 JOIN experience_extranet_resource.flight f ON f.airline_code = mdtf.airline_code
1349 WHERE experience_id = filter_experience_id AND mdtf.is_deleted = FALSE AND mdtf.is_return_flight = FALSE
1350 ORDER BY flight_order ASC) result),
1351 get_return_flights_result AS (SELECT jsonb_agg(to_jsonb(result))
1352 FROM (SELECT mdtf.flight_id, mdtf.airline_code, mdtf.flight_order, experience_extranet_resource_v1_helper.get_airport_by_iata(mdtf.departure_port) AS departure_port, experience_extranet_resource_v1_helper.get_airport_by_iata(mdtf.destination_port) AS destination_port, mdtf._lut, f.airline_name, f.image_url
1353 FROM experience_extranet_experience.experience_multi_day_tours_flight mdtf
1354 JOIN experience_extranet_resource.flight f ON f.airline_code = mdtf.airline_code
1355 WHERE experience_id = filter_experience_id AND mdtf.is_deleted = FALSE AND mdtf.is_return_flight = TRUE
1356 ORDER BY flight_order ASC) result)
1357SELECT jsonb_build_object(
1358 'flight_included', (SELECT flight_included FROM get_multi_day_tours_result),
1359 'duration_day', (SELECT duration_day FROM get_multi_day_tours_result),
1360 'duration_hour', (SELECT duration_hour FROM get_multi_day_tours_result),
1361 'duration_minute', (SELECT duration_minute FROM get_multi_day_tours_result),
1362 'inclusions', (SELECT * FROM get_inclusions_result),
1363 'additional_inclusions', (SELECT additional_inclusions FROM get_multi_day_tours_result),
1364 'additional_exclusions', (SELECT additional_exclusions FROM get_multi_day_tours_result),
1365 'sub_type', (SELECT * FROM get_sub_type_result),
1366 'departure_flights', (SELECT * FROM get_departure_flights_result),
1367 'return_flights', (SELECT * FROM get_return_flights_result),
1368 'hotels', (SELECT * FROM get_hotels_result),
1369 'itineraries', (SELECT array_agg(get_experience_itineraries::JSONB) FROM experience_extranet_management_v2_helper.get_experience_itineraries(filter_experience_id)));
1370$$;
1371
1372
1373CREATE OR REPLACE FUNCTION experience_extranet_management_v2_helper.upsert_experience_multi_day_tours_additional_data(filter_experience_id TEXT, additional_data_spec JSONB) returns boolean
1374 security definer
1375 language plpgsql
1376as $$
1377DECLARE
1378 inclusion JSONB;
1379 hotel JSONB;
1380 departure_flight JSONB;
1381 return_flight JSONB;
1382 itinerary JSONB;
1383BEGIN
1384
1385INSERT INTO experience_extranet_experience.experience_multi_day_tours (experience_id, duration_day, duration_hour, duration_minute, flight_included, additional_inclusions, additional_exclusions)
1386VALUES (filter_experience_id, (additional_data_spec->>'duration_day')::INTEGER, (additional_data_spec->>'duration_hour')::INTEGER, (additional_data_spec->>'duration_minute')::INTEGER,
1387 COALESCE((additional_data_spec->>'flight_included')::BOOLEAN, FALSE), additional_data_spec->>'additional_inclusions', additional_data_spec->>'additional_exclusions')
1388ON CONFLICT (experience_id)
1389DO UPDATE SET duration_day = EXCLUDED.duration_day,
1390 duration_hour = EXCLUDED.duration_hour,
1391 duration_minute = EXCLUDED.duration_minute,
1392 flight_included = EXCLUDED.flight_included,
1393 additional_inclusions = EXCLUDED.additional_inclusions,
1394 additional_exclusions = EXCLUDED.additional_exclusions;
1395
1396UPDATE experience_extranet_content.experience_multi_day_tours_hotel SET is_deleted = TRUE WHERE experience_id = filter_experience_id;
1397FOR hotel IN SELECT jsonb_array_elements(additional_data_spec->'hotels') LOOP
1398 INSERT INTO experience_extranet_content.experience_multi_day_tours_hotel(hotel_id,experience_id,city,rating,name,photos,information,is_deleted)
1399 VALUES(COALESCE((hotel->>'hotel_id')::BIGINT, nextval('experience_extranet_content.experience_multi_day_tours_hotel_hotel_id_seq')),
1400 filter_experience_id,
1401 hotel->>'city',
1402 (hotel->>'rating')::INTEGER,
1403 hotel->>'name',
1404 (hotel->>'photos')::JSONB,
1405 hotel->>'information',
1406 FALSE
1407 ) ON CONFLICT (hotel_id)
1408 DO UPDATE SET experience_id = EXCLUDED.experience_id,
1409 city = EXCLUDED.city,
1410 rating = COALESCE(EXCLUDED.rating, experience_multi_day_tours_hotel.rating),
1411 name = EXCLUDED.name,
1412 photos = COALESCE(EXCLUDED.photos, experience_multi_day_tours_hotel.photos),
1413 information = EXCLUDED.information,
1414 is_deleted = FALSE
1415 ;
1416END LOOP;
1417
1418UPDATE experience_extranet_experience.experience_multi_day_tours_flight SET is_deleted = TRUE WHERE experience_id = filter_experience_id;
1419FOR departure_flight IN SELECT jsonb_array_elements(additional_data_spec->'departure_flights') LOOP
1420 INSERT INTO experience_extranet_experience.experience_multi_day_tours_flight(flight_id,experience_id,airline_code,flight_order,departure_port,destination_port,is_return_flight,is_deleted)
1421 VALUES(COALESCE((departure_flight->>'flight_id')::BIGINT, nextval('experience_extranet_experience.experience_multi_day_tours_flight_flight_id_seq')),
1422 filter_experience_id,
1423 departure_flight->>'airline_code',
1424 (departure_flight->>'flight_order')::INTEGER,
1425 departure_flight->'departure_port'->>'iata',
1426 departure_flight->'destination_port'->>'iata',
1427 FALSE,
1428 FALSE
1429 ) ON CONFLICT(flight_id)
1430 DO UPDATE SET experience_id = EXCLUDED.experience_id,
1431 airline_code = EXCLUDED.airline_code,
1432 flight_order = EXCLUDED.flight_order,
1433 departure_port = EXCLUDED.departure_port,
1434 destination_port = EXCLUDED.destination_port,
1435 is_return_flight = FALSE,
1436 is_deleted = FALSE
1437 ;
1438END LOOP;
1439
1440FOR return_flight IN SELECT jsonb_array_elements(additional_data_spec->'return_flights') LOOP
1441 INSERT INTO experience_extranet_experience.experience_multi_day_tours_flight(flight_id,experience_id,airline_code,flight_order,departure_port,destination_port,is_return_flight,is_deleted)
1442 VALUES(COALESCE((return_flight->>'flight_id')::BIGINT, nextval('experience_extranet_experience.experience_multi_day_tours_flight_flight_id_seq')),
1443 filter_experience_id,
1444 return_flight->>'airline_code',
1445 (return_flight->>'flight_order')::INTEGER,
1446 return_flight->'departure_port'->>'iata',
1447 return_flight->'destination_port'->>'iata',
1448 TRUE,
1449 FALSE
1450 ) ON CONFLICT(flight_id)
1451 DO UPDATE SET experience_id = EXCLUDED.experience_id,
1452 airline_code = EXCLUDED.airline_code,
1453 flight_order = EXCLUDED.flight_order,
1454 departure_port = EXCLUDED.departure_port,
1455 destination_port = EXCLUDED.destination_port,
1456 is_return_flight = TRUE,
1457 is_deleted = FALSE
1458 ;
1459END LOOP;
1460
1461UPDATE experience_extranet_content.experience_inclusion_mapping SET is_deleted = TRUE WHERE experience_id = filter_experience_id;
1462FOR inclusion IN SELECT jsonb_array_elements(additional_data_spec->'inclusions') LOOP
1463 INSERT INTO experience_extranet_content.experience_inclusion_mapping(experience_id,inclusion_id,is_deleted)
1464 VALUES(filter_experience_id,
1465 (inclusion->>'inclusion_id')::BIGINT,
1466 FALSE
1467 ) ON CONFLICT(experience_id, inclusion_id)
1468 DO UPDATE SET is_deleted = FALSE
1469 ;
1470END LOOP;
1471 DELETE FROM experience_extranet_content.experience_sub_type_mapping WHERE experience_id = filter_experience_id;
1472 INSERT INTO experience_extranet_content.experience_sub_type_mapping (experience_sub_type_id, experience_id)
1473 VALUES (
1474 additional_data_spec->'sub_type'->>'experience_sub_type_id',
1475 filter_experience_id
1476 );
1477
1478DELETE FROM experience_extranet_experience.experience_itinerary
1479 WHERE NOT EXISTS (
1480 SELECT experience_itinerary_id
1481 FROM jsonb_array_elements(additional_data_spec->'itineraries') AS elem
1482 WHERE experience_itinerary_id = (elem->>'experience_itinerary_id')::BIGINT
1483 ) AND experience_id = filter_experience_id;
1484
1485 FOR itinerary IN SELECT jsonb_array_elements(additional_data_spec->'itineraries') LOOP
1486 PERFORM experience_extranet_management_v2_helper.upsert_experience_itinerary(filter_experience_id, itinerary);
1487 END LOOP;
1488
1489 RETURN FOUND;
1490END;
1491$$;