--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

--
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
--

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';


SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: autor; Type: TABLE; Schema: public; Owner: student; Tablespace:
--

CREATE TABLE autor (
    sifra integer NOT NULL,
    ime character varying(20) NOT NULL,
    prezime character varying(20) NOT NULL
);


ALTER TABLE public.autor OWNER TO student;

--
-- Name: autor_knjige; Type: TABLE; Schema: public; Owner: student; Tablespace:
--

CREATE TABLE autor_knjige (
    knjiga integer NOT NULL,
    autor integer NOT NULL
);


ALTER TABLE public.autor_knjige OWNER TO student;

--
-- Name: autor_sifra_seq; Type: SEQUENCE; Schema: public; Owner: student
--

CREATE SEQUENCE autor_sifra_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.autor_sifra_seq OWNER TO student;

--
-- Name: autor_sifra_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: student
--

ALTER SEQUENCE autor_sifra_seq OWNED BY autor.sifra;


--
-- Name: brojac; Type: SEQUENCE; Schema: public; Owner: student
--

CREATE SEQUENCE brojac
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.brojac OWNER TO student;

--
-- Name: clan; Type: TABLE; Schema: public; Owner: student; Tablespace:
--

CREATE TABLE clan (
    sifra integer NOT NULL,
    ime character varying(20) NOT NULL,
    prezime character varying(20) NOT NULL,
    adresa character varying(50) NOT NULL
);


ALTER TABLE public.clan OWNER TO student;

--
-- Name: clan_sifra_seq; Type: SEQUENCE; Schema: public; Owner: student
--

CREATE SEQUENCE clan_sifra_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.clan_sifra_seq OWNER TO student;

--
-- Name: clan_sifra_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: student
--

ALTER SEQUENCE clan_sifra_seq OWNED BY clan.sifra;


--
-- Name: izdavac; Type: TABLE; Schema: public; Owner: student; Tablespace:
--

CREATE TABLE izdavac (
    sifra integer NOT NULL,
    naziv character varying(50) NOT NULL
);


ALTER TABLE public.izdavac OWNER TO student;

--
-- Name: izdavac_sifra_seq; Type: SEQUENCE; Schema: public; Owner: student
--

CREATE SEQUENCE izdavac_sifra_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.izdavac_sifra_seq OWNER TO student;

--
-- Name: izdavac_sifra_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: student
--

ALTER SEQUENCE izdavac_sifra_seq OWNED BY izdavac.sifra;


--
-- Name: knjiga; Type: TABLE; Schema: public; Owner: student; Tablespace:
--

CREATE TABLE knjiga (
    sifra integer NOT NULL,
    isbn character varying(15),
    naziv character varying(50) NOT NULL,
    godina smallint NOT NULL,
    izdavac integer,
    CONSTRAINT knjiga_godina_check CHECK (((godina > 1970) AND (godina < 2050)))
);


ALTER TABLE public.knjiga OWNER TO student;

--
-- Name: knjiga_sifra_seq; Type: SEQUENCE; Schema: public; Owner: student
--

CREATE SEQUENCE knjiga_sifra_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.knjiga_sifra_seq OWNER TO student;

--
-- Name: knjiga_sifra_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: student
--

ALTER SEQUENCE knjiga_sifra_seq OWNED BY knjiga.sifra;


--
-- Name: posudba; Type: TABLE; Schema: public; Owner: student; Tablespace:
--

CREATE TABLE posudba (
    clan integer NOT NULL,
    datum_posudbe date NOT NULL,
    datum_vracanja date,
    knjiga integer NOT NULL
);


ALTER TABLE public.posudba OWNER TO student;

--
-- Name: sifra; Type: DEFAULT; Schema: public; Owner: student
--

ALTER TABLE ONLY autor ALTER COLUMN sifra SET DEFAULT nextval('autor_sifra_seq'::regclass);


--
-- Name: sifra; Type: DEFAULT; Schema: public; Owner: student
--

ALTER TABLE ONLY clan ALTER COLUMN sifra SET DEFAULT nextval('clan_sifra_seq'::regclass);


--
-- Name: sifra; Type: DEFAULT; Schema: public; Owner: student
--

ALTER TABLE ONLY izdavac ALTER COLUMN sifra SET DEFAULT nextval('izdavac_sifra_seq'::regclass);


