--
-- PostgreSQL database dump
--

-- Started on 2010-02-12 22:44:35 CET

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

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- TOC entry 1508 (class 1259 OID 16389)
-- Dependencies: 6
-- Name: IntProperties; Type: TABLE; Schema: public; Owner: yalp; Tablespace: 
--

CREATE TABLE "IntProperties" (
    id bigint NOT NULL,
    description text,
    value integer
);


ALTER TABLE public."IntProperties" OWNER TO yalp;

--
-- TOC entry 1507 (class 1259 OID 16387)
-- Dependencies: 6 1508
-- Name: IntProperties_id_seq; Type: SEQUENCE; Schema: public; Owner: yalp
--

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


ALTER TABLE public."IntProperties_id_seq" OWNER TO yalp;

--
-- TOC entry 1826 (class 0 OID 0)
-- Dependencies: 1507
-- Name: IntProperties_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: yalp
--

ALTER SEQUENCE "IntProperties_id_seq" OWNED BY "IntProperties".id;


--
-- TOC entry 1827 (class 0 OID 0)
-- Dependencies: 1507
-- Name: IntProperties_id_seq; Type: SEQUENCE SET; Schema: public; Owner: yalp
--

SELECT pg_catalog.setval('"IntProperties_id_seq"', 1, false);


--
-- TOC entry 1510 (class 1259 OID 16398)
-- Dependencies: 6
-- Name: Medias; Type: TABLE; Schema: public; Owner: yalp; Tablespace: 
--

CREATE TABLE "Medias" (
    id bigint NOT NULL,
    type character(1),
    path text,
    "fileName" text,
    duration text,
    name text,
    tags text
);


ALTER TABLE public."Medias" OWNER TO yalp;

--
-- TOC entry 1509 (class 1259 OID 16396)
-- Dependencies: 6 1510
-- Name: Medias_id_seq; Type: SEQUENCE; Schema: public; Owner: yalp
--

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


ALTER TABLE public."Medias_id_seq" OWNER TO yalp;

--
-- TOC entry 1828 (class 0 OID 0)
-- Dependencies: 1509
-- Name: Medias_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: yalp
--

ALTER SEQUENCE "Medias_id_seq" OWNED BY "Medias".id;


--
-- TOC entry 1829 (class 0 OID 0)
-- Dependencies: 1509
-- Name: Medias_id_seq; Type: SEQUENCE SET; Schema: public; Owner: yalp
--

SELECT pg_catalog.setval('"Medias_id_seq"', 2, true);


--
-- TOC entry 1512 (class 1259 OID 16407)
-- Dependencies: 1796 1797 6
-- Name: PropertyConnector; Type: TABLE; Schema: public; Owner: yalp; Tablespace: 
--

CREATE TABLE "PropertyConnector" (
    "mediaId" integer,
    "stringPropertyId" integer DEFAULT 0,
    "intPropertyId" integer DEFAULT 0,
    id bigint NOT NULL
);


ALTER TABLE public."PropertyConnector" OWNER TO yalp;

--
-- TOC entry 1511 (class 1259 OID 16405)
-- Dependencies: 6 1512
-- Name: PropertyConnector_id_seq; Type: SEQUENCE; Schema: public; Owner: yalp
--

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


ALTER TABLE public."PropertyConnector_id_seq" OWNER TO yalp;

--
-- TOC entry 1830 (class 0 OID 0)
-- Dependencies: 1511
-- Name: PropertyConnector_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: yalp
--

ALTER SEQUENCE "PropertyConnector_id_seq" OWNED BY "PropertyConnector".id;


--
-- TOC entry 1831 (class 0 OID 0)
-- Dependencies: 1511
-- Name: PropertyConnector_id_seq; Type: SEQUENCE SET; Schema: public; Owner: yalp
--

SELECT pg_catalog.setval('"PropertyConnector_id_seq"', 1, false);


--
-- TOC entry 1514 (class 1259 OID 16415)
-- Dependencies: 6
-- Name: StringProperties; Type: TABLE; Schema: public; Owner: yalp; Tablespace: 
--

CREATE TABLE "StringProperties" (
    id bigint NOT NULL,
    description text,
    value text
);


ALTER TABLE public."StringProperties" OWNER TO yalp;

--
-- TOC entry 1513 (class 1259 OID 16413)
-- Dependencies: 1514 6
-- Name: StringProperties_id_seq; Type: SEQUENCE; Schema: public; Owner: yalp
--

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


