1 files changed, 321 insertions, 0 deletions
diff --git a/src/YalpInputs/YalpPGSqlInput/db-design-backup.sql b/src/YalpInputs/YalpPGSqlInput/db-design-backup.sql
new file mode 100644
index 0000000..0ab8d4d
--- /dev/null
+++ b/src/YalpInputs/YalpPGSqlInput/db-design-backup.sql
@@ -0,0 +1,321 @@
+--
+-- PostgreSQL database dump
+--
+
+-- Started on 2008-09-23 20:48:41 CEST
+
+SET client_encoding = 'UNICODE';
+SET check_function_bodies = false;
+SET client_min_messages = warning;
+
+--
+-- TOC entry 1518 (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 1170 (class 1259 OID 17306)
+-- Dependencies: 1491 5
+-- Name: IntProperties; Type: TABLE; Schema: public; Owner: yalp; Tablespace: 
+--
+
+CREATE TABLE "IntProperties" (
+    id bigserial NOT NULL,
+    description "char",
+    value integer
+);
+
+
+ALTER TABLE public."IntProperties" OWNER TO yalp;
+
+--
+-- TOC entry 1520 (class 0 OID 0)
+-- Dependencies: 1169
+-- 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 1172 (class 1259 OID 17313)
+-- Dependencies: 1492 5
+-- Name: Medias; Type: TABLE; Schema: public; Owner: yalp; Tablespace: 
+--
+
+CREATE TABLE "Medias" (
+    id bigserial NOT NULL,
+    "type" character(1),
+    path "char",
+    "fileName" "char",
+    tags "char"[],
+    duration "char"
+);
+
+
+ALTER TABLE public."Medias" OWNER TO yalp;
+
+--
+-- TOC entry 1521 (class 0 OID 0)
+-- Dependencies: 1171
+-- Name: Medias_id_seq; Type: SEQUENCE SET; Schema: public; Owner: yalp
+--
+
+SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('"Medias"', 'id'), 1, false);
+
+
+--
+-- TOC entry 1174 (class 1259 OID 17323)
+-- Dependencies: 1493 1494 1495 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 1168 (class 1259 OID 17294)
+-- Dependencies: 1490 5
+-- Name: StringProperties; Type: TABLE; Schema: public; Owner: yalp; Tablespace: 
+--
+
+CREATE TABLE "StringProperties" (
+    id bigserial NOT NULL,
+    description "char",
+    value "char"
+);
+
+
+ALTER TABLE public."StringProperties" OWNER TO yalp;
+
+--
+-- TOC entry 1522 (class 0 OID 0)
+-- Dependencies: 1167
+-- 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 1165 (class 1259 OID 17269)
+-- Dependencies: 1488 1489 5
+-- Name: Users; Type: TABLE; Schema: public; Owner: yalp; Tablespace: 
+--
+
+CREATE TABLE "Users" (
+    name "char"[] NOT NULL,
+    "realName" name[],
+    "level" integer DEFAULT 1 NOT NULL,
+    id bigserial NOT NULL
+);
+
+
+ALTER TABLE public."Users" OWNER TO yalp;
+
+--
+-- TOC entry 1523 (class 0 OID 0)
+-- Dependencies: 1166
+-- 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 1524 (class 0 OID 0)
+-- Dependencies: 1173
+-- 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 1513 (class 0 OID 17306)
+-- Dependencies: 1170
+-- Data for Name: IntProperties; Type: TABLE DATA; Schema: public; Owner: yalp
+--
+
+COPY "IntProperties" (id, description, value) FROM stdin;
+\.
+
+
+--
+-- TOC entry 1514 (class 0 OID 17313)
+-- Dependencies: 1172
+-- Data for Name: Medias; Type: TABLE DATA; Schema: public; Owner: yalp
+--
+
+COPY "Medias" (id, "type", path, "fileName", tags, duration) FROM stdin;
+\.
+
+
+--
+-- TOC entry 1515 (class 0 OID 17323)
+-- Dependencies: 1174
+-- Data for Name: PropertyConnector; Type: TABLE DATA; Schema: public; Owner: yalp
+--
+
+COPY "PropertyConnector" ("mediaId", "stringPropertyId", "intPropertyId", id) FROM stdin;
+\.
+
+
+--
+-- TOC entry 1512 (class 0 OID 17294)
+-- Dependencies: 1168
+-- Data for Name: StringProperties; Type: TABLE DATA; Schema: public; Owner: yalp
+--
+
+COPY "StringProperties" (id, description, value) FROM stdin;
+\.
+
+
+--
+-- TOC entry 1511 (class 0 OID 17269)
+-- Dependencies: 1165
+-- Data for Name: Users; Type: TABLE DATA; Schema: public; Owner: yalp
+--
+
+COPY "Users" (name, "realName", "level", id) FROM stdin;
+\.
+
+
+--
+-- TOC entry 1507 (class 16386 OID 17329)
+-- Dependencies: 1174 1174
+-- 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 1497 (class 16386 OID 17291)
+-- Dependencies: 1165 1165
+-- 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 1501 (class 16386 OID 17298)
+-- Dependencies: 1168 1168
+-- 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 1503 (class 16386 OID 17310)
+-- Dependencies: 1170 1170
+-- 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 1505 (class 16386 OID 17320)
+-- Dependencies: 1172 1172
+-- 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 1499 (class 16386 OID 17278)
+-- Dependencies: 1165 1165
+-- Name: user_name_unique; Type: CONSTRAINT; Schema: public; Owner: yalp; Tablespace: 
+--
+
+ALTER TABLE ONLY "Users"
+    ADD CONSTRAINT user_name_unique UNIQUE (name);
+
+
+ALTER INDEX public.user_name_unique OWNER TO yalp;
+
+--
+-- TOC entry 1509 (class 16386 OID 17334)
+-- Dependencies: 1174 1170 1502
+-- 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 1508 (class 16386 OID 17330)
+-- Dependencies: 1174 1172 1504
+-- 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 1510 (class 16386 OID 17338)
+-- Dependencies: 1174 1168 1500
+-- 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 1519 (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-23 20:48:41 CEST
+
+--
+-- PostgreSQL database dump complete
+--
+