--
-- Name: sifra; Type: DEFAULT; Schema: public; Owner: student
--

ALTER TABLE ONLY knjiga ALTER COLUMN sifra SET DEFAULT nextval('knjiga_sifra_seq'::regclass);


--
-- Data for Name: autor; Type: TABLE DATA; Schema: public; Owner: student
--

COPY autor (sifra, ime, prezime) FROM stdin;
1   Slavko  Tkalac
2   Mirko   Čubrilo
3   Mario   Radovan
4   Vjeran  Strahonja
5   Miroslav    Žugaj
6   Miroslav    Bača
7   Cristopher  Date
\.


--
-- Data for Name: autor_knjige; Type: TABLE DATA; Schema: public; Owner: student
--

COPY autor_knjige (knjiga, autor) FROM stdin;
\.


--
-- Name: autor_sifra_seq; Type: SEQUENCE SET; Schema: public; Owner: student
--

SELECT pg_catalog.setval('autor_sifra_seq', 7, true);


--
-- Name: brojac; Type: SEQUENCE SET; Schema: public; Owner: student
--

SELECT pg_catalog.setval('brojac', 121, true);


--
-- Data for Name: clan; Type: TABLE DATA; Schema: public; Owner: student
--

COPY clan (sifra, ime, prezime, adresa) FROM stdin;
\.


--
-- Name: clan_sifra_seq; Type: SEQUENCE SET; Schema: public; Owner: student
--

SELECT pg_catalog.setval('clan_sifra_seq', 1, false);


--
-- Data for Name: izdavac; Type: TABLE DATA; Schema: public; Owner: student
--

COPY izdavac (sifra, naziv) FROM stdin;
1   DRIP
2   Informator
3   Narodne novine
4   Addison Wesley
\.


--
-- Name: izdavac_sifra_seq; Type: SEQUENCE SET; Schema: public; Owner: student
--

SELECT pg_catalog.setval('izdavac_sifra_seq', 4, true);


--
-- Data for Name: knjiga; Type: TABLE DATA; Schema: public; Owner: student
--

COPY knjiga (sifra, isbn, naziv, godina, izdavac) FROM stdin;
4   \N  Relacijski model podataka   1993    1
5   \N  Visual Basic, vizualni pristup programiranju    1994    1
6   \N  Matematička logika za ekspertne sisteme    1989    2
7   \N  Programiranje u Prologu 1990    2
8   \N  Baze podataka: relacijski pristup i SQL 1993    2
9   \N   Projektiranje informacijskih sistema   1989    2
10  \N   Informacijski sustavi proizvodnje  1992    2
11  \N  Uvod u računalnu sigurnost 2004    3
12  \N  An Introduction to Database Systems 2004    4
13  \N  What not how – the business rules approach    2000    4
\.


--
-- Name: knjiga_sifra_seq; Type: SEQUENCE SET; Schema: public; Owner: student
--

SELECT pg_catalog.setval('knjiga_sifra_seq', 13, true);


--
-- Data for Name: posudba; Type: TABLE DATA; Schema: public; Owner: student
--

COPY posudba (clan, datum_posudbe, datum_vracanja, knjiga) FROM stdin;
\.


--
-- Name: autor_knjige_pkey; Type: CONSTRAINT; Schema: public; Owner: student; Tablespace:
--

ALTER TABLE ONLY autor_knjige
    ADD CONSTRAINT autor_knjige_pkey PRIMARY KEY (knjiga, autor);


--
-- Name: autor_pkey; Type: CONSTRAINT; Schema: public; Owner: student; Tablespace:
--

ALTER TABLE ONLY autor
    ADD CONSTRAINT autor_pkey PRIMARY KEY (sifra);


--
-- Name: clan_pkey; Type: CONSTRAINT; Schema: public; Owner: student; Tablespace:
--

ALTER TABLE ONLY clan
    ADD CONSTRAINT clan_pkey PRIMARY KEY (sifra);


--
-- Name: izdavac_pkey; Type: CONSTRAINT; Schema: public; Owner: student; Tablespace:
--

ALTER TABLE ONLY izdavac
    ADD CONSTRAINT izdavac_pkey PRIMARY KEY (sifra);


--
-- Name: knjiga_pkey; Type: CONSTRAINT; Schema: public; Owner: student; Tablespace:
--