ALTER TABLE public."StringProperties_id_seq" OWNER TO yalp;

--
-- TOC entry 1832 (class 0 OID 0)
-- Dependencies: 1513
-- Name: StringProperties_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: yalp
--

ALTER SEQUENCE "StringProperties_id_seq" OWNED BY "StringProperties".id;


--
-- TOC entry 1833 (class 0 OID 0)
-- Dependencies: 1513
-- Name: StringProperties_id_seq; Type: SEQUENCE SET; Schema: public; Owner: yalp
--

SELECT pg_catalog.setval('"StringProperties_id_seq"', 1, false);


--
-- TOC entry 1516 (class 1259 OID 16424)
-- Dependencies: 1800 6
-- Name: Users; Type: TABLE; Schema: public; Owner: yalp; Tablespace: 
--

CREATE TABLE "Users" (
    level integer DEFAULT 1 NOT NULL,
    id bigint NOT NULL,
    name text NOT NULL,
    "realName" text
);


ALTER TABLE public."Users" OWNER TO yalp;

--
-- TOC entry 1515 (class 1259 OID 16422)
-- Dependencies: 6 1516
-- Name: Users_id_seq; Type: SEQUENCE; Schema: public; Owner: yalp
--

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


ALTER TABLE public."Users_id_seq" OWNER TO yalp;

--
-- TOC entry 1834 (class 0 OID 0)
-- Dependencies: 1515
-- Name: Users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: yalp
--

ALTER SEQUENCE "Users_id_seq" OWNED BY "Users".id;


--
-- TOC entry 1835 (class 0 OID 0)
-- Dependencies: 1515
-- Name: Users_id_seq; Type: SEQUENCE SET; Schema: public; Owner: yalp
--

SELECT pg_catalog.setval('"Users_id_seq"', 1, false);


--
-- TOC entry 1794 (class 2604 OID 16392)
-- Dependencies: 1508 1507 1508
-- Name: id; Type: DEFAULT; Schema: public; Owner: yalp
--

ALTER TABLE "IntProperties" ALTER COLUMN id SET DEFAULT nextval('"IntProperties_id_seq"'::regclass);


--
-- TOC entry 1795 (class 2604 OID 16401)
-- Dependencies: 1510 1509 1510
-- Name: id; Type: DEFAULT; Schema: public; Owner: yalp
--

ALTER TABLE "Medias" ALTER COLUMN id SET DEFAULT nextval('"Medias_id_seq"'::regclass);


--
-- TOC entry 1798 (class 2604 OID 16412)
-- Dependencies: 1512 1511 1512
-- Name: id; Type: DEFAULT; Schema: public; Owner: yalp
--

ALTER TABLE "PropertyConnector" ALTER COLUMN id SET DEFAULT nextval('"PropertyConnector_id_seq"'::regclass);


--
-- TOC entry 1799 (class 2604 OID 16418)
-- Dependencies: 1514 1513 1514
-- Name: id; Type: DEFAULT; Schema: public; Owner: yalp
--

ALTER TABLE "StringProperties" ALTER COLUMN id SET DEFAULT nextval('"StringProperties_id_seq"'::regclass);


--
-- TOC entry 1801 (class 2604 OID 16428)
-- Dependencies: 1516 1515 1516
-- Name: id; Type: DEFAULT; Schema: public; Owner: yalp
--

ALTER TABLE "Users" ALTER COLUMN id SET DEFAULT nextval('"Users_id_seq"'::regclass);


--
-- TOC entry 1817 (class 0 OID 16389)
-- Dependencies: 1508
-- Data for Name: IntProperties; Type: TABLE DATA; Schema: public; Owner: yalp
--

COPY "IntProperties" (id, description, value) FROM stdin;
\.


--
-- TOC entry 1818 (class 0 OID 16398)
-- Dependencies: 1510
-- Data for Name: Medias; Type: TABLE DATA; Schema: public; Owner: yalp
--

COPY "Medias" (id, type, path, "fileName", duration, name, tags) FROM stdin;
1	v	/home/manut	test.avi	5:55	huhu	hihi
2	s	/home/manut	test.mp3	2:22	chavenger - jung und frech	live, hiltensweiler, hihi
\.


