c1ABHrmQ

1/*
2 Navicat Premium Data Transfer
3
4 Source Server         : localhost
5 Source Server Type    : MySQL
6 Source Server Version : 80011
7 Source Host           : localhost:3306
8 Source Schema         : hey_star
9
10 Target Server Type    : MySQL
11 Target Server Version : 80011
12 File Encoding         : 65001
13
14 Date: 28/07/2018 10:07:08
15*/
16
17SET NAMES utf8mb4;
18SET FOREIGN_KEY_CHECKS = 0;
19
20-- ----------------------------
21-- Table structure for reference_country
22-- ----------------------------
23DROP TABLE IF EXISTS `reference_country`;
24CREATE TABLE `reference_country` (
25  `id` int(11) NOT NULL AUTO_INCREMENT,
26  `code` varchar(5) NOT NULL,
27  `name` varchar(50) NOT NULL,
28  PRIMARY KEY (`id`),
29  UNIQUE KEY `code` (`code`)
30) ENGINE=InnoDB AUTO_INCREMENT=247 DEFAULT CHARSET=utf8;
31
32-- ----------------------------
33-- Records of reference_country
34-- ----------------------------
35BEGIN;
36INSERT INTO `reference_country` VALUES (1, 'AF', 'Afghanistan');
37INSERT INTO `reference_country` VALUES (2, 'AL', 'Albania');
38INSERT INTO `reference_country` VALUES (3, 'DZ', 'Algeria');
39INSERT INTO `reference_country` VALUES (4, 'DS', 'American Samoa');
40INSERT INTO `reference_country` VALUES (5, 'AD', 'Andorra');
41INSERT INTO `reference_country` VALUES (6, 'AO', 'Angola');
42INSERT INTO `reference_country` VALUES (7, 'AI', 'Anguilla');
43INSERT INTO `reference_country` VALUES (8, 'AQ', 'Antarctica');
44INSERT INTO `reference_country` VALUES (9, 'AG', 'Antigua and Barbuda');
45INSERT INTO `reference_country` VALUES (10, 'AR', 'Argentina');
46INSERT INTO `reference_country` VALUES (11, 'AM', 'Armenia');
47INSERT INTO `reference_country` VALUES (12, 'AW', 'Aruba');
48INSERT INTO `reference_country` VALUES (13, 'AU', 'Australia');
49INSERT INTO `reference_country` VALUES (14, 'AT', 'Austria');
50INSERT INTO `reference_country` VALUES (15, 'AZ', 'Azerbaijan');
51INSERT INTO `reference_country` VALUES (16, 'BS', 'Bahamas');
52INSERT INTO `reference_country` VALUES (17, 'BH', 'Bahrain');
53INSERT INTO `reference_country` VALUES (18, 'BD', 'Bangladesh');
54INSERT INTO `reference_country` VALUES (19, 'BB', 'Barbados');
55INSERT INTO `reference_country` VALUES (20, 'BY', 'Belarus');
56INSERT INTO `reference_country` VALUES (21, 'BE', 'Belgium');
57INSERT INTO `reference_country` VALUES (22, 'BZ', 'Belize');
58INSERT INTO `reference_country` VALUES (23, 'BJ', 'Benin');
59INSERT INTO `reference_country` VALUES (24, 'BM', 'Bermuda');
60INSERT INTO `reference_country` VALUES (25, 'BT', 'Bhutan');
61INSERT INTO `reference_country` VALUES (26, 'BO', 'Bolivia');
62INSERT INTO `reference_country` VALUES (27, 'BA', 'Bosnia and Herzegovina');
63INSERT INTO `reference_country` VALUES (28, 'BW', 'Botswana');
64INSERT INTO `reference_country` VALUES (29, 'BV', 'Bouvet Island');
65INSERT INTO `reference_country` VALUES (30, 'BR', 'Brazil');
66INSERT INTO `reference_country` VALUES (31, 'IO', 'British Indian Ocean Territory');
67INSERT INTO `reference_country` VALUES (32, 'BN', 'Brunei Darussalam');
68INSERT INTO `reference_country` VALUES (33, 'BG', 'Bulgaria');
69INSERT INTO `reference_country` VALUES (34, 'BF', 'Burkina Faso');
70INSERT INTO `reference_country` VALUES (35, 'BI', 'Burundi');
71INSERT INTO `reference_country` VALUES (36, 'KH', 'Cambodia');
72INSERT INTO `reference_country` VALUES (37, 'CM', 'Cameroon');
73INSERT INTO `reference_country` VALUES (38, 'CA', 'Canada');
74INSERT INTO `reference_country` VALUES (39, 'CV', 'Cape Verde');
75INSERT INTO `reference_country` VALUES (40, 'KY', 'Cayman Islands');
76INSERT INTO `reference_country` VALUES (41, 'CF', 'Central African Republic');
77INSERT INTO `reference_country` VALUES (42, 'TD', 'Chad');
78INSERT INTO `reference_country` VALUES (43, 'CL', 'Chile');
79INSERT INTO `reference_country` VALUES (44, 'CN', 'China');
80INSERT INTO `reference_country` VALUES (45, 'CX', 'Christmas Island');
81INSERT INTO `reference_country` VALUES (46, 'CC', 'Cocos (Keeling) Islands');
82INSERT INTO `reference_country` VALUES (47, 'CO', 'Colombia');
83INSERT INTO `reference_country` VALUES (48, 'KM', 'Comoros');
84INSERT INTO `reference_country` VALUES (49, 'CG', 'Congo');
85INSERT INTO `reference_country` VALUES (50, 'CK', 'Cook Islands');
86INSERT INTO `reference_country` VALUES (51, 'CR', 'Costa Rica');
87INSERT INTO `reference_country` VALUES (52, 'HR', 'Croatia (Hrvatska)');
88INSERT INTO `reference_country` VALUES (53, 'CU', 'Cuba');
89INSERT INTO `reference_country` VALUES (54, 'CY', 'Cyprus');
90INSERT INTO `reference_country` VALUES (55, 'CZ', 'Czech Republic');
91INSERT INTO `reference_country` VALUES (56, 'DK', 'Denmark');
92INSERT INTO `reference_country` VALUES (57, 'DJ', 'Djibouti');
93INSERT INTO `reference_country` VALUES (58, 'DM', 'Dominica');
94INSERT INTO `reference_country` VALUES (59, 'DO', 'Dominican Republic');
95INSERT INTO `reference_country` VALUES (60, 'TP', 'East Timor');
96INSERT INTO `reference_country` VALUES (61, 'EC', 'Ecuador');
97INSERT INTO `reference_country` VALUES (62, 'EG', 'Egypt');
98INSERT INTO `reference_country` VALUES (63, 'SV', 'El Salvador');
99INSERT INTO `reference_country` VALUES (64, 'GQ', 'Equatorial Guinea');
100INSERT INTO `reference_country` VALUES (65, 'ER', 'Eritrea');
101INSERT INTO `reference_country` VALUES (66, 'EE', 'Estonia');
102INSERT INTO `reference_country` VALUES (67, 'ET', 'Ethiopia');
103INSERT INTO `reference_country` VALUES (68, 'FK', 'Falkland Islands (Malvinas)');
104INSERT INTO `reference_country` VALUES (69, 'FO', 'Faroe Islands');
105INSERT INTO `reference_country` VALUES (70, 'FJ', 'Fiji');
106INSERT INTO `reference_country` VALUES (71, 'FI', 'Finland');
107INSERT INTO `reference_country` VALUES (72, 'FR', 'France');
108INSERT INTO `reference_country` VALUES (73, 'FX', 'France, Metropolitan');
109INSERT INTO `reference_country` VALUES (74, 'GF', 'French Guiana');
110INSERT INTO `reference_country` VALUES (75, 'PF', 'French Polynesia');
111INSERT INTO `reference_country` VALUES (76, 'TF', 'French Southern Territories');
112INSERT INTO `reference_country` VALUES (77, 'GA', 'Gabon');
113INSERT INTO `reference_country` VALUES (78, 'GM', 'Gambia');
114INSERT INTO `reference_country` VALUES (79, 'GE', 'Georgia');
115INSERT INTO `reference_country` VALUES (80, 'DE', 'Germany');
116INSERT INTO `reference_country` VALUES (81, 'GH', 'Ghana');
117INSERT INTO `reference_country` VALUES (82, 'GI', 'Gibraltar');
118INSERT INTO `reference_country` VALUES (83, 'GK', 'Guernsey');
119INSERT INTO `reference_country` VALUES (84, 'GR', 'Greece');
120INSERT INTO `reference_country` VALUES (85, 'GL', 'Greenland');
121INSERT INTO `reference_country` VALUES (86, 'GD', 'Grenada');
122INSERT INTO `reference_country` VALUES (87, 'GP', 'Guadeloupe');
123INSERT INTO `reference_country` VALUES (88, 'GU', 'Guam');
124INSERT INTO `reference_country` VALUES (89, 'GT', 'Guatemala');
125INSERT INTO `reference_country` VALUES (90, 'GN', 'Guinea');
126INSERT INTO `reference_country` VALUES (91, 'GW', 'Guinea-Bissau');
127INSERT INTO `reference_country` VALUES (92, 'GY', 'Guyana');
128INSERT INTO `reference_country` VALUES (93, 'HT', 'Haiti');
129INSERT INTO `reference_country` VALUES (94, 'HM', 'Heard and Mc Donald Islands');
130INSERT INTO `reference_country` VALUES (95, 'HN', 'Honduras');
131INSERT INTO `reference_country` VALUES (96, 'HK', 'Hong Kong');
132INSERT INTO `reference_country` VALUES (97, 'HU', 'Hungary');
133INSERT INTO `reference_country` VALUES (98, 'IS', 'Iceland');
134INSERT INTO `reference_country` VALUES (99, 'IN', 'India');
135INSERT INTO `reference_country` VALUES (100, 'IM', 'Isle of Man');
136INSERT INTO `reference_country` VALUES (101, 'ID', 'Indonesia');
137INSERT INTO `reference_country` VALUES (102, 'IR', 'Iran (Islamic Republic of)');
138INSERT INTO `reference_country` VALUES (103, 'IQ', 'Iraq');
139INSERT INTO `reference_country` VALUES (104, 'IE', 'Ireland');
140INSERT INTO `reference_country` VALUES (105, 'IL', 'Israel');
141INSERT INTO `reference_country` VALUES (106, 'IT', 'Italy');
142INSERT INTO `reference_country` VALUES (107, 'CI', 'Ivory Coast');
143INSERT INTO `reference_country` VALUES (108, 'JE', 'Jersey');
144INSERT INTO `reference_country` VALUES (109, 'JM', 'Jamaica');
145INSERT INTO `reference_country` VALUES (110, 'JP', 'Japan');
146INSERT INTO `reference_country` VALUES (111, 'JO', 'Jordan');
147INSERT INTO `reference_country` VALUES (112, 'KZ', 'Kazakhstan');
148INSERT INTO `reference_country` VALUES (113, 'KE', 'Kenya');
149INSERT INTO `reference_country` VALUES (114, 'KI', 'Kiribati');
150INSERT INTO `reference_country` VALUES (115, 'KP', 'Korea, Democratic People\'s Republic of');
151INSERT INTO `reference_country` VALUES (116, 'KR', 'Korea, Republic of');
152INSERT INTO `reference_country` VALUES (117, 'XK', 'Kosovo');
153INSERT INTO `reference_country` VALUES (118, 'KW', 'Kuwait');
154INSERT INTO `reference_country` VALUES (119, 'KG', 'Kyrgyzstan');
155INSERT INTO `reference_country` VALUES (120, 'LA', 'Lao People\'s Democratic Republic');
156INSERT INTO `reference_country` VALUES (121, 'LV', 'Latvia');
157INSERT INTO `reference_country` VALUES (122, 'LB', 'Lebanon');
158INSERT INTO `reference_country` VALUES (123, 'LS', 'Lesotho');
159INSERT INTO `reference_country` VALUES (124, 'LR', 'Liberia');
160INSERT INTO `reference_country` VALUES (125, 'LY', 'Libyan Arab Jamahiriya');
161INSERT INTO `reference_country` VALUES (126, 'LI', 'Liechtenstein');
162INSERT INTO `reference_country` VALUES (127, 'LT', 'Lithuania');
163INSERT INTO `reference_country` VALUES (128, 'LU', 'Luxembourg');
164INSERT INTO `reference_country` VALUES (129, 'MO', 'Macau');
165INSERT INTO `reference_country` VALUES (130, 'MK', 'Macedonia');
166INSERT INTO `reference_country` VALUES (131, 'MG', 'Madagascar');
167INSERT INTO `reference_country` VALUES (132, 'MW', 'Malawi');
168INSERT INTO `reference_country` VALUES (133, 'MY', 'Malaysia');
169INSERT INTO `reference_country` VALUES (134, 'MV', 'Maldives');
170INSERT INTO `reference_country` VALUES (135, 'ML', 'Mali');
171INSERT INTO `reference_country` VALUES (136, 'MT', 'Malta');
172INSERT INTO `reference_country` VALUES (137, 'MH', 'Marshall Islands');
173INSERT INTO `reference_country` VALUES (138, 'MQ', 'Martinique');
174INSERT INTO `reference_country` VALUES (139, 'MR', 'Mauritania');
175INSERT INTO `reference_country` VALUES (140, 'MU', 'Mauritius');
176INSERT INTO `reference_country` VALUES (141, 'TY', 'Mayotte');
177INSERT INTO `reference_country` VALUES (142, 'MX', 'Mexico');
178INSERT INTO `reference_country` VALUES (143, 'FM', 'Micronesia, Federated States of');
179INSERT INTO `reference_country` VALUES (144, 'MD', 'Moldova, Republic of');
180INSERT INTO `reference_country` VALUES (145, 'MC', 'Monaco');
181INSERT INTO `reference_country` VALUES (146, 'MN', 'Mongolia');
182INSERT INTO `reference_country` VALUES (147, 'ME', 'Montenegro');
183INSERT INTO `reference_country` VALUES (148, 'MS', 'Montserrat');
184INSERT INTO `reference_country` VALUES (149, 'MA', 'Morocco');
185INSERT INTO `reference_country` VALUES (150, 'MZ', 'Mozambique');
186INSERT INTO `reference_country` VALUES (151, 'MM', 'Myanmar');
187INSERT INTO `reference_country` VALUES (152, 'NA', 'Namibia');
188INSERT INTO `reference_country` VALUES (153, 'NR', 'Nauru');
189INSERT INTO `reference_country` VALUES (154, 'NP', 'Nepal');
190INSERT INTO `reference_country` VALUES (155, 'NL', 'Netherlands');
191INSERT INTO `reference_country` VALUES (156, 'AN', 'Netherlands Antilles');
192INSERT INTO `reference_country` VALUES (157, 'NC', 'New Caledonia');
193INSERT INTO `reference_country` VALUES (158, 'NZ', 'New Zealand');
194INSERT INTO `reference_country` VALUES (159, 'NI', 'Nicaragua');
195INSERT INTO `reference_country` VALUES (160, 'NE', 'Niger');
196INSERT INTO `reference_country` VALUES (161, 'NG', 'Nigeria');
197INSERT INTO `reference_country` VALUES (162, 'NU', 'Niue');
198INSERT INTO `reference_country` VALUES (163, 'NF', 'Norfolk Island');
199INSERT INTO `reference_country` VALUES (164, 'MP', 'Northern Mariana Islands');
200INSERT INTO `reference_country` VALUES (165, 'NO', 'Norway');
201INSERT INTO `reference_country` VALUES (166, 'OM', 'Oman');
202INSERT INTO `reference_country` VALUES (167, 'PK', 'Pakistan');
203INSERT INTO `reference_country` VALUES (168, 'PW', 'Palau');
204INSERT INTO `reference_country` VALUES (169, 'PS', 'Palestine');
205INSERT INTO `reference_country` VALUES (170, 'PA', 'Panama');
206INSERT INTO `reference_country` VALUES (171, 'PG', 'Papua New Guinea');
207INSERT INTO `reference_country` VALUES (172, 'PY', 'Paraguay');
208INSERT INTO `reference_country` VALUES (173, 'PE', 'Peru');
209INSERT INTO `reference_country` VALUES (174, 'PH', 'Philippines');
210INSERT INTO `reference_country` VALUES (175, 'PN', 'Pitcairn');
211INSERT INTO `reference_country` VALUES (176, 'PL', 'Poland');
212INSERT INTO `reference_country` VALUES (177, 'PT', 'Portugal');
213INSERT INTO `reference_country` VALUES (178, 'PR', 'Puerto Rico');
214INSERT INTO `reference_country` VALUES (179, 'QA', 'Qatar');
215INSERT INTO `reference_country` VALUES (180, 'RE', 'Reunion');
216INSERT INTO `reference_country` VALUES (181, 'RO', 'Romania');
217INSERT INTO `reference_country` VALUES (182, 'RU', 'Russian Federation');
218INSERT INTO `reference_country` VALUES (183, 'RW', 'Rwanda');
219INSERT INTO `reference_country` VALUES (184, 'KN', 'Saint Kitts and Nevis');
220INSERT INTO `reference_country` VALUES (185, 'LC', 'Saint Lucia');
221INSERT INTO `reference_country` VALUES (186, 'VC', 'Saint Vincent and the Grenadines');
222INSERT INTO `reference_country` VALUES (187, 'WS', 'Samoa');
223INSERT INTO `reference_country` VALUES (188, 'SM', 'San Marino');
224INSERT INTO `reference_country` VALUES (189, 'ST', 'Sao Tome and Principe');
225INSERT INTO `reference_country` VALUES (190, 'SA', 'Saudi Arabia');
226INSERT INTO `reference_country` VALUES (191, 'SN', 'Senegal');
227INSERT INTO `reference_country` VALUES (192, 'RS', 'Serbia');
228INSERT INTO `reference_country` VALUES (193, 'SC', 'Seychelles');
229INSERT INTO `reference_country` VALUES (194, 'SL', 'Sierra Leone');
230INSERT INTO `reference_country` VALUES (195, 'SG', 'Singapore');
231INSERT INTO `reference_country` VALUES (196, 'SK', 'Slovakia');
232INSERT INTO `reference_country` VALUES (197, 'SI', 'Slovenia');
233INSERT INTO `reference_country` VALUES (198, 'SB', 'Solomon Islands');
234INSERT INTO `reference_country` VALUES (199, 'SO', 'Somalia');
235INSERT INTO `reference_country` VALUES (200, 'ZA', 'South Africa');
236INSERT INTO `reference_country` VALUES (201, 'GS', 'South Georgia South Sandwich Islands');
237INSERT INTO `reference_country` VALUES (202, 'SS', 'South Sudan');
238INSERT INTO `reference_country` VALUES (203, 'ES', 'Spain');
239INSERT INTO `reference_country` VALUES (204, 'LK', 'Sri Lanka');
240INSERT INTO `reference_country` VALUES (205, 'SH', 'St. Helena');
241INSERT INTO `reference_country` VALUES (206, 'PM', 'St. Pierre and Miquelon');
242INSERT INTO `reference_country` VALUES (207, 'SD', 'Sudan');
243INSERT INTO `reference_country` VALUES (208, 'SR', 'Suriname');
244INSERT INTO `reference_country` VALUES (209, 'SJ', 'Svalbard and Jan Mayen Islands');
245INSERT INTO `reference_country` VALUES (210, 'SZ', 'Swaziland');
246INSERT INTO `reference_country` VALUES (211, 'SE', 'Sweden');
247INSERT INTO `reference_country` VALUES (212, 'CH', 'Switzerland');
248INSERT INTO `reference_country` VALUES (213, 'SY', 'Syrian Arab Republic');
249INSERT INTO `reference_country` VALUES (214, 'TW', 'Taiwan');
250INSERT INTO `reference_country` VALUES (215, 'TJ', 'Tajikistan');
251INSERT INTO `reference_country` VALUES (216, 'TZ', 'Tanzania, United Republic of');
252INSERT INTO `reference_country` VALUES (217, 'TH', 'Thailand');
253INSERT INTO `reference_country` VALUES (218, 'TG', 'Togo');
254INSERT INTO `reference_country` VALUES (219, 'TK', 'Tokelau');
255INSERT INTO `reference_country` VALUES (220, 'TO', 'Tonga');
256INSERT INTO `reference_country` VALUES (221, 'TT', 'Trinidad and Tobago');
257INSERT INTO `reference_country` VALUES (222, 'TN', 'Tunisia');
258INSERT INTO `reference_country` VALUES (223, 'TR', 'Turkey');
259INSERT INTO `reference_country` VALUES (224, 'TM', 'Turkmenistan');
260INSERT INTO `reference_country` VALUES (225, 'TC', 'Turks and Caicos Islands');
261INSERT INTO `reference_country` VALUES (226, 'TV', 'Tuvalu');
262INSERT INTO `reference_country` VALUES (227, 'UG', 'Uganda');
263INSERT INTO `reference_country` VALUES (228, 'UA', 'Ukraine');
264INSERT INTO `reference_country` VALUES (229, 'AE', 'United Arab Emirates');
265INSERT INTO `reference_country` VALUES (230, 'GB', 'United Kingdom');
266INSERT INTO `reference_country` VALUES (231, 'US', 'United States');
267INSERT INTO `reference_country` VALUES (232, 'UM', 'United States minor outlying islands');
268INSERT INTO `reference_country` VALUES (233, 'UY', 'Uruguay');
269INSERT INTO `reference_country` VALUES (234, 'UZ', 'Uzbekistan');
270INSERT INTO `reference_country` VALUES (235, 'VU', 'Vanuatu');
271INSERT INTO `reference_country` VALUES (236, 'VA', 'Vatican City State');
272INSERT INTO `reference_country` VALUES (237, 'VE', 'Venezuela');
273INSERT INTO `reference_country` VALUES (238, 'VN', 'Vietnam');
274INSERT INTO `reference_country` VALUES (239, 'VG', 'Virgin Islands (British)');
275INSERT INTO `reference_country` VALUES (240, 'VI', 'Virgin Islands (U.S.)');
276INSERT INTO `reference_country` VALUES (241, 'WF', 'Wallis and Futuna Islands');
277INSERT INTO `reference_country` VALUES (242, 'EH', 'Western Sahara');
278INSERT INTO `reference_country` VALUES (243, 'YE', 'Yemen');
279INSERT INTO `reference_country` VALUES (244, 'ZR', 'Zaire');
280INSERT INTO `reference_country` VALUES (245, 'ZM', 'Zambia');
281INSERT INTO `reference_country` VALUES (246, 'ZW', 'Zimbabwe');
282COMMIT;
283
284SET FOREIGN_KEY_CHECKS = 1;