-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathcourse.sql
executable file
·420 lines (361 loc) · 103 KB
/
course.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
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
-- MySQL dump 10.13 Distrib 5.7.27, for Linux (x86_64)
--
-- Host: localhost Database: course
-- ------------------------------------------------------
-- Server version 5.7.27-0ubuntu0.18.04.1
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `access_log`
--
DROP TABLE IF EXISTS `access_log`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `access_log` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`ip_v4_address` char(16) NOT NULL,
`ip_v6_address` varchar(128) DEFAULT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`uri` varchar(254) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `access_log`
--
LOCK TABLES `access_log` WRITE;
/*!40000 ALTER TABLE `access_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `access_log` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `attendee`
--
DROP TABLE IF EXISTS `attendee`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `attendee` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`registration_id` int(11) NOT NULL,
`name_on_ticket` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `attendee`
--
LOCK TABLES `attendee` WRITE;
/*!40000 ALTER TABLE `attendee` DISABLE KEYS */;
INSERT INTO `attendee` VALUES (50,32,'Daryl'),(51,32,'Josie'),(52,33,'Lada'),(53,33,'Saleen'),(54,33,'Tami'),(55,34,'JR'),(56,34,'Nong Ai'),(57,35,'Fred'),(58,35,'Barney'),(59,35,'Wilma'),(60,35,'Betty'),(61,36,'Doug'),(62,36,'Fon'),(63,36,'JR'),(64,38,'Fon'),(65,38,'JR'),(66,38,''),(67,38,''),(68,38,''),(69,38,''),(70,39,'111'),(71,39,'222'),(72,39,'333'),(73,40,'111'),(74,40,'222'),(75,40,'333'),(76,40,'444'),(77,41,'444'),(78,41,'555'),(79,41,'666');
/*!40000 ALTER TABLE `attendee` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `attendee_d`
--
DROP TABLE IF EXISTS `attendee_d`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `attendee_d` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`registration_id` int(11) DEFAULT NULL,
`name_on_ticket` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_EA203C4E833D8F43` (`registration_id`),
CONSTRAINT `FK_EA203C4E833D8F43` FOREIGN KEY (`registration_id`) REFERENCES `registration_d` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `attendee_d`
--
LOCK TABLES `attendee_d` WRITE;
/*!40000 ALTER TABLE `attendee_d` DISABLE KEYS */;
INSERT INTO `attendee_d` VALUES (1,1,'Lada'),(2,1,'Tongsoi'),(3,1,'Saleen'),(4,1,'Tami'),(5,1,'Suchi'),(6,2,'Bart'),(7,2,'Lisa'),(8,3,'Daryl'),(9,3,'Josie'),(10,4,'Doug'),(11,4,'Fon');
/*!40000 ALTER TABLE `attendee_d` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `event`
--
DROP TABLE IF EXISTS `event`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `event` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT '',
`max_attendees` int(11) DEFAULT NULL,
`date` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `event`
--
LOCK TABLES `event` WRITE;
/*!40000 ALTER TABLE `event` DISABLE KEYS */;
INSERT INTO `event` VALUES (1,'Event A',25,'2013-10-01 00:00:00'),(2,'Event B',150,'2013-12-12 00:00:00');
/*!40000 ALTER TABLE `event` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `event_d`
--
DROP TABLE IF EXISTS `event_d`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `event_d` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`max_attendees` int(11) NOT NULL,
`date` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `event_d`
--
LOCK TABLES `event_d` WRITE;
/*!40000 ALTER TABLE `event_d` DISABLE KEYS */;
INSERT INTO `event_d` VALUES (1,'Event A',100,'2017-12-01 00:00:00'),(2,'Event B',200,'2018-01-01 00:00:00');
/*!40000 ALTER TABLE `event_d` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `guest_messages`
--
DROP TABLE IF EXISTS `guest_messages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `guest_messages` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`message` varchar(1024) COLLATE utf8_unicode_ci DEFAULT NULL,
`to_email` varchar(254) COLLATE utf8_unicode_ci DEFAULT NULL,
`from_email` varchar(254) COLLATE utf8_unicode_ci DEFAULT NULL,
`date_time` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `guest_messages`
--
LOCK TABLES `guest_messages` WRITE;
/*!40000 ALTER TABLE `guest_messages` DISABLE KEYS */;
INSERT INTO `guest_messages` VALUES (1,'5f22be90b75f12d49d807d3cf0c287a64f1e65e865f97d6b3161500e436213a09Yk31ZhAEzTur8hmjQTyyof4XsiFGX6NKpm6oCduRFBwV6TtIiEXS+KYVnG3euwV','doug@zend.com','admin@zend.com',NULL),(2,'5f878a1b0f663de59c673d0cd6ba99b6fd551eab1803a596e30ef5ad47fe3decB7Itoz1pw9odtEc5G4ewt+mAqeeaJAspsYzAdxHwssxPjqVEXCAvZG+xES+Vp3fZD3NTcdhQq1BucB6z9mD7/Q==','daryl@zend.com','admin@zend.com',NULL),(3,'5b6746f53844feb2a566112722a58dfd5da7a567df312c568e20b7ff1dc270166ngmWdQ1ULrvfN0/P0QAl7W6CgCjqRoiFo6e5T2r/LwIXqUVL63pfpXYxg9MH37/','daryl@zend.com','doug@zend.com',NULL),(4,'91196a93cad8c0c4c050d85169531ca9bd0f1497eddff5d1fa11082cef6f34a1KjFtvkTemKLzSiuV7dcJPr3d3UE0vmBgCBhrMUrhFmglDldKX/DjE/XmBQseTMB6OOAzkZ/V8ZKIwjI4VDuY0g==','doug@zend.com','daryl@zend.com',NULL);
/*!40000 ALTER TABLE `guest_messages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `guestbook`
--
DROP TABLE IF EXISTS `guestbook`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `guestbook` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`website` varchar(255) NOT NULL,
`message` text NOT NULL,
`avatar` varchar(254) DEFAULT NULL,
`dateSigned` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `guestbook`
--
LOCK TABLES `guestbook` WRITE;
/*!40000 ALTER TABLE `guestbook` DISABLE KEYS */;
INSERT INTO `guestbook` VALUES (52,'Doug','doug@unlikelysource.com','http://unlikelysource.com/','Doug dogged duck. Duck dug dog. Dog ducked Doug.','doug.png','2018-09-17 13:02:28'),(53,'Fon','fon@unlikelysource.com','http://unlikelysource.com/','Fon phoned for fun. Phone fun had Fon. Fun phoning Fon.','fon.png','2018-09-17 13:06:42'),(54,'Fon','fon@unlikelysource.com','http://unlikelysource.com/','Fon phone home.','fon.png','2018-09-17 15:32:49'),(59,'Daryl','daryl@datashuttle.net','http://datashuttle.net/','Daryl dares Elle. Elle gets back. Daryl goes to Elle and back.','daryl.png','2018-11-27 11:21:40'),(60,'Josie','josie@datashuttle.net','http://datashuttle.net/','Joe see Doe. Doe no see Josie. Joe know Josie. Doe see Joe.','josie.png','2018-11-27 11:23:57');
/*!40000 ALTER TABLE `guestbook` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `listings`
--
DROP TABLE IF EXISTS `listings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `listings` (
`listings_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`category` char(16) NOT NULL,
`title` varchar(128) NOT NULL,
`date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`date_expires` timestamp NULL DEFAULT NULL,
`description` varchar(4096) DEFAULT NULL,
`photo_filename` varchar(1024) DEFAULT NULL,
`contact_name` varchar(255) DEFAULT NULL,
`contact_email` varchar(255) DEFAULT NULL,
`contact_phone` varchar(32) DEFAULT NULL,
`city` varchar(128) DEFAULT NULL,
`country` char(2) NOT NULL,
`price` decimal(12,2) NOT NULL,
`delete_code` char(16) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (`listings_id`),
KEY `title` (`title`),
KEY `category` (`category`),
KEY `delete_code` (`delete_code`)
) ENGINE=InnoDB AUTO_INCREMENT=83 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `listings`
--
LOCK TABLES `listings` WRITE;
/*!40000 ALTER TABLE `listings` DISABLE KEYS */;
INSERT INTO `listings` VALUES (2,'beauty','Discount Lipstick','2013-03-27 01:41:27',NULL,'Duis viverra dapibus nunc vel egestas. In hac habitasse platea dictumst. Nunc scelerisque elementum tellus, id laoreet dui molestie id. In lacinia rhoncus ante, et elementum ipsum ornare vitae. Donec facilisis laoreet turpis, quis sagittis lacus vestibulum at. Nullam vel arcu in tortor ullamcorper mollis. Mauris mi orci, pretium et varius id, faucibus condimentum metus. Nunc a dolor diam, quis viverra tellus. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Duis tempor urna ac tortor placerat id mattis ipsum consectetur. Nunc et purus mi, ac lacinia turpis. Aenean tristique libero ac turpis hendrerit tincidunt sodales urna fermentum. Donec eleifend, elit in tempor vehicula, massa lectus vulputate ipsum, non imperdiet diam metus at libero. Vestibulum quis molestie orci. Integer non vulputate libero. Mauris elit elit, tempus in consectetur ac, hendrerit ac leo.','/images/beauty/beauty_discount_on_lipstick.png','Phil Ayala','phil.ayala@telewest.com','+1 678-833-8754','Atlanta','US',8774.74,NULL),(3,'beauty','Handmade Jewelry','2013-05-05 07:18:44',NULL,'Nam tempor leo non risus blandit lobortis. Quisque vestibulum tellus ac justo iaculis non semper neque congue. Nam fermentum tincidunt turpis, vel tincidunt tellus cursus sit amet. Praesent a nulla quis mauris suscipit tincidunt. Sed porttitor elementum suscipit. Aliquam erat volutpat. Aliquam fringilla congue tincidunt. Integer ac arcu nec purus bibendum fermentum. Curabitur neque nulla, ultrices eget hendrerit volutpat, viverra quis nunc. Donec nisl risus, tempor id porttitor non, pellentesque vitae sem. Nulla facilisi.','/images/beauty/beauty_karthikeyan_ruby_flatmix.png','Alfred Cohen','alfred.cohen@bellcon.net','+55 11-946-6214','Santo Andr','BR',1667.63,NULL),(6,'barter','Luggage','2013-01-09 15:43:06',NULL,'Luis Vitton designer luggage set, mint condition. Will barter for a set of Wallis Snow Tires or any reasonable offer.','/images/barter/barter_luggage.png','Herman Hyde','herman.hyde@telecentral.net','+44 1709-728-550','Rotherham','GB',9292.46,NULL),(7,'clothing','Discount Dresses -- Many Styles','2013-01-19 12:59:16',NULL,'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec id mauris massa. Nam vel metus elit. Duis consectetur nisi ac felis porttitor volutpat. Donec consectetur odio nec turpis imperdiet at tempor velit facilisis. In velit mi, aliquam nec consectetur id, vehicula sed sapien. Maecenas semper arcu sit amet tortor bibendum viverra. Cras aliquam elit non velit tincidunt et eleifend ipsum cursus. Nulla pulvinar consequat lacus eget interdum.','/images/clothing/clothing_dress.png','Buddy Stark','buddy.stark@teleeast.com','+91 5564-729-851','Padrauna','IN',1261.71,NULL),(8,'clothing','Original Indiana Jones Hat','2013-09-25 02:54:55',NULL,'Proin posuere egestas dictum. Nunc condimentum consectetur auctor. Donec eget nisl id tortor imperdiet fermentum. Proin auctor rhoncus velit quis commodo. Proin nisi ipsum, commodo a congue a, egestas vitae dolor. Donec pretium adipiscing urna, non scelerisque tortor pharetra sed. Praesent vitae dictum elit. Phasellus consectetur dignissim pellentesque. Morbi neque turpis, pretium ac suscipit sit amet, tempor at tortor.','/images/clothing/clothing_indiana_jones_hat.png','Emil Freeman','emil.freeman@commcentral.net','+1 812-148-1812','Evansville','US',1234.00,NULL),(9,'clothing','Discount Jeans','2013-03-11 02:39:08',NULL,'Pellentesque non ligula id tortor varius sagittis. Donec ac ante massa, et ultrices metus. Vestibulum aliquet egestas nunc eu iaculis. Donec vel sapien lacus. Nullam elit mauris, facilisis eget aliquam a, lacinia quis odio. Morbi imperdiet pellentesque tristique. Phasellus mattis ligula eget neque laoreet iaculis. Aenean et consectetur ligula. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Aliquam laoreet, enim ac luctus molestie, metus neque scelerisque nunc, a suscipit nibh velit id sem.','/images/clothing/clothing_jeans.png','Isaac Patel','isaac.patel@mediasouth.com','+31 30-428-9706','de Meern','NL',8431.17,NULL),(10,'clothing','Red Hat','2013-12-25 06:50:15',NULL,'Sed enim lacus, mollis a blandit ac, convallis non nisl. Integer dolor ipsum, lacinia in adipiscing vitae, gravida sit amet arcu. Cras dignissim vehicula mi in tempus. Donec ut euismod lectus. Cras lectus sapien, tristique sed mollis at, tincidunt in nisi. Quisque sollicitudin, dui vitae cursus lobortis, lacus nibh scelerisque felis, eget lacinia lectus nibh et odio. Sed ut magna eu purus tristique imperdiet. Phasellus eleifend vestibulum metus id feugiat. Nullam pellentesque tincidunt mollis. Aenean auctor posuere malesuada. Integer hendrerit laoreet nunc eget rhoncus. Ut viverra lacinia est quis malesuada. Morbi ultrices rhoncus dictum. Praesent iaculis placerat suscipit.','/images/clothing/clothing_red_hat.png','Ethan Chan','ethan.chan@mediasouth.net','+91 6226-950-476','Sitamarhi','IN',8370.72,NULL),(12,'clothing','Classic Keds Tennis Shoes','2013-08-23 08:39:10',NULL,'Donec ac libero magna, ut cursus turpis. Fusce libero massa, volutpat non malesuada a, commodo id elit. In a dui sem, eu lacinia elit. Sed pharetra lacinia risus ultricies tincidunt. Integer scelerisque dui in ipsum vehicula quis suscipit sapien dictum. Proin ullamcorper egestas adipiscing. Sed quis nisi laoreet odio feugiat pulvinar nec ac purus. Nulla volutpat porta justo quis bibendum. Praesent a quam ut libero porta interdum. Cras eu lectus neque, et mollis enim. Pellentesque non mollis sem. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Aenean a sollicitudin felis.','/images/clothing/clothing_shoe.png','Jimmy Gilbert','jimmy.gilbert@mediawest.com','+91 7432-502-870','Jhalawar','IN',7688.26,NULL),(13,'clothing','Grey Suit','2013-06-18 18:24:06',NULL,'Integer pharetra ipsum sed leo vehicula pellentesque sodales metus suscipit. Praesent mollis vestibulum mollis. Sed suscipit orci pellentesque lectus volutpat et fringilla nunc laoreet. Praesent pulvinar ullamcorper sem, eget sagittis nisi ornare quis. Nunc condimentum, massa ac sollicitudin pharetra, tellus metus mattis felis, nec feugiat metus tortor vitae urna. Nam id rutrum purus. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos.','/images/clothing/clothing_suit_grey.png','Ismael Gay','ismael.gay@telenorth.net','+91 40-244-7621','Hyderabad','IN',8761.07,NULL),(14,'clothing','T Shirts','2013-09-05 20:57:50',NULL,'Integer pharetra ipsum sed leo vehicula pellentesque sodales metus suscipit. Praesent mollis vestibulum mollis. Sed suscipit orci pellentesque lectus volutpat et fringilla nunc laoreet. Praesent pulvinar ullamcorper sem, eget sagittis nisi ornare quis. Nunc condimentum, massa ac sollicitudin pharetra, tellus metus mattis felis, nec feugiat metus tortor vitae urna. Nam id rutrum purus. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos.','/images/clothing/clothing_t_shirts.png','Byron Medina','byron.medina@belleast.net','+233 22-579-8841','Tema','GH',740.56,NULL),(15,'computer','3.5 Inch Diskettes','2013-04-06 23:45:15',NULL,'Duis viverra dapibus nunc vel egestas. In hac habitasse platea dictumst. Nunc scelerisque elementum tellus, id laoreet dui molestie id. In lacinia rhoncus ante, et elementum ipsum ornare vitae. Donec facilisis laoreet turpis, quis sagittis lacus vestibulum at. Nullam vel arcu in tortor ullamcorper mollis. Mauris mi orci, pretium et varius id, faucibus condimentum metus. Nunc a dolor diam, quis viverra tellus. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Duis tempor urna ac tortor placerat id mattis ipsum consectetur. Nunc et purus mi, ac lacinia turpis. Aenean tristique libero ac turpis hendrerit tincidunt sodales urna fermentum. Donec eleifend, elit in tempor vehicula, massa lectus vulputate ipsum, non imperdiet diam metus at libero. Vestibulum quis molestie orci. Integer non vulputate libero. Mauris elit elit, tempus in consectetur ac, hendrerit ac leo.','/images/computer/computer_3.5_diskettes.png','Marvin Bradford','marvin.bradford@telenorth.net','+91 7642-344-727','Mandla','IN',7419.58,NULL),(16,'computer','Slightly Used Cray-1 for Sale','2013-10-18 19:02:33',NULL,'Nam leo odio, sollicitudin ac lobortis eu, luctus a quam. Aliquam aliquam ullamcorper elementum. Curabitur vehicula diam a lorem dapibus in pretium lorem tristique. Integer vitae nibh id elit auctor vulputate. Morbi aliquam est ut eros aliquam eu auctor est consequat. Donec viverra, nunc ut pretium pretium, ante velit dignissim nibh, bibendum tincidunt erat dui at lacus. Donec non quam at ligula tincidunt placerat. Proin augue dolor, lobortis in condimentum ut, suscipit quis eros. Cras justo leo, pretium at vulputate nec, placerat a diam. Quisque volutpat dui vel sapien fermentum bibendum. Morbi et metus ut mi interdum egestas. Nam dictum turpis at ipsum gravida volutpat. Nullam eget lorem vel tellus consectetur pellentesque fringilla at lorem. Integer volutpat blandit ante eu luctus. Integer pellentesque quam quis nulla ornare in sodales ipsum elementum. Donec et felis vel leo interdum scelerisque sed nec nisi. ','/images/computer/computer_cray_1.png','Merle Vang','merle.vang@mediawest.com','+91 233-410-4288','Sangli','IN',8800000.00,NULL),(17,'computer','HP Desktop Computer -- Base Unit','2013-02-04 22:23:12',NULL,'Aenean egestas, urna id interdum venenatis, tellus magna varius leo, sed laoreet urna turpis sit amet tortor. Curabitur molestie, ligula eu dapibus egestas, arcu ipsum egestas ante, tempor sodales lectus lacus eu odio. Aenean neque odio, viverra eu pharetra at, sollicitudin porta diam. Ut volutpat mattis mi. Etiam egestas luctus metus nec laoreet. Donec bibendum justo at ipsum tempor sit amet tincidunt nisl hendrerit. Maecenas lacinia convallis tincidunt. Maecenas dictum congue accumsan. Phasellus vel ante ac velit tempor tincidunt. Vivamus est dolor, lobortis a laoreet et, vulputate in nibh. In eget pretium ligula. Cras tristique fermentum mattis. Sed scelerisque varius rhoncus.','/images/computer/computer_hp.png','Drew Melendez','drew.melendez@teleeast.com','+91 761-936-9507','Jabalpur','IN',234.00,NULL),(18,'computer','Laptop for Sale','2013-06-05 01:44:13',NULL,'Morbi et interdum tellus. Vivamus eu ipsum turpis, quis semper lacus. Duis sagittis elementum sem ut varius. Cras fringilla, neque dictum adipiscing lobortis, erat lorem volutpat felis, quis sagittis turpis diam ut quam. Praesent ac vestibulum mauris. Donec pulvinar iaculis justo, at vulputate sapien malesuada id. Duis sit amet neque nibh, non suscipit dolor. Vestibulum bibendum lorem libero. Phasellus vestibulum malesuada hendrerit. Vivamus euismod placerat tellus, id iaculis eros fringilla nec. Nullam viverra, lorem sed vehicula lobortis, diam mi gravida nulla, a laoreet mi leo suscipit velit. Sed velit eros, lobortis ac fermentum sed, lacinia a nunc. Duis neque nulla, interdum sit amet convallis sit amet, molestie quis libero. Curabitur rutrum risus consequat eros ullamcorper facilisis. Maecenas nisi arcu, malesuada quis rutrum non, eleifend at dui.','/images/computer/computer_laptop.png','Emil Sawyer','emil.sawyer@commcon.com','+33 2-860-0826','Rouen','FR',439.00,NULL),(19,'computer','Original Compaq Luggable','2013-07-15 19:11:28',NULL,'Sed enim lacus, mollis a blandit ac, convallis non nisl. Integer dolor ipsum, lacinia in adipiscing vitae, gravida sit amet arcu. Cras dignissim vehicula mi in tempus. Donec ut euismod lectus. Cras lectus sapien, tristique sed mollis at, tincidunt in nisi. Quisque sollicitudin, dui vitae cursus lobortis, lacus nibh scelerisque felis, eget lacinia lectus nibh et odio. Sed ut magna eu purus tristique imperdiet. Phasellus eleifend vestibulum metus id feugiat. Nullam pellentesque tincidunt mollis. Aenean auctor posuere malesuada. Integer hendrerit laoreet nunc eget rhoncus. Ut viverra lacinia est quis malesuada. Morbi ultrices rhoncus dictum. Praesent iaculis placerat suscipit.','/images/computer/computer_original_compaq.png','Anton Lewis','anton.lewis@mediacon.com','+64 765-491-3440','Richmond','NZ',999.00,NULL),(20,'household','Ikea Computer Desk','2013-04-26 21:05:12',NULL,'Morbi et interdum tellus. Vivamus eu ipsum turpis, quis semper lacus. Duis sagittis elementum sem ut varius. Cras fringilla, neque dictum adipiscing lobortis, erat lorem volutpat felis, quis sagittis turpis diam ut quam. Praesent ac vestibulum mauris. Donec pulvinar iaculis justo, at vulputate sapien malesuada id. Duis sit amet neque nibh, non suscipit dolor. Vestibulum bibendum lorem libero. Phasellus vestibulum malesuada hendrerit. Vivamus euismod placerat tellus, id iaculis eros fringilla nec. Nullam viverra, lorem sed vehicula lobortis, diam mi gravida nulla, a laoreet mi leo suscipit velit. Sed velit eros, lobortis ac fermentum sed, lacinia a nunc. Duis neque nulla, interdum sit amet convallis sit amet, molestie quis libero. Curabitur rutrum risus consequat eros ullamcorper facilisis. Maecenas nisi arcu, malesuada quis rutrum non, eleifend at dui.','/images/household/household_computer_desk.png','Mario Wooten','mario.wooten@bellcon.net','+1 867-706-3327','Wekweti','CA',49.95,NULL),(22,'property','Mountainside Plot of Land for Sale','2013-11-21 14:52:21',NULL,'Donec ac libero magna, ut cursus turpis. Fusce libero massa, volutpat non malesuada a, commodo id elit. In a dui sem, eu lacinia elit. Sed pharetra lacinia risus ultricies tincidunt. Integer scelerisque dui in ipsum vehicula quis suscipit sapien dictum. Proin ullamcorper egestas adipiscing. Sed quis nisi laoreet odio feugiat pulvinar nec ac purus. Nulla volutpat porta justo quis bibendum. Praesent a quam ut libero porta interdum. Cras eu lectus neque, et mollis enim. Pellentesque non mollis sem. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Aenean a sollicitudin felis.','/images/property/property_Snowscape.png','Dollie Pitts','dollie.pitts@mediacon.net','+7 475-582-9388','Tambov','RU',1200000.00,NULL),(23,'sporting','Hot Air Balloon','2013-05-26 12:22:59',NULL,'Slightly used, a couple of dents in the basket, only crashed once. A bargain at any price!','/images/sporting/sporting_hot-air-baloon.png','Wilma Parker','wilma.parker@telecentral.net','+55 55-229-4322','Uruguaiana','BR',29000.00,NULL),(24,'sporting','Karate Lessons','2013-02-01 03:32:33',NULL,'Pellentesque non ligula id tortor varius sagittis. Donec ac ante massa, et ultrices metus. Vestibulum aliquet egestas nunc eu iaculis. Donec vel sapien lacus. Nullam elit mauris, facilisis eget aliquam a, lacinia quis odio. Morbi imperdiet pellentesque tristique. Phasellus mattis ligula eget neque laoreet iaculis. Aenean et consectetur ligula. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Aliquam laoreet, enim ac luctus molestie, metus neque scelerisque nunc, a suscipit nibh velit id sem.','/images/sporting/sporting_PackardJennings_Karate_girl_breaks_board.png','Ora Armstrong','ora.armstrong@telecon.net','+1 830-540-5472','New Braunfels','US',4876.22,NULL),(25,'transportation','Golf Cart','2013-05-26 16:01:06',NULL,'Nam porttitor metus quis eros imperdiet fermentum. Quisque scelerisque pellentesque mauris, ultricies sagittis tellus ultrices aliquam. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse tempus accumsan lectus et pharetra. Donec sed risus eu mauris eleifend fermentum. Fusce ipsum arcu, accumsan ac accumsan sed, consequat sed dui. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos.','/images/transportation/transportation_johnny_automatic_golf_cart.png','Jerri Eaton','jerri.eaton@mediawest.com','+91 7592-309-198','Vidisha','IN',2999.00,NULL),(26,'transportation','Used Ocean Liner','2013-05-28 03:51:12',NULL,'Fantastic bargain for the discerning buyer. Only been around the world once. Mainly used by a member of the Royal Family on Sundays.','/images/transportation/transportation_johnny_automatic_ocean_liner.png','Leanna Pruitt','leanna.pruitt@belleast.net','+7 41322-399-919','Magadan','RU',299000000.00,NULL),(27,'transportation','Syrena 105 for Sale','2013-01-13 01:31:23',NULL,'Mint condition. Only driven by a grandmother on Sundays.','/images/transportation/transportation_koconmus_Syrena_105.png','Chrystal Reed','chrystal.reed@bellcon.net','+44 115-868-2599','Nottingham','GB',14995.00,NULL),(28,'transportation','Non-Street-Legal Limited Edition Lotus Exige','2013-01-17 10:31:32',NULL,'Nam tempor leo non risus blandit lobortis. Quisque vestibulum tellus ac justo iaculis non semper neque congue. Nam fermentum tincidunt turpis, vel tincidunt tellus cursus sit amet. Praesent a nulla quis mauris suscipit tincidunt. Sed porttitor elementum suscipit. Aliquam erat volutpat. Aliquam fringilla congue tincidunt. Integer ac arcu nec purus bibendum fermentum. Curabitur neque nulla, ultrices eget hendrerit volutpat, viverra quis nunc. Donec nisl risus, tempor id porttitor non, pellentesque vitae sem. Nulla facilisi.','/images/transportation/transportation_lotus.png','Reyna Holman','reyna.holman@bellnorth.com','+91 6792-747-360','Baripada','IN',69999.00,NULL),(29,'transportation','Skoda Fabia','2013-08-22 13:02:04',NULL,'Nam leo odio, sollicitudin ac lobortis eu, luctus a quam. Aliquam aliquam ullamcorper elementum. Curabitur vehicula diam a lorem dapibus in pretium lorem tristique. Integer vitae nibh id elit auctor vulputate. Morbi aliquam est ut eros aliquam eu auctor est consequat. Donec viverra, nunc ut pretium pretium, ante velit dignissim nibh, bibendum tincidunt erat dui at lacus. Donec non quam at ligula tincidunt placerat. Proin augue dolor, lobortis in condimentum ut, suscipit quis eros. Cras justo leo, pretium at vulputate nec, placerat a diam. Quisque volutpat dui vel sapien fermentum bibendum. Morbi et metus ut mi interdum egestas. Nam dictum turpis at ipsum gravida volutpat. Nullam eget lorem vel tellus consectetur pellentesque fringilla at lorem. Integer volutpat blandit ante eu luctus. Integer pellentesque quam quis nulla ornare in sodales ipsum elementum. Donec et felis vel leo interdum scelerisque sed nec nisi. ','/images/transportation/transportation_ryanlerch_fabia_all_views.png','Rena Keller','rena.keller@telecentral.com','+91 2462-469-437','Nanded','IN',2999.00,NULL),(30,'wanted','Viking Longship Wanted','2013-11-16 13:32:05',NULL,'Must be in working order. Urgent! Must meet deadline for a few raids along the English coast.','/images/wanted/wanted_GMcGlinn_Viking_Longship.png','Josie Morales','josie.morales@commwest.com','+46 671-501-0054','Hoting','SE',2122.36,NULL),(31,'general','Instant Camera','2013-07-12 00:08:03',NULL,'Morbi et interdum tellus. Vivamus eu ipsum turpis, quis semper lacus. Duis sagittis elementum sem ut varius. Cras fringilla, neque dictum adipiscing lobortis, erat lorem volutpat felis, quis sagittis turpis diam ut quam. Praesent ac vestibulum mauris. Donec pulvinar iaculis justo, at vulputate sapien malesuada id. Duis sit amet neque nibh, non suscipit dolor. Vestibulum bibendum lorem libero. Phasellus vestibulum malesuada hendrerit. Vivamus euismod placerat tellus, id iaculis eros fringilla nec. Nullam viverra, lorem sed vehicula lobortis, diam mi gravida nulla, a laoreet mi leo suscipit velit. Sed velit eros, lobortis ac fermentum sed, lacinia a nunc. Duis neque nulla, interdum sit amet convallis sit amet, molestie quis libero. Curabitur rutrum risus consequat eros ullamcorper facilisis. Maecenas nisi arcu, malesuada quis rutrum non, eleifend at dui.','/images/general/general_instantcamera.png','Letitia West','letitia.west@telewest.net','+1 606-294-1819','London','US',5983.13,NULL),(32,'transportation','Restored Italian Streetcar from Milano','2013-11-10 01:52:34',NULL,'Duis viverra dapibus nunc vel egestas. In hac habitasse platea dictumst. Nunc scelerisque elementum tellus, id laoreet dui molestie id. In lacinia rhoncus ante, et elementum ipsum ornare vitae. Donec facilisis laoreet turpis, quis sagittis lacus vestibulum at. Nullam vel arcu in tortor ullamcorper mollis. Mauris mi orci, pretium et varius id, faucibus condimentum metus. Nunc a dolor diam, quis viverra tellus. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Duis tempor urna ac tortor placerat id mattis ipsum consectetur. Nunc et purus mi, ac lacinia turpis. Aenean tristique libero ac turpis hendrerit tincidunt sodales urna fermentum. Donec eleifend, elit in tempor vehicula, massa lectus vulputate ipsum, non imperdiet diam metus at libero. Vestibulum quis molestie orci. Integer non vulputate libero. Mauris elit elit, tempus in consectetur ac, hendrerit ac leo.','/images/transportation/transportation_SteveLambert_Milan_Streetcar.png','Darcy Valentine','darcy.valentine@bellsouth.net','+1 423-975-9608','Chattanooga','US',149999.00,NULL),(33,'barter','Newly Fallen Snowflakes','2013-01-04 14:55:04',NULL,'Guaranteed fresh! Recently fallen. Make a snowball, make a snowman. Surprise your friends.','/images/barter/barter_snowflakes2.png','Ila Justice','ila.justice@telenorth.net','+44 1189-533-365','Reading','UK',22.50,NULL),(34,'entertainment','Theresa Knott Grand Piano','2013-01-04 14:59:23',NULL,'Full sized replica of a classic 9 foot long Steinway Grand Piano. New manufacturing techniques results in drastically lower costs. Quantities limited! Get one while they last! Buy one for a friend. Everybody should have one in their living room!','/images/entertainment/entertainment_TheresaKnott_piano.png','Dollie Pitts','dollie.pitts@mediacon.com','+1 212-780-4726','New York','US',19.99,NULL),(36,'household','Cheap Lightbulbs','2013-01-11 14:08:11',NULL,'Cheap lightbulbs designed to last exactly 99 days. All purchases include a manufacturer\'s warranty of 3 months. You can\'t go wrong! Buy some for your in-laws.','/images/household/household_lightbulb.png','Joe','joe@joe.com','+1 555-666-7777','Aachen','DE',0.01,'123456'),(37,'health','Effective Sleeping Course','2013-01-12 09:55:48',NULL,'This course will give you a foundation level understanding on how to sleep effectively. See the complimentary course on Advanced Sleep Techniques.','/images/health/health_sleeping.png','Nolan Somnia','nolan@bt.net','+44 123-456-7890','Aix en Provence','FR',1295.00,'123456'),(38,'property','Used City for Sale','2013-01-12 10:22:28','2013-02-11 10:22:28','Beautiful seaside city, slightly used, but mainly only on Sundays. Will entertain any reasonable offer. Must unload this city ASAP: council taxes are due!','/images/property/property_city.png','Eric Ritchie','eric@zend.com','+44 1224-888-999','Aberdeen','GB',2999999.00,'123456 ABCD'),(41,'free','Free Money','2013-01-12 21:53:18','2013-01-13 21:53:18','Free money, just 9.99. What a bargain!','/images/free/free_bag_of_money.png','Jacques Gratuit','jfree@free.com','+33 222-333-4444','Aix en Provence','FR',9.99,'123456'),(43,'health','Exercise Bicycle','2013-01-13 18:12:26','2013-01-20 18:12:26','Exercise bike for sale. Mint condition. Mainly used on Sundays.','/images/health/health_exercise_bike.png','Julia Roberts','jroberts@someplace.net','+61 399-888-7777','Melbourne','AU',299.99,'123456'),(44,'household','Gas Mask for Sale','2013-01-13 19:32:04',NULL,'Used only one time: worked pretty well. No household should be without one!','/images/household/household_gas_mask.png','Irene Smith','irene@bellwest.com','+1 555-666-7777','Aachen','DE',129.00,'123456'),(45,'wanted','Al Capone','2013-01-14 16:14:12',NULL,'It is believed that the notorious gangster Al Capone has been somehow brought back from the dead, and is once again on the loose, terrorizing innocent citizens. Any person coming forward with information leading to his re-arrest will be rewarded with the princely sum of $599.','http://upload.wikimedia.org/wikipedia/commons/thumb/d/d0/AlCaponemugshotCPD.jpg/320px-AlCaponemugshotCPD.jpg','Elliott Ness','eness@untouchables.gov','+1 312-555-1212','Chicago','US',599.00,'123456'),(47,'entertainment','Real Live Exploding Black Bombs','2013-01-17 11:09:09','2013-02-16 11:09:09','Be the life of the party. Amaze your friends. This explosive new form of entertainment will leave them talking about the event for years to come. Every kid should have one!','/images/entertainment/entertainment_black_bomb.png','Boris Badanov','boris@rocky.n.bullwinkle.com','+7 495-555-6666','Moscow','RU',9.99,'123456'),(49,'free','Free City','2013-01-25 13:20:18',NULL,'How would you like to own the beautiful city of Paris, France? For a limited time only, this city is on offer for the incredible price of 100% absolutely free! Contact owner for details. [Fine print: there is a minor matter of a few billion Euro in outstanding taxes, but that\'s life, right?)','http://upload.wikimedia.org/wikipedia/commons/thumb/6/6e/Paris_-_Eiffelturm_und_Marsfeld2.jpg/233px-Paris_-_Eiffelturm_und_Marsfeld2.jpg','Julius Caesar','julius@romanempire.com','+0 000-000-0000','Paris',' F',0.00,'123456'),(50,'barter','Slightly Used Battleship for Sale','2013-01-26 12:03:16','2013-02-25 12:03:16','Slightly used battleship available to trade for a nuclear submarine in reasonable condition. This is a great battleship which had on board such notable celebrities as Frank Sinatra and General Douglas MacArthur. Used mainly on Sundays.','http://upload.wikimedia.org/wikipedia/commons/thumb/e/e8/Missouri_post_refit.JPG/300px-Missouri_post_refit.JPG','Chester Nimitz','nimitz@navy.us.gov','+1 555-666-77777','New York','US',4999999.00,'123456'),(51,'garden','Common Garden Variety Goats for Sale','2013-01-26 20:12:39','2013-01-26 20:12:39','Great around gardens because they eat *anything*: worms, grubs, pests, rotten fruit, small household pets ... and even all of your produce (but who really cares about that as long as your produce is healthy, right?).','http://upload.wikimedia.org/wikipedia/commons/thumb/b/b2/Hausziege_04.jpg/256px-Hausziege_04.jpg','The Old Goat','oldgoat@crankyoldgoat.com','+44 222-333-4444','London','UK',299.99,'123456'),(52,'free','Tibetan Terrier Needs a Home!','2013-01-28 10:10:05','2013-02-27 10:10:05','Lovely Tibetan Terrier needs a home ASAP!','https://upload.wikimedia.org/wikipedia/commons/thumb/7/75/4_Year_Old_Female_Tibetan_Dagny.jpg/800px-4_Year_Old_Female_Tibetan_Dagny.jpg','Jane Sad','sad@needshome.org','+31 222-333','Paris','FR',0.00,'123456'),(53,'wanted','World Peace','2017-06-20 07:52:05','2017-06-20 07:52:05','World peace or peace on Earth is an ideal state of freedom, peace, and happiness among and within all nations and people. This ideal of world non-violence provides a basis for peoples and nations to willingly cooperate, either voluntarily or by virtue of a system of governance that prevents warfare. While different cultures, religions, philosophies, and organizations may have differing concepts about how such an ideal state might come about, they have in common this ideal of a cessation of all hostility amongst all humanity.','/images/wanted/wanted_world_peace.jpg','Mr. Sane','somebody.sane@whats.this.world.coming.to.com','00-999-888-7777','Paris','FR',999999999.99,'12345'),(54,'wanted','Last Known Address of J Caesar','2017-06-21 05:24:57','2017-07-20 22:24:57','The scoundrel was last seen fleeing in a boat heading for Sicily. Would pay more but he took all the money in our treasury. If you hear rumors that this individual was murdered, don\'t believe it for a second ... and DON\'T BLAME ME. You should really be asking about that Calpurnia.','/images/wanted/wanted_la_clemence_de_caesar.jpg','Cleopatrat','cleo@philopator.com','+00-000-000-0000','Cairo','EG',99.99,'12345'),(56,'garden','Elephant in the Room','2017-10-19 07:56:40','2017-11-18 07:56:40','Real live elephant for sale. Perfect for a conservatory overlooking your garden. Very quiet, makes hardly any noise, only eats vegetables. Loyal companion. Excellent conversation starter for shy visitors. As an example, your shy guest might start the conversation with an apologetic perhaps fearful eye gesture, followed by, \"can we talk about the Elephant in the Room now?\"','https://upload.wikimedia.org/wikipedia/commons/6/6a/African_Forest_Elephant.jpg','M. Tocks In','mtoks@manchester.co.uk','+66-111-222-3333','Surin','TH',99.99,'12345'),(57,'barter','Bend It Like Beckham','2017-11-06 17:04:47','2017-11-07 17:04:47','Willing to trade used footballer for younger model.','https://upload.wikimedia.org/wikipedia/commons/thumb/9/9e/Beckswimbledon.jpg/250px-Beckswimbledon.jpg','Victoria','vicky@not.so.spicy.com','+44-888-999-0000','London','UK',99.99,'12345'),(58,'property','Prime Lakeside Property','2017-11-16 04:44:12','2017-11-16 04:44:12','Prime lakeside property for sale in Bangkok','https://upload.wikimedia.org/wikipedia/commons/thumb/3/3e/Aerial_view_of_Lumphini_Park.jpg/1280px-Aerial_view_of_Lumphini_Park.jpg','The Prime Minister','prime@gov.co.th','+66-111-222-3333','Bangkok','TH',999.99,'12345'),(59,'computer','Used Classic Computer','2017-11-16 04:59:47','2017-11-16 04:59:47','Used classic computer','https://upload.wikimedia.org/wikipedia/commons/thumb/e/e9/Commodore-64-Computer-FL.jpg/1280px-Commodore-64-Computer-FL.jpg','Some Geek','geek@used.computer.com','111-222-3333','New York','US',999.99,'12345'),(60,'barter','Swap Mall for Airport','2018-05-24 04:03:13','2018-05-25 04:03:13','Want to swap slightly used shopping mall for a *real* airport. Doggoned developer sold me this piece of trash and swore up and down it was an airport terminal. @#$&#@&*#*$&#*#$)','http://cdn-cms.pgimgs.com/news/2016/02/Terminal-21-Korat_inside.jpg','M. Shopping','shops@alotofstuff.com','111-111-1111','Korat','TH',99.99,'12345'),(61,'health','Politicians For Sale','2018-06-12 07:15:00','2018-06-12 07:15:00','Politicians for sale. Guaranteed results! If you really really need to dump tons of toxic waste, but are being held back by pesky regulations ... SAY NO MORE! Need tax cuts? Are you being held back from buying an island, a small country, or building your 21st mansion? SAY NO MORE! If your net worth is less than $1M USD please do not apply.\nFREE GIFTS INCLUDED: 1 Presidential Pardon for *any* crime you have, or are planning, to commit; 1 language course in Russian.','https://openclipart.org/download/278113/HandOfferingMoney.svg','\"The\" Ronald Dump','ronald@dump.com','111-111-1111','Washington DC','US',99.99,'12345'),(63,'wanted','Waterfall','2018-06-19 09:28:37','2018-07-19 09:28:37','Waterfall sought to supplement city water supply. The bigger the better. Niagara Falls or its equivalent preferred. Contact Ms. de Lille for more information.','https://upload.wikimedia.org/wikipedia/commons/thumb/a/ab/3Falls_Niagara.jpg/220px-3Falls_Niagara.jpg','Patricia de Lille','contact.us@capetown.gov.za','+27-021-400-1111','Capetown','SA',99.99,'12345'),(64,'garden','Live Volcano','2018-06-22 08:32:45','2018-07-22 01:32:45','Live volcano for sale. Perfect natural source of energy. Provides so much backlighting you won\'t need to turn on the lights at night. Once this beauty is installed you\'ll be the talk of the neighborhood. But not to worry: soon you won\'t have any neighbors, trust us. Bargain price. You will need to provide a means of transporting it.','https://upload.wikimedia.org/wikipedia/commons/thumb/8/89/P%C4%81hoehoe_and_Aa_flows_at_Hawaii.jpg/1280px-P%C4%81hoehoe_and_Aa_flows_at_Hawaii.jpg','NGS','got_a_live_one@ngs.gov','+1 111-111-1111','Hilo HI','US',99.99,'12345'),(65,'barter','Sled Dogs','2018-06-22 15:42:02','2018-06-23 08:42:02','Want to trade a Pomeranian for a *real* sled dog. Bought this one over the Internet ... and the doggone thing (uh ... pardon the pun) just plain never grew up!','https://upload.wikimedia.org/wikipedia/commons/thumb/6/6a/Pomeranian_600.jpg/220px-Pomeranian_600.jpg','S. Kimo','itz@very.cold.outside.us','+1-907-459-2700','Fairbanks AK','US',99.99,'12345'),(66,'free','Free Hurricane','2018-09-12 07:48:34','2018-10-12 07:48:34','Large hurricane on offer. Certified by the White House in Washington, DC to be \"very wet\" and having \"lots of water\". You must provide own transport.','/images/free/phpSzeF1B_5b98c4d2d579f9_34326862.jpg','Florence','hurricane@very.wet.gov','111-111-1111','Charleston SC','US',99.99,'12345'),(67,'general','Looking for a General','2018-09-19 06:17:08','2018-10-18 17:00:00','General urgently needed to conduct a series of useless wars which will generate tremendous profits for my company. Apply via dropbox at the nearest secret location.','https://upload.wikimedia.org/wikipedia/commons/thumb/9/92/MacArthur_Manila.jpg/220px-MacArthur_Manila.jpg','E. Prince','eprince@academi.org','+1111-111-1111','Washington DC','US',99.99,'12345'),(68,'clothing','Hand Warmer','2018-09-27 06:29:29','2018-10-04 06:29:29','Elegant matching vest and trousers. Serves as hand warmer. Be the envy of your friends. Rule the neighborhood. Bargain price. Must sell before heading off to Elba.','https://upload.wikimedia.org/wikipedia/commons/thumb/5/50/Jacques-Louis_David_-_The_Emperor_Napoleon_in_His_Study_at_the_Tuileries_-_Google_Art_Project.jpg/800px-Jacques-Louis_David_-_The_Emperor_Napoleon_in_His_Study_at_the_Tuileries_-_Google_Art_Project.jpg','The Napster','n@bon.apart.fr','+33-444-555-6666','Paris','FR',9.99,'12345'),(69,'entertainment','Full Grown Leopard','2018-10-21 13:27:49','2018-11-20 17:00:00','Full grown leopard for sale. Makes a wonderful pet. Not good with children (it tends to eat them). Be the wonder of your neighborhood. Fantastically useful if you have a neighbor with annoying barking dogs. Within 24 hours such annoying problems will vanish for good!','https://upload.wikimedia.org/wikipedia/commons/thumb/e/eb/African_leopard%2C_Panthera_pardus_pardus%2C_near_Lake_Panic%2C_Kruger_National_Park%2C_South_Africa_%2819448654130%29.jpg/220px-African_leopard%2C_Panthera_pardus_pardus%2C_near_Lake_Panic%2C_Kruger_National_Park%2C_South_Africa_%2819448654130%29.jpg','G. Whiz','gwhiz@big.cats.com','+27-111-222-333','Peoria','SA',9.99,'12345'),(80,'tools','Orange Clown Robot Available','2018-11-07 03:51:33','2018-11-14 03:51:33','Orange Clown robot available. Upon activation the robot immediately starts stuffing its pockets with money, while drawing attention to itself by shouting loud incoherent phrases. Serves as an excellent distraction for your *real* agenda, no matter what it might be. The O.C. will also issue tax cuts for the rich, alienate friends, insult women and get rid of troublesome regulations. The only downside is that the planet will become uninhabitable in 20 years and/or WW III could start.','https://i.ytimg.com/vi/XRxASqFCUW8/maxresdefault.jpg','Moscow Mitch','mmconnell@repubs.com','+1-222-333-4444','Washington DC','US',9.99,'12345'),(81,'health','Large Air Conditioner','2018-11-27 03:58:31','2018-11-27 03:58:31','Wanted: extremely large air conditioning unit to cool down an entire planet. Willing to trade for a free trip to Mars.','https://upload.wikimedia.org/wikipedia/commons/thumb/3/3e/All_forcing_agents_CO2_equivalent_concentration.png/1280px-All_forcing_agents_CO2_equivalent_concentration.png','Everyone','all@planet.earth.com','+1-222-333-4444','Any City','PE',9999.99,'12345'),(82,'entertainment','Jimmy Dore Show','2018-12-20 14:23:47',NULL,'Watch Jimmy Dore for a comic take on the latest news. Might as well laugh while you\'re crying, right?','https://jimmydorecomedy.com/wp-content/uploads/2016/11/jimmy-dore-life-magazine-240x300.jpg','James Dore','info@jimmydorecomedy.com','+1-222-333-4444','Erie PA','US',99.99,'12345');
/*!40000 ALTER TABLE `listings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `messages`
--
DROP TABLE IF EXISTS `messages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `messages` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`message` varchar(254) NOT NULL,
`to_email` varchar(254) NOT NULL DEFAULT '',
`from_email` varchar(254) NOT NULL DEFAULT '',
`date_time` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `messages`
--
LOCK TABLES `messages` WRITE;
/*!40000 ALTER TABLE `messages` DISABLE KEYS */;
INSERT INTO `messages` VALUES (37,'4ba18c70337210f1853cb928e5a5f04fccac0aabba72e1d3dfe6b2974e0913951CbglWSVNKTJEhEkWA5ANLFXvEAL4mFTq5wUSWliwevBeZ54/++ijcjhTH6jLlvvdTINJNeDWEyH5nxB7h1qKQ==','daryl@zend.com','admin@zend.com',NULL),(38,'881eef936f5cb0781e41986381e437deec9911f6820a60fc906c39797c979b33RoKmXfhNzDXxg4Ss/XzfoXukPpPDYhdTdw4dfHMNK8g9uYn6faqhQVgV4f7/MINr7XQmENWd/sjTtpHCJGNCuQ==','doug@zend.com','admin@zend.com',NULL),(39,'b9e5e824f82ad6655f2a683bde9d62eb333c6f0a710d521404d03a5278e7bfa1UrotX8/N297iYBwv51rLi1HaU3WlIoKuUIMMOV0biZ8=','admin@zend.com','daryl@zend.com',NULL),(40,'e03285936f4a16d4b269d16fa9b169b8b4556908f67e9a5b3b6fc7ccd65d1bd6QP7NIn0rX7Tjlr6CDYGU9aQo1Jk/aXEUtlHXOwYd+SJALObANQA9haRdR9C3+5Ec84pJg+6OdlZNl3F8Yw+ZLlRwW0Y86ntXHflQFv3KKrQ=','doug@zend.com','daryl@zend.com',NULL),(41,'ec76bb900d1c378ef60108eff029d13ca3a82733712876ccb343f7cb6aec8ddeyO3VcbC1s1ZdK4UwQ3/sOg4gVDCKRr+8vEgWNY9a19Y9p2GTKb09lLXjYveTrN2d27i+vlgMLAT9bJJKi1LvKw==','daryl@zend.com','doug@zend.com',NULL),(42,'7b3d84890b788edb91f4f59afb4b098b1c09bf7741a4912d412a3a85d0f64f4fXI1MVaQHWhtujqqL7gmxK9SBfIIRGR7IIb2edVXgr09UcxyK4mpfA6BbON5e3fFqnrhjZqeZ6UHYznL8H4tm/Q==','admin@zend.com','doug@zend.com',NULL);
/*!40000 ALTER TABLE `messages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `registration`
--
DROP TABLE IF EXISTS `registration`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `registration` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`event_id` int(11) NOT NULL,
`first_name` varchar(255) NOT NULL,
`last_name` varchar(255) NOT NULL,
`registration_time` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `registration`
--
LOCK TABLES `registration` WRITE;
/*!40000 ALTER TABLE `registration` DISABLE KEYS */;
INSERT INTO `registration` VALUES (32,1,'Daryl','Wood','2018-09-17 14:57:43'),(33,1,'Doug','Bierer','2018-09-17 14:58:08'),(34,2,'Fon','Fun','2018-09-17 14:58:33'),(35,1,'Fred','Flintstone','2018-09-18 16:31:41'),(36,2,'Doug','Bierer','2018-10-11 20:32:15'),(37,2,'Test','Doug','2018-10-14 19:54:11'),(38,2,'Test','Doug','2018-10-14 19:54:33'),(39,2,'Test','2222','2018-10-14 19:55:23'),(40,1,'Test','333','2018-10-14 19:56:43'),(41,1,'Test','444','2018-10-14 20:01:35');
/*!40000 ALTER TABLE `registration` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `registration_d`
--
DROP TABLE IF EXISTS `registration_d`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `registration_d` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`event_id` int(11) DEFAULT NULL,
`first_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`last_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`registration_time` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `IDX_9FD188E871F7E88B` (`event_id`),
CONSTRAINT `FK_9FD188E871F7E88B` FOREIGN KEY (`event_id`) REFERENCES `event_d` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `registration_d`
--
LOCK TABLES `registration_d` WRITE;
/*!40000 ALTER TABLE `registration_d` DISABLE KEYS */;
INSERT INTO `registration_d` VALUES (1,1,'Doug','Bierer','2017-11-07 12:44:48'),(2,1,'Homer','Simpson','2018-06-13 16:45:10'),(3,1,'Daryl','Wood','2018-09-17 15:06:57'),(4,2,'Doug','Bierer','2018-09-17 15:07:13');
/*!40000 ALTER TABLE `registration_d` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `session_storage`
--
DROP TABLE IF EXISTS `session_storage`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `session_storage` (
`key` varchar(254) NOT NULL,
`value` text,
PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `session_storage`
--
LOCK TABLES `session_storage` WRITE;
/*!40000 ALTER TABLE `session_storage` DISABLE KEYS */;
INSERT INTO `session_storage` VALUES ('Application','C:23:\"Zend\\Stdlib\\ArrayObject\":245:{a:4:{s:7:\"storage\";a:2:{s:7:\"message\";N;s:8:\"identity\";s:2:\"{}\";}s:4:\"flag\";i:2;s:13:\"iteratorClass\";s:13:\"ArrayIterator\";s:19:\"protectedProperties\";a:4:{i:0;s:7:\"storage\";i:1;s:4:\"flag\";i:2;s:13:\"iteratorClass\";i:3;s:19:\"protectedProperties\";}}}'),('Zend_Auth','C:23:\"Zend\\Stdlib\\ArrayObject\":862:{a:4:{s:7:\"storage\";a:1:{s:7:\"storage\";O:16:\"Login\\Model\\User\":2:{s:10:\"\0*\0mapping\";a:7:{s:2:\"id\";s:2:\"id\";s:5:\"email\";s:5:\"email\";s:8:\"username\";s:8:\"username\";s:8:\"password\";s:8:\"password\";s:16:\"securityquestion\";s:17:\"security_question\";s:14:\"securityanswer\";s:15:\"security_answer\";s:6:\"locale\";s:6:\"locale\";}s:13:\"\0*\0properties\";a:9:{s:2:\"id\";s:1:\"6\";s:5:\"email\";s:14:\"admin@zend.com\";s:8:\"username\";s:5:\"admin\";s:8:\"password\";s:60:\"$2y$10$SZx5lX6/hJFb//lvocLkeessDzlL7hmr63BBmcVFC22iT/1SCZz6C\";s:16:\"securityquestion\";s:43:\"What language is Zend Framework written in?\";s:14:\"securityanswer\";s:3:\"PHP\";s:4:\"role\";s:5:\"admin\";s:8:\"provider\";s:7:\"default\";s:6:\"locale\";s:2:\"en\";}}}s:4:\"flag\";i:2;s:13:\"iteratorClass\";s:13:\"ArrayIterator\";s:19:\"protectedProperties\";a:4:{i:0;s:7:\"storage\";i:1;s:4:\"flag\";i:2;s:13:\"iteratorClass\";i:3;s:19:\"protectedProperties\";}}}'),('__ZF','C:23:\"Zend\\Stdlib\\ArrayObject\":339:{a:4:{s:7:\"storage\";a:2:{s:20:\"_REQUEST_ACCESS_TIME\";d:1537164405.119185;s:6:\"_VALID\";a:1:{s:25:\"Zend\\Session\\Validator\\Id\";s:26:\"rcvtfk02me5bembef1t6t92b8l\";}}s:4:\"flag\";i:1;s:13:\"iteratorClass\";s:13:\"ArrayIterator\";s:19:\"protectedProperties\";a:4:{i:0;s:7:\"storage\";i:1;s:4:\"flag\";i:2;s:13:\"iteratorClass\";i:3;s:19:\"protectedProperties\";}}}');
/*!40000 ALTER TABLE `session_storage` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`email` varchar(254) NOT NULL,
`username` varchar(128) DEFAULT NULL,
`password` varchar(254) DEFAULT NULL,
`security_question` varchar(254) DEFAULT NULL,
`security_answer` varchar(254) DEFAULT NULL,
`role` char(8) DEFAULT 'user',
`provider` char(8) DEFAULT 'default',
`locale` char(8) DEFAULT 'en',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'google@zend.com','OAuth',NULL,NULL,NULL,'user','google','en'),(3,'doug@zend.com','doug','$2y$10$eFpYKtvtbe8wqSCk5mDLke.5n7jr2tQ1ILV48VaWbHxULxwYsal7e','How many dogs do you have?','5','user','default','fr'),(4,'daryl@zend.com','daryl','$2y$10$Gy8fTpy1K.0Hy1iCf4S6ee5z0Hi6GUARoDHwnAf8EKIRA.XrRLIma','What is your favorite sport?','Kayaking','user','default','en'),(6,'admin@zend.com','admin','$2y$10$SZx5lX6/hJFb//lvocLkeessDzlL7hmr63BBmcVFC22iT/1SCZz6C','What language is Zend Framework written in?','PHP','admin','default','en'),(12,'fred@zend.com','fred','$2y$10$IyS3Mg3705V57INkHpRnVuH4kYJF7z4H3Ld1dzgQYzVGN4K/US5fm','What is made of rock?','stone','user','default','fr'),(16,'wilma@zend.com','wilma','$2y$10$YKvhiV2.di4dM.CiRmWyqOKeBwnTG.B/G3RXcF0CsQLfW4BZiJK9q','Where is Bedrock?','nowhere','user',NULL,NULL),(17,'test2@zend.com','TestTwo','$2y$10$ikRRTH0pAlqX.IzCmJwVre7tG7Y86tqpwR8Vzc9hDo0HGMTg4zwFC','Huh?','What?','user','','');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `world_city_area_codes`
--
DROP TABLE IF EXISTS `world_city_area_codes`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `world_city_area_codes` (
`world_city_area_code_id` int(11) NOT NULL AUTO_INCREMENT,
`ISO2` char(2) DEFAULT 'XX',
`city` varchar(64) NOT NULL,
`area_code` int(6) NOT NULL,
`state_province` char(6) DEFAULT NULL COMMENT 'USA and Canada',
PRIMARY KEY (`world_city_area_code_id`),
KEY `ISO2` (`ISO2`),
KEY `city` (`city`),
KEY `city_2` (`city`)
) ENGINE=InnoDB AUTO_INCREMENT=1687 DEFAULT CHARSET=utf8 COMMENT='world cities and telephone area codes';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `world_city_area_codes`
--
LOCK TABLES `world_city_area_codes` WRITE;
/*!40000 ALTER TABLE `world_city_area_codes` DISABLE KEYS */;
INSERT INTO `world_city_area_codes` VALUES (1,'GB','Aberdeen',1224,''),(2,'GB','Belfast City',28,''),(3,'GB','Birmingham',121,''),(4,'GB','Blackburn',1254,''),(5,'GB','Blackpool',1253,''),(6,'GB','Bolton',1204,''),(7,'GB','Bournemouth',1202,''),(8,'GB','Bradford',1274,''),(9,'GB','Brighton',1273,''),(10,'GB','Bristol',117,''),(11,'GB','Cambridge',1223,''),(12,'GB','Cardiff',29,''),(13,'GB','Carlisle',859,''),(14,'GB','Chelsea',205,''),(15,'GB','Chester',563,''),(16,'GB','Colchester',1206,''),(17,'GB','Coventry',24,''),(18,'GB','Crawley',1293,''),(19,'GB','Derby',1332,''),(20,'GB','Dover',302,''),(21,'GB','Dudley',1384,''),(22,'GB','Eastbourne',1323,''),(23,'GB','Edinburgh',131,''),(24,'GB','Glasgow',141,''),(25,'GB','Gloucester',1452,''),(26,'GB','Gosport',251,''),(27,'GB','Greenwich',20,''),(28,'GB','Huddersfield',1484,''),(29,'GB','Ipswich',1473,''),(30,'GB','Kingston upon Hull',1482,''),(31,'GB','Lancaster',913,''),(32,'GB','Leeds',113,''),(33,'GB','Leicester',116,''),(34,'GB','Lincoln',217,''),(35,'GB','Liverpool',151,''),(36,'GB','London',20,''),(37,'GB','Luton',1582,''),(38,'GB','Manchester',161,''),(39,'GB','Middlesbrough',1642,''),(40,'GB','Milton Keynes',1908,''),(41,'GB','Newcastle upon Tyne',191,''),(42,'GB','Northampton',1604,''),(43,'GB','Norwich',1603,''),(44,'GB','Nottingham',115,''),(45,'GB','Oldham',161,''),(46,'GB','Oxford',1865,''),(47,'GB','Peterborough',1733,''),(48,'GB','Plymouth',1752,''),(49,'GB','Poole',1202,''),(50,'GB','Portland',207,''),(51,'GB','Portsmouth',23,''),(52,'GB','Preston',1772,''),(53,'GB','Reading',118,''),(54,'GB','Rotherham',1709,''),(55,'GB','Sheffield',114,''),(56,'GB','Slough',1753,''),(57,'GB','Southampton',23,''),(58,'GB','St. Helens',1744,''),(59,'GB','Stafford',620,''),(60,'GB','Stockport',161,''),(61,'GB','Sunderland',191,''),(62,'GB','Sutton Coldfield',121,''),(63,'GB','Swansea',1792,''),(64,'GB','Swindon',1793,''),(65,'GB','Telford',1952,''),(66,'GB','Walsall',1922,''),(67,'GB','Warwick',229,''),(68,'GB','Watford',1923,''),(69,'GB','West Bromwich',121,''),(70,'GB','Westminster',720,''),(71,'GB','Weymouth',781,''),(72,'GB','Winchester',913,''),(73,'GB','Windsor',757,''),(74,'GB','Wolverhampton',1902,''),(75,'GB','Worcester',774,''),(76,'GB','Worthing',605,''),(77,'GB','York',1904,''),(78,'DE','Aachen',241,''),(79,'DE','Augsburg',821,''),(80,'DE','Bergisch Gladbach',2202,''),(81,'DE','Berlin',30,''),(82,'DE','Bielefeld',521,''),(83,'DE','Bonn',228,''),(84,'DE','Bottrop',2041,''),(85,'DE','Braunschweig',531,''),(86,'DE','Bremen',421,''),(87,'DE','Bremerhaven',471,''),(88,'DE','Chemnitz',371,''),(89,'DE','Cologne',221,''),(90,'DE','Cottbus',355,''),(91,'DE','Darmstadt',6151,''),(92,'DE','Dortmund',231,''),(93,'DE','Dresden',351,''),(94,'DE','Duisburg',203,''),(95,'DE','D',211,''),(96,'DE','Erfurt',361,''),(97,'DE','Erlangen',9131,''),(98,'DE','Essen',201,''),(99,'DE','Frankfurt',69,''),(100,'DE','Frankfurt am Main',69,''),(101,'DE','Frankfurt an der Oder',335,''),(102,'DE','Freiburg',761,''),(103,'DE','F',911,''),(104,'DE','Gelsenkirchen',209,''),(105,'DE','Gera',365,''),(106,'DE','G',0,''),(107,'DE','Hagen',2331,''),(108,'DE','Halle',345,''),(109,'DE','Hamburg',40,''),(110,'DE','Hamm',2381,''),(111,'DE','Hannover',511,''),(112,'DE','Heidelberg',6221,''),(113,'DE','Heilbronn',7131,''),(114,'DE','Herne',2323,''),(115,'DE','Hildesheim',5121,''),(116,'DE','Ingolstadt',841,''),(117,'DE','Karlsruhe',721,''),(118,'DE','Kassel',561,''),(119,'DE','Kiel',431,''),(120,'DE','Koblenz',261,''),(121,'DE','Krefeld',2151,''),(122,'DE','Leipzig',341,''),(123,'DE','Leverkusen',214,''),(124,'DE','L',451,''),(125,'DE','Ludwigsburg',7141,''),(126,'DE','Ludwigshafen',621,''),(127,'DE','Magdeburg',391,''),(128,'DE','Mainz',6131,''),(129,'DE','Mannheim',621,''),(130,'DE','M',2161,''),(131,'DE','Munich',89,''),(132,'DE','Munster',251,''),(133,'DE','Neubrandenburg',395,''),(134,'DE','Neuss',2131,''),(135,'DE','Nuremberg',911,''),(136,'DE','Oberhausen',208,''),(137,'DE','Offenbach',69,''),(138,'DE','Oldenburg',441,''),(139,'DE','Osnabr',541,''),(140,'DE','Paderborn',5251,''),(141,'DE','Pforzheim',7231,''),(142,'DE','Potsdam',331,''),(143,'DE','Recklinghausen',2361,''),(144,'DE','Regensburg',941,''),(145,'DE','Remscheid',2191,''),(146,'DE','Rostock',381,''),(147,'DE','Saarbr',681,''),(148,'DE','Salzgitter',5341,''),(149,'DE','Schwerin',385,''),(150,'DE','Siegen',271,''),(151,'DE','Solingen',212,''),(152,'DE','Stuttgart',711,''),(153,'DE','Ulm',731,''),(154,'DE','Wiesbaden',611,''),(155,'DE','Wolfsburg',5361,''),(156,'DE','Wuppertal',202,''),(157,'DE','W',931,''),(158,'DE','Zwickau',375,''),(159,'IE','Arklow',402,''),(160,'IE','Cork',21,''),(161,'IE','Drogheda',41,''),(162,'IE','Dublin',1,''),(163,'IE','Ennis',65,''),(164,'IE','Galway City',91,''),(165,'IE','Kildare',45,''),(166,'IE','Killarney',64,''),(167,'IE','Limerick',61,''),(168,'IE','Sligo',71,''),(169,'IE','Tipperary',52,''),(170,'IE','Tralee',66,''),(171,'IE','Tullamore',506,''),(172,'IE','Waterford',51,''),(173,'IE','Wexford',53,''),(174,'SE','Alfta',271,''),(175,'SE','Alings',322,''),(176,'SE','',476,''),(177,'SE','Alunda',174,''),(178,'SE','',251,''),(179,'SE','Alvesta',472,''),(180,'SE','',929,''),(181,'SE','',532,''),(182,'SE','',690,''),(183,'SE','',431,''),(184,'SE','Arboga',589,''),(185,'SE','',647,''),(186,'SE','',573,''),(187,'SE','Arjeplog',961,''),(188,'SE','Arvidsjaur',960,''),(189,'SE','Arvika',570,''),(190,'SE','',474,''),(191,'SE','',941,''),(192,'SE','Askersund',583,''),(193,'SE','',120,''),(194,'SE','Avesta',226,''),(195,'SE','Backe',624,''),(196,'SE','Bastutr',915,''),(197,'SE','Bengtsfors',531,''),(198,'SE','Bergsj',652,''),(199,'SE','Bj',662,''),(200,'SE','Bjurholm',932,''),(201,'SE','Boden',921,''),(202,'SE','Bolln',278,''),(203,'SE','Bor',33,''),(204,'SE','Borl',243,''),(205,'SE','Br',693,''),(206,'SE','Bredbyn',661,''),(207,'SE','Burtr',914,''),(208,'SE','Byske',912,''),(209,'SE','Charlottenberg',571,''),(210,'SE','Deje',552,''),(211,'SE','Delsbo',653,''),(212,'SE','Dorotea',942,''),(213,'SE','Ed',534,''),(214,'SE','Eksj',381,''),(215,'SE','Emmaboda',471,''),(216,'SE','Enk',171,''),(217,'SE','Eskilstuna',16,''),(218,'SE','Esl',413,''),(219,'SE','Fagersta',223,''),(220,'SE','Falkenberg',346,''),(221,'SE','Falk',515,''),(222,'SE','Falun',23,''),(223,'SE','F',528,''),(224,'SE','Filipstad',590,''),(225,'SE','Finsp',122,''),(226,'SE','Fjugesta',585,''),(227,'SE','Flen',157,''),(228,'SE','F',645,''),(229,'SE','Fredrika',943,''),(230,'SE','Furudal',258,''),(231,'SE','Gaddede',672,''),(232,'SE','Gagnef',241,''),(233,'SE','G',970,''),(234,'SE','Gamleby',493,''),(235,'SE','G',26,''),(236,'SE','Gislaved',371,''),(237,'SE','Gnesta',158,''),(238,'SE','G',31,''),(239,'SE','Gothenburg',31,''),(240,'SE','Gothenburg (G',31,''),(241,'SE','Gotland',498,''),(242,'SE','Gr',390,''),(243,'SE','Gr',514,''),(244,'SE','Grebbestad',525,''),(245,'SE','Grums',555,''),(246,'SE','Gullsp',551,''),(247,'SE','Hagfors',563,''),(248,'SE','Hakkas',975,''),(249,'SE','H',591,''),(250,'SE','Hallen',643,''),(251,'SE','Hallsberg',582,''),(252,'SE','Hallstahammar',220,''),(253,'SE','Hallstavik',175,''),(254,'SE','Halmstad',35,''),(255,'SE','Hammarstrand',696,''),(256,'SE','Hammerdal',644,''),(257,'SE','Haparanda',922,''),(258,'SE','Harads',928,''),(259,'SE','H',611,''),(260,'SE','H',451,''),(261,'SE','Hede',684,''),(262,'SE','Hedemora',225,''),(263,'SE','Hedesunda',291,''),(264,'SE','Helsingborg',42,''),(265,'SE','Herrljunga',513,''),(266,'SE','Hind',301,''),(267,'SE','Hjo',503,''),(268,'SE','Hofors',290,''),(269,'SE','H',415,''),(270,'SE','Hoting',671,''),(271,'SE','Hudiksvall',650,''),(272,'SE','Hultsfred',495,''),(273,'SE','Hyltebruk',345,''),(274,'SE','Idre',253,''),(275,'SE','Jokkmokk',971,''),(276,'SE','J',36,''),(277,'SE','J',916,''),(278,'SE','Junsele',621,''),(279,'SE','Kalix',923,''),(280,'SE','Kalmar',480,''),(281,'SE','Karlholmsbruk',294,''),(282,'SE','Karlsborg',505,''),(283,'SE','Karlshamn',454,''),(284,'SE','Karlskoga',586,''),(285,'SE','Karlskrona',455,''),(286,'SE','Karlstad',54,''),(287,'SE','Katrineholm',150,''),(288,'SE','Kil',554,''),(289,'SE','Kinna',320,''),(290,'SE','Kiruna',980,''),(291,'SE','Kisa',494,''),(292,'SE','Klippan',435,''),(293,'SE','K',221,''),(294,'SE','Kopparberg',580,''),(295,'SE','Korpilombolo',977,''),(296,'SE','Kramfors',612,''),(297,'SE','Kristianstad',44,''),(298,'SE','Kristinehamn',550,''),(299,'SE','Krokom',640,''),(300,'SE','Kung',303,''),(301,'SE','Kungsbacka',300,''),(302,'SE','Kungs',227,''),(303,'SE','Laholm',430,''),(304,'SE','Lakatr',925,''),(305,'SE','Landskrona',418,''),(306,'SE','Lax',584,''),(307,'SE','Leksand',247,''),(308,'SE','Lerum',302,''),(309,'SE','Lessebo',478,''),(310,'SE','Liden',692,''),(311,'SE','Lidk',510,''),(312,'SE','Lindesberg',581,''),(313,'SE','Link',13,''),(314,'SE','Lit',642,''),(315,'SE','Ljungby',372,''),(316,'SE','Ljusdal',651,''),(317,'SE','Los',657,''),(318,'SE','L',913,''),(319,'SE','Ludvika',240,''),(320,'SE','Lule',920,''),(321,'SE','Lycksele',950,''),(322,'SE','Lysekil',523,''),(323,'SE','Mal',953,''),(324,'SE','Malm',40,''),(325,'SE','Malung',280,''),(326,'SE','Mariannelund',496,''),(327,'SE','Mariefred',159,''),(328,'SE','Mariestad',501,''),(329,'SE','Markaryd',433,''),(330,'SE','Mellerud',530,''),(331,'SE','Mj',142,''),(332,'SE','Molkom',553,''),(333,'SE','M',499,''),(334,'SE','Motala',141,''),(335,'SE','Mullsj',392,''),(336,'SE','Munkedal',524,''),(337,'SE','N',622,''),(338,'SE','N',380,''),(339,'SE','Nora',587,''),(340,'SE','Nordmaling',930,''),(341,'SE','Norrk',11,''),(342,'SE','Norrt',176,''),(343,'SE','Norsj',918,''),(344,'SE','Nybro',481,''),(345,'SE','Nyk',155,''),(346,'SE','Ockelbo',297,''),(347,'SE','',144,''),(348,'SE','',485,''),(349,'SE','',295,''),(350,'SE','',173,''),(351,'SE','',173,''),(352,'SE','',660,''),(353,'SE','Orust',304,''),(354,'SE','Osby',479,''),(355,'SE','Oskarshamn',491,''),(356,'SE','',63,''),(357,'SE','',926,''),(358,'SE','',927,''),(359,'SE','Pajala',978,''),(360,'SE','Pite',911,''),(361,'SE','Porjus',973,''),(362,'SE','Ramsele',623,''),(363,'SE','R',924,''),(364,'SE','R',682,''),(365,'SE','R',248,''),(366,'SE','Robertsfors',934,''),(367,'SE','Ronneby',457,''),(368,'SE','Ryd',459,''),(369,'SE','S',533,''),(370,'SE','Sala',224,''),(371,'SE','S',382,''),(372,'SE','Simrishamn',414,''),(373,'SE','Sj',416,''),(374,'SE','Skara',511,''),(375,'SE','Skellefte',910,''),(376,'SE','Skinnskatteberg',222,''),(377,'SE','Sk',500,''),(378,'SE','S',270,''),(379,'SE','S',121,''),(380,'SE','S',8,''),(381,'SE','Sollefte',620,''),(382,'SE','S',456,''),(383,'SE','Sorsele',952,''),(384,'SE','Stockholm',8,''),(385,'SE','Storuman',951,''),(386,'SE','Str',152,''),(387,'SE','Str',526,''),(388,'SE','Str',670,''),(389,'SE','Stugun',695,''),(390,'SE','Sundsvall',60,''),(391,'SE','Sunne',565,''),(392,'SE','Sv',246,''),(393,'SE','Sveg',680,''),(394,'SE','Svenljunga',325,''),(395,'SE','Svenstavik',687,''),(396,'SE','Syssleb',564,''),(397,'SE','T',954,''),(398,'SE','T',292,''),(399,'SE','Tibro',504,''),(400,'SE','Tidaholm',502,''),(401,'SE','Tierp',293,''),(402,'SE','Tingsryd',477,''),(403,'SE','Tomelilla',417,''),(404,'SE','T',506,''),(405,'SE','Torpshammar',691,''),(406,'SE','Tors',486,''),(407,'SE','Torsby',560,''),(408,'SE','Tran',140,''),(409,'SE','Trelleborg',410,''),(410,'SE','Trollh',520,''),(411,'SE','Trosa',156,''),(412,'SE','Uddevalla',522,''),(413,'SE','Ull',613,''),(414,'SE','Ulricehamn',321,''),(415,'SE','Ume',90,''),(416,'SE','Uppsala',18,''),(417,'SE','Vadstena',143,''),(418,'SE','Vaggeryd',393,''),(419,'SE','Valdemarsvik',123,''),(420,'SE','V',521,''),(421,'SE','V',935,''),(422,'SE','Vansbro',281,''),(423,'SE','Vara',512,''),(424,'SE','Varberg',340,''),(425,'SE','V',370,''),(426,'SE','V',21,''),(427,'SE','V',490,''),(428,'SE','V',470,''),(429,'SE','Vetlanda',383,''),(430,'SE','Vikbolandet',125,''),(431,'SE','Vilhelmina',940,''),(432,'SE','Vimmerby',492,''),(433,'SE','Vindeln',933,''),(434,'SE','Ving',151,''),(435,'SE','Vittangi',981,''),(436,'SE','Vuollerim',976,''),(437,'SE','Ystad',411,''),(438,'NL','s-Hertogenbosch',73,''),(439,'NL','Almere',36,''),(440,'NL','Amersfoort',33,''),(441,'NL','Amsterdam',20,''),(442,'NL','Apeldoorn',55,''),(443,'NL','Arnhem',26,''),(444,'NL','Breda',76,''),(445,'NL','de Meern',30,''),(446,'NL','Delft',15,''),(447,'NL','Den Bosch',73,''),(448,'NL','Denventer',570,''),(449,'NL','Deventer',570,''),(450,'NL','Dordrecht',78,''),(451,'NL','Ede',318,''),(452,'NL','Eindhoven',40,''),(453,'NL','Emmen',591,''),(454,'NL','Enschede',53,''),(455,'NL','Groningen',50,''),(456,'NL','Haarlem',23,''),(457,'NL','Heemstede',23,''),(458,'NL','Hillegersberg',10,''),(459,'NL','Hilversum',35,''),(460,'NL','Hoensbroek',45,''),(461,'NL','Hoofddorp',23,''),(462,'NL','Hoogkerk',50,''),(463,'NL','Hoogvliet',10,''),(464,'NL','Houten',30,''),(465,'NL','IJsselstein',30,''),(466,'NL','Leiden',71,''),(467,'NL','Maastricht',43,''),(468,'NL','Nieuwegein',30,''),(469,'NL','Nijmegen',24,''),(470,'NL','Oud Zuilen',30,''),(471,'NL','Philipsburg',0,''),(472,'NL','Rotterdam',10,''),(473,'NL','The Hague',70,''),(474,'NL','The Hague (Den Haag)',70,''),(475,'NL','Tilburg',13,''),(476,'NL','Utrecht',30,''),(477,'NL','Vught',73,''),(478,'NL','Zaandam',75,''),(479,'NL','Zeist',30,''),(480,'NL','Zoetermeer',79,''),(481,'NL','Zwolle',38,''),(482,'RU','Amursk',416,''),(483,'RU','Anadyr',42722,''),(484,'RU','Arkhangelsk',8182,''),(485,'RU','Astrahanka',8512,''),(486,'RU','Astrakhan',8512,''),(487,'RU','Barnaul',3852,''),(488,'RU','Belgorod',472,''),(489,'RU','Bryansk',483,''),(490,'RU','Cheboksary',8352,''),(491,'RU','Chelyabinsk',351,''),(492,'RU','Cherepovets',820,''),(493,'RU','Cherkessk',87822,''),(494,'RU','Chita',302,''),(495,'RU','Ekaterinburg',343,''),(496,'RU','Gorno Altaysk',388,''),(497,'RU','Groznyy',871,''),(498,'RU','Irkutsk',3952,''),(499,'RU','Ivanovo',493,''),(500,'RU','Izhevsk',3412,''),(501,'RU','Kaliningrad',401,''),(502,'RU','Kaluga',484,''),(503,'RU','Kazan',843,''),(504,'RU','Kemerovo',3842,''),(505,'RU','Khabarovsk',4212,''),(506,'RU','Kirov',833,''),(507,'RU','Kostroma',494,''),(508,'RU','Krasnodar',8612,''),(509,'RU','Krasnoyarsk',3912,''),(510,'RU','Kurgan',352,''),(511,'RU','Kursk',471,''),(512,'RU','Lipetsk',474,''),(513,'RU','Magadan',41322,''),(514,'RU','Mineral nyye Vody',879,''),(515,'RU','Moscow',495,''),(516,'RU','Murmansk',8152,''),(517,'RU','Naberezhnye Chelny',8552,''),(518,'RU','Norilsk',39152,''),(519,'RU','Novgorod',81622,''),(520,'RU','Novorossiysk',86117,''),(521,'RU','Novosibirsk',383,''),(522,'RU','Omsk',3812,''),(523,'RU','Orel',8262,''),(524,'RU','Orenburg',3532,''),(525,'RU','Penza',8412,''),(526,'RU','Perm',3422,''),(527,'RU','Petropavlovsk Kamchatskiy',4152,''),(528,'RU','Petrozavodsk',814,''),(529,'RU','Rostov',863,''),(530,'RU','Ryazan',491,''),(531,'RU','Samara',8462,''),(532,'RU','Saransk',834,''),(533,'RU','Saratov',8452,''),(534,'RU','Smolensk',481,''),(535,'RU','Sochi',862,''),(536,'RU','St. Petersburg',812,''),(537,'RU','Stavropol',8652,''),(538,'RU','Surgut',3462,''),(539,'RU','Syktyvkar',821,''),(540,'RU','Tambov',475,''),(541,'RU','Tomsk',3822,''),(542,'RU','Tula',487,''),(543,'RU','Tura',39113,''),(544,'RU','Tver',482,''),(545,'RU','Ufa',3472,''),(546,'RU','Ul\'yanovsk',8422,''),(547,'RU','Ulan Ude',3012,''),(548,'RU','Ulyanovsk',842,''),(549,'RU','Vladikavkaz',867,''),(550,'RU','Vladimir',492,''),(551,'RU','Vladivostok',4232,''),(552,'RU','Volgograd',8442,''),(553,'RU','Vologda',817,''),(554,'RU','Voronezh',473,''),(555,'RU','Yakutsk',4112,''),(556,'RU','Yaroslavl',485,''),(557,'RU','Yekaterinburg',343,''),(558,'RU','Yoshkar Ola',836,''),(559,'FR','Aix en Provence',4,''),(560,'FR','Ajaccio',4,''),(561,'FR','Angers',2,''),(562,'FR','Bastia',4,''),(563,'FR','Besan',3,''),(564,'FR','Bordeaux',5,''),(565,'FR','Brest',2,''),(566,'FR','Caen',2,''),(567,'FR','Clermont Ferrand',4,''),(568,'FR','Dijon',3,''),(569,'FR','Grenoble',4,''),(570,'FR','Istres',4,''),(571,'FR','Le Havre',2,''),(572,'FR','Le Mans',2,''),(573,'FR','Lens',3,''),(574,'FR','Lille',3,''),(575,'FR','Limoges',5,''),(576,'FR','Lyon',4,''),(577,'FR','Macon',478,''),(578,'FR','Marseille',4,''),(579,'FR','Montpellier',4,''),(580,'FR','Mulhouse',3,''),(581,'FR','Nancy',3,''),(582,'FR','Nantes',2,''),(583,'FR','Nice',4,''),(584,'FR','Nimes',4,''),(585,'FR','Orleans',2,''),(586,'FR','Paris',1,''),(587,'FR','Perpignan',4,''),(588,'FR','Reims',3,''),(589,'FR','Rennes',2,''),(590,'FR','Rouen',2,''),(591,'FR','Saint Denis',1,''),(592,'FR','Saint Etienne du Rouvray',4,''),(593,'FR','Strasbourg',3,''),(594,'FR','Toulon',4,''),(595,'FR','Toulouse',5,''),(596,'FR','Tours',2,''),(597,'FR','Versailles',859,''),(598,'FR','Villeurbanne',4,''),(599,'ES','Albacete',967,''),(600,'ES','Alicante',96,''),(601,'ES','Almer',950,''),(602,'ES','',920,''),(603,'ES','Badajoz',924,''),(604,'ES','Barcelona',93,''),(605,'ES','Bilbao',94,''),(606,'ES','Burgos',947,''),(607,'ES','Caceres',927,''),(608,'ES','Cadiz',956,''),(609,'ES','Ceuta',952,''),(610,'ES','Cordoba',957,''),(611,'ES','Cuenca',969,''),(612,'ES','Durango',970,''),(613,'ES','Girona',972,''),(614,'ES','Granada',958,''),(615,'ES','Guadalajara',949,''),(616,'ES','Huelva',959,''),(617,'ES','Huesca',974,''),(618,'ES','Jaen',953,''),(619,'ES','La Coru',81,''),(620,'ES','Las Palmas',928,''),(621,'ES','Leon',987,''),(622,'ES','Lerida',973,''),(623,'ES','Lugo',982,''),(624,'ES','Madrid',91,''),(625,'ES','Malaga',95,''),(626,'ES','Melilla',952,''),(627,'ES','Murcia',968,''),(628,'ES','Orense',988,''),(629,'ES','Oviedo',407,''),(630,'ES','Palma',971,''),(631,'ES','Palma de Mallorca',971,''),(632,'ES','Pamplona',948,''),(633,'ES','Pontevedra',986,''),(634,'ES','Salamanca',923,''),(635,'ES','Santa Cruz',922,''),(636,'ES','Santander',942,''),(637,'ES','Sevilla',95,''),(638,'ES','Tarragona',977,''),(639,'ES','Tenerife',922,''),(640,'ES','Toledo',925,''),(641,'ES','Valencia',96,''),(642,'ES','Valladolid',983,''),(643,'ES','Zamora',980,''),(644,'ES','Zaragoza',976,''),(645,'ZA','Bethlehem',835,''),(646,'ZA','Bloemfontein',51,''),(647,'ZA','Cape Town',21,''),(648,'ZA','Durban',31,''),(649,'ZA','East London',431,''),(650,'ZA','George',712,''),(651,'ZA','Johannesburg',11,''),(652,'ZA','Port Elizabeth',41,''),(653,'ZA','Pretoria',12,''),(654,'ZA','Uitenhage',41,''),(655,'ZA','Vereeniging',11,''),(656,'ZA','Welkom',57,''),(657,'NG','Aba',82,''),(658,'NG','Abakaliki',43,''),(659,'NG','Abeokuta',39,''),(660,'NG','Abuja',9,''),(661,'NG','Ado Ekiti',30,''),(662,'NG','Agbor',55,''),(663,'NG','Ahoada',86,''),(664,'NG','Akure',34,''),(665,'NG','Asaba',56,''),(666,'NG','Auchi',57,''),(667,'NG','Awka',48,''),(668,'NG','Azare',71,''),(669,'NG','Badagry',1,''),(670,'NG','Bauchi',77,''),(671,'NG','Benin',52,''),(672,'NG','Birnin',68,''),(673,'NG','Calabar',87,''),(674,'NG','Damaturu',74,''),(675,'NG','Edo',52,''),(676,'NG','Enugu',42,''),(677,'NG','Gombe',72,''),(678,'NG','Gusau',63,''),(679,'NG','Hadejia',78,''),(680,'NG','Ibadan',2,''),(681,'NG','Ijebu Ode',37,''),(682,'NG','Ikare',50,''),(683,'NG','Ile Ife',36,''),(684,'NG','Ilorin',31,''),(685,'NG','Jalingo',79,''),(686,'NG','Jos',73,''),(687,'NG','Kaduna',62,''),(688,'NG','Kafanchau',61,''),(689,'NG','Kano',64,''),(690,'NG','Kano Nigeria',64,''),(691,'NG','Katsina',65,''),(692,'NG','Kontagora',67,''),(693,'NG','Lafia',47,''),(694,'NG','Lagos',1,''),(695,'NG','Lokoja',58,''),(696,'NG','Maiduguri',76,''),(697,'NG','Makurdi',44,''),(698,'NG','Minna',66,''),(699,'NG','New Bussa',33,''),(700,'NG','Niger Sate',66,''),(701,'NG','Ogoja',45,''),(702,'NG','Okitipupa',59,''),(703,'NG','Onitsha',46,''),(704,'NG','Oshogbo',35,''),(705,'NG','Owerri',83,''),(706,'NG','Owo',51,''),(707,'NG','Oyo',38,''),(708,'NG','Pank Shin',70,''),(709,'NG','Port Harcourt',84,''),(710,'NG','Sapele',54,''),(711,'NG','Sokobo',60,''),(712,'NG','Umuahia',88,''),(713,'NG','Uyo',85,''),(714,'NG','Warri',53,''),(715,'NG','Wukari',41,''),(716,'NG','Yenegoa',89,''),(717,'NG','Yola',75,''),(718,'NG','Zaria',69,''),(719,'KE','Garissa',46,''),(720,'KE','Kakamega',56,''),(721,'KE','Kericho',52,''),(722,'KE','Kisii',58,''),(723,'KE','Kisumu',57,''),(724,'KE','Kitale',54,''),(725,'KE','Malindi',42,''),(726,'KE','Marsabit',69,''),(727,'KE','Meru',64,''),(728,'KE','Mombasa',41,''),(729,'KE','Nairobi',20,''),(730,'KE','Nakuru',51,''),(731,'KE','Thika',67,''),(732,'KE','Voi',43,''),(733,'GH','Accra',21,''),(734,'GH','Bolgatanga',72,''),(735,'GH','Cape Coast',42,''),(736,'GH','Koforidua',81,''),(737,'GH','Kumasi',51,''),(738,'GH','Takoradi',31,''),(739,'GH','Tamale',71,''),(740,'GH','Tema',22,''),(741,'IN','Agartala',381,''),(742,'IN','Agra',562,''),(743,'IN','Ahmedabad',79,''),(744,'IN','Aizawl',389,''),(745,'IN','Ajmer',145,''),(746,'IN','Akbarpur',5271,''),(747,'IN','Akola',724,''),(748,'IN','Alappuzha',477,''),(749,'IN','Aligarh',571,''),(750,'IN','Alipore',33,''),(751,'IN','Alwar',144,''),(752,'IN','Amravati',721,''),(753,'IN','Amritsar',183,''),(754,'IN','Amroha',5922,''),(755,'IN','Anand',2692,''),(756,'IN','Anantapur',8554,''),(757,'IN','Anantnag',193,''),(758,'IN','Angul',6764,''),(759,'IN','Araria',6453,''),(760,'IN','Arrah',6182,''),(761,'IN','Asansol',341,''),(762,'IN','Auraiya',5683,''),(763,'IN','Aurangabad',2432,''),(764,'IN','Azamgarh',5462,''),(765,'IN','Badaun',5832,''),(766,'IN','Bagpat',1234,''),(767,'IN','Baharampur',3482,''),(768,'IN','Bahraich',5252,''),(769,'IN','Balaghat',7632,''),(770,'IN','Balangir',6652,''),(771,'IN','Balasore',6782,''),(772,'IN','Ballia',5498,''),(773,'IN','Balrampur',5263,''),(774,'IN','Balurghat',3522,''),(775,'IN','Banda',5192,''),(776,'IN','Bangalore',80,''),(777,'IN','Banka',6424,''),(778,'IN','Bankura',3242,''),(779,'IN','Banswara',2962,''),(780,'IN','Barabanki',5248,''),(781,'IN','Baramulla',1952,''),(782,'IN','Baran',7453,''),(783,'IN','Barasat',33,''),(784,'IN','Barddhaman',342,''),(785,'IN','Bardhaman',342,''),(786,'IN','Bareilly',581,''),(787,'IN','Bargarh',6646,''),(788,'IN','Baripada',6792,''),(789,'IN','Barmer',2982,''),(790,'IN','Barnala',1679,''),(791,'IN','Baroda',265,''),(792,'IN','Barwani',7290,''),(793,'IN','Basti',5542,''),(794,'IN','Bathinda',164,''),(795,'IN','Beawar',1462,''),(796,'IN','Beed',2442,''),(797,'IN','Begusarai',6243,''),(798,'IN','Berhampur',680,''),(799,'IN','Bettiah',6254,''),(800,'IN','Betul',7141,''),(801,'IN','Bhabua',6189,''),(802,'IN','Bhadrachalam',8743,''),(803,'IN','Bhadrak',6784,''),(804,'IN','Bhagalpur',641,''),(805,'IN','Bhandara',7184,''),(806,'IN','Bharatpur',5644,''),(807,'IN','Bharuch',2642,''),(808,'IN','Bhavnagar',278,''),(809,'IN','Bhawanipatna',6670,''),(810,'IN','Bhilwara',1482,''),(811,'IN','Bhind',7534,''),(812,'IN','Bhinga',5250,''),(813,'IN','Bhopal',755,''),(814,'IN','Bhubaneshwar',674,''),(815,'IN','Bhubaneswar',674,''),(816,'IN','Bhuj',2832,''),(817,'IN','Bijnor',1342,''),(818,'IN','Bikaner',151,''),(819,'IN','Bokaro Steel City',6542,''),(820,'IN','Bombay',22,''),(821,'IN','Boudh',6841,''),(822,'IN','Bulandshahr',5732,''),(823,'IN','Buldhana',7262,''),(824,'IN','Bundi',747,''),(825,'IN','Burhanpur',7325,''),(826,'IN','Buxar',6183,''),(827,'IN','Calcutta',33,''),(828,'IN','Chandauli',5412,''),(829,'IN','Chandigarh',172,''),(830,'IN','Chandrapur',7172,''),(831,'IN','Chennai',44,''),(832,'IN','Chennai (formerly Madras)',44,''),(833,'IN','Chennai (Madras)',44,''),(834,'IN','Cherrapunji',3637,''),(835,'IN','Chhapra',6152,''),(836,'IN','Chhatarpur',7682,''),(837,'IN','Chhatrapur',6811,''),(838,'IN','Chhindwara',7162,''),(839,'IN','Chitrakuta',5194,''),(840,'IN','Chittoor',8572,''),(841,'IN','Chittorgarh',8572,''),(842,'IN','Churu',1562,''),(843,'IN','Cochin (Kochi)',484,''),(844,'IN','Coimbator',422,''),(845,'IN','Coimbatore',422,''),(846,'IN','Cooch Behar',3582,''),(847,'IN','Cuddalore',4142,''),(848,'IN','Cuttack',671,''),(849,'IN','Daman',260,''),(850,'IN','Damoh',7638,''),(851,'IN','Darbhanga',6272,''),(852,'IN','Darjeeling',354,''),(853,'IN','Datia',7522,''),(854,'IN','Dausa',1427,''),(855,'IN','Debagarh',6641,''),(856,'IN','Dehra Dun',135,''),(857,'IN','Dehradun',135,''),(858,'IN','Delhi',11,''),(859,'IN','Deogarh',6432,''),(860,'IN','Deoghar',6432,''),(861,'IN','Deoria',5568,''),(862,'IN','Dewas',7272,''),(863,'IN','Dhanbad',326,''),(864,'IN','Dhar',7292,''),(865,'IN','Dharmapuri',4342,''),(866,'IN','Dhenkanal',6762,''),(867,'IN','Dholpur',5642,''),(868,'IN','Dhule',2562,''),(869,'IN','Dibrugarh',373,''),(870,'IN','Dimapur',3862,''),(871,'IN','Dindigul',451,''),(872,'IN','Dispur',361,''),(873,'IN','Dungarpur',2964,''),(874,'IN','Eluru',8812,''),(875,'IN','Erode',424,''),(876,'IN','Etah',5742,''),(877,'IN','Etawah',5688,''),(878,'IN','Faizabad',5278,''),(879,'IN','Faridabad',129,''),(880,'IN','Faridkot',1639,''),(881,'IN','Fatehgarh',5692,''),(882,'IN','Fatehgarh Sahib',1763,''),(883,'IN','Fatehpur',5240,''),(884,'IN','Fathepur Sikri',5619,''),(885,'IN','Firozabad',5612,''),(886,'IN','Firozpur',1632,''),(887,'IN','Gadchiroli',7132,''),(888,'IN','Gandhinagar',2712,''),(889,'IN','Ganganagar',154,''),(890,'IN','Gangtok',3592,''),(891,'IN','Gaya',631,''),(892,'IN','Ghaziabad',120,''),(893,'IN','Ghazipur',548,''),(894,'IN','Giridih',1933,''),(895,'IN','Gonda',5262,''),(896,'IN','Gondia',7182,''),(897,'IN','Gopalganj',6156,''),(898,'IN','Gorakhpur',551,''),(899,'IN','Gumla',6524,''),(900,'IN','Guna',7542,''),(901,'IN','Guntur',863,''),(902,'IN','Gurdaspur',1874,''),(903,'IN','Gurgaon',124,''),(904,'IN','Guwahati',361,''),(905,'IN','Gwalior',751,''),(906,'IN','Gyanpur',5414,''),(907,'IN','Hajipur',6224,''),(908,'IN','Haldwani',5946,''),(909,'IN','Hamirpur',5282,''),(910,'IN','Hanumangarh',1552,''),(911,'IN','Harda',7577,''),(912,'IN','Hardoi',5852,''),(913,'IN','Haridwar',1332,''),(914,'IN','Hathras',5722,''),(915,'IN','Hazaribagh',6546,''),(916,'IN','Hingoli',2456,''),(917,'IN','Hoshangabad',7574,''),(918,'IN','Hoshiarpur',1882,''),(919,'IN','Howrah',33,''),(920,'IN','Hugli-Chuchura',33,''),(921,'IN','Hyderabad',40,''),(922,'IN','Imphal',3852,''),(923,'IN','Indore',731,''),(924,'IN','Itanagar',360,''),(925,'IN','Jabalpur',761,''),(926,'IN','Jagatsinghpur',6724,''),(927,'IN','Jaipur',141,''),(928,'IN','Jaisalmer',2922,''),(929,'IN','Jalandhar',181,''),(930,'IN','Jalgaon',257,''),(931,'IN','Jalna',2482,''),(932,'IN','Jalore',2972,''),(933,'IN','Jalpaiguri',3561,''),(934,'IN','Jammu',191,''),(935,'IN','Jamnagar',288,''),(936,'IN','Jamshedpur',657,''),(937,'IN','Jamui',6345,''),(938,'IN','Jaunpur',5452,''),(939,'IN','Jehanabad',6114,''),(940,'IN','Jhabua',7392,''),(941,'IN','Jhalawar',7432,''),(942,'IN','Jhansi',510,''),(943,'IN','Jharsuguda',6645,''),(944,'IN','Jhunjhunu',1595,''),(945,'IN','Jodhpur',291,''),(946,'IN','Jullundur',181,''),(947,'IN','Junagadh',285,''),(948,'IN','Kalpetta',4936,''),(949,'IN','Kanchipuram',44,''),(950,'IN','Kannauj',5694,''),(951,'IN','Kanpur',512,''),(952,'IN','Kapurthala',1822,''),(953,'IN','Karauli',7464,''),(954,'IN','Karjat',2489,''),(955,'IN','Karur',4324,''),(956,'IN','Kasaragod',494,''),(957,'IN','Kathua',1922,''),(958,'IN','Katihar',6452,''),(959,'IN','Katni',7622,''),(960,'IN','Kavaratti',4896,''),(961,'IN','Kendrapara',6727,''),(962,'IN','Kendujhar',6766,''),(963,'IN','Khagaria',6244,''),(964,'IN','Khalilabad',5547,''),(965,'IN','Khandwa',733,''),(966,'IN','Kharagpur',3222,''),(967,'IN','Khargone',7282,''),(968,'IN','Khordha',6755,''),(969,'IN','Kishanganj',6466,''),(970,'IN','Kochi',484,''),(971,'IN','Kohima',370,''),(972,'IN','Kolhapur',231,''),(973,'IN','Kolkata',33,''),(974,'IN','Kolkata (Calcutta)',33,''),(975,'IN','Kolkatta (formerly Calcutta)',33,''),(976,'IN','Kollam',474,''),(977,'IN','Koraput',6852,''),(978,'IN','Kota',744,''),(979,'IN','Kottayam',481,''),(980,'IN','Kozhikode',495,''),(981,'IN','Krishnagiri',4343,''),(982,'IN','Krishnanagar',3472,''),(983,'IN','Kulti',341,''),(984,'IN','Lakhimpur',5872,''),(985,'IN','Lakhisarai',6346,''),(986,'IN','Lalitpur',5176,''),(987,'IN','Latur',2382,''),(988,'IN','Lucknow',522,''),(989,'IN','Ludhiana',161,''),(990,'IN','Madhepura',6476,''),(991,'IN','Madhubani',6276,''),(992,'IN','Madras',44,''),(993,'IN','Madurai',452,''),(994,'IN','Maharajganj',5523,''),(995,'IN','Mahoba',5281,''),(996,'IN','Mainpuri',5672,''),(997,'IN','Malda',3512,''),(998,'IN','Malkangiri',6861,''),(999,'IN','Mandla',7642,''),(1000,'IN','Mandsaur',7422,''),(1001,'IN','Manipal',8252,''),(1002,'IN','Manjhanpur',5331,''),(1003,'IN','Mansa',1652,''),(1004,'IN','Margao',8342,''),(1005,'IN','Mathura',565,''),(1006,'IN','Mau',5195,''),(1007,'IN','Meerut',121,''),(1008,'IN','Midnapore',3222,''),(1009,'IN','Mirzapur',5442,''),(1010,'IN','Moga',1636,''),(1011,'IN','Mohali',172,''),(1012,'IN','Moradabad',591,''),(1013,'IN','Morena',7532,''),(1014,'IN','Motihari',6252,''),(1015,'IN','Mount Abu',2974,''),(1016,'IN','Muktsar',1633,''),(1017,'IN','Mumbai',22,''),(1018,'IN','Mumbai (Bombay)',22,''),(1019,'IN','Mumbai (formerly Bombay )',22,''),(1020,'IN','Munger',6344,''),(1021,'IN','Mussooree',1362,''),(1022,'IN','Muzaffarnagar',131,''),(1023,'IN','Muzaffarpur',621,''),(1024,'IN','Mysore',821,''),(1025,'IN','Nabarangpur',685,''),(1026,'IN','Nadiad',268,''),(1027,'IN','Nagaon',3672,''),(1028,'IN','Nagapattinam',4365,''),(1029,'IN','Nagaur',1582,''),(1030,'IN','Nagercoil',4652,''),(1031,'IN','Nagpur',712,''),(1032,'IN','Nalanda',6119,''),(1033,'IN','Namakkal',4286,''),(1034,'IN','Nanded',2462,''),(1035,'IN','Nandurbar',2564,''),(1036,'IN','Narsinghpur',7792,''),(1037,'IN','Nashik',253,''),(1038,'IN','Nasik',253,''),(1039,'IN','Naugarh',5544,''),(1040,'IN','Navi Mumbai',22,''),(1041,'IN','Navsari',2637,''),(1042,'IN','Nawabganj',6324,''),(1043,'IN','Nawada',6324,''),(1044,'IN','Nawanshahr',1823,''),(1045,'IN','Nayagarh',6753,''),(1046,'IN','Neemuch',7423,''),(1047,'IN','New Delhi',11,''),(1048,'IN','New Okhla Industrial Development Authority',120,''),(1049,'IN','Nuapada',6678,''),(1050,'IN','Ootacamund',423,''),(1051,'IN','Orai',5162,''),(1052,'IN','Osmanabad',2472,''),(1053,'IN','Padrauna',5564,''),(1054,'IN','Painavu',486,''),(1055,'IN','Palakkad',491,''),(1056,'IN','Pampore',1933,''),(1057,'IN','Panaji',832,''),(1058,'IN','Panchkula',172,''),(1059,'IN','Panipat',180,''),(1060,'IN','Panna',7732,''),(1061,'IN','Panskura',3228,''),(1062,'IN','Panvel',22,''),(1063,'IN','Paralakhemundi',6815,''),(1064,'IN','Parbhani',2452,''),(1065,'IN','Pathanamthitta',468,''),(1066,'IN','Patiala',175,''),(1067,'IN','Patna',612,''),(1068,'IN','Perambalur',4328,''),(1069,'IN','Phulbani',6842,''),(1070,'IN','Pilibhit',5882,''),(1071,'IN','Ponnani',483,''),(1072,'IN','Port Blair',3192,''),(1073,'IN','Pratapgarh',5342,''),(1074,'IN','Puducherry',413,''),(1075,'IN','Pudukkottai',4322,''),(1076,'IN','Pune',20,''),(1077,'IN','Pune (formerly Poona)',20,''),(1078,'IN','Puri',6752,''),(1079,'IN','Purnia',6454,''),(1080,'IN','Purulia',3252,''),(1081,'IN','Pushkar',145,''),(1082,'IN','Rae Bareli',535,''),(1083,'IN','Raebareli',535,''),(1084,'IN','Raiganj',3523,''),(1085,'IN','Raipur',771,''),(1086,'IN','Rajgarh',7372,''),(1087,'IN','Rajkot',281,''),(1088,'IN','Rajsamand',2952,''),(1089,'IN','Ramanathapuram',4567,''),(1090,'IN','Rampur',595,''),(1091,'IN','Ranchi',651,''),(1092,'IN','Ranthambhore Natl. Park',7462,''),(1093,'IN','Ratlam',7412,''),(1094,'IN','Ratnagiri',2353,''),(1095,'IN','Rayagada',6856,''),(1096,'IN','Rewa',7662,''),(1097,'IN','Robertsganj',5444,''),(1098,'IN','Roorkee',1332,''),(1099,'IN','Rourkela',661,''),(1100,'IN','Rupnagar',1881,''),(1101,'IN','Sagar',7582,''),(1102,'IN','Saharanpur',132,''),(1103,'IN','Saharsa',6478,''),(1104,'IN','Samastipur',6274,''),(1105,'IN','Sambalpur',663,''),(1106,'IN','Sangli',233,''),(1107,'IN','Sangrur',1672,''),(1108,'IN','Sariska',144,''),(1109,'IN','Sasaram',6184,''),(1110,'IN','Satara',2162,''),(1111,'IN','Satna',7672,''),(1112,'IN','Sawai Madhopur',7462,''),(1113,'IN','Sehore',7562,''),(1114,'IN','Seoni',7692,''),(1115,'IN','Shahdol',7652,''),(1116,'IN','Shahjahanpur',5842,''),(1117,'IN','Shajapur',7364,''),(1118,'IN','Sheikhpura',6341,''),(1119,'IN','Sheohar',6222,''),(1120,'IN','Sheopur',7530,''),(1121,'IN','Shillong',364,''),(1122,'IN','Shimla',177,''),(1123,'IN','Shivpuri',7492,''),(1124,'IN','Sibsagar',3772,''),(1125,'IN','Sidhi',7822,''),(1126,'IN','Sikar',1572,''),(1127,'IN','Silchar',3842,''),(1128,'IN','Silvassa',260,''),(1129,'IN','Simla',177,''),(1130,'IN','Sindri',326,''),(1131,'IN','Sitamarhi',6226,''),(1132,'IN','Sitapur',5862,''),(1133,'IN','Sivaganga',4575,''),(1134,'IN','Siwan',6154,''),(1135,'IN','Solapur',217,''),(1136,'IN','Sonepur',6654,''),(1137,'IN','Sopore',1954,''),(1138,'IN','Srinagar',194,''),(1139,'IN','Sultanpur',5362,''),(1140,'IN','Sundergarh',6622,''),(1141,'IN','Supaul',6473,''),(1142,'IN','Surat',261,''),(1143,'IN','Suri',3462,''),(1144,'IN','Tamluk',3228,''),(1145,'IN','Tarn Taran Sahib',1852,''),(1146,'IN','Thalassery',490,''),(1147,'IN','Thane',22,''),(1148,'IN','Thanjavur',4362,''),(1149,'IN','Theni',4546,''),(1150,'IN','Thiruvan',471,''),(1151,'IN','Thiruvananthapuram',471,''),(1152,'IN','Thiruvannaamalai',4175,''),(1153,'IN','Thoothukudi',461,''),(1154,'IN','Thrissur',487,''),(1155,'IN','Tikamgarh',7683,''),(1156,'IN','Tinsukia',374,''),(1157,'IN','Tiruchirapalli',431,''),(1158,'IN','Tirumala',877,''),(1159,'IN','Tirunelveli',462,''),(1160,'IN','Tiruvallur',44,''),(1161,'IN','Tiruvarur',4366,''),(1162,'IN','Tonk',1435,''),(1163,'IN','Udaipur',294,''),(1164,'IN','Udhampur',199,''),(1165,'IN','Ujjain',734,''),(1166,'IN','Unnao',515,''),(1167,'IN','Vadodara',265,''),(1168,'IN','Vadodara (Baroda)',265,''),(1169,'IN','Varanasi',542,''),(1170,'IN','Vasco da Gama',832,''),(1171,'IN','Vellore',416,''),(1172,'IN','Vidisha',7592,''),(1173,'IN','Vijayawada',866,''),(1174,'IN','Viluppuram',4146,''),(1175,'IN','Virudhunagar',4562,''),(1176,'IN','Virudunagar',4562,''),(1177,'IN','Visakhapatnam',891,''),(1178,'IN','Warangal',870,''),(1179,'IN','Wardha',7152,''),(1180,'IN','Washim',7252,''),(1181,'IN','Yavatmal',7232,''),(1182,'PH','Angeles City',455,''),(1183,'PH','Bacolod City',34,''),(1184,'PH','Cavite',46,''),(1185,'PH','Cebu City',32,''),(1186,'PH','Dagupan City',75,''),(1187,'PH','Davao City',82,''),(1188,'PH','General Santos',83,''),(1189,'PH','Iloilo',33,''),(1190,'PH','Manila',2,''),(1191,'PH','Masbate',56,''),(1192,'PH','Puerto Princesa City',48,''),(1193,'PH','Quezon City',2,''),(1194,'PH','San Fernando',818,''),(1195,'PH','San Jose',309,''),(1196,'PH','San Pablo City',93,''),(1197,'PH','Santa Cruz',831,''),(1198,'PH','Tacloban City',53,''),(1199,'PH','Tarlac',452,''),(1200,'PH','Zamboanga',62,''),(1201,'BR','Alagoinhas',75,''),(1202,'BR','Alexandria',859,''),(1203,'BR','An',62,''),(1204,'BR','Aracaju',79,''),(1205,'BR','Araguaina',63,''),(1206,'BR','Barreiras',77,''),(1207,'BR','Bauru',14,''),(1208,'BR','Bel',91,''),(1209,'BR','Belo Horizonte',31,''),(1210,'BR','Blumenau',47,''),(1211,'BR','Boa Vista',95,''),(1212,'BR','Brasilia',61,''),(1213,'BR','Campina Grande',83,''),(1214,'BR','Campinas',19,''),(1215,'BR','Campo Grande',67,''),(1216,'BR','Campos',22,''),(1217,'BR','Caruaru',81,''),(1218,'BR','Caxias do Sul',54,''),(1219,'BR','Cuiaba',65,''),(1220,'BR','Curitiba',41,''),(1221,'BR','Feira de Santana',75,''),(1222,'BR','Fernando de Noronha',81,''),(1223,'BR','Florianopolis',48,''),(1224,'BR','Fortaleza',85,''),(1225,'BR','Garanhuns',81,''),(1226,'BR','Goiania',62,''),(1227,'BR','Governador Valadares',33,''),(1228,'BR','Ilheus',73,''),(1229,'BR','Itabuna',73,''),(1230,'BR','Jequie',73,''),(1231,'BR','Joao Pessoa',83,''),(1232,'BR','Joinville',47,''),(1233,'BR','Juazeiro do Norte',74,''),(1234,'BR','Juiz de Fora',32,''),(1235,'BR','Londrina',43,''),(1236,'BR','Macapa',96,''),(1237,'BR','Maceio',82,''),(1238,'BR','Manaus',92,''),(1239,'BR','Medina',830,''),(1240,'BR','Montes Claros',38,''),(1241,'BR','Montezuma',478,''),(1242,'BR','Mossoro',84,''),(1243,'BR','Natal',84,''),(1244,'BR','Niteroi',21,''),(1245,'BR','Palmas',63,''),(1246,'BR','Panama',712,''),(1247,'BR','Parnaiba',86,''),(1248,'BR','Passo Fundo',54,''),(1249,'BR','Pelotas',532,''),(1250,'BR','Ponta Grossa',42,''),(1251,'BR','Porto Alegre',51,''),(1252,'BR','Porto Velho',69,''),(1253,'BR','Recife',81,''),(1254,'BR','Ribeir',16,''),(1255,'BR','Rio Branco',68,''),(1256,'BR','Rio de Janeiro',21,''),(1257,'BR','Rio Grande',53,''),(1258,'BR','Sacramento',916,''),(1259,'BR','Salinas',408,''),(1260,'BR','Salvador',71,''),(1261,'BR','Santa Cruz',831,''),(1262,'BR','Santa Fe',505,''),(1263,'BR','Santa Maria',34,''),(1264,'BR','Santa Rosa',707,''),(1265,'BR','Santo Andr',11,''),(1266,'BR','Santos',13,''),(1267,'BR','S',17,''),(1268,'BR','S',12,''),(1269,'BR','S',98,''),(1270,'BR','S',11,''),(1271,'BR','Sobral',88,''),(1272,'BR','Sorocaba',15,''),(1273,'BR','Teofilo Otoni',33,''),(1274,'BR','Teresina',86,''),(1275,'BR','Timbo',870,''),(1276,'BR','Uberaba',34,''),(1277,'BR','Uberlandia',34,''),(1278,'BR','Uruguaiana',55,''),(1279,'BR','Valparaiso',850,''),(1280,'BR','Vitoria',27,''),(1281,'BR','Vitoria da Conquista',77,''),(1282,'BR','Volta Redonda',24,''),(1283,'AR','Bah',291,''),(1284,'AR','Buenos Aires',11,''),(1285,'AR','Comodoro Rivadavia',297,''),(1286,'AR','Concordia',345,''),(1287,'AR','C',351,''),(1288,'AR','Corrientes',3783,''),(1289,'AR','Formosa',3717,''),(1290,'AR','Jes',3525,''),(1291,'AR','Jun',2362,''),(1292,'AR','La Plata',221,''),(1293,'AR','La Rioja',3822,''),(1294,'AR','Mar del Plata',223,''),(1295,'AR','Mendoza',261,''),(1296,'AR','Mercedes',2324,''),(1297,'AR','Neuqu',299,''),(1298,'AR','Paran',343,''),(1299,'AR','Posadas',3752,''),(1300,'AR','Resistencia',3722,''),(1301,'AR','R',358,''),(1302,'AR','R',2966,''),(1303,'AR','Rosario',341,''),(1304,'AR','Salta',387,''),(1305,'AR','San Francisco',628,''),(1306,'AR','San Juan',264,''),(1307,'AR','San Luis',2652,''),(1308,'AR','San Mart',408,''),(1309,'AR','San Nicol',3461,''),(1310,'AR','San Pedro',424,''),(1311,'AR','San Rafael',2627,''),(1312,'AR','Santa Fe',342,''),(1313,'AR','Santa Rosa',2954,''),(1314,'AR','Santiago del Estero',385,''),(1315,'AR','Santo Tom',3756,''),(1316,'AR','Tandil',2293,''),(1317,'AR','Trelew/Rawson',2965,''),(1318,'AR','Ushuaia',2901,''),(1319,'AR','Viedma',2920,''),(1320,'AR','Z',3487,''),(1321,'AU','Adelaide',8,''),(1322,'AU','Albury',2,''),(1323,'AU','Alice Springs',8,''),(1324,'AU','Ballarat',3,''),(1325,'AU','Bendigo',3,''),(1326,'AU','Brisbane',7,''),(1327,'AU','Bunbury',8,''),(1328,'AU','Bundaberg',7,''),(1329,'AU','Cairns',7,''),(1330,'AU','Canberra',2,''),(1331,'AU','Coffs Harbour',2,''),(1332,'AU','Darwin',8,''),(1333,'AU','Forrest',815,''),(1334,'AU','Geelong',3,''),(1335,'AU','Gibson',706,''),(1336,'AU','Gold Coast',7,''),(1337,'AU','Hamilton',620,''),(1338,'AU','Hobart',3,''),(1339,'AU','Kingston',770,''),(1340,'AU','Launceston',3,''),(1341,'AU','Mackay',7,''),(1342,'AU','Macquarie Island',13,''),(1343,'AU','Marion',765,''),(1344,'AU','Melbourne',3,''),(1345,'AU','Newcastle',2,''),(1346,'AU','Perth',8,''),(1347,'AU','Portland',207,''),(1348,'AU','Richmond',765,''),(1349,'AU','Rockhampton',7,''),(1350,'AU','Sydney',2,''),(1351,'AU','Townsville',7,''),(1352,'AU','Warwick',229,''),(1353,'AU','Wollongong',2,''),(1354,'AU','Young',928,''),(1355,'NZ','Auckland',9,''),(1356,'NZ','Chatham Islands',3,''),(1357,'NZ','Christchurch',3,''),(1358,'NZ','Dunedin',3,''),(1359,'NZ','Hamilton',7,''),(1360,'NZ','Hastings',6,''),(1361,'NZ','Invercargill',3,''),(1362,'NZ','Napier',6,''),(1363,'NZ','Nelson',3,''),(1364,'NZ','New Plymouth',6,''),(1365,'NZ','Palmerston North',6,''),(1366,'NZ','Richmond',765,''),(1367,'NZ','Tauranga Harbour',7,''),(1368,'NZ','Timaru',3,''),(1369,'NZ','Wellington',4,''),(1370,'NZ','Westport',812,''),(1371,'US','Jersey City',201,' NJ'),(1372,'US','Washington',202,' DC'),(1373,'US','New Haven',203,' CT'),(1374,'US','Birmingham',205,' AL'),(1375,'US','Seattle',206,' WA'),(1376,'US','Portland',207,' ME'),(1377,'US','Boise',208,' ID'),(1378,'US','Modesto',209,' CA'),(1379,'US','San Antonio',210,' TX'),(1380,'US','New York',212,' NY'),(1381,'US','Los Angeles',213,' CA'),(1382,'US','Dallas',214,' TX'),(1383,'US','Philadelphia',215,' PA'),(1384,'US','Cleveland',216,' OH'),(1385,'US','Champaign',217,' IL'),(1386,'US','Duluth',218,' MN'),(1387,'US','Gary',219,' IN'),(1388,'US','Wauconda',224,' IL'),(1389,'US','Baton Rouge',225,' LA'),(1390,'US','Gulfport',228,' MS'),(1391,'US','Albany',229,' GA'),(1392,'US','Muskegon',231,' MI'),(1393,'US','Akron',234,' OH'),(1394,'US','Naples',239,' FL'),(1395,'US','Gaithersburg',240,' MD'),(1396,'US','Royal Oak',248,' MI'),(1397,'US','Mobile',251,' AL'),(1398,'US','Greenville',252,' NC'),(1399,'US','Tacoma',253,' WA'),(1400,'US','Waco',254,' TX'),(1401,'US','Huntsville',256,' AL'),(1402,'US','Auburn',260,' IN'),(1403,'US','Racine',262,' WI'),(1404,'US','Doylestown',267,' PA'),(1405,'US','Woodland',269,' MI'),(1406,'US','Bowling Green',270,' KY'),(1407,'US','Martinsville',276,' VA'),(1408,'US','Houston',281,' TX'),(1409,'US','Rockville',301,' MD'),(1410,'US','Wilmington',302,' DE'),(1411,'US','Denver',303,' CO'),(1412,'US','Charleston',304,' WV'),(1413,'US','Miami',305,' FL'),(1414,'US','Cheyenne',307,' WY'),(1415,'US','Grand Island',308,' NE'),(1416,'US','Peoria',309,' IL'),(1417,'US','Los Angeles',310,' CA'),(1418,'US','Chicago',312,' IL'),(1419,'US','Detroit',313,' MI'),(1420,'US','Saint Louis',314,' MO'),(1421,'US','Syracuse',315,' NY'),(1422,'US','Wichita',316,' KS'),(1423,'US','Indianapolis',317,' IN'),(1424,'US','Shreveport',318,' LA'),(1425,'US','Cedar Rapids',319,' IA'),(1426,'US','Saint Cloud',320,' MN'),(1427,'US','Melbourne',321,' FL'),(1428,'US','Los Angeles',323,' CA'),(1429,'US','Menard',325,' TX'),(1430,'US','Akron',330,' OH'),(1431,'US','Elmhurst',331,' IL'),(1432,'US','Montgomery',334,' AL'),(1433,'US','Greensboro',336,' NC'),(1434,'US','Lafayette',337,' LA'),(1435,'US','Hingham',339,' MA'),(1436,'US','Charlotte Amalie',340,' VI'),(1437,'US','Ridgewood',347,' NY'),(1438,'US','Danvers',351,' MA'),(1439,'US','Gainesville',352,' FL'),(1440,'US','Vancouver',360,' WA'),(1441,'US','Corpus Christi',361,' TX'),(1442,'US','Provo',385,' UT'),(1443,'US','Daytona Beach',386,' FL'),(1444,'US','Providence',401,' RI'),(1445,'US','Omaha',402,' NE'),(1446,'US','Atlanta',404,' GA'),(1447,'US','Oklahoma City',405,' OK'),(1448,'US','Billings',406,' MT'),(1449,'US','Orlando',407,' FL'),(1450,'US','San Jose',408,' CA'),(1451,'US','Beaumont',409,' TX'),(1452,'US','Baltimore',410,' MD'),(1453,'US','Pittsburgh',412,' PA'),(1454,'US','Springfield',413,' MA'),(1455,'US','Milwaukee',414,' WI'),(1456,'US','San Francisco',415,' CA'),(1457,'US','Springfield',417,' MO'),(1458,'US','Toledo',419,' OH'),(1459,'US','Chattanooga',423,' TN'),(1460,'US','Hawthorne',424,' CA'),(1461,'US','Kirkland',425,' WA'),(1462,'US','Texarkana',430,' TX'),(1463,'US','Balmorhea',432,' TX'),(1464,'US','Lynchburg',434,' VA'),(1465,'US','St George',435,' UT'),(1466,'US','Cleveland',440,' OH'),(1467,'US','Oceanside',442,' CA'),(1468,'US','Pikesville',443,' MD'),(1469,'US','Oregon',458,''),(1470,'US','Plano',469,' TX'),(1471,'US','Georgia',470,''),(1472,'US','New Haven',475,' CT'),(1473,'US','Macon',478,' GA'),(1474,'US','Dover',479,' AR'),(1475,'US','Mesa',480,' AZ'),(1476,'US','Exton',484,' PA'),(1477,'US','Little Rock',501,' AR'),(1478,'US','Louisville',502,' KY'),(1479,'US','Portland',503,' OR'),(1480,'US','New Orleans',504,' LA'),(1481,'US','Albuquerque',505,' NM'),(1482,'US','Rochester',507,' MN'),(1483,'US','Worcester',508,' MA'),(1484,'US','Spokane',509,' WA'),(1485,'US','Oakland',510,' CA'),(1486,'US','Austin',512,' TX'),(1487,'US','Cincinnati',513,' OH'),(1488,'US','Des Moines',515,' IA'),(1489,'US','Lynbrook',516,' NY'),(1490,'US','Lansing',517,' MI'),(1491,'US','Albany',518,' NY'),(1492,'US','Tucson',520,' AZ'),(1493,'US','Chico',530,' CA'),(1494,'US','Tulsa',539,' OK'),(1495,'US','Roanoke',540,' VA'),(1496,'US','Eugene',541,' OR'),(1497,'US','Jersey City',551,' NJ'),(1498,'US','Fresno',559,' CA'),(1499,'US','West Palm Beach',561,' FL'),(1500,'US','Long Beach',562,' CA'),(1501,'US','Davenport',563,' IA'),(1502,'US','New Riegel',567,' OH'),(1503,'US','Scranton',570,' PA'),(1504,'US','Herndon',571,' VA'),(1505,'US','Columbia',573,' MO'),(1506,'US','Macy',574,' IN'),(1507,'US','Eagle Nest',575,' NM'),(1508,'US','Lawton',580,' OK'),(1509,'US','Rochester',585,' NY'),(1510,'US','Roseville',586,' MI'),(1511,'US','Jackson',601,' MS'),(1512,'US','Phoenix',602,' AZ'),(1513,'US','Manchester',603,' NH'),(1514,'US','Sioux Falls',605,' SD'),(1515,'US','London',606,' KY'),(1516,'US','Binghamton',607,' NY'),(1517,'US','Madison',608,' WI'),(1518,'US','Atlantic City',609,' NJ'),(1519,'US','Reading',610,' PA'),(1520,'US','Minneapolis',612,' MN'),(1521,'US','Columbus',614,' OH'),(1522,'US','Nashville',615,' TN'),(1523,'US','Grand Rapids',616,' MI'),(1524,'US','Boston',617,' MA'),(1525,'US','Belleville',618,' IL'),(1526,'US','San Diego',619,' CA'),(1527,'US','Hutchinson',620,' KS'),(1528,'US','Phoenix',623,' AZ'),(1529,'US','Alhambra',626,' CA'),(1530,'US','Naperville',630,' IL'),(1531,'US','Huntington',631,' NY'),(1532,'US','Harvester',636,' MO'),(1533,'US','Mason City',641,' IA'),(1534,'US','New York',646,' NY'),(1535,'US','San Mateo',650,' CA'),(1536,'US','Saint Paul',651,' MN'),(1537,'US','Westminster',657,' CA'),(1538,'US','Sedalia',660,' MO'),(1539,'US','Bakersfield',661,' CA'),(1540,'US','Tupelo',662,' MS'),(1541,'US','Agana Heights',671,' GU'),(1542,'US','Atlanta',678,' GA'),(1543,'US','Parkersburg',681,' WV'),(1544,'US','Roanoke',682,' TX'),(1545,'US','Pago Pago',684,' AS'),(1546,'US','Fargo',701,' ND'),(1547,'US','Las Vegas',702,' NV'),(1548,'US','Alexandria',703,' VA'),(1549,'US','Charlotte',704,' NC'),(1550,'US','Augusta',706,' GA'),(1551,'US','Santa Rosa',707,' CA'),(1552,'US','Oak Park',708,' IL'),(1553,'US','Sioux City',712,' IA'),(1554,'US','Houston',713,' TX'),(1555,'US','Santa Ana',714,' CA'),(1556,'US','Eau Claire',715,' WI'),(1557,'US','Buffalo',716,' NY'),(1558,'US','Lancaster',717,' PA'),(1559,'US','Brooklyn',718,' NY'),(1560,'US','Colorado Springs',719,' CO'),(1561,'US','Denver',720,' CO'),(1562,'US','Greensburg',724,' PA'),(1563,'US','Saint Petersburg',727,' FL'),(1564,'US','Jackson',731,' TN'),(1565,'US','Toms River',732,' NJ'),(1566,'US','Ann Arbor',734,' MI'),(1567,'US','Zanesville',740,' OH'),(1568,'US','Los Angeles',747,' CA'),(1569,'US','Fort Lauderdale',754,' FL'),(1570,'US','Virginia Beach',757,' VA'),(1571,'US','Vista',760,' CA'),(1572,'US','Dalton',762,' GA'),(1573,'US','Minneapolis',763,' MN'),(1574,'US','Muncie',765,' IN'),(1575,'US','Bailey',769,' MS'),(1576,'US','Atlanta',770,' GA'),(1577,'US','Port Saint Lucie',772,' FL'),(1578,'US','Chicago',773,' IL'),(1579,'US','Northboro',774,' MA'),(1580,'US','Reno',775,' NV'),(1581,'US','Rockford',779,' IL'),(1582,'US','Lynn',781,' MA'),(1583,'US','Topeka',785,' KS'),(1584,'US','Miami',786,' FL'),(1585,'US','Salinas',787,' PR'),(1586,'US','Ogden',801,' UT'),(1587,'US','Burlington',802,' VT'),(1588,'US','Columbia',803,' SC'),(1589,'US','Richmond',804,' VA'),(1590,'US','Santa Barbara',805,' CA'),(1591,'US','Lubbock',806,' TX'),(1592,'US','Honolulu',808,' HI'),(1593,'US','Flint',810,' MI'),(1594,'US','Evansville',812,' IN'),(1595,'US','Tampa',813,' FL'),(1596,'US','Erie',814,' PA'),(1597,'US','Rockford',815,' IL'),(1598,'US','Kansas City',816,' MO'),(1599,'US','Fort Worth',817,' TX'),(1600,'US','Van Nuys',818,' CA'),(1601,'US','Asheville',828,' NC'),(1602,'US','New Braunfels',830,' TX'),(1603,'US','Santa Cruz',831,' CA'),(1604,'US','Houston',832,' TX'),(1605,'US','Charleston',843,' SC'),(1606,'US','Spring Valley',845,' NY'),(1607,'US','Arlington Hts',847,' IL'),(1608,'US','Metuchen',848,' NJ'),(1609,'US','Tallahassee',850,' FL'),(1610,'US','Moorestown',856,' NJ'),(1611,'US','Quincy',857,' MA'),(1612,'US','San Diego',858,' CA'),(1613,'US','Lexington',859,' KY'),(1614,'US','Hartford',860,' CT'),(1615,'US','Pompton Lakes',862,' NJ'),(1616,'US','Lakeland',863,' FL'),(1617,'US','Greenville',864,' SC'),(1618,'US','Knoxville',865,' TN'),(1619,'US','Jonesboro',870,' AR'),(1620,'US','Chicago',872,' IL'),(1621,'US','Pennsylvania',878,''),(1622,'US','Memphis',901,' TN'),(1623,'US','Tyler',903,' TX'),(1624,'US','Jacksonville',904,' FL'),(1625,'US','Marquette',906,' MI'),(1626,'US','Anchorage',907,' AK'),(1627,'US','Plainfield',908,' NJ'),(1628,'US','San Bernardino',909,' CA'),(1629,'US','Fayetteville',910,' NC'),(1630,'US','Savannah',912,' GA'),(1631,'US','Kansas City',913,' KS'),(1632,'US','Yonkers',914,' NY'),(1633,'US','El Paso',915,' TX'),(1634,'US','Sacramento',916,' CA'),(1635,'US','New York',917,' NY'),(1636,'US','Tulsa',918,' OK'),(1637,'US','Raleigh',919,' NC'),(1638,'US','Green Bay',920,' WI'),(1639,'US','Walnut Creek',925,' CA'),(1640,'US','Yuma',928,' AZ'),(1641,'US','Flushing',929,' NY'),(1642,'US','Clarksville',931,' TN'),(1643,'US','Conroe',936,' TX'),(1644,'US','Dayton',937,' OH'),(1645,'US','Red Bay',938,' AL'),(1646,'US','Adjuntas',939,' PR'),(1647,'US','Wichita Falls',940,' TX'),(1648,'US','Sarasota',941,' FL'),(1649,'US','Ortonville',947,' MI'),(1650,'US','El Toro',949,' CA'),(1651,'US','Murrieta',951,' CA'),(1652,'US','Minneapolis',952,' MN'),(1653,'US','Fort Lauderdale',954,' FL'),(1654,'US','Laredo',956,' TX'),(1655,'US','Ft Collins',970,' CO'),(1656,'US','Portland',971,' OR'),(1657,'US','Dallas',972,' TX'),(1658,'US','Newark',973,' NJ'),(1659,'US','Lowell',978,' MA'),(1660,'US','Bryan',979,' TX'),(1661,'US','Charlotte',980,' NC'),(1662,'US','Houma',985,' LA'),(1663,'US','Saginaw',989,' MI'),(1664,'CA','Lynn Lake',204,' MB'),(1665,'CA','Shalalth',250,' BC'),(1666,'CA','Aurora',289,' ON'),(1667,'CA','Yellow Creek',306,' SK'),(1668,'CA','Ralston',403,' AB'),(1669,'CA','Toronto',416,' ON'),(1670,'CA','Riviere Du Loup',418,' QC'),(1671,'CA','Farnham',450,' QC'),(1672,'CA','Tracadie',506,' NB'),(1673,'CA','Montreal',514,' QC'),(1674,'CA','Saint Marys',519,' ON'),(1675,'CA','New Westminister',604,' BC'),(1676,'CA','Adolphustown',613,' ON'),(1677,'CA','Toronto',647,' ON'),(1678,'CA','Stroud',705,' ON'),(1679,'CA','Fermeuse',709,' NL'),(1680,'CA','Port Coquitlam',778,' BC'),(1681,'CA','Eaglesham',780,' AB'),(1682,'CA','Hudson',807,' ON'),(1683,'CA','Gentilly',819,' QC'),(1684,'CA','Wekweti',867,' NT'),(1685,'CA','Georgetown',902,' PE'),(1686,'CA','Wellandport',905,' ON');
/*!40000 ALTER TABLE `world_city_area_codes` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2019-09-30 10:55:36