View difference between Paste ID: PpyGPdfV and yCN7yJqj

 
 
 -- SKRIPTA ZA MYSQL BAZU DA BI PROGRAM MOGAO DA RADI
 -- opis TIMA 12
 -- kolega koji je bio Student 2 nije uradio svoje delove, pa smo morali da hardkodujemo hrane
-insert into Food values (2,"dobra" , "pizza",50);
+
-insert into Food values (1,"vruca" , "supa",26);
+
 insert into Food values (1,"dobra" , "pizza",50);
 insert into Food values (2,"vruca" , "supa",35);
 insert into Food values (3,"hladno" , "meso",20);
-insert into drink values (1,"gazirano pice" , "kola",12);
+
 insert into drink values (1,"lepo pice" , "limunada",20);
 insert into drink values (2,"hladno pice" , "pivo",10);
 insert into drink values (3,"gazirano pice" , "kola",12);
 
 
 
 insert into Restaurant values("1", "Kineski" ,250,4.8,  "Ispod saca", 5,false);
 
 insert into Restaurant values("2",  "Italijanski",  1000, 4.8,  "Aman", 5,false);
 
 insert into Restaurant values("3",  "Domaci",  300, 4.8, "Corso",  5,false);
 
 insert into Restaurant values ("4",  "Vegan",  750, 4.5, "Perla",  4.2,false);
 
 
 -- dodati goste na pocetku sa verifikovanim nalozima, jer se mail za proveru salje na nas privatni mail
 insert into Guest values ("100" , null, "prvi@gmail.com",null,"Mika","Mikic","prvi",null,0,null,"jovan jovanovic 33",1);
-insert into t_order values (1,false, "Kineski",false,"asd");
+
 insert into Guest values ("300" , null, "treci@gmail.com",null,"Lola","Lolic","treci",null,0,null,"Pera peric 60",1);
 insert into Guest values ("400" , null, "cetvrti@gmail.com",null,"Moma","Momic","cetvrti",null,0,null,"jovan jovanovic 78",1);
 
 insert into t_order values (1,false, "Aman",false,"12.09.2017 08:00 10:00");
 
 
 insert into order_food values (1,false,false, 1, 1);
 insert into order_food values (2,false,false, 1, 1);
-insert into order_broj_stola values (1, 7);
+
 
 insert into order_drink values (1,false, 1, 1);
 insert into order_drink values (2,false, 2, 1);
 insert into order_drink values (3,false, 3, 1);
 
 insert into order_broj_stola values (1, 1);
 insert into order_broj_stola values (1, 4);
 insert into order_broj_stola values (1, 7);
 
 insert into t_order values (1,false, "Aman",false,"12.09.2017 17:00 19:00");
 
 
 insert into order_food values (1,false,false, 1, 1);
 
 
 insert into order_drink values (1,false, 1, 1);
 
 
 insert into order_broj_stola values (1, 5);
 insert into order_broj_stola values (1, 6);