ALTER TABLE ONLY knjiga
    ADD CONSTRAINT knjiga_pkey PRIMARY KEY (sifra);


--
-- Name: posudba_pkey; Type: CONSTRAINT; Schema: public; Owner: student; Tablespace:
--

ALTER TABLE ONLY posudba
    ADD CONSTRAINT posudba_pkey PRIMARY KEY (clan, datum_posudbe, knjiga);


--
-- Name: i2; Type: INDEX; Schema: public; Owner: student; Tablespace:
--

CREATE UNIQUE INDEX i2 ON autor USING btree (prezime, ime);


--
-- Name: i3; Type: INDEX; Schema: public; Owner: student; Tablespace:
--

CREATE UNIQUE INDEX i3 ON izdavac USING btree (naziv);


--
-- Name: i4; Type: INDEX; Schema: public; Owner: student; Tablespace:
--

CREATE UNIQUE INDEX i4 ON clan USING btree (prezime, ime);


--
-- Name: i5; Type: INDEX; Schema: public; Owner: student; Tablespace:
--

CREATE UNIQUE INDEX i5 ON posudba USING btree (datum_posudbe, datum_vracanja);


--
-- Name: autor_knjige_autor_fkey; Type: FK CONSTRAINT; Schema: public; Owner: student
--

ALTER TABLE ONLY autor_knjige
    ADD CONSTRAINT autor_knjige_autor_fkey FOREIGN KEY (autor) REFERENCES autor(sifra);


--
-- Name: autor_knjige_knjiga_fkey; Type: FK CONSTRAINT; Schema: public; Owner: student
--

ALTER TABLE ONLY autor_knjige
    ADD CONSTRAINT autor_knjige_knjiga_fkey FOREIGN KEY (knjiga) REFERENCES knjiga(sifra);


--
-- Name: knjiga_izdavac_fkey; Type: FK CONSTRAINT; Schema: public; Owner: student
--

ALTER TABLE ONLY knjiga
    ADD CONSTRAINT knjiga_izdavac_fkey FOREIGN KEY (izdavac) REFERENCES izdavac(sifra) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: posudba_clan_fkey; Type: FK CONSTRAINT; Schema: public; Owner: student
--

ALTER TABLE ONLY posudba
    ADD CONSTRAINT posudba_clan_fkey FOREIGN KEY (clan) REFERENCES clan(sifra);


--
-- Name: posudba_knjiga_fkey; Type: FK CONSTRAINT; Schema: public; Owner: student
--

ALTER TABLE ONLY posudba
    ADD CONSTRAINT posudba_knjiga_fkey FOREIGN KEY (knjiga) REFERENCES knjiga(sifra);


--
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
-- PostgreSQL database dump complete
--


--
-- PostgreSQL database dump
--

-- Dumped from database version 10.6 (Ubuntu 10.6-0ubuntu0.18.10.1)
-- Dumped by pg_dump version 10.6 (Ubuntu 10.6-0ubuntu0.18.10.1)

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET client_min_messages = warning;
SET row_security = off;

--
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
--

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';


SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: autor; Type: TABLE; Schema: public; Owner: student1
--

CREATE TABLE public.autor (
    sifra character varying(10) NOT NULL,
    ime character varying(20) NOT NULL,
    prezime character varying(20) NOT NULL
);


ALTER TABLE public.autor OWNER TO student1;

--
-- Name: autor_knjige; Type: TABLE; Schema: public; Owner: student1
--

CREATE TABLE public.autor_knjige (
    knjiga character varying(10) NOT NULL,
    autor character varying(10) NOT NULL
);


ALTER TABLE public.autor_knjige OWNER TO student1;

--
-- Name: autor_sifra_seq; Type: SEQUENCE; Schema: public; Owner: student1
--

CREATE SEQUENCE public.autor_sifra_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.autor_sifra_seq OWNER TO student1;

--
-- Name: autor_sifra_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: student1
--

ALTER SEQUENCE public.autor_sifra_seq OWNED BY public.autor.sifra;


--
-- Name: brojac; Type: SEQUENCE; Schema: public; Owner: student1
--

CREATE SEQUENCE public.brojac
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.brojac OWNER TO student1;

--
-- Name: clan; Type: TABLE; Schema: public; Owner: student1
--

