Continued:

- added SQL dump with initial country data

Signed-off-by: Roland Häder <roland@mxchange.org>

diff --git a/src/country_data.sql b/src/country_data.sql
new file mode 100644 (file)
index 0000000..8bc1c84
--- /dev/null
+++ b/src/country_data.sql
@@ -0,0 +1,23 @@
+-- Adminer 4.7.6 MySQL dump
+
+SET NAMES utf8;
+SET time_zone = '+00:00';
+SET foreign_key_checks = 0;
+SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
+
+INSERT INTO `country_data` (`country_id`, `country_abroad_dial_prefix`, `country_code`, `country_entry_created`, `country_entry_updated`, `country_external_dial_prefix`, `country_i18n_key`, `country_is_local_prefix_required`, `country_phone_code`) VALUES
+(1,    '+',    'DE',   NOW(),  NULL,   '0',    'COUNTRY_GERMANY',      1,      49),
+(2,    '+',    'IT',   NOW(),  NULL,   '0',    'COUNTRY_ITALIA',       1,      39),
+(3,    '+',    'PH',   NOW(),  NULL,   '0',    'COUNTRY_PHILIPPINES',  1,      63),
+(4,    '+',    'TR',   NOW(),  NULL,   '0',    'COUNTRY_TURKEY',       1,      90),
+(5,    '+',    'GR',   NOW(),  NULL,   '0',    'COUNTRY_GREECE',       1,      30),
+(6,    '+',    'FR',   NOW(),  NULL,   '0',    'COUNTRY_FRANCE',       1,      33),
+(7,    '+',    'DK',   NOW(),  NULL,   '0',    'COUNTRY_DANMARK',      1,      45),
+(8,    '+',    'AT',   NOW(),  NULL,   '0',    'COUNTRY_AUSTRIA',      1,      43),
+(9,    '+',    'NL',   NOW(),  NULL,   '0',    'COUNTRY_NETHERLANDS',  1,      31),
+(11,   '+',    'CL',   NOW(),  NULL,   '0',    'COUNTRY_CHILE',        1,      56),
+(12,   '+',    'BE',   NOW(),  NULL,   '0',    'COUNTRY_BELGIUM',      1,      32),
+(13,   '+',    'TH',   NOW(),  NULL,   '0',    'COUNTRY_THAILAND',     1,      66),
+(14,   '+',    'US',   NOW(),  NULL,   '0',    'COUNTRY_UNITED_STATES_OF_AMERICA',     1,      1);
+
+-- 2020-04-01 19:02:59