Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- --------------------------------------------------------
- -- Host: 127.0.0.1
- -- Server version: 5.6.11 - MySQL Community Server (GPL)
- -- Server OS: Win32
- -- HeidiSQL Version: 8.0.0.4396
- -- --------------------------------------------------------
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET NAMES utf8 */;
- /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
- /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
- -- Dumping data for table 1560a.ps_country: ~244 rows (approximately)
- DELETE FROM `ps_country`;
- /*!40000 ALTER TABLE `ps_country` DISABLE KEYS */;
- INSERT INTO `ps_country` (`id_country`, `id_zone`, `id_currency`, `iso_code`, `call_prefix`, `active`, `contains_states`, `need_identification_number`, `need_zip_code`, `zip_code_format`, `display_tax_label`) VALUES
- (1, 1, 0, 'DE', 49, 0, 0, 0, 1, 'NNNNN', 1),
- (2, 1, 0, 'AT', 43, 0, 0, 0, 1, 'NNNN', 1),
- (3, 1, 0, 'BE', 32, 0, 0, 0, 1, 'NNNN', 1),
- (4, 2, 0, 'CA', 1, 0, 1, 0, 1, 'LNL NLN', 0),
- (5, 3, 0, 'CN', 86, 0, 0, 0, 1, 'NNNNNN', 1),
- (6, 1, 0, 'ES', 34, 0, 0, 1, 1, 'NNNNN', 1),
- (7, 1, 0, 'FI', 358, 0, 0, 0, 1, 'NNNNN', 1),
- (8, 1, 0, 'FR', 33, 0, 0, 0, 1, 'NNNNN', 1),
- (9, 1, 0, 'GR', 30, 0, 0, 0, 1, 'NNNNN', 1),
- (10, 1, 0, 'IT', 39, 0, 1, 0, 1, 'NNNNN', 1),
- (11, 3, 0, 'JP', 81, 0, 1, 0, 1, 'NNN-NNNN', 1),
- (12, 1, 0, 'LU', 352, 0, 0, 0, 1, 'NNNN', 1),
- (13, 1, 0, 'NL', 31, 0, 0, 0, 1, 'NNNN LL', 1),
- (14, 1, 0, 'PL', 48, 0, 0, 0, 1, 'NN-NNN', 1),
- (15, 1, 0, 'PT', 351, 0, 0, 0, 1, 'NNNN NNN', 1),
- (16, 1, 0, 'CZ', 420, 0, 0, 0, 1, 'NNN NN', 1),
- (17, 1, 0, 'GB', 44, 1, 0, 0, 1, '', 1),
- (18, 1, 0, 'SE', 46, 0, 0, 0, 1, 'NNN NN', 1),
- (19, 7, 0, 'CH', 41, 0, 0, 0, 1, 'NNNN', 1),
- (20, 1, 0, 'DK', 45, 0, 0, 0, 1, 'NNNN', 1),
- (21, 2, 0, 'US', 1, 0, 1, 0, 1, 'NNNNN', 0),
- (22, 3, 0, 'HK', 852, 0, 0, 0, 0, '', 1),
- (23, 7, 0, 'NO', 47, 0, 0, 0, 1, 'NNNN', 1),
- (24, 5, 0, 'AU', 61, 0, 0, 0, 1, 'NNNN', 1),
- (25, 3, 0, 'SG', 65, 0, 0, 0, 1, 'NNNNNN', 1),
- (26, 1, 0, 'IE', 353, 0, 0, 0, 1, '', 1),
- (27, 5, 0, 'NZ', 64, 0, 0, 0, 1, 'NNNN', 1),
- (28, 3, 0, 'KR', 82, 0, 0, 0, 1, 'NNN-NNN', 1),
- (29, 3, 0, 'IL', 972, 0, 0, 0, 1, 'NNNNN', 1),
- (30, 4, 0, 'ZA', 27, 0, 0, 0, 1, 'NNNN', 1),
- (31, 4, 0, 'NG', 234, 0, 0, 0, 1, '', 1),
- (32, 4, 0, 'CI', 225, 0, 0, 0, 1, '', 1),
- (33, 4, 0, 'TG', 228, 0, 0, 0, 1, '', 1),
- (34, 6, 0, 'BO', 591, 0, 0, 0, 1, '', 1),
- (35, 4, 0, 'MU', 230, 0, 0, 0, 1, '', 1),
- (36, 1, 0, 'RO', 40, 0, 0, 0, 1, 'NNNNNN', 1),
- (37, 1, 0, 'SK', 421, 0, 0, 0, 1, 'NNN NN', 1),
- (38, 4, 0, 'DZ', 213, 0, 0, 0, 1, 'NNNNN', 1),
- (39, 2, 0, 'AS', 0, 0, 0, 0, 1, '', 1),
- (40, 7, 0, 'AD', 376, 0, 0, 0, 1, 'CNNN', 1),
- (41, 4, 0, 'AO', 244, 0, 0, 0, 0, '', 1),
- (42, 8, 0, 'AI', 0, 0, 0, 0, 1, '', 1),
- (43, 2, 0, 'AG', 0, 0, 0, 0, 1, '', 1),
- (44, 6, 0, 'AR', 54, 0, 1, 0, 1, 'LNNNN', 1),
- (45, 3, 0, 'AM', 374, 0, 0, 0, 1, 'NNNN', 1),
- (46, 8, 0, 'AW', 297, 0, 0, 0, 1, '', 1),
- (47, 3, 0, 'AZ', 994, 0, 0, 0, 1, 'CNNNN', 1),
- (48, 2, 0, 'BS', 0, 0, 0, 0, 1, '', 1),
- (49, 3, 0, 'BH', 973, 0, 0, 0, 1, '', 1),
- (50, 3, 0, 'BD', 880, 0, 0, 0, 1, 'NNNN', 1),
- (51, 2, 0, 'BB', 0, 0, 0, 0, 1, 'CNNNNN', 1),
- (52, 7, 0, 'BY', 0, 0, 0, 0, 1, 'NNNNNN', 1),
- (53, 8, 0, 'BZ', 501, 0, 0, 0, 0, '', 1),
- (54, 4, 0, 'BJ', 229, 0, 0, 0, 0, '', 1),
- (55, 2, 0, 'BM', 0, 0, 0, 0, 1, '', 1),
- (56, 3, 0, 'BT', 975, 0, 0, 0, 1, '', 1),
- (57, 4, 0, 'BW', 267, 0, 0, 0, 1, '', 1),
- (58, 6, 0, 'BR', 55, 0, 0, 0, 1, 'NNNNN-NNN', 1),
- (59, 3, 0, 'BN', 673, 0, 0, 0, 1, 'LLNNNN', 1),
- (60, 4, 0, 'BF', 226, 0, 0, 0, 1, '', 1),
- (61, 3, 0, 'MM', 95, 0, 0, 0, 1, '', 1),
- (62, 4, 0, 'BI', 257, 0, 0, 0, 1, '', 1),
- (63, 3, 0, 'KH', 855, 0, 0, 0, 1, 'NNNNN', 1),
- (64, 4, 0, 'CM', 237, 0, 0, 0, 1, '', 1),
- (65, 4, 0, 'CV', 238, 0, 0, 0, 1, 'NNNN', 1),
- (66, 4, 0, 'CF', 236, 0, 0, 0, 1, '', 1),
- (67, 4, 0, 'TD', 235, 0, 0, 0, 1, '', 1),
- (68, 6, 0, 'CL', 56, 0, 0, 0, 1, 'NNN-NNNN', 1),
- (69, 6, 0, 'CO', 57, 0, 0, 0, 1, 'NNNNNN', 1),
- (70, 4, 0, 'KM', 269, 0, 0, 0, 1, '', 1),
- (71, 4, 0, 'CD', 242, 0, 0, 0, 1, '', 1),
- (72, 4, 0, 'CG', 243, 0, 0, 0, 1, '', 1),
- (73, 8, 0, 'CR', 506, 0, 0, 0, 1, 'NNNNN', 1),
- (74, 7, 0, 'HR', 385, 0, 0, 0, 1, 'NNNNN', 1),
- (75, 8, 0, 'CU', 53, 0, 0, 0, 1, '', 1),
- (76, 1, 0, 'CY', 357, 0, 0, 0, 1, 'NNNN', 1),
- (77, 4, 0, 'DJ', 253, 0, 0, 0, 1, '', 1),
- (78, 8, 0, 'DM', 0, 0, 0, 0, 1, '', 1),
- (79, 8, 0, 'DO', 0, 0, 0, 0, 1, '', 1),
- (80, 3, 0, 'TL', 670, 0, 0, 0, 1, '', 1),
- (81, 6, 0, 'EC', 593, 0, 0, 0, 1, 'CNNNNNN', 1),
- (82, 4, 0, 'EG', 20, 0, 0, 0, 0, '', 1),
- (83, 8, 0, 'SV', 503, 0, 0, 0, 1, '', 1),
- (84, 4, 0, 'GQ', 240, 0, 0, 0, 1, '', 1),
- (85, 4, 0, 'ER', 291, 0, 0, 0, 1, '', 1),
- (86, 1, 0, 'EE', 372, 0, 0, 0, 1, 'NNNNN', 1),
- (87, 4, 0, 'ET', 251, 0, 0, 0, 1, '', 1),
- (88, 8, 0, 'FK', 0, 0, 0, 0, 1, 'LLLL NLL', 1),
- (89, 7, 0, 'FO', 298, 0, 0, 0, 1, '', 1),
- (90, 5, 0, 'FJ', 679, 0, 0, 0, 1, '', 1),
- (91, 4, 0, 'GA', 241, 0, 0, 0, 1, '', 1),
- (92, 4, 0, 'GM', 220, 0, 0, 0, 1, '', 1),
- (93, 3, 0, 'GE', 995, 0, 0, 0, 1, 'NNNN', 1),
- (94, 4, 0, 'GH', 233, 0, 0, 0, 1, '', 1),
- (95, 8, 0, 'GD', 0, 0, 0, 0, 1, '', 1),
- (96, 7, 0, 'GL', 299, 0, 0, 0, 1, '', 1),
- (97, 7, 0, 'GI', 350, 0, 0, 0, 1, '', 1),
- (98, 8, 0, 'GP', 590, 0, 0, 0, 1, '', 1),
- (99, 5, 0, 'GU', 0, 0, 0, 0, 1, '', 1),
- (100, 8, 0, 'GT', 502, 0, 0, 0, 1, '', 1),
- (101, 7, 0, 'GG', 0, 0, 0, 0, 1, 'LLN NLL', 1),
- (102, 4, 0, 'GN', 224, 0, 0, 0, 1, '', 1),
- (103, 4, 0, 'GW', 245, 0, 0, 0, 1, '', 1),
- (104, 6, 0, 'GY', 592, 0, 0, 0, 1, '', 1),
- (105, 8, 0, 'HT', 509, 0, 0, 0, 1, '', 1),
- (106, 5, 0, 'HM', 0, 0, 0, 0, 1, '', 1),
- (107, 7, 0, 'VA', 379, 0, 0, 0, 1, 'NNNNN', 1),
- (108, 8, 0, 'HN', 504, 0, 0, 0, 1, '', 1),
- (109, 7, 0, 'IS', 354, 0, 0, 0, 1, 'NNN', 1),
- (110, 3, 0, 'IN', 91, 0, 0, 0, 1, 'NNN NNN', 1),
- (111, 3, 0, 'ID', 62, 0, 1, 0, 1, 'NNNNN', 1),
- (112, 3, 0, 'IR', 98, 0, 0, 0, 1, 'NNNNN-NNNNN', 1),
- (113, 3, 0, 'IQ', 964, 0, 0, 0, 1, 'NNNNN', 1),
- (114, 7, 0, 'IM', 0, 0, 0, 0, 1, 'CN NLL', 1),
- (115, 8, 0, 'JM', 0, 0, 0, 0, 1, '', 1),
- (116, 7, 0, 'JE', 0, 0, 0, 0, 1, 'CN NLL', 1),
- (117, 3, 0, 'JO', 962, 0, 0, 0, 1, '', 1),
- (118, 3, 0, 'KZ', 7, 0, 0, 0, 1, 'NNNNNN', 1),
- (119, 4, 0, 'KE', 254, 0, 0, 0, 1, '', 1),
- (120, 5, 0, 'KI', 686, 0, 0, 0, 1, '', 1),
- (121, 3, 0, 'KP', 850, 0, 0, 0, 1, '', 1),
- (122, 3, 0, 'KW', 965, 0, 0, 0, 1, '', 1),
- (123, 3, 0, 'KG', 996, 0, 0, 0, 1, '', 1),
- (124, 3, 0, 'LA', 856, 0, 0, 0, 1, '', 1),
- (125, 1, 0, 'LV', 371, 0, 0, 0, 1, 'C-NNNN', 1),
- (126, 3, 0, 'LB', 961, 0, 0, 0, 1, '', 1),
- (127, 4, 0, 'LS', 266, 0, 0, 0, 1, '', 1),
- (128, 4, 0, 'LR', 231, 0, 0, 0, 1, '', 1),
- (129, 4, 0, 'LY', 218, 0, 0, 0, 1, '', 1),
- (130, 1, 0, 'LI', 423, 0, 0, 0, 1, 'NNNN', 1),
- (131, 1, 0, 'LT', 370, 0, 0, 0, 1, 'NNNNN', 1),
- (132, 3, 0, 'MO', 853, 0, 0, 0, 0, '', 1),
- (133, 7, 0, 'MK', 389, 0, 0, 0, 1, '', 1),
- (134, 4, 0, 'MG', 261, 0, 0, 0, 1, '', 1),
- (135, 4, 0, 'MW', 265, 0, 0, 0, 1, '', 1),
- (136, 3, 0, 'MY', 60, 0, 0, 0, 1, 'NNNNN', 1),
- (137, 3, 0, 'MV', 960, 0, 0, 0, 1, '', 1),
- (138, 4, 0, 'ML', 223, 0, 0, 0, 1, '', 1),
- (139, 1, 0, 'MT', 356, 0, 0, 0, 1, 'LLL NNNN', 1),
- (140, 5, 0, 'MH', 692, 0, 0, 0, 1, '', 1),
- (141, 8, 0, 'MQ', 596, 0, 0, 0, 1, '', 1),
- (142, 4, 0, 'MR', 222, 0, 0, 0, 1, '', 1),
- (143, 1, 0, 'HU', 36, 0, 0, 0, 1, 'NNNN', 1),
- (144, 4, 0, 'YT', 262, 0, 0, 0, 1, '', 1),
- (145, 2, 0, 'MX', 52, 0, 1, 1, 1, 'NNNNN', 1),
- (146, 5, 0, 'FM', 691, 0, 0, 0, 1, '', 1),
- (147, 7, 0, 'MD', 373, 0, 0, 0, 1, 'C-NNNN', 1),
- (148, 7, 0, 'MC', 377, 0, 0, 0, 1, '980NN', 1),
- (149, 3, 0, 'MN', 976, 0, 0, 0, 1, '', 1),
- (150, 7, 0, 'ME', 382, 0, 0, 0, 1, 'NNNNN', 1),
- (151, 8, 0, 'MS', 0, 0, 0, 0, 1, '', 1),
- (152, 4, 0, 'MA', 212, 0, 0, 0, 1, 'NNNNN', 1),
- (153, 4, 0, 'MZ', 258, 0, 0, 0, 1, '', 1),
- (154, 4, 0, 'NA', 264, 0, 0, 0, 1, '', 1),
- (155, 5, 0, 'NR', 674, 0, 0, 0, 1, '', 1),
- (156, 3, 0, 'NP', 977, 0, 0, 0, 1, '', 1),
- (157, 8, 0, 'AN', 599, 0, 0, 0, 1, '', 1),
- (158, 5, 0, 'NC', 687, 0, 0, 0, 1, '', 1),
- (159, 8, 0, 'NI', 505, 0, 0, 0, 1, 'NNNNNN', 1),
- (160, 4, 0, 'NE', 227, 0, 0, 0, 1, '', 1),
- (161, 5, 0, 'NU', 683, 0, 0, 0, 1, '', 1),
- (162, 5, 0, 'NF', 0, 0, 0, 0, 1, '', 1),
- (163, 5, 0, 'MP', 0, 0, 0, 0, 1, '', 1),
- (164, 3, 0, 'OM', 968, 0, 0, 0, 1, '', 1),
- (165, 3, 0, 'PK', 92, 0, 0, 0, 1, '', 1),
- (166, 5, 0, 'PW', 680, 0, 0, 0, 1, '', 1),
- (167, 3, 0, 'PS', 0, 0, 0, 0, 1, '', 1),
- (168, 8, 0, 'PA', 507, 0, 0, 0, 1, 'NNNNNN', 1),
- (169, 5, 0, 'PG', 675, 0, 0, 0, 1, '', 1),
- (170, 6, 0, 'PY', 595, 0, 0, 0, 1, '', 1),
- (171, 6, 0, 'PE', 51, 0, 0, 0, 1, '', 1),
- (172, 3, 0, 'PH', 63, 0, 0, 0, 1, 'NNNN', 1),
- (173, 5, 0, 'PN', 0, 0, 0, 0, 1, 'LLLL NLL', 1),
- (174, 8, 0, 'PR', 0, 0, 0, 0, 1, 'NNNNN', 1),
- (175, 3, 0, 'QA', 974, 0, 0, 0, 1, '', 1),
- (176, 4, 0, 'RE', 262, 0, 0, 0, 1, '', 1),
- (177, 7, 0, 'RU', 7, 0, 0, 0, 1, 'NNNNNN', 1),
- (178, 4, 0, 'RW', 250, 0, 0, 0, 1, '', 1),
- (179, 8, 0, 'BL', 0, 0, 0, 0, 1, '', 1),
- (180, 8, 0, 'KN', 0, 0, 0, 0, 1, '', 1),
- (181, 8, 0, 'LC', 0, 0, 0, 0, 1, '', 1),
- (182, 8, 0, 'MF', 0, 0, 0, 0, 1, '', 1),
- (183, 8, 0, 'PM', 508, 0, 0, 0, 1, '', 1),
- (184, 8, 0, 'VC', 0, 0, 0, 0, 1, '', 1),
- (185, 5, 0, 'WS', 685, 0, 0, 0, 1, '', 1),
- (186, 7, 0, 'SM', 378, 0, 0, 0, 1, 'NNNNN', 1),
- (187, 4, 0, 'ST', 239, 0, 0, 0, 1, '', 1),
- (188, 3, 0, 'SA', 966, 0, 0, 0, 1, '', 1),
- (189, 4, 0, 'SN', 221, 0, 0, 0, 1, '', 1),
- (190, 7, 0, 'RS', 381, 0, 0, 0, 1, 'NNNNN', 1),
- (191, 4, 0, 'SC', 248, 0, 0, 0, 1, '', 1),
- (192, 4, 0, 'SL', 232, 0, 0, 0, 1, '', 1),
- (193, 1, 0, 'SI', 386, 0, 0, 0, 1, 'C-NNNN', 1),
- (194, 5, 0, 'SB', 677, 0, 0, 0, 1, '', 1),
- (195, 4, 0, 'SO', 252, 0, 0, 0, 1, '', 1),
- (196, 8, 0, 'GS', 0, 0, 0, 0, 1, 'LLLL NLL', 1),
- (197, 3, 0, 'LK', 94, 0, 0, 0, 1, 'NNNNN', 1),
- (198, 4, 0, 'SD', 249, 0, 0, 0, 1, '', 1),
- (199, 8, 0, 'SR', 597, 0, 0, 0, 1, '', 1),
- (200, 7, 0, 'SJ', 0, 0, 0, 0, 1, '', 1),
- (201, 4, 0, 'SZ', 268, 0, 0, 0, 1, '', 1),
- (202, 3, 0, 'SY', 963, 0, 0, 0, 1, '', 1),
- (203, 3, 0, 'TW', 886, 0, 0, 0, 1, 'NNNNN', 1),
- (204, 3, 0, 'TJ', 992, 0, 0, 0, 1, '', 1),
- (205, 4, 0, 'TZ', 255, 0, 0, 0, 1, '', 1),
- (206, 3, 0, 'TH', 66, 0, 0, 0, 1, 'NNNNN', 1),
- (207, 5, 0, 'TK', 690, 0, 0, 0, 1, '', 1),
- (208, 5, 0, 'TO', 676, 0, 0, 0, 1, '', 1),
- (209, 6, 0, 'TT', 0, 0, 0, 0, 1, '', 1),
- (210, 4, 0, 'TN', 216, 0, 0, 0, 1, '', 1),
- (211, 7, 0, 'TR', 90, 0, 0, 0, 1, 'NNNNN', 1),
- (212, 3, 0, 'TM', 993, 0, 0, 0, 1, '', 1),
- (213, 8, 0, 'TC', 0, 0, 0, 0, 1, 'LLLL NLL', 1),
- (214, 5, 0, 'TV', 688, 0, 0, 0, 1, '', 1),
- (215, 4, 0, 'UG', 256, 0, 0, 0, 1, '', 1),
- (216, 1, 0, 'UA', 380, 0, 0, 0, 1, 'NNNNN', 1),
- (217, 3, 0, 'AE', 971, 0, 0, 0, 1, '', 1),
- (218, 6, 0, 'UY', 598, 0, 0, 0, 1, '', 1),
- (219, 3, 0, 'UZ', 998, 0, 0, 0, 1, '', 1),
- (220, 5, 0, 'VU', 678, 0, 0, 0, 1, '', 1),
- (221, 6, 0, 'VE', 58, 0, 0, 0, 1, '', 1),
- (222, 3, 0, 'VN', 84, 0, 0, 0, 1, 'NNNNNN', 1),
- (223, 2, 0, 'VG', 0, 0, 0, 0, 1, 'CNNNN', 1),
- (224, 2, 0, 'VI', 0, 0, 0, 0, 1, '', 1),
- (225, 5, 0, 'WF', 681, 0, 0, 0, 1, '', 1),
- (226, 4, 0, 'EH', 0, 0, 0, 0, 1, '', 1),
- (227, 3, 0, 'YE', 967, 0, 0, 0, 1, '', 1),
- (228, 4, 0, 'ZM', 260, 0, 0, 0, 1, '', 1),
- (229, 4, 0, 'ZW', 263, 0, 0, 0, 1, '', 1),
- (230, 7, 0, 'AL', 355, 0, 0, 0, 1, 'NNNN', 1),
- (231, 3, 0, 'AF', 93, 0, 0, 0, 0, '', 1),
- (232, 5, 0, 'AQ', 0, 0, 0, 0, 1, '', 1),
- (233, 1, 0, 'BA', 387, 0, 0, 0, 1, '', 1),
- (234, 5, 0, 'BV', 0, 0, 0, 0, 1, '', 1),
- (235, 5, 0, 'IO', 0, 0, 0, 0, 1, 'LLLL NLL', 1),
- (236, 1, 0, 'BG', 359, 0, 0, 0, 1, 'NNNN', 1),
- (237, 8, 0, 'KY', 0, 0, 0, 0, 1, '', 1),
- (238, 3, 0, 'CX', 0, 0, 0, 0, 1, '', 1),
- (239, 3, 0, 'CC', 0, 0, 0, 0, 1, '', 1),
- (240, 5, 0, 'CK', 682, 0, 0, 0, 1, '', 1),
- (241, 6, 0, 'GF', 594, 0, 0, 0, 1, '', 1),
- (242, 5, 0, 'PF', 689, 0, 0, 0, 1, '', 1),
- (243, 5, 0, 'TF', 0, 0, 0, 0, 1, '', 1),
- (244, 7, 0, 'AX', 0, 0, 0, 0, 1, 'NNNNN', 1);
- /*!40000 ALTER TABLE `ps_country` ENABLE KEYS */;
- -- Dumping data for table 1560a.ps_country_lang: ~485 rows (approximately)
- DELETE FROM `ps_country_lang`;
- /*!40000 ALTER TABLE `ps_country_lang` DISABLE KEYS */;
- INSERT INTO `ps_country_lang` (`id_country`, `id_lang`, `name`) VALUES
- (1, 1, 'Germany'),
- (1, 2, 'Germany'),
- (2, 1, 'Austria'),
- (2, 2, 'Austria'),
- (3, 1, 'Belgium'),
- (3, 2, 'Belgium'),
- (4, 1, 'Canada'),
- (4, 2, 'Canada'),
- (5, 1, 'China'),
- (5, 2, 'China'),
- (6, 1, 'Spain'),
- (6, 2, 'Spain'),
- (7, 1, 'Finland'),
- (7, 2, 'Finland'),
- (8, 1, 'France'),
- (8, 2, 'France'),
- (9, 1, 'Greece'),
- (9, 2, 'Greece'),
- (10, 1, 'Italy'),
- (10, 2, 'Italy'),
- (11, 1, 'Japan'),
- (11, 2, 'Japan'),
- (12, 1, 'Luxemburg'),
- (12, 2, 'Luxemburg'),
- (13, 1, 'Netherlands'),
- (13, 2, 'Netherlands'),
- (14, 1, 'Poland'),
- (14, 2, 'Poland'),
- (15, 1, 'Portugal'),
- (15, 2, 'Portugal'),
- (16, 1, 'Czech Republic'),
- (16, 2, 'Czech Republic'),
- (17, 1, 'United Kingdom'),
- (17, 2, 'United Kingdom'),
- (18, 1, 'Sweden'),
- (18, 2, 'Sweden'),
- (19, 1, 'Switzerland'),
- (19, 2, 'Switzerland'),
- (20, 1, 'Denmark'),
- (20, 2, 'Denmark'),
- (21, 1, 'United States'),
- (21, 2, 'United States'),
- (22, 1, 'HongKong'),
- (22, 2, 'HongKong'),
- (23, 1, 'Norway'),
- (23, 2, 'Norway'),
- (24, 1, 'Australia'),
- (24, 2, 'Australia'),
- (25, 1, 'Singapore'),
- (25, 2, 'Singapore'),
- (26, 1, 'Ireland'),
- (26, 2, 'Ireland'),
- (27, 1, 'New Zealand'),
- (27, 2, 'New Zealand'),
- (28, 1, 'South Korea'),
- (28, 2, 'South Korea'),
- (29, 1, 'Israel'),
- (29, 2, 'Israel'),
- (30, 1, 'South Africa'),
- (30, 2, 'South Africa'),
- (31, 1, 'Nigeria'),
- (31, 2, 'Nigeria'),
- (32, 1, 'Ivory Coast'),
- (32, 2, 'Ivory Coast'),
- (33, 1, 'Togo'),
- (33, 2, 'Togo'),
- (34, 1, 'Bolivia'),
- (34, 2, 'Bolivia'),
- (35, 1, 'Mauritius'),
- (35, 2, 'Mauritius'),
- (36, 1, 'Romania'),
- (36, 2, 'Romania'),
- (37, 1, 'Slovakia'),
- (37, 2, 'Slovakia'),
- (38, 1, 'Algeria'),
- (38, 2, 'Algeria'),
- (39, 1, 'American Samoa'),
- (39, 2, 'American Samoa'),
- (40, 1, 'Andorra'),
- (40, 2, 'Andorra'),
- (41, 1, 'Angola'),
- (41, 2, 'Angola'),
- (42, 1, 'Anguilla'),
- (42, 2, 'Anguilla'),
- (43, 1, 'Antigua and Barbuda'),
- (43, 2, 'Antigua and Barbuda'),
- (44, 1, 'Argentina'),
- (44, 2, 'Argentina'),
- (45, 1, 'Armenia'),
- (45, 2, 'Armenia'),
- (46, 1, 'Aruba'),
- (46, 2, 'Aruba'),
- (47, 1, 'Azerbaijan'),
- (47, 2, 'Azerbaijan'),
- (48, 1, 'Bahamas'),
- (48, 2, 'Bahamas'),
- (49, 1, 'Bahrain'),
- (49, 2, 'Bahrain'),
- (50, 1, 'Bangladesh'),
- (50, 2, 'Bangladesh'),
- (51, 1, 'Barbados'),
- (51, 2, 'Barbados'),
- (52, 1, 'Belarus'),
- (52, 2, 'Belarus'),
- (53, 1, 'Belize'),
- (53, 2, 'Belize'),
- (54, 1, 'Benin'),
- (54, 2, 'Benin'),
- (55, 1, 'Bermuda'),
- (55, 2, 'Bermuda'),
- (56, 1, 'Bhutan'),
- (56, 2, 'Bhutan'),
- (57, 1, 'Botswana'),
- (57, 2, 'Botswana'),
- (58, 1, 'Brazil'),
- (58, 2, 'Brazil'),
- (59, 1, 'Brunei'),
- (59, 2, 'Brunei'),
- (60, 1, 'Burkina Faso'),
- (60, 2, 'Burkina Faso'),
- (61, 1, 'Burma (Myanmar)'),
- (61, 2, 'Burma (Myanmar)'),
- (62, 1, 'Burundi'),
- (62, 2, 'Burundi'),
- (63, 1, 'Cambodia'),
- (63, 2, 'Cambodia'),
- (64, 1, 'Cameroon'),
- (64, 2, 'Cameroon'),
- (65, 1, 'Cape Verde'),
- (65, 2, 'Cape Verde'),
- (66, 1, 'Central African Republic'),
- (66, 2, 'Central African Republic'),
- (67, 1, 'Chad'),
- (67, 2, 'Chad'),
- (68, 1, 'Chile'),
- (68, 2, 'Chile'),
- (69, 1, 'Colombia'),
- (69, 2, 'Colombia'),
- (70, 1, 'Comoros'),
- (70, 2, 'Comoros'),
- (71, 1, 'Congo, Dem. Republic'),
- (71, 2, 'Congo, Dem. Republic'),
- (72, 1, 'Congo, Republic'),
- (72, 2, 'Congo, Republic'),
- (73, 1, 'Costa Rica'),
- (73, 2, 'Costa Rica'),
- (74, 1, 'Croatia'),
- (74, 2, 'Croatia'),
- (75, 1, 'Cuba'),
- (75, 2, 'Cuba'),
- (76, 1, 'Cyprus'),
- (76, 2, 'Cyprus'),
- (77, 1, 'Djibouti'),
- (77, 2, 'Djibouti'),
- (78, 1, 'Dominica'),
- (78, 2, 'Dominica'),
- (79, 1, 'Dominican Republic'),
- (79, 2, 'Dominican Republic'),
- (80, 1, 'East Timor'),
- (80, 2, 'East Timor'),
- (81, 1, 'Ecuador'),
- (81, 2, 'Ecuador'),
- (82, 1, 'Egypt'),
- (82, 2, 'Egypt'),
- (83, 1, 'El Salvador'),
- (83, 2, 'El Salvador'),
- (84, 1, 'Equatorial Guinea'),
- (84, 2, 'Equatorial Guinea'),
- (85, 1, 'Eritrea'),
- (85, 2, 'Eritrea'),
- (86, 1, 'Estonia'),
- (86, 2, 'Estonia'),
- (87, 1, 'Ethiopia'),
- (87, 2, 'Ethiopia'),
- (88, 1, 'Falkland Islands'),
- (88, 2, 'Falkland Islands'),
- (89, 1, 'Faroe Islands'),
- (89, 2, 'Faroe Islands'),
- (90, 1, 'Fiji'),
- (90, 2, 'Fiji'),
- (91, 1, 'Gabon'),
- (91, 2, 'Gabon'),
- (92, 1, 'Gambia'),
- (92, 2, 'Gambia'),
- (93, 1, 'Georgia'),
- (93, 2, 'Georgia'),
- (94, 1, 'Ghana'),
- (94, 2, 'Ghana'),
- (95, 1, 'Grenada'),
- (95, 2, 'Grenada'),
- (96, 1, 'Greenland'),
- (96, 2, 'Greenland'),
- (97, 1, 'Gibraltar'),
- (97, 2, 'Gibraltar'),
- (98, 1, 'Guadeloupe'),
- (98, 2, 'Guadeloupe'),
- (99, 1, 'Guam'),
- (99, 2, 'Guam'),
- (100, 1, 'Guatemala'),
- (100, 2, 'Guatemala'),
- (101, 1, 'Guernsey'),
- (101, 2, 'Guernsey'),
- (102, 1, 'Guinea'),
- (102, 2, 'Guinea'),
- (103, 1, 'Guinea-Bissau'),
- (103, 2, 'Guinea-Bissau'),
- (104, 1, 'Guyana'),
- (104, 2, 'Guyana'),
- (105, 1, 'Haiti'),
- (105, 2, 'Haiti'),
- (106, 1, 'Heard Island and McDonald Islands'),
- (106, 2, 'Heard Island and McDonald Islands'),
- (107, 1, 'Vatican City State'),
- (107, 2, 'Vatican City State'),
- (108, 1, 'Honduras'),
- (108, 2, 'Honduras'),
- (109, 1, 'Iceland'),
- (109, 2, 'Iceland'),
- (110, 1, 'India'),
- (110, 2, 'India'),
- (111, 1, 'Indonesia'),
- (111, 2, 'Indonesia'),
- (112, 1, 'Iran'),
- (112, 2, 'Iran'),
- (113, 1, 'Iraq'),
- (113, 2, 'Iraq'),
- (114, 1, 'Man Island'),
- (114, 2, 'Man Island'),
- (115, 1, 'Jamaica'),
- (115, 2, 'Jamaica'),
- (116, 1, 'Jersey'),
- (116, 2, 'Jersey'),
- (117, 1, 'Jordan'),
- (117, 2, 'Jordan'),
- (118, 1, 'Kazakhstan'),
- (118, 2, 'Kazakhstan'),
- (119, 1, 'Kenya'),
- (119, 2, 'Kenya'),
- (120, 1, 'Kiribati'),
- (120, 2, 'Kiribati'),
- (121, 1, 'Korea, Dem. Republic of'),
- (121, 2, 'Korea, Dem. Republic of'),
- (122, 1, 'Kuwait'),
- (122, 2, 'Kuwait'),
- (123, 1, 'Kyrgyzstan'),
- (123, 2, 'Kyrgyzstan'),
- (124, 1, 'Laos'),
- (124, 2, 'Laos'),
- (125, 1, 'Latvia'),
- (125, 2, 'Latvia'),
- (126, 1, 'Lebanon'),
- (126, 2, 'Lebanon'),
- (127, 1, 'Lesotho'),
- (127, 2, 'Lesotho'),
- (128, 1, 'Liberia'),
- (128, 2, 'Liberia'),
- (129, 1, 'Libya'),
- (129, 2, 'Libya'),
- (130, 1, 'Liechtenstein'),
- (130, 2, 'Liechtenstein'),
- (131, 1, 'Lithuania'),
- (131, 2, 'Lithuania'),
- (132, 1, 'Macau'),
- (132, 2, 'Macau'),
- (133, 1, 'Macedonia'),
- (133, 2, 'Macedonia'),
- (134, 1, 'Madagascar'),
- (134, 2, 'Madagascar'),
- (135, 1, 'Malawi'),
- (135, 2, 'Malawi'),
- (136, 1, 'Malaysia'),
- (136, 2, 'Malaysia'),
- (137, 1, 'Maldives'),
- (137, 2, 'Maldives'),
- (138, 1, 'Mali'),
- (138, 2, 'Mali'),
- (139, 1, 'Malta'),
- (139, 2, 'Malta'),
- (140, 1, 'Marshall Islands'),
- (140, 2, 'Marshall Islands'),
- (141, 1, 'Martinique'),
- (141, 2, 'Martinique'),
- (142, 1, 'Mauritania'),
- (142, 2, 'Mauritania'),
- (143, 1, 'Hungary'),
- (143, 2, 'Hungary'),
- (144, 1, 'Mayotte'),
- (144, 2, 'Mayotte'),
- (145, 1, 'Mexico'),
- (145, 2, 'Mexico'),
- (146, 1, 'Micronesia'),
- (146, 2, 'Micronesia'),
- (147, 1, 'Moldova'),
- (147, 2, 'Moldova'),
- (148, 1, 'Monaco'),
- (148, 2, 'Monaco'),
- (149, 1, 'Mongolia'),
- (149, 2, 'Mongolia'),
- (150, 1, 'Montenegro'),
- (150, 2, 'Montenegro'),
- (151, 1, 'Montserrat'),
- (151, 2, 'Montserrat'),
- (152, 1, 'Morocco'),
- (152, 2, 'Morocco'),
- (153, 1, 'Mozambique'),
- (153, 2, 'Mozambique'),
- (154, 1, 'Namibia'),
- (154, 2, 'Namibia'),
- (155, 1, 'Nauru'),
- (155, 2, 'Nauru'),
- (156, 1, 'Nepal'),
- (156, 2, 'Nepal'),
- (157, 1, 'Netherlands Antilles'),
- (157, 2, 'Netherlands Antilles'),
- (158, 1, 'New Caledonia'),
- (158, 2, 'New Caledonia'),
- (159, 1, 'Nicaragua'),
- (159, 2, 'Nicaragua'),
- (160, 1, 'Niger'),
- (160, 2, 'Niger'),
- (161, 1, 'Niue'),
- (161, 2, 'Niue'),
- (162, 1, 'Norfolk Island'),
- (162, 2, 'Norfolk Island'),
- (163, 1, 'Northern Mariana Islands'),
- (163, 2, 'Northern Mariana Islands'),
- (164, 1, 'Oman'),
- (164, 2, 'Oman'),
- (165, 1, 'Pakistan'),
- (165, 2, 'Pakistan'),
- (166, 1, 'Palau'),
- (166, 2, 'Palau'),
- (167, 1, 'Palestinian Territories'),
- (167, 2, 'Palestinian Territories'),
- (168, 1, 'Panama'),
- (168, 2, 'Panama'),
- (169, 1, 'Papua New Guinea'),
- (169, 2, 'Papua New Guinea'),
- (170, 1, 'Paraguay'),
- (170, 2, 'Paraguay'),
- (171, 1, 'Peru'),
- (171, 2, 'Peru'),
- (172, 1, 'Philippines'),
- (172, 2, 'Philippines'),
- (173, 1, 'Pitcairn'),
- (173, 2, 'Pitcairn'),
- (174, 1, 'Puerto Rico'),
- (174, 2, 'Puerto Rico'),
- (175, 1, 'Qatar'),
- (175, 2, 'Qatar'),
- (176, 1, 'Reunion Island'),
- (176, 2, 'Reunion Island'),
- (177, 1, 'Russian Federation'),
- (177, 2, 'Russian Federation'),
- (178, 1, 'Rwanda'),
- (178, 2, 'Rwanda'),
- (179, 1, 'Saint Barthelemy'),
- (179, 2, 'Saint Barthelemy'),
- (180, 1, 'Saint Kitts and Nevis'),
- (180, 2, 'Saint Kitts and Nevis'),
- (181, 1, 'Saint Lucia'),
- (181, 2, 'Saint Lucia'),
- (182, 1, 'Saint Martin'),
- (182, 2, 'Saint Martin'),
- (183, 1, 'Saint Pierre and Miquelon'),
- (183, 2, 'Saint Pierre and Miquelon'),
- (184, 1, 'Saint Vincent and the Grenadines'),
- (184, 2, 'Saint Vincent and the Grenadines'),
- (185, 1, 'Samoa'),
- (185, 2, 'Samoa'),
- (186, 1, 'San Marino'),
- (186, 2, 'San Marino'),
- (187, 1, 'São Tomé and Príncipe'),
- (187, 2, 'São Tomé and Príncipe'),
- (188, 1, 'Saudi Arabia'),
- (188, 2, 'Saudi Arabia'),
- (189, 1, 'Senegal'),
- (189, 2, 'Senegal'),
- (190, 1, 'Serbia'),
- (190, 2, 'Serbia'),
- (191, 1, 'Seychelles'),
- (191, 2, 'Seychelles'),
- (192, 1, 'Sierra Leone'),
- (192, 2, 'Sierra Leone'),
- (193, 1, 'Slovenia'),
- (193, 2, 'Slovenia'),
- (194, 1, 'Solomon Islands'),
- (194, 2, 'Solomon Islands'),
- (195, 1, 'Somalia'),
- (195, 2, 'Somalia'),
- (196, 1, 'South Georgia and the South Sandwich Islands'),
- (196, 2, 'South Georgia and the South Sandwich Islands'),
- (197, 1, 'Sri Lanka'),
- (197, 2, 'Sri Lanka'),
- (198, 1, 'Sudan'),
- (198, 2, 'Sudan'),
- (199, 1, 'Suriname'),
- (199, 2, 'Suriname'),
- (200, 1, 'Svalbard and Jan Mayen'),
- (200, 2, 'Svalbard and Jan Mayen'),
- (201, 1, 'Swaziland'),
- (201, 2, 'Swaziland'),
- (202, 1, 'Syria'),
- (202, 2, 'Syria'),
- (203, 1, 'Taiwan'),
- (203, 2, 'Taiwan'),
- (204, 1, 'Tajikistan'),
- (204, 2, 'Tajikistan'),
- (205, 1, 'Tanzania'),
- (205, 2, 'Tanzania'),
- (206, 1, 'Thailand'),
- (206, 2, 'Thailand'),
- (207, 1, 'Tokelau'),
- (207, 2, 'Tokelau'),
- (208, 1, 'Tonga'),
- (208, 2, 'Tonga'),
- (209, 1, 'Trinidad and Tobago'),
- (209, 2, 'Trinidad and Tobago'),
- (210, 1, 'Tunisia'),
- (210, 2, 'Tunisia'),
- (211, 1, 'Turkey'),
- (211, 2, 'Turkey'),
- (212, 1, 'Turkmenistan'),
- (212, 2, 'Turkmenistan'),
- (213, 1, 'Turks and Caicos Islands'),
- (213, 2, 'Turks and Caicos Islands'),
- (214, 1, 'Tuvalu'),
- (214, 2, 'Tuvalu'),
- (215, 1, 'Uganda'),
- (215, 2, 'Uganda'),
- (216, 1, 'Ukraine'),
- (216, 2, 'Ukraine'),
- (217, 1, 'United Arab Emirates'),
- (217, 2, 'United Arab Emirates'),
- (218, 1, 'Uruguay'),
- (218, 2, 'Uruguay'),
- (219, 1, 'Uzbekistan'),
- (219, 2, 'Uzbekistan'),
- (220, 1, 'Vanuatu'),
- (220, 2, 'Vanuatu'),
- (221, 1, 'Venezuela'),
- (221, 2, 'Venezuela'),
- (222, 1, 'Vietnam'),
- (222, 2, 'Vietnam'),
- (223, 1, 'Virgin Islands (British)'),
- (223, 2, 'Virgin Islands (British)'),
- (224, 1, 'Virgin Islands (U.S.)'),
- (224, 2, 'Virgin Islands (U.S.)'),
- (225, 1, 'Wallis and Futuna'),
- (225, 2, 'Wallis and Futuna'),
- (226, 1, 'Western Sahara'),
- (226, 2, 'Western Sahara'),
- (227, 1, 'Yemen'),
- (227, 2, 'Yemen'),
- (228, 1, 'Zambia'),
- (228, 2, 'Zambia'),
- (229, 1, 'Zimbabwe'),
- (229, 2, 'Zimbabwe'),
- (230, 1, 'Albania'),
- (230, 2, 'Albania'),
- (231, 1, 'Afghanistan'),
- (231, 2, 'Afghanistan'),
- (232, 1, 'Antarctica'),
- (232, 2, 'Antarctica'),
- (233, 1, 'Bosnia and Herzegovina'),
- (233, 2, 'Bosnia and Herzegovina'),
- (234, 1, 'Bouvet Island'),
- (234, 2, 'Bouvet Island'),
- (235, 1, 'British Indian Ocean Territory'),
- (235, 2, 'British Indian Ocean Territory'),
- (236, 1, 'Bulgaria'),
- (236, 2, 'Bulgaria'),
- (237, 1, 'Cayman Islands'),
- (237, 2, 'Cayman Islands'),
- (238, 1, 'Christmas Island'),
- (238, 2, 'Christmas Island'),
- (239, 1, 'Cocos (Keeling) Islands'),
- (239, 2, 'Cocos (Keeling) Islands'),
- (240, 1, 'Cook Islands'),
- (240, 2, 'Cook Islands'),
- (241, 1, 'French Guiana'),
- (241, 2, 'French Guiana'),
- (242, 1, 'French Polynesia'),
- (242, 2, 'French Polynesia'),
- (243, 1, 'French Southern Territories'),
- (243, 2, 'French Southern Territories'),
- (244, 1, 'Åland Islands'),
- (244, 2, 'Åland Islands');
- /*!40000 ALTER TABLE `ps_country_lang` ENABLE KEYS */;
- -- Dumping data for table 1560a.ps_country_shop: ~488 rows (approximately)
- DELETE FROM `ps_country_shop`;
- /*!40000 ALTER TABLE `ps_country_shop` DISABLE KEYS */;
- INSERT INTO `ps_country_shop` (`id_country`, `id_shop`/*!40000 ALTER TABLE `ps_country_shop` ENABLE KEYS */;
- /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
- /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
Advertisement
Add Comment
Please, Sign In to add comment