CREATE TABLE my_products (
    product_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    image_link VARCHAR(150) NOT NULL,
    product_name VARCHAR(150) UNIQUE NOT NULL,
    product_description VARCHAR(250)  NOT NULL,
    price INT NOT NULL,
    quantity INT NOT NULL,
    category_initial VARCHAR(5) NOT NULL,
    category_name VARCHAR(100) NOT NULL,
    product_added_datetime TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

INSERT INTO my_products (image_link, product_name, product_description, price, quantity, category_initial, category_name)
VALUES
    ('images/products/chickentenders.jpg', 'Chicken Tenders', 'Juicy pieces of chicken breast covered in a delicious marinade and fried until golden brown. Served with ketchup and mayonnaise.', 8.00, 50, 'APP', 'Appetizers');


INSERT INTO my_products (image_link, product_name, product_description, price, quantity, category_initial, category_name)

VALUES

    ('images/products/chickentenders.jpg', 'Chicken Tenders', 'Juicy pieces of chicken breast covered in a delicious marinade and fried until golden brown. Served with ketchup and mayonnaise.', 8.00, 50, 'APP', 'Appetizers'),

    ('images/products/poutine.jpg', 'Poutine', 'Crispy fries and squeaky cheese curds drenched in a delicious gravy.', 8.00, 50, 'APP', 'Appetizers'),

    ('images/products/cheesebites.jpg', 'Cheese Bites', 'Bite sized pieces of cheese fried until golden brown. Served with ketchup.', 3.00, 50, 'APP', 'Appetizers'),

    ('images/products/onionrings.jpg', 'Onion Rings', 'Ring-sized pieces of fresh onions battered and fried until golden brown. Served with our special house sauce.', 7.00, 50, 'APP', 'Appetizers'),

    ('images/products/crispycalamari.jpg', 'Crispy Calamari', 'Ring-sized pieces of squid battered and fried until golden brown. Served with our special tartar sauce.', 8.50, 50, 'APP', 'Appetizers'),

    ('images/products/specialfries.jpg', 'Special Fries', 'Golden fried potato wedges seasoned with salt and pepper and served with our signature marinara sauce.', 5.00, 50, 'APP', 'Appetizers'),

    ('images/products/crispychickenburger.jpg', 'Crispy Chicken Burger', 'A delicious burger combining a buttered bun, veggies, and crispy fried chicken patty. A delight truly!', 12.00, 50, 'BUR', 'Burgers'),

    ('images/products/nashvillehotchickensandwich.jpg', 'Nashville Hot Chicken Sandwich', 'A delicious burger combining a buttered bun, pickles, and crispy fried chicken patty marinated in a spicy paste. A delight of the senses!', 13.00, 50, 'BUR', 'Burgers'),

    ('images/products/clubsandwich.jpg', 'Club Sandwich', 'A delightful combination of soft white sandwich bread with roasted chicken slices, lettuce, tomato slices, creamy mayonnaise, and Lays chips!', 4.00, 50, 'BUR', 'Burgers'),

    ('images/products/crispyfriedchicken.jpg', 'Crispy Fried Chicken', 'Juicy chicken legs marinated in buttermilk and deep fried in true Southern fashion.', 17.00, 50, 'FRI', 'Fried Chicken'),

    ('images/products/classicbuffalowings.jpg', 'Classic Buffalo Wings', 'Juicy chicken wings tossed in hot sauce and served with creamy blue cheese dressing.', 15.00, 50, 'FRI', 'Fried Chicken'),

    ('images/products/broastedchicken.jpg', 'Broasted Chicken', 'Juicy chicken legs marinated in our secret recipe and deep fried in a pressure cooker. Served with habanero hot sauce.', 17.00, 50, 'FRI', 'Fried Chicken'),

    ('images/products/chickenandwaffles.jpg', 'Chicken and Waffles', 'Juicy fried chicken served with delicious syrup-drenched waffles. A delightful combo from the South!', 18.00, 50, 'FRI', 'Fried Chicken'),

    ('images/products/hotdogs.jpg', 'Hotdogs', 'Buttered bun filled with grilled sausage and pickles. Hmm, delicious!', 10.00, 50, 'SID', 'Sides'),

    ('images/products/macandcheese.jpg', 'Mac and Cheese', 'Macaroni baked in a creamy cheese sauce.', 8.00, 50, 'SID', 'Sides'),

    ('images/products/applepie.jpg', 'Apple Pie', 'Crispy pie filled with sweet and warm apples. Served with a scoop of ice cream.', 8.00, 50, 'DES', 'Desserts'),

    ('images/products/cheesecake.jpg', 'Cheesecake', 'A delicious cake made with cheese, eggs, and sugar with a base made of crispy Graham crackers.', 10.00, 50, 'DES', 'Desserts'),

    ('images/products/peachcobbler.jpg', 'Peach Cobbler', 'Sweet slices of peaches covered with buttermilk and biscuits and baked.', 10.00, 50, 'DES', 'Desserts'),

    ('images/products/coke.jpg', 'Coke', 'Carbonated Coca-Cola drink', 4.00, 50, 'BEV', 'Beverages'),

('images/products/mirinda.jpg', 'Mirinda', 'Carbonated orange soft drink', 4.00, 50, 'BEV', 'Beverages');

