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); |