-
Notifications
You must be signed in to change notification settings - Fork 0
/
zfcourse.sql
executable file
·448 lines (385 loc) · 101 KB
/
zfcourse.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
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
-- MySQL dump 10.13 Distrib 8.0.18, for Linux (x86_64)
--
-- Host: 127.0.0.1 Database: zfcourse
-- ------------------------------------------------------
-- Server version 8.0.18
/*!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 */;
/*!50503 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 */;
/*!50503 SET character_set_client = utf8mb4 */;
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=36 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 */;
INSERT INTO `access_log` VALUES (1,'127.0.0.1',NULL,'2017-09-21 12:14:12','http://zf3.guestbook.local/restricted'),(2,'127.0.0.1',NULL,'2017-09-21 12:16:07','http://zf3.guestbook.local/restricted'),(3,'127.0.0.1',NULL,'2017-09-21 12:17:13','http://zf3.guestbook.local/restricted'),(4,'127.0.0.1',NULL,'2017-09-21 12:18:40','http://zf3.guestbook.local/restricted'),(5,'127.0.0.1',NULL,'2017-09-21 12:19:06','http://zf3.guestbook.local/restricted'),(6,'127.0.0.1',NULL,'2017-09-21 12:29:49','http://zf3.guestbook.local/restricted'),(7,'127.0.0.1',NULL,'2017-09-21 12:30:18','http://zf3.guestbook.local/restricted'),(8,'127.0.0.1',NULL,'2017-09-21 12:44:29','http://zf3.guestbook.local/restricted'),(9,'127.0.0.1',NULL,'2017-09-21 13:06:27','http://zf3.guestbook.local/restricted'),(10,'127.0.0.1',NULL,'2017-09-22 05:42:18','http://zf3.guestbook.local/manage/lookup'),(11,'127.0.0.1',NULL,'2017-09-22 05:43:00','http://zf3.guestbook.local/manage/lookup'),(12,'127.0.0.1',NULL,'2017-09-22 05:43:10','http://zf3.guestbook.local/manage/lookup?_=1506058989859'),(13,'127.0.0.1',NULL,'2017-09-22 05:45:22','http://zf3.guestbook.local/manage/lookup?_=1506059122446'),(14,'127.0.0.1',NULL,'2017-09-22 05:45:31','http://zf3.guestbook.local/manage/lookup'),(15,'127.0.0.1',NULL,'2017-09-22 05:46:05','http://zf3.guestbook.local/manage/lookup'),(16,'127.0.0.1',NULL,'2017-09-22 05:46:15','http://zf3.guestbook.local/manage/lookup?_=1506059175818'),(17,'127.0.0.1',NULL,'2017-09-22 06:42:34','http://zf3.guestbook.local/manage/lookup?_=1506062554381'),(18,'127.0.0.1',NULL,'2017-11-30 05:57:28','http://zf3.guestbook.local/manage/lookup?_=1512021447850'),(19,'127.0.0.1',NULL,'2017-11-30 06:00:29','http://onlinemarket.complete/manage/lookup'),(20,'127.0.0.1',NULL,'2017-11-30 06:00:38','http://onlinemarket.complete/manage/lookup?_=1512021637962'),(21,'127.0.0.1',NULL,'2018-01-26 05:31:13','http://localhost:9999/manage/lookup?_=1516944673086'),(22,'127.0.0.1',NULL,'2018-01-26 05:33:27','http://localhost:9999/manage/lookup?_=1516944807081'),(23,'127.0.0.1',NULL,'2018-01-26 05:34:39','http://localhost:9999/manage/lookup?_=1516944879230'),(24,'127.0.0.1',NULL,'2018-01-26 05:44:03','http://localhost:9999/manage/lookup?_=1516945443190'),(25,'127.0.0.1',NULL,'2018-05-22 05:21:37','http://onlinemarket.complete.local/manage/lookup?_=1526966497399'),(26,'127.0.0.1',NULL,'2018-06-11 06:32:59','http://onlinemarket.complete.local/manage/lookup?_=1528698779164'),(27,'127.0.0.1',NULL,'2018-06-11 06:35:17','http://onlinemarket.complete.local/manage/lookup?_=1528698917125'),(28,'127.0.0.1',NULL,'2018-06-11 06:38:57','http://onlinemarket.complete.local/manage/lookup?_=1528699136920'),(29,'127.0.0.1',NULL,'2018-06-11 06:42:23','http://onlinemarket.complete.local/manage/lookup?_=1528699343403'),(30,'127.0.0.1',NULL,'2018-06-11 06:53:07','http://onlinemarket.complete.local/manage/lookup?_=1528699987062'),(31,'127.0.0.1',NULL,'2018-06-11 06:58:59','http://onlinemarket.complete.local/manage/lookup'),(32,'127.0.0.1',NULL,'2018-06-11 06:59:58','http://onlinemarket.complete.local/manage/lookup?_=1528700398733'),(33,'127.0.0.1',NULL,'2018-06-27 14:44:12','http://onlinemarket.complete.local/manage/lookup?_=1530110651885'),(34,'127.0.0.1',NULL,'2018-06-27 14:45:14','http://onlinemarket.complete.local/manage/lookup?_=1530110714059'),(35,'127.0.0.1',NULL,'2018-07-24 08:26:48','http://onlinemarket.complete.local/manage/lookup?_=1532420808673');
/*!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 */;
/*!50503 SET character_set_client = utf8mb4 */;
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=61 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');
/*!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 */;
/*!50503 SET character_set_client = utf8mb4 */;
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`) ON DELETE RESTRICT ON UPDATE RESTRICT
) 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 */;
/*!50503 SET character_set_client = utf8mb4 */;
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 */;
/*!50503 SET character_set_client = utf8mb4 */;
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 */;
/*!50503 SET character_set_client = utf8mb4 */;
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','[email protected]','[email protected]',NULL),(2,'5f878a1b0f663de59c673d0cd6ba99b6fd551eab1803a596e30ef5ad47fe3decB7Itoz1pw9odtEc5G4ewt+mAqeeaJAspsYzAdxHwssxPjqVEXCAvZG+xES+Vp3fZD3NTcdhQq1BucB6z9mD7/Q==','[email protected]','[email protected]',NULL),(3,'5b6746f53844feb2a566112722a58dfd5da7a567df312c568e20b7ff1dc270166ngmWdQ1ULrvfN0/P0QAl7W6CgCjqRoiFo6e5T2r/LwIXqUVL63pfpXYxg9MH37/','[email protected]','[email protected]',NULL),(4,'91196a93cad8c0c4c050d85169531ca9bd0f1497eddff5d1fa11082cef6f34a1KjFtvkTemKLzSiuV7dcJPr3d3UE0vmBgCBhrMUrhFmglDldKX/DjE/XmBQseTMB6OOAzkZ/V8ZKIwjI4VDuY0g==','[email protected]','[email protected]',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 */;
/*!50503 SET character_set_client = utf8mb4 */;
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=55 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','[email protected]','http://unlikelysource.com/','Doug dogged duck. Duck dug dog. Dog ducked Doug.','phpZULGwh_5b9f4374e2dc52_07862997','2018-09-17 13:02:28'),(53,'Fon','[email protected]','http://unlikelysource.com/','Fon phoned for fun. Phone fun had Fon. Fun phoning Fon.','phpxPnKgB_5b9f4472167a01_55848081','2018-09-17 13:06:42'),(54,'Fon','[email protected]','http://unlikelysource.com/','Fon phone home.','phpVVNLfV_5b9f66b1750402_27477978','2018-09-17 15:32:49');
/*!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 */;
/*!50503 SET character_set_client = utf8mb4 */;
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=69 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 (1,'beauty','Classic Cuts','2013-08-16 20:43:05',NULL,'Sed magna tellus, consectetur vel luctus id, viverra eget mi. Mauris rutrum est lobortis turpis vehicula dapibus. Nam fringilla luctus felis, nec placerat massa rutrum eget. Phasellus at ante at justo gravida accumsan. Vestibulum gravida viverra erat, id ornare elit tincidunt mattis. Morbi nulla massa, pulvinar ac auctor sed, porttitor id risus. Nulla eu interdum risus. Nam semper aliquet velit, at varius nibh scelerisque ullamcorper. Vestibulum lectus justo, fermentum a sagittis pellentesque, luctus vitae tellus.','/images/beauty/beauty_classic_cuts.png','Jake Conner','[email protected]','+91 721-706-2109','Amravati','IN',4068.68,NULL),(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','[email protected]','+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','[email protected]','+55 11-946-6214','Santo Andr','BR',1667.63,NULL),(4,'beauty','Muga Makeup','2013-04-25 00:23:46',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/beauty/beauty_Muga_Make_up.png','Darren Mayo','[email protected]','+91 6466-627-224','Kishanganj','IN',2013.95,NULL),(5,'entertainment','Disco Ball Remix by Merlin','2013-04-17 17:23: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/entertainment/entertainment_Disco_Ball_Remix_by_Merlin2525.png','Esteban Hines','[email protected]','+1 418-653-1146','Riviere Du Loup','CA',5066.86,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','[email protected]','+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','[email protected]','+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','[email protected]','+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','[email protected]','+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','[email protected]','+91 6226-950-476','Sitamarhi','IN',8370.72,NULL),(11,'clothing','Remi Inconnu Shoes','2013-05-10 15:32:21',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_remi_inconnu_shoe.png','Armando Curry','[email protected]','+91 6782-949-471','Balasore','IN',6560.08,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','[email protected]','+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','[email protected]','+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','[email protected]','+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','[email protected]','+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','[email protected]','+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','[email protected]','+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','[email protected]','+33 2-860-0826','Rouen','FR',439.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','[email protected]','+1 867-706-3327','Wekweti','CA',49.95,NULL),(21,'phones','Original Telefono Pubblico SIP','2013-11-25 19:25:53',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/phones/phones_Telefono_Pubblico_SIP.png','Ava Gallagher','[email protected]','+234 2-162-9665','Ibadan','NG',399.00,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','[email protected]','+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','[email protected]','+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','[email protected]','+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','[email protected]','+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','[email protected]','+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','[email protected]','+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','[email protected]','+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','[email protected]','+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','[email protected]','+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','[email protected]','+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','[email protected]','+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','[email protected]','+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','[email protected]','+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','[email protected]','+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','[email protected]','+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','[email protected]','+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','[email protected]','+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','[email protected]','+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','[email protected]','+1 555-666-7777','Aachen','DE',129.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','[email protected]','+7 495-555-6666','Moscow','RU',9.99,'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','[email protected]','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','[email protected]','+00-000-000-0000','Cairo','EG',99.99,'12345'),(59,'computer','Used Classic Computer','2017-11-16 04:59:47','2017-11-16 04:59:47','Used classic computer','/images/computer/computer_old.png','Some Geek','[email protected]','111-222-3333','New York','US',999.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.','/images/wanted/wanted_waterfall.png','Patricia de Lille','[email protected]','+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.','/images/garden/volcano.jpg','NGS','[email protected]','+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!','/images/barter/barter_sled_dogs.png','S. Kimo','[email protected]','+1-907-459-2700','Fairbanks AK','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.','/images/general/general_military_general.png','E. Prince','[email protected]','+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.','/images/clothing/clothing_hand_warmer.png','The Napster','[email protected]','+33-444-555-6666','Paris','FR',9.99,'12345');
/*!40000 ALTER TABLE `listings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `log`
--
DROP TABLE IF EXISTS `log`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `log` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`priority` int(11) DEFAULT NULL,
`priorityName` varchar(20) DEFAULT NULL,
`message` varchar(255) DEFAULT NULL,
`timestamp` varchar(45) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `log`
--
LOCK TABLES `log` WRITE;
/*!40000 ALTER TABLE `log` DISABLE KEYS */;
INSERT INTO `log` VALUES (1,NULL,NULL,NULL,NULL),(2,NULL,NULL,NULL,NULL),(3,6,'INFO','Informational Message','2019-01-16T10:35:09-08:00');
/*!40000 ALTER TABLE `log` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `messages`
--
DROP TABLE IF EXISTS `messages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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=37 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 (32,'Wednesday Test','[email protected]','[email protected]','2018-09-26 14:08:50'),(33,'Test Message to Admin','[email protected]','[email protected]','2018-09-26 17:20:01'),(34,'Have you talked to Daryl yet?','[email protected]','[email protected]','2018-09-26 17:20:35'),(35,'Have you talked to Doug yet?','[email protected]','[email protected]','2018-09-26 17:20:48'),(36,'You need to call Bob','[email protected]','[email protected]','2018-09-26 17:21:31');
/*!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 */;
/*!50503 SET character_set_client = utf8mb4 */;
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=36 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');
/*!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 */;
/*!50503 SET character_set_client = utf8mb4 */;
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`) ON DELETE RESTRICT ON UPDATE RESTRICT
) 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 */;
/*!50503 SET character_set_client = utf8mb4 */;
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\":275:{a:4:{s:7:\"storage\";a:1:{s:7:\"message\";s:48:\"<b style=\"color:green;\">Login was successful</b>\";}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\":851:{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:\"4\";s:5:\"email\";s:14:\"[email protected]\";s:8:\"username\";s:5:\"daryl\";s:8:\"password\";s:60:\"$2y$10$Gy8fTpy1K.0Hy1iCf4S6ee5z0Hi6GUARoDHwnAf8EKIRA.XrRLIma\";s:16:\"securityquestion\";s:28:\"What is your favorite sport?\";s:14:\"securityanswer\";s:8:\"Kayaking\";s:4:\"role\";s:4:\"user\";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:\"r1plsl1vhtpl71pcv85s5fc7g1\";}}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 */;
/*!50503 SET character_set_client = utf8mb4 */;
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=17 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,'[email protected]','OAuth',NULL,NULL,NULL,'user','google','en'),(3,'[email protected]','doug','$2y$10$eFpYKtvtbe8wqSCk5mDLke.5n7jr2tQ1ILV48VaWbHxULxwYsal7e','How many dogs do you have?','5','user','default','fr'),(4,'[email protected]','daryl','$2y$10$Gy8fTpy1K.0Hy1iCf4S6ee5z0Hi6GUARoDHwnAf8EKIRA.XrRLIma','What is your favorite sport?','Kayaking','user','default','en'),(6,'[email protected]','admin','$2y$10$SZx5lX6/hJFb//lvocLkeessDzlL7hmr63BBmcVFC22iT/1SCZz6C','What language is Zend Framework written in?','PHP','admin','default','en'),(12,'[email protected]','fred','$2y$10$IyS3Mg3705V57INkHpRnVuH4kYJF7z4H3Ld1dzgQYzVGN4K/US5fm','What is made of rock?','stone','user','default','fr'),(16,'[email protected]','wilma','$2y$10$YKvhiV2.di4dM.CiRmWyqOKeBwnTG.B/G3RXcF0CsQLfW4BZiJK9q','Where is Bedrock?','nowhere','user',NULL,NULL);
/*!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 */;
/*!50503 SET character_set_client = utf8mb4 */;
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-11-25 10:24:43