· 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: 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--