INSERT INTO category (catId, catName) VAlUES (1, 'Frozen Food');
    INSERT INTO foodItem(catId, itemName, itemDesc, itemImage, itemPrice, itemQtyStocked)
          VALUES(
            1, 
            'Birds Eye® Broccoli Florets - 4 lb. bag',
            'Birds Eye farmers are pickier than most. Maybe that''s because we don''t just grow the vegetables. We own the company. It''s our reputation in every package. So we make sure only the best, freshest tasting vegetables reach your table. Vegetables we''re proud to call our own. Enjoy. ',
            'birdeye-broccoli.jpg',
            7.89,
            10);

    INSERT INTO foodItem(catId, itemName, itemDesc, itemImage, itemPrice, itemQtyStocked)
          VALUES(
            1, 
            'Ore-Ida Crunchy French Fries',
            'Crankly, crunchy and delicious french fries.',
            'ore-ida-french-fries.jpg',
            5.99,
            3);

INSERT INTO category (catId, catName) VAlUES (2,'Canned Goods');
    INSERT INTO  foodItem(catId, itemName, itemDesc, itemImage, itemPrice,itemQtyStocked)
          VALUES(
            2, 
            'Dole® Pineapple Chunks - 6 lb. 10 oz. can',
            'Dole pineapple chunks are tasty morsels of flavor and color that enhance a variety of cuisines. Add a taste of the tropics to your menu by serving Dole Pineapple Chunks. ',
            'dole-pineapple-can.jpg',
            4.89,
            31);

    INSERT INTO  foodItem(catId, itemName, itemDesc, itemImage, itemPrice, itemQtyStocked)
          VALUES(
            2, 
            'Progresso® Italian Style Soup 8/18.5 oz.',
            'A great tasting soup for all occasions.  Serve in deli''s',
            'progresso-soup.jpg',
            11.89,
            6);

    INSERT INTO  foodItem(catId, itemName, itemDesc, itemImage, itemPrice)
          VALUES(
            2, 
            'RED KIDNEY BEANS 6/15.5 OZ',
            '',
            'beans-goya.jpg',
            11.89);

INSERT INTO category (catId, catName) VAlUES (3,'Dairy');
    INSERT INTO  foodItem(catId, itemName, itemDesc, itemImage, itemPrice, itemQtyStocked)
          VALUES(
            3, 
            'Silk® Vanilla Soymilk - 3/half gallon cartons',
            'Try Silk plain soymilk over your cereal, have it as a between-meals snack, make ice cream, milk shakes or smoothies with it.',
            'soymilk-silk.jpg',
            11.89,
            7);

INSERT INTO category (catId, catName) VAlUES (4,'Produce');
    INSERT INTO  foodItem(catId, itemName, itemDesc, itemImage, itemPrice, itemQtyStocked)
          VALUES(
            4, 
            ' Red Delicious Apples - 8 lbs.',
            'Try Silk plain soymilk over your cereal, have it as a between-meals snack, make ice cream, milk shakes or smoothies with it.',
            'red-apples.jpg',
            11.89,
            100);

    INSERT INTO  foodItem(catId, itemName, itemDesc, itemImage, itemPrice, itemQtyStocked)
          VALUES(
            4, 
            'Garden Salad - 3 lb.',
            'Each 3lb. bag of Garden Salad consists of pre mixed chopped iceberg lettuce, shredded red cabbage and carrots. Product is washed and ready to eat, contains no preservatives, and is 100% useable.',
            'garden-salad.jpg',
            11.89,
            10);

    INSERT INTO  foodItem(catId, itemName, itemDesc, itemImage, itemPrice, itemQtyStocked)
          VALUES(
            4, 
            'Asparagus - 2.25 lbs.',
            'A nutrient-dense food which is high in Folic Acid and is a good source of potassium, fiber, Vitamin B6, Vitamins A and C, and thiamin.',
            'asparagus-veggie.jpg',
            11.89,
            9);

    INSERT INTO  foodItem(catId, itemName, itemDesc, itemImage, itemPrice, itemQtyStocked)
          VALUES(
            4, 
            'Variety Pack Bell Pepper',
            'Beautiful green, yellow, and red peppers.',
            'bell-peppers.jpg',
            11.89,
            8);

INSERT INTO category (catId, catName) VAlUES (5,'Baking Goods');
INSERT INTO category (catId, catName) VAlUES (6,'Pasteries');

COMMIT;