INSERT INTO `oc_country` (`country_id`, `name`, `iso_code_2`, `iso_code_3`, `address_format`, `postcode_required`, `status`) VALUES
(195, '西班牙(Spain)', 'ES', 'ESP', '', 0, 1),
(194, '南乔治亚岛和南桑威奇群岛(South Georgia & South Sandwich Islands)', 'GS', 'SGS', '', 0, 1),
(192, '索马里(Somalia)', 'SO', 'SOM', '', 0, 1),
(191, '所罗门群岛(Solomon Islands)', 'SB', 'SLB', '', 0, 1),
(190, '斯洛文尼亚(Slovenia)', 'SI', 'SVN', '', 0, 1),
(188, '新加坡(Singapore)', 'SG', 'SGP', '', 0, 1),
(187, '塞拉利昂(Sierra Leone)', 'SL', 'SLE', '', 0, 1),
(186, '塞舌尔(Seychelles)', 'SC', 'SYC', '', 0, 1),
(185, '塞内加尔(Senegal)', 'SN', 'SEN', '', 0, 1),
(184, '沙特阿拉伯(Saudi Arabia)', 'SA', 'SAU', '', 0, 1),
(181, '萨摩亚(Samoa)', 'WS', 'WSM', '', 0, 1),
(182, '圣马力诺(San Marino)', 'SM', 'SMR', '', 0, 1),
(180, '圣文森特和格林纳丁斯(Saint Vincent and the Grenadines)', 'VC', 'VCT', '', 0, 1),
(179, '圣卢西亚岛(Saint Lucia)', 'LC', 'LCA', '', 0, 1),
(178, '圣基茨和尼维斯(Saint Kitts and Nevis)', 'KN', 'KNA', '', 0, 1),
(176, '俄罗斯联邦(Russian Federation)', 'RU', 'RUS', '', 0, 1),
(175, '罗马尼亚(Romania)', 'RO', 'ROM', '', 0, 1),
(174, '留尼旺岛(Reunion)', 'RE', 'REU', '', 0, 1),
(173, '卡塔尔(Qatar)', 'QA', 'QAT', '', 0, 1),
(172, '波多黎各(Puerto Rico)', 'PR', 'PRI', '', 0, 1),
(170, '波兰(Poland)', 'PL', 'POL', '', 0, 1),
(168, '菲律宾(Philippines)', 'PH', 'PHL', '', 0, 1),
(167, '秘鲁(Peru)', 'PE', 'PER', '', 0, 1),
(165, '巴布亚新几内亚(Papua New Guinea)', 'PG', 'PNG', '', 0, 1),
(164, '巴拿马(Panama)', 'PA', 'PAN', '', 0, 1),
(163, '帕劳群岛 (Palau)', 'PW', 'PLW', '', 0, 1),
(162, '巴基斯坦(Pakistan)', 'PK', 'PAK', '', 0, 1),
(161, '阿曼(Oman)', 'OM', 'OMN', '', 0, 1),
(159, '北马里亚纳群岛(Northern Mariana Islands)', 'MP', 'MNP', '', 0, 1),
(158, '诺福克岛(Norfolk Island)', 'NF', 'NFK', '', 0, 1),
(157, '纽埃(Niue)', 'NU', 'NIU', '', 0, 1),
(155, '尼日尔(Niger)', 'NE', 'NER', '', 0, 1),
(153, '新西兰(New Zealand)', 'NZ', 'NZL', '', 0, 1),
(152, '新喀里多尼亚(New Caledonia)', 'NC', 'NCL', '', 0, 1),
(149, '尼泊尔(Nepal)', 'NP', 'NPL', '', 0, 1),
(147, '纳米比亚(Namibia)', 'NA', 'NAM', '', 0, 1),
(145, '莫桑比克(Mozambique)', 'MZ', 'MOZ', '', 0, 1),
(140, '摩尔多瓦共和国(Moldova, Republic of)', 'MD', 'MDA', '', 0, 1),
(137, '马约特(Mayotte)', 'YT', 'MYT', '', 0, 1),
(138, '墨西哥(Mexico)', 'MX', 'MEX', '', 0, 1),
(139, '密克罗尼西亚联邦(Micronesia, Federated States of)', 'FM', 'FSM', '', 0, 1),
(136, '毛里求斯(Mauritius)', 'MU', 'MUS', '', 0, 1),
(134, '马提尼克(Martinique)', 'MQ', 'MTQ', '', 0, 1),
(131, '马里(Mali)', 'ML', 'MLI', '', 0, 1),
(132, '马尔他(Malta)', 'MT', 'MLT', '', 0, 1),
(130, '马尔代夫(Maldives)', 'MV', 'MDV', '', 0, 1),
(128, '马拉维(Malawi)', 'MW', 'MWI', '', 0, 1),
(127, '马达加斯加(Madagascar)', 'MG', 'MDG', '', 0, 1),
(125, '澳门(Macau)', 'MO', 'MAC', '', 0, 1),
(124, '卢森堡(Luxembourg)', 'LU', 'LUX', '', 0, 1),
(123, '立陶宛(Lithuania)', 'LT', 'LTU', '', 0, 1),
(122, '列支敦士登(Liechtenstein)', 'LI', 'LIE', '', 0, 1),
(121, '利比亚(Libyan Arab Jamahiriya)', 'LY', 'LBY', '', 0, 1),
(119, '莱索托(Lesotho)', 'LS', 'LSO', '', 0, 1),
(118, '黎巴嫩(Lebanon)', 'LB', 'LBN', '', 0, 1),
(117, '拉脱维亚(Latvia)', 'LV', 'LVA', '', 0, 1),
(116, '老挝(Lao People''s Democratic Republic)', 'LA', 'LAO', '', 0, 1),
(115, '吉尔吉斯斯坦(Kyrgyzstan)', 'KG', 'KGZ', '', 0, 1),
(114, '科威特(Kuwait)', 'KW', 'KWT', '', 0, 1),
(113, '韩国(Korea)', 'KR', 'KOR', '', 0, 1),
(112, '北朝鲜(North Korea)', 'KP', 'PRK', '', 0, 1),
(111, '基里巴斯(Kiribati)', 'KI', 'KIR', '', 0, 1),
(110, '肯尼亚(Kenya)', 'KE', 'KEN', '', 0, 1),
(109, '哈萨克斯坦(Kazakhstan)', 'KZ', 'KAZ', '', 0, 1),
(108, '约旦(Jordan)', 'JO', 'JOR', '', 0, 1),
(107, '日本(Japan)', 'JP', 'JPN', '', 0, 1),
(106, '牙买加(Jamaica)', 'JM', 'JAM', '', 0, 1),
(105, '意大利(Italy)', 'IT', 'ITA', '', 0, 1),
(104, '以色列(Israel)', 'IL', 'ISR', '', 0, 1),
(103, '爱尔兰(Ireland)', 'IE', 'IRL', '', 0, 1),
(102, ' 伊拉克(Iraq)', 'IQ', 'IRQ', '', 0, 1),
(101, '伊朗(伊斯兰共和国)(Iran (Islamic Republic of))', 'IR', 'IRN', '', 0, 1),
(100, '印度尼西亚(Indonesia)', 'ID', 'IDN', '', 0, 1),
(99, '印度(India)', 'IN', 'IND', '', 0, 1),
(98, '冰岛(Iceland)', 'IS', 'ISL', '', 0, 1),
(97, '匈牙利(Hungary)', 'HU', 'HUN', '', 0, 1),
(96, '中国香港(Hong Kong)', 'HK', 'HKG', '', 0, 1),
(95, '洪都拉斯(Honduras)', 'HN', 'HND', '', 0, 1),
(94, '赫德岛和麦当劳群岛(Heard and Mc Donald Islands)', 'HM', 'HMD', '', 0, 1),
(93, '海地(Haiti)', 'HT', 'HTI', '', 0, 1),
(92, '圭亚那(Guyana)', 'GY', 'GUY', '', 0, 1),
(91, '几内亚比索(Guinea-Bissau)', 'GW', 'GNB', '', 0, 1),
(90, '几内亚(Guinea)', 'GN', 'GIN', '', 0, 1),
(89, '危地马拉(Guatemala)', 'GT', 'GTM', '', 0, 1),
(88, '关岛(Guam)', 'GU', 'GUM', '', 0, 1),
(87, '瓜德罗普岛(Guadeloupe)', 'GP', 'GLP', '', 0, 1),
(86, '格林纳达(Grenada)', 'GD', 'GRD', '', 0, 1),
(85, '格陵兰(Greenland)', 'GL', 'GRL', '', 0, 1),
(84, '希腊(Greece)', 'GR', 'GRC', '', 0, 1),
(83, '直布罗陀(Gibraltar)', 'GI', 'GIB', '', 0, 1),
(82, '加纳(Ghana)', 'GH', 'GHA', '', 0, 1),
(81, '德国(Germany)', 'DE', 'DEU', '{company}\r\n{firstname} {lastname}\r\n{address_1}\r\n{address_2}\r\n{postcode} {city}\r\n{country}', 1, 1),
(80, '格鲁吉亚(Georgia)', 'GE', 'GEO', '', 0, 1),
(79, '冈比亚(Gambia)', 'GM', 'GMB', '', 0, 1),
(78, '加蓬(Gabon)', 'GA', 'GAB', '', 0, 1),
(77, '法属南半球领地(French Southern Territories)', 'TF', 'ATF', '', 0, 1),
(76, '法属玻里尼西亚(French Polynesia)', 'PF', 'PYF', '', 0, 1),
(75, '法属几内亚(French Guiana)', 'GF', 'GUF', '', 0, 1),
(74, '法国(France, Metropolitan)', 'FR', 'FRA', '{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{postcode} {city}\r\n{country}', 1, 1),
(72, '芬兰(Finland)', 'FI', 'FIN', '', 0, 1),
(71, '斐济(Fiji)', 'FJ', 'FJI', '', 0, 1),
(70, '法罗群岛(Faroe Islands)', 'FO', 'FRO', '', 0, 1),
(69, '福克兰群岛(马尔维纳斯) (Falkland Islands (Malvinas))', 'FK', 'FLK', '', 0, 1),
(68, '埃塞俄比亚(Ethiopia)', 'ET', 'ETH', '', 0, 1),
(67, '爱沙尼亚(Estonia)', 'EE', 'EST', '', 0, 1),
(66, '厄立特里亚(Eritrea)', 'ER', 'ERI', '', 0, 1),
(65, '赤道几内亚(Equatorial Guinea)', 'GQ', 'GNQ', '', 0, 1),
(64, '萨尔瓦多(El Salvador)', 'SV', 'SLV', '', 0, 1),
(63, '埃及(Egypt)', 'EG', 'EGY', '', 0, 1),
(62, '厄瓜多尔(Ecuador)', 'EC', 'ECU', '', 0, 1),
(61, '东帝汶(East Timor)', 'TL', 'TLS', '', 0, 1),
(60, '多米尼加共和国(Dominican Republic)', 'DO', 'DOM', '', 0, 1),
(59, '多米尼加岛(Dominica)', 'DM', 'DMA', '', 0, 1),
(58, '吉布提(Djibouti)', 'DJ', 'DJI', '', 0, 1),
(57, '丹麦(Denmark)', 'DK', 'DNK', '', 0, 1),
(54, '古巴(Cuba)', 'CU', 'CUB', '', 0, 1),
(55, '塞浦路斯(Cyprus)', 'CY', 'CYP', '', 0, 1),
(56, '捷克(Czech Republic)', 'CZ', 'CZE', '', 0, 1),
(53, '克罗地亚(Croatia)', 'HR', 'HRV', '', 0, 1),
(52, '科特廸亚(Cote D''Ivoire)', 'CI', 'CIV', '', 0, 1),
(51, '哥斯达黎加(Costa Rica)', 'CR', 'CRI', '', 0, 1),
(50, '库克群岛(Cook Islands)', 'CK', 'COK', '', 0, 1),
(49, '刚果(Congo)', 'CG', 'COG', '', 0, 1),
(48, '科摩罗(Comoros)', 'KM', 'COM', '', 0, 1),
(