Q51BuVGc

1DROP TABLE IF EXISTS RECEPTI_has_SESTAVINE;
2DROP TABLE IF EXISTS SESTAVINE_has_PROIZVAJALCI_SESTAVIN;
3DROP TABLE IF EXISTS SESTAVINE_has_TRGOVINE;
4DROP TABLE IF EXISTS JEDI_has_JEDILNIKI;
5DROP TABLE IF EXISTS RECEPTI;
6DROP TABLE IF EXISTS SESTAVINE;
7DROP TABLE IF EXISTS PROIZVAJALCI_SESTAVIN;
8DROP TABLE IF EXISTS TRGOVINE;
9DROP TABLE IF EXISTS JEDI;
10DROP TABLE IF EXISTS JEDILNIKI;
11DROP TABLE IF EXISTS MASOVNE_KOLICINE;
12DROP TABLE IF EXISTS VIR;
13DROP TABLE IF EXISTS OSEBE;
14DROP TABLE IF EXISTS EMAIL;
15DROP TABLE IF EXISTS NASLOV;
16DROP TABLE IF EXISTS ULICA;
17DROP TABLE IF EXISTS KRAJ;
18DROP TABLE IF EXISTS DRZAVA;
19DROP TABLE IF EXISTS CENE;
20DROP TABLE IF EXISTS TIPI_VALUT;
21DROP TABLE IF EXISTS CASOVI_KUHANJA;
22DROP TABLE IF EXISTS CASOVI_PRIPRAV;
23DROP TABLE IF EXISTS CASOVNE_KOLICINE;
24DROP TABLE IF EXISTS TIPI_CASOVNIH_ENOT;
25DROP TABLE IF EXISTS KOLICINE_CASOV;
26DROP TABLE IF EXISTS TIPI_MASOVNIH_ENOT;
27DROP TABLE IF EXISTS TIPI_VIROV;
28DROP TABLE IF EXISTS TIPI_DOMEN;
29DROP TABLE IF EXISTS TIPI_NAMENOV;
30DROP TABLE IF EXISTS TIPI_JEDI;
31
32
33CREATE TABLE TIPI_NAMENOV(
34    ID INT NOT NULL,
35    namen VARCHAR(20) NOT NULL
36);
37
38CREATE TABLE TIPI_JEDI(
39    ID INT NOT NULL,
40    vrsta VARCHAR(15)
41);
42
43CREATE TABLE TIPI_DOMEN(
44    ID INT NOT NULL,
45    naziv VARCHAR(15) NOT NULL
46);
47
48CREATE TABLE TIPI_VIROV(
49    ID INT NOT NULL,
50    tip VARCHAR(50) NOT NULL
51);
52
53CREATE TABLE TIPI_MASOVNIH_ENOT(
54    ID INT NOT NULL,
55    naziv VARCHAR(15) NOT NULL
56);
57
58CREATE TABLE MASOVNE_KOLICINE(
59    ID INT NOT NULL,
60    kolicina DECIMAL(8,2) NOT NULL,
61    TIPI_MASOVNIH_ENOT_ID INT NOT NULL
62);
63
64CREATE TABLE TIPI_CASOVNIH_ENOT(
65    ID INT NOT NULL,
66    enota VARCHAR(10) NOT NULL
67);
68
69CREATE TABLE CASOVNE_KOLICINE(
70    ID INT NOT NULL,
71    cas DECIMAL(7,2) NOT NULL,
72    CASOVNE_ENOTE_ID INT NOT NULL
73);
74
75CREATE TABLE CASOVI_PRIPRAV(
76    ID INT NOT NULL,
77    CASOVNE_KOLICINE_ID INT NOT NULL
78);
79
80CREATE TABLE CASOVI_KUHANJA(
81    ID INT NOT NULL,
82    CASOVNE_KOLICINE_ID INT NOT NULL
83);
84
85CREATE TABLE TIPI_VALUT(
86    ID INT NOT NULL,
87    valuta VARCHAR(20) NOT NULL
88);
89
90CREATE TABLE CENE(
91    ID INT NOT NULL NOT NULL,
92    cena DECIMAL(10,2) NOT NULL,
93    TIPI_VALUT_ID INT NOT NULL
94);
95
96CREATE TABLE DRZAVA(
97    ID INT NOT NULL,
98    ime VARCHAR(25) NOT NULL
99);
100
101CREATE TABLE KRAJ(
102    ID INT NOT NULL,
103    ime VARCHAR(25) NOT NULL,
104    DRZAVA_ID INT NOT NULL
105);
106
107CREATE TABLE ULICA(
108    ID INT NOT NULL,
109    ime VARCHAR(20),
110    KRAJ_ID INT NOT NULL
111);
112
113CREATE TABLE NASLOV(
114    ID INT NOT NULL,
115    hisnaStevilka INT NOT NULL,
116    ULICA_ID INT NOT NULL
117);
118
119CREATE TABLE EMAIL(
120    ID INT NOT NULL,
121    uporabniskoIme VARCHAR(20) NOT NULL,
122    TIPI_DOMEN_ID INT NOT NULL
123);
124
125CREATE TABLE OSEBE(
126    ID INT NOT NULL,
127    ime VARCHAR(25),
128    priimek VARCHAR(25),
129    EMAIL_ID INT,
130    NASLOV_ID INT
131);
132
133CREATE TABLE VIR(
134    ID INT NOT NULL,
135    OSEBE_ID INT,
136    TIPI_VIROV_ID INT NOT NULL,
137    nazivVira VARCHAR(50),
138    naslov VARCHAR(150),
139    stran INT
140);
141
142CREATE TABLE JEDILNIKI(
143    ID INT NOT NULL,
144    kdaj DATETIME NOT NULL,
145    TIPI_NAMENOV_ID INT,
146    OSEBE_ID INT
147);
148
149CREATE TABLE JEDI_has_JEDILNIKI(
150    ID INT NOT NULL,
151    JEDI_ID INT NOT NULL,
152    JEDILNIKI_ID INT
153);
154
155CREATE TABLE JEDI(
156    ID INT NOT NULL,
157    ime VARCHAR(45),
158    TIPI_JEDI_ID INT NOT NULL
159);
160
161CREATE TABLE TRGOVINE(
162    ID INT NOT NULL,
163    ime VARCHAR(20) NOT NULL,
164    NASLOV_ID INT NOT NULL
165);
166
167CREATE TABLE SESTAVINE(
168    ID INT NOT NULL,
169    ime VARCHAR(20),
170    CENE_ID INT NOT NULL
171);
172
173CREATE TABLE PROIZVAJALCI_SESTAVIN(
174    ID INT NOT NULL,
175    ime VARCHAR(20) NOT NULL,
176    NASLOV_ID INT NOT NULL
177);
178
179CREATE TABLE SESTAVINE_has_TRGOVINE(
180    ID INT NOT NULL,
181    SESTAVINE_ID INT NOT NULL,
182    TRGOVINE_ID INT
183);
184
185CREATE TABLE SESTAVINE_has_PROIZVAJALCI_SESTAVIN(
186    ID INT NOT NULL,
187    SESTAVINE_ID INT NOT NULL,
188    PROIZVAJALCI_SESTAVIN_ID INT
189);
190
191CREATE TABLE RECEPTI_has_SESTAVINE(
192    ID INT NOT NULL,
193    RECEPTI_ID INT NOT NULL,
194    SESTAVINE_ID INT NOT NULL,
195    MASOVNE_KOLICINE_ID INT 
196);
197
198CREATE TABLE RECEPTI(
199    ID INT NOT NULL,
200    JEDI_ID INT NOT NULL,
201    CASOVI_PRIPRAV_ID INT NOT NULL,
202    CASOVI_KUHANJA_ID INT NOT NULL,
203    postopek BLOB(1000) NOT NULL,
204    komentar BLOB(1000),
205    VIR_ID INT
206);
207
208ALTER TABLE TIPI_NAMENOV ADD CONSTRAINT PK_tipi_namenov PRIMARY KEY(ID), MODIFY ID INTEGER NOT NULL AUTO_INCREMENT;
209
210ALTER TABLE TIPI_JEDI ADD CONSTRAINT PK_tipi_jedi PRIMARY KEY(ID);
211
212ALTER TABLE TIPI_DOMEN ADD CONSTRAINT PK_tipi_domen PRIMARY KEY(ID);
213
214ALTER TABLE TIPI_VIROV ADD CONSTRAINT PK_tipi_virov PRIMARY KEY(id);
215
216ALTER TABLE TIPI_MASOVNIH_ENOT ADD CONSTRAINT PK_tipi_masovnih_enot PRIMARY KEY(ID);
217
218ALTER TABLE MASOVNE_KOLICINE ADD CONSTRAINT PK_masovne_kolicine PRIMARY KEY(ID);
219
220ALTER TABLE TIPI_CASOVNIH_ENOT ADD CONSTRAINT PK_tipi_casovnih_enot PRIMARY KEY(ID);
221
222ALTER TABLE CASOVNE_KOLICINE ADD CONSTRAINT PK_casovne_kolicine PRIMARY KEY(ID);
223
224ALTER TABLE CASOVI_PRIPRAV ADD CONSTRAINT PK_casovi_priprav PRIMARY KEY(ID);
225
226ALTER TABLE CASOVI_KUHANJA ADD CONSTRAINT PK_casovi_kuhanja PRIMARY KEY(ID);
227
228ALTER TABLE TIPI_VALUT ADD CONSTRAINT PK_tipi_valut PRIMARY KEY(ID);
229
230ALTER TABLE CENE ADD CONSTRAINT PK_cene PRIMARY KEY(ID);
231
232ALTER TABLE DRZAVA ADD CONSTRAINT PK_drzava PRIMARY KEY(ID);
233
234ALTER TABLE KRAJ ADD CONSTRAINT PK_kraj PRIMARY KEY(ID);
235
236ALTER TABLE ULICA ADD CONSTRAINT PK_ulica PRIMARY KEY(ID);
237
238ALTER TABLE NASLOV ADD CONSTRAINT PK_naslov PRIMARY KEY(ID);
239
240ALTER TABLE EMAIL ADD CONSTRAINT PK_email PRIMARY KEY(ID);
241
242ALTER TABLE OSEBE ADD CONSTRAINT PK_osebe PRIMARY KEY(ID);
243
244ALTER TABLE VIR ADD CONSTRAINT PK_vir PRIMARY KEY(ID), MODIFY ID INTEGER NOT NULL AUTO_INCREMENT;
245
246ALTER TABLE JEDILNIKI ADD CONSTRAINT PK_jedilniki PRIMARY KEY(ID), MODIFY ID INTEGER NOT NULL AUTO_INCREMENT;
247
248ALTER TABLE JEDI_has_JEDILNIKI ADD CONSTRAINT PK_jedi_has_jedilniki PRIMARY KEY(ID);
249
250ALTER TABLE JEDI ADD CONSTRAINT PK_jedi PRIMARY KEY(ID);
251
252ALTER TABLE TRGOVINE ADD CONSTRAINT PK_trgovine PRIMARY KEY(ID);
253
254ALTER TABLE PROIZVAJALCI_SESTAVIN ADD CONSTRAINT PK_proizvajalci_sestavin PRIMARY KEY(ID);
255
256ALTER TABLE SESTAVINE_has_TRGOVINE ADD CONSTRAINT PK_sestavine_has_trgovine PRIMARY KEY(ID);
257
258ALTER TABLE SESTAVINE_has_PROIZVAJALCI_SESTAVIN ADD CONSTRAINT PK_sestavine_has_proizvajalci_sestavin PRIMARY KEY(ID);
259
260ALTER TABLE SESTAVINE ADD CONSTRAINT PK_sestavine PRIMARY KEY(ID);
261
262ALTER TABLE RECEPTI_has_SESTAVINE ADD CONSTRAINT PK_receptI_has_sestavine PRIMARY KEY(ID);
263
264ALTER TABLE RECEPTI ADD CONSTRAINT PK_recepti PRIMARY KEY(ID);
265
266
267
268
269
270ALTER TABLE MASOVNE_KOLICINE ADD CONSTRAINT FK_masovne_kolicine FOREIGN KEY(TIPI_MASOVNIH_ENOT_ID) REFERENCES TIPI_MASOVNIH_ENOT(ID) ON DELETE CASCADE ON UPDATE CASCADE;
271
272ALTER TABLE CASOVNE_KOLICINE ADD CONSTRAINT FK_casovne_enote FOREIGN KEY(CASOVNE_ENOTE_ID) REFERENCES TIPI_CASOVNIH_ENOT(ID) ON DELETE CASCADE ON UPDATE CASCADE;
273
274ALTER TABLE CASOVI_PRIPRAV ADD CONSTRAINT FK_casovne_kolicine_priprav FOREIGN KEY(CASOVNE_KOLICINE_ID) REFERENCES CASOVNE_KOLICINE(ID) ON DELETE CASCADE ON UPDATE CASCADE;
275
276ALTER TABLE CASOVI_KUHANJA ADD CONSTRAINT FK_casovne_kolicine_kuhanja FOREIGN KEY(CASOVNE_KOLICINE_ID) REFERENCES CASOVNE_KOLICINE(ID) ON DELETE CASCADE ON UPDATE CASCADE;
277
278ALTER TABLE CENE ADD CONSTRAINT FK_tipi_valut FOREIGN KEY(TIPI_VALUT_ID) REFERENCES TIPI_VALUT(ID) ON DELETE CASCADE ON UPDATE CASCADE;
279
280ALTER TABLE KRAJ ADD CONSTRAINT FK_drzava FOREIGN KEY(DRZAVA_ID) REFERENCES DRZAVA(ID) ON DELETE CASCADE ON UPDATE CASCADE;
281
282ALTER TABLE ULICA ADD CONSTRAINT FK_kraj FOREIGN KEY(KRAJ_ID) REFERENCES KRAJ(ID) ON DELETE CASCADE ON UPDATE CASCADE;
283
284ALTER TABLE NASLOV ADD CONSTRAINT FK_ulica FOREIGN KEY(ULICA_ID) REFERENCES ULICA(ID) ON DELETE CASCADE ON UPDATE CASCADE;
285
286ALTER TABLE EMAIL ADD CONSTRAINT FK_tipi_domen FOREIGN KEY(TIPI_DOMEN_ID) REFERENCES TIPI_DOMEN(ID) ON DELETE CASCADE ON UPDATE CASCADE;
287
288ALTER TABLE OSEBE ADD CONSTRAINT FK_email FOREIGN KEY(EMAIL_ID) REFERENCES EMAIL(ID) ON DELETE CASCADE ON UPDATE CASCADE;
289
290ALTER TABLE OSEBE ADD CONSTRAINT FK_naslov FOREIGN KEY(NASLOV_ID) REFERENCES NASLOV(ID) ON DELETE CASCADE ON UPDATE CASCADE;
291
292ALTER TABLE VIR ADD CONSTRAINT FK_tipi_virov FOREIGN KEY(TIPI_VIROV_ID) REFERENCES TIPI_VIROV(ID) ON DELETE CASCADE ON UPDATE CASCADE;
293
294ALTER TABLE JEDILNIKI ADD CONSTRAINT FK_tipi_namenov FOREIGN KEY(TIPI_NAMENOV_ID) REFERENCES TIPI_NAMENOV(ID) ON DELETE CASCADE ON UPDATE CASCADE;
295
296ALTER TABLE JEDILNIKI ADD CONSTRAINT FK_osebe FOREIGN KEY(OSEBE_ID) REFERENCES OSEBE(ID) ON DELETE CASCADE ON UPDATE CASCADE;
297
298ALTER TABLE JEDI_has_JEDILNIKI ADD CONSTRAINT FK_jedi_jedilnika FOREIGN KEY(JEDI_ID) REFERENCES JEDI(ID) ON DELETE CASCADE ON UPDATE CASCADE;
299
300ALTER TABLE JEDI_has_JEDILNIKI ADD CONSTRAINT FK_jedilniki FOREIGN KEY(JEDILNIKI_ID) REFERENCES JEDILNIKI(ID) ON DELETE CASCADE ON UPDATE CASCADE;
301
302ALTER TABLE JEDI ADD CONSTRAINT FK_tipi_jedi FOREIGN KEY(TIPI_JEDI_ID) REFERENCES TIPI_JEDI(ID) ON DELETE CASCADE ON UPDATE CASCADE;
303
304ALTER TABLE TRGOVINE ADD CONSTRAINT FK_trgovine_naslov FOREIGN KEY(NASLOV_ID) REFERENCES NASLOV(ID) ON DELETE CASCADE ON UPDATE CASCADE;
305
306ALTER TABLE PROIZVAJALCI_SESTAVIN ADD CONSTRAINT FK_proizvjalaci_naslov FOREIGN KEY(NASLOV_ID) REFERENCES NASLOV(ID) ON DELETE CASCADE ON UPDATE CASCADE;
307
308ALTER TABLE SESTAVINE_has_TRGOVINE ADD CONSTRAINT FK_sestavina_trgovine FOREIGN KEY(SESTAVINE_ID) REFERENCES SESTAVINE(ID) ON DELETE CASCADE ON UPDATE CASCADE;
309
310ALTER TABLE SESTAVINE_has_TRGOVINE ADD CONSTRAINT FK_trgovina_sestavine FOREIGN KEY(TRGOVINE_ID) REFERENCES TRGOVINE(ID) ON DELETE CASCADE ON UPDATE CASCADE;
311
312ALTER TABLE SESTAVINE_has_PROIZVAJALCI_SESTAVIN ADD CONSTRAINT FK_sestavina FOREIGN KEY(SESTAVINE_ID) REFERENCES SESTAVINE(ID) ON DELETE CASCADE ON UPDATE CASCADE;
313
314ALTER TABLE SESTAVINE_has_PROIZVAJALCI_SESTAVIN ADD CONSTRAINT FK_proizvajalci_sestavine FOREIGN KEY(PROIZVAJALCI_SESTAVIN_ID) REFERENCES PROIZVAJALCI_SESTAVIN(ID) ON DELETE CASCADE ON UPDATE CASCADE;
315
316ALTER TABLE SESTAVINE ADD CONSTRAINT FK_cene FOREIGN KEY(CENE_ID) REFERENCES CENE(ID) ON DELETE CASCADE ON UPDATE CASCADE;
317
318ALTER TABLE RECEPTI_has_SESTAVINE ADD CONSTRAINT FK_recepti FOREIGN KEY(RECEPTI_ID) REFERENCES RECEPTI(ID) ON DELETE CASCADE ON UPDATE CASCADE;
319
320ALTER TABLE RECEPTI_has_SESTAVINE ADD CONSTRAINT FK_sestavine FOREIGN KEY(SESTAVINE_ID) REFERENCES SESTAVINE(ID) ON DELETE CASCADE ON UPDATE CASCADE;
321
322ALTER TABLE RECEPTI ADD CONSTRAINT FK_jed_recepta FOREIGN KEY(JEDI_ID) REFERENCES JEDI(ID) ON DELETE CASCADE ON UPDATE CASCADE;
323
324ALTER TABLE RECEPTI ADD CONSTRAINT FK_casovi_priprav_recepta FOREIGN KEY(CASOVI_PRIPRAV_ID) REFERENCES CASOVI_PRIPRAV(ID) ON DELETE CASCADE ON UPDATE CASCADE;
325
326ALTER TABLE RECEPTI ADD CONSTRAINT FK_casovi_kuhanja_recepta FOREIGN KEY(CASOVI_KUHANJA_ID) REFERENCES CASOVI_KUHANJA(ID) ON DELETE CASCADE ON UPDATE CASCADE;
327
328ALTER TABLE RECEPTI ADD CONSTRAINT FK_vir FOREIGN KEY(VIR_ID) REFERENCES VIR(ID) ON DELETE CASCADE ON UPDATE CASCADE;
329
330INSERT INTO TIPI_NAMENOV
331VALUES
332(1, "Večerja"),
333(2, "Rojstni dan"),
334(3, "Kosilo"),
335(4, "Zajterk"),
336(5, "Obletnica");
337
338INSERT INTO TIPI_JEDI
339VALUES
340(1, "Mesna jed"),
341(2, "Enolončnica"),
342(3, "Sladica"),
343(4, "Predjed"),
344(5, "Žar"),
345(6, "Juha"),
346(7, "Morska hrana"),
347(8, "Testenine"),
348(9, "Solata"),
349(10, "Kruh");
350
351INSERT INTO TIPI_DOMEN
352VALUES
353(1, "@gmail.com"),
354(2, "@yahoo.com"),
355(3, "@arnes.si"),
356(4, "@student.um.si"),
357(5, "@hotmail.com");
358
359INSERT INTO TIPI_VIROV
360VALUES
361(1, "Revija"),
362(2, "Interneta stran"),
363(3, "Zapiski"),
364(4, "Knjiga"),
365(5, "TV oddaja");
366
367INSERT INTO TIPI_MASOVNIH_ENOT
368VALUES
369(1, "kg"),
370(2, "g"),
371(3, "dg"),
372(4, "Funt"),
373(5, "ounce");
374
375INSERT INTO MASOVNE_KOLICINE
376VALUES
377(1, 2.5 , 1),
378(2, 300, 3),
379(3, 10.53, 5),
380(4, 500.5, 2),
381(5, 1, 1);
382
383INSERT INTO TIPI_CASOVNIH_ENOT
384VALUES
385(1, "s"),
386(2, "ms"),
387(3, "h"),
388(4, "min"),
389(5, "dan");
390
391INSERT INTO CASOVNE_KOLICINE
392VALUES
393(1, 2.5, 3),
394(2, 1, 5),
395(3, 25.5, 4),
396(4, 360, 1),
397(5, 10, 4);
398
399INSERT INTO CASOVI_PRIPRAV
400VALUES
401(1, 4),
402(2, 2),
403(3, 5),
404(4, 1),
405(5, 3);
406
407INSERT INTO CASOVI_KUHANJA
408VALUES
409(1, 5),
410(2, 1),
411(3, 2),
412(4, 1),
413(5, 4);
414
415INSERT INTO TIPI_VALUT
416VALUES
417(1, "Euro"),
418(2, "Dollar"),
419(3, "Funt"),
420(4, "Japonski jen"),
421(5, "Norveške krone");
422
423INSERT INTO CENE
424VALUES
425(1, 15.5, 1),
426(2, 5, 1),
427(3, 5.24, 1),
428(4, 40.2, 1),
429(5, 21.32, 1),
430(6, 7.85, 1),
431(7, 2.98, 1),
432(8, 11.12, 1),
433(9, 4.90, 1),
434(10, 10.25, 1);
435
436INSERT INTO DRZAVA
437VALUES
438(1, "Slovenija"),
439(2, "Italija"),
440(3, "Avstrija"),
441(4, "Nemčija"),
442(5, "Norveška");
443
444INSERT INTO KRAJ
445VALUES
446(1, "Maribor", 1),
447(2, "Bergen", 5),
448(3, "Dunaj", 3),
449(4, "Berlin", 4),
450(5, "Milan", 2);
451
452INSERT INTO ULICA
453VALUES
454(1, "Kirchberggasse", 3),
455(2, "Fasanenstraße", 4),
456(3, "Smetanova ulica", 1),
457(4, "Markeveien", 2),
458(5, "Via Orefici", 5),
459(6, "Sparebanksgaten", 2),
460(7, "Krausnickstraße", 4),
461(8, "Via Pola", 5),
462(9, "Gosposvetska ulica", 1),
463(10, "Pappenheimgasse", 3);
464
465INSERT INTO NASLOV
466VALUES
467(1, 8, 3),
468(2, 25, 4),
469(3, 17, 2),
470(4, 75, 5),
471(5, 53, 1),
472(6, 21, 7),
473(7, 1, 10),
474(8, 67, 6),
475(9, 19, 9),
476(10, 5, 8);
477
478INSERT INTO EMAIL
479VALUES
480(1, "ethan.hunt", 1),
481(2, "jack.ryan", 1),
482(3, "ivan.cankar", 2),
483(4, "jason.bourne", 1),
484(5, "james.bond", 3);
485
486INSERT INTO OSEBE
487VALUES
488(1, "John", "McClane", NULL, 5),
489(2, "Indiana", "Jones", NULL, 3),
490(3, "Han", "Solo", NULL, 1),
491(4, "John", "Rambo", NULL, 2),
492(5, "Martin", "Riggs", NULL, 4),
493(6, NULL, NULL, 5, 7),
494(7, NULL, NULL, 2, 9),
495(8, NULL, NULL, 4, NULL),
496(9, NULL, NULL, 1, 10),
497(10, NULL, NULL, 3, NULL);
498
499INSERT INTO JEDI
500VALUES
501(1, "Mehiška tortilja", 1),
502(2, "Lazanja", 1),
503(3, "Musaka", 1),
504(4, "Pasulj", 2),
505(5, "Jota", 2),
506(6, "Ričet", 2),
507(7, "ÄŒokoladno - mascarponejeve kocke", 3),
508(8, "Torta Nutella", 3),
509(9, "Skutino pecivo za požerešne sosede", 3),
510(10, "Sirov Å¡trukelj", 4),
511(11, "Slani polžli", 4),
512(12, "Domači hitri namaz", 4),
513(13, "Reberca na žaru v pivski omaki", 5),
514(14, "Mesna nabodala", 5);
515
516INSERT INTO JEDILNIKI
517VALUES
518(1, '2017-05-25', 2, 1),
519(2,'2017-12-05', NULL, NULL),
520(3, '2018-04-04', 7, 3),
521(4, '2018-01-25', 4, 8),
522(5, '2018-10-20', NULL, 5);
523
524INSERT INTO JEDI_has_JEDILNIKI
525VALUES
526(1 ,2 , 1),
527(2 ,11 , 1),
528(3 ,4 , 4),
529(4 ,4 , 4),
530(5 ,3 , 2),
531(6 ,8 , 2),
532(7 ,7 , 3),
533(8 ,2 , 5),
534(9 ,13 , 5),
535(10 ,11 , 5);
536
537INSERT INTO TRGOVINE
538VALUES
539(1, "Mercator", 4),
540(2, "Spar", 1),
541(3, "Tuš", 2),
542(4, "Lidl", 8),
543(5, "Hofer", 10);
544
545INSERT INTO PROIZVAJALCI_SESTAVIN
546VALUES
547(1, "Zelene doline", 3),
548(2, "Anton", 7),
549(3, "Podravka", 6),
550(4, "Barilla", 9),
551(5, "Mlinotest", 5);
552
553INSERT INTO SESTAVINE
554VALUES
555(1, "Moka", NULL),
556(2, "Maslo", 2),
557(3, "Mleto meso", 1),
558(4, "Listnate testenine", 3),
559(5, "Ješprenj", 5),
560(6, "Jajca", NULL),
561(7, "Sir", 8),
562(8, "Reberca", 10),
563(9, "Svinjina", 4),
564(10, "Koruza", 9);
565
566INSERT INTO SESTAVINE_has_TRGOVINE
567VALUES
568(1, 1, 4),
569(2, 1, 2), 
570(3, 6, NULL),
571(4, 3, 1),
572(5, 8, 4),
573(6, 5, 1),
574(7, 3, 3),
575(7, 3, 5),
576(8, 2, NULL),
577(9, 7, 3),
578(10, 9, 1),
579(11, 9, 4),
580(12, 4, 2),
581(13, 2, 3),
582(13, 8, 2),
583(14, 5, 5),
584(15, 1, 3);
585
586INSERT INTO SESTAVINE_has_PROIZVAJALCI_SESTAVIN
587VALUES
588(1, 1, 4),
589(2, 2, 2), 
590(3, 6, NULL),
591(4, 3, 1),
592(5, 8, 4),
593(6, 3, NULL),
594(7, 10, 3),
595(7, 3, 5),
596(8, 2, NULL),
597(9, 7, 3),
598(10, 10, 1),
599(11, 9, 4),
600(12, 4, 2),
601(13, 5, NULL),
602(13, 8, 2),
603(14, 6, 5),
604(15, 1, 3);
605
606/*NSERT INTO RECEPTI
607VALUES
608(1, 7, 2, 5 , 
609"Penasto umešamo jajca in sladkor ter dodamo moko in kakav. Zlijemo v velik pekač, obložen s peki papirjem...", NULL, 3),
610(2, 2, 1, 3 , 
611"Mesni nadev:na olju prepražimo sesekljano čebulo, dodamo mleto meso in vse začimbe ter vse skupaj dušimo 15 minut. Na koncu mesni omaki ...", NULL, 1),
612(3, 13, 4 ,1 ,
613
614
615
616
617INSERT INTO RECEPTI_has_SESTAVINE
618VALUES
619(1, 1, 4),
620(2, 2, 2), 
621(3, 6, NULL),
622(4, 7, 1),
623(5, 7, 2),
624(6, 7, 6),
625(7, 13, 8),
626(7, 13, 5),
627(8, 13, NULL),
628(9, 13, 3),
629(10, 10, 1),
630(11, 9, 4),
631(12, 4, 2),
632(13, 5, NULL),
633(13, 8, 2),
634(14, 6, 5),
635(15, 1, 3);*/