# REPLACE countries
Liens pour exports des 3 tables :
Store_payment_mean_country :
http://localhost:8182/?server=db&username=root&db=fastsite3_milore&select=store_payment_mean_country&columns%5B0%5D%5Bfun%5D=&columns%5B0%5D%5Bcol%5D=&where%5B0%5D%5Bcol%5D=key_country&where%5B0%5D%5Bop%5D=IN&where%5B0%5D%5Bval%5D=%27GB%27%2C%27CZ%27&where%5B01%5D%5Bcol%5D=&where%5B01%5D%5Bop%5D=%3D&where%5B01%5D%5Bval%5D=&order%5B0%5D=&limit=50&text_length=100
Lang_country :
http://localhost:8182/?server=db&username=root&db=fastsite3_milore&select=lang_country&columns%5B0%5D%5Bfun%5D=&columns%5B0%5D%5Bcol%5D=&where%5B0%5D%5Bcol%5D=key_country&where%5B0%5D%5Bop%5D=IN&where%5B0%5D%5Bval%5D=%27GB%27%2C%27CZ%27&where%5B01%5D%5Bcol%5D=&where%5B01%5D%5Bop%5D=%3D&where%5B01%5D%5Bval%5D=&order%5B0%5D=&limit=50&text_length=100
Geo_country :
http://localhost:8182/?server=db&username=root&db=fastsite3_antoineetlili&select=geo_country&columns%5B0%5D%5Bfun%5D=&columns%5B0%5D%5Bcol%5D=&where%5B0%5D%5Bcol%5D=alpha2&where%5B0%5D%5Bop%5D=IN&where%5B0%5D%5Bval%5D=%27GB%27%2C%27CZ%27&where%5B1%5D%5Bcol%5D=&where%5B1%5D%5Bop%5D=%3D&where%5B1%5D%5Bval%5D=&order%5B0%5D=&limit=50&text_length=100
**Remplacer la BD en URL**
- [x] Antoinetlili :
```
```
- [x] PDB :
```
```
- [x] PetF :
```
```
- [x] Closet :
```
REPLACE INTO `geo_country` (`num`, `alpha3`, `alpha2`, `call_prefix`, `zip_regex`, `zip_format`, `key_zone`, `lng`, `name`, `iso_name`, `original_name`, `enabled`, `date_modification`, `date_creation`) VALUES
('203', 'CZE', 'CZ', 420, '^\\d{5}\\s\\(\\d{3}\\s\\d{2}\\)$', 'NNNNN (NNN NN)', 'europe', 'fr_FR', 'République tchèque', 'TCHÈQUE, RÉPUBLIQUE', 'Ceská Republika', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
('826', 'GBR', 'GB', 44, '^[A-Z]{1,2}[0-9R][0-9A-Z]?\\s*[0-9][A-Z-[CIKMOV]]{2}', 'A(A)N(A/N)NAA (A[A]N[A/N] NAA)', 'europe', 'fr_FR', 'Royaume-Uni', 'ROYAUME-UNI', 'United Kingdom', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
REPLACE INTO `lang_country` (`lng`, `key_country`) VALUES
('fr_FR', 'CZ'),
('fr_FR', 'GB');
REPLACE INTO `store_payment_mean_country` (`key_mean`, `key_country`) VALUES
('bank_transfer', 'CZ'),
('check', 'CZ'),
('credit_card', 'CZ'),
('creditnote', 'CZ'),
('paypal', 'CZ'),
('bank_transfer', 'GB'),
('check', 'GB'),
('credit_card', 'GB'),
('creditnote', 'GB'),
('paypal', 'GB');
```
- [x] Sharico :
```
REPLACE INTO `geo_country` (`num`, `alpha3`, `alpha2`, `call_prefix`, `zip_regex`, `zip_format`, `key_zone`, `lng`, `name`, `iso_name`, `original_name`, `enabled`, `date_modification`, `date_creation`) VALUES
('203', 'CZE', 'CZ', 420, '^\\d{5}\\s\\(\\d{3}\\s\\d{2}\\)$', 'NNNNN (NNN NN)', 'europe', 'en_GB', 'République tchèque', 'TCHÈQUE, RÉPUBLIQUE', 'Ceská Republika', 1, '2019-02-26 08:32:01', '2019-02-26 08:32:01'),
('203', 'CZE', 'CZ', 420, '^\\d{5}\\s\\(\\d{3}\\s\\d{2}\\)$', 'NNNNN (NNN NN)', 'europe', 'fr_FR', 'République tchèque', 'TCHÈQUE, RÉPUBLIQUE', 'Ceská Republika', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
('826', 'GBR', 'GB', 44, '^[A-Z]{1,2}[0-9R][0-9A-Z]?\\s*[0-9][A-Z-[CIKMOV]]{2}', 'A(A)N(A/N)NAA (A[A]N[A/N] NAA)', 'europe', 'en_GB', 'Royaume-Uni', 'ROYAUME-UNI', 'United Kingdom', 1, '2019-02-26 08:32:01', '2019-02-26 08:32:01'),
('826', 'GBR', 'GB', 44, '^[A-Z]{1,2}[0-9R][0-9A-Z]?\\s*[0-9][A-Z-[CIKMOV]]{2}', 'A(A)N(A/N)NAA (A[A]N[A/N] NAA)', 'europe', 'fr_FR', 'Royaume-Uni', 'ROYAUME-UNI', 'United Kingdom', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
REPLACE INTO `lang_country` (`lng`, `key_country`) VALUES
('en_GB', 'CZ'),
('fr_FR', 'CZ'),
('en_GB', 'GB'),
('fr_FR', 'GB');
REPLACE INTO `store_payment_mean_country` (`key_mean`, `key_country`) VALUES
('credit_card', 'CZ'),
('creditnote', 'CZ'),
('paypal', 'CZ'),
('credit_card', 'GB'),
('creditnote', 'GB'),
('paypal', 'GB');
```
- [x] AAB :
```
REPLACE INTO `geo_country` (`num`, `alpha3`, `alpha2`, `call_prefix`, `zip_regex`, `zip_format`, `key_zone`, `lng`, `name`, `iso_name`, `original_name`, `enabled`, `date_modification`, `date_creation`) VALUES
('203', 'CZE', 'CZ', 420, '^\\d{5}\\s\\(\\d{3}\\s\\d{2}\\)$', 'NNNNN (NNN NN)', 'europe', 'fr_FR', 'République tchèque', 'TCHÈQUE, RÉPUBLIQUE', 'Ceská Republika', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
('826', 'GBR', 'GB', 44, '^[A-Z]{1,2}[0-9R][0-9A-Z]?\\s*[0-9][A-Z-[CIKMOV]]{2}', 'A(A)N(A/N)NAA (A[A]N[A/N] NAA)', 'europe', 'fr_FR', 'Royaume-Uni', 'ROYAUME-UNI', 'United Kingdom', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
REPLACE INTO `lang_country` (`lng`, `key_country`) VALUES
('fr_FR', 'CZ'),
('fr_FR', 'GB');
REPLACE INTO `store_payment_mean_country` (`key_mean`, `key_country`) VALUES
('bank_transfer', 'CZ'),
('check', 'CZ'),
('credit_card', 'CZ'),
('creditnote', 'CZ'),
('paypal', 'CZ'),
('bank_transfer', 'GB'),
('check', 'GB'),
('credit_card', 'GB'),
('creditnote', 'GB'),
('paypal', 'GB');
```
- [x] Milore :
```
REPLACE INTO `store_payment_mean_country` (`key_mean`, `key_country`) VALUES
('bank_transfer', 'CZ'),
('check', 'CZ'),
('credit_card', 'CZ'),
('creditnote', 'CZ'),
('paypal', 'CZ'),
('bank_transfer', 'GB'),
('check', 'GB'),
('credit_card', 'GB'),
('creditnote', 'GB'),
('paypal', 'GB');
REPLACE INTO `lang_country` (`lng`, `key_country`) VALUES
('en', 'CZ'),
('fr_FR', 'CZ'),
('en', 'GB'),
('fr_FR', 'GB');
```
- [x] Hommesoubetes :
```
REPLACE INTO `store_payment_mean_country` (`key_mean`, `key_country`) VALUES
('bank_transfer', 'CZ'),
('check', 'CZ'),
('credit_card', 'CZ'),
('creditnote', 'CZ'),
('paypal', 'CZ'),
('bank_transfer', 'GB'),
('check', 'GB'),
('credit_card', 'GB'),
('creditnote', 'GB'),
('paypal', 'GB');
REPLACE INTO `lang_country` (`lng`, `key_country`) VALUES
('en_UK', 'CZ'),
('fr_FR', 'CZ'),
('en_UK', 'GB'),
('fr_FR', 'GB');
REPLACE INTO `geo_country` (`num`, `alpha3`, `alpha2`, `call_prefix`, `zip_regex`, `zip_format`, `key_zone`, `lng`, `name`, `iso_name`, `original_name`, `enabled`, `date_modification`, `date_creation`) VALUES
('203', 'CZE', 'CZ', 420, '^\\d{5}\\s\\(\\d{3}\\s\\d{2}\\)$', 'NNNNN (NNN NN)', 'europe', 'en_UK', 'République tchèque', 'TCHÈQUE, RÉPUBLIQUE', 'Ceská Republika', 1, '2017-01-20 10:53:03', '2017-01-20 10:53:03'),
('203', 'CZE', 'CZ', 420, '^\\d{5}\\s\\(\\d{3}\\s\\d{2}\\)$', 'NNNNN (NNN NN)', 'europe', 'fr_FR', 'République tchèque', 'TCHÈQUE, RÉPUBLIQUE', 'Ceská Republika', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
('826', 'GBR', 'GB', 44, '^[A-Z]{1,2}[0-9R][0-9A-Z]?\\s*[0-9][A-Z-[CIKMOV]]{2}', 'A(A)N(A/N)NAA (A[A]N[A/N] NAA)', 'europe', 'en_UK', 'Royaume-Uni', 'ROYAUME-UNI', 'United Kingdom', 1, '2017-01-20 10:53:03', '2017-01-20 10:53:03'),
('826', 'GBR', 'GB', 44, '^[A-Z]{1,2}[0-9R][0-9A-Z]?\\s*[0-9][A-Z-[CIKMOV]]{2}', 'A(A)N(A/N)NAA (A[A]N[A/N] NAA)', 'europe', 'fr_FR', 'Royaume-Uni', 'ROYAUME-UNI', 'United Kingdom', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
```
- [x] Impexair :
```
REPLACE INTO `geo_country` (`num`, `alpha3`, `alpha2`, `call_prefix`, `zip_regex`, `zip_format`, `key_zone`, `lng`, `name`, `iso_name`, `original_name`, `enabled`, `date_modification`, `date_creation`) VALUES
('203', 'CZE', 'CZ', 420, '^\\d{5}\\s\\(\\d{3}\\s\\d{2}\\)$', 'NNNNN (NNN NN)', 'europe', 'fr_FR', 'République tchèque', 'TCHÈQUE, RÉPUBLIQUE', 'Ceská Republika', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
('826', 'GBR', 'GB', 44, '^[A-Z]{1,2}[0-9R][0-9A-Z]?\\s*[0-9][A-Z-[CIKMOV]]{2}', 'A(A)N(A/N)NAA (A[A]N[A/N] NAA)', 'europe', 'fr_FR', 'Royaume-Uni', 'ROYAUME-UNI', 'United Kingdom', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
REPLACE INTO `lang_country` (`lng`, `key_country`) VALUES
('fr_FR', 'CZ'),
('fr_FR', 'GB');
```
- [x] Maradji :
```
REPLACE INTO `geo_country` (`num`, `alpha3`, `alpha2`, `call_prefix`, `zip_regex`, `zip_format`, `key_zone`, `lng`, `name`, `iso_name`, `original_name`, `enabled`, `date_modification`, `date_creation`) VALUES
('203', 'CZE', 'CZ', 420, '^\\d{5}\\s\\(\\d{3}\\s\\d{2}\\)$', 'NNNNN (NNN NN)', 'europe', 'en_GB', 'Czech Republic', 'TCHÈQUE, RÉPUBLIQUE', 'Ceská Republika', 1, '2018-09-05 13:49:20', '2018-01-30 15:08:33'),
('203', 'CZE', 'CZ', 420, '^\\d{5}\\s\\(\\d{3}\\s\\d{2}\\)$', 'NNNNN (NNN NN)', 'europe', 'fr_FR', 'République tchèque', 'TCHÈQUE, RÉPUBLIQUE', 'Ceská Republika', 1, '2018-09-05 13:49:20', '0000-00-00 00:00:00'),
('826', 'GBR', 'GB', 44, '^[A-Z]{1,2}[0-9R][0-9A-Z]?\\s*[0-9][A-Z-[CIKMOV]]{2}', 'A(A)N(A/N)NAA (A[A]N[A/N] NAA)', 'espagne-portugal-royaume-unis-irlande', 'en_GB', 'United Kingdom', 'ROYAUME-UNI', 'United Kingdom', 1, '2020-05-25 13:05:29', '2018-01-30 15:08:33'),
('826', 'GBR', 'GB', 44, '^[A-Z]{1,2}[0-9R][0-9A-Z]?\\s*[0-9][A-Z-[CIKMOV]]{2}', 'A(A)N(A/N)NAA (A[A]N[A/N] NAA)', 'espagne-portugal-royaume-unis-irlande', 'fr_FR', 'Royaume-Uni', 'ROYAUME-UNI', 'United Kingdom', 1, '2020-05-25 13:05:29', '0000-00-00 00:00:00');
REPLACE INTO `lang_country` (`lng`, `key_country`) VALUES
('en_GB', 'CZ'),
('fr_FR', 'CZ'),
('en_GB', 'GB'),
('fr_FR', 'GB');
REPLACE INTO `store_payment_mean_country` (`key_mean`, `key_country`) VALUES
('bank_transfer', 'CZ'),
('check', 'CZ'),
('credit_card', 'CZ'),
('credit_card_amex', 'CZ'),
('creditnote', 'CZ'),
('payment_shop', 'CZ'),
('paypal', 'CZ'),
('bank_transfer', 'GB'),
('check', 'GB'),
('credit_card', 'GB'),
('credit_card_amex', 'GB'),
('creditnote', 'GB'),
('payment_shop', 'GB'),
('paypal', 'GB');
```
- [x] Axston :
```
REPLACE INTO `geo_country` (`num`, `alpha3`, `alpha2`, `call_prefix`, `zip_regex`, `zip_format`, `key_zone`, `lng`, `name`, `iso_name`, `original_name`, `enabled`, `date_modification`, `date_creation`) VALUES
('203', 'CZE', 'CZ', '420', '^\\d{5}\\s\\(\\d{3}\\s\\d{2}\\)$', 'NNNNN (NNN NN)', 'europe', 'fr_FR', 'République tchèque', 'TCHÈQUE, RÉPUBLIQUE', 'Ceská Republika', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
('826', 'GBR', 'GB', '44', '^[A-Z]{1,2}[0-9R][0-9A-Z]?\\s*[0-9][A-Z-[CIKMOV]]{2}', 'A(A)N(A/N)NAA (A[A]N[A/N] NAA)', 'europe', 'fr_FR', 'Royaume-Uni', 'ROYAUME-UNI', 'United Kingdom', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
REPLACE INTO `lang_country` (`lng`, `key_country`) VALUES
('fr_FR', 'CZ'),
('fr_FR', 'GB');
```
- [x] bailart :
```
REPLACE INTO `geo_country` (`num`, `alpha3`, `alpha2`, `call_prefix`, `zip_regex`, `zip_format`, `key_zone`, `lng`, `name`, `iso_name`, `original_name`, `enabled`, `date_modification`, `date_creation`) VALUES
('203', 'CZE', 'CZ', '420', '^\\d{5}\\s\\(\\d{3}\\s\\d{2}\\)$', 'NNNNN (NNN NN)', 'europe', 'fr_FR', 'République tchèque', 'TCHÈQUE, RÉPUBLIQUE', 'Ceská Republika', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
('826', 'GBR', 'GB', '44', '^[A-Z]{1,2}[0-9R][0-9A-Z]?\\s*[0-9][A-Z-[CIKMOV]]{2}', 'A(A)N(A/N)NAA (A[A]N[A/N] NAA)', 'europe', 'fr_FR', 'Royaume-Uni', 'ROYAUME-UNI', 'United Kingdom', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
REPLACE INTO `lang_country` (`lng`, `key_country`) VALUES
('fr_FR', 'CZ'),
('fr_FR', 'GB');
```
- [ ] Bgr :
```
REPLACE INTO `geo_country` (`num`, `alpha3`, `alpha2`, `call_prefix`, `zip_regex`, `zip_format`, `key_zone`, `lng`, `name`, `iso_name`, `original_name`, `enabled`, `date_modification`, `date_creation`) VALUES
('203', 'CZE', 'CZ', '420', '^\\d{5}\\s\\(\\d{3}\\s\\d{2}\\)$', 'NNNNN (NNN NN)', 'europe', 'en_GB', 'République tchèque', 'TCHÈQUE, RÉPUBLIQUE', 'Ceská Republika', 1, '2020-02-19 16:54:40', '2020-02-19 16:54:40'),
('203', 'CZE', 'CZ', '420', '^\\d{5}\\s\\(\\d{3}\\s\\d{2}\\)$', 'NNNNN (NNN NN)', 'europe', 'fr_FR', 'République tchèque', 'TCHÈQUE, RÉPUBLIQUE', 'Ceská Republika', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
('826', 'GBR', 'GB', '44', '^[A-Z]{1,2}[0-9R][0-9A-Z]?\\s*[0-9][A-Z-[CIKMOV]]{2}', 'A(A)N(A/N)NAA (A[A]N[A/N] NAA)', 'europe', 'en_GB', 'Royaume-Uni', 'ROYAUME-UNI', 'United Kingdom', 1, '2020-02-19 16:54:40', '2020-02-19 16:54:40'),
('826', 'GBR', 'GB', '44', '^[A-Z]{1,2}[0-9R][0-9A-Z]?\\s*[0-9][A-Z-[CIKMOV]]{2}', 'A(A)N(A/N)NAA (A[A]N[A/N] NAA)', 'europe', 'fr_FR', 'Royaume-Uni', 'ROYAUME-UNI', 'United Kingdom', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
REPLACE INTO `lang_country` (`lng`, `key_country`) VALUES
('fr_FR', 'CZ'),
('fr_FR', 'GB');
```
- [x] Clarence nalpas :
```
REPLACE INTO `geo_country` (`num`, `alpha3`, `alpha2`, `call_prefix`, `zip_regex`, `zip_format`, `key_zone`, `lng`, `name`, `iso_name`, `original_name`, `enabled`, `date_modification`, `date_creation`) VALUES
('203', 'CZE', 'CZ', '420', '^\\d{5}\\s\\(\\d{3}\\s\\d{2}\\)$', 'NNNNN (NNN NN)', NULL, 'fr_FR', 'République tchèque', 'TCHÈQUE, RÉPUBLIQUE', 'Ceská Republika', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
('826', 'GBR', 'GB', '44', '^[A-Z]{1,2}[0-9R][0-9A-Z]?\\s*[0-9][A-Z-[CIKMOV]]{2}', 'A(A)N(A/N)NAA (A[A]N[A/N] NAA)', NULL, 'fr_FR', 'Royaume-Uni', 'ROYAUME-UNI', 'United Kingdom', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
REPLACE INTO `lang_country` (`lng`, `key_country`) VALUES
('fr_FR', 'CZ'),
('fr_FR', 'GB');
```
- [x] Cogifluide :
```
REPLACE INTO `geo_country` (`num`, `alpha3`, `alpha2`, `call_prefix`, `zip_regex`, `zip_format`, `key_zone`, `lng`, `name`, `iso_name`, `original_name`, `enabled`, `date_modification`, `date_creation`) VALUES
('203', 'CZE', 'CZ', '420', '^\\d{5}\\s\\(\\d{3}\\s\\d{2}\\)$', 'NNNNN (NNN NN)', 'europe', 'fr_FR', 'République tchèque', 'TCHÈQUE, RÉPUBLIQUE', 'Ceská Republika', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
('826', 'GBR', 'GB', '44', '^[A-Z]{1,2}[0-9R][0-9A-Z]?\\s*[0-9][A-Z-[CIKMOV]]{2}', 'A(A)N(A/N)NAA (A[A]N[A/N] NAA)', 'europe', 'fr_FR', 'Royaume-Uni', 'ROYAUME-UNI', 'United Kingdom', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
REPLACE INTO `lang_country` (`lng`, `key_country`) VALUES
('fr_FR', 'CZ'),
('fr_FR', 'GB');
```
- [x] Concepteev :
```
REPLACE INTO `geo_country` (`num`, `alpha3`, `alpha2`, `call_prefix`, `zip_regex`, `zip_format`, `key_zone`, `lng`, `name`, `iso_name`, `original_name`, `enabled`, `date_modification`, `date_creation`) VALUES
('203', 'CZE', 'CZ', 420, '^\\d{5}\\s\\(\\d{3}\\s\\d{2}\\)$', 'NNNNN (NNN NN)', 'europe', 'en_EN', 'République tchèque', 'TCHÈQUE, RÉPUBLIQUE', 'Ceská Republika', 1, '2017-04-05 17:07:30', '2017-04-05 17:07:30'),
('203', 'CZE', 'CZ', 420, '^\\d{5}\\s\\(\\d{3}\\s\\d{2}\\)$', 'NNNNN (NNN NN)', 'europe', 'fr_FR', 'République tchèque', 'TCHÈQUE, RÉPUBLIQUE', 'Ceská Republika', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
('826', 'GBR', 'GB', 44, '^[A-Z]{1,2}[0-9R][0-9A-Z]?\\s*[0-9][A-Z-[CIKMOV]]{2}', 'A(A)N(A/N)NAA (A[A]N[A/N] NAA)', 'europe', 'en_EN', 'Royaume-Uni', 'ROYAUME-UNI', 'United Kingdom', 1, '2017-04-05 17:07:30', '2017-04-05 17:07:30'),
('826', 'GBR', 'GB', 44, '^[A-Z]{1,2}[0-9R][0-9A-Z]?\\s*[0-9][A-Z-[CIKMOV]]{2}', 'A(A)N(A/N)NAA (A[A]N[A/N] NAA)', 'europe', 'fr_FR', 'Royaume-Uni', 'ROYAUME-UNI', 'United Kingdom', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
REPLACE INTO `lang_country` (`lng`, `key_country`) VALUES
('en_EN', 'CZ'),
('fr_FR', 'CZ'),
('en_EN', 'GB'),
('fr_FR', 'GB');
REPLACE INTO `store_payment_mean_country` (`key_mean`, `key_country`) VALUES
('bank_transfer', 'CZ'),
('check', 'CZ'),
('credit_card', 'CZ'),
('creditnote', 'CZ'),
('paypal', 'CZ'),
('bank_transfer', 'GB'),
('check', 'GB'),
('credit_card', 'GB'),
('creditnote', 'GB'),
('paypal', 'GB');
```
- [x] Excp :
```
REPLACE INTO `geo_country` (`num`, `alpha3`, `alpha2`, `call_prefix`, `zip_regex`, `zip_format`, `key_zone`, `lng`, `name`, `iso_name`, `original_name`, `enabled`, `date_modification`, `date_creation`) VALUES
('203', 'CZE', 'CZ', '420', '^\\d{5}\\s\\(\\d{3}\\s\\d{2}\\)$', 'NNNNN (NNN NN)', NULL, 'en_GB', 'République tchèque', 'TCHÈQUE, RÉPUBLIQUE', 'Ceská Republika', 1, '2019-07-15 13:51:29', '2019-07-15 13:51:29'),
('203', 'CZE', 'CZ', '420', '^\\d{5}\\s\\(\\d{3}\\s\\d{2}\\)$', 'NNNNN (NNN NN)', NULL, 'fr_FR', 'République tchèque', 'TCHÈQUE, RÉPUBLIQUE', 'Ceská Republika', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
('826', 'GBR', 'GB', '44', '^[A-Z]{1,2}[0-9R][0-9A-Z]?\\s*[0-9][A-Z-[CIKMOV]]{2}', 'A(A)N(A/N)NAA (A[A]N[A/N] NAA)', NULL, 'en_GB', 'Royaume-Uni', 'ROYAUME-UNI', 'United Kingdom', 1, '2019-07-15 13:51:29', '2019-07-15 13:51:29'),
('826', 'GBR', 'GB', '44', '^[A-Z]{1,2}[0-9R][0-9A-Z]?\\s*[0-9][A-Z-[CIKMOV]]{2}', 'A(A)N(A/N)NAA (A[A]N[A/N] NAA)', NULL, 'fr_FR', 'Royaume-Uni', 'ROYAUME-UNI', 'United Kingdom', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
REPLACE INTO `lang_country` (`lng`, `key_country`) VALUES
('en_GB', 'CZ'),
('fr_FR', 'CZ'),
('en_GB', 'GB'),
('fr_FR', 'GB');
```
- [x] Expertimmobilier :
```
```
- [x] Financiale :
```
REPLACE INTO `geo_country` (`num`, `alpha3`, `alpha2`, `call_prefix`, `zip_regex`, `zip_format`, `key_zone`, `lng`, `name`, `iso_name`, `original_name`, `enabled`, `date_modification`, `date_creation`) VALUES
('203', 'CZE', 'CZ', '420', '^\\d{5}\\s\\(\\d{3}\\s\\d{2}\\)$', 'NNNNN (NNN NN)', 'europe', 'fr_FR', 'République tchèque', 'TCHÈQUE, RÉPUBLIQUE', 'Ceská Republika', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
('826', 'GBR', 'GB', '44', '^[A-Z]{1,2}[0-9R][0-9A-Z]?\\s*[0-9][A-Z-[CIKMOV]]{2}', 'A(A)N(A/N)NAA (A[A]N[A/N] NAA)', 'europe', 'fr_FR', 'Royaume-Uni', 'ROYAUME-UNI', 'United Kingdom', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
REPLACE NTO `lang_country` (`lng`, `key_country`) VALUES
('fr_FR', 'CZ'),
('fr_FR', 'GB');
```
- [x] Financialesport :
```
REPLACE INTO `geo_country` (`num`, `alpha3`, `alpha2`, `call_prefix`, `zip_regex`, `zip_format`, `key_zone`, `lng`, `name`, `iso_name`, `original_name`, `enabled`, `date_modification`, `date_creation`) VALUES
('203', 'CZE', 'CZ', '420', '^\\d{5}\\s\\(\\d{3}\\s\\d{2}\\)$', 'NNNNN (NNN NN)', 'europe', 'fr_FR', 'République tchèque', 'TCHÈQUE, RÉPUBLIQUE', 'Ceská Republika', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
('826', 'GBR', 'GB', '44', '^[A-Z]{1,2}[0-9R][0-9A-Z]?\\s*[0-9][A-Z-[CIKMOV]]{2}', 'A(A)N(A/N)NAA (A[A]N[A/N] NAA)', 'europe', 'fr_FR', 'Royaume-Uni', 'ROYAUME-UNI', 'United Kingdom', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
REPLACE INTO `lang_country` (`lng`, `key_country`) VALUES
('fr_FR', 'CZ'),
('fr_FR', 'GB');
```
- [x] Ideoj :
```
REPLACE INTO `geo_country` (`num`, `alpha3`, `alpha2`, `call_prefix`, `zip_regex`, `zip_format`, `key_zone`, `lng`, `name`, `iso_name`, `original_name`, `enabled`, `date_modification`, `date_creation`) VALUES
('203', 'CZE', 'CZ', '420', '^\\d{5}\\s\\(\\d{3}\\s\\d{2}\\)$', 'NNNNN (NNN NN)', 'europe', 'fr_FR', 'République tchèque', 'TCHÈQUE, RÉPUBLIQUE', 'Ceská Republika', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
('826', 'GBR', 'GB', '44', '^[A-Z]{1,2}[0-9R][0-9A-Z]?\\s*[0-9][A-Z-[CIKMOV]]{2}', 'A(A)N(A/N)NAA (A[A]N[A/N] NAA)', 'europe', 'fr_FR', 'Royaume-Uni', 'ROYAUME-UNI', 'United Kingdom', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
REPLACE INTO `lang_country` (`lng`, `key_country`) VALUES
('fr_FR', 'CZ'),
('fr_FR', 'GB');
```
- [x] Jbk :
```
REPLACE INTO `geo_country` (`num`, `alpha3`, `alpha2`, `call_prefix`, `zip_regex`, `zip_format`, `key_zone`, `lng`, `name`, `iso_name`, `original_name`, `enabled`, `date_modification`, `date_creation`) VALUES
('203', 'CZE', 'CZ', 420, '^\\d{5}\\s\\(\\d{3}\\s\\d{2}\\)$', 'NNNNN (NNN NN)', 'europe', 'en', 'République tchèque', 'TCHÈQUE, RÉPUBLIQUE', 'Ceská Republika', 1, '2019-10-23 13:06:43', '2019-10-23 13:06:43'),
('203', 'CZE', 'CZ', 420, '^\\d{5}\\s\\(\\d{3}\\s\\d{2}\\)$', 'NNNNN (NNN NN)', 'europe', 'fr_FR', 'République tchèque', 'TCHÈQUE, RÉPUBLIQUE', 'Ceská Republika', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
('826', 'GBR', 'GB', 44, '^[A-Z]{1,2}[0-9R][0-9A-Z]?\\s*[0-9][A-Z-[CIKMOV]]{2}', 'A(A)N(A/N)NAA (A[A]N[A/N] NAA)', 'europe', 'en', 'Royaume-Uni', 'ROYAUME-UNI', 'United Kingdom', 1, '2019-10-23 13:06:43', '2019-10-23 13:06:43'),
('826', 'GBR', 'GB', 44, '^[A-Z]{1,2}[0-9R][0-9A-Z]?\\s*[0-9][A-Z-[CIKMOV]]{2}', 'A(A)N(A/N)NAA (A[A]N[A/N] NAA)', 'europe', 'fr_FR', 'Royaume-Uni', 'ROYAUME-UNI', 'United Kingdom', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
REPLACE INTO `lang_country` (`lng`, `key_country`) VALUES
('en', 'CZ'),
('fr_FR', 'CZ'),
('en', 'GB'),
('fr_FR', 'GB');
```
- [ ] Pandda :
```
```
- [x] Signascript :
```
REPLACE INTO `geo_country` (`num`, `alpha3`, `alpha2`, `call_prefix`, `zip_regex`, `zip_format`, `key_zone`, `lng`, `name`, `iso_name`, `original_name`, `enabled`, `date_modification`, `date_creation`) VALUES
('203', 'CZE', 'CZ', 420, '^\\d{5}\\s\\(\\d{3}\\s\\d{2}\\)$', 'NNNNN (NNN NN)', 'europe', 'en_GB', 'République tchèque', 'TCHÈQUE, RÉPUBLIQUE', 'Ceská Republika', 1, '2019-07-09 09:50:04', '2019-07-09 09:50:04'),
('203', 'CZE', 'CZ', 420, '^\\d{5}\\s\\(\\d{3}\\s\\d{2}\\)$', 'NNNNN (NNN NN)', 'europe', 'fr_FR', 'République tchèque', 'TCHÈQUE, RÉPUBLIQUE', 'Ceská Republika', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
('826', 'GBR', 'GB', 44, '^[A-Z]{1,2}[0-9R][0-9A-Z]?\\s*[0-9][A-Z-[CIKMOV]]{2}', 'A(A)N(A/N)NAA (A[A]N[A/N] NAA)', 'europe', 'en_GB', 'Royaume-Uni', 'ROYAUME-UNI', 'United Kingdom', 1, '2019-07-09 09:50:04', '2019-07-09 09:50:04'),
('826', 'GBR', 'GB', 44, '^[A-Z]{1,2}[0-9R][0-9A-Z]?\\s*[0-9][A-Z-[CIKMOV]]{2}', 'A(A)N(A/N)NAA (A[A]N[A/N] NAA)', 'europe', 'fr_FR', 'Royaume-Uni', 'ROYAUME-UNI', 'United Kingdom', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
REPLACE INTO `lang_country` (`lng`, `key_country`) VALUES
('en_GB', 'CZ'),
('fr_FR', 'CZ'),
('en_GB', 'GB'),
('fr_FR', 'GB');
```
- [x] Styleconnexion :
```
REPLACE INTO `geo_country` (`num`, `alpha3`, `alpha2`, `call_prefix`, `zip_regex`, `zip_format`, `key_zone`, `lng`, `name`, `iso_name`, `original_name`, `enabled`, `date_modification`, `date_creation`) VALUES
('203', 'CZE', 'CZ', 420, '^\\d{5}\\s\\(\\d{3}\\s\\d{2}\\)$', 'NNNNN (NNN NN)', 'europe', 'fr_FR', 'République tchèque', 'TCHÈQUE, RÉPUBLIQUE', 'Ceská Republika', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
('826', 'GBR', 'GB', 44, '^[A-Z]{1,2}[0-9R][0-9A-Z]?\\s*[0-9][A-Z-[CIKMOV]]{2}', 'A(A)N(A/N)NAA (A[A]N[A/N] NAA)', 'europe', 'fr_FR', 'Royaume-Uni', 'ROYAUME-UNI', 'United Kingdom', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
REPLACE INTO `lang_country` (`lng`, `key_country`) VALUES
('fr_FR', 'CZ'),
('fr_FR', 'GB');
REPLACE INTO `store_payment_mean_country` (`key_mean`, `key_country`) VALUES
('bank_transfer', 'CZ'),
('cash', 'CZ'),
('check', 'CZ'),
('credit_card', 'CZ'),
('creditnote', 'CZ'),
('paypal', 'CZ'),
('bank_transfer', 'GB'),
('cash', 'GB'),
('check', 'GB'),
('credit_card', 'GB'),
('creditnote', 'GB'),
('paypal', 'GB');
```
- [x] Timpartner :
```
REPLACE INTO `geo_country` (`num`, `alpha3`, `alpha2`, `call_prefix`, `zip_regex`, `zip_format`, `key_zone`, `lng`, `name`, `iso_name`, `original_name`, `enabled`, `date_modification`, `date_creation`) VALUES
('203', 'CZE', 'CZ', '420', '^\\d{5}\\s\\(\\d{3}\\s\\d{2}\\)$', 'NNNNN (NNN NN)', 'europe', 'fr_FR', 'République tchèque', 'TCHÈQUE, RÉPUBLIQUE', 'Ceská Republika', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
('826', 'GBR', 'GB', '44', '^[A-Z]{1,2}[0-9R][0-9A-Z]?\\s*[0-9][A-Z-[CIKMOV]]{2}', 'A(A)N(A/N)NAA (A[A]N[A/N] NAA)', 'europe', 'fr_FR', 'Royaume-Uni', 'ROYAUME-UNI', 'United Kingdom', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
REPLACE INTO `lang_country` (`lng`, `key_country`) VALUES
('fr_FR', 'CZ'),
('fr_FR', 'GB');
```
- [x] Toutfeu :
```
REPLACE INTO `geo_country` (`num`, `alpha3`, `alpha2`, `call_prefix`, `zip_regex`, `zip_format`, `key_zone`, `lng`, `name`, `iso_name`, `original_name`, `enabled`, `date_modification`, `date_creation`) VALUES
('203', 'CZE', 'CZ', 420, '^\\d{5}\\s\\(\\d{3}\\s\\d{2}\\)$', 'NNNNN (NNN NN)', 'europe', 'fr_FR', 'République tchèque', 'TCHÈQUE, RÉPUBLIQUE', 'Ceská Republika', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
('826', 'GBR', 'GB', 44, '^[A-Z]{1,2}[0-9R][0-9A-Z]?\\s*[0-9][A-Z-[CIKMOV]]{2}', 'A(A)N(A/N)NAA (A[A]N[A/N] NAA)', 'europe', 'fr_FR', 'Royaume-Uni', 'ROYAUME-UNI', 'United Kingdom', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
REPLACE INTO `lang_country` (`lng`, `key_country`) VALUES
('fr_FR', 'CZ'),
('fr_FR', 'GB');
REPLACE INTO `store_payment_mean_country` (`key_mean`, `key_country`) VALUES
('bank_transfer', 'CZ'),
('check', 'CZ'),
('credit_card', 'CZ'),
('creditnote', 'CZ'),
('paypal', 'CZ'),
('bank_transfer', 'GB'),
('check', 'GB'),
('credit_card', 'GB'),
('creditnote', 'GB'),
('paypal', 'GB');
```
Sign in with Wallet
Connect another wallet