-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathflippers.sql
897 lines (865 loc) · 90.4 KB
/
flippers.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
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
-- phpMyAdmin SQL Dump
-- version 4.1.2
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Sep 05, 2014 at 11:44 PM
-- Server version: 5.6.19
-- PHP Version: 5.4.24
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `flippers`
--
-- --------------------------------------------------------
--
-- Table structure for table `bars`
--
CREATE TABLE IF NOT EXISTS `bars` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`latitude` float DEFAULT NULL,
`longitude` float DEFAULT NULL,
`url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=121 ;
--
-- Dumping data for table `bars`
--
INSERT INTO `bars` (`id`, `name`, `address`, `latitude`, `longitude`, `url`, `created_at`, `updated_at`) VALUES
(34, 'La Fac', ' 45 Rue Jussieu 75005 Paris', 48.8472, 2.35314, 'http://geoflipper.fr/la-fac/', '2014-08-02 17:34:41', '2014-08-02 17:34:41'),
(35, 'Le soleil levant', ' 95 Rue Saint-Maur 75011 Paris', 48.8648, 2.37786, 'http://geoflipper.fr/le-soleil-levant/', '2014-08-02 17:34:47', '2014-08-02 17:34:47'),
(36, 'Le Paris Nord', ' 138 Rue du Faubourg Poissonnière 75010 Paris', 48.8811, 2.3498, 'http://geoflipper.fr/le-paris-nord/', '2014-08-02 17:34:54', '2014-08-02 17:34:54'),
(37, 'Le Relais', ' 134 Rue du Chemin Vert 75011 Paris', 48.8623, 2.3852, 'http://geoflipper.fr/le-relais-2/', '2014-08-02 17:35:01', '2014-08-02 17:35:01'),
(38, 'Le Week-End', ' 42 Boulevard Henri IV, 75004 Paris', 48.8525, 2.36714, 'http://geoflipper.fr/le-week-end-3/', '2014-08-02 17:35:07', '2014-08-02 17:35:07'),
(39, 'L Etoile', ' 44 Rue des Fossés-Saint-Bernard 75005 Paris', 48.8474, 2.35298, 'http://geoflipper.fr/levalmozzola/', '2014-08-02 17:35:13', '2014-08-02 17:35:13'),
(40, 'Le Week-End', ' 59 Rue de Turbigo 75003 Paris', 48.8657, 2.357, 'http://geoflipper.fr/le-week-end-2/', '2014-08-02 17:35:20', '2014-08-02 17:35:20'),
(41, 'Le Carrefour', ' 92 rue Oberkampf 75011 Paris', 48.8656, 2.37737, 'http://geoflipper.fr/le-carrefour/', '2014-08-02 17:35:25', '2014-08-02 17:35:25'),
(42, 'Terminus Château', ' 9 Avenue de Nogent 75012 Paris', 48.8447, 2.44055, 'http://geoflipper.fr/terminus-chateau/', '2014-08-02 17:35:31', '2014-08-02 17:35:31'),
(43, 'Le Multiplex', ' 27 Rue de la Tour d''Auvergne 75009 Paris', 48.8792, 2.34319, 'http://geoflipper.fr/le-multiplex/', '2014-08-02 17:35:37', '2014-08-02 17:35:37'),
(44, 'Le Mauri 7', ' 44 rue du Faubourg St Denis, 75010 Paris', 48.8715, 2.35363, 'http://geoflipper.fr/le-mauri-7/', '2014-08-02 17:35:43', '2014-08-02 17:35:43'),
(45, 'Aux Chiffons', ' 90 Rue Marcadet 75018 Paris', 48.8906, 2.34588, 'http://geoflipper.fr/aux-chiffons/', '2014-08-02 17:35:48', '2014-08-02 17:35:48'),
(46, 'Workshop Paris', ' 173 Rue Saint-Martin 75003 Paris', 48.8626, 2.35184, 'http://geoflipper.fr/workshop-paris/', '2014-08-02 17:36:04', '2014-08-02 17:36:04'),
(47, 'Bar Robert Chez Papy', ' 83 Rue Baudricourt 75013 Paris', 48.8246, 2.36242, 'http://geoflipper.fr/bar-robert-chez-papy/', '2014-08-02 17:36:11', '2014-08-02 17:36:11'),
(48, 'L''Alliance', ' 113 Boulevard de l''Hôpital 75013 Paris', 48.836, 2.3589, 'http://geoflipper.fr/lalliance/', '2014-08-02 17:36:17', '2014-08-02 17:36:17'),
(49, 'Le Rallye', ' 64 Rue du Faubourg Poissonnière, 75010 Paris', 48.8758, 2.3482, 'http://geoflipper.fr/le-rallye/', '2014-08-02 17:36:22', '2014-08-02 17:36:22'),
(50, 'O Atlantico', ' 313 Rue de Charenton 75012 Paris', 48.8336, 2.39493, 'http://geoflipper.fr/o-atlantico/', '2014-08-02 17:36:28', '2014-08-02 17:36:28'),
(51, 'Le Sans Souci', ' 183 rue Saint Denis 75002 Paris', 48.8658, 2.35066, 'http://geoflipper.fr/le-sans-souci/', '2014-08-02 17:36:34', '2014-08-02 17:36:34'),
(52, 'Le bel air', ' 194 Rue de Belleville 75019 Paris', 48.8753, 2.39426, 'http://geoflipper.fr/le-bel-air/', '2014-08-02 17:36:39', '2014-08-02 17:36:39'),
(53, 'Holybelly', ' 19 Rue Lucien Sampaix 75010 Paris', 48.8724, 2.36096, 'http://geoflipper.fr/holybelly/', '2014-08-02 17:36:44', '2014-08-02 17:36:44'),
(54, 'Le Jean Bouin', ' 55 Rue Molitor 75016 Paris, France', 48.8453, 2.25772, 'http://geoflipper.fr/le-jean-bouin/', '2014-08-02 17:36:50', '2014-08-02 17:36:50'),
(55, 'A la consigne', ' 170 rue du Faubourg St Denis, 75010 Paris', 48.8796, 2.35726, 'http://geoflipper.fr/a-la-consigne/', '2014-08-02 17:36:56', '2014-08-02 17:36:56'),
(56, 'Le Lautrec Café', ' 1 rue de Douai, 75009 Paris', 48.8812, 2.33618, 'http://geoflipper.fr/le-lautrec-cafe/', '2014-08-02 17:37:02', '2014-08-02 17:37:02'),
(57, 'Red House', ' 1 Rue de la Forgé Royale 75012 Paris', 48.8507, 2.38018, 'http://geoflipper.fr/red-house/', '2014-08-02 17:37:07', '2014-08-02 17:37:07'),
(58, '347 Lecourbe', ' 347 Rue Lecourbe 75015 Paris', 48.8368, 2.28361, 'http://geoflipper.fr/347-lecourbe/', '2014-08-02 17:37:12', '2014-08-02 17:37:12'),
(59, 'Aux II Académies', ' 16 Rue Bonaparte 75006 Paris ', 48.8563, 2.33438, 'http://geoflipper.fr/aux-ii-academies/', '2014-08-02 17:37:17', '2014-08-02 17:37:17'),
(60, 'Le Soleil', ' 136 Boulevard de Ménilmontant 75020 Paris', 48.8662, 2.38385, 'http://geoflipper.fr/le-soleil/', '2014-08-02 17:37:24', '2014-08-02 17:37:24'),
(61, 'Le Gymnase', ' 1 Rue Huyghens 75014 Paris', 48.8414, 2.32959, 'http://geoflipper.fr/le-gymnase/', '2014-08-02 17:37:30', '2014-08-02 17:37:30'),
(62, 'Le Libre Echange', ' 34 Rue Brochant 75017 Paris', 48.8905, 2.32023, 'http://geoflipper.fr/le-libre-echange/', '2014-08-02 17:37:36', '2014-08-02 17:37:36'),
(63, 'La Tête dans les Nuages', ' 5 Boulevard des Italiens 75002 Paris', 48.8718, 2.33934, 'http://geoflipper.fr/la-tete-dans-les-nuages/', '2014-08-02 17:44:02', '2014-08-02 17:44:02'),
(64, 'Extérieur Quai', ' 7 Rue d''Alsace, 75010 Paris', 48.8767, 2.35763, 'http://geoflipper.fr/exterieur-quai/', '2014-08-02 17:44:05', '2014-08-02 17:44:05'),
(65, 'Baromaîtres', ' 24 Rue Nicolaï 75012 Paris', 48.8359, 2.39418, 'http://geoflipper.fr/baromaitres/', '2014-08-02 17:44:08', '2014-08-02 17:44:08'),
(66, 'Le Satellite', ' Rue Édouard Robert 75012 Paris', 48.8376, 2.39839, 'http://geoflipper.fr/le-satellite/', '2014-08-02 17:44:11', '2014-08-02 17:44:11'),
(67, 'Le Fantôme', ' 61 Rue d''Hauteville 75010 Paris', 48.8753, 2.35089, 'http://geoflipper.fr/le-fantome/', '2014-08-02 17:44:14', '2014-08-02 17:44:14'),
(68, 'Wanderlust', ' 32 Quai d''Austerlitz 75013 Paris', 48.84, 2.37056, 'http://geoflipper.fr/wanderlust/', '2014-08-02 17:44:20', '2014-08-02 17:44:20'),
(69, 'Le Métro', ' 60 Boulevard Saint-Germain 75005 Paris', 48.8502, 2.34825, 'http://geoflipper.fr/le-metro-2/', '2014-08-02 17:44:22', '2014-08-02 17:44:22'),
(70, 'Au Métro', ' 17 Rue de Crussol 75011 Paris', 48.8643, 2.36858, 'http://geoflipper.fr/au-metro/', '2014-08-02 17:44:25', '2014-08-02 17:44:25'),
(71, 'Le Rouergue', ' 34 Rue Jouffroy d''Abbans 75017 Paris', 48.886, 2.3096, 'http://geoflipper.fr/le-rouergue/', '2014-08-02 17:44:28', '2014-08-02 17:44:28'),
(72, 'A Jean Bart', ' 3 Rue Jouffroy d''Abbans 75017 Paris', 48.8872, 2.31368, 'http://geoflipper.fr/a-jean-bart/', '2014-08-02 17:44:31', '2014-08-02 17:44:31'),
(73, 'Bowling Front de Seine', ' 11 Rue Gaston de Caillavet 75015 Paris', 48.8493, 2.28401, 'http://geoflipper.fr/bowling-front-de-seine/', '2014-08-02 17:44:35', '2014-08-02 17:44:35'),
(74, 'Hideout Bar', ' 11 Rue du Pot de Fer 75005 Paris', 48.8429, 2.34846, 'http://geoflipper.fr/hideout-bar/', '2014-08-02 17:44:38', '2014-08-02 17:44:38'),
(75, 'Le Bouillon Belge', ' 6 Rue Planchat 75020 Paris', 48.8519, 2.39939, 'http://geoflipper.fr/le-bouillon-belge/', '2014-08-02 17:44:41', '2014-08-02 17:44:41'),
(76, 'Café Lyon', ' 40 avenue Ledru-Rollin, 75012 Paris', 48.8478, 2.37114, 'http://geoflipper.fr/cafe-lyon/', '2014-08-02 17:44:44', '2014-08-02 17:44:44'),
(77, 'Royal Strasbourg', ' 34 Boulevard de Strasbourg 75010 Paris', 48.872, 2.35601, 'http://geoflipper.fr/royal-strasbourg/', '2014-08-02 17:44:47', '2014-08-02 17:44:47'),
(78, 'Le Miro', ' 29 Rue La Boétie, 75008 Paris', 48.8739, 2.31591, 'http://geoflipper.fr/le-miro/', '2014-08-02 17:44:52', '2014-08-02 17:44:52'),
(79, 'Le Narval', ' 235 Rue des Pyrénées 75020 Paris', 48.864, 2.39916, 'http://geoflipper.fr/le-narval-2/', '2014-08-02 17:44:55', '2014-08-02 17:44:55'),
(80, 'Le Jean Bart', ' 18 rue Le Peletier, 75009 Paris', 48.8733, 2.3388, 'http://geoflipper.fr/le-jean-bart/', '2014-08-02 17:44:59', '2014-08-02 17:44:59'),
(81, 'La Rotonde Hébertine', ' 3 Place Hébert 75018 Paris', 48.8931, 2.36346, 'http://geoflipper.fr/la-rotonde-hebertine/', '2014-08-02 17:45:02', '2014-08-02 17:45:02'),
(82, 'Le Marigny', ' 4 Rue Armand Carrel 75019 Paris', 48.8825, 2.38139, 'http://geoflipper.fr/le-marigny/', '2014-08-02 17:45:05', '2014-08-02 17:45:05'),
(83, 'Turku Bar', ' 143 Rue d''Avron 75020 Paris', 48.8534, 2.4101, 'http://geoflipper.fr/amsterdam/', '2014-08-02 17:45:09', '2014-08-02 17:45:09'),
(84, 'Aux Mousquetaires', ' 135 Rue de Montreuil 75011 Paris', 48.8513, 2.39812, 'http://geoflipper.fr/aux-mousquetaires/', '2014-08-02 17:45:12', '2014-08-02 17:45:12'),
(85, 'Le Dalou', ' 30 Place de la Nation 75012 Paris', 48.8478, 2.39742, 'http://geoflipper.fr/le-dalou/', '2014-08-02 17:45:15', '2014-08-02 17:45:15'),
(86, 'La Fauvette', ' 115 Avenue Parmentier 75011 Paris', 48.8684, 2.37219, 'http://geoflipper.fr/la-fauvette/', '2014-08-02 17:45:18', '2014-08-02 17:45:18'),
(87, 'Le Trumilou', ' 84 Quai de l''Hôtel de ville 75004 Paris', 48.8548, 2.35404, 'http://geoflipper.fr/le-trumilou/', '2014-08-02 17:45:21', '2014-08-02 17:45:21'),
(88, 'Le Temps Perdu', ' 23 Rue Eugène Sue 75018 Paris', 48.8914, 2.34777, 'http://geoflipper.fr/le-temps-perdu/', '2014-08-02 17:45:25', '2014-08-02 17:45:25'),
(89, 'Le Dunhill', ' 38 Rue de Rochechouart 75009 Paris', 48.8791, 2.34554, 'http://geoflipper.fr/le-dunhill/', '2014-08-02 17:45:28', '2014-08-02 17:45:28'),
(90, 'Le Thermidor', ' 196 rue de Vaugirard, 75015 Paris', 48.8415, 2.30784, 'http://geoflipper.fr/le-thermidor/', '2014-08-02 17:45:31', '2014-08-02 17:45:31'),
(91, 'Le Murillo', ' 63 Rue de Courcelles 75008 Paris', 48.8777, 2.30592, 'http://geoflipper.fr/le-murillo/', '2014-08-02 17:45:33', '2014-08-02 17:45:33'),
(92, 'Le Balto', ' 63 Avenue de la Grande Armée 75116 Paris', 48.876, 2.28672, 'http://geoflipper.fr/le-balto-3/', '2014-08-02 17:45:36', '2014-08-02 17:45:36'),
(93, 'Royal Nation', ' 2 Avenue Philippe Auguste 75011 Paris', 48.8494, 2.39528, 'http://geoflipper.fr/royal-nation/', '2014-08-02 17:45:39', '2014-08-02 17:45:39'),
(94, 'Le Rugby', ' 3 Rue Roquépine 75008 Paris', 48.8734, 2.3202, 'http://geoflipper.fr/le-rugby/', '2014-08-02 17:45:43', '2014-08-02 17:45:43'),
(95, 'Le Mozart', ' 117 Avenue Mozart 75016 Paris', 48.8508, 2.26711, 'http://geoflipper.fr/le-mozart/', '2014-08-02 17:45:46', '2014-08-02 17:45:46'),
(96, 'Le Celtique', ' 1 Rue Simart 75018 Paris', 48.8896, 2.34955, 'http://geoflipper.fr/le-celtique-2/', '2014-08-02 17:45:50', '2014-08-02 17:45:50'),
(97, 'Le Nord Sud', ' Place Jules Joffrin 75018 Paris', 48.8925, 2.34428, 'http://geoflipper.fr/le-nord-sud/', '2014-08-02 17:45:53', '2014-08-02 17:45:53'),
(98, 'Au Péché Mignon', ' 30 Rue Sedaine 75011 Paris', 48.8565, 2.37359, 'http://geoflipper.fr/au-peche-mignon/', '2014-08-02 17:45:55', '2014-08-02 17:45:55'),
(99, 'Le Saint Malo', ' 24 Avenue Secrétan 75019 Paris', 48.8817, 2.37227, 'http://geoflipper.fr/le-saint-malo/', '2014-08-02 17:45:58', '2014-08-02 17:45:58'),
(100, 'Le Mirabeau', ' 58 Rue de la Convention 75015 Paris', 48.8433, 2.28271, 'http://geoflipper.fr/le-mirabeau/', '2014-08-02 17:46:02', '2014-08-02 17:46:02'),
(101, 'Le Nesle', ' 22 rue Dauphine, 75006 Paris', 48.8551, 2.33963, 'http://geoflipper.fr/le-nesle/', '2014-08-02 17:46:04', '2014-08-02 17:46:04'),
(102, 'Le Lutetia', ' 160 Rue du Faubourg Saint-Denis, 75010 Paris', 48.8791, 2.35701, 'http://geoflipper.fr/le-lutetia/', '2014-08-02 17:46:07', '2014-08-02 17:46:07'),
(103, 'Le kiosque', ' 13 Boulevard Auguste Blanqui, 75013 Paris', 48.8306, 2.35363, 'http://geoflipper.fr/le-kiosque/', '2014-08-02 17:46:11', '2014-08-02 17:46:11'),
(104, 'Gaumont Parnasse', ' 3 Rue d''Odessa 75015 Paris', 48.8431, 2.32434, 'http://geoflipper.fr/gaumont-parnasse/', '2014-08-02 17:46:14', '2014-08-02 17:46:14'),
(105, 'Le Bastille', ' 8 Place de la Bastille 75012 Paris', 48.8536, 2.37044, 'http://geoflipper.fr/le-bastille/', '2014-08-02 17:46:17', '2014-08-02 17:46:17'),
(106, 'Le Capucin', ' 2 Rue Marx Dormoy 75018 Paris', 48.8849, 2.35935, 'http://geoflipper.fr/le-capucin/', '2014-08-02 17:46:20', '2014-08-02 17:46:20'),
(107, 'Le Cyclone', ' 31 Rue Philippe de Girard 75010 Paris', 48.8841, 2.36153, 'http://geoflipper.fr/le-cyclone/', '2014-08-02 17:46:23', '2014-08-02 17:46:23'),
(108, 'La manette Drouot', ' 11 Rue Rossini 75009 Paris', 48.873, 2.33967, 'http://geoflipper.fr/la-manette-drouot/', '2014-08-02 17:46:27', '2014-08-02 17:46:27'),
(109, 'Tabac de la Place', ' Place Falguière 75015 Paris', 48.8362, 2.31007, 'http://geoflipper.fr/tabac-de-la-poste-2/', '2014-08-02 17:46:30', '2014-08-02 17:46:30'),
(110, 'Le Sarrette', ' 1 Rue Alphonse Daudet 75014 Paris', 48.8261, 2.32895, 'http://geoflipper.fr/le-sarrette/', '2014-08-02 17:56:39', '2014-08-02 17:56:39'),
(111, 'Le Biarritz', ' 115 rue des pyrénées, 75020 Paris', 48.8563, 2.40489, 'http://geoflipper.fr/le-biarritz/', '2014-08-02 17:56:42', '2014-08-02 17:56:42'),
(112, 'L''océan', ' 44 Avenue d''Ivry 75013 Paris', 48.8233, 2.36573, 'http://geoflipper.fr/locean-2/', '2014-08-02 17:56:46', '2014-08-02 17:56:46'),
(113, 'Le Royal', ' 34 Rue Servan 75011 Paris', 48.8615, 2.38268, 'http://geoflipper.fr/le-royal/', '2014-08-02 17:56:48', '2014-08-02 17:56:48'),
(114, 'Bistrot de l''avenir', ' 39 Rue des Pyrénées 75020 Paris', 48.8504, 2.40637, 'http://geoflipper.fr/bistrot-de-lavenir/', '2014-08-02 17:56:53', '2014-08-02 17:56:53'),
(115, 'Le Fumaillon', ' 3 Place d Italie 75013 Paris', 48.8322, 2.35618, 'http://geoflipper.fr/le-fumaillon/', '2014-08-02 17:56:56', '2014-08-02 17:56:56'),
(116, 'La divette de Montmartre', ' 136 Rue Marcadet 75018 Paris', 48.8912, 2.33925, 'http://geoflipper.fr/la-divette-de-montmartre/', '2014-08-02 17:56:59', '2014-08-02 17:56:59'),
(117, 'Le soleil du Nord', ' 38 rue Boursault 75017 Paris', 48.8844, 2.31956, 'http://geoflipper.fr/le-soleil-du-nord/', '2014-08-02 17:57:02', '2014-08-02 17:57:02'),
(118, 'Le Davout', ' 137 rue d''Avron 75020 Paris', 48.8535, 2.41041, 'http://geoflipper.fr/le-davout/', '2014-08-02 17:57:05', '2014-08-02 17:57:05'),
(119, 'A Trianon', ' 69 Rue de Belleville 75019 Paris', 48.8735, 2.38302, 'http://geoflipper.fr/a-trianon/', '2014-08-02 17:57:08', '2014-08-02 17:57:08'),
(120, 'Le Montmartre', ' 18 Rue Custine 75018 Paris', 48.8885, 2.3479, 'http://geoflipper.fr/le-montmartre/', '2014-08-02 17:57:11', '2014-08-02 17:57:11');
-- --------------------------------------------------------
--
-- Table structure for table `cheap_bars`
--
CREATE TABLE IF NOT EXISTS `cheap_bars` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`latitude` float DEFAULT NULL,
`longitude` float DEFAULT NULL,
`url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`price` float DEFAULT NULL,
`original_price` float DEFAULT NULL,
`happy_hour` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=426 ;
--
-- Dumping data for table `cheap_bars`
--
INSERT INTO `cheap_bars` (`id`, `name`, `address`, `latitude`, `longitude`, `url`, `price`, `original_price`, `happy_hour`, `created_at`, `updated_at`) VALUES
(1, 'Chez Quan', '21, rue Copreaux', 48.8417, 2.30705, NULL, 3, 3, 'Happy hour: h - h', '2014-09-05 22:31:46', '2014-09-05 22:31:46'),
(2, 'Le Forum', '104, rue de Vaugirard', 48.8465, 2.32312, NULL, 5, 5, 'Happy hour: h - h', '2014-09-05 22:31:47', '2014-09-05 22:31:47'),
(3, 'Le Scoop', '117, rue des Dames', 48.8825, 2.31721, NULL, 3.8, 5.5, 'Happy hour: 18h30 - 20h30', '2014-09-05 22:31:47', '2014-09-05 22:31:47'),
(4, 'L''Escale', '34, rue de Clignancourt', 48.886, 2.3481, NULL, 4.5, 4.5, 'Happy hour: h - h', '2014-09-05 22:31:47', '2014-09-05 22:31:47'),
(5, 'Syphax', '26, rue de Châteaudun', 48.8763, 2.33763, NULL, 3, 3, 'Happy hour: h - h', '2014-09-05 22:31:47', '2014-09-05 22:31:47'),
(6, 'Le Mélocoton', '10, rue Descartes', 48.8471, 2.34866, NULL, 3, 4.5, 'Happy hour: 17h00 - 22h00', '2014-09-05 22:31:48', '2014-09-05 22:31:48'),
(7, 'Piment Café', '15, rue de Sévigné', 48.8565, 2.36224, NULL, 3.5, 5, 'Happy hour: 18h00 - 21h00', '2014-09-05 22:31:48', '2014-09-05 22:31:48'),
(8, 'La Ménagerie', '90, boulevard de l''Hôpital', 48.8366, 2.35931, NULL, 3.5, 5, 'Happy hour: 16h00 - 22h00', '2014-09-05 22:31:48', '2014-09-05 22:31:48'),
(9, 'Beer Pong Bar', '99, boulevard de l''Hôpital', 48.8373, 2.36039, NULL, 4, 0, 'Happy hour: 16h00 - 22h00', '2014-09-05 22:31:48', '2014-09-05 22:31:48'),
(10, 'La Mascotte', '43, rue Desnouettes', 48.835, 2.28709, NULL, 3.5, 0, 'Happy hour: 18h00 - 20h00', '2014-09-05 22:31:49', '2014-09-05 22:31:49'),
(11, 'The Wall', '51, rue Lacépède', 48.8442, 2.34981, NULL, 3.5, 0, 'Happy hour: h - h', '2014-09-05 22:31:49', '2014-09-05 22:31:49'),
(12, 'James Hetfeeld''s Pub', '17, Boulevard Poissonière', 48.8708, 2.34484, NULL, 4, 4, 'Happy hour: h - h', '2014-09-05 22:31:49', '2014-09-05 22:31:49'),
(13, 'L''Antidote', '45, rue Descartes', 48.8453, 2.34919, NULL, 3.5, 5, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:31:49', '2014-09-05 22:31:49'),
(14, 'Objectif Lune', '19 rue de la roquette', 48.8546, 2.37182, NULL, 3, 4, 'Happy hour: 18h00 - 22h00', '2014-09-05 22:31:50', '2014-09-05 22:31:50'),
(15, 'Le Tape', '21 rue de la roquette', 48.8548, 2.37213, NULL, 3.8, 5, 'Happy hour: 18h00 - 21h00', '2014-09-05 22:31:50', '2014-09-05 22:31:50'),
(16, 'L''Orange Mécanique', '72bis, rue Jean-Pierre Timbaud', 48.8667, 2.37565, NULL, 2.5, 4, 'Happy hour: 18h00 - 21h00', '2014-09-05 22:31:50', '2014-09-05 22:31:50'),
(17, 'La Cordonnerie', '28, rue de Greneta', 48.8652, 2.35071, NULL, 2.9, 4, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:31:50', '2014-09-05 22:31:50'),
(18, 'L''Attirail', '9, rue au Maire', 48.8645, 2.35696, NULL, 3.3, 4, 'Happy hour: 15h30 - 20h00', '2014-09-05 22:31:51', '2014-09-05 22:31:51'),
(19, 'La Chope du Château Rouge', '40, rue de Clignancourt', 48.887, 2.34781, NULL, 3.5, 4, 'Happy hour: 19h00 - 22h00', '2014-09-05 22:31:51', '2014-09-05 22:31:51'),
(20, 'Le Pantalon', '7 rue Royer-Collard', 48.8454, 2.34189, NULL, 3, 5, 'Happy hour: 17h00 - 19h00', '2014-09-05 22:31:51', '2014-09-05 22:31:51'),
(21, 'Hideout Châtelet', '46, rue des Lombards', 48.8598, 2.34842, NULL, 3, 6, 'Happy hour: 15h00 - 22h00', '2014-09-05 22:31:52', '2014-09-05 22:31:52'),
(22, 'Hideout Mouffetard', '11, rue du pot de fer', 48.8429, 2.34847, NULL, 3, 5, 'Happy hour: 15h00 - 22h00', '2014-09-05 22:31:52', '2014-09-05 22:31:52'),
(23, 'Taverne de Nesle', '32, rue Dauphine', 48.8546, 2.3392, NULL, 3, 6, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:31:52', '2014-09-05 22:31:52'),
(24, 'Hideout Gare du Nord', '8, boulevard de Denain', 48.8792, 2.3548, NULL, 3.5, 6.5, 'Happy hour: 18h00 - 23h00', '2014-09-05 22:31:53', '2014-09-05 22:31:53'),
(25, 'Hideout Bastille', '25, rue de Lappe', 48.8537, 2.37294, NULL, 3, 4.5, 'Happy hour: 15h00 - 21h00', '2014-09-05 22:31:53', '2014-09-05 22:31:53'),
(26, 'Le Motel', '8, passage Josset', 48.8527, 2.37641, NULL, 3.5, 0, 'Happy hour: 18h00 - 21h00', '2014-09-05 22:31:53', '2014-09-05 22:31:53'),
(27, 'Le Klein', '36, Rue du roi Sicile', 48.8564, 2.358, NULL, 3.5, 5.5, 'Happy hour: 17h00 - 22h00', '2014-09-05 22:31:53', '2014-09-05 22:31:53'),
(28, 'Le Cristal', '163, avenue de Suffren', 48.8458, 2.30993, NULL, 2.6, 4.4, 'Happy hour: 19h00 - 21h00', '2014-09-05 22:31:54', '2014-09-05 22:31:54'),
(29, 'Le Sémaphore', '32, rue de Londres', 48.8777, 2.32786, NULL, 4, 5, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:31:54', '2014-09-05 22:31:54'),
(30, 'Le Beho', '8, place Saint Opportune', 48.8596, 2.34733, NULL, 3.8, 7, 'Happy hour: 15h00 - 23h00', '2014-09-05 22:31:54', '2014-09-05 22:31:54'),
(31, 'Tribal Café', '3, passage des Petites écuries', 48.8731, 2.3521, NULL, 3, 4, 'Happy hour: 14h00 - 21h00', '2014-09-05 22:31:54', '2014-09-05 22:31:54'),
(32, '25 Degrés Est', '10, place de la bataille de Stalingrad', 48.8833, 2.3693, NULL, 3.5, 6, 'Happy hour: 15h00 - 20h00', '2014-09-05 22:31:55', '2014-09-05 22:31:55'),
(33, 'Wake Up Paris', '31, boulevard Henri IV', 48.8523, 2.36537, NULL, 4, 0, 'Happy hour: 18h00 - 20h00', '2014-09-05 22:31:55', '2014-09-05 22:31:55'),
(34, 'Banana Café', '13, rue de la Ferronerie', 48.8602, 2.34754, NULL, 3, 0, 'Happy hour: 18h00 - 23h00', '2014-09-05 22:31:55', '2014-09-05 22:31:55'),
(35, 'Café Daguerre', '4, avenue du Général Leclerc', 48.8333, 2.33147, NULL, 4.4, 0, 'Happy hour: 16h00 - 21h00', '2014-09-05 22:31:55', '2014-09-05 22:31:55'),
(36, 'Les Prolongations', '76, boulevard de Grenelle', 48.8501, 2.2936, NULL, 4.2, 5, 'Happy hour: 17h30 - 19h30', '2014-09-05 22:31:56', '2014-09-05 22:31:56'),
(37, 'Le Comptoir', '354bis, rue de Vaugirard', 48.8357, 2.29301, NULL, 3.5, 5, 'Happy hour: 17h00 - 19h00', '2014-09-05 22:31:56', '2014-09-05 22:31:56'),
(38, 'Aux Edelweiss', '85, avenue Gambetta', 48.8657, 2.39879, NULL, 4, 5.8, 'Happy hour: 18h30 - 21h00', '2014-09-05 22:31:56', '2014-09-05 22:31:56'),
(39, 'Le Fontenoy', '20, rue Eugène Sue', 48.8912, 2.34724, NULL, 3.5, 3.5, 'Happy hour: h - h', '2014-09-05 22:31:56', '2014-09-05 22:31:56'),
(40, 'Au Rêve', '89, rue de Coulaincourt', 48.8898, 2.33777, NULL, 4, 0, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:31:57', '2014-09-05 22:31:57'),
(41, 'La Popote du 18', '184, rue Marcadet', 48.8917, 2.33645, NULL, 3.5, 0, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:31:57', '2014-09-05 22:31:57'),
(42, 'Le village Michel', '100, rue Ordener', 48.8932, 2.34174, NULL, 3.5, 4.4, 'Happy hour: 16h00 - 21h00', '2014-09-05 22:31:57', '2014-09-05 22:31:57'),
(43, 'Gentleman', '3, rue Hautefeuille', 48.8525, 2.34315, NULL, 4, 5, 'Happy hour: 12h00 - 22h00', '2014-09-05 22:31:57', '2014-09-05 22:31:57'),
(44, 'B.B.O. Bar', '19, rue François Miron', 48.8557, 2.35716, NULL, 4, 7, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:31:57', '2014-09-05 22:31:57'),
(45, 'Mad Maker Pub', '22, rue Cujas', 48.8482, 2.34181, NULL, 4, 6, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:31:58', '2014-09-05 22:31:58'),
(46, 'Le Onzebar', '83, rue Jean-Pierre Timbaud', 48.8682, 2.37802, NULL, 4, 5, 'Happy hour: 17h30 - 20h30', '2014-09-05 22:31:58', '2014-09-05 22:31:58'),
(47, 'Fubar', '5, rue Saint Sulpice', 48.8515, 2.33791, NULL, 3.5, 0, 'Happy hour: 12h00 - 22h00', '2014-09-05 22:31:58', '2014-09-05 22:31:58'),
(48, 'La Bodega', '12, rue Descartes', 48.847, 2.34861, NULL, 3, 0, 'Happy hour: 17h00 - 22h00', '2014-09-05 22:31:58', '2014-09-05 22:31:58'),
(49, 'Val Café', '39, boulevard du Port Royal', 48.8372, 2.34492, NULL, 3.5, 0, 'Happy hour: 15h00 - 22h00', '2014-09-05 22:31:59', '2014-09-05 22:31:59'),
(50, 'Le Mayflower', '49, rue Descartes', 48.8452, 2.34931, NULL, 3.5, 0, 'Happy hour: 16h00 - 21h00', '2014-09-05 22:31:59', '2014-09-05 22:31:59'),
(51, 'The Fifth Bar', '62, rue Mouffetard', 48.843, 2.3494, NULL, 4, 0, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:31:59', '2014-09-05 22:31:59'),
(52, 'Le Frenchy', '81, boulevard de Strasbourg', 48.8755, 2.35763, NULL, 3.5, 0, 'Happy hour: 19h00 - 22h00', '2014-09-05 22:31:59', '2014-09-05 22:31:59'),
(53, 'La Fût Gueuze', '24, rue Duméril', 48.8363, 2.35821, NULL, 3, 0, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:32:00', '2014-09-05 22:32:00'),
(54, 'Le Polly Maggoo', '5, rue du Petit Pont', 48.8526, 2.34668, NULL, 5, 7, 'Happy hour: 16h00 - 22h00', '2014-09-05 22:32:00', '2014-09-05 22:32:00'),
(55, 'Le Basile', '34, rue de Grenelle', 48.8568, 2.3036, NULL, 3.5, 5, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:32:00', '2014-09-05 22:32:00'),
(56, 'Le Bistrot des Artistes', '6, rue des anglais', 48.8509, 2.34773, NULL, 3, 5, 'Happy hour: 19h00 - 21h00', '2014-09-05 22:32:00', '2014-09-05 22:32:00'),
(57, 'Le Pub Saint Hilaire', '2, rue Valette', 48.8481, 2.34683, NULL, 4, 0, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:32:01', '2014-09-05 22:32:01'),
(58, 'Le Berimbar', '131, rue Obekampf', 48.8664, 2.38008, NULL, 3.5, 0, 'Happy hour: 18h00 - 20h30', '2014-09-05 22:32:01', '2014-09-05 22:32:01'),
(59, 'Le Wagon Bleu', '7, rue Boursault', 48.883, 2.32065, NULL, 4.8, 0, 'Happy hour: 18h00 - 21h00', '2014-09-05 22:32:01', '2014-09-05 22:32:01'),
(60, 'Le Cap Rouge', '23, rue Mouffetard', 48.8442, 2.34952, NULL, 3, 0, 'Happy hour: 16h00 - 23h00', '2014-09-05 22:32:01', '2014-09-05 22:32:01'),
(61, 'Violon Dingue', '40, rue de la Montagne Sainte-Geneviève', 48.8478, 2.34845, NULL, 3, 0, 'Happy hour: 19h00 - 22h00', '2014-09-05 22:32:01', '2014-09-05 22:32:01'),
(62, 'Hideout Beaubourg', '173, rue Saint Martin', 48.8626, 2.35184, NULL, 3.5, 4.5, 'Happy hour: 15h00 - 21h00', '2014-09-05 22:32:02', '2014-09-05 22:32:02'),
(63, 'O''Kleins', '117bis, boulevard Poniatowski', 48.8354, 2.40584, NULL, 3.5, 0, 'Happy hour: 17h30 - 20h00', '2014-09-05 22:32:02', '2014-09-05 22:32:02'),
(64, 'Le Truskel', '12, rue Feydeau', 48.8701, 2.3413, NULL, 3.5, 4.5, 'Happy hour: 20h00 - 23h00', '2014-09-05 22:32:02', '2014-09-05 22:32:02'),
(65, 'Le Gobe', '16, rue de Bagnolet', 48.8567, 2.39586, NULL, 3.5, 0, 'Happy hour: 18h00 - 20h00', '2014-09-05 22:32:03', '2014-09-05 22:32:03'),
(66, 'Aux Folies', '8, rue de Belleville paris', 48.8722, 2.3779, NULL, 4, 4, 'Happy hour: h - h', '2014-09-05 22:32:03', '2014-09-05 22:32:03'),
(67, 'Zig-Zag (Garibaldi)', '58, boulevard Garibaldi', 48.8461, 2.30695, NULL, 4.2, 5.7, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:32:03', '2014-09-05 22:32:03'),
(68, 'L''eau peine bar', '26, rue Lappe', 48.8534, 2.37332, NULL, 3.5, 0, 'Happy hour: 18h00 - 22h00', '2014-09-05 22:32:03', '2014-09-05 22:32:03'),
(69, 'Le Château d''Eau', '68, rue du Faubourg Saint-Denis', 48.8727, 2.3544, NULL, 4, 4, 'Happy hour: h - h', '2014-09-05 22:32:04', '2014-09-05 22:32:04'),
(70, 'Café Salé', '66, rue de Clichy', 48.882, 2.32831, NULL, 4, 0, 'Happy hour: 16h00 - 20h00', '2014-09-05 22:32:04', '2014-09-05 22:32:04'),
(71, 'Le Barilleur', '173, rue Saint-Jacques', 48.8456, 2.34281, NULL, 3.9, 3.9, 'Happy hour: h - h', '2014-09-05 22:32:04', '2014-09-05 22:32:04'),
(72, 'Le Bistrot de la Banque', '15 rue Rougemont', 48.8721, 2.346, NULL, 4, 0, 'Happy hour: 15h00 - 22h00', '2014-09-05 22:32:04', '2014-09-05 22:32:04'),
(73, 'Au Bon Accueil', '64, rue Alexandre Dumas', 48.8538, 2.39501, NULL, 4, 0, 'Happy hour: 17h00 - 02h00', '2014-09-05 22:32:05', '2014-09-05 22:32:05'),
(74, 'Le Bloody Mary', '41, rue Amelot', 48.8573, 2.3688, NULL, 3, 5, 'Happy hour: 19h00 - 22h00', '2014-09-05 22:32:05', '2014-09-05 22:32:05'),
(75, 'Le Bastide', '18 rue de Lappe', 48.8537, 2.37216, NULL, 3.5, 5, 'Happy hour: 18h00 - 22h00', '2014-09-05 22:32:05', '2014-09-05 22:32:05'),
(76, '3 Ducks Hotel', '6, place Etienne Pernet paris', 48.8435, 2.29244, NULL, 4.3, 4.3, 'Happy hour: h - h', '2014-09-05 22:32:06', '2014-09-05 22:32:06'),
(77, 'Le Sully', '13 Faubourg Saint-Denis', 48.8703, 2.35277, NULL, 4, 4, 'Happy hour: h - h', '2014-09-05 22:32:06', '2014-09-05 22:32:06'),
(78, 'Biere Academy', '7, rue des Ecoles', 48.8476, 2.35208, NULL, 3, 4.5, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:32:06', '2014-09-05 22:32:06'),
(79, 'L''hôtel de Clermont', '18, rue Veron', 48.8847, 2.33648, NULL, 4, 5, 'Happy hour: 17h00 - 22h00', '2014-09-05 22:32:06', '2014-09-05 22:32:06'),
(80, 'La Petite Taverne', '3, rue de la Huchette', 48.8528, 2.34641, NULL, 3.5, 4.8, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:32:07', '2014-09-05 22:32:07'),
(81, 'Chez Karole', '34, rue Boulard', 48.8334, 2.32843, NULL, 4, 4, 'Happy hour: h - h', '2014-09-05 22:32:07', '2014-09-05 22:32:07'),
(82, 'Le Bistrot de l''Horloge', '7, rue Bernard de Clairevaux', 48.8623, 2.35252, NULL, 4, 0, 'Happy hour: 17h00 - 00h00', '2014-09-05 22:32:07', '2014-09-05 22:32:07'),
(83, 'Père et Fils', '86, rue Montmartre', 48.8668, 2.34432, NULL, 4, 0, 'Happy hour: 18h00 - 21h00', '2014-09-05 22:32:08', '2014-09-05 22:32:08'),
(84, 'La Vache au Comptoir', '13 rue d''Odessa', 48.8423, 2.32465, NULL, 5, 0, 'Happy hour: 16h00 - 20h00', '2014-09-05 22:32:08', '2014-09-05 22:32:08'),
(85, 'Les Volontaires', '227 rue Vaugirard', 48.8414, 2.30822, NULL, 3.6, 0, 'Happy hour: 18h00 - 20h00', '2014-09-05 22:32:08', '2014-09-05 22:32:08'),
(86, 'Galway', '13 quai des Grands Augustins', 48.8539, 2.34353, NULL, 3.5, 5, 'Happy hour: 16h00 - 19h30', '2014-09-05 22:32:08', '2014-09-05 22:32:08'),
(87, 'Aux Marsouins', '50 boulevard de Port Royal', 48.8376, 2.34659, NULL, 3.5, 0, 'Happy hour: 16h00 - 00h00', '2014-09-05 22:32:09', '2014-09-05 22:32:09'),
(88, 'O''Malley', '6 bis, rue 4 Septembre', 48.8692, 2.33907, NULL, 3.9, 0, 'Happy hour: 18h00 - 21h00', '2014-09-05 22:32:09', '2014-09-05 22:32:09'),
(89, 'The Local', '54, rue de la clef', 48.8434, 2.35289, NULL, 3.5, 0, 'Happy hour: 14h00 - 21h00', '2014-09-05 22:32:09', '2014-09-05 22:32:09'),
(90, 'The Mazet', '61, rue Saint Andre des Art', 48.8536, 2.33875, NULL, 4, 0, 'Happy hour: 18h00 - 21h00', '2014-09-05 22:32:09', '2014-09-05 22:32:09'),
(91, 'River Bar', '40, Rue Descartes', 48.8457, 2.34899, NULL, 3, 5, 'Happy hour: 16h00 - 22h00', '2014-09-05 22:32:09', '2014-09-05 22:32:09'),
(92, 'Le Petit Batignolles', '36, rue des Batignolles', 48.8854, 2.32028, NULL, 4.9, 4.9, 'Happy hour: h - h', '2014-09-05 22:32:10', '2014-09-05 22:32:10'),
(93, 'Pergo Café', '69, rue Pergolèse', 48.8728, 2.28043, NULL, 5, 7, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:32:10', '2014-09-05 22:32:10'),
(94, 'L''Entracte Café', '7, rue Biot', 48.8841, 2.32631, NULL, 3.6, 3.6, 'Happy hour: h - h', '2014-09-05 22:32:10', '2014-09-05 22:32:10'),
(95, 'Archi-Bar', '13bis, rue Campagne Première', 48.8399, 2.33279, NULL, 3.8, 6, 'Happy hour: 18h00 - 20h00', '2014-09-05 22:32:10', '2014-09-05 22:32:10'),
(96, 'Le Toucan', '226, rue de Vaugirard', 48.8409, 2.30477, NULL, 4, 7, 'Happy hour: 18h00 - 20h30', '2014-09-05 22:32:11', '2014-09-05 22:32:11'),
(97, 'Le Toucan Café', '10, avenue de la République', 48.8665, 2.36661, NULL, 5, 0, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:32:11', '2014-09-05 22:32:11'),
(98, 'Dogstar', '122, rue La Boétie', 48.8713, 2.30641, NULL, 4.45, 7.9, 'Happy hour: 16h00 - 20h00', '2014-09-05 22:32:11', '2014-09-05 22:32:11'),
(99, 'Sogoosto', '129, boulevard Diderot', 48.8482, 2.39242, NULL, 3.5, 0, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:32:11', '2014-09-05 22:32:11'),
(100, 'Antirouille Bar', '5, rue Moret', 48.8667, 2.37976, NULL, 3.5, 0, 'Happy hour: 18h00 - 02h00', '2014-09-05 22:32:11', '2014-09-05 22:32:11'),
(101, 'Zig-Zag (Sorbonne)', '32, Rue des Carmes', 48.8483, 2.34694, NULL, 4.2, 5.5, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:32:12', '2014-09-05 22:32:12'),
(102, 'Sunset Boulevard', '26, boulevard Poissonnière', 48.8715, 2.34466, NULL, 4, 4, 'Happy hour: h - h', '2014-09-05 22:32:12', '2014-09-05 22:32:12'),
(103, 'Café Le Triomphe', '8, avenue de la Grande Armée', 48.8749, 2.29274, NULL, 5, 7.5, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:32:12', '2014-09-05 22:32:12'),
(104, 'L''Atelier Club', '173bis, rue Saint Martin', 48.8626, 2.35184, NULL, 3.5, 0, 'Happy hour: 10h00 - 21h00', '2014-09-05 22:32:13', '2014-09-05 22:32:13'),
(105, 'Zéro zéro Sèvres', '46, rue de Sèvres', 48.8484, 2.32052, NULL, 3.9, 0, 'Happy hour: 17h00 - 20h30', '2014-09-05 22:32:13', '2014-09-05 22:32:13'),
(106, 'Aux Petits Joueurs', '59, rue de Mouzaia', 48.8806, 2.39619, NULL, 5, 0, 'Happy hour: 18h00 - 02h00', '2014-09-05 22:32:13', '2014-09-05 22:32:13'),
(107, 'Le Block', '33bis, rue des Lombards', 48.8597, 2.34807, NULL, 2.9, 2.9, 'Happy hour: 18h00 - 00h00', '2014-09-05 22:32:14', '2014-09-05 22:32:14'),
(108, 'Jeanne & Marcelle', '18, rue francoeur', 48.8907, 2.34124, NULL, 3, 5, 'Happy hour: 16h00 - 19h30', '2014-09-05 22:32:14', '2014-09-05 22:32:14'),
(109, 'La Folie en Tête', '33, rue de la Butte aux Cailles', 48.8274, 2.34801, NULL, 3, 5, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:32:14', '2014-09-05 22:32:14'),
(110, 'Sputnik', '14, rue de la Butte aux Cailles', 48.8279, 2.35123, NULL, 4.5, 8, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:32:14', '2014-09-05 22:32:14'),
(111, 'Le Diamant', '56 Rue Des Cinq Diamants', 48.8278, 2.34938, NULL, 4, 0, 'Happy hour: 18h00 - 20h00', '2014-09-05 22:32:14', '2014-09-05 22:32:14'),
(112, 'Le Bateau Ivre', '40bis, rue Descartes', 48.8457, 2.34899, NULL, 3, 5, 'Happy hour: 10h00 - 21h30', '2014-09-05 22:32:15', '2014-09-05 22:32:15'),
(113, 'Au P''tit Douai', '38, rue de Douai', 48.8828, 2.33233, NULL, 4.5, 0, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:32:15', '2014-09-05 22:32:15'),
(114, 'Le Hide', '10, rue du Général Lanrezac', 48.8763, 2.29409, NULL, 5, 5, 'Happy hour: h - h', '2014-09-05 22:32:15', '2014-09-05 22:32:15'),
(115, 'Le Breguet', '72, rue Falguière', 48.8405, 2.31261, NULL, 3.5, 4.5, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:32:15', '2014-09-05 22:32:15'),
(116, 'Le Bel-Air', '6 Rue Germain Pilon', 48.8832, 2.33655, NULL, 3, 5, 'Happy hour: 18h00 - 22h00', '2014-09-05 22:32:16', '2014-09-05 22:32:16'),
(117, 'L''Assignat', '7, Rue Guénégaud', 48.8562, 2.3396, NULL, 4, 4, 'Happy hour: h - h', '2014-09-05 22:32:16', '2014-09-05 22:32:16'),
(118, 'Lucernaire', '53 rue Notre-Dame des Champs pqris', 48.8443, 2.33052, NULL, 4, 0, 'Happy hour: 18h00 - 21h00', '2014-09-05 22:32:16', '2014-09-05 22:32:16'),
(119, 'Le Bistro 1', '4 rue de l''Ecole de Médecine', 48.8506, 2.34212, NULL, 4.5, 4.5, 'Happy hour: h - h', '2014-09-05 22:32:16', '2014-09-05 22:32:16'),
(120, 'Les Caractères', '25, rue des Grands Augustins', 48.8538, 2.34053, NULL, 3, 5, 'Happy hour: 18h00 - 20h00', '2014-09-05 22:32:17', '2014-09-05 22:32:17'),
(121, 'The Bootlagers', '73, quai Panhard et Levassor', 48.831, 2.38132, NULL, 3.5, 5, 'Happy hour: 16h00 - 20h00', '2014-09-05 22:32:17', '2014-09-05 22:32:17'),
(122, 'Café Lacombe', '55 rue des Acacias', 48.8783, 2.29385, NULL, 4, 8, 'Happy hour: 18h00 - 21h00', '2014-09-05 22:32:18', '2014-09-05 22:32:18'),
(123, 'Pop In', '105 Rue Amelot', 48.8614, 2.36748, NULL, 3, 5, 'Happy hour: 18h30 - 21h00', '2014-09-05 22:32:18', '2014-09-05 22:32:18'),
(124, 'Cottage Elysee', '14, Rue Lincoln', 48.8706, 2.30321, NULL, 5, 8, 'Happy hour: 17h30 - 20h00', '2014-09-05 22:32:18', '2014-09-05 22:32:18'),
(125, 'La Piscine', '33 rue Boinod', 48.8942, 2.35138, NULL, 3, 5, 'Happy hour: 18h00 - 22h00', '2014-09-05 22:32:19', '2014-09-05 22:32:19'),
(126, '9B', '68 Boulevard de la Villette', 48.8754, 2.37366, NULL, 3.5, 5, 'Happy hour: 18h00 - 21h00', '2014-09-05 22:32:19', '2014-09-05 22:32:19'),
(127, 'Le Chouff''Bar', '16, rue du Pot De Fer', 48.8431, 2.34863, NULL, 4, 6, 'Happy hour: 16h00 - 22h00', '2014-09-05 22:32:20', '2014-09-05 22:32:20'),
(128, 'Le Duc', '9, rue Victor Cousin', 48.8477, 2.3424, NULL, 4, 4, 'Happy hour: h - h', '2014-09-05 22:32:20', '2014-09-05 22:32:20'),
(129, 'Stand''art Café', '102, Bd de Ménilmontant', 48.8653, 2.38525, NULL, 3.5, 5, 'Happy hour: 17h00 - 22h00', '2014-09-05 22:32:20', '2014-09-05 22:32:20'),
(130, 'Panic Room', '101, rue Amelot', 48.8612, 2.36762, NULL, 4, 5, 'Happy hour: 18h30 - 20h30', '2014-09-05 22:32:21', '2014-09-05 22:32:21'),
(131, '2 Bis', '2 bis rue des écoles', 48.8475, 2.3527, NULL, 3, 3, 'Happy hour: h - h', '2014-09-05 22:32:21', '2014-09-05 22:32:21'),
(132, 'le 96', '96 Boulevard de Charonne', 48.8537, 2.3973, NULL, 4, 4, 'Happy hour: h - h', '2014-09-05 22:32:21', '2014-09-05 22:32:21'),
(133, 'L''Adada', '15 rue du Maine', 48.8405, 2.32239, NULL, 4, 5, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:32:21', '2014-09-05 22:32:21'),
(134, 'Bull''s Brothers', '27 rue de la huchette', 48.853, 2.34506, NULL, 4, 8, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:32:21', '2014-09-05 22:32:21'),
(135, 'Les caves populaires', '22 Rue des Dame', 48.8456, 2.32788, NULL, 2.9, 5.2, 'Happy hour: 15h00 - 18h00', '2014-09-05 22:32:22', '2014-09-05 22:32:22'),
(136, 'O''neil', '20, rue des Canettes', 48.8518, 2.33367, NULL, 3.9, 5.2, 'Happy hour: 18h00 - 20h00', '2014-09-05 22:32:22', '2014-09-05 22:32:22'),
(137, 'Bar''Ock', '18 rue Daval', 48.8544, 2.37083, NULL, 3.5, 0, 'Happy hour: 17h00 - 23h00', '2014-09-05 22:32:22', '2014-09-05 22:32:22'),
(138, 'The Pledge', '19, rue des Deux Ponts', 48.8517, 2.35643, NULL, 4, 7, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:32:22', '2014-09-05 22:32:22'),
(139, 'L''Univers', '11 rue d''Enghien', 48.8716, 2.35226, NULL, 2.5, 0, 'Happy hour: 22h00 - 01h00', '2014-09-05 22:32:23', '2014-09-05 22:32:23'),
(140, 'Le Supercoin', '3 rue Baudelique', 48.8922, 2.34702, NULL, 3.5, 4, 'Happy hour: 18h00 - 21h00', '2014-09-05 22:32:23', '2014-09-05 22:32:23'),
(141, 'Nul Bar Ailleurs', '18, rue de Cotte', 48.8499, 2.37817, NULL, 3, 5, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:32:23', '2014-09-05 22:32:23'),
(142, 'La Laverie', '1, rue Sorbier', 48.8687, 2.38987, NULL, 4, 4, 'Happy hour: h - h', '2014-09-05 22:32:23', '2014-09-05 22:32:23'),
(143, 'Café Pierre', '202, rue du Faubourg Saint Antoine', 48.8499, 2.38521, NULL, 3.7, 5.9, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:32:23', '2014-09-05 22:32:23'),
(144, 'Houblon du Vin Tième', '75 avenue Gambetta', 48.8651, 2.39692, NULL, 3.3, 3.3, 'Happy hour: h - h', '2014-09-05 22:32:24', '2014-09-05 22:32:24'),
(145, 'Frog XVI', '110, Avenue Kléber', 48.8649, 2.28822, NULL, 5, 7, 'Happy hour: 17h30 - 20h00', '2014-09-05 22:32:24', '2014-09-05 22:32:24'),
(146, 'Eugène', '23, rue Eugène Carrière', 48.8904, 2.33296, NULL, 4, 5, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:32:24', '2014-09-05 22:32:24'),
(147, 'Hélice Bar', '50, rue d''Orsel', 48.8836, 2.34134, NULL, 4, 4, 'Happy hour: h - h', '2014-09-05 22:32:24', '2014-09-05 22:32:24'),
(148, 'Le Must', '63 rue de la Jonquière', 48.8942, 2.3204, NULL, 4, 4, 'Happy hour: h - h', '2014-09-05 22:32:24', '2014-09-05 22:32:24'),
(149, 'Quai Ouest', '1, rue Alexandre Parodi', 48.8793, 2.36645, NULL, 3.5, 4.5, 'Happy hour: 18h30 - 22h30', '2014-09-05 22:32:25', '2014-09-05 22:32:25'),
(150, 'Le Baltard', '11, rue Saint Denis', 48.8593, 2.34752, NULL, 4, 5, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:32:25', '2014-09-05 22:32:25'),
(151, 'Le Petit Chatelet', '9, rue Saint Denis', 48.8592, 2.34753, NULL, 3.5, 5, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:32:25', '2014-09-05 22:32:25'),
(152, 'Le Petit Chatelet', '9, rue Saint Denis', 48.8592, 2.34753, NULL, 3.5, 5, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:32:25', '2014-09-05 22:32:25'),
(153, 'La Légende', '100, rue Legendre', 48.8877, 2.32038, NULL, 3.5, 4.5, 'Happy hour: 18h00 - 20h45', '2014-09-05 22:32:26', '2014-09-05 22:32:26'),
(154, 'Pères Populaires', '46, rue de Buzenval', 48.8512, 2.40182, NULL, 5.2, 5.2, 'Happy hour: h - h', '2014-09-05 22:32:26', '2014-09-05 22:32:26'),
(155, 'Le Metropolitain', '83, boulevard de Grenelle', 48.8503, 2.29514, NULL, 5, 0, 'Happy hour: 16h00 - 20h00', '2014-09-05 22:32:26', '2014-09-05 22:32:26'),
(156, 'Multiplex', '7, rue de la Tour d''Auvergne', 48.8789, 2.34476, NULL, 3, 3, 'Happy hour: h - h', '2014-09-05 22:32:26', '2014-09-05 22:32:26'),
(157, 'O''Connells Parmentier', '88ter, avenue Parmentier', 48.8656, 2.37476, NULL, 3.5, 5.5, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:32:27', '2014-09-05 22:32:27'),
(158, 'Little O''Connells Oberkampf', '115, rue Oberkampf', 48.8659, 2.37851, NULL, 3.5, 5, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:32:27', '2014-09-05 22:32:27'),
(159, 'O''Connells Oberkampf', '98, rue Oberkampf', 48.8657, 2.37812, NULL, 3.5, 5, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:32:27', '2014-09-05 22:32:27'),
(160, 'Teddy''s Bar', '3, rue Thouin', 48.845, 2.34931, NULL, 3.5, 5, 'Happy hour: 16h00 - 20h00', '2014-09-05 22:32:27', '2014-09-05 22:32:27'),
(161, 'Le Troquet', '36, rue de Clignancourt', 48.8866, 2.34777, NULL, 3.5, 4.5, 'Happy hour: 18h00 - 22h00', '2014-09-05 22:32:27', '2014-09-05 22:32:27'),
(162, 'Le Sans Gêne', '112, rue Legendre', 48.8881, 2.32107, NULL, 3, 7, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:32:28', '2014-09-05 22:32:28'),
(163, 'Bureau des ferrailleurs', '18, rue de Lappe', 48.8537, 2.37216, NULL, 4, 6, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:32:28', '2014-09-05 22:32:28'),
(164, 'Indiana café (Sébastopol)', '58, bd Sébastopol', 48.8632, 2.35115, NULL, 4.4, 0, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:32:28', '2014-09-05 22:32:28'),
(165, 'Les Blouses Blanches', '186, rue du Faubourg Saint Antoine', 48.8501, 2.38312, NULL, 3.7, 5, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:32:28', '2014-09-05 22:32:28'),
(166, 'Chapi Chapo', '50, rue Descartes', 48.8452, 2.34892, NULL, 4, 0, 'Happy hour: 16h00 - 21h00', '2014-09-05 22:32:29', '2014-09-05 22:32:29'),
(167, 'La Maison du vin', '52, rue des Plantes', 48.8288, 2.32192, NULL, 3, 3, 'Happy hour: h - h', '2014-09-05 22:32:29', '2014-09-05 22:32:29'),
(168, 'La Taverne du Croissant', '146, rue Montmartre', 48.8693, 2.34322, NULL, 2.9, 0, 'Happy hour: 18h00 - 23h45', '2014-09-05 22:32:29', '2014-09-05 22:32:29'),
(169, 'Les Pirates', '88, rue Oberkampf', 48.8654, 2.37673, NULL, 3, 5, 'Happy hour: 18h00 - 20h00', '2014-09-05 22:32:29', '2014-09-05 22:32:29'),
(170, 'Le Cavern', '21, rue Dauphine', 48.8552, 2.33985, NULL, 3, 0, 'Happy hour: 17h30 - 20h30', '2014-09-05 22:32:30', '2014-09-05 22:32:30'),
(171, 'Quartier Général', '101, rue Oberkampf', 48.8656, 2.37689, NULL, 3, 0, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:32:30', '2014-09-05 22:32:30'),
(172, 'Café du Mont Cenis', '62, rue Custine', 48.8899, 2.34323, NULL, 3.5, 6, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:32:30', '2014-09-05 22:32:30'),
(173, 'Royal Custine', '36, rue Custine', 48.889, 2.34626, NULL, 4, 0, 'Happy hour: 16h00 - 22h00', '2014-09-05 22:32:30', '2014-09-05 22:32:30'),
(174, 'Le Renouveau', '63, rue des Vinaigriers', 48.8733, 2.35837, NULL, 3.8, 0, 'Happy hour: 16h00 - 22h00', '2014-09-05 22:32:30', '2014-09-05 22:32:30'),
(175, 'La Grosse Caisse', '160, rue Montmatre', 48.8701, 2.34273, NULL, 4, 0, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:32:31', '2014-09-05 22:32:31'),
(176, 'L''Engrenage', '8, rue Etienne Marcel', 48.8637, 2.35027, NULL, 4, 0, 'Happy hour: 16h00 - 21h00', '2014-09-05 22:32:31', '2014-09-05 22:32:31'),
(177, 'The Labo', '37, rue des Lombards', 48.8598, 2.34777, NULL, 3, 0, 'Happy hour: 17h00 - 23h00', '2014-09-05 22:32:31', '2014-09-05 22:32:31'),
(178, 'Café Louis', '154, av de Versailles', 48.8408, 2.26453, NULL, 5, 0, 'Happy hour: 16h00 - 20h00', '2014-09-05 22:32:31', '2014-09-05 22:32:31'),
(179, 'Le Corridor', '30, rue Saint-Sauveur', 48.8664, 2.34762, NULL, 3.5, 7, 'Happy hour: 18h00 - 20h30', '2014-09-05 22:32:31', '2014-09-05 22:32:31'),
(180, 'La Tireuse', '18, rue Laplace', 48.8475, 2.34719, NULL, 4, 5, 'Happy hour: 18h00 - 23h00', '2014-09-05 22:32:32', '2014-09-05 22:32:32'),
(181, 'L''Age d''Or', '26, rue du docteur Magna', 48.8264, 2.35989, NULL, 4, 6, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:32:32', '2014-09-05 22:32:32'),
(182, 'Token 138', '138 rue Montmartre', 48.8686, 2.34366, NULL, 3, 0, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:32:32', '2014-09-05 22:32:32'),
(183, 'O P''ti Paris', '8 cours des petites écuries', 48.8524, 2.33928, NULL, 2.9, 0, 'Happy hour: 15h00 - 20h00', '2014-09-05 22:32:32', '2014-09-05 22:32:32'),
(184, '1979', '49 Rue Berger', 48.8623, 2.34207, NULL, 2.9, 0, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:32:33', '2014-09-05 22:32:33'),
(185, 'Barklays', '48 avenue de Saint Ouen', 48.8904, 2.32684, NULL, 2.9, 0, 'Happy hour: 18h00 - 21h00', '2014-09-05 22:32:33', '2014-09-05 22:32:33'),
(186, 'Au Chat Noir', '76 rue Jean Pierre Timbaud', 48.8673, 2.37613, NULL, 3, 0, 'Happy hour: 18h00 - 21h00', '2014-09-05 22:32:33', '2014-09-05 22:32:33'),
(187, 'Café Fusain', '50 Avenue Parmentier', 48.8622, 2.37714, NULL, 3, 0, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:32:33', '2014-09-05 22:32:33'),
(188, 'L''Objectif Lune', '19 rue de la Roquette', 48.8546, 2.37182, NULL, 3, 0, 'Happy hour: 18h00 - 22h00', '2014-09-05 22:32:33', '2014-09-05 22:32:33'),
(189, 'La Belette Qui Tête', '17 boulevard Arago', 48.836, 2.34999, NULL, 3, 0, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:32:34', '2014-09-05 22:32:34'),
(190, 'La Gamine', '100 rue Damrémont', 48.8933, 2.3362, NULL, 3.6, 0, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:32:34', '2014-09-05 22:32:34'),
(191, 'La Serena', '92 rue de Richelieu', 48.8703, 2.33973, NULL, 3, 0, 'Happy hour: 18h00 - 21h00', '2014-09-05 22:32:34', '2014-09-05 22:32:34'),
(192, 'La Taverne de la Butte', '13 rue de la Butte aux Cailles', 48.8276, 2.35011, NULL, 3, 0, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:32:34', '2014-09-05 22:32:34'),
(193, 'Le Bistro 77', '77 Rue Claude Bernard', 48.841, 2.34334, NULL, 3, 0, 'Happy hour: 16h00 - 21h00', '2014-09-05 22:32:35', '2014-09-05 22:32:35'),
(194, 'Le Diapason', '17 rue de la Butte aux Cailles', 48.8276, 2.34986, NULL, 3, 0, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:32:35', '2014-09-05 22:32:35'),
(195, 'Le Merle Moqueur', '11 rue de la Butte aux Cailles', 48.8277, 2.35041, NULL, 3, 0, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:32:35', '2014-09-05 22:32:35'),
(196, 'Le Paradis', '10 rue Belhomme', 48.8844, 2.34869, NULL, 3, 0, 'Happy hour: 18h00 - 21h00', '2014-09-05 22:32:35', '2014-09-05 22:32:35'),
(197, 'Le Petit Garage', '63 rue Jean Pierre Timbaud', 48.8672, 2.37523, NULL, 3, 0, 'Happy hour: 18h00 - 21h00', '2014-09-05 22:32:35', '2014-09-05 22:32:35'),
(198, 'Le Violon Dingue', '46 Rue Montagne Sainte', 48.8476, 2.34847, NULL, 3, 0, 'Happy hour: 19h00 - 22h00', '2014-09-05 22:32:36', '2014-09-05 22:32:36'),
(199, 'Marlusse et Lapin', '14 rue Germain Pilon', 48.8837, 2.33676, NULL, 3.5, 0, 'Happy hour: h - h', '2014-09-05 22:32:36', '2014-09-05 22:32:36'),
(200, 'Melocoton', '10 rue Descartes', 48.8471, 2.34866, NULL, 3, 0, 'Happy hour: 17h00 - 22h00', '2014-09-05 22:32:36', '2014-09-05 22:32:36'),
(201, 'Melrose Avenue', '142 rue Oberkampf', 48.8662, 2.38087, NULL, 3, 0, 'Happy hour: 16h00 - 21h00', '2014-09-05 22:32:36', '2014-09-05 22:32:36'),
(202, 'Nun''s Café', '112 Rue Saint Maur', 48.8668, 2.37645, NULL, 3, 0, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:32:36', '2014-09-05 22:32:36'),
(203, 'Pub O''Malley', '6 bis rue du 4 septembre', 48.8692, 2.33907, NULL, 3, 0, 'Happy hour: 18h00 - 21h00', '2014-09-05 22:32:37', '2014-09-05 22:32:37'),
(204, 'Station Service', '117 rue St Maur', 48.8656, 2.37752, NULL, 3, 0, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:32:37', '2014-09-05 22:32:37'),
(205, 'The Hideout', '25 rue de Lappe', 48.8537, 2.37294, NULL, 3, 0, 'Happy hour: 15h00 - 21h00', '2014-09-05 22:32:37', '2014-09-05 22:32:37'),
(206, 'Le Biarritz Café', '139 Boulevard Menilmontant', 48.8667, 2.383, NULL, 3.3, 0, 'Happy hour: 17h00 - 21h30', '2014-09-05 22:32:37', '2014-09-05 22:32:37'),
(207, 'Au Clair de Lune (18)', '1 Rue Ramey', 48.887, 2.34748, NULL, 3.5, 0, 'Happy hour: 18h00 - 22h00', '2014-09-05 22:32:38', '2014-09-05 22:32:38'),
(208, 'Au Val de Loire', '176 rue Saint Maur', 48.8705, 2.37316, NULL, 3.5, 0, 'Happy hour: 18h00 - 21h00', '2014-09-05 22:32:38', '2014-09-05 22:32:38'),
(209, 'Bastille Bar', '14 rue de la Roquette', 48.8536, 2.37089, NULL, 3.5, 0, 'Happy hour: 18h00 - 22h00', '2014-09-05 22:32:38', '2014-09-05 22:32:38'),
(210, 'Café de la Poste', '1 rue Ordener', 48.8902, 2.35949, NULL, 3.5, 0, 'Happy hour: 17h00 - 23h00', '2014-09-05 22:32:38', '2014-09-05 22:32:38'),
(211, 'Chez Pierrot', '33 rue de Lappe', 48.8535, 2.37326, NULL, 3.5, 0, 'Happy hour: 18h00 - 22h00', '2014-09-05 22:32:39', '2014-09-05 22:32:39'),
(212, 'Ethnika Rhumerie', '127 Rue Saint Maur', 48.8669, 2.37597, NULL, 3.5, 0, 'Happy hour: 17h00 - 23h00', '2014-09-05 22:32:39', '2014-09-05 22:32:39'),
(213, 'Fréquence café', '56 rue Notre Dame de Lorette', 48.88, 2.33599, NULL, 3.5, 0, 'Happy hour: 17h00 - 00h00', '2014-09-05 22:32:39', '2014-09-05 22:32:39'),
(214, 'Houla Oups', '4 rue Basfroi', 48.8539, 2.38037, NULL, 3.5, 0, 'Happy hour: 18h00 - 20h00', '2014-09-05 22:32:39', '2014-09-05 22:32:39'),
(215, 'Indian Connection', '35 rue de Lappe', 48.8535, 2.37338, NULL, 3.5, 0, 'Happy hour: 16h00 - 22h30', '2014-09-05 22:32:40', '2014-09-05 22:32:40'),
(216, 'A la Bonne Cave', '11 rue de l''espérance', 48.8271, 2.34877, NULL, 3.5, 0, 'Happy hour: 18h00 - 21h00', '2014-09-05 22:32:40', '2014-09-05 22:32:40'),
(217, 'Jolis Momes', '92 Rue de Charonne', 48.8538, 2.38199, NULL, 3.5, 0, 'Happy hour: 16h00 - 20h00', '2014-09-05 22:32:40', '2014-09-05 22:32:40'),
(218, 'L''Assassin', '99 rue Jean Pierre Timbaud', 48.8687, 2.37996, NULL, 3.5, 0, 'Happy hour: 18h00 - 21h00', '2014-09-05 22:32:40', '2014-09-05 22:32:40'),
(219, 'L''eau Peine Bar', '26 rue de Lappe', 48.8534, 2.37332, NULL, 3.5, 0, 'Happy hour: 18h00 - 21h00', '2014-09-05 22:32:40', '2014-09-05 22:32:40'),
(220, 'L''Espérance', '9 rue de l''espérance', 48.8272, 2.34877, NULL, 3.5, 0, 'Happy hour: 18h00 - 21h00', '2014-09-05 22:32:41', '2014-09-05 22:32:41'),
(221, 'L''or en Bar', '28 rue de Lappe', 48.8531, 2.37338, NULL, 3.5, 0, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:32:41', '2014-09-05 22:32:41'),
(222, 'La Ferme', '5 rue des Petites 퉣uries', 48.8566, 2.35222, NULL, 3.5, 0, 'Happy hour: 16h00 - 20h00', '2014-09-05 22:32:41', '2014-09-05 22:32:41'),
(223, 'La Goutière', '96 avenue Parmentier', 48.8661, 2.37415, NULL, 3.5, 6, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:32:41', '2014-09-05 22:32:41'),
(224, 'La P''tite Mercerie', '115 rue Oberkampf', 48.8659, 2.37851, NULL, 3.5, 0, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:32:42', '2014-09-05 22:32:42'),
(225, 'Le Banco', '3 rue des Trois Bornes', 48.8663, 2.3714, NULL, 3.5, 0, 'Happy hour: 17h00 - 22h00', '2014-09-05 22:32:42', '2014-09-05 22:32:42'),
(226, 'Le Bercail', '144 rue Oberkampf', 48.8663, 2.38108, NULL, 3.5, 0, 'Happy hour: 17h00 - 22h00', '2014-09-05 22:32:42', '2014-09-05 22:32:42'),
(227, 'Le Biscornu', '89 rue Montmartre', 48.8677, 2.34371, NULL, 3.5, 0, 'Happy hour: 18h00 - 22h00', '2014-09-05 22:32:42', '2014-09-05 22:32:42'),
(228, 'Le Carrefour', '92 rue Oberkampf', 48.8655, 2.37713, NULL, 3.5, 0, 'Happy hour: 16h00 - 20h00', '2014-09-05 22:32:42', '2014-09-05 22:32:42'),
(229, 'Le Delly''s', '188 boulevard de la Vilette', 48.8817, 2.37058, NULL, 3.5, 0, 'Happy hour: 16h30 - 22h00', '2014-09-05 22:32:43', '2014-09-05 22:32:43'),
(230, 'Le Mo''Town Bar', '116 boulevard de Ménilmontant', 48.8655, 2.38458, NULL, 3.5, 0, 'Happy hour: 17h00 - 22h00', '2014-09-05 22:32:43', '2014-09-05 22:32:43'),
(231, 'Le Prado', '12 rue du Faubourg St Denis', 48.8703, 2.35301, NULL, 4, 0, 'Happy hour: h - h', '2014-09-05 22:32:43', '2014-09-05 22:32:43'),
(232, 'Le Siam', '12 Boulevard Sébastopol', 48.8595, 2.34876, NULL, 3.5, 0, 'Happy hour: 16h00 - 20h00', '2014-09-05 22:32:44', '2014-09-05 22:32:44'),
(233, 'Le Sun', '14 Boulevard Sebastopol', 48.8596, 2.34906, NULL, 3.5, 0, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:32:44', '2014-09-05 22:32:44'),
(234, 'Le Village de la Butte', '23 rue de la Butte aux Cailles', 48.8275, 2.34955, NULL, 3.5, 0, 'Happy hour: 17h00 - 20h30', '2014-09-05 22:32:44', '2014-09-05 22:32:44'),
(235, 'Le Zorba', '137 rue du Faubourg du Temple', 48.8721, 2.3763, NULL, 3.5, 0, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:32:44', '2014-09-05 22:32:44'),
(236, 'Lou Cantou', '19 rue de Lappe', 48.8539, 2.37259, NULL, 3.5, 4.5, 'Happy hour: 19h00 - 21h00', '2014-09-05 22:32:45', '2014-09-05 22:32:45'),
(237, 'Opus Parmentier', '151 avenue Parmentier', 48.8713, 2.36977, NULL, 3.5, 0, 'Happy hour: 17h00 - 22h00', '2014-09-05 22:32:45', '2014-09-05 22:32:45'),
(238, 'Restaurant Oriental', '66 rue Botzaris', 48.8793, 2.38594, NULL, 3.5, 0, 'Happy hour: 08h00 - 00h00', '2014-09-05 22:32:45', '2014-09-05 22:32:45'),
(239, 'Some Girls', '43 rue de Lappe', 48.8533, 2.37379, NULL, 3.5, 5, 'Happy hour: 18h00 - 22h00', '2014-09-05 22:32:46', '2014-09-05 22:32:46'),
(240, 'U.F.O', '51 rue Jean Pierre Timbaud', 48.8669, 2.37392, NULL, 3.5, 0, 'Happy hour: 18h00 - 20h00', '2014-09-05 22:32:46', '2014-09-05 22:32:46'),
(241, 'Café du Commerce', '13 rue de Clignancourt', 48.8848, 2.34686, NULL, 3.6, 0, 'Happy hour: 18h00 - 22h00', '2014-09-05 22:32:46', '2014-09-05 22:32:46'),
(242, 'Charbon', '109 rue Oberkampf', 48.8658, 2.37762, NULL, 3.6, 0, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:32:46', '2014-09-05 22:32:46'),
(243, 'Café Menilmontant', '143 Boulevard Menilmontant', 48.8668, 2.38272, NULL, 2.5, 6.6, 'Happy hour: 17h00 - 21h30', '2014-09-05 22:32:47', '2014-09-05 22:32:47'),
(244, 'Au Fond du Bar', '15 rue Simart', 48.8906, 2.34818, NULL, 3.8, 0, 'Happy hour: 17h00 - 20h30', '2014-09-05 22:32:47', '2014-09-05 22:32:47'),
(245, 'Café Mont Cenis', '42 rue du Mont Cenis', 48.89, 2.34331, NULL, 3.8, 0, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:32:47', '2014-09-05 22:32:47'),
(246, 'Café Victor', '58 rue Custine', 48.8898, 2.3437, NULL, 3.8, 0, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:32:47', '2014-09-05 22:32:47'),
(247, 'Gossip Café', '14 rue des Lombards', 48.8593, 2.34969, NULL, 3.8, 0, 'Happy hour: 17h00 - 22h00', '2014-09-05 22:32:48', '2014-09-05 22:32:48'),
(248, 'La Grille', '4 Place d''Aligre', 48.8487, 2.37787, NULL, 3.8, 0, 'Happy hour: 18h00 - 22h00', '2014-09-05 22:32:48', '2014-09-05 22:32:48'),
(249, 'Quetzal', '10 rue de la Verrerie', 48.8573, 2.35516, NULL, 3.8, 0, 'Happy hour: 17h00 - 23h00', '2014-09-05 22:32:48', '2014-09-05 22:32:48'),
(250, 'Charonne Café', '25 rue de Charonne', 48.8534, 2.37502, NULL, 3.9, 0, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:32:49', '2014-09-05 22:32:49'),
(251, 'O''Berzinc', '145 rue Oberkampf', 48.8668, 2.38116, NULL, 3.9, 0, 'Happy hour: 16h00 - 20h00', '2014-09-05 22:32:49', '2014-09-05 22:32:49'),
(252, 'Art Bistro', '56 bis Rue de Clichy', 48.8776, 2.30887, NULL, 4, 0, 'Happy hour: 16h00 - 22h00', '2014-09-05 22:32:49', '2014-09-05 22:32:49'),
(253, 'Art Café', '37 rue de Lappe', 48.8534, 2.37345, NULL, 4, 0, 'Happy hour: 18h00 - 22h00', '2014-09-05 22:32:50', '2014-09-05 22:32:50'),
(254, 'Au Carrefour', '99 rue Ordener', 48.892, 2.34659, NULL, 4, 0, 'Happy hour: 17h00 - 22h00', '2014-09-05 22:32:50', '2014-09-05 22:32:50'),
(255, 'Au Coin de la Rue', '34 rue de Bourgogne', 48.8576, 2.3175, NULL, 4, 7, 'Happy hour: 18h00 - 21h00', '2014-09-05 22:32:50', '2014-09-05 22:32:50'),
(256, 'Baloo Bar', '13 rue du Petit Pont', 48.8524, 2.3466, NULL, 4, 0, 'Happy hour: 17h00 - 22h00', '2014-09-05 22:32:51', '2014-09-05 22:32:51'),
(257, 'Bambolina Caffé', '13 rue Rougemont', 48.8721, 2.34568, NULL, 4, 0, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:32:51', '2014-09-05 22:32:51'),
(258, 'Bar des Familles', '21 rue de Lappe', 48.8538, 2.37264, NULL, 4, 0, 'Happy hour: 18h00 - 02h00', '2014-09-05 22:32:51', '2014-09-05 22:32:51'),
(259, 'Café Aventura', '21 rue Saint Lazare', 48.8767, 2.33686, NULL, 4, 0, 'Happy hour: 18h00 - 20h00', '2014-09-05 22:32:51', '2014-09-05 22:32:51'),
(260, 'Café Félix', '136 avenue Félix Faure', 48.8377, 2.27987, NULL, 4, 0, 'Happy hour: 16h00 - 20h00', '2014-09-05 22:32:52', '2014-09-05 22:32:52'),
(261, 'Chez Michel', '15 rue de la Butte aux Cailles', 48.8276, 2.34996, NULL, 4, 0, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:32:52', '2014-09-05 22:32:52'),
(262, 'Dock', '25 rue Louis Legrand', 48.8704, 2.33397, NULL, 4, 0, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:32:52', '2014-09-05 22:32:52'),
(263, 'El Tonel Bar', '5 Rue des Pyramides', 48.8644, 2.33232, NULL, 5, 0, 'Happy hour: 18h00 - 20h00', '2014-09-05 22:32:52', '2014-09-05 22:32:52'),
(264, 'En attendant l''or', '6 rue Faidherbes', 48.8566, 2.35222, NULL, 4, 0, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:32:53', '2014-09-05 22:32:53'),
(265, 'Feria Café', '43 rue du Roi de Sicile', 48.8568, 2.35597, NULL, 4, 0, 'Happy hour: 18h00 - 20h00', '2014-09-05 22:32:53', '2014-09-05 22:32:53'),
(266, 'Fifth Bar', '62 Rue Mouffetard', 48.843, 2.3494, NULL, 4, 0, 'Happy hour: 16h00 - 22h00', '2014-09-05 22:32:53', '2014-09-05 22:32:53'),
(267, 'Folie''s Café', '74 rue de la Folie Mericourt', 48.8656, 2.3708, NULL, 4, 0, 'Happy hour: 16h00 - 20h00', '2014-09-05 22:32:53', '2014-09-05 22:32:53'),
(268, 'Georges Café', '4 rue de La Huchette', 48.8529, 2.34632, NULL, 4, 0, 'Happy hour: 16h00 - 21h00', '2014-09-05 22:32:53', '2014-09-05 22:32:53'),
(269, 'Havane Café', '70 bis Bld Auguste Blanqui', 48.8303, 2.34769, NULL, 4, 0, 'Happy hour: 16h00 - 20h00', '2014-09-05 22:32:54', '2014-09-05 22:32:54'),
(270, 'Inside Bar', '14 Rue Claude Tillier', 48.8481, 2.38807, NULL, 4, 0, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:32:54', '2014-09-05 22:32:54'),
(271, 'L''Accoudoir', '25 rue La Bruyère', 48.8793, 2.33478, NULL, 4, 0, 'Happy hour: 18h00 - 20h00', '2014-09-05 22:32:54', '2014-09-05 22:32:54'),
(272, 'L''Aveyronnais', '120 rue du Faubourg St Martin', 48.8742, 2.35868, NULL, 4, 0, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:32:54', '2014-09-05 22:32:54'),
(273, 'L''Entrepot''s', '2 rue Sorbier', 48.8686, 2.38955, NULL, 4, 0, 'Happy hour: 16h00 - 19h00', '2014-09-05 22:32:55', '2014-09-05 22:32:55'),
(274, 'L''Orée des champs', '35 avenue des Ternes', 48.8785, 2.29403, NULL, 4, 0, 'Happy hour: 18h00 - 21h00', '2014-09-05 22:32:55', '2014-09-05 22:32:55'),
(275, 'La Bande a Bon''eau', '63 rue des Cloys', 48.8935, 2.33653, NULL, 4, 0, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:32:55', '2014-09-05 22:32:55'),
(276, 'La Belle Vie St Martin', '121 rue du Faubourg St Martin', 48.875, 2.35891, NULL, 4, 0, 'Happy hour: 18h00 - 21h00', '2014-09-05 22:32:55', '2014-09-05 22:32:55'),
(277, 'La Chose d''Enghien', '54 rue d''Enghien', 48.8725, 2.34817, NULL, 4, 0, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:32:55', '2014-09-05 22:32:55'),
(278, 'La Forge', '63 Bd Vaugirard', 48.8404, 2.31606, NULL, 4, 0, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:32:56', '2014-09-05 22:32:56'),
(279, 'La Marmite', '66 rue du Faubourg Poissonière', 48.876, 2.34835, NULL, 4, 0, 'Happy hour: 18h00 - 21h00', '2014-09-05 22:32:56', '2014-09-05 22:32:56'),
(280, 'La Marquise', '74 rue Jean Pierre Timbaud', 48.8672, 2.37574, NULL, 4, 0, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:32:56', '2014-09-05 22:32:56'),
(281, 'La Note Bleue', '99 rue Ménilmontant', 48.8692, 2.39104, NULL, 4, 0, 'Happy hour: 17h30 - 22h00', '2014-09-05 22:32:57', '2014-09-05 22:32:57'),
(282, 'La Souris Verte', '190 rue marcadet', 48.8916, 2.33616, NULL, 4, 0, 'Happy hour: 17h00 - 21h30', '2014-09-05 22:32:57', '2014-09-05 22:32:57'),
(283, 'La Tour de Nesle', '114 Rue de Sèvres', 48.8456, 2.31198, NULL, 4, 0, 'Happy hour: 19h00 - 21h00', '2014-09-05 22:32:57', '2014-09-05 22:32:57'),
(284, 'Latin Corner', '12 Rue de La Huchette', 48.853, 2.34611, NULL, 4, 0, 'Happy hour: 16h00 - 21h00', '2014-09-05 22:32:57', '2014-09-05 22:32:57'),
(285, 'Le Bistrot de la Huchette', '27 rue de la Huchette', 48.853, 2.34506, NULL, 4, 0, 'Happy hour: 15h00 - 21h00', '2014-09-05 22:32:58', '2014-09-05 22:32:58'),
(286, 'Le Bretagne', '66 rue Ordener', 48.8922, 2.34684, NULL, 4, 0, 'Happy hour: 16h00 - 00h00', '2014-09-05 22:32:58', '2014-09-05 22:32:58'),
(287, 'Le Bric a Brac', '108 rue Oberkampf', 48.8658, 2.37893, NULL, 4, 0, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:32:58', '2014-09-05 22:32:58'),
(288, 'Le Buron', '119 avenue Felix Faure', 48.8382, 2.28155, NULL, 4, 0, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:32:58', '2014-09-05 22:32:58'),
(289, 'Le Ca. Rillon Bistrot', '18 rue Alibert', 48.8716, 2.36778, NULL, 4, 0, 'Happy hour: 18h00 - 20h00', '2014-09-05 22:32:59', '2014-09-05 22:32:59'),
(290, 'Le Café des Sports', '94 rue Ménilmontant', 48.8691, 2.39212, NULL, 4, 0, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:32:59', '2014-09-05 22:32:59'),
(291, 'Le Conservatoire', '10 avenue Jean Jaurès', 48.8829, 2.37129, NULL, 4, 0, 'Happy hour: 16h00 - 20h00', '2014-09-05 22:32:59', '2014-09-05 22:32:59'),
(292, 'Le Gustoso', '55 Rue Réaumur', 48.8663, 2.35168, NULL, 4, 0, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:32:59', '2014-09-05 22:32:59'),
(293, 'Le Jaures Café', '1 av Jean Jaures', 48.9012, 2.38923, NULL, 4, 0, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:33:00', '2014-09-05 22:33:00'),
(294, 'Le N''importe Quoi', '16 Rue du Roule', 48.8608, 2.34392, NULL, 4, 8, 'Happy hour: 18h00 - 20h00', '2014-09-05 22:33:00', '2014-09-05 22:33:00'),
(295, 'Le Petit Léon', '88 rue Mouffetard', 48.8419, 2.34969, NULL, 4, 0, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:33:00', '2014-09-05 22:33:00'),
(296, 'Le Play Off', '35 Rue Saint Georges', 48.8769, 2.33705, NULL, 4, 0, 'Happy hour: 18h00 - 20h00', '2014-09-05 22:33:01', '2014-09-05 22:33:01'),
(297, 'Le Relais de la Huchette', '16 rue de la Huchette', 48.8531, 2.34583, NULL, 4, 0, 'Happy hour: 13h00 - 21h00', '2014-09-05 22:33:01', '2014-09-05 22:33:01'),
(298, 'Le Rhubarb', '18 Rue Laplace', 48.8475, 2.34719, NULL, 4, 0, 'Happy hour: 19h00 - 22h00', '2014-09-05 22:33:01', '2014-09-05 22:33:01'),
(299, 'Le Sancerre', '2 Boulevard Saint Marcel', 48.84, 2.36143, NULL, 4, 0, 'Happy hour: 16h00 - 20h00', '2014-09-05 22:33:01', '2014-09-05 22:33:01'),
(300, 'Le Sans Chichi', '37 Rue de Maubeuge', 48.8788, 2.34597, NULL, 4, 0, 'Happy hour: 16h00 - 20h00', '2014-09-05 22:33:02', '2014-09-05 22:33:02'),
(301, 'Le Size', '16 rue de Lappe', 48.8539, 2.37213, NULL, 4, 0, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:33:02', '2014-09-05 22:33:02'),
(302, 'Le Soleil', '134 Avenue de Clichy', 48.8907, 2.32025, NULL, 4, 0, 'Happy hour: 17h00 - 22h00', '2014-09-05 22:33:02', '2014-09-05 22:33:02'),
(303, 'Le Taillebourg', '25 Boulevard de Charonne', 48.8504, 2.39837, NULL, 4, 0, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:33:03', '2014-09-05 22:33:03'),
(304, 'Le Vieux Chêne', '69 rue Mouffetard', 48.8423, 2.34981, NULL, 4, 0, 'Happy hour: 16h00 - 21h00', '2014-09-05 22:33:03', '2014-09-05 22:33:03'),
(305, 'Les Anémones', '41 avenue de la République', 48.8654, 2.37489, NULL, 4, 0, 'Happy hour: 16h00 - 22h00', '2014-09-05 22:33:03', '2014-09-05 22:33:03'),
(306, 'Les Rigoles', '6 rue Levert', 48.8735, 2.3903, NULL, 4, 6, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:33:03', '2014-09-05 22:33:03'),
(307, 'My Woodie', '101 rue Oberkampf', 48.8656, 2.37689, NULL, 4, 0, 'Happy hour: 18h00 - 21h00', '2014-09-05 22:33:04', '2014-09-05 22:33:04'),
(308, 'Oberkafé', '131 rue Oberkampf', 48.8664, 2.38008, NULL, 4, 0, 'Happy hour: 18h00 - 22h00', '2014-09-05 22:33:04', '2014-09-05 22:33:04'),
(309, 'Pépito', '130 rue Saint Maur', 48.8681, 2.37569, NULL, 4, 0, 'Happy hour: 18h00 - 20h30', '2014-09-05 22:33:04', '2014-09-05 22:33:04'),
(310, 'Shywawa Pub', '7 rue du Petit Pont', 48.8525, 2.34674, NULL, 4, 0, 'Happy hour: 16h00 - 22h00', '2014-09-05 22:33:04', '2014-09-05 22:33:04'),
(311, 'Tortilla 10', '10 rue Lappe', 48.854, 2.37192, NULL, 4, 0, 'Happy hour: 17h30 - 21h00', '2014-09-05 22:33:04', '2014-09-05 22:33:04'),
(312, 'Ze Bar', '20 rue de la Huchette', 48.8532, 2.34557, NULL, 4, 0, 'Happy hour: 16h00 - 21h00', '2014-09-05 22:33:05', '2014-09-05 22:33:05'),
(313, 'Yellow Mad Monkey', '8 rue de Lappe', 48.854, 2.37178, NULL, 4.2, 0, 'Happy hour: 18h00 - 21h00', '2014-09-05 22:33:05', '2014-09-05 22:33:05'),
(314, 'Peace & Love', '245 rue Lafayette', 48.8823, 2.36874, NULL, 4.3, 0, 'Happy hour: 18h00 - 22h00', '2014-09-05 22:33:05', '2014-09-05 22:33:05'),
(315, 'Indiana (3)', '1 place de la République', 48.8665, 2.36469, NULL, 4.4, 0, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:33:05', '2014-09-05 22:33:05'),
(316, 'Indiana (10)', '42 bd bonne nouvelle', 48.8707, 2.34827, NULL, 4.4, 0, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:33:06', '2014-09-05 22:33:06'),
(317, 'Indiana (14)', '3 avenue du G. Leclerc', 48.8332, 2.33193, NULL, 4.4, 0, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:33:06', '2014-09-05 22:33:06'),
(318, 'Indiana Club', '83 avenue du Maine', 48.8384, 2.32335, NULL, 4.4, 0, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:33:06', '2014-09-05 22:33:06'),
(319, 'Absolut''Café', '10 rue de la Gaé', 48.8405, 2.32396, NULL, 4.5, 0, 'Happy hour: 15h00 - 19h00', '2014-09-05 22:33:07', '2014-09-05 22:33:07'),
(320, 'Au Métro 14', '66 rue Raymond Losserand', 48.834, 2.31814, NULL, 4.5, 7, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:33:07', '2014-09-05 22:33:07'),
(321, 'Café Lilou', '62 boulevard de Port-Royal', 48.8378, 2.3457, NULL, 4.5, 0, 'Happy hour: 16h00 - 20h00', '2014-09-05 22:33:07', '2014-09-05 22:33:07'),
(322, 'Canon de la Nation', '2 place de la Nation', 48.8484, 2.39433, NULL, 5.5, 0, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:33:07', '2014-09-05 22:33:07'),
(323, 'Chez Margot', '25 Boulevard Henri IV', 48.852, 2.36462, NULL, 4.5, 0, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:33:08', '2014-09-05 22:33:08'),
(324, 'Hall''s Beer Tavern', '70 rue St Denis', 48.8616, 2.34934, NULL, 4.5, 0, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:33:08', '2014-09-05 22:33:08'),
(325, 'Kazimir', '115 Rue Saint Maur', 48.8661, 2.37662, NULL, 4.5, 0, 'Happy hour: 17h00 - 20h30', '2014-09-05 22:33:08', '2014-09-05 22:33:08'),
(326, 'La Comète', '19 rue du Faubourg Montmartre', 48.8728, 2.34303, NULL, 4.5, 0, 'Happy hour: 17h30 - 21h00', '2014-09-05 22:33:08', '2014-09-05 22:33:08'),
(327, 'La Malle', '3 rue Rodier', 48.8773, 2.34227, NULL, 4.5, 0, 'Happy hour: 18h00 - 20h00', '2014-09-05 22:33:09', '2014-09-05 22:33:09'),
(328, 'Le Bar Belge', '75 avenue de Saint Ouen', 48.8924, 2.32706, NULL, 4.5, 0, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:33:09', '2014-09-05 22:33:09'),
(329, 'Le Boursault', '62 rue des Dames', 48.8837, 2.32041, NULL, 4.5, 0, 'Happy hour: 16h00 - 20h00', '2014-09-05 22:33:09', '2014-09-05 22:33:09');
INSERT INTO `cheap_bars` (`id`, `name`, `address`, `latitude`, `longitude`, `url`, `price`, `original_price`, `happy_hour`, `created_at`, `updated_at`) VALUES
(330, 'Le Café Charlotte', '4 rue Belgrand', 48.8649, 2.39922, NULL, 4.5, 0, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:33:09', '2014-09-05 22:33:09'),
(331, 'Le Fleurus', '10 boulevard Jourdan', 48.8197, 2.34281, NULL, 4.5, 0, 'Happy hour: 16h00 - 20h00', '2014-09-05 22:33:10', '2014-09-05 22:33:10'),
(332, 'Le Gabin', '25 rue Lambert', 48.889, 2.34493, NULL, 4.5, 0, 'Happy hour: 16h00 - 21h00', '2014-09-05 22:33:10', '2014-09-05 22:33:10'),
(333, 'Le Lakanal', '2 avenue René Coty', 48.8332, 2.33258, NULL, 4.5, 0, 'Happy hour: 16h00 - 21h00', '2014-09-05 22:33:10', '2014-09-05 22:33:10'),
(334, 'Le Melting Pot', '3 Rue de Lagny', 48.8489, 2.39997, NULL, 4.5, 0, 'Happy hour: 18h00 - 21h00', '2014-09-05 22:33:10', '2014-09-05 22:33:10'),
(335, 'Le Monde de Léa', '9 rue de l Olive', 48.891, 2.36124, NULL, 4.5, 0, 'Happy hour: 15h00 - 20h00', '2014-09-05 22:33:10', '2014-09-05 22:33:10'),
(336, 'Le Rempart', '15 rue St Antoine', 48.8534, 2.36655, NULL, 4.5, 0, 'Happy hour: 16h00 - 23h00', '2014-09-05 22:33:11', '2014-09-05 22:33:11'),
(337, 'Le Styx', '126 rue Oberkampf', 48.866, 2.38009, NULL, 4.5, 0, 'Happy hour: 17h30 - 20h30', '2014-09-05 22:33:11', '2014-09-05 22:33:11'),
(338, 'Le Velocipede', '24 rue Turbigo', 48.8643, 2.351, NULL, 4.5, 0, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:33:11', '2014-09-05 22:33:11'),
(339, 'Lol Classe', '74, rue du Faubourg St Denis', 48.8731, 2.3547, NULL, 4.5, 0, 'Happy hour: 15h00 - 22h00', '2014-09-05 22:33:11', '2014-09-05 22:33:11'),
(340, 'Lounge Bar', '37 bd Bonne Nouvelle', 48.8703, 2.34834, NULL, 4.5, 0, 'Happy hour: 17h00 - 22h00', '2014-09-05 22:33:12', '2014-09-05 22:33:12'),
(341, 'Margen''s Pub', '65 Rue Mouffetard', 48.8425, 2.34994, NULL, 4.5, 0, 'Happy hour: 16h00 - 21h00', '2014-09-05 22:33:12', '2014-09-05 22:33:12'),
(342, 'Point Ephémère', '200 Quai de Valmy', 48.8812, 2.36814, NULL, 4.5, 0, 'Happy hour: 15h00 - 19h00', '2014-09-05 22:33:12', '2014-09-05 22:33:12'),
(343, 'Indiana Café', '129 rue du Faubourg St Martin', 48.8757, 2.35895, NULL, 4.8, 0, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:33:13', '2014-09-05 22:33:13'),
(344, 'Le Capitole', '74 rue Réaumur', 48.8662, 2.35252, NULL, 4.8, 0, 'Happy hour: 18h00 - 23h00', '2014-09-05 22:33:13', '2014-09-05 22:33:13'),
(345, 'Dogs Bar', '7 rue de la Cossonerie', 48.8614, 2.34893, NULL, 4.9, 0, 'Happy hour: 15h00 - 22h00', '2014-09-05 22:33:13', '2014-09-05 22:33:13'),
(346, 'La Sidreria', '25 Rue Moret', 48.8674, 2.37886, NULL, 4.9, 0, 'Happy hour: 18h00 - 20h00', '2014-09-05 22:33:14', '2014-09-05 22:33:14'),
(347, 'Le Café Convention', '200 rue convention', 48.8372, 2.29644, NULL, 4.9, 0, 'Happy hour: 18h00 - 20h00', '2014-09-05 22:33:14', '2014-09-05 22:33:14'),
(348, 'Café des Antiquaires', '15 rue de la Grange Batelière', 48.873, 2.34151, NULL, 3.5, 5.4, 'Happy hour: 16h00 - 01h00', '2014-09-05 22:33:14', '2014-09-05 22:33:14'),
(349, 'Métro bar', '236 rue du faubourg saint Martin', 48.8812, 2.36609, NULL, 4, 5, 'Happy hour: 18h00 - 21h00', '2014-09-05 22:33:14', '2014-09-05 22:33:14'),
(350, 'ZS Café', '93, rue duhesme', 48.8948, 2.34441, NULL, 3, 0, 'Happy hour: h - h', '2014-09-05 22:33:15', '2014-09-05 22:33:15'),
(351, 'Le Square', '31 rue Saint Dominique', 48.8589, 2.3203, NULL, 4, 6.5, 'Happy hour: 17h00 - 19h00', '2014-09-05 22:33:15', '2014-09-05 22:33:15'),
(352, 'Le Falguière', '129 rue de Vaugirard', 48.8444, 2.31828, NULL, 4, 0, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:33:15', '2014-09-05 22:33:15'),
(353, 'Kamelo', '19, bvd Edgar Quinet', 48.8412, 2.32385, NULL, 5, 0, 'Happy hour: 16h30 - 20h00', '2014-09-05 22:33:15', '2014-09-05 22:33:15'),
(354, 'Le Certa', '5, rue de l''Isly', 48.8746, 2.32589, NULL, 5, 6, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:33:16', '2014-09-05 22:33:16'),
(355, 'Hurling pub', '8 rue Descartes', 48.847, 2.34849, NULL, 3.5, 5, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:33:16', '2014-09-05 22:33:16'),
(356, 'Le Grand Palais', '21 avenue Franklin Roosevelt', 48.872, 2.22107, NULL, 5, 1, 'Happy hour: 18h00 - 20h00', '2014-09-05 22:33:16', '2014-09-05 22:33:16'),
(357, 'French Beer Factory', '176, rue Montmartre', 48.871, 2.34339, NULL, 3.5, 6.5, 'Happy hour: 15h00 - 17h00', '2014-09-05 22:33:16', '2014-09-05 22:33:16'),
(358, 'Le petit pont', '1 Rue du Petit Pont', 48.8528, 2.34673, NULL, 3.9, 8, 'Happy hour: 17h00 - 21h30', '2014-09-05 22:33:17', '2014-09-05 22:33:17'),
(359, 'Le Dude', '214, rue saint-maur', 48.8733, 2.37072, NULL, 2.5, 4, 'Happy hour: 18h00 - 21h00', '2014-09-05 22:33:17', '2014-09-05 22:33:17'),
(360, 'Chez Raymonde', '104 Blvd Richard Lenoir', 48.8636, 2.37186, NULL, 4, 6, 'Happy hour: 18h00 - 21h00', '2014-09-05 22:33:17', '2014-09-05 22:33:17'),
(361, 'Point Zéro', '9 rue Paul Lelong', 48.8676, 2.34269, NULL, 4, 6, 'Happy hour: 18h00 - 21h00', '2014-09-05 22:33:17', '2014-09-05 22:33:17'),
(362, 'Comptoir Moderne', '26 rue de la Croix Nivert', 48.8468, 2.29953, NULL, 3.9, 5, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:33:18', '2014-09-05 22:33:18'),
(363, 'Floyd''s bar & grill', '11 rue d''Enghein', 48.8716, 2.35226, NULL, 4, 5.5, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:33:18', '2014-09-05 22:33:18'),
(364, 'Chez Papa', '101 rue de la croix nivert', 48.8426, 2.29499, NULL, 5, 8.4, 'Happy hour: 16h00 - 20h00', '2014-09-05 22:33:18', '2014-09-05 22:33:18'),
(365, 'Le carré parisien', '1 rue du Général Beuret', 48.8415, 2.30288, NULL, 4, 6, 'Happy hour: 18h00 - 20h00', '2014-09-05 22:33:18', '2014-09-05 22:33:18'),
(366, 'Jojo', '168 rue Saint-Martin', 48.8623, 2.35206, NULL, 5, 6.5, 'Happy hour: 17h00 - 00h00', '2014-09-05 22:33:19', '2014-09-05 22:33:19'),
(367, 'Le bistrot gourmand', '28 rue guersant', 48.8814, 2.28951, NULL, 3, 5, 'Happy hour: 19h00 - 20h00', '2014-09-05 22:33:19', '2014-09-05 22:33:19'),
(368, 'L''Attirail (Saint-Martin)', '8 Boulevard Saint-Martin', 48.8686, 2.35786, NULL, 3.3, 4, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:33:19', '2014-09-05 22:33:19'),
(369, 'Indiana (Ternes)', '237 rue du faubourg saint honoré', 48.8774, 2.29848, NULL, 4.4, 8.8, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:33:20', '2014-09-05 22:33:20'),
(370, 'Café victoria', '64 rue Pierre Charron', 48.8696, 2.30405, NULL, 4.4, 8, 'Happy hour: 16h00 - 23h00', '2014-09-05 22:33:20', '2014-09-05 22:33:20'),
(371, 'La casserole', '17 rue Boinod', 48.8931, 2.35055, NULL, 5, 5, 'Happy hour: h - h', '2014-09-05 22:33:20', '2014-09-05 22:33:20'),
(372, 'Au Beaujolais', '167 rue faubourg Poissonniere', 48.8814, 2.34952, NULL, 4, 4, 'Happy hour: h - h', '2014-09-05 22:33:21', '2014-09-05 22:33:21'),
(373, 'Les Fontaines', '12 rue Brisemiche', 48.8596, 2.35193, NULL, 4, 4, 'Happy hour: h - h', '2014-09-05 22:33:21', '2014-09-05 22:33:21'),
(374, 'Chez Camille', '8 rue Ravignan', 48.8855, 2.33795, NULL, 5, 5.8, 'Happy hour: 18h00 - 20h00', '2014-09-05 22:33:21', '2014-09-05 22:33:21'),
(375, 'Canibale Café', '93 rue Jean-Pierre Timbaud', 48.8684, 2.37909, NULL, 4, 6, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:33:21', '2014-09-05 22:33:21'),
(376, 'Le Commerce', '8 rue des Martyrs', 48.877, 2.33963, NULL, 3.5, 5, 'Happy hour: 17h00 - 22h00', '2014-09-05 22:33:22', '2014-09-05 22:33:22'),
(377, 'Insomniac', '46 rue Léon frot ', 48.8559, 2.38659, NULL, 3, 3, 'Happy hour: h - h', '2014-09-05 22:33:22', '2014-09-05 22:33:22'),
(378, 'Sur les quais', '37 quai de Valmy', 48.8692, 2.36635, NULL, 5, 5, 'Happy hour: h - h', '2014-09-05 22:33:22', '2014-09-05 22:33:22'),
(379, 'My Baar', '152 bd du Montparnasse', 48.8403, 2.33407, NULL, 3, 5, 'Happy hour: 15h00 - 22h00', '2014-09-05 22:33:22', '2014-09-05 22:33:22'),
(380, 'La Planque', '15 rue Daval paris', 48.8548, 2.37086, NULL, 3.5, 5, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:33:22', '2014-09-05 22:33:22'),
(381, 'Le Génie', '4 bd Beaumarchais', 48.8546, 2.36905, NULL, 3, 6.5, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:33:23', '2014-09-05 22:33:23'),
(382, 'Ma pomme en colimaçon', '107 rue de Ménilmontant', 48.8694, 2.39197, NULL, 5, 5, 'Happy hour: h - h', '2014-09-05 22:33:23', '2014-09-05 22:33:23'),
(383, 'le Festiv´', '51 rue guy moquet', 48.8926, 2.32454, NULL, 4.5, 6, 'Happy hour: 17h00 - 22h00', '2014-09-05 22:33:23', '2014-09-05 22:33:23'),
(384, 'La Taverne Karlsbrau', '1 Boulevard Voltaire', 48.8666, 2.36572, NULL, 5, 9.4, 'Happy hour: 16h00 - 20h00', '2014-09-05 22:33:23', '2014-09-05 22:33:23'),
(385, 'Le Komptoir', '27 rue Quincampoix', 48.8602, 2.35001, NULL, 4.8, 6.5, 'Happy hour: 17h30 - 20h30', '2014-09-05 22:33:24', '2014-09-05 22:33:24'),
(386, 'Le Quid', '12 rue de la truanderie', 48.8629, 2.34912, NULL, 3, 4.5, 'Happy hour: 17h00 - 22h00', '2014-09-05 22:33:24', '2014-09-05 22:33:24'),
(387, 'Le Balto', '15 rue Mazarine', 48.8554, 2.33784, NULL, 5, 5, 'Happy hour: h - h', '2014-09-05 22:33:24', '2014-09-05 22:33:24'),
(388, 'Le p''tit Wagram', '41 avenue de Wagram', 48.8773, 2.29669, NULL, 5, 7, 'Happy hour: 18h00 - 21h00', '2014-09-05 22:33:24', '2014-09-05 22:33:24'),
(389, 'Le Flamme', '6 avenue de Wagram', 48.8753, 2.29642, NULL, 5, 8.5, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:33:25', '2014-09-05 22:33:25'),
(390, 'Petit Bain', '7 port de la gare', 48.8298, 2.38659, NULL, 4, 8, 'Happy hour: 18h00 - 20h00', '2014-09-05 22:33:25', '2014-09-05 22:33:25'),
(391, 'Au bouillon belge', '6 rue Planchat', 48.8519, 2.39935, NULL, 5, 5, 'Happy hour: h - h', '2014-09-05 22:33:25', '2014-09-05 22:33:25'),
(392, 'La Marine', '59 bd du Montparnasse ', 48.8443, 2.32332, NULL, 5, 9, 'Happy hour: 18h00 - 20h00', '2014-09-05 22:33:25', '2014-09-05 22:33:25'),
(393, 'Pub O''Prince', '52 rue monsieur le prince', 48.8484, 2.34051, NULL, 4, 6, 'Happy hour: 18h00 - 21h00', '2014-09-05 22:33:26', '2014-09-05 22:33:26'),
(394, 'Café Clochette', '16 avenue Richerand ', 48.8724, 2.36652, NULL, 5, 5, 'Happy hour: h - h', '2014-09-05 22:33:26', '2014-09-05 22:33:26'),
(395, 'Le Progres', '62 rue Legendre', 48.8854, 2.31664, NULL, 5, 5, 'Happy hour: h - h', '2014-09-05 22:33:26', '2014-09-05 22:33:26'),
(396, 'Café Blanc', '10 rue croix des petits champs', 48.8628, 2.33973, NULL, 5, 6.9, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:33:26', '2014-09-05 22:33:26'),
(397, 'La fusée', '168bis Rue Saint-Martin', 48.8623, 2.35206, NULL, 5, 5, 'Happy hour: h - h', '2014-09-05 22:33:26', '2014-09-05 22:33:26'),
(398, 'Charlie et sa bière à deux balles', '29 rue de Cotte', 48.8502, 2.37797, NULL, 3.5, 4, 'Happy hour: 18h00 - 21h00', '2014-09-05 22:33:27', '2014-09-05 22:33:27'),
(399, 'Pili pili', '70 rue Jean-Pierre Timbaud', 48.8663, 2.3755, NULL, 4, 6, 'Happy hour: 18h00 - 20h00', '2014-09-05 22:33:27', '2014-09-05 22:33:27'),
(400, 'La Pendrie', '17 rue Etienne Marcel', 48.8636, 2.3494, NULL, 5, 0, 'Happy hour: 16h00 - 21h00', '2014-09-05 22:33:27', '2014-09-05 22:33:27'),
(401, 'Le Tout est Bon', '18 Faubourg saint denis', 48.8705, 2.35403, NULL, 3.5, 3.5, 'Happy hour: h - h', '2014-09-05 22:33:28', '2014-09-05 22:33:28'),
(402, 'Chez ta soeur', '128 Rue Oberkampf', 48.866, 2.38018, NULL, 4, 6, 'Happy hour: 17h00 - 22h00', '2014-09-05 22:33:28', '2014-09-05 22:33:28'),
(403, 'Le 45 Tours', '45 Rue de Montreuil', 48.8508, 2.38812, NULL, 3.5, 3.5, 'Happy hour: h - h', '2014-09-05 22:33:28', '2014-09-05 22:33:28'),
(404, 'Le Bo Zinc', '59 avenue Mozart', 48.8545, 2.26961, NULL, 5, 5, 'Happy hour: h - h', '2014-09-05 22:33:28', '2014-09-05 22:33:28'),
(405, 'Le Bar à mines', '64 rue de Charenton', 48.8493, 2.37427, NULL, 3, 5, 'Happy hour: 18h00 - 21h00', '2014-09-05 22:33:29', '2014-09-05 22:33:29'),
(406, 'L''abribus', '56 rue de Bagnolet', 48.8574, 2.39919, NULL, 3, 0, 'Happy hour: 18h00 - 20h00', '2014-09-05 22:33:29', '2014-09-05 22:33:29'),
(407, 'James Hetfeeld''s Pub - Clichy', '118 bd de Clichy', 48.8845, 2.33037, NULL, 4, 4, 'Happy hour: h - h', '2014-09-05 22:33:29', '2014-09-05 22:33:29'),
(408, 'Le Boucan', '108 bd de Clichy', 48.8845, 2.33104, NULL, 5, 6, 'Happy hour: 17h00 - 22h00', '2014-09-05 22:33:30', '2014-09-05 22:33:30'),
(409, 'Le comptoir Parmentier', '6 avenue Parmentier', 48.8591, 2.37997, NULL, 4, 0, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:33:30', '2014-09-05 22:33:30'),
(410, 'Aux Ours', '236, rue des Pyrénées ', 48.8675, 2.39667, NULL, 4, 5, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:33:30', '2014-09-05 22:33:30'),
(411, '3234 café', '32 rue de charonne', 48.8532, 2.37626, NULL, 5.5, 5.5, 'Happy hour: h - h', '2014-09-05 22:33:31', '2014-09-05 22:33:31'),
(412, 'La mère pouchet', '168 boulevard Diderot', 48.8478, 2.39261, NULL, 4, 6, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:33:31', '2014-09-05 22:33:31'),
(413, 'Tavern''Café', '17-18 boulevard Montmartre', 48.8722, 2.34082, NULL, 5, 0, 'Happy hour: 19h00 - 20h00', '2014-09-05 22:33:31', '2014-09-05 22:33:31'),
(414, 'The Cricketer', '41 rue des Mathurins', 48.8732, 2.32408, NULL, 5, 6, 'Happy hour: 15h00 - 19h00', '2014-09-05 22:33:32', '2014-09-05 22:33:32'),
(415, 'Le Valentin', '40 rue de prony', 48.8818, 2.30557, NULL, 5, 0, 'Happy hour: 17h30 - 20h30', '2014-09-05 22:33:32', '2014-09-05 22:33:32'),
(416, 'Le Lock Groove', '15 rue Roger', 48.8353, 2.32668, NULL, 3.5, 6, 'Happy hour: 18h00 - 21h00', '2014-09-05 22:33:32', '2014-09-05 22:33:32'),
(417, 'Le Parc', '358, rue de Vaugirard', 48.8355, 2.29246, NULL, 3.5, 0, 'Happy hour: 16h30 - 21h00', '2014-09-05 22:33:32', '2014-09-05 22:33:32'),
(418, 'O''Connells Ferronerie', '11 rue de la Ferronnerie', 48.8601, 2.34767, NULL, 3.5, 5.5, 'Happy hour: 17h00 - 21h00', '2014-09-05 22:33:33', '2014-09-05 22:33:33'),
(419, 'Le Tibourg', '4 rue du Bourg Tibourg', 48.8568, 2.35588, NULL, 4, 0, 'Happy hour: 16h00 - 20h00', '2014-09-05 22:33:33', '2014-09-05 22:33:33'),
(420, 'Le Moderne', '121 rue du chemin vert', 48.8619, 2.38317, NULL, 6, 6, 'Happy hour: h - h', '2014-09-05 22:33:33', '2014-09-05 22:33:33'),
(421, 'Eden Park Pub', '10 rue princesse', 48.8524, 2.33433, NULL, 5, 7.5, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:33:33', '2014-09-05 22:33:33'),
(422, '20134', '11 rue de la montagne sainte Geneviève', 48.849, 2.34882, NULL, 3.5, 0, 'Happy hour: 17h00 - 21h30', '2014-09-05 22:33:34', '2014-09-05 22:33:34'),
(423, 'Café du marché', '38 rue Cler', 48.8567, 2.3063, NULL, 5, 5, 'Happy hour: h - h', '2014-09-05 22:33:34', '2014-09-05 22:33:34'),
(424, 'The Bottle Shop', '5 rue Trousseau', 48.8512, 2.3784, NULL, 4.8, 5.2, 'Happy hour: 17h00 - 20h00', '2014-09-05 22:33:34', '2014-09-05 22:33:34'),
(425, 'Le Carbone 14', '6 rue \\u00c9mile Lepeu', 48.8566, 2.35222, NULL, 3, 5, 'Happy hour: 17h30 - 20h30', '2014-09-05 22:33:35', '2014-09-05 22:33:35');
-- --------------------------------------------------------
--
-- Table structure for table `flippers`
--
CREATE TABLE IF NOT EXISTS `flippers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=140 ;
--
-- Dumping data for table `flippers`
--
INSERT INTO `flippers` (`id`, `name`) VALUES
(2, '24'),
(3, 'AC/DC'),
(4, 'Acapulco'),
(5, 'Amazon Hunt'),
(6, 'Amazon Hunt II'),
(7, 'Amazon Hunt III'),
(8, 'Attack from Mars'),
(9, 'Austin Powers'),
(10, 'Avatar'),
(11, 'Aztec'),
(12, 'Bad Cats'),
(13, 'Batman'),
(14, 'Big Buck Hunter'),
(15, 'Big Hurt'),
(16, 'Black Rose'),
(17, 'Cactus Canyon'),
(18, 'Cactus Jack’s'),
(19, 'Car Hop'),
(20, 'Cirqus Voltaire'),
(21, 'Class of 1812'),
(22, 'Congo'),
(23, 'Corvette'),
(24, 'Creature Black Lagoon'),
(25, 'CSI'),
(26, 'Cue Ball Wizard'),
(27, 'The Addams Family'),
(28, 'The Avengers'),
(29, 'Demolition Man'),
(30, 'Dirty Harry'),
(31, 'Doctor Who'),
(32, 'Dr Dude'),
(33, 'Dracula'),
(34, 'Eight Ball Deluxe'),
(35, 'Elvira'),
(36, 'Elvis'),
(37, 'Family Guy'),
(38, 'Fish Tales'),
(39, 'Frankenstein'),
(40, 'Funhouse'),
(41, 'Gladiators'),
(42, 'Godzilla'),
(43, 'Grand Prix'),
(44, 'Guns N’ Roses'),
(45, 'Harley Davidson'),
(46, 'High Roller Casino'),
(47, 'Hulk'),
(48, 'Indiana Jones'),
(49, 'Indianapolis 500'),
(50, 'Iron Man'),
(51, 'The Champion Pub'),
(52, 'The Flintstones'),
(53, 'The Getaway: HS II'),
(54, 'Jack Bot'),
(55, 'Johnny Mnemonic'),
(56, 'Jokerz'),
(57, 'Judge Dredd'),
(58, 'Junk Yard'),
(59, 'Jurassic Park'),
(60, 'Last Action Hero'),
(61, 'Lethal Weapon 3'),
(62, 'Lights.Camera.Action!'),
(63, 'Lord of the rings'),
(64, 'Lost in Space'),
(65, 'Mario Andretti'),
(66, 'Medieval Madness'),
(67, 'Metallica'),
(68, 'Monopoly'),
(69, 'Monster Bash'),
(70, 'Monte Carlo'),
(71, 'Mustang'),
(72, 'NBA'),
(73, 'NBA Fast Break'),
(74, 'No Fear'),
(75, 'No Good Gofers'),
(76, 'Panthera'),
(77, 'Paragon'),
(78, 'Pirates des Caraïbes'),
(79, 'Playboy'),
(80, 'Pool Sharks'),
(81, 'Popeye Saves the Earth'),
(82, 'The Party Zone'),
(83, 'Les Sopranos'),
(84, 'Rack ‘Em Up!'),
(85, 'Red & Ted’s Road Show'),
(86, 'Revenge from Mars'),
(87, 'Ripley’s bel. it or not'),
(88, 'Riverboat Gambler'),
(89, 'RollerCoaster Tycoon'),
(90, 'Scared Stiff'),
(91, 'Shaq Attaq'),
(92, 'Sharkey’s Shootout'),
(93, 'Shrek'),
(94, 'Silver Slugger'),
(95, 'South Park'),
(96, 'Space Jam'),
(97, 'Space Mission'),
(98, 'Spiderman'),
(99, 'Star Trek'),
(100, 'Star Wars'),
(101, 'Star Wars Episode I'),
(102, 'Stargate'),
(103, 'Starship Troopers'),
(104, 'Street Fighter II'),
(105, 'Striker Xtreme'),
(106, 'Super Mario Bros'),
(107, 'Surf ‘n Safari'),
(108, 'The Rolling Stones'),
(109, 'The Shadow'),
(110, 'The Simpsons'),
(111, 'Tales of the Arab. Ni.'),
(112, 'Tee’d off'),
(113, 'Terminator 2'),
(114, 'Terminator 3'),
(115, 'Theatre of magic'),
(116, 'Tommy the Who'),
(117, 'Torch'),
(118, 'Totem'),
(119, 'Transformers'),
(120, 'TRON: Legacy'),
(121, 'Twilight Zone'),
(122, 'Waterworld'),
(123, 'Wheel of fortune'),
(124, 'Whirlwind'),
(125, 'White Water'),
(126, 'WHO dunnit'),
(127, 'World Chall. Soccer'),
(128, 'World Cup Soccer'),
(129, 'World Poker Tour'),
(130, 'WWF Royal Rumble'),
(131, 'X-Men'),
(132, 'Terminator 2: Judgment Day '),
(133, 'The Sopranos® '),
(134, 'Tales of the Arabian Nights '),
(135, 'Dr. Dude '),
(136, 'Pirates of the Caribbean '),
(137, 'Transformers™ '),
(138, 'Ripley’s Believe It or Not!® '),
(139, 'Shrek™ ');
-- --------------------------------------------------------
--
-- Table structure for table `locations`
--
CREATE TABLE IF NOT EXISTS `locations` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`flipper_id` int(11) DEFAULT NULL,
`bar_id` int(11) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `locations_ibfk_1` (`flipper_id`),
KEY `locations_ibfk_2` (`bar_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=98 ;
--
-- Dumping data for table `locations`
--
INSERT INTO `locations` (`id`, `flipper_id`, `bar_id`, `created_at`, `updated_at`) VALUES
(1, 13, 34, '2014-08-02 17:34:41', '2014-08-02 17:34:41'),
(2, 67, 35, '2014-08-02 17:34:47', '2014-08-02 17:34:47'),
(3, 50, 36, '2014-08-02 17:34:54', '2014-08-02 17:34:54'),
(4, 13, 37, '2014-08-02 17:35:01', '2014-08-02 17:35:01'),
(5, 99, 38, '2014-08-02 17:35:08', '2014-08-02 17:35:08'),
(6, 71, 39, '2014-08-02 17:35:13', '2014-08-02 17:35:13'),
(7, 8, 40, '2014-08-02 17:35:20', '2014-08-02 17:35:20'),
(8, 71, 41, '2014-08-02 17:35:25', '2014-08-02 17:35:25'),
(9, 66, 42, '2014-08-02 17:35:31', '2014-08-02 17:35:31'),
(10, 133, 43, '2014-08-02 17:35:37', '2014-08-02 17:35:37'),
(11, 8, 44, '2014-08-02 17:35:43', '2014-08-02 17:35:43'),
(12, 69, 45, '2014-08-02 17:35:48', '2014-08-02 17:35:48'),
(13, 66, 46, '2014-08-02 17:36:04', '2014-08-02 17:36:04'),
(14, 134, 47, '2014-08-02 17:36:11', '2014-08-02 17:36:11'),
(15, 27, 48, '2014-08-02 17:36:17', '2014-08-02 17:36:17'),
(16, 119, 49, '2014-08-02 17:36:22', '2014-08-02 17:36:22'),
(17, 66, 50, '2014-08-02 17:36:28', '2014-08-02 17:36:28'),
(18, 86, 51, '2014-08-02 17:36:34', '2014-08-02 17:36:34'),
(19, 86, 52, '2014-08-02 17:36:39', '2014-08-02 17:36:39'),
(20, 69, 53, '2014-08-02 17:36:44', '2014-08-02 17:36:44'),
(21, 27, 54, '2014-08-02 17:36:50', '2014-08-02 17:36:50'),
(22, 58, 54, '2014-08-02 17:36:50', '2014-08-02 17:36:50'),
(23, 69, 55, '2014-08-02 17:36:56', '2014-08-02 17:36:56'),
(24, 69, 56, '2014-08-02 17:37:02', '2014-08-02 17:37:02'),
(25, 28, 57, '2014-08-02 17:37:07', '2014-08-02 17:37:07'),
(26, 69, 58, '2014-08-02 17:37:12', '2014-08-02 17:37:12'),
(27, 3, 59, '2014-08-02 17:37:17', '2014-08-02 17:37:17'),
(28, 115, 60, '2014-08-02 17:37:24', '2014-08-02 17:37:24'),
(29, 69, 61, '2014-08-02 17:37:30', '2014-08-02 17:37:30'),
(30, 69, 62, '2014-08-02 17:37:36', '2014-08-02 17:37:36'),
(31, 67, 62, '2014-08-02 17:37:36', '2014-08-02 17:37:36'),
(32, 37, 63, '2014-08-02 17:44:02', '2014-08-02 17:44:02'),
(33, 69, 64, '2014-08-02 17:44:05', '2014-08-02 17:44:05'),
(34, 69, 65, '2014-08-02 17:44:08', '2014-08-02 17:44:08'),
(35, 97, 66, '2014-08-02 17:44:11', '2014-08-02 17:44:11'),
(36, 90, 67, '2014-08-02 17:44:14', '2014-08-02 17:44:14'),
(37, 69, 67, '2014-08-02 17:44:14', '2014-08-02 17:44:14'),
(38, 115, 67, '2014-08-02 17:44:14', '2014-08-02 17:44:14'),
(39, 80, 68, '2014-08-02 17:44:20', '2014-08-02 17:44:20'),
(40, 27, 68, '2014-08-02 17:44:20', '2014-08-02 17:44:20'),
(41, 135, 68, '2014-08-02 17:44:20', '2014-08-02 17:44:20'),
(42, 44, 68, '2014-08-02 17:44:20', '2014-08-02 17:44:20'),
(43, 132, 69, '2014-08-02 17:44:22', '2014-08-02 17:44:22'),
(44, 69, 69, '2014-08-02 17:44:22', '2014-08-02 17:44:22'),
(45, 69, 70, '2014-08-02 17:44:25', '2014-08-02 17:44:25'),
(46, 8, 71, '2014-08-02 17:44:28', '2014-08-02 17:44:28'),
(47, 8, 72, '2014-08-02 17:44:31', '2014-08-02 17:44:31'),
(48, 69, 72, '2014-08-02 17:44:31', '2014-08-02 17:44:31'),
(49, 13, 73, '2014-08-02 17:44:35', '2014-08-02 17:44:35'),
(50, 69, 74, '2014-08-02 17:44:38', '2014-08-02 17:44:38'),
(51, 66, 75, '2014-08-02 17:44:41', '2014-08-02 17:44:41'),
(52, 69, 76, '2014-08-02 17:44:44', '2014-08-02 17:44:44'),
(53, 8, 77, '2014-08-02 17:44:47', '2014-08-02 17:44:47'),
(54, 69, 78, '2014-08-02 17:44:52', '2014-08-02 17:44:52'),
(55, 69, 79, '2014-08-02 17:44:55', '2014-08-02 17:44:55'),
(56, 69, 80, '2014-08-02 17:44:59', '2014-08-02 17:44:59'),
(57, 125, 81, '2014-08-02 17:45:02', '2014-08-02 17:45:02'),
(58, 69, 82, '2014-08-02 17:45:05', '2014-08-02 17:45:05'),
(59, 8, 83, '2014-08-02 17:45:09', '2014-08-02 17:45:09'),
(60, 13, 84, '2014-08-02 17:45:12', '2014-08-02 17:45:12'),
(61, 69, 85, '2014-08-02 17:45:15', '2014-08-02 17:45:15'),
(62, 90, 86, '2014-08-02 17:45:18', '2014-08-02 17:45:18'),
(63, 8, 87, '2014-08-02 17:45:21', '2014-08-02 17:45:21'),
(64, 69, 88, '2014-08-02 17:45:25', '2014-08-02 17:45:25'),
(65, 17, 89, '2014-08-02 17:45:28', '2014-08-02 17:45:28'),
(66, 66, 90, '2014-08-02 17:45:31', '2014-08-02 17:45:31'),
(67, 69, 91, '2014-08-02 17:45:33', '2014-08-02 17:45:33'),
(68, 8, 92, '2014-08-02 17:45:36', '2014-08-02 17:45:36'),
(69, 69, 93, '2014-08-02 17:45:39', '2014-08-02 17:45:39'),
(70, 66, 94, '2014-08-02 17:45:43', '2014-08-02 17:45:43'),
(71, 66, 95, '2014-08-02 17:45:46', '2014-08-02 17:45:46'),
(72, 27, 96, '2014-08-02 17:45:50', '2014-08-02 17:45:50'),
(73, 8, 97, '2014-08-02 17:45:53', '2014-08-02 17:45:53'),
(74, 3, 98, '2014-08-02 17:45:55', '2014-08-02 17:45:55'),
(75, 66, 99, '2014-08-02 17:45:58', '2014-08-02 17:45:58'),
(76, 28, 100, '2014-08-02 17:46:02', '2014-08-02 17:46:02'),
(77, 69, 101, '2014-08-02 17:46:04', '2014-08-02 17:46:04'),
(78, 136, 102, '2014-08-02 17:46:07', '2014-08-02 17:46:07'),
(79, 66, 103, '2014-08-02 17:46:11', '2014-08-02 17:46:11'),
(80, 67, 104, '2014-08-02 17:46:14', '2014-08-02 17:46:14'),
(81, 8, 105, '2014-08-02 17:46:17', '2014-08-02 17:46:17'),
(82, 69, 105, '2014-08-02 17:46:17', '2014-08-02 17:46:17'),
(83, 69, 106, '2014-08-02 17:46:20', '2014-08-02 17:46:20'),
(84, 69, 107, '2014-08-02 17:46:23', '2014-08-02 17:46:23'),
(85, 137, 108, '2014-08-02 17:46:27', '2014-08-02 17:46:27'),
(86, 138, 109, '2014-08-02 17:46:30', '2014-08-02 17:46:30'),
(87, 139, 110, '2014-08-02 17:56:39', '2014-08-02 17:56:39'),
(88, 133, 111, '2014-08-02 17:56:42', '2014-08-02 17:56:42'),
(89, 69, 112, '2014-08-02 17:56:46', '2014-08-02 17:56:46'),
(90, 63, 113, '2014-08-02 17:56:48', '2014-08-02 17:56:48'),
(91, 69, 114, '2014-08-02 17:56:53', '2014-08-02 17:56:53'),
(92, 69, 115, '2014-08-02 17:56:56', '2014-08-02 17:56:56'),
(93, 67, 116, '2014-08-02 17:56:59', '2014-08-02 17:56:59'),
(94, 138, 117, '2014-08-02 17:57:02', '2014-08-02 17:57:02'),
(95, 69, 118, '2014-08-02 17:57:05', '2014-08-02 17:57:05'),
(96, 67, 119, '2014-08-02 17:57:08', '2014-08-02 17:57:08'),
(97, 69, 120, '2014-08-02 17:57:11', '2014-08-02 17:57:11');
-- --------------------------------------------------------
--
-- Table structure for table `schema_migrations`
--
CREATE TABLE IF NOT EXISTS `schema_migrations` (
`version` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
UNIQUE KEY `unique_schema_migrations` (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `schema_migrations`
--
INSERT INTO `schema_migrations` (`version`) VALUES
('20140802153618'),
('20140802162810'),
('20140802171943'),
('20140905221857');
--
-- Constraints for dumped tables
--
--
-- Constraints for table `locations`
--
ALTER TABLE `locations`
ADD CONSTRAINT `locations_ibfk_2` FOREIGN KEY (`bar_id`) REFERENCES `bars` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `locations_ibfk_1` FOREIGN KEY (`flipper_id`) REFERENCES `flippers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
/*!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 */;