     FOREIGN KEY (recipe_id)
         REFERENCES recipes (recipe_id),
     UNIQUE (meal_id , recipe_id)
-);
-
+);
drop table if exists meals;
drop table if exists recipe_ingredients;
drop table if exists recipes;
drop table if exists shopping_lists;
drop table if exists pantry_foods;
drop table if exists pantries;
drop table if exists users;
drop table if exists foods;



insert into users (username) values ("roscode");

CREATE TABLE pantry_contents (
    user_id INT NOT NULL,
    food_id INT NOT NULL,
    FOREIGN KEY (user_id)
        REFERENCES users (user_id),
    FOREIGN KEY (food_id)
        REFERENCES foods (food_id),
    UNIQUE (user_id , food_id)
);

insert into pantry_contents values (1, 1), (1, 2), (1, 3), (1, 4);


CREATE TABLE shopping_list_contents (
    user_id INT NOT NULL,
    food_id INT NOT NULL,
    FOREIGN KEY (user_id)
