gistfile1.txt

CREATE TABLE regions
(
    id SERIAL PRIMARY KEY NOT NULL,
    name VARCHAR(500),
    uri VARCHAR(250) NOT NULL
);

INSERT INTO public.regions (id, name, uri) VALUES (1, 'Asia', 'asia');
INSERT INTO public.regions (id, name, uri) VALUES (2, 'Europe', 'europe');
INSERT INTO public.regions (id, name, uri) VALUES (3, 'Africa', 'africa');
INSERT INTO public.regions (id, name, uri) VALUES (4, 'Latin America', 'latin-america');
INSERT INTO public.regions (id, name, uri) VALUES (5, 'Middle East', 'middle-east');
INSERT INTO public.regions (id, name, uri) VALUES (6, 'Caribbean', 'caribbean');
INSERT INTO public.regions (id, name, uri) VALUES (7, 'North America', 'north-america');



CREATE TABLE countries
(
    id SERIAL PRIMARY KEY NOT NULL,
    region_id BIGINT,
    name VARCHAR(500),
    short_name VARCHAR(50),
    FOREIGN KEY (region_id) REFERENCES regions (id)
);
CREATE INDEX fki_countries_fk0 ON countries (region_id);


INSERT INTO public.countries (id, region_id, name, short_name) VALUES (6, 1, 'Bangladesh', 'BD');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (9, 4, 'Brazil', 'BR');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (13, 4, 'Colombia', 'CO');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (67, 2, 'Estonia', 'EE');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (7, 2, 'Belarus', 'BY');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (27, 2, 'Ireland', 'IE ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (68, 3, 'Angola', 'AO');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (2, 4, 'Argentina', 'AR');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (4, 2, 'Austria', 'AT');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (5, 2, 'Azerbaijan', 'AZ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (10, 2, 'Bulgaria', 'BG');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (11, 7, 'Canada', 'CA');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (12, 1, 'China', 'CN');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (14, 2, 'Croatia', 'HR');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (15, 2, 'Czech Republic', 'CZ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (16, 2, 'Denmark', 'DK');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (18, 2, 'Finland', 'FI');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (19, 2, 'France', 'FR');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (20, 2, 'Georgia', 'GE');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (21, 2, 'Germany', 'DE');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (22, 2, 'Greece', 'GR');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (23, 1, 'Hong Kong', 'HK');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (26, 5, 'Iran', 'IR');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (28, 2, 'Italy', 'IT ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (29, 1, 'Japan', 'JP ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (31, 2, 'Kyrgyzstan', 'KG ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (70, 3, 'South Sudan', 'SS');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (33, 5, 'Lebanon', 'LB ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (34, 2, 'Luxembourg', 'LU ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (35, 4, 'Mexico', 'MX ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (37, 2, 'Monaco', 'MC ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (36, 2, 'Moldova', 'MD');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (38, 3, 'Morocco', 'MA ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (40, 1, 'New Zealand', 'NZ ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (41, 2, 'Norway', 'NO ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (42, 4, 'Peru', 'PE ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (43, 2, 'Poland', 'PL ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (44, 2, 'Portugal', 'PT ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (45, 2, 'Romania', 'RO ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (50, 2, 'Slovakia', 'SK ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (49, 1, 'Singapore', 'SG');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (51, 2, 'Slovenia', 'SI ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (54, 2, 'Spain', 'ES ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (52, 3, 'South Africa', 'ZA');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (53, 1, 'South Korea', 'KR');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (56, 2, 'Sweden', 'SE ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (57, 2, 'Switzerland', 'CH ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (58, 1, 'Taiwan', 'TW ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (59, 1, 'Thailand', 'TH ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (60, 3, 'Tunisia', 'TN ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (61, 2, 'Turkey', 'TR ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (64, 2, 'United Kingdom', 'UK');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (63, 5, 'United Arab Emirates', 'AE');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (71, 1, 'Australia', 'AU');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (3, 2, 'Armenia', 'AM');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (69, 4, 'Antigua and Barbuda', 'AG');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (73, 6, 'Bahamas', 'BS');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (75, 6, 'Barbados', 'BB');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (76, 6, 'Belize', 'BZ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (77, 3, 'Benin', 'BJ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (79, 1, 'Bhutan', 'BT');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (81, 2, 'Bosnia-Herzegovina', 'BA');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (82, 3, 'Botswana', 'BW');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (83, 1, 'Brunei', 'BN');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (84, 3, 'Burkina Faso', 'BF');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (85, 3, 'Burundi', 'BI');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (87, 3, 'Cameroon', 'CM');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (88, 3, 'Cape Verde', 'CV');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (89, 6, 'Cayman Islands', 'KY');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (91, 3, 'Chad', 'TD');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (92, 4, 'Chile', 'CL');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (93, 3, 'Comoros', 'KM');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (95, 3, 'Congo-Brazzaville', 'CG');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (96, 6, 'Costa Rica', 'CR');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (98, 6, 'Cuba', 'CU');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (100, 2, 'Cyprus', 'CY');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (101, 3, 'Djibouti', 'DJ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (103, 6, 'Dominican Republic', 'DO');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (104, 1, 'East Timor', 'TL');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (105, 4, 'Ecuador', 'EC');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (106, 4, 'El Salvador', 'SV');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (108, 3, 'Eritrea', 'ER');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (109, 3, 'Ethiopia', 'ET');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (110, 3, 'Gabon', 'GA');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (111, 3, 'Gambia', 'GM');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (112, 3, 'Ghana', 'GH');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (113, 6, 'Grenada', 'GD');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (116, 3, 'Guinea', 'GN');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (117, 3, 'Guinea-Bissau', 'GW');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (119, 2, 'Iceland', 'IS');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (120, 1, 'Indonesia', 'ID');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (121, 5, 'Iraq', 'IQ ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (122, 5, 'Israel', 'IL ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (123, 6, 'Jamaica', 'JM ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (125, 3, 'Kenya', 'KE ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (127, 5, 'Kuwait', 'KW ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (129, 3, 'Liberia', 'LR ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (130, 2, 'Liechtenstein', 'LI ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (131, 1, 'Laos', 'LA ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (133, 2, 'Macedonia', 'MK ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (134, 3, 'Madagascar', 'MG ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (135, 3, 'Malawi', 'MW ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (136, 1, 'Malaysia', 'MY ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (138, 3, 'Mali', 'ML ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (140, 6, 'Martinique', 'MQ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (141, 3, 'Mauritania', 'MR ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (143, 2, 'Montenegro', 'ME ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (144, 6, 'Montserrat', 'MS ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (145, 3, 'Mozambique', 'MZ ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (146, 1, 'Myanmar', 'MM');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (148, 4, 'Nicaragua', 'NI ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (149, 3, 'Niger', 'NE ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (150, 3, 'Nigeria', 'NG');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (151, 5, 'Oman', 'OM ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (153, 4, 'Panama', 'PA');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (155, 1, 'Philippines', 'PH ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (24, 2, 'Hungary', ' HU');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (65, null, 'United States', 'US');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (30, 2, 'Kazakhstan', 'KZ ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (66, null, 'Viet Nam', ' ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (46, 2, 'Russian Federation', 'RU');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (47, 2, 'San Marino', 'SM');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (142, 3, 'Mauritius', 'MU ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (147, 3, 'Namibia', 'NA ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (194, 1, 'Afghanistan', 'AF');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (152, 1, 'Pakistan', 'PK ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (72, 2, 'Albania', 'AL');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (1, 3, 'Algeria', 'DZ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (8, 2, 'Belgium', 'BE');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (17, 3, 'Egypt', 'EG');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (25, 1, 'India', 'IN');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (156, 6, 'Puerto Rico', 'PR ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (157, 5, 'Qatar', 'QA ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (159, 3, 'Rwanda', 'RW ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (78, 6, 'Bermuda', 'BM');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (94, 3, 'Congo (DRC)', 'CD');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (115, 4, 'Guatemala', 'GT');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (126, 2, 'Kosovo', 'XK ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (139, 2, 'Malta', 'MT ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (154, 1, 'Papua New Guinea', 'PA ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (32, 2, 'Latvia', 'LV ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (39, 2, 'Netherlands', 'NL ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (48, 2, 'Serbia', 'RS ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (55, 1, 'Sri Lanka', 'LK ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (62, 2, 'Ukraine', 'UA ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (74, 5, 'Bahrain', 'BH');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (80, 4, 'Bolivia', 'BO');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (86, 1, 'Cambodia', 'KH');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (90, 3, 'Central African Republic', 'CF');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (99, 6, 'Curacao', 'CW');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (102, 6, 'Dominica', 'DM');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (107, 3, 'Equatorial Guinea', 'GQ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (114, 6, 'Guadeloupe', 'GP');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (118, 6, 'Honduras', 'HN');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (124, 5, 'Jordan', 'JO ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (128, 3, 'Lesotho', 'LS ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (132, 2, 'Lithuania', 'LT ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (137, 1, 'Maldives', 'MV ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (160, 6, 'Saint Kitts and Nevis', 'KN ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (161, 6, 'Saint Lucia', 'LC ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (162, 1, 'Samoa', 'WS ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (163, 5, 'Saudi Arabia', 'SA ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (165, 3, 'Senegal', 'SN ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (166, 3, 'Seychelles', 'SC ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (167, 3, 'Sierra Leone', 'SL ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (168, 1, 'Solomon Islands', 'SB ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (169, 3, 'Somalia', 'SO ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (170, 3, 'Sudan', 'SD ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (171, 4, 'Suriname', 'SR ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (172, 3, 'Swaziland', 'SZ ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (173, 5, 'Syria', 'SY ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (175, 3, 'Tanzania', 'TZ ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (176, 3, 'Togo', 'TG ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (178, 3, 'Uganda', 'UG');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (181, 1, 'Vanuatu', 'VU ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (182, 4, 'Venezuela', 'VE ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (183, 6, 'Virgin Islands, British', 'VG ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (184, 6, 'Virgin Islands, U.S.', 'VI ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (185, 5, 'Yemen', 'YE ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (186, 4, 'Uruguay', 'UY ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (187, 3, 'Libya', 'LY ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (188, 4, 'Guyana', 'GY');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (189, 6, 'Haiti', 'HT');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (190, 1, 'Nepal', 'NP ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (191, 3, 'Zambia', 'ZM ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (192, 3, 'Zimbabwe', 'ZW ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (193, 1, 'Vietnam', 'VT');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (97, 3, 'Côte d''Ivoire', 'CI');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (174, 2, 'Tajikistan', 'TJ ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (177, 2, 'Turkmenistan', 'TM ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (180, 2, 'Uzbekistan', 'UZ ');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (264, 3, 'Côte d''Ivoire', 'CI');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (273, 3, 'Congo (DRC)', 'CD');
INSERT INTO public.countries (id, region_id, name, short_name) VALUES (275, 3, 'Congo-Brazzaville', 'CG');