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