· 6 years ago · Mar 25, 2019, 02:56 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: gandalf; 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 gandalf;
43
44--
45-- Name: autor_knjige; Type: TABLE; Schema: public; Owner: gandalf; 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 gandalf;
55
56--
57-- Name: autor_sifra_seq; Type: SEQUENCE; Schema: public; Owner: gandalf
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 gandalf;
69
70--
71-- Name: autor_sifra_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: gandalf
72--
73
74ALTER SEQUENCE autor_sifra_seq OWNED BY autor.sifra;
75
76
77--
78-- Name: brojac; Type: SEQUENCE; Schema: public; Owner: gandalf
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 gandalf;
90
91--
92-- Name: clan; Type: TABLE; Schema: public; Owner: gandalf; 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 gandalf;
104
105--
106-- Name: clan_sifra_seq; Type: SEQUENCE; Schema: public; Owner: gandalf
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 gandalf;
118
119--
120-- Name: clan_sifra_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: gandalf
121--
122
123ALTER SEQUENCE clan_sifra_seq OWNED BY clan.sifra;
124
125
126--
127-- Name: izdavac; Type: TABLE; Schema: public; Owner: gandalf; 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 gandalf;
137
138--
139-- Name: izdavac_sifra_seq; Type: SEQUENCE; Schema: public; Owner: gandalf
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 gandalf;
151
152--
153-- Name: izdavac_sifra_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: gandalf
154--
155
156ALTER SEQUENCE izdavac_sifra_seq OWNED BY izdavac.sifra;
157
158
159--
160-- Name: knjiga; Type: TABLE; Schema: public; Owner: gandalf; 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 gandalf;
174
175--
176-- Name: knjiga_sifra_seq; Type: SEQUENCE; Schema: public; Owner: gandalf
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 gandalf;
188
189--
190-- Name: knjiga_sifra_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: gandalf
191--
192
193ALTER SEQUENCE knjiga_sifra_seq OWNED BY knjiga.sifra;
194
195
196--
197-- Name: posudba; Type: TABLE; Schema: public; Owner: gandalf; 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 gandalf;
209
210--
211-- Name: sifra; Type: DEFAULT; Schema: public; Owner: gandalf
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: gandalf
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: gandalf
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: gandalf
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: gandalf
240--
241
242COPY autor (sifra, ime, prezime) FROM stdin;
2431 Slavko Tkalec
2442 Mirko ÄŒubrilo
2453 Nenad Crnko
2464 Mario Radovan
2475 Vjeran Strahonja
2486 Miroslav BaÄa
2497 Christopher Date
250\.
251
252
253--
254-- Data for Name: autor_knjige; Type: TABLE DATA; Schema: public; Owner: gandalf
255--
256
257COPY autor_knjige (knjiga, autor) FROM stdin;
258\.
259
260
261--
262-- Name: autor_sifra_seq; Type: SEQUENCE SET; Schema: public; Owner: gandalf
263--
264
265SELECT pg_catalog.setval('autor_sifra_seq', 7, true);
266
267
268--
269-- Name: brojac; Type: SEQUENCE SET; Schema: public; Owner: gandalf
270--
271
272SELECT pg_catalog.setval('brojac', 122, true);
273
274
275--
276-- Data for Name: clan; Type: TABLE DATA; Schema: public; Owner: gandalf
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: gandalf
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: gandalf
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: gandalf
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: gandalf
311--
312
313COPY knjiga (sifra, isbn, naziv, godina, izdavac) FROM stdin;
314\.
315
316
317--
318-- Name: knjiga_sifra_seq; Type: SEQUENCE SET; Schema: public; Owner: gandalf
319--
320
321SELECT pg_catalog.setval('knjiga_sifra_seq', 1, false);
322
323
324--
325-- Data for Name: posudba; Type: TABLE DATA; Schema: public; Owner: gandalf
326--
327
328COPY posudba (clan, datum_posudbe, datum_vracanja, knjiga) FROM stdin;
329\.
330
331
332--
333-- Name: autor_knjige_pkey; Type: CONSTRAINT; Schema: public; Owner: gandalf; Tablespace:
334--
335
336ALTER TABLE ONLY autor_knjige
337 ADD CONSTRAINT autor_knjige_pkey PRIMARY KEY (knjiga, autor);
338
339
340--
341-- Name: autor_pkey; Type: CONSTRAINT; Schema: public; Owner: gandalf; Tablespace:
342--
343
344ALTER TABLE ONLY autor
345 ADD CONSTRAINT autor_pkey PRIMARY KEY (sifra);
346
347
348--
349-- Name: clan_pkey; Type: CONSTRAINT; Schema: public; Owner: gandalf; Tablespace:
350--
351
352ALTER TABLE ONLY clan
353 ADD CONSTRAINT clan_pkey PRIMARY KEY (sifra);
354
355
356--
357-- Name: izdavac_pkey; Type: CONSTRAINT; Schema: public; Owner: gandalf; Tablespace:
358--
359
360ALTER TABLE ONLY izdavac
361 ADD CONSTRAINT izdavac_pkey PRIMARY KEY (sifra);
362
363
364--
365-- Name: knjiga_pkey; Type: CONSTRAINT; Schema: public; Owner: gandalf; Tablespace:
366--
367
368ALTER TABLE ONLY knjiga
369 ADD CONSTRAINT knjiga_pkey PRIMARY KEY (sifra);
370
371
372--
373-- Name: posudba_pkey; Type: CONSTRAINT; Schema: public; Owner: gandalf; Tablespace:
374--
375
376ALTER TABLE ONLY posudba
377 ADD CONSTRAINT posudba_pkey PRIMARY KEY (clan, datum_posudbe, knjiga);
378
379
380--
381-- Name: i1; Type: INDEX; Schema: public; Owner: gandalf; Tablespace:
382--
383
384CREATE UNIQUE INDEX i1 ON izdavac USING btree (naziv);
385
386
387--
388-- Name: i2; Type: INDEX; Schema: public; Owner: gandalf; Tablespace:
389--
390
391CREATE INDEX i2 ON autor USING btree (prezime, ime);
392
393
394--
395-- Name: i3; Type: INDEX; Schema: public; Owner: gandalf; Tablespace:
396--
397
398CREATE UNIQUE INDEX i3 ON clan USING btree (prezime, ime);
399
400
401--
402-- Name: i4; Type: INDEX; Schema: public; Owner: gandalf; Tablespace:
403--
404
405CREATE UNIQUE INDEX i4 ON posudba USING btree (datum_posudbe, datum_vracanja);
406
407
408--
409-- Name: autor_knjige_autor_fkey; Type: FK CONSTRAINT; Schema: public; Owner: gandalf
410--
411
412ALTER TABLE ONLY autor_knjige
413 ADD CONSTRAINT autor_knjige_autor_fkey FOREIGN KEY (autor) REFERENCES autor(sifra);
414
415
416--
417-- Name: autor_knjige_knjiga_fkey; Type: FK CONSTRAINT; Schema: public; Owner: gandalf
418--
419
420ALTER TABLE ONLY autor_knjige
421 ADD CONSTRAINT autor_knjige_knjiga_fkey FOREIGN KEY (knjiga) REFERENCES knjiga(sifra);
422
423
424--
425-- Name: knjiga_izdavac_fkey; Type: FK CONSTRAINT; Schema: public; Owner: gandalf
426--
427
428ALTER TABLE ONLY knjiga
429 ADD CONSTRAINT knjiga_izdavac_fkey FOREIGN KEY (izdavac) REFERENCES izdavac(sifra) ON UPDATE CASCADE ON DELETE RESTRICT;
430
431
432--
433-- Name: posudba_clan_fkey; Type: FK CONSTRAINT; Schema: public; Owner: gandalf
434--
435
436ALTER TABLE ONLY posudba
437 ADD CONSTRAINT posudba_clan_fkey FOREIGN KEY (clan) REFERENCES clan(sifra);
438
439
440--
441-- Name: posudba_knjiga_fkey; Type: FK CONSTRAINT; Schema: public; Owner: gandalf
442--
443
444ALTER TABLE ONLY posudba
445 ADD CONSTRAINT posudba_knjiga_fkey FOREIGN KEY (knjiga) REFERENCES knjiga(sifra);
446
447
448--
449-- Name: public; Type: ACL; Schema: -; Owner: postgres
450--
451
452REVOKE ALL ON SCHEMA public FROM PUBLIC;
453REVOKE ALL ON SCHEMA public FROM postgres;
454GRANT ALL ON SCHEMA public TO postgres;
455GRANT ALL ON SCHEMA public TO PUBLIC;
456
457
458--
459-- PostgreSQL database dump complete
460--