Ф2: Script-1pr.sql

INSERT INTO User(user_id,name_surname,account_number,card_number,password,tel_num,address,e-mail,height,weight) VALUES (1,"Tamara Ackovska",64784,474883,”password123”,070111123,”ul2,Skopje”,”tamara.ackovska@students.finki.ukim.mk”,165,50),
(2,"Lina Petrovska",1784,34883,"password888",070666123,"ul5,Skopje","lina.petrovska@gmail.com",166,52);

INSERT INTO Program(user_id,program_name,program_id)
VALUES(1,'BuildMuscleProgram','1');

INSERT INTO BuildMuscleProgram (user_id,bm_p,meal)
VALUES(1,"p5","meal1"),
(2,”p35”,”meal8”);

INSERT INTO Workout (user_id,w_id,name)
VALUES(1,"w21","abs workout"),
 (2,"w66","legs workout");


INSERT INTO WeightLossProgram(wl_p,user_id,meal,calories)
VALUES("wl5",1,"meal3",1200),
("wl2",2,"meal4",1500);

INSERT INTO Supplements(supplement_id,user_id, preworkouts,proteins,creatine,fat_burners,vitamins,aminos)
VALUES("s4",1,"Super Charge","Iso whey zero","CreaBomb","Thermo speed extreme","MultiVitamins","Arginine"),
("s8",2,"Redweiler","Hydro whey zero","CreaBomb","Razor","MultiVitamins","Bcaa");

INSERT INTO LoyalityCardUser(user_id,loyality_card_number,discout,price)
VALUES(1,6464,30,35),
(2,7389,20,40);

INSERT INTO NoLoyalityCardUser(user_id,price)
VALUES(1,50),
(2,50);

INSERT INTO Payment(user_id ,payment_id,payment_date)
VALUES (1,"p1", "2008-11-11");

INSERT INTO MealPlan(meal_name,meal_id,calores)
VALUES ("oatmeal",2,"1200kcal");