--
-- 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: gandalf; 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 gandalf;

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

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


ALTER TABLE public.autor_knjige OWNER TO gandalf;

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

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 gandalf;

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

ALTER SEQUENCE autor_sifra_seq OWNED BY autor.sifra;


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

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


ALTER TABLE public.brojac OWNER TO gandalf;

--
-- Name: clan; Type: TABLE; Schema: public; Owner: gandalf; 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 gandalf;

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

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 gandalf;

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

ALTER SEQUENCE clan_sifra_seq OWNED BY clan.sifra;


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

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


ALTER TABLE public.izdavac OWNER TO gandalf;

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

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 gandalf;

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

ALTER SEQUENCE izdavac_sifra_seq OWNED BY izdavac.sifra;


--
-- Name: knjiga; Type: TABLE; Schema: public; Owner: gandalf; 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 gandalf;

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

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 gandalf;

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

ALTER SEQUENCE knjiga_sifra_seq OWNED BY knjiga.sifra;


--
-- Name: posudba; Type: TABLE; Schema: public; Owner: gandalf; 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 gandalf;

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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


--
-- Name: i1; Type: INDEX; Schema: public; Owner: gandalf; Tablespace:
--

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


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

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


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

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


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

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


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

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

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

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

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

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