---
# System prepended metadata

title: REPLACE countries

---

# 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');
```
