LogicAndPhysicalDeisgn: polnenjeFinal2.sql

delete from UserHasProgram;
delete from UserHasDays;
delete from DayHasMeal;
delete from MealHasIngredient;
delete from DayHasWorkout;
delete from WorkoutHasExercise;
delete from WorkoutProgramHasWorkout;


delete from Meal;
delete from Workout;
delete from _User;
delete from _Day;
delete from PersIngrsIsOfType;
delete from PersonalizedIngredient;
delete from Ingredient;
delete from PersExerIsOfType;
delete from PersonalizedExercise;
delete from Exercise;

delete from WorkoutProgram;



INSERT INTO _User (uID, name, password, age, height, weight, role)
VALUES 
    (1, 'JohnDoe', 'password123', 25, 180, 75, 'user'),
    (2, 'JaneDoe', 'securepass', 30, 165, 60, 'admin');



   
INSERT INTO _Day (dID, date)
VALUES 
    (1, '2024-02-08'),
    (2, '2024-06-08'),
    (3, '2024-02-09');


   
INSERT INTO Workout (wID, duration, name)
VALUES 
    (1, 60, 'Morning Workout'),
    (2, 45, 'Evening Workout');


   
INSERT INTO Meal (mID, name, type, uID)
VALUES 
    (1, 'Breakfast', 'Healthy', 1),
    (2, 'Lunch', 'Balanced', 2);


   INSERT INTO Ingredient (iID, name, calories, protein, carbs, fats)
VALUES 
    (1, 'Eggs', 70, 6, 1, 5),
    (2, 'Chicken Breast', 165, 31, 0, 3);


   
INSERT INTO PersonalizedIngredient (piID, quantity)
VALUES 
    (1, 2),
    (2, 150);
   
   
INSERT INTO PersIngrsIsOfType (iID, piID)
VALUES 
    (1, 2),
    (2, 2);

   
INSERT INTO Exercise (eID, name, type)
VALUES 
    (1, 'Running', 'Cardio'),
    (2, 'Bench Press', 'Bodybuilding');


   
INSERT INTO PersonalizedExercise (peID, reps, sets, weight, time)
VALUES 
    (1, 10, 3, 50, NULL),
    (2, 12, 4, 80, null);

   
INSERT INTO PersExerIsOfType (eID, peID)
VALUES 
    (2, 1),
    (2, 2);



   
INSERT INTO WorkoutProgram (wpID, name)
VALUES 
    (1, 'Weight Loss Program'),
    (2, 'Muscle Building Program');


   
INSERT INTO UserHasDays (uID, dID)
VALUES 
    (1, 1),
    (1, 3),
    (2, 2);


   
INSERT INTO UserHasProgram (uID, wpID)
VALUES 
    (1, 1),
    (2, 2);



INSERT INTO DayHasWorkout (wID, dID)
VALUES 
    (1, 1),
    (2, 2);


   
INSERT INTO WorkoutProgramHasWorkout (wID, wpID)
VALUES 
    (1, 1),
    (2, 2);

   
INSERT INTO DayHasMeal (mID, dID)
VALUES 
    (1, 1),
    (2, 2);


INSERT INTO MealHasIngredient (mID, piID)
VALUES 
    (1, 1),
    (2, 2);


INSERT INTO WorkoutHasExercise (peID, wID)
VALUES 
    (1, 1),
    (2, 2);