--
-- PostgreSQL database dump
--

-- Started on 2008-08-11 14:08:55

SET client_encoding = 'WIN1251';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;

--
-- TOC entry 1761 (class 1262 OID 16403)
-- Name: test; Type: DATABASE; Schema: -; Owner: postgres
--

CREATE DATABASE test WITH TEMPLATE = template0 ENCODING = 'WIN1251';


ALTER DATABASE test OWNER TO postgres;

\connect test

SET client_encoding = 'WIN1251';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;

--
-- TOC entry 301 (class 2612 OID 16386)
-- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: postgres
--

CREATE PROCEDURAL LANGUAGE plpgsql;


ALTER PROCEDURAL LANGUAGE plpgsql OWNER TO postgres;

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- TOC entry 1473 (class 1259 OID 16404)
-- Dependencies: 1743 3
-- Name: dvd; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE dvd (
    id integer NOT NULL,
    maker character varying NOT NULL,
    model character varying NOT NULL,
    price money NOT NULL,
    CONSTRAINT chk_price CHECK ((price > 'ð.0,00'::money))
);


ALTER TABLE public.dvd OWNER TO postgres;

--
-- TOC entry 1476 (class 1259 OID 16445)
-- Dependencies: 1746 3 1473
-- Name: car_dvd; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE car_dvd (
)
INHERITS (dvd);


ALTER TABLE public.car_dvd OWNER TO postgres;

--
-- TOC entry 1474 (class 1259 OID 16410)
-- Dependencies: 1744 1473 3
-- Name: home_cinema; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE home_cinema (
    sound integer
)
INHERITS (dvd);


ALTER TABLE public.home_cinema OWNER TO postgres;

--
-- TOC entry 1475 (class 1259 OID 16430)
-- Dependencies: 1745 3 1473
-- Name: portable_dvd; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE portable_dvd (
    screen_size numeric(2,1)
)
INHERITS (dvd);


ALTER TABLE public.portable_dvd OWNER TO postgres;

--
-- TOC entry 1758 (class 0 OID 16445)
-- Dependencies: 1476
-- Data for Name: car_dvd; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY car_dvd (id, maker, model, price) FROM stdin;
1	Cameron	CA-575 DVD	ð.4 599,00
2	Elenberg	MX-390DVD	ð.2 499,00
\.


--
-- TOC entry 1755 (class 0 OID 16404)
-- Dependencies: 1473
-- Data for Name: dvd; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY dvd (id, maker, model, price) FROM stdin;
1	Philips	DVP-3148K	ð.1 599,00
2	Supra	DVS-120X	ð.899,00
3	Daewoo	DNS-5800	ð.1 199,00
\.


--
-- TOC entry 1756 (class 0 OID 16410)
-- Dependencies: 1474
-- Data for Name: home_cinema; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY home_cinema (id, maker, model, price, sound) FROM stdin;
1	Elenberg	HT-111	ð.2 399,00	6
2	Daewoo	HC-4250XS	ð.2 999,00	6
3	Samsung	HT-Z110R	ð.4 199,00	6
4	LG	LH-T3530X	ð.5 499,00	6
\.


--
-- TOC entry 1757 (class 0 OID 16430)
-- Dependencies: 1475
-- Data for Name: portable_dvd; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY portable_dvd (id, maker, model, price, screen_size) FROM stdin;
1	BBK	DL370SI	ð.2 999,00	7.0
2	Daewoo	DPC-8209PD	ð.2 999,00	8.0
3	Elenberg	LD-715	ð.3 199,00	7.0
\.


--
-- TOC entry 1754 (class 2606 OID 16453)
-- Dependencies: 1476 1476
-- Name: pk_car_dvd; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY car_dvd
    ADD CONSTRAINT pk_car_dvd PRIMARY KEY (id);


--
-- TOC entry 1748 (class 2606 OID 16417)
-- Dependencies: 1473 1473
-- Name: pk_dvd; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY dvd
    ADD CONSTRAINT pk_dvd PRIMARY KEY (id);


--
-- TOC entry 1750 (class 2606 OID 16438)
-- Dependencies: 1474 1474
-- Name: pk_home_cinema; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY home_cinema
    ADD CONSTRAINT pk_home_cinema PRIMARY KEY (id);


--
-- TOC entry 1752 (class 2606 OID 16440)
-- Dependencies: 1475 1475
-- Name: pk_portable_dvd; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY portable_dvd
    ADD CONSTRAINT pk_portable_dvd PRIMARY KEY (id);


--
-- TOC entry 1763 (class 0 OID 0)
-- Dependencies: 3
-- 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;


-- Completed on 2008-08-11 14:08:56

--
-- PostgreSQL database dump complete
--