drop table if exists t_eu_country; 

create table t_eu_country (
    cceu varchar(4) primary key,
    cc2 varchar(4),
    cc3 varchar(4),
    short_name varchar(64),
    short_name_en varchar(64),
    official_name_en varchar(256),
    eu_entry_date date,
    eu_exit_date date,
    schengen_implementation_date date
);

create unique index i_eu_country_cc2 on t_eu_country (cc2); 
create unique index i_eu_country_cc3 on t_eu_country (cc3); 

INSERT INTO t_eu_country (cceu, cc2, cc3, short_name, short_name_en, 
    official_name_en, eu_entry_date, eu_exit_date, schengen_implementation_date) 
    VALUES ('BE', 'BE', 'BEL', 'Belgique/België', 'Belgium', 'Kingdom of Belgium',
    '1958-01-01', '9999-12-31', '1995-03-26');
INSERT INTO t_eu_country (cceu, cc2, cc3, short_name, short_name_en, 
    official_name_en, eu_entry_date, eu_exit_date, schengen_implementation_date) 
    VALUES ('DE', 'DE', 'DEU', 'Deutschland', 'Germany', 'Federal Republic of Germany',
    '1958-01-01', '9999-12-31', '1995-03-26');
INSERT INTO t_eu_country (cceu, cc2, cc3, short_name, short_name_en, 
    official_name_en, eu_entry_date, eu_exit_date, schengen_implementation_date) 
    VALUES ('FR', 'FR', 'FRA', 'France', 'France', 'French Republic',
    '1958-01-01', '9999-12-31', '1995-03-26');
INSERT INTO t_eu_country (cceu, cc2, cc3, short_name, short_name_en, 
    official_name_en, eu_entry_date, eu_exit_date, schengen_implementation_date) 
    VALUES ('IT', 'IT', 'ITA', 'Italia', 'Italy', 'Italian Republic',
    '1958-01-01', '9999-12-31', '1997-10-26');
INSERT INTO t_eu_country (cceu, cc2, cc3, short_name, short_name_en, 
    official_name_en, eu_entry_date, eu_exit_date, schengen_implementation_date) 
    VALUES ('LU', 'LU', 'LUX', 'Luxembourg', 'Luxembourg', 'Grand Duchy of Luxembourg',
    '1958-01-01', '9999-12-31', '1995-03-26');
INSERT INTO t_eu_country (cceu, cc2, cc3, short_name, short_name_en, 
    official_name_en, eu_entry_date, eu_exit_date, schengen_implementation_date) 
    VALUES ('NL', 'NL', 'NLD', 'Nederland', 'Netherlands', 'Kingdom of the Netherlands',
    '1958-01-01', '9999-12-31', '1995-03-26');
INSERT INTO t_eu_country (cceu, cc2, cc3, short_name, short_name_en, 
    official_name_en, eu_entry_date, eu_exit_date, schengen_implementation_date) 
    VALUES ('DK', 'DK', 'DNK', 'Danmark', 'Denmark', 'Kingdom of Denmark',
    '1973-01-01', '9999-12-31', '2001-03-25');
INSERT INTO t_eu_country (cceu, cc2, cc3, short_name, short_name_en, 
    official_name_en, eu_entry_date, eu_exit_date, schengen_implementation_date) 
    VALUES ('IE', 'IE', 'IRL', 'Éire/Ireland', 'Ireland', 'Ireland',
    '1973-01-01', '9999-12-31', NULL);
INSERT INTO t_eu_country (cceu, cc2, cc3, short_name, short_name_en, 
    official_name_en, eu_entry_date, eu_exit_date, schengen_implementation_date) 
    VALUES ('UK', 'GB', 'GBR', 'United  Kingdom', 'United  Kingdom', 
    'United Kingdom of Great Britain and Northern Ireland',
    '1973-01-01', '2020-02-01', NULL);
INSERT INTO t_eu_country (cceu, cc2, cc3, short_name, short_name_en, 
    official_name_en, eu_entry_date, eu_exit_date, schengen_implementation_date) 
    VALUES ('EL', 'GR', 'GRC', 'Ελλάδα', 'Greece', 'Hellenic Republic',
    '1981-01-01', '9999-12-31', '2000-01-01');