CREATE TABLE public.clan (
    sifra character varying(10) NOT NULL,
    ime character varying(20) NOT NULL,
    prezime character varying(20) NOT NULL,
    adresa character varying(50) NOT NULL
);


ALTER TABLE public.clan OWNER TO student1;

--
-- Name: clan_sifra_seq; Type: SEQUENCE; Schema: public; Owner: student1
--

CREATE SEQUENCE public.clan_sifra_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.clan_sifra_seq OWNER TO student1;

--
-- Name: clan_sifra_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: student1
--

ALTER SEQUENCE public.clan_sifra_seq OWNED BY public.clan.sifra;


--
-- Name: izdavac; Type: TABLE; Schema: public; Owner: student1
--

CREATE TABLE public.izdavac (
    sifra character varying(10) NOT NULL,
    naziv character varying(50) NOT NULL
);


ALTER TABLE public.izdavac OWNER TO student1;

--
-- Name: izdavac_sifra_seq; Type: SEQUENCE; Schema: public; Owner: student1
--

CREATE SEQUENCE public.izdavac_sifra_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.izdavac_sifra_seq OWNER TO student1;

--
-- Name: izdavac_sifra_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: student1
--

ALTER SEQUENCE public.izdavac_sifra_seq OWNED BY public.izdavac.sifra;


--
-- Name: knjiga; Type: TABLE; Schema: public; Owner: student1
--

CREATE TABLE public.knjiga (
    sifra character varying(50) NOT NULL,
    isbn character varying(15),
    naziv character varying(50) NOT NULL,
    godina smallint,
    izdavac character varying(10),
    CONSTRAINT knjiga_godina_check CHECK (((godina > 1970) AND (godina < 2050)))
);


ALTER TABLE public.knjiga OWNER TO student1;

--
-- Name: knjiga_sifra_seq; Type: SEQUENCE; Schema: public; Owner: student1
--

CREATE SEQUENCE public.knjiga_sifra_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.knjiga_sifra_seq OWNER TO student1;

--
-- Name: knjiga_sifra_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: student1
--

ALTER SEQUENCE public.knjiga_sifra_seq OWNED BY public.knjiga.sifra;


--
-- Name: posudba; Type: TABLE; Schema: public; Owner: student1
--

CREATE TABLE public.posudba (
    clan character varying(10) NOT NULL,
    datum_posudbe date NOT NULL,
    datum_vracanja date,
    knjiga character varying(10) NOT NULL
);


ALTER TABLE public.posudba OWNER TO student1;

--
-- Name: autor sifra; Type: DEFAULT; Schema: public; Owner: student1
--

ALTER TABLE ONLY public.autor ALTER COLUMN sifra SET DEFAULT nextval('public.autor_sifra_seq'::regclass);


--
-- Name: clan sifra; Type: DEFAULT; Schema: public; Owner: student1
--

ALTER TABLE ONLY public.clan ALTER COLUMN sifra SET DEFAULT nextval('public.clan_sifra_seq'::regclass);


--
-- Name: izdavac sifra; Type: DEFAULT; Schema: public; Owner: student1
--

ALTER TABLE ONLY public.izdavac ALTER COLUMN sifra SET DEFAULT nextval('public.izdavac_sifra_seq'::regclass);


--
-- Name: knjiga sifra; Type: DEFAULT; Schema: public; Owner: student1
--

ALTER TABLE ONLY public.knjiga ALTER COLUMN sifra SET DEFAULT nextval('public.knjiga_sifra_seq'::regclass);


--
-- Data for Name: autor; Type: TABLE DATA; Schema: public; Owner: student1
--

COPY public.autor (sifra, ime, prezime) FROM stdin;
\.


--
-- Data for Name: autor_knjige; Type: TABLE DATA; Schema: public; Owner: student1
--

COPY public.autor_knjige (knjiga, autor) FROM stdin;
\.


--
-- Data for Name: clan; Type: TABLE DATA; Schema: public; Owner: student1
--

COPY public.clan (sifra, ime, prezime, adresa) FROM stdin;
\.


--
-- Data for Name: izdavac; Type: TABLE DATA; Schema: public; Owner: student1
--

COPY public.izdavac (sifra, naziv) FROM stdin;
\.


--
-- Data for Name: knjiga; Type: TABLE DATA; Schema: public; Owner: student1
--

COPY public.knjiga (sifra, isbn, naziv, godina, izdavac) FROM stdin;
\.


