diff options
Diffstat (limited to 'src/YalpInputs/YalpPGSqlInput/db-design-backup.sql')
| -rw-r--r-- | src/YalpInputs/YalpPGSqlInput/db-design-backup.sql | 139 |
1 files changed, 71 insertions, 68 deletions
diff --git a/src/YalpInputs/YalpPGSqlInput/db-design-backup.sql b/src/YalpInputs/YalpPGSqlInput/db-design-backup.sql index 0ab8d4d..bbdd0d9 100644 --- a/src/YalpInputs/YalpPGSqlInput/db-design-backup.sql +++ b/src/YalpInputs/YalpPGSqlInput/db-design-backup.sql @@ -2,14 +2,14 @@ -- PostgreSQL database dump -- --- Started on 2008-09-23 20:48:41 CEST +-- 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 1518 (class 0 OID 0) +-- TOC entry 1520 (class 0 OID 0) -- Dependencies: 5 -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres -- @@ -24,14 +24,14 @@ SET default_tablespace = ''; SET default_with_oids = false; -- --- TOC entry 1170 (class 1259 OID 17306) --- Dependencies: 1491 5 +-- 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 "char", + description text, value integer ); @@ -39,8 +39,8 @@ CREATE TABLE "IntProperties" ( ALTER TABLE public."IntProperties" OWNER TO yalp; -- --- TOC entry 1520 (class 0 OID 0) --- Dependencies: 1169 +-- TOC entry 1522 (class 0 OID 0) +-- Dependencies: 1171 -- Name: IntProperties_id_seq; Type: SEQUENCE SET; Schema: public; Owner: yalp -- @@ -48,35 +48,36 @@ SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('"IntProperties"', 'i -- --- TOC entry 1172 (class 1259 OID 17313) --- Dependencies: 1492 5 +-- 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 "char", - "fileName" "char", - tags "char"[], - duration "char" + path text, + "fileName" text, + duration text, + name text, + tags text ); ALTER TABLE public."Medias" OWNER TO yalp; -- --- TOC entry 1521 (class 0 OID 0) --- Dependencies: 1171 +-- 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'), 1, false); +SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('"Medias"', 'id'), 2, true); -- --- TOC entry 1174 (class 1259 OID 17323) --- Dependencies: 1493 1494 1495 5 +-- TOC entry 1176 (class 1259 OID 17323) +-- Dependencies: 1495 1496 1497 5 -- Name: PropertyConnector; Type: TABLE; Schema: public; Owner: yalp; Tablespace: -- @@ -91,23 +92,23 @@ CREATE TABLE "PropertyConnector" ( ALTER TABLE public."PropertyConnector" OWNER TO yalp; -- --- TOC entry 1168 (class 1259 OID 17294) --- Dependencies: 1490 5 +-- 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 "char", - value "char" + description text, + value text ); ALTER TABLE public."StringProperties" OWNER TO yalp; -- --- TOC entry 1522 (class 0 OID 0) --- Dependencies: 1167 +-- TOC entry 1524 (class 0 OID 0) +-- Dependencies: 1169 -- Name: StringProperties_id_seq; Type: SEQUENCE SET; Schema: public; Owner: yalp -- @@ -115,24 +116,24 @@ SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('"StringProperties"', -- --- TOC entry 1165 (class 1259 OID 17269) --- Dependencies: 1488 1489 5 +-- TOC entry 1167 (class 1259 OID 17269) +-- Dependencies: 1490 1491 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 + id bigserial NOT NULL, + name text NOT NULL, + "realName" text ); ALTER TABLE public."Users" OWNER TO yalp; -- --- TOC entry 1523 (class 0 OID 0) --- Dependencies: 1166 +-- TOC entry 1525 (class 0 OID 0) +-- Dependencies: 1168 -- Name: Users_id_seq; Type: SEQUENCE SET; Schema: public; Owner: yalp -- @@ -140,8 +141,8 @@ SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('"Users"', 'id'), 1, -- --- TOC entry 1524 (class 0 OID 0) --- Dependencies: 1173 +-- TOC entry 1526 (class 0 OID 0) +-- Dependencies: 1175 -- Name: propertyConnector_id_seq; Type: SEQUENCE SET; Schema: public; Owner: yalp -- @@ -149,8 +150,8 @@ SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('"PropertyConnector"' -- --- TOC entry 1513 (class 0 OID 17306) --- Dependencies: 1170 +-- TOC entry 1515 (class 0 OID 17306) +-- Dependencies: 1172 -- Data for Name: IntProperties; Type: TABLE DATA; Schema: public; Owner: yalp -- @@ -159,18 +160,20 @@ COPY "IntProperties" (id, description, value) FROM stdin; -- --- TOC entry 1514 (class 0 OID 17313) --- Dependencies: 1172 +-- 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", tags, duration) FROM stdin; +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 1515 (class 0 OID 17323) --- Dependencies: 1174 +-- TOC entry 1517 (class 0 OID 17323) +-- Dependencies: 1176 -- Data for Name: PropertyConnector; Type: TABLE DATA; Schema: public; Owner: yalp -- @@ -179,8 +182,8 @@ COPY "PropertyConnector" ("mediaId", "stringPropertyId", "intPropertyId", id) FR -- --- TOC entry 1512 (class 0 OID 17294) --- Dependencies: 1168 +-- TOC entry 1514 (class 0 OID 17294) +-- Dependencies: 1170 -- Data for Name: StringProperties; Type: TABLE DATA; Schema: public; Owner: yalp -- @@ -189,18 +192,18 @@ COPY "StringProperties" (id, description, value) FROM stdin; -- --- TOC entry 1511 (class 0 OID 17269) --- Dependencies: 1165 +-- TOC entry 1513 (class 0 OID 17269) +-- Dependencies: 1167 -- Data for Name: Users; Type: TABLE DATA; Schema: public; Owner: yalp -- -COPY "Users" (name, "realName", "level", id) FROM stdin; +COPY "Users" ("level", id, name, "realName") FROM stdin; \. -- --- TOC entry 1507 (class 16386 OID 17329) --- Dependencies: 1174 1174 +-- TOC entry 1509 (class 16386 OID 17329) +-- Dependencies: 1176 1176 -- Name: key_id_con; Type: CONSTRAINT; Schema: public; Owner: yalp; Tablespace: -- @@ -211,8 +214,8 @@ ALTER TABLE ONLY "PropertyConnector" ALTER INDEX public.key_id_con OWNER TO yalp; -- --- TOC entry 1497 (class 16386 OID 17291) --- Dependencies: 1165 1165 +-- TOC entry 1499 (class 16386 OID 17291) +-- Dependencies: 1167 1167 -- Name: key_is_id; Type: CONSTRAINT; Schema: public; Owner: yalp; Tablespace: -- @@ -223,8 +226,8 @@ ALTER TABLE ONLY "Users" ALTER INDEX public.key_is_id OWNER TO yalp; -- --- TOC entry 1501 (class 16386 OID 17298) --- Dependencies: 1168 1168 +-- TOC entry 1503 (class 16386 OID 17298) +-- Dependencies: 1170 1170 -- Name: prim_key_id; Type: CONSTRAINT; Schema: public; Owner: yalp; Tablespace: -- @@ -235,8 +238,8 @@ ALTER TABLE ONLY "StringProperties" ALTER INDEX public.prim_key_id OWNER TO yalp; -- --- TOC entry 1503 (class 16386 OID 17310) --- Dependencies: 1170 1170 +-- TOC entry 1505 (class 16386 OID 17310) +-- Dependencies: 1172 1172 -- Name: prim_key_int_id; Type: CONSTRAINT; Schema: public; Owner: yalp; Tablespace: -- @@ -247,8 +250,8 @@ ALTER TABLE ONLY "IntProperties" ALTER INDEX public.prim_key_int_id OWNER TO yalp; -- --- TOC entry 1505 (class 16386 OID 17320) --- Dependencies: 1172 1172 +-- TOC entry 1507 (class 16386 OID 17320) +-- Dependencies: 1174 1174 -- Name: prim_key_m_id; Type: CONSTRAINT; Schema: public; Owner: yalp; Tablespace: -- @@ -259,20 +262,20 @@ ALTER TABLE ONLY "Medias" 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: +-- 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 user_name_unique UNIQUE (name); + ADD CONSTRAINT username_is_unique UNIQUE (name); -ALTER INDEX public.user_name_unique OWNER TO yalp; +ALTER INDEX public.username_is_unique OWNER TO yalp; -- --- TOC entry 1509 (class 16386 OID 17334) --- Dependencies: 1174 1170 1502 +-- TOC entry 1511 (class 16386 OID 17334) +-- Dependencies: 1176 1172 1504 -- Name: int_prop; Type: FK CONSTRAINT; Schema: public; Owner: yalp -- @@ -281,8 +284,8 @@ ALTER TABLE ONLY "PropertyConnector" -- --- TOC entry 1508 (class 16386 OID 17330) --- Dependencies: 1174 1172 1504 +-- TOC entry 1510 (class 16386 OID 17330) +-- Dependencies: 1176 1174 1506 -- Name: media_prop; Type: FK CONSTRAINT; Schema: public; Owner: yalp -- @@ -291,8 +294,8 @@ ALTER TABLE ONLY "PropertyConnector" -- --- TOC entry 1510 (class 16386 OID 17338) --- Dependencies: 1174 1168 1500 +-- TOC entry 1512 (class 16386 OID 17338) +-- Dependencies: 1176 1170 1502 -- Name: string_prop; Type: FK CONSTRAINT; Schema: public; Owner: yalp -- @@ -301,7 +304,7 @@ ALTER TABLE ONLY "PropertyConnector" -- --- TOC entry 1519 (class 0 OID 0) +-- TOC entry 1521 (class 0 OID 0) -- Dependencies: 5 -- Name: public; Type: ACL; Schema: -; Owner: postgres -- @@ -313,7 +316,7 @@ GRANT ALL ON SCHEMA public TO yalp; GRANT ALL ON SCHEMA public TO PUBLIC; --- Completed on 2008-09-23 20:48:41 CEST +-- Completed on 2008-09-25 00:44:25 CEST -- -- PostgreSQL database dump complete |