From 36e9024f652b20497a1e79d9c67b3e2b56806c9c Mon Sep 17 00:00:00 2001 From: =?utf8?q?Roland=20H=C3=A4der?= Date: Sat, 24 Nov 2012 20:21:48 +0000 Subject: [PATCH] Added missing parameter which allows to add the SQL statements not just to 'install' SQL pool --- DOCS/de/README.txt | 2 +- DOCS/de/THANK_YOU.txt | 2 +- DOCS/de/TODO.txt | 2 +- DOCS/de/country/README.txt | 9 +- DOCS/de/country/countries-europe.sql | 72 +-- DOCS/de/country/countries-full.sql | 514 ++++++++++----------- DOCS/de/country/countries-sorted.sql | 514 ++++++++++----------- DOCS/en/TEMPLATES.txt | 2 +- DOCS/en/country/README.txt | 9 +- DOCS/en/country/countries-europe.sql | 72 +-- DOCS/en/country/countries-full.sql | 514 ++++++++++----------- DOCS/en/country/countries-sorted.sql | 514 ++++++++++----------- inc/install-functions.php | 2 +- inc/sql-functions.php | 6 +- templates/de/html/guest/guest_register.tpl | 21 +- 15 files changed, 1130 insertions(+), 1125 deletions(-) diff --git a/DOCS/de/README.txt b/DOCS/de/README.txt index b9832820ee..b3aec8e940 100644 --- a/DOCS/de/README.txt +++ b/DOCS/de/README.txt @@ -72,7 +72,7 @@ Die Installation ist recht einfach gehalten: - Entpacken Sie das heruntergeladene Archiv (zum Beispiel mit WinZIP) in ein Verzeichnis auf Ihrer Festplatte. Es wird dabei ein Verzeichnis namens - "mxchange-x.x.x" angelegt (wobei x.x.x die aktuelle Version ist). + "mailer-x.x.x" angelegt (wobei x.x.x die aktuelle Version ist). - Laden Sie den gesamten Inhalt des Verzeichnisses "0.2.1" hoch (die anderen Dateien werden nicht benoetigt.) Auch die SQL-Dateien im Hauptverzeichnis diff --git a/DOCS/de/THANK_YOU.txt b/DOCS/de/THANK_YOU.txt index 47336cf21f..642484ce79 100644 --- a/DOCS/de/THANK_YOU.txt +++ b/DOCS/de/THANK_YOU.txt @@ -57,4 +57,4 @@ Websites / Programmierer / etc.: Danke euch allen fuer die Unterstuetzung! -Roland Haeder (webmaster@mxchange.org) +Roland Haeder (webmaster [at] mxchange [dot] org) diff --git a/DOCS/de/TODO.txt b/DOCS/de/TODO.txt index 8196f91082..90915f1d46 100644 --- a/DOCS/de/TODO.txt +++ b/DOCS/de/TODO.txt @@ -10,7 +10,6 @@ - Alle @DEPRECATED entfernen, wo es geht und evtl. Ersatzcode finden --- OFFEN: --- -- Den gesamten HTML-Code auf XHTML portieren und mit http://validator.w3.org validieren - Alle JavaScripte aus den HTML-Templates umlagern und per js.php?tag=xxx aufrufen (bzw. nach js/ auslagern wenn keine Template-Variablen vorhanden sind) - Die Datenbankspalten ext_has_css nach ext_css und id nach ext_id umbenennen (Tabelle extensions) @@ -31,6 +30,7 @@ --- ERLEDIGT: (alte TODO) --- +- Den gesamten HTML-Code auf XHTML portieren und mit http://validator.w3.org validieren - Replace all HTTP_GET_VARS and HTTP_POST_VARS with _GET and _POST - Replace SQL_QUERY() command with SQL_QUERY_ESC() commands where ever it is needed to secure SQL queries. diff --git a/DOCS/de/country/README.txt b/DOCS/de/country/README.txt index 594751bc70..e8a89e41f3 100644 --- a/DOCS/de/country/README.txt +++ b/DOCS/de/country/README.txt @@ -12,9 +12,10 @@ von der Erweiterung selber mitgebracht wird. Hinweis: -Die Dateien wurden von Lothar Menges mir zur Verfuegung -gestellt, bei Fragen wegen der Laendernamen, fragen Sie bitte ihn und nicht -mich. Auch trotz sorgfaeltiger Pruefung koennen immer noch Fehler enthalten -sein. Danke! +Die Dateien wurden mir von Lothar Menges zur Verfuegung gestellt, bei Fragen +wegen der Laendernamen, fragen Sie bitte ihn und nicht mich. Auch trotz +sorgfaeltiger Pruefung koennen immer noch Fehler enthalten sein. + +Danke! [-- ENDE VON README.de --] 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'); diff --git a/DOCS/de/country/countries-full.sql b/DOCS/de/country/countries-full.sql index 6520114db7..621a9ee9da 100644 --- a/DOCS/de/country/countries-full.sql +++ b/DOCS/de/country/countries-full.sql @@ -1,257 +1,257 @@ -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AC','Ascension','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AD','Andorra','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AE','United Arab Emirates','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AF','Afghanistan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AG','Antigua and Barbuda','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AI','Anguilla','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AL','Albania','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AM','Armenia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AN','Netherlands Antilles','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AO','Angola','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AQ','Antarctica','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AR','Argentina','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AS','American Samoa','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AT','Austria','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AU','Australia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AW','Aruba','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AZ','Azerbaijan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BA','Bosnia and Herzegovina','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BB','Barbados','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BD','Bangladesh','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BE','Belgium','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BF','Burkina Faso','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BG','Bulgaria','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BH','Bahrain','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BI','Burundi','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BJ','Benin','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BM','Bermuda','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BN','Brunei Darussalam','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BO','Bolivia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BR','Brazil','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BS','Bahamas','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BT','Bhutan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BV','Bouvet','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BW','Botswana','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BY','Belarus','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BZ','Belize','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CA','Canada','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CC','Cocos','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CD','Congo Democratc Repuplic','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CF','Central African Republic','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CG','Congo Republic','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CH','Switzerland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CI','Cote D Ivoire','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CK','Cook Iland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CL','Chile','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CM','Cameroon','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CN','China','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CO','Colombia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CR','Costa Rica','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CS','Serbia and Montenegro','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CT','Canton and Enderbury','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CU','Cuba','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CV','Cape Verde','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CX','Christmas Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CY','Cyprus','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CZ','Czech Republic','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('DJ','Djibuti','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('DK','Denmark','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('DM','Dominica','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('DO','Dominican Republic','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('DZ','Algeria','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('EC','Ecuador','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('EE','Estonia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('EG','Egypt','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('EH','Western Sahara','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ER','Eritrea','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ES','Spain','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ET','Ethiopia','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 ('FJ','Fiji','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('FK','Falkland Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('FM','Micronesia Fed. S.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('FO','Faroe Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('FR','Frabce','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GA','Gabon','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 ('GD','Grenada','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GE','Georgia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GF','French Guiana','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GG','Guernsey','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GH','Ghana','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GI','Gibraltar','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GL','Greenland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GM','Gambia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GN','Guinea','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GP','Guadeloupe','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GQ','Guinea Equatorial','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GR','Greece','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GS','South Georgia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GT','Guatemala','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GU','Guam','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GW','Guinea-Bissau','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GY','Guyana','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('HK','Hong Kong','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('HM','Heard- and MC Donald Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('HN','Honduras','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('HR','Croatia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('HT','Haiti','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('HU','Hungary','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ID','Indonesia','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 ('IL','Israel','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IM','Isle of Man','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IN','India','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IO','British Indian O.T.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IQ','Iraq','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IR','Iran Islamic Republic','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 ('JE','Jersey Bailwick','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('JM','Jamaica','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('JO','Jordan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('JP','Japan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('JT','Johnston Atoll','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KE','Kenya','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KG','Kyrgyzstan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KH','Cambodia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KI','Kiribati','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KM','Comoros','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KN','Saint Kitts and Nevis','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KP','Korea Democratic P. Rep.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KR','Korea Republic','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KW','Kuwait','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KY','Cayman Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KZ','Kazakhstan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LA','Lao People Democratic Rep.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LB','Lebanon','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LC','St. Lucia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LI','Liechtenstein','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LK','Sri Lanka','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LR','Liberia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LS','Lesotho','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LT','Lithuania','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LU','Luxembourg','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LV','Latvia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LY','Libyan Arab Jamahiriya','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MA','Morocco','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MC','Monaco','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MD','Moldova Rep.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MG','Madagascar','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MH','Marshall Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MI','Midway Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MK','Macedonia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ML','Mali','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MM','Myanmar','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MN','Mongolia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MO','Macau','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MP','Northern Mariana Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MQ','Martinique','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MR','Mauritania','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MS','Montserat','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MT','Malta','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MU','Mauritius','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MV','Maldives','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MW','Malawi','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MX','Mexico','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MY','Malaysia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MZ','Mozambique','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NA','Namibia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NC','New Caledonia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NE','Niger','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NF','Norfolk Iland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NG','Nigeria','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NI','Nicaragua','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 ('NP','Nepal','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NQ','Dronning Mauds Land','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NR','Nauru','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NU','Niue','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NZ','New Zealand','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('OM','Oman','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PA','Panama','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PE','Peru','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PF','French Polynesia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PG','Papua New Guinea','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PH','Philippines','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PK','Parkistan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PL','Poland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PM','St. Pierre and Miquelon','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PN','Pitcairn Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PR','Puerto Rico','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PS','Palestian Authority','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PS','Gaza Strip','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PS','West Bank','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PT','Portugal','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PW','Palau','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PY','Paraguay','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('QA','Qatar','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('RE','Reunion','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('RO','Romania','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('RU','Russian Federation','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('RW','Rwanda','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SA','Saudi Arabia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SB','Solomon Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SC','Seychelles','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SD','Sudan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SE','Sweden','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SG','Singapore','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SH','St. Helena','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SI','Slovenia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SJ','Svalbard and Jan Mayen','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SK','Slovakia Slovak Rep.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SL','Sierra Leone','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SM','San Marino','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SN','Senegal','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SO','Somalia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SR','Suriname','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ST','Sao Tome and Principe','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SV','El Salvador','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SY','Syrian Arab Rep.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SZ','Swaziland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TA','Tahiti','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TC','Turks and Caicos Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TD','Chad','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TF','French Southern Ter.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TG','Togo','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TH','Thailand','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TJ','Tajikistan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TK','Ttokelau','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TM','Turkmenistan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TN','Tunisia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TO','Tonga','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TP','East Timor','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TR','Turkey','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TT','Trinidad and Tobago','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TV','Tuvalu','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TW','Taiwan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TZ','Tanzania U. Rep.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('UA','Ukraine','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('UG','Uganda','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('UM','U.S. Minor Outlying Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('US','United States','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('UY','Uruguay','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('UZ','Uzbekistan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VA','Vatican City State','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VA','Holy See','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VC','St. Vincent and Grenadines','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VE','Venezuela','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VG','Virgin Iland (British)','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VI','Virgin Iland (U.S.)','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VN','Viet Nam','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VU','Vanuatu','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('WF','Wallis anf Futuna Iland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('WK','Wake Iland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('WS','Samoa West','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('YE','Yemen','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('YT','Mayotte','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ZA','South Africa','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ZM','Zambia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ZW','Zimbabwe','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AC','Ascension','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AD','Andorra','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AE','United Arab Emirates','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AF','Afghanistan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AG','Antigua and Barbuda','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AI','Anguilla','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AL','Albania','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AM','Armenia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AN','Netherlands Antilles','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AO','Angola','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AQ','Antarctica','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AR','Argentina','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AS','American Samoa','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AT','Austria','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AU','Australia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AW','Aruba','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AZ','Azerbaijan','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 ('BB','Barbados','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BD','Bangladesh','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BE','Belgium','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BF','Burkina Faso','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BG','Bulgaria','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BH','Bahrain','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BI','Burundi','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BJ','Benin','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BM','Bermuda','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BN','Brunei Darussalam','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BO','Bolivia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BR','Brazil','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BS','Bahamas','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BT','Bhutan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BV','Bouvet','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BW','Botswana','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BY','Belarus','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BZ','Belize','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CA','Canada','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CC','Cocos','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CD','Congo Democratc Repuplic','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CF','Central African Republic','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CG','Congo Republic','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CH','Switzerland','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CI','Cote D Ivoire','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CK','Cook Iland','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CL','Chile','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CM','Cameroon','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CN','China','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CO','Colombia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CR','Costa Rica','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CS','Serbia and Montenegro','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CT','Canton and Enderbury','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CU','Cuba','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CV','Cape Verde','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CX','Christmas Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CY','Cyprus','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 ('DJ','Djibuti','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('DK','Denmark','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('DM','Dominica','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('DO','Dominican Republic','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('DZ','Algeria','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('EC','Ecuador','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('EE','Estonia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('EG','Egypt','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('EH','Western Sahara','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('ER','Eritrea','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('ES','Spain','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('ET','Ethiopia','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 ('FJ','Fiji','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('FK','Falkland Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('FM','Micronesia Fed. S.','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('FO','Faroe Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('FR','Frabce','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GA','Gabon','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 ('GD','Grenada','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GE','Georgia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GF','French Guiana','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GG','Guernsey','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GH','Ghana','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GI','Gibraltar','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GL','Greenland','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GM','Gambia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GN','Guinea','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GP','Guadeloupe','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GQ','Guinea Equatorial','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GR','Greece','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GS','South Georgia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GT','Guatemala','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GU','Guam','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GW','Guinea-Bissau','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GY','Guyana','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('HK','Hong Kong','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('HM','Heard- and MC Donald Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('HN','Honduras','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('HR','Croatia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('HT','Haiti','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('HU','Hungary','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('ID','Indonesia','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 ('IL','Israel','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('IM','Isle of Man','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('IN','India','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('IO','British Indian O.T.','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('IQ','Iraq','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('IR','Iran Islamic Republic','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 ('JE','Jersey Bailwick','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('JM','Jamaica','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('JO','Jordan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('JP','Japan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('JT','Johnston Atoll','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KE','Kenya','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KG','Kyrgyzstan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KH','Cambodia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KI','Kiribati','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KM','Comoros','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KN','Saint Kitts and Nevis','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KP','Korea Democratic P. Rep.','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KR','Korea Republic','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KW','Kuwait','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KY','Cayman Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KZ','Kazakhstan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LA','Lao People Democratic Rep.','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LB','Lebanon','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LC','St. Lucia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LI','Liechtenstein','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LK','Sri Lanka','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LR','Liberia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LS','Lesotho','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LT','Lithuania','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LU','Luxembourg','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LV','Latvia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LY','Libyan Arab Jamahiriya','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MA','Morocco','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MC','Monaco','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MD','Moldova Rep.','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MG','Madagascar','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MH','Marshall Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MI','Midway Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MK','Macedonia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('ML','Mali','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MM','Myanmar','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MN','Mongolia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MO','Macau','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MP','Northern Mariana Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MQ','Martinique','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MR','Mauritania','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MS','Montserat','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MT','Malta','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MU','Mauritius','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MV','Maldives','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MW','Malawi','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MX','Mexico','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MY','Malaysia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MZ','Mozambique','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('NA','Namibia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('NC','New Caledonia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('NE','Niger','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('NF','Norfolk Iland','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('NG','Nigeria','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('NI','Nicaragua','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 ('NP','Nepal','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('NQ','Dronning Mauds Land','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('NR','Nauru','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('NU','Niue','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 ('OM','Oman','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PA','Panama','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PE','Peru','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PF','French Polynesia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PG','Papua New Guinea','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PH','Philippines','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PK','Parkistan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PL','Poland','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PM','St. Pierre and Miquelon','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PN','Pitcairn Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PR','Puerto Rico','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PS','Palestian Authority','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PS','Gaza Strip','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PS','West Bank','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PT','Portugal','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PW','Palau','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PY','Paraguay','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('QA','Qatar','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('RE','Reunion','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('RO','Romania','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('RU','Russian Federation','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('RW','Rwanda','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SA','Saudi Arabia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SB','Solomon Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SC','Seychelles','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SD','Sudan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SE','Sweden','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SG','Singapore','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SH','St. Helena','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SI','Slovenia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SJ','Svalbard and Jan Mayen','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 ('SL','Sierra Leone','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SM','San Marino','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SN','Senegal','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SO','Somalia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SR','Suriname','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('ST','Sao Tome and Principe','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SV','El Salvador','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SY','Syrian Arab Rep.','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SZ','Swaziland','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TA','Tahiti','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TC','Turks and Caicos Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TD','Chad','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TF','French Southern Ter.','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TG','Togo','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TH','Thailand','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TJ','Tajikistan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TK','Ttokelau','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TM','Turkmenistan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TN','Tunisia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TO','Tonga','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TP','East Timor','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TR','Turkey','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TT','Trinidad and Tobago','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TV','Tuvalu','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TW','Taiwan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TZ','Tanzania U. Rep.','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('UA','Ukraine','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('UG','Uganda','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('UM','U.S. Minor Outlying Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('US','United States','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('UY','Uruguay','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('UZ','Uzbekistan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('VA','Vatican City State','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('VA','Holy See','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('VC','St. Vincent and Grenadines','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('VE','Venezuela','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('VG','Virgin Iland (British)','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('VI','Virgin Iland (U.S.)','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('VN','Viet Nam','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('VU','Vanuatu','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('WF','Wallis anf Futuna Iland','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('WK','Wake Iland','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('WS','Samoa West','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('YE','Yemen','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('YT','Mayotte','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('ZA','South Africa','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('ZM','Zambia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('ZW','Zimbabwe','Y'); diff --git a/DOCS/de/country/countries-sorted.sql b/DOCS/de/country/countries-sorted.sql index 6b3a5266c0..f9673ecc69 100644 --- a/DOCS/de/country/countries-sorted.sql +++ b/DOCS/de/country/countries-sorted.sql @@ -1,257 +1,257 @@ -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AT','Austria','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BE','Belgium','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CH','Switzerland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CR','Costa Rica','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 ('ES','Spain','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('FI','Finland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('FR','Frabce','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 ('PL','Poland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('RO','Romania','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('RU','Russian Federation','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 `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AC','Ascension','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AD','Andorra','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AE','United Arab Emirates','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AF','Afghanistan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AG','Antigua and Barbuda','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AI','Anguilla','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AL','Albania','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AM','Armenia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AN','Netherlands Antilles','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AO','Angola','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AQ','Antarctica','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AR','Argentina','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AS','American Samoa','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AU','Australia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AW','Aruba','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AZ','Azerbaijan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BA','Bosnia and Herzegovina','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BB','Barbados','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BD','Bangladesh','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BF','Burkina Faso','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BG','Bulgaria','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BH','Bahrain','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BI','Burundi','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BJ','Benin','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BM','Bermuda','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BN','Brunei Darussalam','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BO','Bolivia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BR','Brazil','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BS','Bahamas','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BT','Bhutan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BV','Bouvet','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BW','Botswana','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BY','Belarus','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BZ','Belize','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CA','Canada','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CC','Cocos','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CD','Congo Democratc Repuplic','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CF','Central African Republic','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CG','Congo Republic','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CI','Cote D Ivoire','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CK','Cook Iland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CL','Chile','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CM','Cameroon','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CN','China','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CO','Colombia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CS','Serbia and Montenegro','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CT','Canton and Enderbury','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CU','Cuba','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CV','Cape Verde','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CX','Christmas Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CY','Cyprus','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('DJ','Djibuti','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('DM','Dominica','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('DO','Dominican Republic','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('DZ','Algeria','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('EC','Ecuador','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('EE','Estonia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('EG','Egypt','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('EH','Western Sahara','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ER','Eritrea','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ET','Ethiopia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('EU','European Union','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('FJ','Fiji','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('FK','Falkland Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('FM','Micronesia Fed. S.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('FO','Faroe Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GA','Gabon','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GD','Grenada','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GE','Georgia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GF','French Guiana','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GG','Guernsey','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GH','Ghana','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GI','Gibraltar','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GL','Greenland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GM','Gambia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GN','Guinea','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GP','Guadeloupe','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GQ','Guinea Equatorial','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GS','South Georgia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GT','Guatemala','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GU','Guam','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GW','Guinea-Bissau','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GY','Guyana','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('HK','Hong Kong','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('HM','Heard- and MC Donald Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('HN','Honduras','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('HT','Haiti','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ID','Indonesia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IL','Israel','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IM','Isle of Man','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IN','India','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IO','British Indian O.T.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IQ','Iraq','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IR','Iran Islamic Republic','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('JE','Jersey Bailwick','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('JM','Jamaica','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('JO','Jordan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('JP','Japan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('JT','Johnston Atoll','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KE','Kenya','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KG','Kyrgyzstan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KH','Cambodia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KI','Kiribati','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KM','Comoros','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KN','Saint Kitts and Nevis','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KP','Korea Democratic P. Rep.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KR','Korea Republic','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KW','Kuwait','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KY','Cayman Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KZ','Kazakhstan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LA','Lao People Democratic Rep.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LB','Lebanon','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LC','St. Lucia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LK','Sri Lanka','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LR','Liberia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LS','Lesotho','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LT','Lithuania','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LV','Latvia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LY','Libyan Arab Jamahiriya','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MA','Morocco','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MD','Moldova Rep.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MG','Madagascar','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MH','Marshall Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MI','Midway Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MK','Macedonia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ML','Mali','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MM','Myanmar','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MN','Mongolia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MO','Macau','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MP','Northern Mariana Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MQ','Martinique','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MR','Mauritania','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MS','Montserat','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MT','Malta','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MU','Mauritius','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MV','Maldives','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MW','Malawi','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MX','Mexico','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MY','Malaysia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MZ','Mozambique','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NA','Namibia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NC','New Caledonia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NE','Niger','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NF','Norfolk Iland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NG','Nigeria','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NI','Nicaragua','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NP','Nepal','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NQ','Dronning Mauds Land','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NR','Nauru','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NU','Niue','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NZ','New Zealand','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('OM','Oman','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PA','Panama','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PE','Peru','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PF','French Polynesia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PG','Papua New Guinea','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PH','Philippines','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PK','Parkistan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PM','St. Pierre and Miquelon','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PN','Pitcairn Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PR','Puerto Rico','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PS','Palestian Authority','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PS','Gaza Strip','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PS','West Bank','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PT','Portugal','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PW','Palau','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PY','Paraguay','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('QA','Qatar','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('RE','Reunion','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('RW','Rwanda','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SA','Saudi Arabia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SB','Solomon Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SC','Seychelles','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SD','Sudan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SG','Singapore','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SH','St. Helena','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SJ','Svalbard and Jan Mayen','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SL','Sierra Leone','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SM','San Marino','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SN','Senegal','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SO','Somalia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SR','Suriname','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ST','Sao Tome and Principe','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SV','El Salvador','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SY','Syrian Arab Rep.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SZ','Swaziland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TA','Tahiti','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TC','Turks and Caicos Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TD','Chad','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TF','French Southern Ter.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TG','Togo','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TH','Thailand','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TJ','Tajikistan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TK','Ttokelau','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TM','Turkmenistan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TN','Tunisia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TO','Tonga','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TP','East Timor','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TT','Trinidad and Tobago','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TV','Tuvalu','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TW','Taiwan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TZ','Tanzania U. Rep.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('UA','Ukraine','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('UG','Uganda','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('UM','U.S. Minor Outlying Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('US','United States','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('UY','Uruguay','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('UZ','Uzbekistan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VA','Vatican City State','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VA','Holy See','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VC','St. Vincent and Grenadines','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VE','Venezuela','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VG','Virgin Iland (British)','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VI','Virgin Iland (U.S.)','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VN','Viet Nam','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VU','Vanuatu','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('WF','Wallis anf Futuna Iland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('WK','Wake Iland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('WS','Samoa West','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('YE','Yemen','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('YT','Mayotte','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ZA','South Africa','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ZM','Zambia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ZW','Zimbabwe','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AT','Austria','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BE','Belgium','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CH','Switzerland','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CR','Costa Rica','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 ('ES','Spain','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('FI','Finland','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('FR','Frabce','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 ('PL','Poland','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('RO','Romania','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('RU','Russian Federation','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'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AC','Ascension','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AD','Andorra','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AE','United Arab Emirates','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AF','Afghanistan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AG','Antigua and Barbuda','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AI','Anguilla','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AL','Albania','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AM','Armenia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AN','Netherlands Antilles','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AO','Angola','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AQ','Antarctica','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AR','Argentina','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AS','American Samoa','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AU','Australia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AW','Aruba','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AZ','Azerbaijan','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 ('BB','Barbados','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BD','Bangladesh','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BF','Burkina Faso','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BG','Bulgaria','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BH','Bahrain','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BI','Burundi','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BJ','Benin','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BM','Bermuda','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BN','Brunei Darussalam','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BO','Bolivia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BR','Brazil','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BS','Bahamas','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BT','Bhutan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BV','Bouvet','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BW','Botswana','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BY','Belarus','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BZ','Belize','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CA','Canada','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CC','Cocos','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CD','Congo Democratc Repuplic','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CF','Central African Republic','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CG','Congo Republic','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CI','Cote D Ivoire','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CK','Cook Iland','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CL','Chile','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CM','Cameroon','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CN','China','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CO','Colombia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CS','Serbia and Montenegro','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CT','Canton and Enderbury','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CU','Cuba','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CV','Cape Verde','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CX','Christmas Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CY','Cyprus','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('DJ','Djibuti','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('DM','Dominica','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('DO','Dominican Republic','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('DZ','Algeria','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('EC','Ecuador','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('EE','Estonia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('EG','Egypt','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('EH','Western Sahara','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('ER','Eritrea','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('ET','Ethiopia','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 ('FJ','Fiji','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('FK','Falkland Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('FM','Micronesia Fed. S.','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('FO','Faroe Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GA','Gabon','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GD','Grenada','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GE','Georgia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GF','French Guiana','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GG','Guernsey','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GH','Ghana','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GI','Gibraltar','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GL','Greenland','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GM','Gambia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GN','Guinea','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GP','Guadeloupe','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GQ','Guinea Equatorial','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GS','South Georgia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GT','Guatemala','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GU','Guam','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GW','Guinea-Bissau','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GY','Guyana','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('HK','Hong Kong','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('HM','Heard- and MC Donald Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('HN','Honduras','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('HT','Haiti','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('ID','Indonesia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('IL','Israel','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('IM','Isle of Man','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('IN','India','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('IO','British Indian O.T.','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('IQ','Iraq','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('IR','Iran Islamic Republic','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('JE','Jersey Bailwick','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('JM','Jamaica','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('JO','Jordan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('JP','Japan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('JT','Johnston Atoll','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KE','Kenya','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KG','Kyrgyzstan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KH','Cambodia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KI','Kiribati','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KM','Comoros','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KN','Saint Kitts and Nevis','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KP','Korea Democratic P. Rep.','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KR','Korea Republic','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KW','Kuwait','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KY','Cayman Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KZ','Kazakhstan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LA','Lao People Democratic Rep.','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LB','Lebanon','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LC','St. Lucia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LK','Sri Lanka','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LR','Liberia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LS','Lesotho','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LT','Lithuania','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LV','Latvia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LY','Libyan Arab Jamahiriya','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MA','Morocco','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MD','Moldova Rep.','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MG','Madagascar','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MH','Marshall Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MI','Midway Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MK','Macedonia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('ML','Mali','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MM','Myanmar','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MN','Mongolia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MO','Macau','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MP','Northern Mariana Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MQ','Martinique','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MR','Mauritania','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MS','Montserat','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MT','Malta','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MU','Mauritius','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MV','Maldives','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MW','Malawi','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MX','Mexico','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MY','Malaysia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MZ','Mozambique','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('NA','Namibia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('NC','New Caledonia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('NE','Niger','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('NF','Norfolk Iland','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('NG','Nigeria','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('NI','Nicaragua','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('NP','Nepal','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('NQ','Dronning Mauds Land','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('NR','Nauru','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('NU','Niue','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 ('OM','Oman','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PA','Panama','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PE','Peru','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PF','French Polynesia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PG','Papua New Guinea','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PH','Philippines','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PK','Parkistan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PM','St. Pierre and Miquelon','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PN','Pitcairn Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PR','Puerto Rico','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PS','Palestian Authority','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PS','Gaza Strip','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PS','West Bank','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PT','Portugal','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PW','Palau','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PY','Paraguay','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('QA','Qatar','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('RE','Reunion','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('RW','Rwanda','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SA','Saudi Arabia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SB','Solomon Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SC','Seychelles','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SD','Sudan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SG','Singapore','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SH','St. Helena','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SJ','Svalbard and Jan Mayen','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SL','Sierra Leone','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SM','San Marino','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SN','Senegal','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SO','Somalia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SR','Suriname','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('ST','Sao Tome and Principe','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SV','El Salvador','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SY','Syrian Arab Rep.','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SZ','Swaziland','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TA','Tahiti','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TC','Turks and Caicos Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TD','Chad','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TF','French Southern Ter.','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TG','Togo','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TH','Thailand','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TJ','Tajikistan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TK','Ttokelau','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TM','Turkmenistan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TN','Tunisia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TO','Tonga','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TP','East Timor','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TT','Trinidad and Tobago','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TV','Tuvalu','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TW','Taiwan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TZ','Tanzania U. Rep.','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('UA','Ukraine','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('UG','Uganda','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('UM','U.S. Minor Outlying Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('US','United States','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('UY','Uruguay','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('UZ','Uzbekistan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('VA','Vatican City State','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('VA','Holy See','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('VC','St. Vincent and Grenadines','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('VE','Venezuela','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('VG','Virgin Iland (British)','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('VI','Virgin Iland (U.S.)','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('VN','Viet Nam','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('VU','Vanuatu','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('WF','Wallis anf Futuna Iland','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('WK','Wake Iland','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('WS','Samoa West','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('YE','Yemen','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('YT','Mayotte','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('ZA','South Africa','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('ZM','Zambia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('ZW','Zimbabwe','Y'); diff --git a/DOCS/en/TEMPLATES.txt b/DOCS/en/TEMPLATES.txt index 36843c37dd..abdcafb745 100644 --- a/DOCS/en/TEMPLATES.txt +++ b/DOCS/en/TEMPLATES.txt @@ -60,7 +60,7 @@ Wenn Sie eine aeltere Version als v0.2.0-pre4 besitzen, so koennen Sie gerne das gesamte templates-Verzeichnis (inklusive emails-Verzeichnis) an mich senden und ich wandle dann die Dateinamen um. -Verwenden Sie dazu einfach diese Adresse: webmaster@mxchange.org +Verwenden Sie dazu einfach diese Adresse: webmaster [at] mxchange [dot] org Da ich hier einfach alles enpacke und nur kurz ein Shell-Script starte, kostet diese Umwandlung Ihnen nichts. Selbstverstaendlich gebe ich Ihre Aenderungen diff --git a/DOCS/en/country/README.txt b/DOCS/en/country/README.txt index 24e4f79acb..018ee88125 100644 --- a/DOCS/en/country/README.txt +++ b/DOCS/en/country/README.txt @@ -12,9 +12,10 @@ von der Erweiterung selber mitgebracht wird. Hinweis: -Die Dateien wurden von Lothar Menges mir zur Verfuegung -gestellt, bei Fragen wegen der Laendernamen, fragen Sie bitte ihn und nicht -mich. Auch trotz sorgfaeltiger Pruefung koennen immer noch Fehler enthalten -sein. Danke! +Die Dateien wurden mir von Lothar Menges zur Verfuegung gestellt, bei Fragen +wegen der Laendernamen, fragen Sie bitte ihn und nicht mich. Auch trotz +sorgfaeltiger Pruefung koennen immer noch Fehler enthalten sein. + +Danke! [-- ENDE VON README.de --] diff --git a/DOCS/en/country/countries-europe.sql b/DOCS/en/country/countries-europe.sql index a1250b19ca..f520c5fee7 100644 --- a/DOCS/en/country/countries-europe.sql +++ b/DOCS/en/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'); diff --git a/DOCS/en/country/countries-full.sql b/DOCS/en/country/countries-full.sql index 6520114db7..621a9ee9da 100644 --- a/DOCS/en/country/countries-full.sql +++ b/DOCS/en/country/countries-full.sql @@ -1,257 +1,257 @@ -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AC','Ascension','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AD','Andorra','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AE','United Arab Emirates','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AF','Afghanistan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AG','Antigua and Barbuda','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AI','Anguilla','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AL','Albania','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AM','Armenia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AN','Netherlands Antilles','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AO','Angola','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AQ','Antarctica','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AR','Argentina','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AS','American Samoa','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AT','Austria','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AU','Australia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AW','Aruba','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AZ','Azerbaijan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BA','Bosnia and Herzegovina','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BB','Barbados','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BD','Bangladesh','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BE','Belgium','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BF','Burkina Faso','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BG','Bulgaria','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BH','Bahrain','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BI','Burundi','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BJ','Benin','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BM','Bermuda','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BN','Brunei Darussalam','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BO','Bolivia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BR','Brazil','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BS','Bahamas','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BT','Bhutan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BV','Bouvet','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BW','Botswana','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BY','Belarus','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BZ','Belize','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CA','Canada','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CC','Cocos','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CD','Congo Democratc Repuplic','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CF','Central African Republic','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CG','Congo Republic','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CH','Switzerland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CI','Cote D Ivoire','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CK','Cook Iland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CL','Chile','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CM','Cameroon','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CN','China','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CO','Colombia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CR','Costa Rica','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CS','Serbia and Montenegro','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CT','Canton and Enderbury','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CU','Cuba','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CV','Cape Verde','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CX','Christmas Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CY','Cyprus','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CZ','Czech Republic','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('DJ','Djibuti','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('DK','Denmark','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('DM','Dominica','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('DO','Dominican Republic','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('DZ','Algeria','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('EC','Ecuador','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('EE','Estonia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('EG','Egypt','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('EH','Western Sahara','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ER','Eritrea','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ES','Spain','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ET','Ethiopia','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 ('FJ','Fiji','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('FK','Falkland Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('FM','Micronesia Fed. S.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('FO','Faroe Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('FR','Frabce','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GA','Gabon','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 ('GD','Grenada','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GE','Georgia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GF','French Guiana','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GG','Guernsey','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GH','Ghana','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GI','Gibraltar','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GL','Greenland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GM','Gambia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GN','Guinea','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GP','Guadeloupe','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GQ','Guinea Equatorial','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GR','Greece','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GS','South Georgia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GT','Guatemala','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GU','Guam','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GW','Guinea-Bissau','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GY','Guyana','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('HK','Hong Kong','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('HM','Heard- and MC Donald Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('HN','Honduras','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('HR','Croatia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('HT','Haiti','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('HU','Hungary','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ID','Indonesia','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 ('IL','Israel','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IM','Isle of Man','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IN','India','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IO','British Indian O.T.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IQ','Iraq','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IR','Iran Islamic Republic','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 ('JE','Jersey Bailwick','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('JM','Jamaica','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('JO','Jordan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('JP','Japan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('JT','Johnston Atoll','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KE','Kenya','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KG','Kyrgyzstan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KH','Cambodia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KI','Kiribati','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KM','Comoros','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KN','Saint Kitts and Nevis','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KP','Korea Democratic P. Rep.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KR','Korea Republic','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KW','Kuwait','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KY','Cayman Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KZ','Kazakhstan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LA','Lao People Democratic Rep.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LB','Lebanon','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LC','St. Lucia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LI','Liechtenstein','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LK','Sri Lanka','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LR','Liberia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LS','Lesotho','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LT','Lithuania','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LU','Luxembourg','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LV','Latvia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LY','Libyan Arab Jamahiriya','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MA','Morocco','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MC','Monaco','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MD','Moldova Rep.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MG','Madagascar','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MH','Marshall Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MI','Midway Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MK','Macedonia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ML','Mali','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MM','Myanmar','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MN','Mongolia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MO','Macau','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MP','Northern Mariana Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MQ','Martinique','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MR','Mauritania','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MS','Montserat','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MT','Malta','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MU','Mauritius','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MV','Maldives','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MW','Malawi','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MX','Mexico','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MY','Malaysia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MZ','Mozambique','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NA','Namibia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NC','New Caledonia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NE','Niger','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NF','Norfolk Iland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NG','Nigeria','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NI','Nicaragua','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 ('NP','Nepal','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NQ','Dronning Mauds Land','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NR','Nauru','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NU','Niue','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NZ','New Zealand','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('OM','Oman','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PA','Panama','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PE','Peru','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PF','French Polynesia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PG','Papua New Guinea','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PH','Philippines','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PK','Parkistan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PL','Poland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PM','St. Pierre and Miquelon','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PN','Pitcairn Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PR','Puerto Rico','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PS','Palestian Authority','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PS','Gaza Strip','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PS','West Bank','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PT','Portugal','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PW','Palau','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PY','Paraguay','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('QA','Qatar','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('RE','Reunion','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('RO','Romania','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('RU','Russian Federation','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('RW','Rwanda','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SA','Saudi Arabia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SB','Solomon Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SC','Seychelles','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SD','Sudan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SE','Sweden','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SG','Singapore','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SH','St. Helena','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SI','Slovenia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SJ','Svalbard and Jan Mayen','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SK','Slovakia Slovak Rep.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SL','Sierra Leone','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SM','San Marino','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SN','Senegal','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SO','Somalia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SR','Suriname','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ST','Sao Tome and Principe','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SV','El Salvador','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SY','Syrian Arab Rep.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SZ','Swaziland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TA','Tahiti','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TC','Turks and Caicos Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TD','Chad','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TF','French Southern Ter.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TG','Togo','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TH','Thailand','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TJ','Tajikistan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TK','Ttokelau','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TM','Turkmenistan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TN','Tunisia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TO','Tonga','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TP','East Timor','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TR','Turkey','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TT','Trinidad and Tobago','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TV','Tuvalu','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TW','Taiwan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TZ','Tanzania U. Rep.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('UA','Ukraine','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('UG','Uganda','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('UM','U.S. Minor Outlying Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('US','United States','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('UY','Uruguay','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('UZ','Uzbekistan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VA','Vatican City State','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VA','Holy See','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VC','St. Vincent and Grenadines','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VE','Venezuela','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VG','Virgin Iland (British)','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VI','Virgin Iland (U.S.)','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VN','Viet Nam','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VU','Vanuatu','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('WF','Wallis anf Futuna Iland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('WK','Wake Iland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('WS','Samoa West','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('YE','Yemen','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('YT','Mayotte','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ZA','South Africa','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ZM','Zambia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ZW','Zimbabwe','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AC','Ascension','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AD','Andorra','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AE','United Arab Emirates','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AF','Afghanistan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AG','Antigua and Barbuda','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AI','Anguilla','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AL','Albania','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AM','Armenia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AN','Netherlands Antilles','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AO','Angola','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AQ','Antarctica','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AR','Argentina','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AS','American Samoa','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AT','Austria','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AU','Australia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AW','Aruba','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AZ','Azerbaijan','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 ('BB','Barbados','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BD','Bangladesh','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BE','Belgium','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BF','Burkina Faso','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BG','Bulgaria','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BH','Bahrain','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BI','Burundi','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BJ','Benin','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BM','Bermuda','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BN','Brunei Darussalam','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BO','Bolivia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BR','Brazil','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BS','Bahamas','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BT','Bhutan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BV','Bouvet','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BW','Botswana','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BY','Belarus','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BZ','Belize','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CA','Canada','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CC','Cocos','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CD','Congo Democratc Repuplic','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CF','Central African Republic','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CG','Congo Republic','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CH','Switzerland','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CI','Cote D Ivoire','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CK','Cook Iland','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CL','Chile','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CM','Cameroon','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CN','China','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CO','Colombia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CR','Costa Rica','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CS','Serbia and Montenegro','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CT','Canton and Enderbury','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CU','Cuba','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CV','Cape Verde','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CX','Christmas Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CY','Cyprus','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 ('DJ','Djibuti','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('DK','Denmark','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('DM','Dominica','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('DO','Dominican Republic','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('DZ','Algeria','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('EC','Ecuador','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('EE','Estonia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('EG','Egypt','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('EH','Western Sahara','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('ER','Eritrea','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('ES','Spain','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('ET','Ethiopia','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 ('FJ','Fiji','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('FK','Falkland Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('FM','Micronesia Fed. S.','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('FO','Faroe Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('FR','Frabce','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GA','Gabon','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 ('GD','Grenada','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GE','Georgia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GF','French Guiana','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GG','Guernsey','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GH','Ghana','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GI','Gibraltar','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GL','Greenland','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GM','Gambia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GN','Guinea','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GP','Guadeloupe','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GQ','Guinea Equatorial','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GR','Greece','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GS','South Georgia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GT','Guatemala','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GU','Guam','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GW','Guinea-Bissau','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GY','Guyana','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('HK','Hong Kong','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('HM','Heard- and MC Donald Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('HN','Honduras','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('HR','Croatia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('HT','Haiti','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('HU','Hungary','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('ID','Indonesia','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 ('IL','Israel','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('IM','Isle of Man','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('IN','India','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('IO','British Indian O.T.','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('IQ','Iraq','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('IR','Iran Islamic Republic','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 ('JE','Jersey Bailwick','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('JM','Jamaica','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('JO','Jordan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('JP','Japan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('JT','Johnston Atoll','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KE','Kenya','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KG','Kyrgyzstan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KH','Cambodia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KI','Kiribati','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KM','Comoros','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KN','Saint Kitts and Nevis','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KP','Korea Democratic P. Rep.','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KR','Korea Republic','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KW','Kuwait','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KY','Cayman Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KZ','Kazakhstan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LA','Lao People Democratic Rep.','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LB','Lebanon','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LC','St. Lucia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LI','Liechtenstein','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LK','Sri Lanka','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LR','Liberia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LS','Lesotho','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LT','Lithuania','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LU','Luxembourg','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LV','Latvia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LY','Libyan Arab Jamahiriya','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MA','Morocco','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MC','Monaco','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MD','Moldova Rep.','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MG','Madagascar','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MH','Marshall Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MI','Midway Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MK','Macedonia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('ML','Mali','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MM','Myanmar','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MN','Mongolia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MO','Macau','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MP','Northern Mariana Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MQ','Martinique','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MR','Mauritania','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MS','Montserat','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MT','Malta','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MU','Mauritius','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MV','Maldives','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MW','Malawi','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MX','Mexico','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MY','Malaysia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MZ','Mozambique','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('NA','Namibia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('NC','New Caledonia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('NE','Niger','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('NF','Norfolk Iland','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('NG','Nigeria','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('NI','Nicaragua','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 ('NP','Nepal','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('NQ','Dronning Mauds Land','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('NR','Nauru','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('NU','Niue','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 ('OM','Oman','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PA','Panama','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PE','Peru','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PF','French Polynesia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PG','Papua New Guinea','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PH','Philippines','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PK','Parkistan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PL','Poland','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PM','St. Pierre and Miquelon','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PN','Pitcairn Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PR','Puerto Rico','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PS','Palestian Authority','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PS','Gaza Strip','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PS','West Bank','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PT','Portugal','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PW','Palau','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PY','Paraguay','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('QA','Qatar','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('RE','Reunion','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('RO','Romania','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('RU','Russian Federation','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('RW','Rwanda','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SA','Saudi Arabia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SB','Solomon Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SC','Seychelles','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SD','Sudan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SE','Sweden','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SG','Singapore','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SH','St. Helena','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SI','Slovenia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SJ','Svalbard and Jan Mayen','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 ('SL','Sierra Leone','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SM','San Marino','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SN','Senegal','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SO','Somalia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SR','Suriname','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('ST','Sao Tome and Principe','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SV','El Salvador','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SY','Syrian Arab Rep.','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SZ','Swaziland','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TA','Tahiti','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TC','Turks and Caicos Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TD','Chad','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TF','French Southern Ter.','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TG','Togo','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TH','Thailand','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TJ','Tajikistan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TK','Ttokelau','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TM','Turkmenistan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TN','Tunisia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TO','Tonga','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TP','East Timor','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TR','Turkey','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TT','Trinidad and Tobago','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TV','Tuvalu','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TW','Taiwan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TZ','Tanzania U. Rep.','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('UA','Ukraine','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('UG','Uganda','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('UM','U.S. Minor Outlying Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('US','United States','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('UY','Uruguay','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('UZ','Uzbekistan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('VA','Vatican City State','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('VA','Holy See','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('VC','St. Vincent and Grenadines','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('VE','Venezuela','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('VG','Virgin Iland (British)','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('VI','Virgin Iland (U.S.)','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('VN','Viet Nam','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('VU','Vanuatu','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('WF','Wallis anf Futuna Iland','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('WK','Wake Iland','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('WS','Samoa West','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('YE','Yemen','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('YT','Mayotte','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('ZA','South Africa','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('ZM','Zambia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('ZW','Zimbabwe','Y'); diff --git a/DOCS/en/country/countries-sorted.sql b/DOCS/en/country/countries-sorted.sql index 6b3a5266c0..f9673ecc69 100644 --- a/DOCS/en/country/countries-sorted.sql +++ b/DOCS/en/country/countries-sorted.sql @@ -1,257 +1,257 @@ -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AT','Austria','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BE','Belgium','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CH','Switzerland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CR','Costa Rica','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 ('ES','Spain','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('FI','Finland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('FR','Frabce','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 ('PL','Poland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('RO','Romania','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('RU','Russian Federation','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 `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AC','Ascension','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AD','Andorra','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AE','United Arab Emirates','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AF','Afghanistan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AG','Antigua and Barbuda','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AI','Anguilla','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AL','Albania','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AM','Armenia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AN','Netherlands Antilles','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AO','Angola','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AQ','Antarctica','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AR','Argentina','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AS','American Samoa','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AU','Australia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AW','Aruba','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('AZ','Azerbaijan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BA','Bosnia and Herzegovina','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BB','Barbados','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BD','Bangladesh','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BF','Burkina Faso','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BG','Bulgaria','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BH','Bahrain','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BI','Burundi','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BJ','Benin','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BM','Bermuda','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BN','Brunei Darussalam','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BO','Bolivia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BR','Brazil','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BS','Bahamas','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BT','Bhutan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BV','Bouvet','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BW','Botswana','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BY','Belarus','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('BZ','Belize','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CA','Canada','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CC','Cocos','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CD','Congo Democratc Repuplic','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CF','Central African Republic','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CG','Congo Republic','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CI','Cote D Ivoire','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CK','Cook Iland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CL','Chile','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CM','Cameroon','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CN','China','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CO','Colombia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CS','Serbia and Montenegro','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CT','Canton and Enderbury','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CU','Cuba','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CV','Cape Verde','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CX','Christmas Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('CY','Cyprus','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('DJ','Djibuti','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('DM','Dominica','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('DO','Dominican Republic','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('DZ','Algeria','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('EC','Ecuador','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('EE','Estonia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('EG','Egypt','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('EH','Western Sahara','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ER','Eritrea','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ET','Ethiopia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('EU','European Union','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('FJ','Fiji','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('FK','Falkland Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('FM','Micronesia Fed. S.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('FO','Faroe Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GA','Gabon','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GD','Grenada','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GE','Georgia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GF','French Guiana','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GG','Guernsey','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GH','Ghana','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GI','Gibraltar','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GL','Greenland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GM','Gambia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GN','Guinea','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GP','Guadeloupe','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GQ','Guinea Equatorial','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GS','South Georgia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GT','Guatemala','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GU','Guam','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GW','Guinea-Bissau','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('GY','Guyana','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('HK','Hong Kong','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('HM','Heard- and MC Donald Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('HN','Honduras','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('HT','Haiti','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ID','Indonesia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IL','Israel','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IM','Isle of Man','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IN','India','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IO','British Indian O.T.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IQ','Iraq','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('IR','Iran Islamic Republic','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('JE','Jersey Bailwick','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('JM','Jamaica','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('JO','Jordan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('JP','Japan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('JT','Johnston Atoll','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KE','Kenya','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KG','Kyrgyzstan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KH','Cambodia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KI','Kiribati','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KM','Comoros','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KN','Saint Kitts and Nevis','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KP','Korea Democratic P. Rep.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KR','Korea Republic','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KW','Kuwait','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KY','Cayman Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('KZ','Kazakhstan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LA','Lao People Democratic Rep.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LB','Lebanon','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LC','St. Lucia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LK','Sri Lanka','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LR','Liberia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LS','Lesotho','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LT','Lithuania','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LV','Latvia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('LY','Libyan Arab Jamahiriya','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MA','Morocco','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MD','Moldova Rep.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MG','Madagascar','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MH','Marshall Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MI','Midway Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MK','Macedonia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ML','Mali','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MM','Myanmar','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MN','Mongolia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MO','Macau','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MP','Northern Mariana Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MQ','Martinique','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MR','Mauritania','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MS','Montserat','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MT','Malta','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MU','Mauritius','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MV','Maldives','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MW','Malawi','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MX','Mexico','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MY','Malaysia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('MZ','Mozambique','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NA','Namibia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NC','New Caledonia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NE','Niger','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NF','Norfolk Iland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NG','Nigeria','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NI','Nicaragua','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NP','Nepal','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NQ','Dronning Mauds Land','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NR','Nauru','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NU','Niue','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('NZ','New Zealand','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('OM','Oman','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PA','Panama','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PE','Peru','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PF','French Polynesia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PG','Papua New Guinea','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PH','Philippines','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PK','Parkistan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PM','St. Pierre and Miquelon','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PN','Pitcairn Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PR','Puerto Rico','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PS','Palestian Authority','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PS','Gaza Strip','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PS','West Bank','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PT','Portugal','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PW','Palau','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('PY','Paraguay','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('QA','Qatar','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('RE','Reunion','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('RW','Rwanda','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SA','Saudi Arabia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SB','Solomon Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SC','Seychelles','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SD','Sudan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SG','Singapore','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SH','St. Helena','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SJ','Svalbard and Jan Mayen','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SL','Sierra Leone','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SM','San Marino','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SN','Senegal','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SO','Somalia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SR','Suriname','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ST','Sao Tome and Principe','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SV','El Salvador','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SY','Syrian Arab Rep.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('SZ','Swaziland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TA','Tahiti','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TC','Turks and Caicos Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TD','Chad','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TF','French Southern Ter.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TG','Togo','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TH','Thailand','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TJ','Tajikistan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TK','Ttokelau','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TM','Turkmenistan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TN','Tunisia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TO','Tonga','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TP','East Timor','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TT','Trinidad and Tobago','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TV','Tuvalu','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TW','Taiwan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('TZ','Tanzania U. Rep.','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('UA','Ukraine','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('UG','Uganda','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('UM','U.S. Minor Outlying Ilands','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('US','United States','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('UY','Uruguay','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('UZ','Uzbekistan','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VA','Vatican City State','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VA','Holy See','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VC','St. Vincent and Grenadines','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VE','Venezuela','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VG','Virgin Iland (British)','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VI','Virgin Iland (U.S.)','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VN','Viet Nam','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('VU','Vanuatu','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('WF','Wallis anf Futuna Iland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('WK','Wake Iland','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('WS','Samoa West','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('YE','Yemen','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('YT','Mayotte','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ZA','South Africa','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ZM','Zambia','Y'); -INSERT INTO `mxchange_countries` (`code`, `descr`, `is_active`) VALUES ('ZW','Zimbabwe','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AT','Austria','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BE','Belgium','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CH','Switzerland','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CR','Costa Rica','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 ('ES','Spain','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('FI','Finland','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('FR','Frabce','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 ('PL','Poland','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('RO','Romania','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('RU','Russian Federation','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'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AC','Ascension','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AD','Andorra','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AE','United Arab Emirates','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AF','Afghanistan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AG','Antigua and Barbuda','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AI','Anguilla','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AL','Albania','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AM','Armenia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AN','Netherlands Antilles','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AO','Angola','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AQ','Antarctica','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AR','Argentina','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AS','American Samoa','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AU','Australia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AW','Aruba','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('AZ','Azerbaijan','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 ('BB','Barbados','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BD','Bangladesh','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BF','Burkina Faso','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BG','Bulgaria','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BH','Bahrain','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BI','Burundi','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BJ','Benin','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BM','Bermuda','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BN','Brunei Darussalam','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BO','Bolivia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BR','Brazil','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BS','Bahamas','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BT','Bhutan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BV','Bouvet','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BW','Botswana','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BY','Belarus','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('BZ','Belize','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CA','Canada','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CC','Cocos','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CD','Congo Democratc Repuplic','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CF','Central African Republic','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CG','Congo Republic','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CI','Cote D Ivoire','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CK','Cook Iland','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CL','Chile','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CM','Cameroon','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CN','China','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CO','Colombia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CS','Serbia and Montenegro','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CT','Canton and Enderbury','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CU','Cuba','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CV','Cape Verde','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CX','Christmas Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('CY','Cyprus','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('DJ','Djibuti','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('DM','Dominica','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('DO','Dominican Republic','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('DZ','Algeria','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('EC','Ecuador','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('EE','Estonia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('EG','Egypt','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('EH','Western Sahara','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('ER','Eritrea','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('ET','Ethiopia','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 ('FJ','Fiji','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('FK','Falkland Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('FM','Micronesia Fed. S.','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('FO','Faroe Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GA','Gabon','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GD','Grenada','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GE','Georgia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GF','French Guiana','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GG','Guernsey','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GH','Ghana','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GI','Gibraltar','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GL','Greenland','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GM','Gambia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GN','Guinea','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GP','Guadeloupe','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GQ','Guinea Equatorial','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GS','South Georgia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GT','Guatemala','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GU','Guam','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GW','Guinea-Bissau','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('GY','Guyana','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('HK','Hong Kong','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('HM','Heard- and MC Donald Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('HN','Honduras','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('HT','Haiti','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('ID','Indonesia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('IL','Israel','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('IM','Isle of Man','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('IN','India','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('IO','British Indian O.T.','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('IQ','Iraq','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('IR','Iran Islamic Republic','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('JE','Jersey Bailwick','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('JM','Jamaica','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('JO','Jordan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('JP','Japan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('JT','Johnston Atoll','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KE','Kenya','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KG','Kyrgyzstan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KH','Cambodia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KI','Kiribati','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KM','Comoros','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KN','Saint Kitts and Nevis','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KP','Korea Democratic P. Rep.','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KR','Korea Republic','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KW','Kuwait','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KY','Cayman Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('KZ','Kazakhstan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LA','Lao People Democratic Rep.','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LB','Lebanon','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LC','St. Lucia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LK','Sri Lanka','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LR','Liberia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LS','Lesotho','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LT','Lithuania','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LV','Latvia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('LY','Libyan Arab Jamahiriya','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MA','Morocco','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MD','Moldova Rep.','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MG','Madagascar','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MH','Marshall Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MI','Midway Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MK','Macedonia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('ML','Mali','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MM','Myanmar','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MN','Mongolia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MO','Macau','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MP','Northern Mariana Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MQ','Martinique','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MR','Mauritania','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MS','Montserat','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MT','Malta','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MU','Mauritius','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MV','Maldives','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MW','Malawi','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MX','Mexico','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MY','Malaysia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('MZ','Mozambique','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('NA','Namibia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('NC','New Caledonia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('NE','Niger','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('NF','Norfolk Iland','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('NG','Nigeria','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('NI','Nicaragua','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('NP','Nepal','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('NQ','Dronning Mauds Land','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('NR','Nauru','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('NU','Niue','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 ('OM','Oman','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PA','Panama','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PE','Peru','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PF','French Polynesia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PG','Papua New Guinea','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PH','Philippines','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PK','Parkistan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PM','St. Pierre and Miquelon','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PN','Pitcairn Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PR','Puerto Rico','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PS','Palestian Authority','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PS','Gaza Strip','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PS','West Bank','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PT','Portugal','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PW','Palau','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('PY','Paraguay','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('QA','Qatar','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('RE','Reunion','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('RW','Rwanda','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SA','Saudi Arabia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SB','Solomon Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SC','Seychelles','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SD','Sudan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SG','Singapore','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SH','St. Helena','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SJ','Svalbard and Jan Mayen','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SL','Sierra Leone','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SM','San Marino','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SN','Senegal','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SO','Somalia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SR','Suriname','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('ST','Sao Tome and Principe','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SV','El Salvador','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SY','Syrian Arab Rep.','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('SZ','Swaziland','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TA','Tahiti','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TC','Turks and Caicos Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TD','Chad','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TF','French Southern Ter.','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TG','Togo','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TH','Thailand','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TJ','Tajikistan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TK','Ttokelau','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TM','Turkmenistan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TN','Tunisia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TO','Tonga','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TP','East Timor','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TT','Trinidad and Tobago','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TV','Tuvalu','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TW','Taiwan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('TZ','Tanzania U. Rep.','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('UA','Ukraine','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('UG','Uganda','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('UM','U.S. Minor Outlying Ilands','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('US','United States','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('UY','Uruguay','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('UZ','Uzbekistan','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('VA','Vatican City State','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('VA','Holy See','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('VC','St. Vincent and Grenadines','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('VE','Venezuela','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('VG','Virgin Iland (British)','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('VI','Virgin Iland (U.S.)','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('VN','Viet Nam','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('VU','Vanuatu','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('WF','Wallis anf Futuna Iland','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('WK','Wake Iland','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('WS','Samoa West','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('YE','Yemen','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('YT','Mayotte','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('ZA','South Africa','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('ZM','Zambia','Y'); +INSERT INTO `{?_MYSQL_PREFIX?}_countries` (`code`, `descr`, `is_active`) VALUES ('ZW','Zimbabwe','Y'); diff --git a/inc/install-functions.php b/inc/install-functions.php index c0a939c286..ef8ae8debb 100644 --- a/inc/install-functions.php +++ b/inc/install-functions.php @@ -771,7 +771,7 @@ function isInstallerOutputModeValid ($currentTab) { // Wrapper to import given installation SQL dump function importInstallSqlDump ($dumpName) { // Import the file - importSqlDump('install', $dumpName); + importSqlDump('install', $dumpName, 'install'); } // [EOF] diff --git a/inc/sql-functions.php b/inc/sql-functions.php index 4f57bf88ca..e61f393804 100644 --- a/inc/sql-functions.php +++ b/inc/sql-functions.php @@ -260,8 +260,8 @@ function initSqlLink () { } } -// Imports given SQL dump from given (relative) path -function importSqlDump ($path, $dumpName) { +// Imports given SQL dump from given (relative) path and adds them to $sqlPool +function importSqlDump ($path, $dumpName, $sqlPool) { // Construct FQFN $FQFN = getPath() . $path . '/' . $dumpName . '.sql'; @@ -275,7 +275,7 @@ function importSqlDump ($path, $dumpName) { $fileContent = readSqlDump($FQFN); // Merge it with existing SQL statements - mergeSqls(explode(";\n", $fileContent), 'install'); + mergeSqls(explode(";\n", $fileContent), $sqlPool); } // [EOF] diff --git a/templates/de/html/guest/guest_register.tpl b/templates/de/html/guest/guest_register.tpl index 501249615c..00e614e5d1 100644 --- a/templates/de/html/guest/guest_register.tpl +++ b/templates/de/html/guest/guest_register.tpl @@ -17,7 +17,7 @@ - - - - @@ -57,8 +58,8 @@ - -
+ {--GENDER--}$content[must_fillout_gender]: @@ -26,7 +26,8 @@
{--SURNAME--}$content[must_fillout_surname], + + {--SURNAME--}$content[must_fillout_surname], {--FAMILY--}$content[must_fillout_family]: @@ -36,7 +37,7 @@
+ {--STREET_NR--}$content[must_fillout_street_nr]: @@ -45,7 +46,7 @@
+ {--COUNTRY--}$content[must_fillout_cntry], {--ZIP--}$content[must_fillout_zip], {--CITY--}$content[must_fillout_city]:
- {--EMAIL--}$content[must_fillout_email]:   + + {--EMAIL--}$content[must_fillout_email]: @@ -66,7 +67,7 @@
+ {--BIRTHDAY--}$content[must_fillout_birthday]: @@ -76,7 +77,9 @@
-
$content[must_fillout_marker] : {--GUEST_REGISTER_MUST_SET_NOTICE--}
+
+ $content[must_fillout_marker]:{--GUEST_REGISTER_MUST_SET_NOTICE--} +
@@ -114,7 +117,7 @@ - + {--PASS_1--}, {--PASS_2--}: -- 2.39.2