fixed database backup file

git-svn-id: http://manut.eu/svn/yalp/trunk@15 f059d3a0-6783-47b7-97ff-1fe0bbf25129

2 files changed, 0 insertions, 324 deletions

diff --git a/src/YalpInputs/YalpPGSqlInput/db-design-backup.sql b/src/YalpInputs/YalpPGSqlInput/db-design-backup.sql
deleted file mode 100644
index bbdd0d9..0000000
--- a/src/YalpInputs/YalpPGSqlInput/db-design-backup.sql
+++ /dev/null
@@ -1,324 +0,0 @@
---
--- PostgreSQL database dump
---
-
--- Started on 2008-09-25 00:44:25 CEST
-
-SET client_encoding = 'UNICODE';
-SET check_function_bodies = false;
-SET client_min_messages = warning;
-
---
--- TOC entry 1520 (class 0 OID 0)
--- Dependencies: 5
--- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
---
-
-COMMENT ON SCHEMA public IS 'Standard public schema';
-
-
-SET search_path = public, pg_catalog;
-
-SET default_tablespace = '';
-
-SET default_with_oids = false;
-
---
--- TOC entry 1172 (class 1259 OID 17306)
--- Dependencies: 1493 5
--- Name: IntProperties; Type: TABLE; Schema: public; Owner: yalp; Tablespace: 
---
-
-CREATE TABLE "IntProperties" (
-    id bigserial NOT NULL,
-    description text,
-    value integer
-);
-
-
-ALTER TABLE public."IntProperties" OWNER TO yalp;
-
---
--- TOC entry 1522 (class 0 OID 0)
--- Dependencies: 1171
--- Name: IntProperties_id_seq; Type: SEQUENCE SET; Schema: public; Owner: yalp
---
-
-SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('"IntProperties"', 'id'), 1, false);
-
-
---
--- TOC entry 1174 (class 1259 OID 17313)
--- Dependencies: 1494 5
--- Name: Medias; Type: TABLE; Schema: public; Owner: yalp; Tablespace: 
---
-
-CREATE TABLE "Medias" (
-    id bigserial NOT NULL,
-    "type" character(1),
-    path text,
-    "fileName" text,
-    duration text,
-    name text,
-    tags text
-);
-
-
-ALTER TABLE public."Medias" OWNER TO yalp;
-
---
--- TOC entry 1523 (class 0 OID 0)
--- Dependencies: 1173
--- Name: Medias_id_seq; Type: SEQUENCE SET; Schema: public; Owner: yalp
---
-
-SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('"Medias"', 'id'), 2, true);
-
-
---
--- TOC entry 1176 (class 1259 OID 17323)
--- Dependencies: 1495 1496 1497 5
--- Name: PropertyConnector; Type: TABLE; Schema: public; Owner: yalp; Tablespace: 
---
-
-CREATE TABLE "PropertyConnector" (
-    "mediaId" integer,
-    "stringPropertyId" integer DEFAULT 0,
-    "intPropertyId" integer DEFAULT 0,
-    id bigserial NOT NULL
-);
-
-
-ALTER TABLE public."PropertyConnector" OWNER TO yalp;
-
---
--- TOC entry 1170 (class 1259 OID 17294)
--- Dependencies: 1492 5
--- Name: StringProperties; Type: TABLE; Schema: public; Owner: yalp; Tablespace: 
---
-
-CREATE TABLE "StringProperties" (
-    id bigserial NOT NULL,
-    description text,
-    value text
-);
-
-
-ALTER TABLE public."StringProperties" OWNER TO yalp;
-
---
--- TOC entry 1524 (class 0 OID 0)
--- Dependencies: 1169
--- Name: StringProperties_id_seq; Type: SEQUENCE SET; Schema: public; Owner: yalp
---
-
-SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('"StringProperties"', 'id'), 1, false);
-
-
---
--- TOC entry 1167 (class 1259 OID 17269)
--- Dependencies: 1490 1491 5
--- Name: Users; Type: TABLE; Schema: public; Owner: yalp; Tablespace: 
---
-
-CREATE TABLE "Users" (
-    "level" integer DEFAULT 1 NOT NULL,
-    id bigserial NOT NULL,
-    name text NOT NULL,
-    "realName" text
-);
-
-
-ALTER TABLE public."Users" OWNER TO yalp;
-
---
--- TOC entry 1525 (class 0 OID 0)
--- Dependencies: 1168
--- Name: Users_id_seq; Type: SEQUENCE SET; Schema: public; Owner: yalp
---
-
-SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('"Users"', 'id'), 1, false);
-
-
---
--- TOC entry 1526 (class 0 OID 0)
--- Dependencies: 1175
--- Name: propertyConnector_id_seq; Type: SEQUENCE SET; Schema: public; Owner: yalp
---
-
-SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('"PropertyConnector"', 'id'), 1, false);
-
-
---
--- TOC entry 1515 (class 0 OID 17306)
--- Dependencies: 1172
--- Data for Name: IntProperties; Type: TABLE DATA; Schema: public; Owner: yalp
---
-
-COPY "IntProperties" (id, description, value) FROM stdin;
-\.
-
-
---
--- TOC entry 1516 (class 0 OID 17313)
--- Dependencies: 1174
--- 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 1517 (class 0 OID 17323)
--- Dependencies: 1176
--- Data for Name: PropertyConnector; Type: TABLE DATA; Schema: public; Owner: yalp
---
-
-COPY "PropertyConnector" ("mediaId", "stringPropertyId", "intPropertyId", id) FROM stdin;
-\.
-
-
---
--- TOC entry 1514 (class 0 OID 17294)
--- Dependencies: 1170
--- Data for Name: StringProperties; Type: TABLE DATA; Schema: public; Owner: yalp
---
-
-COPY "StringProperties" (id, description, value) FROM stdin;
-\.
-
-
---
--- TOC entry 1513 (class 0 OID 17269)
--- Dependencies: 1167
--- Data for Name: Users; Type: TABLE DATA; Schema: public; Owner: yalp
---
-
-COPY "Users" ("level", id, name, "realName") FROM stdin;
-\.
-
-
---
--- TOC entry 1509 (class 16386 OID 17329)
--- Dependencies: 1176 1176
--- Name: key_id_con; Type: CONSTRAINT; Schema: public; Owner: yalp; Tablespace: 
---
-
-ALTER TABLE ONLY "PropertyConnector"
-    ADD CONSTRAINT key_id_con PRIMARY KEY (id);
-
-
-ALTER INDEX public.key_id_con OWNER TO yalp;
-
---
--- TOC entry 1499 (class 16386 OID 17291)
--- Dependencies: 1167 1167
--- Name: key_is_id; Type: CONSTRAINT; Schema: public; Owner: yalp; Tablespace: 
---
-
-ALTER TABLE ONLY "Users"
-    ADD CONSTRAINT key_is_id PRIMARY KEY (id);
-
-
-ALTER INDEX public.key_is_id OWNER TO yalp;
-
---
--- TOC entry 1503 (class 16386 OID 17298)
--- Dependencies: 1170 1170
--- Name: prim_key_id; Type: CONSTRAINT; Schema: public; Owner: yalp; Tablespace: 
---
-
-ALTER TABLE ONLY "StringProperties"
-    ADD CONSTRAINT prim_key_id PRIMARY KEY (id);
-
-
-ALTER INDEX public.prim_key_id OWNER TO yalp;
-
---
--- TOC entry 1505 (class 16386 OID 17310)
--- Dependencies: 1172 1172
--- 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);
-
-
-ALTER INDEX public.prim_key_int_id OWNER TO yalp;
-
---
--- TOC entry 1507 (class 16386 OID 17320)
--- Dependencies: 1174 1174
--- 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);
-
-
-ALTER INDEX public.prim_key_m_id OWNER TO yalp;
-
---
--- TOC entry 1501 (class 16386 OID 17405)
--- Dependencies: 1167 1167
--- Name: username_is_unique; Type: CONSTRAINT; Schema: public; Owner: yalp; Tablespace: 
---
-
-ALTER TABLE ONLY "Users"
-    ADD CONSTRAINT username_is_unique UNIQUE (name);
-
-
-ALTER INDEX public.username_is_unique OWNER TO yalp;
-
---
--- TOC entry 1511 (class 16386 OID 17334)
--- Dependencies: 1176 1172 1504
--- 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 1510 (class 16386 OID 17330)
--- Dependencies: 1176 1174 1506
--- 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 1512 (class 16386 OID 17338)
--- Dependencies: 1176 1170 1502
--- 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 1521 (class 0 OID 0)
--- Dependencies: 5
--- 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 2008-09-25 00:44:25 CEST
-
---
--- PostgreSQL database dump complete
---
-
diff --git a/src/YalpInputs/YalpPGSqlInput/db-design-sql.backup b/src/YalpInputs/YalpPGSqlInput/db-design-sql.backup
new file mode 100644
index 0000000..37c1585
--- /dev/null
+++ b/src/YalpInputs/YalpPGSqlInput/db-design-sql.backup