· 6 years ago · Mar 26, 2019, 09:30 PM
1--
2-- PostgreSQL database dump
3--
4
5SET statement_timeout = 0;
6SET client_encoding = 'UTF8';
7SET standard_conforming_strings = on;
8SET check_function_bodies = false;
9SET client_min_messages = warning;
10
11--
12-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
13--
14
15CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
16
17
18--
19-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
20--
21
22COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
23
24
25SET search_path = public, pg_catalog;
26
27SET default_tablespace = '';
28
29SET default_with_oids = false;
30
31--
32-- Name: autor; Type: TABLE; Schema: public; Owner: student; Tablespace:
33--
34
35CREATE TABLE autor (
36 sifra integer NOT NULL,
37 ime character varying(20) NOT NULL,
38 prezime character varying(20) NOT NULL
39);
40
41
42ALTER TABLE public.autor OWNER TO student;
43
44--
45-- Name: autor_knjige; Type: TABLE; Schema: public; Owner: student; Tablespace:
46--
47
48CREATE TABLE autor_knjige (
49 knjiga integer NOT NULL,
50 autor integer NOT NULL
51);
52
53
54ALTER TABLE public.autor_knjige OWNER TO student;
55
56--
57-- Name: autor_sifra_seq; Type: SEQUENCE; Schema: public; Owner: student
58--
59
60CREATE SEQUENCE autor_sifra_seq
61 START WITH 1
62 INCREMENT BY 1
63 NO MINVALUE
64 NO MAXVALUE
65 CACHE 1;
66
67
68ALTER TABLE public.autor_sifra_seq OWNER TO student;
69
70--
71-- Name: autor_sifra_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: student
72--
73
74ALTER SEQUENCE autor_sifra_seq OWNED BY autor.sifra;
75
76
77--
78-- Name: brojac; Type: SEQUENCE; Schema: public; Owner: student
79--
80
81CREATE SEQUENCE brojac
82 START WITH 1
83 INCREMENT BY 1
84 NO MINVALUE
85 NO MAXVALUE
86 CACHE 1;
87
88
89ALTER TABLE public.brojac OWNER TO student;
90
91--
92-- Name: clan; Type: TABLE; Schema: public; Owner: student; Tablespace:
93--
94
95CREATE TABLE clan (
96 sifra integer NOT NULL,
97 ime character varying(20) NOT NULL,
98 prezime character varying(20) NOT NULL,
99 adresa character varying(50) NOT NULL
100);
101
102
103ALTER TABLE public.clan OWNER TO student;
104
105--
106-- Name: clan_sifra_seq; Type: SEQUENCE; Schema: public; Owner: student
107--
108
109CREATE SEQUENCE clan_sifra_seq
110 START WITH 1
111 INCREMENT BY 1
112 NO MINVALUE
113 NO MAXVALUE
114 CACHE 1;
115
116
117ALTER TABLE public.clan_sifra_seq OWNER TO student;
118
119--
120-- Name: clan_sifra_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: student
121--
122
123ALTER SEQUENCE clan_sifra_seq OWNED BY clan.sifra;
124
125
126--
127-- Name: izdavac; Type: TABLE; Schema: public; Owner: student; Tablespace:
128--
129
130CREATE TABLE izdavac (
131 sifra integer NOT NULL,
132 naziv character varying(50) NOT NULL
133);
134
135
136ALTER TABLE public.izdavac OWNER TO student;
137
138--
139-- Name: izdavac_sifra_seq; Type: SEQUENCE; Schema: public; Owner: student
140--
141
142CREATE SEQUENCE izdavac_sifra_seq
143 START WITH 1
144 INCREMENT BY 1
145 NO MINVALUE
146 NO MAXVALUE
147 CACHE 1;
148
149
150ALTER TABLE public.izdavac_sifra_seq OWNER TO student;
151
152--
153-- Name: izdavac_sifra_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: student
154--
155
156ALTER SEQUENCE izdavac_sifra_seq OWNED BY izdavac.sifra;
157
158
159--
160-- Name: knjiga; Type: TABLE; Schema: public; Owner: student; Tablespace:
161--
162
163CREATE TABLE knjiga (
164 sifra integer NOT NULL,
165 isbn character varying(15),
166 naziv character varying(50) NOT NULL,
167 godina smallint NOT NULL,
168 izdavac integer,
169 CONSTRAINT knjiga_godina_check CHECK (((godina > 1970) AND (godina < 2050)))
170);
171
172
173ALTER TABLE public.knjiga OWNER TO student;
174
175--
176-- Name: knjiga_sifra_seq; Type: SEQUENCE; Schema: public; Owner: student
177--
178
179CREATE SEQUENCE knjiga_sifra_seq
180 START WITH 1
181 INCREMENT BY 1
182 NO MINVALUE
183 NO MAXVALUE
184 CACHE 1;
185
186
187ALTER TABLE public.knjiga_sifra_seq OWNER TO student;
188
189--
190-- Name: knjiga_sifra_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: student
191--
192
193ALTER SEQUENCE knjiga_sifra_seq OWNED BY knjiga.sifra;
194
195
196--
197-- Name: posudba; Type: TABLE; Schema: public; Owner: student; Tablespace:
198--
199
200CREATE TABLE posudba (
201 clan integer NOT NULL,
202 datum_posudbe date NOT NULL,
203 datum_vracanja date,
204 knjiga integer NOT NULL
205);
206
207
208ALTER TABLE public.posudba OWNER TO student;
209
210--
211-- Name: sifra; Type: DEFAULT; Schema: public; Owner: student
212--
213
214ALTER TABLE ONLY autor ALTER COLUMN sifra SET DEFAULT nextval('autor_sifra_seq'::regclass);
215
216
217--
218-- Name: sifra; Type: DEFAULT; Schema: public; Owner: student
219--
220
221ALTER TABLE ONLY clan ALTER COLUMN sifra SET DEFAULT nextval('clan_sifra_seq'::regclass);
222
223
224--
225-- Name: sifra; Type: DEFAULT; Schema: public; Owner: student
226--
227
228ALTER TABLE ONLY izdavac ALTER COLUMN sifra SET DEFAULT nextval('izdavac_sifra_seq'::regclass);
229
230
231--
232-- Name: sifra; Type: DEFAULT; Schema: public; Owner: student
233--
234
235ALTER TABLE ONLY knjiga ALTER COLUMN sifra SET DEFAULT nextval('knjiga_sifra_seq'::regclass);
236
237
238--
239-- Data for Name: autor; Type: TABLE DATA; Schema: public; Owner: student
240--
241
242COPY autor (sifra, ime, prezime) FROM stdin;
2431 Slavko Tkalac
2442 Mirko ÄŒubrilo
2453 Mario Radovan
2464 Vjeran Strahonja
2475 Miroslav Žugaj
2486 Miroslav BaÄa
2497 Cristopher Date
250\.
251
252
253--
254-- Data for Name: autor_knjige; Type: TABLE DATA; Schema: public; Owner: student
255--
256
257COPY autor_knjige (knjiga, autor) FROM stdin;
258\.
259
260
261--
262-- Name: autor_sifra_seq; Type: SEQUENCE SET; Schema: public; Owner: student
263--
264
265SELECT pg_catalog.setval('autor_sifra_seq', 7, true);
266
267
268--
269-- Name: brojac; Type: SEQUENCE SET; Schema: public; Owner: student
270--
271
272SELECT pg_catalog.setval('brojac', 121, true);
273
274
275--
276-- Data for Name: clan; Type: TABLE DATA; Schema: public; Owner: student
277--
278
279COPY clan (sifra, ime, prezime, adresa) FROM stdin;
280\.
281
282
283--
284-- Name: clan_sifra_seq; Type: SEQUENCE SET; Schema: public; Owner: student
285--
286
287SELECT pg_catalog.setval('clan_sifra_seq', 1, false);
288
289
290--
291-- Data for Name: izdavac; Type: TABLE DATA; Schema: public; Owner: student
292--
293
294COPY izdavac (sifra, naziv) FROM stdin;
2951 DRIP
2962 Informator
2973 Narodne novine
2984 Addison Wesley
299\.
300
301
302--
303-- Name: izdavac_sifra_seq; Type: SEQUENCE SET; Schema: public; Owner: student
304--
305
306SELECT pg_catalog.setval('izdavac_sifra_seq', 4, true);
307
308
309--
310-- Data for Name: knjiga; Type: TABLE DATA; Schema: public; Owner: student
311--
312
313COPY knjiga (sifra, isbn, naziv, godina, izdavac) FROM stdin;
3144 \N Relacijski model podataka 1993 1
3155 \N Visual Basic, vizualni pristup programiranju 1994 1
3166 \N MatematiÄka logika za ekspertne sisteme 1989 2
3177 \N Programiranje u Prologu 1990 2
3188 \N Baze podataka: relacijski pristup i SQL 1993 2
3199 \N Projektiranje informacijskih sistema 1989 2
32010 \N Informacijski sustavi proizvodnje 1992 2
32111 \N Uvod u raÄunalnu sigurnost 2004 3
32212 \N An Introduction to Database Systems 2004 4
32313 \N What not how – the business rules approach 2000 4
324\.
325
326
327--
328-- Name: knjiga_sifra_seq; Type: SEQUENCE SET; Schema: public; Owner: student
329--
330
331SELECT pg_catalog.setval('knjiga_sifra_seq', 13, true);
332
333
334--
335-- Data for Name: posudba; Type: TABLE DATA; Schema: public; Owner: student
336--
337
338COPY posudba (clan, datum_posudbe, datum_vracanja, knjiga) FROM stdin;
339\.
340
341
342--
343-- Name: autor_knjige_pkey; Type: CONSTRAINT; Schema: public; Owner: student; Tablespace:
344--
345
346ALTER TABLE ONLY autor_knjige
347 ADD CONSTRAINT autor_knjige_pkey PRIMARY KEY (knjiga, autor);
348
349
350--
351-- Name: autor_pkey; Type: CONSTRAINT; Schema: public; Owner: student; Tablespace:
352--
353
354ALTER TABLE ONLY autor
355 ADD CONSTRAINT autor_pkey PRIMARY KEY (sifra);
356
357
358--
359-- Name: clan_pkey; Type: CONSTRAINT; Schema: public; Owner: student; Tablespace:
360--
361
362ALTER TABLE ONLY clan
363 ADD CONSTRAINT clan_pkey PRIMARY KEY (sifra);
364
365
366--
367-- Name: izdavac_pkey; Type: CONSTRAINT; Schema: public; Owner: student; Tablespace:
368--
369
370ALTER TABLE ONLY izdavac
371 ADD CONSTRAINT izdavac_pkey PRIMARY KEY (sifra);
372
373
374--
375-- Name: knjiga_pkey; Type: CONSTRAINT; Schema: public; Owner: student; Tablespace:
376--
377
378ALTER TABLE ONLY knjiga
379 ADD CONSTRAINT knjiga_pkey PRIMARY KEY (sifra);
380
381
382--
383-- Name: posudba_pkey; Type: CONSTRAINT; Schema: public; Owner: student; Tablespace:
384--
385
386ALTER TABLE ONLY posudba
387 ADD CONSTRAINT posudba_pkey PRIMARY KEY (clan, datum_posudbe, knjiga);
388
389
390--
391-- Name: i2; Type: INDEX; Schema: public; Owner: student; Tablespace:
392--
393
394CREATE UNIQUE INDEX i2 ON autor USING btree (prezime, ime);
395
396
397--
398-- Name: i3; Type: INDEX; Schema: public; Owner: student; Tablespace:
399--
400
401CREATE UNIQUE INDEX i3 ON izdavac USING btree (naziv);
402
403
404--
405-- Name: i4; Type: INDEX; Schema: public; Owner: student; Tablespace:
406--
407
408CREATE UNIQUE INDEX i4 ON clan USING btree (prezime, ime);
409
410
411--
412-- Name: i5; Type: INDEX; Schema: public; Owner: student; Tablespace:
413--
414
415CREATE UNIQUE INDEX i5 ON posudba USING btree (datum_posudbe, datum_vracanja);
416
417
418--
419-- Name: autor_knjige_autor_fkey; Type: FK CONSTRAINT; Schema: public; Owner: student
420--
421
422ALTER TABLE ONLY autor_knjige
423 ADD CONSTRAINT autor_knjige_autor_fkey FOREIGN KEY (autor) REFERENCES autor(sifra);
424
425
426--
427-- Name: autor_knjige_knjiga_fkey; Type: FK CONSTRAINT; Schema: public; Owner: student
428--
429
430ALTER TABLE ONLY autor_knjige
431 ADD CONSTRAINT autor_knjige_knjiga_fkey FOREIGN KEY (knjiga) REFERENCES knjiga(sifra);
432
433
434--
435-- Name: knjiga_izdavac_fkey; Type: FK CONSTRAINT; Schema: public; Owner: student
436--
437
438ALTER TABLE ONLY knjiga
439 ADD CONSTRAINT knjiga_izdavac_fkey FOREIGN KEY (izdavac) REFERENCES izdavac(sifra) ON UPDATE CASCADE ON DELETE RESTRICT;
440
441
442--
443-- Name: posudba_clan_fkey; Type: FK CONSTRAINT; Schema: public; Owner: student
444--
445
446ALTER TABLE ONLY posudba
447 ADD CONSTRAINT posudba_clan_fkey FOREIGN KEY (clan) REFERENCES clan(sifra);
448
449
450--
451-- Name: posudba_knjiga_fkey; Type: FK CONSTRAINT; Schema: public; Owner: student
452--
453
454ALTER TABLE ONLY posudba
455 ADD CONSTRAINT posudba_knjiga_fkey FOREIGN KEY (knjiga) REFERENCES knjiga(sifra);
456
457
458--
459-- Name: public; Type: ACL; Schema: -; Owner: postgres
460--
461
462REVOKE ALL ON SCHEMA public FROM PUBLIC;
463REVOKE ALL ON SCHEMA public FROM postgres;
464GRANT ALL ON SCHEMA public TO postgres;
465GRANT ALL ON SCHEMA public TO PUBLIC;
466
467
468--
469-- PostgreSQL database dump complete
470--
471
472
473--
474-- PostgreSQL database dump
475--
476
477-- Dumped from database version 10.6 (Ubuntu 10.6-0ubuntu0.18.10.1)
478-- Dumped by pg_dump version 10.6 (Ubuntu 10.6-0ubuntu0.18.10.1)
479
480SET statement_timeout = 0;
481SET lock_timeout = 0;
482SET idle_in_transaction_session_timeout = 0;
483SET client_encoding = 'UTF8';
484SET standard_conforming_strings = on;
485SELECT pg_catalog.set_config('search_path', '', false);
486SET check_function_bodies = false;
487SET client_min_messages = warning;
488SET row_security = off;
489
490--
491-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
492--
493
494CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
495
496
497--
498-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
499--
500
501COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
502
503
504SET default_tablespace = '';
505
506SET default_with_oids = false;
507
508--
509-- Name: autor; Type: TABLE; Schema: public; Owner: student1
510--
511
512CREATE TABLE public.autor (
513 sifra character varying(10) NOT NULL,
514 ime character varying(20) NOT NULL,
515 prezime character varying(20) NOT NULL
516);
517
518
519ALTER TABLE public.autor OWNER TO student1;
520
521--
522-- Name: autor_knjige; Type: TABLE; Schema: public; Owner: student1
523--
524
525CREATE TABLE public.autor_knjige (
526 knjiga character varying(10) NOT NULL,
527 autor character varying(10) NOT NULL
528);
529
530
531ALTER TABLE public.autor_knjige OWNER TO student1;
532
533--
534-- Name: autor_sifra_seq; Type: SEQUENCE; Schema: public; Owner: student1
535--
536
537CREATE SEQUENCE public.autor_sifra_seq
538 START WITH 1
539 INCREMENT BY 1
540 NO MINVALUE
541 NO MAXVALUE
542 CACHE 1;
543
544
545ALTER TABLE public.autor_sifra_seq OWNER TO student1;
546
547--
548-- Name: autor_sifra_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: student1
549--
550
551ALTER SEQUENCE public.autor_sifra_seq OWNED BY public.autor.sifra;
552
553
554--
555-- Name: brojac; Type: SEQUENCE; Schema: public; Owner: student1
556--
557
558CREATE SEQUENCE public.brojac
559 START WITH 1
560 INCREMENT BY 1
561 NO MINVALUE
562 NO MAXVALUE
563 CACHE 1;
564
565
566ALTER TABLE public.brojac OWNER TO student1;
567
568--
569-- Name: clan; Type: TABLE; Schema: public; Owner: student1
570--
571
572CREATE TABLE public.clan (
573 sifra character varying(10) NOT NULL,
574 ime character varying(20) NOT NULL,
575 prezime character varying(20) NOT NULL,
576 adresa character varying(50) NOT NULL
577);
578
579
580ALTER TABLE public.clan OWNER TO student1;
581
582--
583-- Name: clan_sifra_seq; Type: SEQUENCE; Schema: public; Owner: student1
584--
585
586CREATE SEQUENCE public.clan_sifra_seq
587 START WITH 1
588 INCREMENT BY 1
589 NO MINVALUE
590 NO MAXVALUE
591 CACHE 1;
592
593
594ALTER TABLE public.clan_sifra_seq OWNER TO student1;
595
596--
597-- Name: clan_sifra_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: student1
598--
599
600ALTER SEQUENCE public.clan_sifra_seq OWNED BY public.clan.sifra;
601
602
603--
604-- Name: izdavac; Type: TABLE; Schema: public; Owner: student1
605--
606
607CREATE TABLE public.izdavac (
608 sifra character varying(10) NOT NULL,
609 naziv character varying(50) NOT NULL
610);
611
612
613ALTER TABLE public.izdavac OWNER TO student1;
614
615--
616-- Name: izdavac_sifra_seq; Type: SEQUENCE; Schema: public; Owner: student1
617--
618
619CREATE SEQUENCE public.izdavac_sifra_seq
620 START WITH 1
621 INCREMENT BY 1
622 NO MINVALUE
623 NO MAXVALUE
624 CACHE 1;
625
626
627ALTER TABLE public.izdavac_sifra_seq OWNER TO student1;
628
629--
630-- Name: izdavac_sifra_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: student1
631--
632
633ALTER SEQUENCE public.izdavac_sifra_seq OWNED BY public.izdavac.sifra;
634
635
636--
637-- Name: knjiga; Type: TABLE; Schema: public; Owner: student1
638--
639
640CREATE TABLE public.knjiga (
641 sifra character varying(50) NOT NULL,
642 isbn character varying(15),
643 naziv character varying(50) NOT NULL,
644 godina smallint,
645 izdavac character varying(10),
646 CONSTRAINT knjiga_godina_check CHECK (((godina > 1970) AND (godina < 2050)))
647);
648
649
650ALTER TABLE public.knjiga OWNER TO student1;
651
652--
653-- Name: knjiga_sifra_seq; Type: SEQUENCE; Schema: public; Owner: student1
654--
655
656CREATE SEQUENCE public.knjiga_sifra_seq
657 START WITH 1
658 INCREMENT BY 1
659 NO MINVALUE
660 NO MAXVALUE
661 CACHE 1;
662
663
664ALTER TABLE public.knjiga_sifra_seq OWNER TO student1;
665
666--
667-- Name: knjiga_sifra_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: student1
668--
669
670ALTER SEQUENCE public.knjiga_sifra_seq OWNED BY public.knjiga.sifra;
671
672
673--
674-- Name: posudba; Type: TABLE; Schema: public; Owner: student1
675--
676
677CREATE TABLE public.posudba (
678 clan character varying(10) NOT NULL,
679 datum_posudbe date NOT NULL,
680 datum_vracanja date,
681 knjiga character varying(10) NOT NULL
682);
683
684
685ALTER TABLE public.posudba OWNER TO student1;
686
687--
688-- Name: autor sifra; Type: DEFAULT; Schema: public; Owner: student1
689--
690
691ALTER TABLE ONLY public.autor ALTER COLUMN sifra SET DEFAULT nextval('public.autor_sifra_seq'::regclass);
692
693
694--
695-- Name: clan sifra; Type: DEFAULT; Schema: public; Owner: student1
696--
697
698ALTER TABLE ONLY public.clan ALTER COLUMN sifra SET DEFAULT nextval('public.clan_sifra_seq'::regclass);
699
700
701--
702-- Name: izdavac sifra; Type: DEFAULT; Schema: public; Owner: student1
703--
704
705ALTER TABLE ONLY public.izdavac ALTER COLUMN sifra SET DEFAULT nextval('public.izdavac_sifra_seq'::regclass);
706
707
708--
709-- Name: knjiga sifra; Type: DEFAULT; Schema: public; Owner: student1
710--
711
712ALTER TABLE ONLY public.knjiga ALTER COLUMN sifra SET DEFAULT nextval('public.knjiga_sifra_seq'::regclass);
713
714
715--
716-- Data for Name: autor; Type: TABLE DATA; Schema: public; Owner: student1
717--
718
719COPY public.autor (sifra, ime, prezime) FROM stdin;
720\.
721
722
723--
724-- Data for Name: autor_knjige; Type: TABLE DATA; Schema: public; Owner: student1
725--
726
727COPY public.autor_knjige (knjiga, autor) FROM stdin;
728\.
729
730
731--
732-- Data for Name: clan; Type: TABLE DATA; Schema: public; Owner: student1
733--
734
735COPY public.clan (sifra, ime, prezime, adresa) FROM stdin;
736\.
737
738
739--
740-- Data for Name: izdavac; Type: TABLE DATA; Schema: public; Owner: student1
741--
742
743COPY public.izdavac (sifra, naziv) FROM stdin;
744\.
745
746
747--
748-- Data for Name: knjiga; Type: TABLE DATA; Schema: public; Owner: student1
749--
750
751COPY public.knjiga (sifra, isbn, naziv, godina, izdavac) FROM stdin;
752\.
753
754
755--
756-- Data for Name: posudba; Type: TABLE DATA; Schema: public; Owner: student1
757--
758
759COPY public.posudba (clan, datum_posudbe, datum_vracanja, knjiga) FROM stdin;
760\.
761
762
763--
764-- Name: autor_sifra_seq; Type: SEQUENCE SET; Schema: public; Owner: student1
765--
766
767SELECT pg_catalog.setval('public.autor_sifra_seq', 1, false);
768
769
770--
771-- Name: brojac; Type: SEQUENCE SET; Schema: public; Owner: student1
772--
773
774SELECT pg_catalog.setval('public.brojac', 1, false);
775
776
777--
778-- Name: clan_sifra_seq; Type: SEQUENCE SET; Schema: public; Owner: student1
779--
780
781SELECT pg_catalog.setval('public.clan_sifra_seq', 1, false);
782
783
784--
785-- Name: izdavac_sifra_seq; Type: SEQUENCE SET; Schema: public; Owner: student1
786--
787
788SELECT pg_catalog.setval('public.izdavac_sifra_seq', 1, false);
789
790
791--
792-- Name: knjiga_sifra_seq; Type: SEQUENCE SET; Schema: public; Owner: student1
793--
794
795SELECT pg_catalog.setval('public.knjiga_sifra_seq', 1, false);
796
797
798--
799-- Name: autor autor_pkey; Type: CONSTRAINT; Schema: public; Owner: student1
800--
801
802ALTER TABLE ONLY public.autor
803 ADD CONSTRAINT autor_pkey PRIMARY KEY (sifra);
804
805
806--
807-- Name: clan clan_pkey; Type: CONSTRAINT; Schema: public; Owner: student1
808--
809
810ALTER TABLE ONLY public.clan
811 ADD CONSTRAINT clan_pkey PRIMARY KEY (sifra);
812
813
814--
815-- Name: izdavac izdavac_pkey; Type: CONSTRAINT; Schema: public; Owner: student1
816--
817
818ALTER TABLE ONLY public.izdavac
819 ADD CONSTRAINT izdavac_pkey PRIMARY KEY (sifra);
820
821
822--
823-- Name: knjiga knjiga_pkey; Type: CONSTRAINT; Schema: public; Owner: student1
824--
825
826ALTER TABLE ONLY public.knjiga
827 ADD CONSTRAINT knjiga_pkey PRIMARY KEY (sifra);
828
829
830--
831-- Name: autor_knjige pk1; Type: CONSTRAINT; Schema: public; Owner: student1
832--
833
834ALTER TABLE ONLY public.autor_knjige
835 ADD CONSTRAINT pk1 PRIMARY KEY (knjiga, autor);
836
837
838--
839-- Name: posudba pk2; Type: CONSTRAINT; Schema: public; Owner: student1
840--
841
842ALTER TABLE ONLY public.posudba
843 ADD CONSTRAINT pk2 PRIMARY KEY (clan, datum_posudbe, knjiga);
844
845
846--
847-- Name: autor_knjige autor_knjige_autor_fkey; Type: FK CONSTRAINT; Schema: public; Owner: student1
848--
849
850ALTER TABLE ONLY public.autor_knjige
851 ADD CONSTRAINT autor_knjige_autor_fkey FOREIGN KEY (autor) REFERENCES public.autor(sifra);
852
853
854--
855-- Name: autor_knjige autor_knjige_knjiga_fkey; Type: FK CONSTRAINT; Schema: public; Owner: student1
856--
857
858ALTER TABLE ONLY public.autor_knjige
859 ADD CONSTRAINT autor_knjige_knjiga_fkey FOREIGN KEY (knjiga) REFERENCES public.knjiga(sifra);
860
861
862--
863-- Name: knjiga knjiga_izdavac_fkey; Type: FK CONSTRAINT; Schema: public; Owner: student1
864--
865
866ALTER TABLE ONLY public.knjiga
867 ADD CONSTRAINT knjiga_izdavac_fkey FOREIGN KEY (izdavac) REFERENCES public.izdavac(sifra) ON UPDATE CASCADE ON DELETE RESTRICT;
868
869
870--
871-- Name: posudba posudba_clan_fkey; Type: FK CONSTRAINT; Schema: public; Owner: student1
872--
873
874ALTER TABLE ONLY public.posudba
875 ADD CONSTRAINT posudba_clan_fkey FOREIGN KEY (clan) REFERENCES public.clan(sifra);
876
877
878--
879-- Name: posudba posudba_knjiga_fkey; Type: FK CONSTRAINT; Schema: public; Owner: student1
880--
881
882ALTER TABLE ONLY public.posudba
883 ADD CONSTRAINT posudba_knjiga_fkey FOREIGN KEY (knjiga) REFERENCES public.knjiga(sifra);
884
885
886--
887-- PostgreSQL database dump complete
888--