pn1nkL1q

1--
2-- PostgreSQL database dump
3--
4
5-- Dumped from database version 10.6 (Ubuntu 10.6-0ubuntu0.18.10.1)
6-- Dumped by pg_dump version 10.6 (Ubuntu 10.6-0ubuntu0.18.10.1)
7
8SET statement_timeout = 0;
9SET lock_timeout = 0;
10SET idle_in_transaction_session_timeout = 0;
11SET client_encoding = 'UTF8';
12SET standard_conforming_strings = on;
13SELECT pg_catalog.set_config('search_path', '', false);
14SET check_function_bodies = false;
15SET client_min_messages = warning;
16SET row_security = off;
17
18--
19-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
20--
21
22CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
23
24
25--
26-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 
27--
28
29COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
30
31
32SET default_tablespace = '';
33
34SET default_with_oids = false;
35
36--
37-- Name: autor; Type: TABLE; Schema: public; Owner: student1
38--
39
40CREATE TABLE public.autor (
41    sifra character varying(10) NOT NULL,
42    ime character varying(20) NOT NULL,
43    prezime character varying(20) NOT NULL
44);
45
46
47ALTER TABLE public.autor OWNER TO student1;
48
49--
50-- Name: autor_knjige; Type: TABLE; Schema: public; Owner: student1
51--
52
53CREATE TABLE public.autor_knjige (
54    knjiga character varying(10) NOT NULL,
55    autor character varying(10) NOT NULL
56);
57
58
59ALTER TABLE public.autor_knjige OWNER TO student1;
60
61--
62-- Name: autor_sifra_seq; Type: SEQUENCE; Schema: public; Owner: student1
63--
64
65CREATE SEQUENCE public.autor_sifra_seq
66    START WITH 1
67    INCREMENT BY 1
68    NO MINVALUE
69    NO MAXVALUE
70    CACHE 1;
71
72
73ALTER TABLE public.autor_sifra_seq OWNER TO student1;
74
75--
76-- Name: autor_sifra_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: student1
77--
78
79ALTER SEQUENCE public.autor_sifra_seq OWNED BY public.autor.sifra;
80
81
82--
83-- Name: brojac; Type: SEQUENCE; Schema: public; Owner: student1
84--
85
86CREATE SEQUENCE public.brojac
87    START WITH 1
88    INCREMENT BY 1
89    NO MINVALUE
90    NO MAXVALUE
91    CACHE 1;
92
93
94ALTER TABLE public.brojac OWNER TO student1;
95
96--
97-- Name: clan; Type: TABLE; Schema: public; Owner: student1
98--
99
100CREATE TABLE public.clan (
101    sifra character varying(10) NOT NULL,
102    ime character varying(20) NOT NULL,
103    prezime character varying(20) NOT NULL,
104    adresa character varying(50) NOT NULL
105);
106
107
108ALTER TABLE public.clan OWNER TO student1;
109
110--
111-- Name: clan_sifra_seq; Type: SEQUENCE; Schema: public; Owner: student1
112--
113
114CREATE SEQUENCE public.clan_sifra_seq
115    START WITH 1
116    INCREMENT BY 1
117    NO MINVALUE
118    NO MAXVALUE
119    CACHE 1;
120
121
122ALTER TABLE public.clan_sifra_seq OWNER TO student1;
123
124--
125-- Name: clan_sifra_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: student1
126--
127
128ALTER SEQUENCE public.clan_sifra_seq OWNED BY public.clan.sifra;
129
130
131--
132-- Name: izdavac; Type: TABLE; Schema: public; Owner: student1
133--
134
135CREATE TABLE public.izdavac (
136    sifra character varying(10) NOT NULL,
137    naziv character varying(50) NOT NULL
138);
139
140
141ALTER TABLE public.izdavac OWNER TO student1;
142
143--
144-- Name: izdavac_sifra_seq; Type: SEQUENCE; Schema: public; Owner: student1
145--
146
147CREATE SEQUENCE public.izdavac_sifra_seq
148    START WITH 1
149    INCREMENT BY 1
150    NO MINVALUE
151    NO MAXVALUE
152    CACHE 1;
153
154
155ALTER TABLE public.izdavac_sifra_seq OWNER TO student1;
156
157--
158-- Name: izdavac_sifra_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: student1
159--
160
161ALTER SEQUENCE public.izdavac_sifra_seq OWNED BY public.izdavac.sifra;
162
163
164--
165-- Name: knjiga; Type: TABLE; Schema: public; Owner: student1
166--
167
168CREATE TABLE public.knjiga (
169    sifra character varying(50) NOT NULL,
170    isbn character varying(15),
171    naziv character varying(50) NOT NULL,
172    godina smallint,
173    izdavac character varying(10),
174    CONSTRAINT knjiga_godina_check CHECK (((godina > 1970) AND (godina < 2050)))
175);
176
177
178ALTER TABLE public.knjiga OWNER TO student1;
179
180--
181-- Name: knjiga_sifra_seq; Type: SEQUENCE; Schema: public; Owner: student1
182--
183
184CREATE SEQUENCE public.knjiga_sifra_seq
185    START WITH 1
186    INCREMENT BY 1
187    NO MINVALUE
188    NO MAXVALUE
189    CACHE 1;
190
191
192ALTER TABLE public.knjiga_sifra_seq OWNER TO student1;
193
194--
195-- Name: knjiga_sifra_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: student1
196--
197
198ALTER SEQUENCE public.knjiga_sifra_seq OWNED BY public.knjiga.sifra;
199
200
201--
202-- Name: posudba; Type: TABLE; Schema: public; Owner: student1
203--
204
205CREATE TABLE public.posudba (
206    clan character varying(10) NOT NULL,
207    datum_posudbe date NOT NULL,
208    datum_vracanja date,
209    knjiga character varying(10) NOT NULL
210);
211
212
213ALTER TABLE public.posudba OWNER TO student1;
214
215--
216-- Name: autor sifra; Type: DEFAULT; Schema: public; Owner: student1
217--
218
219ALTER TABLE ONLY public.autor ALTER COLUMN sifra SET DEFAULT nextval('public.autor_sifra_seq'::regclass);
220
221
222--
223-- Name: clan sifra; Type: DEFAULT; Schema: public; Owner: student1
224--
225
226ALTER TABLE ONLY public.clan ALTER COLUMN sifra SET DEFAULT nextval('public.clan_sifra_seq'::regclass);
227
228
229--
230-- Name: izdavac sifra; Type: DEFAULT; Schema: public; Owner: student1
231--
232
233ALTER TABLE ONLY public.izdavac ALTER COLUMN sifra SET DEFAULT nextval('public.izdavac_sifra_seq'::regclass);
234
235
236--
237-- Name: knjiga sifra; Type: DEFAULT; Schema: public; Owner: student1
238--
239
240ALTER TABLE ONLY public.knjiga ALTER COLUMN sifra SET DEFAULT nextval('public.knjiga_sifra_seq'::regclass);
241
242
243--
244-- Data for Name: autor; Type: TABLE DATA; Schema: public; Owner: student1
245--
246
247COPY public.autor (sifra, ime, prezime) FROM stdin;
248\.
249
250
251--
252-- Data for Name: autor_knjige; Type: TABLE DATA; Schema: public; Owner: student1
253--
254
255COPY public.autor_knjige (knjiga, autor) FROM stdin;
256\.
257
258
259--
260-- Data for Name: clan; Type: TABLE DATA; Schema: public; Owner: student1
261--
262
263COPY public.clan (sifra, ime, prezime, adresa) FROM stdin;
264\.
265
266
267--
268-- Data for Name: izdavac; Type: TABLE DATA; Schema: public; Owner: student1
269--
270
271COPY public.izdavac (sifra, naziv) FROM stdin;
272\.
273
274
275--
276-- Data for Name: knjiga; Type: TABLE DATA; Schema: public; Owner: student1
277--
278
279COPY public.knjiga (sifra, isbn, naziv, godina, izdavac) FROM stdin;
280\.
281
282
283--
284-- Data for Name: posudba; Type: TABLE DATA; Schema: public; Owner: student1
285--
286
287COPY public.posudba (clan, datum_posudbe, datum_vracanja, knjiga) FROM stdin;
288\.
289
290
291--
292-- Name: autor_sifra_seq; Type: SEQUENCE SET; Schema: public; Owner: student1
293--
294
295SELECT pg_catalog.setval('public.autor_sifra_seq', 1, false);
296
297
298--
299-- Name: brojac; Type: SEQUENCE SET; Schema: public; Owner: student1
300--
301
302SELECT pg_catalog.setval('public.brojac', 1, false);
303
304
305--
306-- Name: clan_sifra_seq; Type: SEQUENCE SET; Schema: public; Owner: student1
307--
308
309SELECT pg_catalog.setval('public.clan_sifra_seq', 1, false);
310
311
312--
313-- Name: izdavac_sifra_seq; Type: SEQUENCE SET; Schema: public; Owner: student1
314--
315
316SELECT pg_catalog.setval('public.izdavac_sifra_seq', 1, false);
317
318
319--
320-- Name: knjiga_sifra_seq; Type: SEQUENCE SET; Schema: public; Owner: student1
321--
322
323SELECT pg_catalog.setval('public.knjiga_sifra_seq', 1, false);
324
325
326--
327-- Name: autor autor_pkey; Type: CONSTRAINT; Schema: public; Owner: student1
328--
329
330ALTER TABLE ONLY public.autor
331    ADD CONSTRAINT autor_pkey PRIMARY KEY (sifra);
332
333
334--
335-- Name: clan clan_pkey; Type: CONSTRAINT; Schema: public; Owner: student1
336--
337
338ALTER TABLE ONLY public.clan
339    ADD CONSTRAINT clan_pkey PRIMARY KEY (sifra);
340
341
342--
343-- Name: izdavac izdavac_pkey; Type: CONSTRAINT; Schema: public; Owner: student1
344--
345
346ALTER TABLE ONLY public.izdavac
347    ADD CONSTRAINT izdavac_pkey PRIMARY KEY (sifra);
348
349
350--
351-- Name: knjiga knjiga_pkey; Type: CONSTRAINT; Schema: public; Owner: student1
352--
353
354ALTER TABLE ONLY public.knjiga
355    ADD CONSTRAINT knjiga_pkey PRIMARY KEY (sifra);
356
357
358--
359-- Name: autor_knjige pk1; Type: CONSTRAINT; Schema: public; Owner: student1
360--
361
362ALTER TABLE ONLY public.autor_knjige
363    ADD CONSTRAINT pk1 PRIMARY KEY (knjiga, autor);
364
365
366--
367-- Name: posudba pk2; Type: CONSTRAINT; Schema: public; Owner: student1
368--
369
370ALTER TABLE ONLY public.posudba
371    ADD CONSTRAINT pk2 PRIMARY KEY (clan, datum_posudbe, knjiga);
372
373
374--
375-- Name: autor_knjige autor_knjige_autor_fkey; Type: FK CONSTRAINT; Schema: public; Owner: student1
376--
377
378ALTER TABLE ONLY public.autor_knjige
379    ADD CONSTRAINT autor_knjige_autor_fkey FOREIGN KEY (autor) REFERENCES public.autor(sifra);
380
381
382--
383-- Name: autor_knjige autor_knjige_knjiga_fkey; Type: FK CONSTRAINT; Schema: public; Owner: student1
384--
385
386ALTER TABLE ONLY public.autor_knjige
387    ADD CONSTRAINT autor_knjige_knjiga_fkey FOREIGN KEY (knjiga) REFERENCES public.knjiga(sifra);
388
389
390--
391-- Name: knjiga knjiga_izdavac_fkey; Type: FK CONSTRAINT; Schema: public; Owner: student1
392--
393
394ALTER TABLE ONLY public.knjiga
395    ADD CONSTRAINT knjiga_izdavac_fkey FOREIGN KEY (izdavac) REFERENCES public.izdavac(sifra) ON UPDATE CASCADE ON DELETE RESTRICT;
396
397
398--
399-- Name: posudba posudba_clan_fkey; Type: FK CONSTRAINT; Schema: public; Owner: student1
400--
401
402ALTER TABLE ONLY public.posudba
403    ADD CONSTRAINT posudba_clan_fkey FOREIGN KEY (clan) REFERENCES public.clan(sifra);
404
405
406--
407-- Name: posudba posudba_knjiga_fkey; Type: FK CONSTRAINT; Schema: public; Owner: student1
408--
409
410ALTER TABLE ONLY public.posudba
411    ADD CONSTRAINT posudba_knjiga_fkey FOREIGN KEY (knjiga) REFERENCES public.knjiga(sifra);
412
413
414--
415-- PostgreSQL database dump complete
416--