--
-- TOC entry 1819 (class 0 OID 16407)
-- Dependencies: 1512
-- Data for Name: PropertyConnector; Type: TABLE DATA; Schema: public; Owner: yalp
--

COPY "PropertyConnector" ("mediaId", "stringPropertyId", "intPropertyId", id) FROM stdin;
\.


--
-- TOC entry 1820 (class 0 OID 16415)
-- Dependencies: 1514
-- Data for Name: StringProperties; Type: TABLE DATA; Schema: public; Owner: yalp
--

COPY "StringProperties" (id, description, value) FROM stdin;
\.


--
-- TOC entry 1821 (class 0 OID 16424)
-- Dependencies: 1516
-- Data for Name: Users; Type: TABLE DATA; Schema: public; Owner: yalp
--

COPY "Users" (level, id, name, "realName") FROM stdin;
\.


--
-- TOC entry 1807 (class 2606 OID 16433)
-- Dependencies: 1512 1512
-- Name: key_id_con; Type: CONSTRAINT; Schema: public; Owner: yalp; Tablespace: 
--

ALTER TABLE ONLY "PropertyConnector"
    ADD CONSTRAINT key_id_con PRIMARY KEY (id);


--
-- TOC entry 1811 (class 2606 OID 16435)
-- Dependencies: 1516 1516
-- Name: key_is_id; Type: CONSTRAINT; Schema: public; Owner: yalp; Tablespace: 
--

ALTER TABLE ONLY "Users"
    ADD CONSTRAINT key_is_id PRIMARY KEY (id);


--
-- TOC entry 1809 (class 2606 OID 16437)
-- Dependencies: 1514 1514
-- Name: prim_key_id; Type: CONSTRAINT; Schema: public; Owner: yalp; Tablespace: 
--

ALTER TABLE ONLY "StringProperties"
    ADD CONSTRAINT prim_key_id PRIMARY KEY (id);


--
-- TOC entry 1803 (class 2606 OID 16439)
-- Dependencies: 1508 1508
-- Name: prim_key_int_id; Type: CONSTRAINT; Schema: public; Owner: yalp; Tablespace: 
--

ALTER TABLE ONLY "IntProperties"
    ADD CONSTRAINT prim_key_int_id PRIMARY KEY (id);


--
-- TOC entry 1805 (class 2606 OID 16441)
-- Dependencies: 1510 1510
-- Name: prim_key_m_id; Type: CONSTRAINT; Schema: public; Owner: yalp; Tablespace: 
--

ALTER TABLE ONLY "Medias"
    ADD CONSTRAINT prim_key_m_id PRIMARY KEY (id);


--
-- TOC entry 1813 (class 2606 OID 16443)
-- Dependencies: 1516 1516
-- Name: username_is_unique; Type: CONSTRAINT; Schema: public; Owner: yalp; Tablespace: 
--

ALTER TABLE ONLY "Users"
    ADD CONSTRAINT username_is_unique UNIQUE (name);


--
-- TOC entry 1814 (class 2606 OID 16444)
-- Dependencies: 1508 1512 1802
-- Name: int_prop; Type: FK CONSTRAINT; Schema: public; Owner: yalp
--

ALTER TABLE ONLY "PropertyConnector"
    ADD CONSTRAINT int_prop FOREIGN KEY ("intPropertyId") REFERENCES "IntProperties"(id);


--
-- TOC entry 1815 (class 2606 OID 16449)
-- Dependencies: 1804 1512 1510
-- Name: media_prop; Type: FK CONSTRAINT; Schema: public; Owner: yalp
--

ALTER TABLE ONLY "PropertyConnector"
    ADD CONSTRAINT media_prop FOREIGN KEY ("mediaId") REFERENCES "Medias"(id);


--
-- TOC entry 1816 (class 2606 OID 16454)
-- Dependencies: 1512 1808 1514
-- Name: string_prop; Type: FK CONSTRAINT; Schema: public; Owner: yalp
--

ALTER TABLE ONLY "PropertyConnector"
    ADD CONSTRAINT string_prop FOREIGN KEY ("stringPropertyId") REFERENCES "StringProperties"(id);


--
-- TOC entry 1825 (class 0 OID 0)
-- Dependencies: 6
-- 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 yalp;
GRANT ALL ON SCHEMA public TO PUBLIC;


-- Completed on 2010-02-12 22:44:35 CET

--
-- PostgreSQL database dump complete
--