--
-- Data for Name: posudba; Type: TABLE DATA; Schema: public; Owner: student1
--

COPY public.posudba (clan, datum_posudbe, datum_vracanja, knjiga) FROM stdin;
\.


--
-- Name: autor_sifra_seq; Type: SEQUENCE SET; Schema: public; Owner: student1
--

SELECT pg_catalog.setval('public.autor_sifra_seq', 1, false);


--
-- Name: brojac; Type: SEQUENCE SET; Schema: public; Owner: student1
--

SELECT pg_catalog.setval('public.brojac', 1, false);


--
-- Name: clan_sifra_seq; Type: SEQUENCE SET; Schema: public; Owner: student1
--

SELECT pg_catalog.setval('public.clan_sifra_seq', 1, false);


--
-- Name: izdavac_sifra_seq; Type: SEQUENCE SET; Schema: public; Owner: student1
--

SELECT pg_catalog.setval('public.izdavac_sifra_seq', 1, false);


--
-- Name: knjiga_sifra_seq; Type: SEQUENCE SET; Schema: public; Owner: student1
--

SELECT pg_catalog.setval('public.knjiga_sifra_seq', 1, false);


--
-- Name: autor autor_pkey; Type: CONSTRAINT; Schema: public; Owner: student1
--

ALTER TABLE ONLY public.autor
    ADD CONSTRAINT autor_pkey PRIMARY KEY (sifra);


--
-- Name: clan clan_pkey; Type: CONSTRAINT; Schema: public; Owner: student1
--

ALTER TABLE ONLY public.clan
    ADD CONSTRAINT clan_pkey PRIMARY KEY (sifra);


--
-- Name: izdavac izdavac_pkey; Type: CONSTRAINT; Schema: public; Owner: student1
--

ALTER TABLE ONLY public.izdavac
    ADD CONSTRAINT izdavac_pkey PRIMARY KEY (sifra);


--
-- Name: knjiga knjiga_pkey; Type: CONSTRAINT; Schema: public; Owner: student1
--

ALTER TABLE ONLY public.knjiga
    ADD CONSTRAINT knjiga_pkey PRIMARY KEY (sifra);


--
-- Name: autor_knjige pk1; Type: CONSTRAINT; Schema: public; Owner: student1
--

ALTER TABLE ONLY public.autor_knjige
    ADD CONSTRAINT pk1 PRIMARY KEY (knjiga, autor);


--
-- Name: posudba pk2; Type: CONSTRAINT; Schema: public; Owner: student1
--

ALTER TABLE ONLY public.posudba
    ADD CONSTRAINT pk2 PRIMARY KEY (clan, datum_posudbe, knjiga);


--
-- Name: autor_knjige autor_knjige_autor_fkey; Type: FK CONSTRAINT; Schema: public; Owner: student1
--

ALTER TABLE ONLY public.autor_knjige
    ADD CONSTRAINT autor_knjige_autor_fkey FOREIGN KEY (autor) REFERENCES public.autor(sifra);


--
-- Name: autor_knjige autor_knjige_knjiga_fkey; Type: FK CONSTRAINT; Schema: public; Owner: student1
--

ALTER TABLE ONLY public.autor_knjige
    ADD CONSTRAINT autor_knjige_knjiga_fkey FOREIGN KEY (knjiga) REFERENCES public.knjiga(sifra);


--
-- Name: knjiga knjiga_izdavac_fkey; Type: FK CONSTRAINT; Schema: public; Owner: student1
--

ALTER TABLE ONLY public.knjiga
    ADD CONSTRAINT knjiga_izdavac_fkey FOREIGN KEY (izdavac) REFERENCES public.izdavac(sifra) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: posudba posudba_clan_fkey; Type: FK CONSTRAINT; Schema: public; Owner: student1
--

ALTER TABLE ONLY public.posudba
    ADD CONSTRAINT posudba_clan_fkey FOREIGN KEY (clan) REFERENCES public.clan(sifra);


--
-- Name: posudba posudba_knjiga_fkey; Type: FK CONSTRAINT; Schema: public; Owner: student1
--

ALTER TABLE ONLY public.posudba
    ADD CONSTRAINT posudba_knjiga_fkey FOREIGN KEY (knjiga) REFERENCES public.knjiga(sifra);


--
-- PostgreSQL database dump complete
--