/* -- 1. create an sql table for my products -- */
CREATE TABLE Project3Eateries(
    id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(127) DEFAULT NULL,
    img VARCHAR(127) DEFAULT NULL,
    rating TINYINT UNSIGNED DEFAULT NULL,
    foodtype VARCHAR(127) DEFAULT NULL,
    address VARCHAR(127) DEFAULT NULL,
    city VARCHAR(127) DEFAULT NULL,
    website VARCHAR(127) DEFAULT NULL
);

INSERT INTO Project3Eateries(name, img, rating, foodtype, address, city, website)
VALUES
("Oishi", "_oishi.jpg", 4, "Asian", "1420 Main St", "Delano, CA", "https://www.oishisushionline.com/"),
("El Charros", "_charros.jpg", 4, "Mexican", "1131 Main St", "Delano, CA", "NA"),
("Mmm Yogurt", "_mmmyogurt.jpg", 5, "Deli", "913 12th Ave", "Delano, CA", "NA"),
("Elmer's Drive In", "_elmers.jpg", 5, "Burgers", "1112 Cecil Ave", "Delano, CA", "NA"),
("Slice Of Italy", "_sliceofitaly.jpg", 3, "Italian", "10524 Hageman Rd", "Bakersfield, CA", "https://mysliceofitaly.com/"),
("Firestone Grill", "_firestone.jpg", 5, "BBQ", "3501 California Ave", "Bakersfield, CA", "https://www.firestonegrill.com/"),
("Barrington's Jamaican Kitchen", "_barrington.jpg", 5, "Caribbean", "4120 Ming Ave", "Bakersfield, CA", "https://www.barringtonsjamaicankitchen.com/"),
("Moo Creamery", "_moo.jpg", 4, "Desert", "4885 Truxton Ave", "Bakersfield, CA", "https://www.moocreamery.com/"),
("Catrina's Mexican Grill and Cantina", "_catrina.jpg", 5, "Mexican", "1345 F St", "Wasco, CA", "NA"),
("La Cocina Del Pueblo", "_lacocina.jpg", 5, "Mexican", "931 7th Ave", "Wasco, CA", "NA"),
("Giovanni's Italian Eatery", "_giovanni.jpg", 4, "Italian", "130 Walker St", "Wasco, CA", "NA"),
("La Barca", "_labarca.jpg", 4, "Mexican", "271 State St", "Earlimart, CA", "NA"),
("Taqueria El Sol De Jalisco", "_taqueria.jpg", 4, "Mexican", "124 S Front Rd", "Earlimart, CA", "NA"),
("Sanad Freeze", "_sanag.jpg", 5, "Burgers", "853 Armstrong Ave", "Earlimart, CA", "NA"),
("Krave", "_krave.jpg", 5, "Asian", "1299 Prosperity Ave", "Tulare, CA", "NA"),
("Bravo Farms", "_bravo.jpg", 5, "American", "1691 Rutherford St", "Tulare, CA", "https://bravofarms.com/locations/tulare-outlets/"),
("The Curry Pizza Company", "_currypizza.jpg", 5, "Italian", "2091 E Bardsley Ave", "Tulare, CA", "https://www.thecurrypizzacompany.com/"),
("La Piazza Ristorante Italiano", "_lapiazza.jpg", 5, "Italian", "1600 E Tulare Ave", "Tulare, CA", "https://www.lapiazzarest.com/"),
("Davorn's Place Lao", "_davorn.jpg", 4, "Asian", "400 N Willis St", "Visalia, CA", "NA"),
("Left Of Center", "_leftofcenter.jpg", 5, "Burgers", "699 W Center Ave", "Visalia, CA", "http://www.leftofcentervisalia.com/#home-section"),
("Brewbakers Brewing Company", "_brewbakers.jpg", 4, "American", "219 E Main St", "Visalia, CA", "https://brewbakersbrewingco.com/"),
("Pita Kabob Mediterranean Gastropub", "_pitakabob.jpg", 4, "Mediterranean", "227 N Court St", "Visalia, CA", "https://pitakabob.com/"),
("Vintage Press", "_vintage.jpg", 4, "American", "216 N Willis St", "Visalia, CA", "https://thevintagepress.com/");

