View difference between Paste ID: gAgwGSya and Xi2fRezM
SHOW: | | - or go back to the newest paste.
1
-- SKRIPTA ZA MYSQL BAZU DA BI PROGRAM MOGAO DA RADI
2
-- opis TIMA 12
3
-- kolega koji je bio Student 2 nije uradio svoje delove, pa smo morali da hardkodujemo hrane
4
-- pica,restorane
5
6
insert into Food values (2,"dobra" , "pizza",50);
7
insert into Food values (1,"vruca" , "supa",26);
8
9
10
insert into drink values (2,"hladno pice" , "pivo",10);
11
insert into drink values (1,"gazirano pice" , "kola",12);
12
13
        
14
insert into Restaurant values("1", "Kineski" ,250,4.8,  "Ispod saca", 5,false);
15
        
16
insert into Restaurant values("2",  "Italijanski",  1000, 4.8,  "Aman", 5,false);
17
        
18
insert into Restaurant values("3",  "Domaci",  300, 4.8, "Corso",  5,false);
19
20
insert into Restaurant values ("4",  "Vegan",  750, 4.5, "Perla",  4.2,false);
21
22
23
-- dodati goste na pocetku sa verifikovanim nalozima, jer se mail za proveru salje na nas privatni mail
24
insert into Guest values ("100" , null, "prvi@gmail.com","Mika","Mikic","prvi",0,"jovan jovanovic 33",1);
25
insert into Guest values ("200" , null, "drugi@gmail.com","Sima","Simic","drugi",0,"Laza Lazarevic 24",1);
26
insert into Guest values ("300" , null, "treci@gmail.com","Lola","Lolic","treci",0,"Pera peric 60",1);
27
insert into Guest values ("400" , null, "cetvrti@gmail.com","Moma","Momic","cetvrti",0,"jovan jovanovic 78",1);
28
29-
insert into t_order values (1, "Kineski", "asd");
29+
insert into t_order values (1,false, "Kineski",false,"asd");
30
31-
insert into order_food values (1, 1, 1);
31+
32-
insert into order_food values (2, 1, 1);
32+
insert into order_food values (1,false,false, 1, 1);
33-
insert into order_food values (3, 2, 1);
33+
insert into order_food values (2,false,false, 1, 1);
34
insert into order_food values (3,false,false, 2, 1);
35
36
insert into order_broj_stola values (1, 1);
37
insert into order_broj_stola values (1, 4);
38
insert into order_broj_stola values (1, 7);