INSERT INTO t_eu_country (cceu, cc2, cc3, short_name, short_name_en, 
    official_name_en, eu_entry_date, eu_exit_date, schengen_implementation_date) 
    VALUES ('ES', 'ES', 'ESP', 'España', 'Spain', 'Kingdom of Spain',
    '1986-01-01', '9999-12-31', '1995-03-26');
INSERT INTO t_eu_country (cceu, cc2, cc3, short_name, short_name_en, 
    official_name_en, eu_entry_date, eu_exit_date, schengen_implementation_date) 
    VALUES ('PT', 'PT', 'PRT', 'Portugal', 'Portugal', 'Portuguese Republic',
    '1986-01-01', '9999-12-31', '1995-03-26');
INSERT INTO t_eu_country (cceu, cc2, cc3, short_name, short_name_en, 
    official_name_en, eu_entry_date, eu_exit_date, schengen_implementation_date) 
    VALUES ('AT', 'AT', 'AUT', 'Österreich', 'Austria', 'Republic of Austria',
    '1995-01-01', '9999-12-31', '1997-12-01');
INSERT INTO t_eu_country (cceu, cc2, cc3, short_name, short_name_en, 
    official_name_en, eu_entry_date, eu_exit_date, schengen_implementation_date) 
    VALUES ('FI', 'FI', 'FIN', 'Suomi/Finland', 'Finland', 'Republic of Finland',
    '1995-01-01', '9999-12-31', '2001-03-25');
INSERT INTO t_eu_country (cceu, cc2, cc3, short_name, short_name_en, 
    official_name_en, eu_entry_date, eu_exit_date, schengen_implementation_date) 
    VALUES ('SE', 'SE', 'SWE', 'Sverige', 'Sweden', 'Kingdom of Sweden',
    '1995-01-01', '9999-12-31', '2001-03-25');
INSERT INTO t_eu_country (cceu, cc2, cc3, short_name, short_name_en, 
    official_name_en, eu_entry_date, eu_exit_date, schengen_implementation_date) 
    VALUES ('CY', 'CY', 'CYP', 'Κύπρος', 'Cyprus', 'Republic of Cyprus',
    '2004-05-01', '9999-12-31', NULL);
INSERT INTO t_eu_country (cceu, cc2, cc3, short_name, short_name_en, 
    official_name_en, eu_entry_date, eu_exit_date, schengen_implementation_date) 
    VALUES ('CZ', 'CZ', 'CZE', 'Česko', 'Czechia', 'Czech Republic',
    '2004-05-01', '9999-12-31', '2007-12-21');
INSERT INTO t_eu_country (cceu, cc2, cc3, short_name, short_name_en, 
    official_name_en, eu_entry_date, eu_exit_date, schengen_implementation_date) 
    VALUES ('EE', 'EE', 'EST', 'Eesti', 'Estonia', 'Republic of Estonia',
    '2004-05-01', '9999-12-31', '2007-12-21');
INSERT INTO t_eu_country (cceu, cc2, cc3, short_name, short_name_en, 
    official_name_en, eu_entry_date, eu_exit_date, schengen_implementation_date) 
    VALUES ('HU', 'HU', 'HUN', 'Magyarország', 'Hungary', 'Hungary',
    '2004-05-01', '9999-12-31', '2007-12-21');
INSERT INTO t_eu_country (cceu, cc2, cc3, short_name, short_name_en, 
    official_name_en, eu_entry_date, eu_exit_date, schengen_implementation_date) 
    VALUES ('LT', 'LT', 'LTU', 'Lietuva', 'Lithuania', 'Republic of Lithuania',
    '2004-05-01', '9999-12-31', '2007-12-21');
INSERT INTO t_eu_country (cceu, cc2, cc3, short_name, short_name_en, 
    official_name_en, eu_entry_date, eu_exit_date, schengen_implementation_date) 
    VALUES ('LV', 'LV', 'LVA', 'Latvija', 'Latvia', 'Republic of Latvia',
    '2004-05-01', '9999-12-31', '2007-12-21');
