· 7 years ago · Oct 18, 2018, 11:48 PM
1-- Server version 5.1.61-0ubuntu0.11.04.1
2
3
4/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
5/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
6/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
7/*!40101 SET NAMES utf8 */;
8
9/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
10/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
11/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
12
13
14--
15-- Create schema countries
16--
17
18CREATE DATABASE IF NOT EXISTS countries;
19USE countries;
20
21--
22-- Definition of table `countries`.`tbl_countries`
23--
24
25DROP TABLE IF EXISTS `countries`.`tbl_countries`;
26CREATE TABLE `countries`.`tbl_countries` (
27 `cnt_id` int(11) NOT NULL AUTO_INCREMENT,
28 `cnt_name` varchar(80) COLLATE utf8_bin NOT NULL,
29 `cnt_iso3_code` char(3) COLLATE utf8_bin DEFAULT NULL,
30 PRIMARY KEY (`cnt_id`) USING BTREE
31) ENGINE=InnoDB AUTO_INCREMENT=240 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
32
33--
34-- Dumping data for table `countries`.`tbl_countries`
35--
36
37/*!40000 ALTER TABLE `tbl_countries` DISABLE KEYS */;
38LOCK TABLES `tbl_countries` WRITE;
39INSERT INTO `countries`.`tbl_countries` VALUES (1,0x41666768616E697374616E,0x414647),
40 (2,0x416C62616E6961,0x414C42),
41 (3,0x416C6765726961,0x445A41),
42 (4,0x416D65726963616E2053616D6F61,0x41534D),
43 (5,0x416E646F727261,0x414E44),
44 (6,0x416E676F6C61,0x41474F),
45 (7,0x416E6775696C6C61,0x414941),
46 (8,0x416E7461726374696361,NULL),
47 (9,0x416E746967756120616E642042617262756461,0x415447),
48 (10,0x417267656E74696E61,0x415247),
49 (11,0x41726D656E6961,0x41524D),
50 (12,0x4172756261,0x414257),
51 (13,0x4175737472616C6961,0x415553),
52 (14,0x41757374726961,0x415554),
53 (15,0x417A65726261696A616E,0x415A45),
54 (16,0x426168616D6173,0x424853),
55 (17,0x4261687261696E,0x424852),
56 (18,0x42616E676C6164657368,0x424744),
57 (19,0x4261726261646F73,0x425242),
58 (20,0x42656C61727573,0x424C52),
59 (21,0x42656C6769756D,0x42454C),
60 (22,0x42656C697A65,0x424C5A),
61 (23,0x42656E696E,0x42454E),
62 (24,0x4265726D756461,0x424D55),
63 (25,0x42687574616E,0x42544E),
64 (26,0x426F6C69766961,0x424F4C),
65 (27,0x426F736E696120616E64204865727A65676F76696E61,0x424948),
66 (28,0x426F747377616E61,0x425741),
67 (29,0x426F757665742049736C616E64,NULL),
68 (30,0x4272617A696C,0x425241),
69 (31,0x4272697469736820496E6469616E204F6365616E205465727269746F7279,NULL),
70 (32,0x4272756E656920446172757373616C616D,0x42524E),
71 (33,0x42756C6761726961,0x424752),
72 (34,0x4275726B696E61204661736F,0x424641),
73 (35,0x427572756E6469,0x424449),
74 (36,0x43616D626F646961,0x4B484D),
75 (37,0x43616D65726F6F6E,0x434D52),
76 (38,0x43616E616461,0x43414E),
77 (39,0x43617065205665726465,0x435056),
78 (40,0x4361796D616E2049736C616E6473,0x43594D),
79 (41,0x43656E7472616C204166726963616E2052657075626C6963,0x434146),
80 (42,0x43686164,0x544344),
81 (43,0x4368696C65,0x43484C),
82 (44,0x4368696E61,0x43484E),
83 (45,0x4368726973746D61732049736C616E64,NULL),
84 (46,0x436F636F7320284B65656C696E67292049736C616E6473,NULL),
85 (47,0x436F6C6F6D626961,0x434F4C),
86 (48,0x436F6D6F726F73,0x434F4D),
87 (49,0x436F6E676F,0x434F47),
88 (50,0x436F6E676F2C207468652044656D6F6372617469632052657075626C6963206F6620746865,0x434F44),
89 (51,0x436F6F6B2049736C616E6473,0x434F4B),
90 (52,0x436F7374612052696361,0x435249),
91 (53,0x436F746520442749766F697265,0x434956),
92 (54,0x43726F61746961,0x485256),
93 (55,0x43756261,0x435542),
94 (56,0x437970727573,0x435950),
95 (57,0x437A6563682052657075626C6963,0x435A45),
96 (58,0x44656E6D61726B,0x444E4B),
97 (59,0x446A69626F757469,0x444A49),
98 (60,0x446F6D696E696361,0x444D41),
99 (61,0x446F6D696E6963616E2052657075626C6963,0x444F4D),
100 (62,0x45637561646F72,0x454355),
101 (63,0x4567797074,0x454759),
102 (64,0x456C2053616C7661646F72,0x534C56),
103 (65,0x45717561746F7269616C204775696E6561,0x474E51),
104 (66,0x45726974726561,0x455249),
105 (67,0x4573746F6E6961,0x455354),
106 (68,0x457468696F706961,0x455448),
107 (69,0x46616C6B6C616E642049736C616E647320284D616C76696E617329,0x464C4B),
108 (70,0x4661726F652049736C616E6473,0x46524F),
109 (71,0x46696A69,0x464A49),
110 (72,0x46696E6C616E64,0x46494E),
111 (73,0x4672616E6365,0x465241),
112 (74,0x4672656E636820477569616E61,0x475546),
113 (75,0x4672656E636820506F6C796E65736961,0x505946),
114 (76,0x4672656E636820536F75746865726E205465727269746F72696573,NULL),
115 (77,0x4761626F6E,0x474142),
116 (78,0x47616D626961,0x474D42),
117 (79,0x47656F72676961,0x47454F),
118 (80,0x4765726D616E79,0x444555),
119 (81,0x4768616E61,0x474841),
120 (82,0x47696272616C746172,0x474942),
121 (83,0x477265656365,0x475243),
122 (84,0x477265656E6C616E64,0x47524C),
123 (85,0x4772656E616461,0x475244),
124 (86,0x47756164656C6F757065,0x474C50),
125 (87,0x4775616D,0x47554D),
126 (88,0x47756174656D616C61,0x47544D),
127 (89,0x4775696E6561,0x47494E),
128 (90,0x4775696E65612D426973736175,0x474E42),
129 (91,0x477579616E61,0x475559),
130 (92,0x4861697469,0x485449),
131 (93,0x48656172642049736C616E6420616E64204D63646F6E616C642049736C616E6473,NULL),
132 (94,0x486F6C792053656520285661746963616E204369747920537461746529,0x564154),
133 (95,0x486F6E6475726173,0x484E44),
134 (96,0x486F6E67204B6F6E67,0x484B47),
135 (97,0x48756E67617279,0x48554E),
136 (98,0x4963656C616E64,0x49534C),
137 (99,0x496E646961,0x494E44),
138 (100,0x496E646F6E65736961,0x49444E),
139 (101,0x4972616E2C2049736C616D69632052657075626C6963206F66,0x49524E),
140 (102,0x49726171,0x495251),
141 (103,0x4972656C616E64,0x49524C),
142 (104,0x49737261656C,0x495352),
143 (105,0x4974616C79,0x495441),
144 (106,0x4A616D61696361,0x4A414D),
145 (107,0x4A6170616E,0x4A504E),
146 (108,0x4A6F7264616E,0x4A4F52),
147 (109,0x4B617A616B687374616E,0x4B415A),
148 (110,0x4B656E7961,0x4B454E),
149 (111,0x4B69726962617469,0x4B4952),
150 (112,0x4B6F7265612C2044656D6F6372617469632050656F706C6527732052657075626C6963206F66,0x50524B),
151 (113,0x4B6F7265612C2052657075626C6963206F66,0x4B4F52),
152 (114,0x4B7577616974,0x4B5754),
153 (115,0x4B797267797A7374616E,0x4B475A),
154 (116,0x4C616F2050656F706C6527732044656D6F6372617469632052657075626C6963,0x4C414F),
155 (117,0x4C6174766961,0x4C5641),
156 (118,0x4C6562616E6F6E,0x4C424E),
157 (119,0x4C65736F74686F,0x4C534F),
158 (120,0x4C696265726961,0x4C4252),
159 (121,0x4C696279616E2041726162204A616D61686972697961,0x4C4259),
160 (122,0x4C6965636874656E737465696E,0x4C4945),
161 (123,0x4C69746875616E6961,0x4C5455),
162 (124,0x4C7578656D626F757267,0x4C5558),
163 (125,0x4D6163616F,0x4D4143),
164 (126,0x4D616365646F6E69612C2074686520466F726D6572205975676F736C61762052657075626C6963206F66,0x4D4B44),
165 (127,0x4D616461676173636172,0x4D4447),
166 (128,0x4D616C617769,0x4D5749),
167 (129,0x4D616C6179736961,0x4D5953),
168 (130,0x4D616C6469766573,0x4D4456),
169 (131,0x4D616C69,0x4D4C49),
170 (132,0x4D616C7461,0x4D4C54),
171 (133,0x4D61727368616C6C2049736C616E6473,0x4D484C),
172 (134,0x4D617274696E69717565,0x4D5451),
173 (135,0x4D6175726974616E6961,0x4D5254),
174 (136,0x4D6175726974697573,0x4D5553),
175 (137,0x4D61796F747465,NULL),
176 (138,0x4D657869636F,0x4D4558),
177 (139,0x4D6963726F6E657369612C2046656465726174656420537461746573206F66,0x46534D),
178 (140,0x4D6F6C646F76612C2052657075626C6963206F66,0x4D4441),
179 (141,0x4D6F6E61636F,0x4D434F),
180 (142,0x4D6F6E676F6C6961,0x4D4E47),
181 (143,0x4D6F6E74736572726174,0x4D5352),
182 (144,0x4D6F726F63636F,0x4D4152),
183 (145,0x4D6F7A616D6269717565,0x4D4F5A),
184 (146,0x4D79616E6D6172,0x4D4D52),
185 (147,0x4E616D69626961,0x4E414D),
186 (148,0x4E61757275,0x4E5255),
187 (149,0x4E6570616C,0x4E504C),
188 (150,0x4E65746865726C616E6473,0x4E4C44),
189 (151,0x4E65746865726C616E647320416E74696C6C6573,0x414E54),
190 (152,0x4E65772043616C65646F6E6961,0x4E434C),
191 (153,0x4E6577205A65616C616E64,0x4E5A4C),
192 (154,0x4E6963617261677561,0x4E4943),
193 (155,0x4E69676572,0x4E4552),
194 (156,0x4E696765726961,0x4E4741),
195 (157,0x4E697565,0x4E4955),
196 (158,0x4E6F72666F6C6B2049736C616E64,0x4E464B),
197 (159,0x4E6F72746865726E204D617269616E612049736C616E6473,0x4D4E50),
198 (160,0x4E6F72776179,0x4E4F52),
199 (161,0x4F6D616E,0x4F4D4E),
200 (162,0x50616B697374616E,0x50414B),
201 (163,0x50616C6175,0x504C57),
202 (164,0x50616C657374696E69616E205465727269746F72792C204F63637570696564,NULL),
203 (165,0x50616E616D61,0x50414E),
204 (166,0x5061707561204E6577204775696E6561,0x504E47),
205 (167,0x5061726167756179,0x505259),
206 (168,0x50657275,0x504552),
207 (169,0x5068696C697070696E6573,0x50484C),
208 (170,0x506974636169726E,0x50434E),
209 (171,0x506F6C616E64,0x504F4C),
210 (172,0x506F72747567616C,0x505254),
211 (173,0x50756572746F205269636F,0x505249),
212 (174,0x5161746172,0x514154),
213 (175,0x5265756E696F6E,0x524555),
214 (176,0x526F6D616E6961,0x524F4D),
215 (177,0x5275737369616E2046656465726174696F6E,0x525553),
216 (178,0x5277616E6461,0x525741),
217 (179,0x5361696E742048656C656E61,0x53484E),
218 (180,0x5361696E74204B6974747320616E64204E65766973,0x4B4E41),
219 (181,0x5361696E74204C75636961,0x4C4341),
220 (182,0x5361696E742050696572726520616E64204D697175656C6F6E,0x53504D),
221 (183,0x5361696E742056696E63656E7420616E6420746865204772656E6164696E6573,0x564354),
222 (184,0x53616D6F61,0x57534D),
223 (185,0x53616E204D6172696E6F,0x534D52),
224 (186,0x53616F20546F6D6520616E64205072696E63697065,0x535450),
225 (187,0x536175646920417261626961,0x534155),
226 (188,0x53656E6567616C,0x53454E),
227 (189,0x53657262696120616E64204D6F6E74656E6567726F,NULL),
228 (190,0x5365796368656C6C6573,0x535943),
229 (191,0x536965727261204C656F6E65,0x534C45),
230 (192,0x53696E6761706F7265,0x534750),
231 (193,0x536C6F76616B6961,0x53564B),
232 (194,0x536C6F76656E6961,0x53564E),
233 (195,0x536F6C6F6D6F6E2049736C616E6473,0x534C42),
234 (196,0x536F6D616C6961,0x534F4D),
235 (197,0x536F75746820416672696361,0x5A4146),
236 (198,0x536F7574682047656F7267696120616E642074686520536F7574682053616E64776963682049736C616E6473,NULL),
237 (199,0x537061696E,0x455350),
238 (200,0x537269204C616E6B61,0x4C4B41),
239 (201,0x537564616E,0x53444E),
240 (202,0x537572696E616D65,0x535552),
241 (203,0x5376616C6261726420616E64204A616E204D6179656E,0x534A4D),
242 (204,0x5377617A696C616E64,0x53575A),
243 (205,0x53776564656E,0x535745),
244 (206,0x537769747A65726C616E64,0x434845),
245 (207,0x53797269616E20417261622052657075626C6963,0x535952),
246 (208,0x54616977616E2C2050726F76696E6365206F66204368696E61,0x54574E),
247 (209,0x54616A696B697374616E,0x544A4B),
248 (210,0x54616E7A616E69612C20556E697465642052657075626C6963206F66,0x545A41),
249 (211,0x546861696C616E64,0x544841),
250 (212,0x54696D6F722D4C65737465,NULL),
251 (213,0x546F676F,0x54474F),
252 (214,0x546F6B656C6175,0x544B4C),
253 (215,0x546F6E6761,0x544F4E),
254 (216,0x5472696E6964616420616E6420546F6261676F,0x54544F),
255 (217,0x54756E69736961,0x54554E),
256 (218,0x5475726B6579,0x545552),
257 (219,0x5475726B6D656E697374616E,0x544B4D),
258 (220,0x5475726B7320616E6420436169636F732049736C616E6473,0x544341),
259 (221,0x547576616C75,0x545556),
260 (222,0x5567616E6461,0x554741),
261 (223,0x556B7261696E65,0x554B52),
262 (224,0x556E69746564204172616220456D697261746573,0x415245),
263 (225,0x556E69746564204B696E67646F6D,0x474252),
264 (226,0x556E6974656420537461746573,0x555341),
265 (227,0x556E6974656420537461746573204D696E6F72204F75746C79696E672049736C616E6473,NULL),
266 (228,0x55727567756179,0x555259),
267 (229,0x557A62656B697374616E,0x555A42),
268 (230,0x56616E75617475,0x565554),
269 (231,0x56656E657A75656C61,0x56454E),
270 (232,0x56696574204E616D,0x564E4D),
271 (233,0x56697267696E2049736C616E64732C2042726974697368,0x564742),
272 (234,0x56697267696E2049736C616E64732C20552E732E,0x564952),
273 (235,0x57616C6C697320616E6420467574756E61,0x574C46),
274 (236,0x5765737465726E20536168617261,0x455348),
275 (237,0x59656D656E,0x59454D),
276 (238,0x5A616D626961,0x5A4D42),
277 (239,0x5A696D6261627765,0x5A5745);
278UNLOCK TABLES;
279/*!40000 ALTER TABLE `tbl_countries` ENABLE KEYS */;
280
281
282
283
284/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
285/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
286/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
287/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
288/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
289/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
290/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;