X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=DOCS%2Fde%2Fcountry%2Fcountries-europe.sql;h=f520c5fee75ffcbc3fc2d37f6a7c1ed764a35d9f;hb=15e0995f7a4a4b2c9b1b1a9273f785cf13605829;hp=a1250b19ca539939730f6a844d9acde85d5b63cc;hpb=9a60a71dde1189e5c922a6dd377b862d08ea8f51;p=mailer.git diff --git a/DOCS/de/country/countries-europe.sql b/DOCS/de/country/countries-europe.sql index a1250b19ca..f520c5fee7 100644 --- a/DOCS/de/country/countries-europe.sql +++ b/DOCS/de/country/countries-europe.sql @@ -1,36 +1,36 @@ -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AT','Austria','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BA','Bosnia and Herzegovina','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BE','Belgium','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BG','Bulgaria','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CH','Switzerland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CZ','Czech Republic','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('DK','Denmark','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('EE','Estonia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ES','Spain','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('EU','European Union','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('FI','Finland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GB','United Kingdom','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GB','England','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GB','Great Britain','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GB','Scotland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GB','Channel Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GR','Greece','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('HR','Croatia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('HU','Hungary','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IE','Ireland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IF','Northern Ireland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IS','Iceland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IT','Italy','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LI','Liechtenstein','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LU','Luxembourg','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MC','Monaco','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NL','Netherlands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NO','Norway','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NZ','New Zealand','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PL','Poland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PT','Portugal','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('RO','Romania','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SE','Sweden','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SI','Slovenia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SK','Slovakia Slovak Rep.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TR','Turkey','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AT','Austria','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BA','Bosnia and Herzegovina','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BE','Belgium','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BG','Bulgaria','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CH','Switzerland','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CZ','Czech Republic','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('DK','Denmark','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('EE','Estonia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('ES','Spain','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('EU','European Union','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('FI','Finland','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GB','United Kingdom','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GB','England','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GB','Great Britain','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GB','Scotland','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GB','Channel Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GR','Greece','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('HR','Croatia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('HU','Hungary','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('IE','Ireland','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('IF','Northern Ireland','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('IS','Iceland','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('IT','Italy','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LI','Liechtenstein','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LU','Luxembourg','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MC','Monaco','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('NL','Netherlands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('NO','Norway','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('NZ','New Zealand','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PL','Poland','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PT','Portugal','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('RO','Romania','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SE','Sweden','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SI','Slovenia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SK','Slovakia Slovak Rep.','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TR','Turkey','Y');