zone_country.sql

phpShop是一个基于php的分布式电子商务模块

# Server version: 3.23.37
# PHP Version: 4.0.6
# Database :
# --------------------------------------------------------

#
# Table structure for table `zone_country`
#

CREATE TABLE zone_country (
  country_id int(11) NOT NULL default '0',
  zone_id int(11) NOT NULL default '1',
  country_name varchar(64) default NULL,
  country_3_code char(3) default NULL,
  country_2_code char(2) default NULL,
  PRIMARY KEY  (country_id)
) TYPE=MyISAM;

#
# Dumping data for table `zone_country`
#

INSERT INTO zone_country VALUES (4, 4, 'AFGHANISTAN', 'AFG', 'AF');
INSERT INTO zone_country VALUES (8, 3, 'ALBANIA', 'ALB', 'AL');
INSERT INTO zone_country VALUES (12, 2, 'ALGERIA', 'DZA', 'DZ');
INSERT INTO zone_country VALUES (16, 1, 'AMERICAN SAMOA', 'ASM', 'AS');
INSERT INTO zone_country VALUES (20, 1, 'ANDORRA', 'AND', 'AD');
INSERT INTO zone_country VALUES (24, 1, 'ANGOLA', 'AGO', 'AO');
INSERT INTO zone_country VALUES (660, 1, 'ANGUILLA', 'AIA', 'AI');
INSERT INTO zone_country VALUES (10, 2, 'ANTARCTICA', 'ATA', 'AQ');
INSERT INTO zone_country VALUES (28, 1, 'ANTIGUA AND BARBUDA', 'ATG', 'AG');
INSERT INTO zone_country VALUES (32, 1, 'ARGENTINA', 'ARG', 'AR');
INSERT INTO zone_country VALUES (51, 1, 'ARMENIA', 'ARM', 'AM');
INSERT INTO zone_country VALUES (533, 1, 'ARUBA', 'ABW', 'AW');
INSERT INTO zone_country VALUES (36, 1, 'AUSTRALIA', 'AUS', 'AU');
INSERT INTO zone_country VALUES (40, 1, 'AUSTRIA', 'AUT', 'AT');
INSERT INTO zone_country VALUES (31, 1, 'AZERBAIJAN', 'AZE', 'AZ');
INSERT INTO zone_country VALUES (44, 1, 'BAHAMAS', 'BHS', 'BS');
INSERT INTO zone_country VALUES (48, 1, 'BAHRAIN', 'BHR', 'BH');
INSERT INTO zone_country VALUES (50, 1, 'BANGLADESH', 'BGD', 'BD');
INSERT INTO zone_country VALUES (52, 1, 'BARBADOS', 'BRB', 'BB');
INSERT INTO zone_country VALUES (112, 1, 'BELARUS', 'BLR', 'BY');
INSERT INTO zone_country VALUES (56, 1, 'BELGIUM', 'BEL', 'BE');
INSERT INTO zone_country VALUES (84, 1, 'BELIZE', 'BLZ', 'BZ');
INSERT INTO zone_country VALUES (204, 1, 'BENIN', 'BEN', 'BJ');
INSERT INTO zone_country VALUES (60, 1, 'BERMUDA', 'BMU', 'BM');
INSERT INTO zone_country VALUES (64, 1, 'BHUTAN', 'BTN', 'BT');
INSERT INTO zone_country VALUES (68, 1, 'BOLIVIA', 'BOL', 'BO');
INSERT INTO zone_country VALUES (70, 1, 'BOSNIA AND HERZEGOWINA', 'BIH', 'BA');
INSERT INTO zone_country VALUES (72, 1, 'BOTSWANA', 'BWA', 'BW');
INSERT INTO zone_country VALUES (74, 1, 'BOUVET ISLAND', 'BVT', 'BV');
INSERT INTO zone_country VALUES (76, 1, 'BRAZIL', 'BRA', 'BR');
INSERT INTO zone_country VALUES (86, 1, 'BRITISH INDIAN OCEAN TERRITORY', 'IOT', 'IO');
INSERT INTO zone_country VALUES (96, 1, 'BRUNEI DARUSSALAM', 'BRN', 'BN');
INSERT INTO zone_country VALUES (100, 1, 'BULGARIA', 'BGR', 'BG');
INSERT INTO zone_country VALUES (854, 1, 'BURKINA FASO', 'BFA', 'BF');
INSERT INTO zone_country VALUES (108, 1, 'BURUNDI', 'BDI', 'BI');
INSERT INTO zone_country VALUES (116, 1, 'CAMBODIA', 'KHM', 'KH');
INSERT INTO zone_country VALUES (120, 1, 'CAMEROON', 'CMR', 'CM');
INSERT INTO zone_country VALUES (124, 1, 'CANADA', 'CAN', 'CA');
INSERT INTO zone_country VALUES (132, 1, 'CAPE VERDE', 'CPV', 'CV');
INSERT INTO zone_country VALUES (136, 1, 'CAYMAN ISLANDS', 'CYM', 'KY');
INSERT INTO zone_country VALUES (140, 1, 'CENTRAL AFRICAN REPUBLIC', 'CAF', 'CF');
INSERT INTO zone_country VALUES (148, 1, 'CHAD', 'TCD', 'TD');
INSERT INTO zone_country VALUES (152, 1, 'CHILE', 'CHL', 'CL');
INSERT INTO zone_country VALUES (156, 1, 'CHINA', 'CHN', 'CN');
INSERT INTO zone_country VALUES (162, 1, 'CHRISTMAS ISLAND', 'CXR', 'CX');
INSERT INTO zone_country VALUES (166, 1, 'COCOS (KEELING) ISLANDS', 'CCK', 'CC');
INSERT INTO zone_country VALUES (170, 1, 'COLOMBIA', 'COL', 'CO');
INSERT INTO zone_country VALUES (174, 1, 'COMOROS', 'COM', 'KM');
INSERT INTO zone_country VALUES (178, 1, 'CONGO', 'COG', 'CG');
INSERT INTO zone_country VALUES (180, 1, 'CONGO, THE DEMOCRATIC REPUBLIC OF THE', 'COD', 'CD');
INSERT INTO zone_country VALUES (184, 1, 'COOK ISLANDS', 'COK', 'CK');
INSERT INTO zone_country VALUES (188, 1, 'COSTA RICA', 'CRI', 'CR');
INSERT INTO zone_country VALUES (384, 1, 'COTE D\'IVOIRE', 'CIV', 'CI');
INSERT INTO zone_country VALUES (191, 1, 'CROATIA (local name: Hrvatska)', 'HRV', 'HR');
INSERT INTO zone_country VALUES (192, 1, 'CUBA', 'CUB', 'CU');
INSERT INTO zone_country VALUES (196, 1, 'CYPRUS', 'CYP', 'CY');
INSERT INTO zone_country VALUES (203, 1, 'CZECH REPUBLIC', 'CZE', 'CZ');
INSERT INTO zone_country VALUES (208, 1, 'DENMARK', 'DNK', 'DK');
INSERT INTO zone_country VALUES (262, 1, 'DJIBOUTI', 'DJI', 'DJ');
INSERT INTO zone_country VALUES (212, 1, 'DOMINICA', 'DMA', 'DM');
INSERT INTO zone_country VALUES (214, 1, 'DOMINICAN REPUBLIC', 'DOM', 'DO');
INSERT INTO zone_country VALUES (626, 1, 'EAST TIMOR', 'TMP', 'TP');
INSERT INTO zone_country VALUES (218, 1, 'ECUADOR', 'ECU', 'EC');
INSERT INTO zone_country VALUES (818, 1, 'EGYPT', 'EGY', 'EG');
INSERT INTO zone_country VALUES (222, 1, 'EL SALVADOR', 'SLV', 'SV');
INSERT INTO zone_country VALUES (226, 1, 'EQUATORIAL GUINEA', 'GNQ', 'GQ');
INSERT INTO zone_country VALUES (232, 1, 'ERITREA', 'ERI', 'ER');
INSERT INTO zone_country VALUES (233, 1, 'ESTONIA', 'EST', 'EE');
INSERT INTO zone_country VALUES (231, 1, 'ETHIOPIA', 'ETH', 'ET');
INSERT INTO zone_country VALUES (238, 1, 'FALKLAND ISLANDS (MALVINAS)', 'FLK', 'FK');
INSERT INTO zone_country VALUES (234, 1, 'FAROE ISLANDS', 'FRO', 'FO');
INSERT INTO zone_country VALUES (242, 1, 'FIJI', 'FJI', 'FJ');
INSERT INTO zone_country VALUES (246, 1, 'FINLAND', 'FIN', 'FI');
INSERT INTO zone_country VALUES (250, 1, 'FRANCE', 'FRA', 'FR');
INSERT INTO zone_country VALUES (249, 1, 'FRANCE, METROPOLITAN', 'FXX', 'FX');
INSERT INTO zone_country VALUES (254, 1, 'FRENCH GUIANA', 'GUF', 'GF');
INSERT INTO zone_country VALUES (258, 1, 'FRENCH POLYNESIA', 'PYF', 'PF');
INSERT INTO zone_country VALUES (260, 1, 'FRENCH SOUTHERN TERRITORIES', 'ATF', 'TF');
INSERT INTO zone_country VALUES (266, 1, 'GABON', 'GAB', 'GA');
INSERT INTO zone_country VALUES (270, 1, 'GAMBIA', 'GMB', 'GM');
INSERT INTO zone_country VALUES (268, 1, 'GEORGIA', 'GEO', 'GE');
INSERT INTO zone_country VALUES (276, 1, 'GERMANY', 'DEU', 'DE');
INSERT INTO zone_country VALUES (288, 1, 'GHANA', 'GHA', 'GH');
INSERT INTO zone_country VALUES (292, 1, 'GIBRALTAR', 'GIB', 'GI');
INSERT INTO zone_country VALUES (300, 1, 'GREECE', 'GRC', 'GR');
INSERT INTO zone_country VALUES (304, 1, 'GREENLAND', 'GRL', 'GL');
INSERT INTO zone_country VALUES (308, 1, 'GRENADA', 'GRD', 'GD');
INSERT INTO zone_country VALUES (312, 1, 'GUADELOUPE', 'GLP', 'GP');
INSERT INTO zone_country VALUES (316, 1, 'GUAM', 'GUM', 'GU');
INSERT INTO zone_country VALUES (320, 1, 'GUATEMALA', 'GTM', 'GT');
INSERT INTO zone_country VALUES (324, 1, 'GUINEA', 'GIN', 'GN');
INSERT INTO zone_country VALUES (624, 1, 'GUINEA-BISSAU', 'GNB', 'GW');
INSERT INTO zone_country VALUES (328, 1, 'GUYANA', 'GUY', 'GY');
INSERT INTO zone_country VALUES (332, 1, 'HAITI', 'HTI', 'HT');
INSERT INTO zone_country VALUES (334, 1, 'HEARD AND MC DONALD ISLANDS', 'HMD', 'HM');
INSERT INTO zone_country VALUES (336, 1, 'HOLY SEE (VATICAN CITY STATE)', 'VAT', 'VA');
INSERT INTO zone_country VALUES (340, 1, 'HONDURAS', 'HND', 'HN');
INSERT INTO zone_country VALUES (344, 1, 'HONG KONG', 'HKG', 'HK');
INSERT INTO zone_country VALUES (348, 1, 'HUNGARY', 'HUN', 'HU');
INSERT INTO zone_country VALUES (352, 1, 'ICELAND', 'ISL', 'IS');
INSERT INTO zone_country VALUES (356, 1, 'INDIA', 'IND', 'IN');
INSERT INTO zone_country VALUES (360, 1, 'INDONESIA', 'IDN', 'ID');
INSERT INTO zone_country VALUES (364, 1, 'IRAN (ISLAMIC REPUBLIC OF)', 'IRN', 'IR');
INSERT INTO zone_country VALUES (368, 1, 'IRAQ', 'IRQ', 'IQ');
INSERT INTO zone_country VALUES (372, 1, 'IRELAND', 'IRL', 'IE');
INSERT INTO zone_country VALUES (376, 1, 'ISRAEL', 'ISR', 'IL');
INSERT INTO zone_country VALUES (380, 1, 'ITALY', 'ITA', 'IT');
INSERT INTO zone_country VALUES (388, 1, 'JAMAICA', 'JAM', 'JM');
INSERT INTO zone_country VALUES (392, 1, 'JAPAN', 'JPN', 'JP');
INSERT INTO zone_country VALUES (400, 1, 'JORDAN', 'JOR', 'JO');