Kraje SQL

Lista krajów w formacie SQL kraje.sql.
Aby szybko i bez większych problemów utworzyć tabele z danymi wystarczy uruchomić skrypt kraje.sql.



-- --------------------------------------------------------

--
-- Struktura tabeli dla  `country`
--

CREATE TABLE IF NOT EXISTS `country` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `name` varchar(80) DEFAULT NULL,
  `iso` char(2) DEFAULT NULL,
  `iso3` char(3) DEFAULT NULL,
  `numcode` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=240 ;

--
-- Zrzut danych tabeli `country`
--

INSERT INTO `country` (`id`, `name`, `iso`, `iso3`, `numcode`) VALUES
(1, 'Andorra', 'AD', 'AND', 20),
(2, 'United Arab Emirates', 'AE', 'ARE', 784),
(3, 'Afghanistan', 'AF', 'AFG', 4),
(4, 'Antigua and Barbuda', 'AG', 'ATG', 28),
(5, 'Anguilla', 'AI', 'AIA', 660),
(6, 'Albania', 'AL', 'ALB', 8),
(7, 'Armenia', 'AM', 'ARM', 51),
(8, 'Netherlands Antilles', 'AN', 'ANT', 530),
(9, 'Angola', 'AO', 'AGO', 24),
(10, 'Antarctica', 'AQ', NULL, NULL),
(11, 'Argentina', 'AR', 'ARG', 32),
(12, 'American Samoa', 'AS', 'ASM', 16),
(13, 'Austria', 'AT', 'AUT', 40),
(14, 'Australia', 'AU', 'AUS', 36),
(15, 'Aruba', 'AW', 'ABW', 533),
(16, 'Azerbaijan', 'AZ', 'AZE', 31),
(17, 'Bosnia and Herzegovina', 'BA', 'BIH', 70),
(18, 'Barbados', 'BB', 'BRB', 52),
(19, 'Bangladesh', 'BD', 'BGD', 50),
(20, 'Belgium', 'BE', 'BEL', 56),
(21, 'Burkina Faso', 'BF', 'BFA', 854),
(22, 'Bulgaria', 'BG', 'BGR', 100),
(23, 'Bahrain', 'BH', 'BHR', 48),
(24, 'Burundi', 'BI', 'BDI', 108),
(25, 'Benin', 'BJ', 'BEN', 204),
(26, 'Bermuda', 'BM', 'BMU', 60),
(27, 'Brunei Darussalam', 'BN', 'BRN', 96),
(28, 'Bolivia', 'BO', 'BOL', 68),
(29, 'Brazil', 'BR', 'BRA', 76),
(30, 'Bahamas', 'BS', 'BHS', 44),
(31, 'Bhutan', 'BT', 'BTN', 64),
(32, 'Bouvet Island', 'BV', NULL, NULL),
(33, 'Botswana', 'BW', 'BWA', 72),
(34, 'Belarus', 'BY', 'BLR', 112),
(35, 'Belize', 'BZ', 'BLZ', 84),
(36, 'Canada', 'CA', 'CAN', 124),
(37, 'Cocos (Keeling) Islands', 'CC', NULL, NULL),
(38, 'Congo, the Democratic Republic of the', 'CD', 'COD', 180),
(39, 'Central African Republic', 'CF', 'CAF', 140),
(40, 'Congo', 'CG', 'COG', 178),
(41, 'Switzerland', 'CH', 'CHE', 756),
(42, 'Cote D''Ivoire', 'CI', 'CIV', 384),
(43, 'Cook Islands', 'CK', 'COK', 184),
(44, 'Chile', 'CL', 'CHL', 152),
(45, 'Cameroon', 'CM', 'CMR', 120),
(46, 'China', 'CN', 'CHN', 156),
(47, 'Colombia', 'CO', 'COL', 170),
(48, 'Costa Rica', 'CR', 'CRI', 188),
(49, 'Serbia and Montenegro', 'CS', NULL, NULL),
(50, 'Cuba', 'CU', 'CUB', 192),
(51, 'Cape Verde', 'CV', 'CPV', 132),
(52, 'Christmas Island', 'CX', NULL, NULL),
(53, 'Cyprus', 'CY', 'CYP', 196),
(54, 'Czech Republic', 'CZ', 'CZE', 203),
(55, 'Germany', 'DE', 'DEU', 276),
(56, 'Djibouti', 'DJ', 'DJI', 262),
(57, 'Denmark', 'DK', 'DNK', 208),
(58, 'Dominica', 'DM', 'DMA', 212),
(59, 'Dominican Republic', 'DO', 'DOM', 214),
(60, 'Algeria', 'DZ', 'DZA', 12),
(61, 'Ecuador', 'EC', 'ECU', 218),
(62, 'Estonia', 'EE', 'EST', 233),
(63, 'Egypt', 'EG', 'EGY', 818),
(64, 'Western Sahara', 'EH', 'ESH', 732),
(65, 'Eritrea', 'ER', 'ERI', 232),
(66, 'Spain', 'ES', 'ESP', 724),
(67, 'Ethiopia', 'ET', 'ETH', 231),
(68, 'Finland', 'FI', 'FIN', 246),
(69, 'Fiji', 'FJ', 'FJI', 242),
(70, 'Falkland Islands (Malvinas)', 'FK', 'FLK', 238),
(71, 'Micronesia, Federated States of', 'FM', 'FSM', 583),
(72, 'Faroe Islands', 'FO', 'FRO', 234),
(73, 'France', 'FR', 'FRA', 250),
(74, 'Gabon', 'GA', 'GAB', 266),
(75, 'United Kingdom', 'GB', 'GBR', 826),
(76, 'Grenada', 'GD', 'GRD', 308),
(77, 'Georgia', 'GE', 'GEO', 268),
(78, 'French Guiana', 'GF', 'GUF', 254),
(79, 'Ghana', 'GH', 'GHA', 288),
(80, 'Gibraltar', 'GI', 'GIB', 292),
(81, 'Greenland', 'GL', 'GRL', 304),
(82, 'Gambia', 'GM', 'GMB', 270),
(83, 'Guinea', 'GN', 'GIN', 324),
(84, 'Guadeloupe', 'GP', 'GLP', 312),
(85, 'Equatorial Guinea', 'GQ', 'GNQ', 226),
(86, 'Greece', 'GR', 'GRC', 300),
(87, 'South Georgia and the South Sandwich Islands', 'GS', NULL, NULL),
(88, 'Guatemala', 'GT', 'GTM', 320),
(89, 'Guam', 'GU', 'GUM', 316),
(90, 'Guinea-Bissau', 'GW', 'GNB', 624),
(91, 'Guyana', 'GY', 'GUY', 328),
(92, 'Hong Kong', 'HK', 'HKG', 344),
(93, 'Heard Island and Mcdonald Islands', 'HM', NULL, NULL),
(94, 'Honduras', 'HN', 'HND', 340),
(95, 'Croatia', 'HR', 'HRV', 191),
(96, 'Haiti', 'HT', 'HTI', 332),
(97, 'Hungary', 'HU', 'HUN', 348),
(98, 'Indonesia', 'ID', 'IDN', 360),
(99, 'Ireland', 'IE', 'IRL', 372),
(100, 'Israel', 'IL', 'ISR', 376),
(101, 'India', 'IN', 'IND', 356),
(102, 'British Indian Ocean Territory', 'IO', NULL, NULL),
(103, 'Iraq', 'IQ', 'IRQ', 368),
(104, 'Iran, Islamic Republic of', 'IR', 'IRN', 364),
(105, 'Iceland', 'IS', 'ISL', 352),
(106, 'Italy', 'IT', 'ITA', 380),
(107, 'Jamaica', 'JM', 'JAM', 388),
(108, 'Jordan', 'JO', 'JOR', 400),
(109, 'Japan', 'JP', 'JPN', 392),
(110, 'Kenya', 'KE', 'KEN', 404),
(111, 'Kyrgyzstan', 'KG', 'KGZ', 417),
(112, 'Cambodia', 'KH', 'KHM', 116),
(113, 'Kiribati', 'KI', 'KIR', 296),
(114, 'Comoros', 'KM', 'COM', 174),
(115, 'Saint Kitts and Nevis', 'KN', 'KNA', 659),
(116, 'Korea, Democratic People''s Republic of', 'KP', 'PRK', 408),
(117, 'Korea, Republic of', 'KR', 'KOR', 410),
(118, 'Kuwait', 'KW', 'KWT', 414),
(119, 'Cayman Islands', 'KY', 'CYM', 136),
(120, 'Kazakhstan', 'KZ', 'KAZ', 398),
(121, 'Lao People''s Democratic Republic', 'LA', 'LAO', 418),
(122, 'Lebanon', 'LB', 'LBN', 422),
(123, 'Saint Lucia', 'LC', 'LCA', 662),
(124, 'Liechtenstein', 'LI', 'LIE', 438),
(125, 'Sri Lanka', 'LK', 'LKA', 144),
(126, 'Liberia', 'LR', 'LBR', 430),
(127, 'Lesotho', 'LS', 'LSO', 426),
(128, 'Lithuania', 'LT', 'LTU', 440),
(129, 'Luxembourg', 'LU', 'LUX', 442),
(130, 'Latvia', 'LV', 'LVA', 428),
(131, 'Libyan Arab Jamahiriya', 'LY', 'LBY', 434),
(132, 'Morocco', 'MA', 'MAR', 504),
(133, 'Monaco', 'MC', 'MCO', 492),
(134, 'Moldova, Republic of', 'MD', 'MDA', 498),
(135, 'Madagascar', 'MG', 'MDG', 450),
(136, 'Marshall Islands', 'MH', 'MHL', 584),
(137, 'Macedonia, the Former Yugoslav Republic of', 'MK', 'MKD', 807),
(138, 'Mali', 'ML', 'MLI', 466),
(139, 'Myanmar', 'MM', 'MMR', 104),
(140, 'Mongolia', 'MN', 'MNG', 496),
(141, 'Macao', 'MO', 'MAC', 446),
(142, 'Northern Mariana Islands', 'MP', 'MNP', 580),
(143, 'Martinique', 'MQ', 'MTQ', 474),
(144, 'Mauritania', 'MR', 'MRT', 478),
(145, 'Montserrat', 'MS', 'MSR', 500),
(146, 'Malta', 'MT', 'MLT', 470),
(147, 'Mauritius', 'MU', 'MUS', 480),
(148, 'Maldives', 'MV', 'MDV', 462),
(149, 'Malawi', 'MW', 'MWI', 454),
(150, 'Mexico', 'MX', 'MEX', 484),
(151, 'Malaysia', 'MY', 'MYS', 458),
(152, 'Mozambique', 'MZ', 'MOZ', 508),
(153, 'Namibia', 'NA', 'NAM', 516),
(154, 'New Caledonia', 'NC', 'NCL', 540),
(155, 'Niger', 'NE', 'NER', 562),
(156, 'Norfolk Island', 'NF', 'NFK', 574),
(157, 'Nigeria', 'NG', 'NGA', 566),
(158, 'Nicaragua', 'NI', 'NIC', 558),
(159, 'Netherlands', 'NL', 'NLD', 528),
(160, 'Norway', 'NO', 'NOR', 578),
(161, 'Nepal', 'NP', 'NPL', 524),
(162, 'Nauru', 'NR', 'NRU', 520),
(163, 'Niue', 'NU', 'NIU', 570),
(164, 'New Zealand', 'NZ', 'NZL', 554),
(165, 'Oman', 'OM', 'OMN', 512),
(166, 'Panama', 'PA', 'PAN', 591),
(167, 'Peru', 'PE', 'PER', 604),
(168, 'French Polynesia', 'PF', 'PYF', 258),
(169, 'Papua New Guinea', 'PG', 'PNG', 598),
(170, 'Philippines', 'PH', 'PHL', 608),
(171, 'Pakistan', 'PK', 'PAK', 586),
(172, 'Poland', 'PL', 'POL', 616),
(173, 'Saint Pierre and Miquelon', 'PM', 'SPM', 666),
(174, 'Pitcairn', 'PN', 'PCN', 612),
(175, 'Puerto Rico', 'PR', 'PRI', 630),
(176, 'Palestinian Territory, Occupied', 'PS', NULL, NULL),
(177, 'Portugal', 'PT', 'PRT', 620),
(178, 'Palau', 'PW', 'PLW', 585),
(179, 'Paraguay', 'PY', 'PRY', 600),
(180, 'Qatar', 'QA', 'QAT', 634),
(181, 'Reunion', 'RE', 'REU', 638),
(182, 'Romania', 'RO', 'ROM', 642),
(183, 'Russian Federation', 'RU', 'RUS', 643),
(184, 'Rwanda', 'RW', 'RWA', 646),
(185, 'Saudi Arabia', 'SA', 'SAU', 682),
(186, 'Solomon Islands', 'SB', 'SLB', 90),
(187, 'Seychelles', 'SC', 'SYC', 690),
(188, 'Sudan', 'SD', 'SDN', 736),
(189, 'Sweden', 'SE', 'SWE', 752),
(190, 'Singapore', 'SG', 'SGP', 702),
(191, 'Saint Helena', 'SH', 'SHN', 654),
(192, 'Slovenia', 'SI', 'SVN', 705),
(193, 'Svalbard and Jan Mayen', 'SJ', 'SJM', 744),
(194, 'Slovakia', 'SK', 'SVK', 703),
(195, 'Sierra Leone', 'SL', 'SLE', 694),
(196, 'San Marino', 'SM', 'SMR', 674),
(197, 'Senegal', 'SN', 'SEN', 686),
(198, 'Somalia', 'SO', 'SOM', 706),
(199, 'Suriname', 'SR', 'SUR', 740),
(200, 'Sao Tome and Principe', 'ST', 'STP', 678),
(201, 'El Salvador', 'SV', 'SLV', 222),
(202, 'Syrian Arab Republic', 'SY', 'SYR', 760),
(203, 'Swaziland', 'SZ', 'SWZ', 748),
(204, 'Turks and Caicos Islands', 'TC', 'TCA', 796),
(205, 'Chad', 'TD', 'TCD', 148),
(206, 'French Southern Territories', 'TF', NULL, NULL),
(207, 'Togo', 'TG', 'TGO', 768),
(208, 'Thailand', 'TH', 'THA', 764),
(209, 'Tajikistan', 'TJ', 'TJK', 762),
(210, 'Tokelau', 'TK', 'TKL', 772),
(211, 'Timor-Leste', 'TL', NULL, NULL),
(212, 'Turkmenistan', 'TM', 'TKM', 795),
(213, 'Tunisia', 'TN', 'TUN', 788),
(214, 'Tonga', 'TO', 'TON', 776),
(215, 'Turkey', 'TR', 'TUR', 792),
(216, 'Trinidad and Tobago', 'TT', 'TTO', 780),
(217, 'Tuvalu', 'TV', 'TUV', 798),
(218, 'Taiwan, Province of China', 'TW', 'TWN', 158),
(219, 'Tanzania, United Republic of', 'TZ', 'TZA', 834),
(220, 'Ukraine', 'UA', 'UKR', 804),
(221, 'Uganda', 'UG', 'UGA', 800),
(222, 'United States Minor Outlying Islands', 'UM', NULL, NULL),
(223, 'United States', 'US', 'USA', 840),
(224, 'Uruguay', 'UY', 'URY', 858),
(225, 'Uzbekistan', 'UZ', 'UZB', 860),
(226, 'Holy See (Vatican City State)', 'VA', 'VAT', 336),
(227, 'Saint Vincent and the Grenadines', 'VC', 'VCT', 670),
(228, 'Venezuela', 'VE', 'VEN', 862),
(229, 'Virgin Islands, British', 'VG', 'VGB', 92),
(230, 'Virgin Islands, U.s.', 'VI', 'VIR', 850),
(231, 'Viet Nam', 'VN', 'VNM', 704),
(232, 'Vanuatu', 'VU', 'VUT', 548),
(233, 'Wallis and Futuna', 'WF', 'WLF', 876),
(234, 'Samoa', 'WS', 'WSM', 882),
(235, 'Yemen', 'YE', 'YEM', 887),
(236, 'Mayotte', 'YT', NULL, NULL),
(237, 'South Africa', 'ZA', 'ZAF', 710),
(238, 'Zambia', 'ZM', 'ZMB', 894),
(239, 'Zimbabwe', 'ZW', 'ZWE', 716);