INSERT INTO t_eu_country (cceu, cc2, cc3, short_name, short_name_en, 
    official_name_en, eu_entry_date, eu_exit_date, schengen_implementation_date) 
    VALUES ('MT', 'MT', 'MLT', 'Malta', 'Malta', 'Republic of Malta',
    '2004-05-01', '9999-12-31', '2007-12-21');
INSERT INTO t_eu_country (cceu, cc2, cc3, short_name, short_name_en, 
    official_name_en, eu_entry_date, eu_exit_date, schengen_implementation_date) 
    VALUES ('PL', 'PL', 'POL', 'Polska', 'Poland', 'Republic of Poland',
    '2004-05-01', '9999-12-31', '2007-12-21');
INSERT INTO t_eu_country (cceu, cc2, cc3, short_name, short_name_en, 
    official_name_en, eu_entry_date, eu_exit_date, schengen_implementation_date) 
    VALUES ('SI', 'SI', 'SVN', 'Slovenija', 'Slovenia', 'Republic of Slovenia',
    '2004-05-01', '9999-12-31', '2007-12-21');
INSERT INTO t_eu_country (cceu, cc2, cc3, short_name, short_name_en, 
    official_name_en, eu_entry_date, eu_exit_date, schengen_implementation_date) 
    VALUES ('SK', 'SK', 'SVK', 'Slovensko', 'Slovakia', 'Slovak Republic',
    '2004-05-01', '9999-12-31', '2007-12-21');
INSERT INTO t_eu_country (cceu, cc2, cc3, short_name, short_name_en, 
    official_name_en, eu_entry_date, eu_exit_date, schengen_implementation_date) 
    VALUES ('BG', 'BG', 'BGR', 'България', 'Bulgaria', 'Republic of Bulgaria',
    '2007-01-01', '9999-12-31', NULL);
INSERT INTO t_eu_country (cceu, cc2, cc3, short_name, short_name_en, 
    official_name_en, eu_entry_date, eu_exit_date, schengen_implementation_date) 
    VALUES ('RO', 'RO', 'ROU', 'România', 'Romania', 'Romania', '2007-01-01',
    '9999-12-31', NULL);
INSERT INTO t_eu_country (cceu, cc2, cc3, short_name, short_name_en, 
    official_name_en, eu_entry_date, eu_exit_date, schengen_implementation_date) 
    VALUES ('HR', 'HR', 'HRV', 'Hrvatska', 'Croatia', 'Republic of Croatia',
    '2013-07-01', '9999-12-31', NULL);
INSERT INTO t_eu_country (cceu, cc2, cc3, short_name, short_name_en, 
    official_name_en, eu_entry_date, eu_exit_date, schengen_implementation_date) 
    VALUES ('CH', 'CH', 'CHE', 'Switzerland', 'Switzerland', 'Swiss Confederation',
    '9999-12-31', '9999-12-31', '2008-12-12');
INSERT INTO t_eu_country (cceu, cc2, cc3, short_name, short_name_en, 
    official_name_en, eu_entry_date, eu_exit_date, schengen_implementation_date) 
    VALUES ('IS', 'IS', 'ISL', 'Ísland', 'Iceland', 'Republic of Iceland',
    '9999-12-31', '9999-12-31', '2001-03-25');
INSERT INTO t_eu_country (cceu, cc2, cc3, short_name, short_name_en, 
    official_name_en, eu_entry_date, eu_exit_date, schengen_implementation_date) 
    VALUES ('LI', 'LI', 'LIE', 'Liechtenstein', 'Liechtenstein', 
    'Principality of Liechtenstein',
    '9999-12-31', '9999-12-31', '2011-12-19');
INSERT INTO t_eu_country (cceu, cc2, cc3, short_name, short_name_en, 
    official_name_en, eu_entry_date, eu_exit_date, schengen_implementation_date) 
    VALUES ('NO', 'NO', 'NOR', 'Norge', 'Norway', 'Kingdom of Norway',
    '9999-12-31', '9999-12-31', '2001-03-25');

