From 276daf59f28244c26a69608c2f799b4379091e91 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Roland=20H=C3=A4der?= Date: Wed, 1 Apr 2020 21:05:10 +0200 Subject: [PATCH] Continued: - added SQL dump with initial country data MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Signed-off-by: Roland Häder --- src/country_data.sql | 23 +++++++++++++++++++++++ 1 file changed, 23 insertions(+) create mode 100644 src/country_data.sql diff --git a/src/country_data.sql b/src/country_data.sql new file mode 100644 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 -- 2.39.5