-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathlocalhost (2).sql
371 lines (347 loc) · 22.2 KB
/
localhost (2).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
-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 29, 2011 at 06:59 PM
-- Server version: 5.1.53
-- PHP Version: 5.3.4
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!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: `maps`
--
CREATE DATABASE `maps` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `maps`;
-- --------------------------------------------------------
--
-- Table structure for table `markers`
--
CREATE TABLE IF NOT EXISTS `markers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(60) NOT NULL,
`address` varchar(80) NOT NULL,
`lat` float(10,6) NOT NULL,
`lng` float(10,6) NOT NULL,
`rating` float DEFAULT NULL,
`reference` varchar(211) DEFAULT NULL,
`google_id` varchar(40) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=170 ;
--
-- Dumping data for table `markers`
--
INSERT INTO `markers` (`id`, `name`, `address`, `lat`, `lng`, `rating`, `reference`, `google_id`) VALUES
(1, 'Frankie Johnnie & Luigo Too', '939 W El Camino Real, Mountain View, CA', 37.386337, -122.085823, NULL, NULL, NULL),
(2, 'Amici''s East Coast Pizzeria', '790 Castro St, Mountain View, CA', 37.387138, -122.083237, NULL, NULL, NULL),
(3, 'Kapp''s Pizza Bar & Grill', '191 Castro St, Mountain View, CA', 37.393887, -122.078918, NULL, NULL, NULL),
(4, 'Round Table Pizza: Mountain View', '570 N Shoreline Blvd, Mountain View, CA', 37.402653, -122.079353, NULL, NULL, NULL),
(5, 'Tony & Alba''s Pizza & Pasta', '619 Escuela Ave, Mountain View, CA', 37.394012, -122.095528, NULL, NULL, NULL),
(6, 'Oregano''s Wood-Fired Pizza', '4546 El Camino Real, Los Altos, CA', 37.401726, -122.114647, NULL, NULL, NULL),
(7, 'Round Table Pizza: Sunnyvale-Mary-Central Expy', '415 N Mary Ave, Sunnyvale, CA', 37.390038, -122.042030, NULL, NULL, NULL),
(8, 'Giordano''s', '730 N Rush St, Chicago, IL', 41.895729, -87.625412, NULL, NULL, NULL),
(9, 'Filippi''s Pizza Grotto', '1747 India St, San Diego, CA', 32.723831, -117.168327, NULL, NULL, NULL),
(10, 'Lou Malnati''s Pizzeria', '439 N Wells St, Chicago, IL', 41.890347, -87.633926, NULL, NULL, NULL),
(11, 'Sammy''s Woodfired Pizza', '770 4th Ave, San Diego, CA', 32.713383, -117.161179, NULL, NULL, NULL),
(12, 'Casa Bianca Pizza Pie', '1650 Colorado Blvd, Los Angeles, CA', 34.139160, -118.204605, NULL, NULL, NULL),
(13, 'Parkway Grill', '510 S Arroyo Pkwy, Pasadena, CA', 34.137005, -118.147301, NULL, NULL, NULL),
(14, 'Pizzeria Paradiso', '2029 P St NW, Washington, DC', 38.909649, -77.045898, NULL, NULL, NULL),
(15, 'Star Pizza', '2111 Norfolk St, Houston, TX', 29.732452, -95.411057, NULL, NULL, NULL),
(16, 'Tutta Bella Neapolitan Pizzera', '4918 Rainier Ave S, Seattle, WA', 47.557705, -122.284988, NULL, NULL, NULL),
(17, 'Touche Pasta Pizza Pool', '1425 NW Glisan St, Portland, OR', 45.526466, -122.685577, NULL, NULL, NULL),
(18, 'Piecora''s New York Pizza', '1401 E Madison St, Seattle, WA', 47.614006, -122.313988, NULL, NULL, NULL),
(19, 'Pagliacci Pizza', '550 Queen Anne Ave N, Seattle, WA', 47.623943, -122.356720, NULL, NULL, NULL),
(20, 'Zeeks Pizza - Phinney Ridge', '6000 Phinney Ave N, Seattle, WA', 47.672668, -122.354095, NULL, NULL, NULL),
(21, 'Old Town Pizza', '226 NW Davis St, Portland, OR', 45.524555, -122.672684, NULL, NULL, NULL),
(22, 'Zeeks Pizza - Belltown', '419 Denny Way, Seattle, WA', 47.618313, -122.348000, NULL, NULL, NULL),
(23, 'Escape From New York Pizza', '622 NW 23rd Ave, Portland, OR', 45.527103, -122.698509, NULL, NULL, NULL),
(24, 'Big Fred''s Pizza Garden', '1101 S 119th St, Omaha, NE', 41.248661, -96.098763, NULL, NULL, NULL),
(25, 'Old Chicago', '1111 Harney St, Omaha, NE', 41.256519, -95.930679, NULL, NULL, NULL),
(26, 'Sgt Peffer''s Cafe Italian', '1501 N Saddle Creek Rd, Omaha, NE', 41.273083, -95.987816, NULL, NULL, NULL),
(27, 'Mama''s Pizza', '715 N Saddle Creek Rd, Omaha, NE', 41.265884, -95.980682, NULL, NULL, NULL),
(28, 'Zio''s New York Style Pizzeria', '1213 Howard St, Omaha, NE', 41.255451, -95.932022, NULL, NULL, NULL),
(29, 'Boston''s Restaurant & Sports', '620 E Disk Dr, Rapid City, SD', 44.106937, -103.205223, NULL, NULL, NULL),
(30, 'Zio''s New York Style Pizzeria', '7834 W Dodge Rd, Omaha, NE', 41.263248, -96.056396, NULL, NULL, NULL),
(31, 'La Casa Pizzaria', '4432 Leavenworth St, Omaha, NE', 41.252399, -95.979576, NULL, NULL, NULL),
(32, 'Giordano''s', '730 N Rush St, Chicago, IL', 41.895729, -87.625412, NULL, NULL, NULL),
(33, 'Lou Malnati''s Pizzeria', '439 N Wells St, Chicago, IL', 41.890347, -87.633926, NULL, NULL, NULL),
(34, 'Piece Restaurant', '1927 W North Ave, Chicago, IL', 41.910492, -87.676125, NULL, NULL, NULL),
(35, 'Connie''s Pizza Inc', '2373 S Archer Ave, Chicago, IL', 41.849213, -87.641678, NULL, NULL, NULL),
(36, 'Exchequer Restaurant', '226 S Wabash Ave, Chicago, IL', 41.879189, -87.626076, NULL, NULL, NULL),
(37, 'Coco''s By The Falls', '5339 Murray Street, Niagara Falls, Ontario', 43.083553, -79.082703, NULL, NULL, NULL),
(38, 'Pompei', '1531 W Taylor St, Chicago, IL', 41.869301, -87.664780, NULL, NULL, NULL),
(39, 'Lynn''s Paradise Cafe', '984 Barret Ave, Louisville, KY', 38.236931, -85.728539, NULL, NULL, NULL),
(40, 'Otto Restaurant Enoteca Pizza', '1 5th Ave, New York, NY', 40.732162, -73.996323, NULL, NULL, NULL),
(41, 'Grimaldi''s', '19 Old Fulton St, Brooklyn, NY', 40.702515, -73.993736, NULL, NULL, NULL),
(42, 'Lombardi''s', '32 Spring St, New York, NY', 40.721676, -73.995598, NULL, NULL, NULL),
(43, 'John''s Pizzeria', '278 Bleecker St, New York, NY', 40.731705, -74.003273, NULL, NULL, NULL),
(44, 'John''s Pizzeria', '260 W 44th St, New York, NY', 40.758072, -73.987740, NULL, NULL, NULL),
(45, 'Burger Joint', '2175 Broadway, New York, NY', 40.782398, -73.981003, NULL, NULL, NULL),
(46, 'Frank Pepe Pizzeria Napoletana', '157 Wooster St, New Haven, CT', 41.302803, -72.917046, NULL, NULL, NULL),
(47, 'Adrianne''s Pizza Bar', '54 Stone St, New York, NY', 40.704479, -74.010139, NULL, NULL, NULL),
(48, 'Pizzeria Regina: Regina Pizza', '11 1/2 Thacher St, Boston, MA', 42.365337, -71.056831, NULL, NULL, NULL),
(49, 'Upper Crust', '20 Charles St, Boston, MA', 42.356606, -71.069679, NULL, NULL, NULL),
(50, 'Bertucci''s Brick Oven Rstrnt', '4 Brookline Pl, Brookline, MA', 42.331917, -71.115311, NULL, NULL, NULL),
(51, 'Aquitaine', '569 Tremont St, Boston, MA', 42.343636, -71.072266, NULL, NULL, NULL),
(52, 'Bertucci''s Brick Oven Rstrnt', '43 Stanhope St, Boston, MA', 42.348297, -71.073250, NULL, NULL, NULL),
(53, 'Upper Crust', '286 Harvard St, Brookline, MA', 42.342857, -71.122314, NULL, NULL, NULL),
(54, 'Bertucci''s Brick Oven Rstrnt', '799 Main St, Cambridge, MA', 42.363258, -71.097214, NULL, NULL, NULL),
(55, 'Bertucci''s Brick Oven Rstrnt', '22 Merchants Row, Boston, MA', 42.359146, -71.055473, NULL, NULL, NULL),
(56, 'Vinnie Van Go-Go''s', '317 W Bryan St, Savannah, GA', 32.081154, -81.094994, NULL, NULL, NULL),
(57, 'Domino''s Pizza: Myrtle Beach', '1706 S Kings Hwy # A, Myrtle Beach, SC', 33.674881, -78.905144, NULL, NULL, NULL),
(58, 'East of Chicago Pizza Company', '3901 North Kings Highway Suite 1, Myrtle Beach, SC', 33.716099, -78.855583, NULL, NULL, NULL),
(59, 'Villa Tronco Italian Rstrnt', '1213 Blanding St, Columbia, SC', 34.008049, -81.036316, NULL, NULL, NULL),
(60, 'Mellow Mushroom Pizza Bakers', '11 W Liberty St, Savannah, GA', 32.074673, -81.093697, NULL, NULL, NULL),
(61, 'Andolinis Pizza', '82 Wentworth St, Charleston, SC', 32.782330, -79.934235, NULL, NULL, NULL),
(62, 'Mellow Mushroom Pizza Bakers', '259 E Broad St, Athens, GA', 33.957802, -83.374657, NULL, NULL, NULL),
(63, 'Bucks Pizza of Edisto Beach Inc', '114 Jungle Rd, Edisto Island, SC', 32.503971, -80.297951, NULL, NULL, NULL),
(64, 'Anthony''s Coal Fired Pizza', '2203 S Federal Hwy, Fort Lauderdale, FL', 26.094671, -80.136688, NULL, NULL, NULL),
(65, 'Giordano''s', '12151 S Apopka Vineland Rd, Orlando, FL', 28.389366, -81.506226, NULL, NULL, NULL),
(66, 'Pizza Rustica', '863 Washington Ave, Miami Beach, FL', 25.779058, -80.133110, NULL, NULL, NULL),
(67, 'Mama Jennie''s Italian Restaurant', '11720 Ne 2nd Ave, North Miami, FL', 25.882782, -80.194290, NULL, NULL, NULL),
(68, 'Anthony''s Coal Fired Pizza', '17901 Biscayne Blvd, Aventura, FL', 25.941116, -80.148827, NULL, NULL, NULL),
(69, 'Anthony''s Coal Fired Pizza', '4527 Weston Rd, Weston, FL', 26.065395, -80.362442, NULL, NULL, NULL),
(70, 'Mario the Baker Pizza & Italian Restaurant', '13695 W Dixie Hwy, North Miami, FL', 25.929741, -80.156090, NULL, NULL, NULL),
(71, 'Big Cheese Pizza', '8080 SW 67th Ave, Miami, FL', 25.696026, -80.301109, NULL, NULL, NULL),
(72, 'Ingleside Village Pizza', '2396 Ingleside Ave, Macon, GA', 32.853760, -83.657410, NULL, NULL, NULL),
(73, 'Ciao Bella Pizza Da Guglielmo', '29 Highway 98 E, Destin, FL', 30.395555, -86.512093, NULL, NULL, NULL),
(74, 'Papa John''s Pizza', '810 Russell Pkwy, Warner Robins, GA', 32.593910, -83.637077, NULL, NULL, NULL),
(75, 'Papa John''s Pizza: East Central Montgomery', '2525 Madison Ave, Montgomery, AL', 32.381123, -86.273033, NULL, NULL, NULL),
(76, 'Cici''s Pizza', '6268 Atlanta Hwy, Montgomery, AL', 32.382206, -86.190674, NULL, NULL, NULL),
(77, 'Papa John''s Pizza', '1210 E Jackson St, Thomasville, GA', 30.849129, -83.963425, NULL, NULL, NULL),
(78, 'Papa John''s Pizza', '711 N Westover Blvd # G, Albany, GA', 31.613970, -84.223083, NULL, NULL, NULL),
(79, 'Mellow Mushroom Pizza Bakers', '6100 Veterans Pkwy, Columbus, GA', 32.532078, -84.955894, NULL, NULL, NULL),
(80, 'Star Pizza', '2111 Norfolk St, Houston, TX', 29.732452, -95.411057, NULL, NULL, NULL),
(81, 'Star Pizza II', '77 Harvard St, Houston, TX', 29.770752, -95.396042, NULL, NULL, NULL),
(82, 'Brothers Pizzeria', '1029 Highway 6 N # 100, Houston, TX', 29.768337, -95.643593, NULL, NULL, NULL),
(83, '11th Street Cafe Inc', '748 E 11th St, Houston, TX', 29.790794, -95.388924, NULL, NULL, NULL),
(84, 'California Pizza Kitchen', '1705 Post Oak Blvd # A, Houston, TX', 29.750172, -95.461197, NULL, NULL, NULL),
(85, 'Collina''s Italian Cafe', '3835 Richmond Ave, Houston, TX', 29.732620, -95.438965, NULL, NULL, NULL),
(86, 'Barry''s Pizza & Italian Diner', '6003 Richmond Ave, Houston, TX', 29.731430, -95.484383, NULL, NULL, NULL),
(87, 'Mario''s Seawall Italian Restaurant', '628 Seawall Blvd, Galveston, TX', 29.304543, -94.772598, NULL, NULL, NULL),
(88, 'Campisi''s Egyptian Restaurant', '5610 E Mockingbird Ln, Dallas, TX', 32.836510, -96.771782, NULL, NULL, NULL),
(89, 'Fat Joe''s Pizza Pasta & Bar', '4721 W Park Blvd # 101, Plano, TX', 33.027054, -96.788910, NULL, NULL, NULL),
(90, 'Saccone''s Pizza', '13812 N Highway 183, Austin, TX', 29.569508, -97.964661, NULL, NULL, NULL),
(91, 'Fireside Pies', '2820 N Henderson Ave, Dallas, TX', 32.819763, -96.784149, NULL, NULL, NULL),
(92, 'Romeo''s', '1500 Barton Springs Rd, Austin, TX', 30.261526, -97.760025, NULL, NULL, NULL),
(93, 'Sandella''s Cafe', '5910 N Macarthur Blvd, Irving, TX', 32.892002, -96.961189, NULL, NULL, NULL),
(94, 'Mangia Chicago Stuffed Pizza', '3500 Guadalupe St, Austin, TX', 30.301542, -97.739113, NULL, NULL, NULL),
(95, 'Frank & Angie''s', '508 West Ave, Austin, TX', 30.269394, -97.750893, NULL, NULL, NULL),
(96, 'Filippi''s Pizza Grotto', '1747 India St, San Diego, CA', 32.723831, -117.168327, NULL, NULL, NULL),
(97, 'Pizzeria Bianco', '623 E Adams St, Phoenix, AZ', 33.449375, -112.065521, NULL, NULL, NULL),
(98, 'Sammy''s Woodfired Pizza', '770 4th Ave, San Diego, CA', 32.713383, -117.161179, NULL, NULL, NULL),
(99, 'Casa Bianca Pizza Pie', '1650 Colorado Blvd, Los Angeles, CA', 34.139160, -118.204605, NULL, NULL, NULL),
(100, 'Parkway Grill', '510 S Arroyo Pkwy, Pasadena, CA', 34.137005, -118.147301, NULL, NULL, NULL),
(101, 'California Pizza Kitchen', '330 S Hope St, Los Angeles, CA', 34.053329, -118.252686, NULL, NULL, NULL),
(102, 'B J''s Pizza & Grill', '200 Main St # 101, Huntington Beach, CA', 33.658058, -118.001099, NULL, NULL, NULL),
(103, 'B J''s Restaurant & Brewhouse', '280 S Coast Hwy, Laguna Beach, CA', 33.542091, -117.783516, NULL, NULL, NULL),
(104, 'Giuseppe''s Depot Restaurant', '10 S Sierra Madre St, Colorado Springs, CO', 38.834549, -104.828300, NULL, NULL, NULL),
(105, 'Beau Jo''s Pizza', '2710 S Colorado Blvd, Denver, CO', 39.667343, -104.940704, NULL, NULL, NULL),
(106, 'Pasquini''s Pizzeria', '1310 S Broadway, Denver, CO', 39.692825, -104.987465, NULL, NULL, NULL),
(107, 'Fargos Pizza Co', '2910 E Platte Ave, Colorado Springs, CO', 38.839848, -104.774422, NULL, NULL, NULL),
(108, 'Old Chicago', '1415 Market St, Denver, CO', 39.748177, -105.000504, NULL, NULL, NULL),
(109, 'Sink', '1165 13th St, Boulder, CO', 40.008209, -105.276237, NULL, NULL, NULL),
(110, 'Ligori''s Pizza & Pasta', '4421 Harrison Blvd, Ogden, UT', 41.182732, -111.949196, NULL, NULL, NULL),
(111, 'Old Chicago', '1102 Pearl St, Boulder, CO', 40.017590, -105.280991, NULL, NULL, NULL),
(112, 'Boston''s Restaurant & Sports', '620 E Disk Dr, Rapid City, SD', 44.106937, -103.205223, NULL, NULL, NULL),
(113, 'Chuck E Cheese''s Pizza', '100 24th St W # B, Billings, MT', 45.771355, -108.576286, NULL, NULL, NULL),
(114, 'Space Aliens Grill & Bar', '1304 E Century Ave, Bismarck, ND', 46.838081, -100.771736, NULL, NULL, NULL),
(115, '2nd Street Bistro', '123 North 2nd Street, Livingston, MT', 45.661015, -110.561424, NULL, NULL, NULL),
(116, 'Domino''s Pizza', '1524 S Broadway # 1, Minot, ND', 48.219658, -101.296036, NULL, NULL, NULL),
(117, 'American Classic Pizzeria', '1744 Grand Ave, Billings, MT', 45.784119, -108.560204, NULL, NULL, NULL),
(118, 'Godfather''s Pizza', '905 Main St, Billings, MT', 45.815079, -108.470757, NULL, NULL, NULL),
(119, 'Papa John''s Pizza', '605 Main St, Billings, MT', 45.810223, -108.472122, NULL, NULL, NULL),
(120, 'Aardvark Pizza & Sub', '304A Caribou St, Banff, AB', 51.176487, -115.570747, NULL, NULL, NULL),
(121, 'Jasper Pizza Place', '402 Connaught Dr, Jasper, AB', 52.879086, -118.079315, NULL, NULL, NULL),
(122, 'Odyssey Pizza & Steak House', '3-3814 Bow Trail SW, Calgary, AB', 51.045235, -114.141251, NULL, NULL, NULL),
(123, 'Basil''s Pizza', '2118 33 Avenue SW, Calgary, AB', 51.023979, -114.109901, NULL, NULL, NULL),
(124, 'Castle Pizza & Donair', '7724 Elbow Drive SW, Calgary, AB', 50.984497, -114.083153, NULL, NULL, NULL),
(125, 'Santa Lucia Italian Restaurant', '714 8 St, Canmore, AB', 51.089195, -115.358734, NULL, NULL, NULL),
(126, 'Tops Pizza & Steak House No 3', '7-5602 4 Street NW, Calgary, AB', 51.101204, -114.071457, NULL, NULL, NULL),
(127, 'Evvia Restaurant', '837 Main St, Canmore, AB', 51.089176, -115.361771, NULL, NULL, NULL),
(128, 'D'Bronx', '3904 Bell St, Kansas City, MO', 39.057182, -94.606102, NULL, NULL, NULL),
(129, 'Cicero''s Restaurant & Entrtnmt', '6691 Delmar Blvd, St Louis, MO', 38.656307, -90.308441, NULL, NULL, NULL),
(130, 'Hideaway Pizza', '6616 N Western Ave, Oklahoma City, OK', 35.539116, -97.529762, NULL, NULL, NULL),
(131, 'Fortel''s Pizza Den', '7932 Mackenzie Rd, St Louis, MO', 38.566441, -90.320793, NULL, NULL, NULL),
(132, 'Hideaway Pizza', '7877 E 51st St, Tulsa, OK', 36.089897, -95.889244, NULL, NULL, NULL),
(133, 'Farotto''s Catering', '9525 Manchester Rd, Webster Groves, MO', 38.609325, -90.364433, NULL, NULL, NULL),
(134, 'California Pizza Kitchen', '1493 Saint Louis Galleria, St Louis, MO', 38.633614, -90.345947, NULL, NULL, NULL),
(135, 'D''Bronx', '2450 Grand Blvd # 124, Kansas City, MO', 39.082722, -94.581779, NULL, NULL, NULL),
(136, 'Giuseppe''s Depot Restaurant', '10 S Sierra Madre St, Colorado Springs, CO', 38.834549, -104.828300, NULL, NULL, NULL),
(137, 'Beau Jo''s Pizza', '2710 S Colorado Blvd, Denver, CO', 39.667343, -104.940704, NULL, NULL, NULL),
(138, 'Pasquini''s Pizzeria', '1310 S Broadway, Denver, CO', 39.692825, -104.987465, NULL, NULL, NULL),
(139, 'Fargos Pizza Co', '2910 E Platte Ave, Colorado Springs, CO', 38.839848, -104.774422, NULL, NULL, NULL),
(140, 'Old Chicago', '1415 Market St, Denver, CO', 39.748177, -105.000504, NULL, NULL, NULL),
(141, 'Sink', '1165 13th St, Boulder, CO', 40.008209, -105.276237, NULL, NULL, NULL),
(142, 'Old Chicago', '1102 Pearl St, Boulder, CO', 40.017590, -105.280991, NULL, NULL, NULL),
(143, 'Gondolier', '1738 Pearl St, Boulder, CO', 40.019344, -105.272949, NULL, NULL, NULL),
(144, 'Ligori''s Pizza & Pasta', '4421 Harrison Blvd, Ogden, UT', 41.182732, -111.949196, NULL, NULL, NULL),
(145, 'Brick Oven Restaurant', '111 E 800 N, Provo, UT', 40.244492, -111.656319, NULL, NULL, NULL),
(146, 'Zachary''s Chicago Pizza', '5801 College Ave, Oakland, CA', 37.846180, -122.251953, NULL, NULL, NULL),
(147, 'Zachary''s Chicago Pizza', '1853 Solano Ave, Berkeley, CA', 37.891407, -122.278427, NULL, NULL, NULL),
(148, 'Cheese Board Pizza', '1512 Shattuck Ave, Berkeley, CA', 37.879974, -122.269272, NULL, NULL, NULL),
(149, 'Goat Hill Pizza', '300 Connecticut St, San Francisco, CA', 37.762432, -122.397614, NULL, NULL, NULL),
(150, 'Tommaso Ristorante Italiano', '1042 Kearny St, San Francisco, CA', 37.797386, -122.405373, NULL, NULL, NULL),
(151, 'Little Star Pizza LLC', '846 Divisadero St, San Francisco, CA', 37.777519, -122.438217, NULL, NULL, NULL),
(152, 'Pauline''s Pizza', '260 Valencia, San Francisco, CA', 37.768726, -122.422241, NULL, NULL, NULL),
(153, 'Villa Romana Pizzeria & Rstrnt', '731 Irving St, San Francisco, CA', 37.764072, -122.465584, NULL, NULL, NULL),
(154, 'Amici''s East Coast Pizzeria', '69 E 3rd Ave, San Mateo, CA', 37.563896, -122.324722, NULL, NULL, NULL),
(155, 'Amici''s East Coast Pizzeria', '226 Redwood Shores Pkwy, Redwood City, CA', 37.520515, -122.252258, NULL, NULL, NULL),
(156, 'North Beach Pizza', '240 E 3rd Ave, San Mateo, CA', 37.565327, -122.322639, NULL, NULL, NULL),
(157, 'Patxi''s Chicago Pizza', '441 Emerson St, Palo Alto, CA', 37.445148, -122.163551, NULL, NULL, NULL),
(158, 'Pizz''a Chicago', '4115 El Camino Real, Palo Alto, CA', 37.414104, -122.126221, NULL, NULL, NULL),
(159, 'California Pizza Kitchen', '531 Cowper St, Palo Alto, CA', 37.448074, -122.158813, NULL, NULL, NULL),
(160, 'Windy City Pizza', '35 Bovet Rd, San Mateo, CA', 37.551563, -122.314522, NULL, NULL, NULL),
(161, 'Applewood Pizza 2 Go', '1001 El Camino Real, Menlo Park, CA', 37.452965, -122.181725, NULL, NULL, NULL),
(162, 'Pizza Antica', '334 Santana Row # 1065, San Jose, CA', 37.321793, -121.947739, NULL, NULL, NULL),
(163, 'Pizz''a Chicago', '155 W San Fernando St, San Jose, CA', 37.333279, -121.891678, NULL, NULL, NULL),
(164, 'House of Pizza', '527 S Almaden Ave, San Jose, CA', 37.326351, -121.888168, NULL, NULL, NULL),
(165, 'Amici''s East Coast Pizzeria', '225 W Santa Clara St, San Jose, CA', 37.334702, -121.894043, NULL, NULL, NULL),
(166, 'Fiorillo''s Restaurant', '638 El Camino Real, Santa Clara, CA', 37.354603, -121.942574, NULL, NULL, NULL),
(167, 'Tony & Alba''s Pizza & Pasta', '3137 Stevens Creek Blvd, San Jose, CA', 37.323296, -121.951645, NULL, NULL, NULL),
(168, 'Giorgio''s', '1445 Foxworthy Ave, San Jose, CA', 37.274647, -121.892891, NULL, NULL, NULL),
(169, 'Round Table Pizza', '4302 Moorpark Ave, San Jose, CA', 37.315903, -121.977928, NULL, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `places`
--
CREATE TABLE IF NOT EXISTS `places` (
`place_id` int(11) NOT NULL AUTO_INCREMENT,
`place_name` varchar(45) DEFAULT NULL,
PRIMARY KEY (`place_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=98 ;
--
-- Dumping data for table `places`
--
INSERT INTO `places` (`place_id`, `place_name`) VALUES
(1, 'accounting'),
(2, 'airport'),
(3, 'amusement_park'),
(4, 'aquarium'),
(5, 'art_gallery'),
(6, 'atm'),
(7, 'bakery'),
(8, 'bank'),
(9, 'bar'),
(10, 'beauty_salon'),
(11, 'bicycle_store'),
(12, 'book_store'),
(13, 'bowling_alley'),
(14, 'bus_station'),
(15, 'cafe'),
(16, 'campground'),
(17, 'car_dealer'),
(18, 'car_rental'),
(19, 'car_repair'),
(20, 'car_wash'),
(21, 'casino'),
(22, 'cemetery'),
(23, 'church'),
(24, 'city_hall'),
(25, 'clothing_store'),
(26, 'convenience_store'),
(27, 'courthouse'),
(28, 'dentist'),
(29, 'department_store'),
(30, 'doctor'),
(31, 'electrician'),
(32, 'electronics_store'),
(33, 'embassy'),
(34, 'establishment'),
(35, 'finance'),
(36, 'fire_station'),
(37, 'florist'),
(38, 'food'),
(39, 'funeral_home'),
(40, 'furniture_store'),
(41, 'gas_station'),
(42, 'general_contractor'),
(43, 'geocode'),
(44, 'grocery_or_supermarket'),
(45, 'gym'),
(46, 'hair_care'),
(47, 'hardware_store'),
(48, 'health'),
(49, 'hindu_temple'),
(50, 'home_goods_store'),
(51, 'hospital'),
(52, 'insurance_agency'),
(53, 'jewelry_store'),
(54, 'laundry'),
(55, 'lawyer'),
(56, 'library'),
(57, 'liquor_store'),
(58, 'local_government_office'),
(59, 'locksmith'),
(60, 'lodging'),
(61, 'meal_delivery'),
(62, 'meal_takeaway'),
(63, 'mosque'),
(64, 'movie_rental'),
(65, 'movie_theater'),
(66, 'moving_company'),
(67, 'museum'),
(68, 'night_club'),
(69, 'painter'),
(70, 'park'),
(71, 'parking'),
(72, 'pet_store'),
(73, 'pharmacy'),
(74, 'physiotherapist'),
(75, 'place_of_worship'),
(76, 'plumber'),
(77, 'police'),
(78, 'post_office'),
(79, 'real_estate_agency'),
(80, 'restaurant'),
(81, 'roofing_contractor'),
(82, 'rv_park'),
(83, 'school'),
(84, 'shoe_store'),
(85, 'shopping_mall'),
(86, 'spa'),
(87, 'stadium'),
(88, 'storage'),
(89, 'store'),
(90, 'subway_station'),
(91, 'synagogue'),
(92, 'taxi_stand'),
(93, 'train_station'),
(94, 'travel_agency'),
(95, 'university'),
(96, 'veterinary_care'),
(97, 'zoo');
-- --------------------------------------------------------
--
-- Table structure for table `products`
--
CREATE TABLE IF NOT EXISTS `products` (
`product_id` int(11) NOT NULL AUTO_INCREMENT,
`product_name` varchar(50) NOT NULL,
`image` varchar(50) DEFAULT NULL,
`barcode` varchar(12) DEFAULT NULL,
`barcode_type` int(1) DEFAULT NULL,
PRIMARY KEY (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `products`
--
-- --------------------------------------------------------
--
-- Table structure for table `store_products`
--
CREATE TABLE IF NOT EXISTS `store_products` (
`store_id` int(11) NOT NULL,
`product_id` int(11) NOT NULL,
`price` float(10,2) NOT NULL,
`quantity` int(5) DEFAULT NULL,
`image` varchar(50) DEFAULT NULL,
PRIMARY KEY (`store_id`,`product_id`),
KEY `product_id` (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `store_products`
--