/
countries.sql
38 lines (31 loc) · 27.7 KB
/
countries.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
/*
Navicat MySQL Data Transfer
Source Server : Localhost
Source Server Version : 50144
Target Server Version : 50144
File Encoding : utf-8
Date: 05/30/2012 10:28:27 AM
*/
SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for `countries`
-- ----------------------------
DROP TABLE IF EXISTS `countries`;
CREATE TABLE `countries` (
`id` char(36) COLLATE utf8_bin NOT NULL DEFAULT '',
`iso` char(10) COLLATE utf8_bin NOT NULL,
`name` varchar(255) COLLATE utf8_bin NOT NULL,
`created` datetime DEFAULT NULL,
`modified` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `country_id` (`id`) USING BTREE,
KEY `country_iso` (`iso`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
-- Records of `countries`
-- ----------------------------
BEGIN;
INSERT INTO `countries` VALUES ('e68fcc24-aa60-11e1-8283-82ddd078e822', 'A2', 'Satellite Provider', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e68fe42a-aa60-11e1-8283-82ddd078e822', 'O1', 'Other Country', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e68ff5c8-aa60-11e1-8283-82ddd078e822', 'AD', 'Andorra', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e6900590-aa60-11e1-8283-82ddd078e822', 'AE', 'United Arab Emirates', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e6901576-aa60-11e1-8283-82ddd078e822', 'AF', 'Afghanistan', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e690261a-aa60-11e1-8283-82ddd078e822', 'AG', 'Antigua and Barbuda', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e6903c68-aa60-11e1-8283-82ddd078e822', 'AI', 'Anguilla', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e69057a2-aa60-11e1-8283-82ddd078e822', 'AL', 'Albania', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e6906bac-aa60-11e1-8283-82ddd078e822', 'AM', 'Armenia', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e6907cdc-aa60-11e1-8283-82ddd078e822', 'AO', 'Angola', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e690912c-aa60-11e1-8283-82ddd078e822', 'AP', 'Asia/Pacific Region', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e690a37e-aa60-11e1-8283-82ddd078e822', 'AQ', 'Antarctica', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e690b42c-aa60-11e1-8283-82ddd078e822', 'AR', 'Argentina', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e690c476-aa60-11e1-8283-82ddd078e822', 'AS', 'American Samoa', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e690d8d0-aa60-11e1-8283-82ddd078e822', 'AT', 'Austria', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e690e99c-aa60-11e1-8283-82ddd078e822', 'AU', 'Australia', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e690fc16-aa60-11e1-8283-82ddd078e822', 'AW', 'Aruba', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e6910c2e-aa60-11e1-8283-82ddd078e822', 'AX', 'Aland Islands', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e6911d04-aa60-11e1-8283-82ddd078e822', 'AZ', 'Azerbaijan', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e6913212-aa60-11e1-8283-82ddd078e822', 'BA', 'Bosnia and Herzegovina', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e691454a-aa60-11e1-8283-82ddd078e822', 'BB', 'Barbados', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e69155f8-aa60-11e1-8283-82ddd078e822', 'BD', 'Bangladesh', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e6916674-aa60-11e1-8283-82ddd078e822', 'BE', 'Belgium', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e691765a-aa60-11e1-8283-82ddd078e822', 'BF', 'Burkina Faso', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e6918640-aa60-11e1-8283-82ddd078e822', 'BG', 'Bulgaria', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e6919784-aa60-11e1-8283-82ddd078e822', 'BH', 'Bahrain', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e691a8b4-aa60-11e1-8283-82ddd078e822', 'BI', 'Burundi', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e691baa2-aa60-11e1-8283-82ddd078e822', 'BJ', 'Benin', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e691dcda-aa60-11e1-8283-82ddd078e822', 'BL', 'Saint Bartelemey', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e691f260-aa60-11e1-8283-82ddd078e822', 'BM', 'Bermuda', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e69203f4-aa60-11e1-8283-82ddd078e822', 'BN', 'Brunei Darussalam', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e6921312-aa60-11e1-8283-82ddd078e822', 'BO', 'Bolivia', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e692232a-aa60-11e1-8283-82ddd078e822', 'BQ', 'Bonaire, Saint Eustatius and Saba', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e6923482-aa60-11e1-8283-82ddd078e822', 'BR', 'Brazil', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e69246de-aa60-11e1-8283-82ddd078e822', 'BS', 'Bahamas', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e6925868-aa60-11e1-8283-82ddd078e822', 'BT', 'Bhutan', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e6926b0a-aa60-11e1-8283-82ddd078e822', 'BV', 'Bouvet Island', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e6927cd0-aa60-11e1-8283-82ddd078e822', 'BW', 'Botswana', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e6928c5c-aa60-11e1-8283-82ddd078e822', 'BY', 'Belarus', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e692a246-aa60-11e1-8283-82ddd078e822', 'BZ', 'Belize', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e692b420-aa60-11e1-8283-82ddd078e822', 'CA', 'Canada', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e692c4a6-aa60-11e1-8283-82ddd078e822', 'CC', 'Cocos (Keeling) Islands', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e692d586-aa60-11e1-8283-82ddd078e822', 'CD', 'Congo, The Democratic Republic of the', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e692e68e-aa60-11e1-8283-82ddd078e822', 'CF', 'Central African Republic', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e692f7aa-aa60-11e1-8283-82ddd078e822', 'CG', 'Congo', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e693089e-aa60-11e1-8283-82ddd078e822', 'CH', 'Switzerland', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e6931a3c-aa60-11e1-8283-82ddd078e822', 'CI', 'Cote d\'Ivoire', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e6932b08-aa60-11e1-8283-82ddd078e822', 'CK', 'Cook Islands', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e6933c10-aa60-11e1-8283-82ddd078e822', 'CL', 'Chile', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e6934cfa-aa60-11e1-8283-82ddd078e822', 'CM', 'Cameroon', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e6935d76-aa60-11e1-8283-82ddd078e822', 'CN', 'China', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e6936f50-aa60-11e1-8283-82ddd078e822', 'CO', 'Colombia', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e69380da-aa60-11e1-8283-82ddd078e822', 'CR', 'Costa Rica', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e6939156-aa60-11e1-8283-82ddd078e822', 'CU', 'Cuba', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e693a1fa-aa60-11e1-8283-82ddd078e822', 'CV', 'Cape Verde', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e693b2bc-aa60-11e1-8283-82ddd078e822', 'CW', 'Curacao', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e693c392-aa60-11e1-8283-82ddd078e822', 'CX', 'Christmas Island', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e693d4e0-aa60-11e1-8283-82ddd078e822', 'CY', 'Cyprus', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e693e570-aa60-11e1-8283-82ddd078e822', 'CZ', 'Czech Republic', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e693f5b0-aa60-11e1-8283-82ddd078e822', 'DE', 'Germany', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e6940e4c-aa60-11e1-8283-82ddd078e822', 'DJ', 'Djibouti', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e6941e8c-aa60-11e1-8283-82ddd078e822', 'DK', 'Denmark', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e6942fda-aa60-11e1-8283-82ddd078e822', 'DM', 'Dominica', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e6944092-aa60-11e1-8283-82ddd078e822', 'DO', 'Dominican Republic', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e6945186-aa60-11e1-8283-82ddd078e822', 'DZ', 'Algeria', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e694613a-aa60-11e1-8283-82ddd078e822', 'EC', 'Ecuador', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e69471d4-aa60-11e1-8283-82ddd078e822', 'EE', 'Estonia', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e6948052-aa60-11e1-8283-82ddd078e822', 'EG', 'Egypt', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e69490ba-aa60-11e1-8283-82ddd078e822', 'EH', 'Western Sahara', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e694a244-aa60-11e1-8283-82ddd078e822', 'ER', 'Eritrea', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e694b40a-aa60-11e1-8283-82ddd078e822', 'ES', 'Spain', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e694c2c4-aa60-11e1-8283-82ddd078e822', 'ET', 'Ethiopia', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e694d340-aa60-11e1-8283-82ddd078e822', 'EU', 'Europe', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e694e2cc-aa60-11e1-8283-82ddd078e822', 'FI', 'Finland', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e694f33e-aa60-11e1-8283-82ddd078e822', 'FJ', 'Fiji', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e695037e-aa60-11e1-8283-82ddd078e822', 'FK', 'Falkland Islands (Malvinas)', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e695145e-aa60-11e1-8283-82ddd078e822', 'FM', 'Micronesia, Federated States of', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e6954334-aa60-11e1-8283-82ddd078e822', 'FO', 'Faroe Islands', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e69553ce-aa60-11e1-8283-82ddd078e822', 'FR', 'France', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e695653a-aa60-11e1-8283-82ddd078e822', 'GA', 'Gabon', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e69576ec-aa60-11e1-8283-82ddd078e822', 'GB', 'United Kingdom', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e695877c-aa60-11e1-8283-82ddd078e822', 'GD', 'Grenada', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e695982a-aa60-11e1-8283-82ddd078e822', 'GE', 'Georgia', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e695b17a-aa60-11e1-8283-82ddd078e822', 'GF', 'French Guiana', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e695c278-aa60-11e1-8283-82ddd078e822', 'GG', 'Guernsey', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e695d2d6-aa60-11e1-8283-82ddd078e822', 'GH', 'Ghana', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e695e320-aa60-11e1-8283-82ddd078e822', 'GI', 'Gibraltar', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e695f482-aa60-11e1-8283-82ddd078e822', 'GL', 'Greenland', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e696054e-aa60-11e1-8283-82ddd078e822', 'GM', 'Gambia', '2012-05-30 10:08:15', '2012-05-30 10:08:15'), ('e6961552-aa60-11e1-8283-82ddd078e822', 'GN', 'Guinea', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69625a6-aa60-11e1-8283-82ddd078e822', 'GP', 'Guadeloupe', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6963622-aa60-11e1-8283-82ddd078e822', 'GQ', 'Equatorial Guinea', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6964676-aa60-11e1-8283-82ddd078e822', 'GR', 'Greece', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e696571a-aa60-11e1-8283-82ddd078e822', 'GS', 'South Georgia and the South Sandwich Islands', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69667aa-aa60-11e1-8283-82ddd078e822', 'GT', 'Guatemala', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6967948-aa60-11e1-8283-82ddd078e822', 'GU', 'Guam', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69689b0-aa60-11e1-8283-82ddd078e822', 'GW', 'Guinea-Bissau', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6969a5e-aa60-11e1-8283-82ddd078e822', 'GY', 'Guyana', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e696ab20-aa60-11e1-8283-82ddd078e822', 'HK', 'Hong Kong', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e696bb24-aa60-11e1-8283-82ddd078e822', 'HM', 'Heard Island and McDonald Islands', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e696efc2-aa60-11e1-8283-82ddd078e822', 'HN', 'Honduras', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6970098-aa60-11e1-8283-82ddd078e822', 'HR', 'Croatia', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6971128-aa60-11e1-8283-82ddd078e822', 'HT', 'Haiti', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e697217c-aa60-11e1-8283-82ddd078e822', 'HU', 'Hungary', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69734a0-aa60-11e1-8283-82ddd078e822', 'ID', 'Indonesia', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69744f4-aa60-11e1-8283-82ddd078e822', 'IE', 'Ireland', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6975502-aa60-11e1-8283-82ddd078e822', 'IL', 'Israel', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6977280-aa60-11e1-8283-82ddd078e822', 'IM', 'Isle of Man', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6978298-aa60-11e1-8283-82ddd078e822', 'IN', 'India', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e697938c-aa60-11e1-8283-82ddd078e822', 'IO', 'British Indian Ocean Territory', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e697a44e-aa60-11e1-8283-82ddd078e822', 'IQ', 'Iraq', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e697b466-aa60-11e1-8283-82ddd078e822', 'IR', 'Iran, Islamic Republic of', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e697c3f2-aa60-11e1-8283-82ddd078e822', 'IS', 'Iceland', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e697d3ce-aa60-11e1-8283-82ddd078e822', 'IT', 'Italy', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e697e468-aa60-11e1-8283-82ddd078e822', 'JE', 'Jersey', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e697f4bc-aa60-11e1-8283-82ddd078e822', 'JM', 'Jamaica', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69804a2-aa60-11e1-8283-82ddd078e822', 'JO', 'Jordan', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69815be-aa60-11e1-8283-82ddd078e822', 'JP', 'Japan', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69825fe-aa60-11e1-8283-82ddd078e822', 'KE', 'Kenya', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69835f8-aa60-11e1-8283-82ddd078e822', 'KG', 'Kyrgyzstan', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69845fc-aa60-11e1-8283-82ddd078e822', 'KH', 'Cambodia', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69855d8-aa60-11e1-8283-82ddd078e822', 'KI', 'Kiribati', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6986712-aa60-11e1-8283-82ddd078e822', 'KM', 'Comoros', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6987a36-aa60-11e1-8283-82ddd078e822', 'KN', 'Saint Kitts and Nevis', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6989b42-aa60-11e1-8283-82ddd078e822', 'KP', 'Korea, Democratic People\'s Republic of', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e698abe6-aa60-11e1-8283-82ddd078e822', 'KR', 'Korea, Republic of', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e698bc80-aa60-11e1-8283-82ddd078e822', 'KW', 'Kuwait', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e698ccd4-aa60-11e1-8283-82ddd078e822', 'KY', 'Cayman Islands', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e698dd78-aa60-11e1-8283-82ddd078e822', 'KZ', 'Kazakhstan', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e698ee12-aa60-11e1-8283-82ddd078e822', 'LA', 'Lao People\'s Democratic Republic', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e698fe84-aa60-11e1-8283-82ddd078e822', 'LB', 'Lebanon', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6990fdc-aa60-11e1-8283-82ddd078e822', 'LC', 'Saint Lucia', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e699208a-aa60-11e1-8283-82ddd078e822', 'LI', 'Liechtenstein', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6994268-aa60-11e1-8283-82ddd078e822', 'LK', 'Sri Lanka', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6995456-aa60-11e1-8283-82ddd078e822', 'LR', 'Liberia', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69964e6-aa60-11e1-8283-82ddd078e822', 'LS', 'Lesotho', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6997724-aa60-11e1-8283-82ddd078e822', 'LT', 'Lithuania', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6998804-aa60-11e1-8283-82ddd078e822', 'LU', 'Luxembourg', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e699986c-aa60-11e1-8283-82ddd078e822', 'LV', 'Latvia', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e699aa1e-aa60-11e1-8283-82ddd078e822', 'LY', 'Libyan Arab Jamahiriya', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e699bb44-aa60-11e1-8283-82ddd078e822', 'MA', 'Morocco', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e699cd8c-aa60-11e1-8283-82ddd078e822', 'MC', 'Monaco', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e699deee-aa60-11e1-8283-82ddd078e822', 'MD', 'Moldova, Republic of', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e699ef6a-aa60-11e1-8283-82ddd078e822', 'ME', 'Montenegro', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e699fff0-aa60-11e1-8283-82ddd078e822', 'MF', 'Saint Martin', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69a103a-aa60-11e1-8283-82ddd078e822', 'MG', 'Madagascar', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69a20c0-aa60-11e1-8283-82ddd078e822', 'MH', 'Marshall Islands', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69a5630-aa60-11e1-8283-82ddd078e822', 'MK', 'Macedonia', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69a69f4-aa60-11e1-8283-82ddd078e822', 'ML', 'Mali', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69a7a8e-aa60-11e1-8283-82ddd078e822', 'MM', 'Myanmar', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69a8b28-aa60-11e1-8283-82ddd078e822', 'MN', 'Mongolia', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69a9af0-aa60-11e1-8283-82ddd078e822', 'MO', 'Macao', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69aab9e-aa60-11e1-8283-82ddd078e822', 'MP', 'Northern Mariana Islands', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69abb02-aa60-11e1-8283-82ddd078e822', 'MQ', 'Martinique', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69acb88-aa60-11e1-8283-82ddd078e822', 'MR', 'Mauritania', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69adbe6-aa60-11e1-8283-82ddd078e822', 'MS', 'Montserrat', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69aec62-aa60-11e1-8283-82ddd078e822', 'MT', 'Malta', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69afe6e-aa60-11e1-8283-82ddd078e822', 'MU', 'Mauritius', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69b0f62-aa60-11e1-8283-82ddd078e822', 'MV', 'Maldives', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69b1f84-aa60-11e1-8283-82ddd078e822', 'MW', 'Malawi', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69b51e8-aa60-11e1-8283-82ddd078e822', 'MX', 'Mexico', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69b6dea-aa60-11e1-8283-82ddd078e822', 'MY', 'Malaysia', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69b7e3e-aa60-11e1-8283-82ddd078e822', 'MZ', 'Mozambique', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69b8ee2-aa60-11e1-8283-82ddd078e822', 'NA', 'Namibia', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69b9f90-aa60-11e1-8283-82ddd078e822', 'NC', 'New Caledonia', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69bb016-aa60-11e1-8283-82ddd078e822', 'NE', 'Niger', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69bc06a-aa60-11e1-8283-82ddd078e822', 'NF', 'Norfolk Island', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69bd104-aa60-11e1-8283-82ddd078e822', 'NG', 'Nigeria', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69be040-aa60-11e1-8283-82ddd078e822', 'NI', 'Nicaragua', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69bf562-aa60-11e1-8283-82ddd078e822', 'NL', 'Netherlands', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69c16f0-aa60-11e1-8283-82ddd078e822', 'NO', 'Norway', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69c27e4-aa60-11e1-8283-82ddd078e822', 'NP', 'Nepal', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69c37f2-aa60-11e1-8283-82ddd078e822', 'NR', 'Nauru', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69c4904-aa60-11e1-8283-82ddd078e822', 'NU', 'Niue', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69c596c-aa60-11e1-8283-82ddd078e822', 'NZ', 'New Zealand', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69c69f2-aa60-11e1-8283-82ddd078e822', 'OM', 'Oman', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69c79f6-aa60-11e1-8283-82ddd078e822', 'PA', 'Panama', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69c8a7c-aa60-11e1-8283-82ddd078e822', 'PE', 'Peru', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69c9b16-aa60-11e1-8283-82ddd078e822', 'PF', 'French Polynesia', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69cabc4-aa60-11e1-8283-82ddd078e822', 'PG', 'Papua New Guinea', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69cbcfe-aa60-11e1-8283-82ddd078e822', 'PH', 'Philippines', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69ccdca-aa60-11e1-8283-82ddd078e822', 'PK', 'Pakistan', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69cde3c-aa60-11e1-8283-82ddd078e822', 'PL', 'Poland', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69cefc6-aa60-11e1-8283-82ddd078e822', 'PM', 'Saint Pierre and Miquelon', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69d0074-aa60-11e1-8283-82ddd078e822', 'PN', 'Pitcairn', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69d112c-aa60-11e1-8283-82ddd078e822', 'PR', 'Puerto Rico', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69d2194-aa60-11e1-8283-82ddd078e822', 'PS', 'Palestinian Territory', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69d3260-aa60-11e1-8283-82ddd078e822', 'PT', 'Portugal', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69d42b4-aa60-11e1-8283-82ddd078e822', 'PW', 'Palau', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69d5380-aa60-11e1-8283-82ddd078e822', 'PY', 'Paraguay', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69d63f2-aa60-11e1-8283-82ddd078e822', 'QA', 'Qatar', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69d836e-aa60-11e1-8283-82ddd078e822', 'RE', 'Reunion', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69d923c-aa60-11e1-8283-82ddd078e822', 'RO', 'Romania', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69da7ea-aa60-11e1-8283-82ddd078e822', 'RS', 'Serbia', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69dcaa4-aa60-11e1-8283-82ddd078e822', 'RU', 'Russian Federation', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69ddba2-aa60-11e1-8283-82ddd078e822', 'RW', 'Rwanda', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69dec3c-aa60-11e1-8283-82ddd078e822', 'SA', 'Saudi Arabia', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69dfcea-aa60-11e1-8283-82ddd078e822', 'SB', 'Solomon Islands', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69e0d84-aa60-11e1-8283-82ddd078e822', 'SC', 'Seychelles', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69e1dec-aa60-11e1-8283-82ddd078e822', 'SD', 'Sudan', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69e2e68-aa60-11e1-8283-82ddd078e822', 'SE', 'Sweden', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69e3ebc-aa60-11e1-8283-82ddd078e822', 'SG', 'Singapore', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69e4f4c-aa60-11e1-8283-82ddd078e822', 'SH', 'Saint Helena', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69e6180-aa60-11e1-8283-82ddd078e822', 'SI', 'Slovenia', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69e72ba-aa60-11e1-8283-82ddd078e822', 'SJ', 'Svalbard and Jan Mayen', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69e834a-aa60-11e1-8283-82ddd078e822', 'SK', 'Slovakia', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69e92f4-aa60-11e1-8283-82ddd078e822', 'SL', 'Sierra Leone', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69ea3c0-aa60-11e1-8283-82ddd078e822', 'SM', 'San Marino', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69eb478-aa60-11e1-8283-82ddd078e822', 'SN', 'Senegal', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69ec6ca-aa60-11e1-8283-82ddd078e822', 'SO', 'Somalia', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69ed854-aa60-11e1-8283-82ddd078e822', 'SR', 'Suriname', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69ee9d4-aa60-11e1-8283-82ddd078e822', 'ST', 'Sao Tome and Principe', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69efa82-aa60-11e1-8283-82ddd078e822', 'SV', 'El Salvador', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69f0b12-aa60-11e1-8283-82ddd078e822', 'SX', 'Sint Maarten', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69f1b7a-aa60-11e1-8283-82ddd078e822', 'SY', 'Syrian Arab Republic', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69f2c00-aa60-11e1-8283-82ddd078e822', 'SZ', 'Swaziland', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69f3c90-aa60-11e1-8283-82ddd078e822', 'TC', 'Turks and Caicos Islands', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69f4d70-aa60-11e1-8283-82ddd078e822', 'TD', 'Chad', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69f7ee4-aa60-11e1-8283-82ddd078e822', 'TF', 'French Southern Territories', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69f9014-aa60-11e1-8283-82ddd078e822', 'TG', 'Togo', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69fa0e0-aa60-11e1-8283-82ddd078e822', 'TH', 'Thailand', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69fb166-aa60-11e1-8283-82ddd078e822', 'TJ', 'Tajikistan', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69fc232-aa60-11e1-8283-82ddd078e822', 'TK', 'Tokelau', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69fd394-aa60-11e1-8283-82ddd078e822', 'TL', 'Timor-Leste', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e69fe47e-aa60-11e1-8283-82ddd078e822', 'TM', 'Turkmenistan', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6a0074c-aa60-11e1-8283-82ddd078e822', 'TN', 'Tunisia', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6a01994-aa60-11e1-8283-82ddd078e822', 'TO', 'Tonga', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6a029fc-aa60-11e1-8283-82ddd078e822', 'TR', 'Turkey', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6a0396a-aa60-11e1-8283-82ddd078e822', 'TT', 'Trinidad and Tobago', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6a04a5e-aa60-11e1-8283-82ddd078e822', 'TV', 'Tuvalu', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6a05b48-aa60-11e1-8283-82ddd078e822', 'TW', 'Taiwan', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6a06d0e-aa60-11e1-8283-82ddd078e822', 'TZ', 'Tanzania, United Republic of', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6a07d30-aa60-11e1-8283-82ddd078e822', 'UA', 'Ukraine', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6a08d0c-aa60-11e1-8283-82ddd078e822', 'UG', 'Uganda', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6a09d42-aa60-11e1-8283-82ddd078e822', 'UM', 'United States Minor Outlying Islands', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6a0ae36-aa60-11e1-8283-82ddd078e822', 'US', 'United States', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6a0be8a-aa60-11e1-8283-82ddd078e822', 'UY', 'Uruguay', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6a0cf1a-aa60-11e1-8283-82ddd078e822', 'UZ', 'Uzbekistan', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6a0dfbe-aa60-11e1-8283-82ddd078e822', 'VA', 'Holy See (Vatican City State)', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6a0f3a0-aa60-11e1-8283-82ddd078e822', 'VC', 'Saint Vincent and the Grenadines', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6a1064c-aa60-11e1-8283-82ddd078e822', 'VE', 'Venezuela', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6a136b2-aa60-11e1-8283-82ddd078e822', 'VG', 'Virgin Islands, British', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6a1472e-aa60-11e1-8283-82ddd078e822', 'VI', 'Virgin Islands, U.S.', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6a159b2-aa60-11e1-8283-82ddd078e822', 'VN', 'Vietnam', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6a16be6-aa60-11e1-8283-82ddd078e822', 'VU', 'Vanuatu', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6a17c3a-aa60-11e1-8283-82ddd078e822', 'WF', 'Wallis and Futuna', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6a18ca2-aa60-11e1-8283-82ddd078e822', 'WS', 'Samoa', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6a19d32-aa60-11e1-8283-82ddd078e822', 'YE', 'Yemen', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6a1ad90-aa60-11e1-8283-82ddd078e822', 'YT', 'Mayotte', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6a1be2a-aa60-11e1-8283-82ddd078e822', 'ZA', 'South Africa', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6a1ce9c-aa60-11e1-8283-82ddd078e822', 'ZM', 'Zambia', '2012-05-30 10:08:16', '2012-05-30 10:08:16'), ('e6a1e062-aa60-11e1-8283-82ddd078e822', 'ZW', 'Zimbabwe', '2012-05-30 10:08:16', '2012-05-30 10:08:16');
COMMIT;
SET FOREIGN_KEY_CHECKS = 1;