-- -- PostgreSQL database dump -- -- Started on 2007-02-20 17:14:06 W. Europe Standard Time SET client_encoding = 'SQL_ASCII'; SET check_function_bodies = false; SET client_min_messages = warning; -- -- TOC entry 1625 (class 1262 OID 21121) -- Name: lineage3; Type: DATABASE; Schema: -; Owner: jopera -- CREATE DATABASE lineage3 WITH TEMPLATE = template0 ENCODING = 'SQL_ASCII'; \connect lineage3 SET client_encoding = 'SQL_ASCII'; SET check_function_bodies = false; SET client_min_messages = warning; -- -- TOC entry 1626 (class 0 OID 0) -- Dependencies: 4 -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres -- COMMENT ON SCHEMA public IS 'Standard public schema'; -- -- TOC entry 278 (class 2612 OID 16386) -- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: -- CREATE PROCEDURAL LANGUAGE plpgsql; SET search_path = public, pg_catalog; -- -- TOC entry 1220 (class 1259 OID 78890) -- Dependencies: 4 -- Name: control_transfe_otations_id_seq; Type: SEQUENCE; Schema: public; Owner: jopera -- CREATE SEQUENCE control_transfe_otations_id_seq START WITH 1 INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; -- -- TOC entry 1628 (class 0 OID 0) -- Dependencies: 1220 -- Name: control_transfe_otations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: jopera -- SELECT pg_catalog.setval('control_transfe_otations_id_seq', 1, false); -- -- TOC entry 1218 (class 1259 OID 78810) -- Dependencies: 4 -- Name: control_transfe_transfer_id_seq; Type: SEQUENCE; Schema: public; Owner: jopera -- CREATE SEQUENCE control_transfe_transfer_id_seq INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; -- -- TOC entry 1629 (class 0 OID 0) -- Dependencies: 1218 -- Name: control_transfe_transfer_id_seq; Type: SEQUENCE SET; Schema: public; Owner: jopera -- SELECT pg_catalog.setval('control_transfe_transfer_id_seq', 3, true); SET default_tablespace = ''; SET default_with_oids = false; -- -- TOC entry 1221 (class 1259 OID 78892) -- Dependencies: 1559 4 -- Name: control_transfer_annotations; Type: TABLE; Schema: public; Owner: jopera; Tablespace: -- CREATE TABLE control_transfer_annotations ( control_transfer_annotations_id integer DEFAULT nextval('control_transfe_otations_id_seq'::regclass) NOT NULL, control_transfer_id integer NOT NULL, annotation text NOT NULL ); -- -- TOC entry 1219 (class 1259 OID 78812) -- Dependencies: 1558 4 -- Name: control_transfers; Type: TABLE; Schema: public; Owner: jopera; Tablespace: -- CREATE TABLE control_transfers ( control_transfer_id integer DEFAULT nextval('control_transfe_transfer_id_seq'::regclass) NOT NULL, src_transformation_id integer NOT NULL, src_execution_id integer NOT NULL, dst_transformation_id integer NOT NULL, dst_execution_id integer NOT NULL ); -- -- TOC entry 1222 (class 1259 OID 78906) -- Dependencies: 4 -- Name: data_item_annot_otations_id_seq; Type: SEQUENCE; Schema: public; Owner: jopera -- CREATE SEQUENCE data_item_annot_otations_id_seq START WITH 1 INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; -- -- TOC entry 1630 (class 0 OID 0) -- Dependencies: 1222 -- Name: data_item_annot_otations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: jopera -- SELECT pg_catalog.setval('data_item_annot_otations_id_seq', 1, false); -- -- TOC entry 1223 (class 1259 OID 78908) -- Dependencies: 1560 4 -- Name: data_item_annotations; Type: TABLE; Schema: public; Owner: jopera; Tablespace: -- CREATE TABLE data_item_annotations ( data_item_annotations_id integer DEFAULT nextval('data_item_annot_otations_id_seq'::regclass) NOT NULL, data_item_id integer NOT NULL, annotation text NOT NULL ); -- -- TOC entry 1232 (class 1259 OID 79011) -- Dependencies: 4 -- Name: data_item_string_id_seq; Type: SEQUENCE; Schema: public; Owner: jopera -- CREATE SEQUENCE data_item_string_id_seq INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; -- -- TOC entry 1631 (class 0 OID 0) -- Dependencies: 1232 -- Name: data_item_string_id_seq; Type: SEQUENCE SET; Schema: public; Owner: jopera -- SELECT pg_catalog.setval('data_item_string_id_seq', 4, true); -- -- TOC entry 1233 (class 1259 OID 79013) -- Dependencies: 1565 4 -- Name: data_item_string; Type: TABLE; Schema: public; Owner: jopera; Tablespace: -- CREATE TABLE data_item_string ( id integer DEFAULT nextval('data_item_string_id_seq'::regclass) NOT NULL, "type" text, name text, value text ); -- -- TOC entry 1224 (class 1259 OID 78918) -- Dependencies: 4 -- Name: data_transfer_a_otations_id_seq; Type: SEQUENCE; Schema: public; Owner: jopera -- CREATE SEQUENCE data_transfer_a_otations_id_seq START WITH 1 INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; -- -- TOC entry 1632 (class 0 OID 0) -- Dependencies: 1224 -- Name: data_transfer_a_otations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: jopera -- SELECT pg_catalog.setval('data_transfer_a_otations_id_seq', 1, false); -- -- TOC entry 1225 (class 1259 OID 78920) -- Dependencies: 1561 4 -- Name: data_transfer_annotations; Type: TABLE; Schema: public; Owner: jopera; Tablespace: -- CREATE TABLE data_transfer_annotations ( data_transfer_annotations_id integer DEFAULT nextval('data_transfer_a_otations_id_seq'::regclass) NOT NULL, data_transfer_id integer NOT NULL, annotation text NOT NULL ); -- -- TOC entry 1216 (class 1259 OID 78780) -- Dependencies: 4 -- Name: data_transfers_transfer_id_seq; Type: SEQUENCE; Schema: public; Owner: jopera -- CREATE SEQUENCE data_transfers_transfer_id_seq INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; -- -- TOC entry 1633 (class 0 OID 0) -- Dependencies: 1216 -- Name: data_transfers_transfer_id_seq; Type: SEQUENCE SET; Schema: public; Owner: jopera -- SELECT pg_catalog.setval('data_transfers_transfer_id_seq', 9, true); -- -- TOC entry 1217 (class 1259 OID 78782) -- Dependencies: 1557 4 -- Name: data_transfers; Type: TABLE; Schema: public; Owner: jopera; Tablespace: -- CREATE TABLE data_transfers ( data_transfer_id integer DEFAULT nextval('data_transfers_transfer_id_seq'::regclass) NOT NULL, src_transformation_id integer NOT NULL, src_execution_id integer NOT NULL, dst_transformation_id integer NOT NULL, dst_execution_id integer NOT NULL, dst_type smallint NOT NULL, src_type smallint NOT NULL, data_item_id integer NOT NULL, src_name text NOT NULL, dst_name text NOT NULL, data_item_table text NOT NULL ); -- -- TOC entry 1230 (class 1259 OID 78966) -- Dependencies: 4 -- Name: executions_hier_chy_tree_id_seq; Type: SEQUENCE; Schema: public; Owner: jopera -- CREATE SEQUENCE executions_hier_chy_tree_id_seq INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; -- -- TOC entry 1634 (class 0 OID 0) -- Dependencies: 1230 -- Name: executions_hier_chy_tree_id_seq; Type: SEQUENCE SET; Schema: public; Owner: jopera -- SELECT pg_catalog.setval('executions_hier_chy_tree_id_seq', 7, true); -- -- TOC entry 1231 (class 1259 OID 78968) -- Dependencies: 1564 4 -- Name: executions_hierarchy_tree; Type: TABLE; Schema: public; Owner: jopera; Tablespace: -- CREATE TABLE executions_hierarchy_tree ( executions_hierarchy_tree_id integer DEFAULT nextval('executions_hier_chy_tree_id_seq'::regclass) NOT NULL, hierarchy_tree_id integer NOT NULL, left_no integer NOT NULL, right_no integer NOT NULL, parent_execution_id integer NOT NULL, transformation_executions_id integer NOT NULL ); -- -- TOC entry 1226 (class 1259 OID 78934) -- Dependencies: 4 -- Name: transformation_otations_id_seq; Type: SEQUENCE; Schema: public; Owner: jopera -- CREATE SEQUENCE transformation_otations_id_seq START WITH 1 INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; -- -- TOC entry 1635 (class 0 OID 0) -- Dependencies: 1226 -- Name: transformation_otations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: jopera -- SELECT pg_catalog.setval('transformation_otations_id_seq', 1, false); -- -- TOC entry 1227 (class 1259 OID 78936) -- Dependencies: 1562 4 -- Name: transformation_annotations; Type: TABLE; Schema: public; Owner: jopera; Tablespace: -- CREATE TABLE transformation_annotations ( transformation_annotations_id integer DEFAULT nextval('transformation_otations_id_seq'::regclass) NOT NULL, transformation_id integer NOT NULL, annotation text NOT NULL ); -- -- TOC entry 1214 (class 1259 OID 78737) -- Dependencies: 4 -- Name: transformation_ecutions_id_seq; Type: SEQUENCE; Schema: public; Owner: jopera -- CREATE SEQUENCE transformation_ecutions_id_seq INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; -- -- TOC entry 1636 (class 0 OID 0) -- Dependencies: 1214 -- Name: transformation_ecutions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: jopera -- SELECT pg_catalog.setval('transformation_ecutions_id_seq', 7, true); -- -- TOC entry 1215 (class 1259 OID 78739) -- Dependencies: 1556 4 -- Name: transformation_executions; Type: TABLE; Schema: public; Owner: jopera; Tablespace: -- CREATE TABLE transformation_executions ( transformation_executions_id integer DEFAULT nextval('transformation_ecutions_id_seq'::regclass) NOT NULL, transformation_id integer NOT NULL, sc_instance text NOT NULL, sc_activity text NOT NULL, sc_tid text NOT NULL, s_state text NOT NULL, s_start text NOT NULL, s_startdt timestamp without time zone NOT NULL, s_readydt timestamp without time zone NOT NULL, s_enddt timestamp without time zone NOT NULL, s_wall double precision NOT NULL ); -- -- TOC entry 1228 (class 1259 OID 78950) -- Dependencies: 4 -- Name: transformation_notation_id_seq; Type: SEQUENCE; Schema: public; Owner: jopera -- CREATE SEQUENCE transformation_notation_id_seq START WITH 1 INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; -- -- TOC entry 1637 (class 0 OID 0) -- Dependencies: 1228 -- Name: transformation_notation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: jopera -- SELECT pg_catalog.setval('transformation_notation_id_seq', 1, false); -- -- TOC entry 1229 (class 1259 OID 78952) -- Dependencies: 1563 4 -- Name: transformation_tion_annotation; Type: TABLE; Schema: public; Owner: jopera; Tablespace: -- CREATE TABLE transformation_tion_annotation ( transformation_n_annotation_id integer DEFAULT nextval('transformation_notation_id_seq'::regclass) NOT NULL, transformation_executions_id integer NOT NULL, annotation text NOT NULL ); -- -- TOC entry 1212 (class 1259 OID 78726) -- Dependencies: 4 -- Name: transformations_ormation_id_seq; Type: SEQUENCE; Schema: public; Owner: jopera -- CREATE SEQUENCE transformations_ormation_id_seq INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; -- -- TOC entry 1638 (class 0 OID 0) -- Dependencies: 1212 -- Name: transformations_ormation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: jopera -- SELECT pg_catalog.setval('transformations_ormation_id_seq', 3, true); -- -- TOC entry 1213 (class 1259 OID 78728) -- Dependencies: 1555 4 -- Name: transformations; Type: TABLE; Schema: public; Owner: jopera; Tablespace: -- CREATE TABLE transformations ( transformation_id integer DEFAULT nextval('transformations_ormation_id_seq'::regclass) NOT NULL, name text, tablename text, is_process boolean, version text, status text, author text, description text ); -- -- TOC entry 1617 (class 0 OID 78892) -- Dependencies: 1221 -- Data for Name: control_transfer_annotations; Type: TABLE DATA; Schema: public; Owner: jopera -- COPY control_transfer_annotations (control_transfer_annotations_id, control_transfer_id, annotation) FROM stdin; \. -- -- TOC entry 1616 (class 0 OID 78812) -- Dependencies: 1219 -- Data for Name: control_transfers; Type: TABLE DATA; Schema: public; Owner: jopera -- COPY control_transfers (control_transfer_id, src_transformation_id, src_execution_id, dst_transformation_id, dst_execution_id) FROM stdin; 1 1 2 2 4 2 1 1 2 5 3 1 3 2 6 \. -- -- TOC entry 1618 (class 0 OID 78908) -- Dependencies: 1223 -- Data for Name: data_item_annotations; Type: TABLE DATA; Schema: public; Owner: jopera -- COPY data_item_annotations (data_item_annotations_id, data_item_id, annotation) FROM stdin; \. -- -- TOC entry 1623 (class 0 OID 79013) -- Dependencies: 1233 -- Data for Name: data_item_string; Type: TABLE DATA; Schema: public; Owner: jopera -- COPY data_item_string (id, "type", name, value) FROM stdin; 1 String C:\\fmri\\atlas-x 2 String C:\\fmri\\atlas-y 3 String C:\\fmri\\atlas-z 4 String C:\\fmri\\atlas.hdr \. -- -- TOC entry 1619 (class 0 OID 78920) -- Dependencies: 1225 -- Data for Name: data_transfer_annotations; Type: TABLE DATA; Schema: public; Owner: jopera -- COPY data_transfer_annotations (data_transfer_annotations_id, data_transfer_id, annotation) FROM stdin; \. -- -- TOC entry 1615 (class 0 OID 78782) -- Dependencies: 1217 -- Data for Name: data_transfers; Type: TABLE DATA; Schema: public; Owner: jopera -- COPY data_transfers (data_transfer_id, src_transformation_id, src_execution_id, dst_transformation_id, dst_execution_id, dst_type, src_type, data_item_id, src_name, dst_name, data_item_table) FROM stdin; 1 3 7 1 2 1 1 1 outImage1 outImage data_item_string 2 3 7 2 4 1 1 1 outImage1 imageFile data_item_string 3 3 7 1 1 1 1 2 outImage2 outImage data_item_string 4 3 7 2 5 1 1 2 outImage2 imageFile data_item_string 5 3 7 1 3 1 1 3 outImage3 outImage data_item_string 6 3 7 2 6 1 1 3 outImage3 imageFile data_item_string 7 3 7 1 2 1 1 4 atlasHeader atlasHeader data_item_string 8 3 7 1 1 1 1 4 atlasHeader atlasHeader data_item_string 9 3 7 1 3 1 1 4 atlasHeader atlasHeader data_item_string \. -- -- TOC entry 1622 (class 0 OID 78968) -- Dependencies: 1231 -- Data for Name: executions_hierarchy_tree; Type: TABLE DATA; Schema: public; Owner: jopera -- COPY executions_hierarchy_tree (executions_hierarchy_tree_id, hierarchy_tree_id, left_no, right_no, parent_execution_id, transformation_executions_id) FROM stdin; 1 1 1 2 7 3 2 1 3 4 7 6 3 1 5 6 7 1 4 1 7 8 7 5 5 1 9 10 7 2 6 1 11 12 7 4 7 1 0 13 -1 7 \. -- -- TOC entry 1620 (class 0 OID 78936) -- Dependencies: 1227 -- Data for Name: transformation_annotations; Type: TABLE DATA; Schema: public; Owner: jopera -- COPY transformation_annotations (transformation_annotations_id, transformation_id, annotation) FROM stdin; \. -- -- TOC entry 1614 (class 0 OID 78739) -- Dependencies: 1215 -- Data for Name: transformation_executions; Type: TABLE DATA; Schema: public; Owner: jopera -- COPY transformation_executions (transformation_executions_id, transformation_id, sc_instance, sc_activity, sc_tid, s_state, s_start, s_startdt, s_readydt, s_enddt, s_wall) FROM stdin; 1 1 0 slicer2 {fmri_part3}FMRI_3[1.0].slicer2.0 4 1 2007-02-20 17:07:11.956 2007-02-20 17:07:11.909 2007-02-20 17:10:20.237 188.328 2 1 0 slicer1 {fmri_part3}FMRI_3[1.0].slicer1.0 4 1 2007-02-20 17:07:11.909 2007-02-20 17:07:11.909 2007-02-20 17:10:21.096 189.18700000000001 3 1 0 slicer3 {fmri_part3}FMRI_3[1.0].slicer3.0 4 1 2007-02-20 17:07:11.956 2007-02-20 17:07:11.909 2007-02-20 17:10:21.252 189.34299999999999 4 2 0 convert1 {fmri_part3}FMRI_3[1.0].convert1.0 4 1 2007-02-20 17:10:20.815 2007-02-20 17:07:11.909 2007-02-20 17:10:58.315 226.40600000000001 5 2 0 convert2 {fmri_part3}FMRI_3[1.0].convert2.0 4 1 2007-02-20 17:10:17.768 2007-02-20 17:07:11.909 2007-02-20 17:10:58.315 226.40600000000001 6 2 0 convert3 {fmri_part3}FMRI_3[1.0].convert3.0 4 1 2007-02-20 17:10:21.096 2007-02-20 17:07:11.909 2007-02-20 17:10:58.315 226.40600000000001 7 3 0 0 {fmri_part3}FMRI_3[1.0].0.0 4 1 2007-02-20 17:07:11.909 2007-02-20 17:07:11.909 2007-02-20 17:10:58.315 226.40600000000001 \. -- -- TOC entry 1621 (class 0 OID 78952) -- Dependencies: 1229 -- Data for Name: transformation_tion_annotation; Type: TABLE DATA; Schema: public; Owner: jopera -- COPY transformation_tion_annotation (transformation_n_annotation_id, transformation_executions_id, annotation) FROM stdin; \. -- -- TOC entry 1613 (class 0 OID 78728) -- Dependencies: 1213 -- Data for Name: transformations; Type: TABLE DATA; Schema: public; Owner: jopera -- COPY transformations (transformation_id, name, tablename, is_process, version, status, author, description) FROM stdin; 1 {fmri_part3}slicer[1.0] act__fmri_part3_slicer_1_0_ f 1.0 Stable 2 {fmri_part3}convert[1.0] act__fmri_part3_convert_1_0_ f 1.0 Stable 3 {fmri_part3}FMRI_3[1.0] proc__fmri_part3_fmri_3_1_0_ t 1.0 Stable \. -- -- TOC entry 1579 (class 2606 OID 78899) -- Dependencies: 1221 1221 -- Name: control_transfer_annotations_pkey; Type: CONSTRAINT; Schema: public; Owner: jopera; Tablespace: -- ALTER TABLE ONLY control_transfer_annotations ADD CONSTRAINT control_transfer_annotations_pkey PRIMARY KEY (control_transfer_annotations_id); -- -- TOC entry 1576 (class 2606 OID 78816) -- Dependencies: 1219 1219 -- Name: control_transfers_pkey; Type: CONSTRAINT; Schema: public; Owner: jopera; Tablespace: -- ALTER TABLE ONLY control_transfers ADD CONSTRAINT control_transfers_pkey PRIMARY KEY (control_transfer_id); -- -- TOC entry 1582 (class 2606 OID 78915) -- Dependencies: 1223 1223 -- Name: data_item_annotations_pkey; Type: CONSTRAINT; Schema: public; Owner: jopera; Tablespace: -- ALTER TABLE ONLY data_item_annotations ADD CONSTRAINT data_item_annotations_pkey PRIMARY KEY (data_item_annotations_id); -- -- TOC entry 1598 (class 2606 OID 79020) -- Dependencies: 1233 1233 -- Name: data_item_string_pkey; Type: CONSTRAINT; Schema: public; Owner: jopera; Tablespace: -- ALTER TABLE ONLY data_item_string ADD CONSTRAINT data_item_string_pkey PRIMARY KEY (id); -- -- TOC entry 1586 (class 2606 OID 78927) -- Dependencies: 1225 1225 -- Name: data_transfer_annotations_pkey; Type: CONSTRAINT; Schema: public; Owner: jopera; Tablespace: -- ALTER TABLE ONLY data_transfer_annotations ADD CONSTRAINT data_transfer_annotations_pkey PRIMARY KEY (data_transfer_annotations_id); -- -- TOC entry 1573 (class 2606 OID 78789) -- Dependencies: 1217 1217 -- Name: data_transfers_pkey; Type: CONSTRAINT; Schema: public; Owner: jopera; Tablespace: -- ALTER TABLE ONLY data_transfers ADD CONSTRAINT data_transfers_pkey PRIMARY KEY (data_transfer_id); -- -- TOC entry 1594 (class 2606 OID 78974) -- Dependencies: 1231 1231 -- Name: executions_hierarchy_tree_executions_hierarchy_tree_id_key; Type: CONSTRAINT; Schema: public; Owner: jopera; Tablespace: -- ALTER TABLE ONLY executions_hierarchy_tree ADD CONSTRAINT executions_hierarchy_tree_executions_hierarchy_tree_id_key UNIQUE (executions_hierarchy_tree_id); -- -- TOC entry 1596 (class 2606 OID 78972) -- Dependencies: 1231 1231 1231 1231 1231 -- Name: executions_hierarchy_tree_pkey; Type: CONSTRAINT; Schema: public; Owner: jopera; Tablespace: -- ALTER TABLE ONLY executions_hierarchy_tree ADD CONSTRAINT executions_hierarchy_tree_pkey PRIMARY KEY (executions_hierarchy_tree_id, left_no, right_no, parent_execution_id); -- -- TOC entry 1588 (class 2606 OID 78943) -- Dependencies: 1227 1227 -- Name: transformation_annotations_pkey; Type: CONSTRAINT; Schema: public; Owner: jopera; Tablespace: -- ALTER TABLE ONLY transformation_annotations ADD CONSTRAINT transformation_annotations_pkey PRIMARY KEY (transformation_annotations_id); -- -- TOC entry 1570 (class 2606 OID 78746) -- Dependencies: 1215 1215 -- Name: transformation_executions_pkey; Type: CONSTRAINT; Schema: public; Owner: jopera; Tablespace: -- ALTER TABLE ONLY transformation_executions ADD CONSTRAINT transformation_executions_pkey PRIMARY KEY (transformation_executions_id); -- -- TOC entry 1591 (class 2606 OID 78959) -- Dependencies: 1229 1229 -- Name: transformation_tion_annotation_pkey; Type: CONSTRAINT; Schema: public; Owner: jopera; Tablespace: -- ALTER TABLE ONLY transformation_tion_annotation ADD CONSTRAINT transformation_tion_annotation_pkey PRIMARY KEY (transformation_n_annotation_id); -- -- TOC entry 1568 (class 2606 OID 78735) -- Dependencies: 1213 1213 -- Name: transformations_pkey; Type: CONSTRAINT; Schema: public; Owner: jopera; Tablespace: -- ALTER TABLE ONLY transformations ADD CONSTRAINT transformations_pkey PRIMARY KEY (transformation_id); -- -- TOC entry 1577 (class 1259 OID 78900) -- Dependencies: 1221 -- Name: control_transfer_annotations_id; Type: INDEX; Schema: public; Owner: jopera; Tablespace: -- CREATE UNIQUE INDEX control_transfer_annotations_id ON control_transfer_annotations USING btree (control_transfer_annotations_id); -- -- TOC entry 1574 (class 1259 OID 78817) -- Dependencies: 1219 -- Name: control_transfer_id_unique; Type: INDEX; Schema: public; Owner: jopera; Tablespace: -- CREATE UNIQUE INDEX control_transfer_id_unique ON control_transfers USING btree (control_transfer_id); -- -- TOC entry 1580 (class 1259 OID 78916) -- Dependencies: 1223 -- Name: data_item_annotations_id_unique; Type: INDEX; Schema: public; Owner: jopera; Tablespace: -- CREATE UNIQUE INDEX data_item_annotations_id_unique ON data_item_annotations USING btree (data_item_annotations_id); -- -- TOC entry 1583 (class 1259 OID 78917) -- Dependencies: 1223 -- Name: data_item_idu; Type: INDEX; Schema: public; Owner: jopera; Tablespace: -- CREATE UNIQUE INDEX data_item_idu ON data_item_annotations USING btree (data_item_id); -- -- TOC entry 1584 (class 1259 OID 78928) -- Dependencies: 1225 -- Name: data_transfer_annotations_id; Type: INDEX; Schema: public; Owner: jopera; Tablespace: -- CREATE UNIQUE INDEX data_transfer_annotations_id ON data_transfer_annotations USING btree (data_transfer_annotations_id); -- -- TOC entry 1566 (class 1259 OID 78736) -- Dependencies: 1213 -- Name: transformation_id_unique; Type: INDEX; Schema: public; Owner: jopera; Tablespace: -- CREATE UNIQUE INDEX transformation_id_unique ON transformations USING btree (transformation_id); -- -- TOC entry 1589 (class 1259 OID 78944) -- Dependencies: 1227 -- Name: trf_anno_idu; Type: INDEX; Schema: public; Owner: jopera; Tablespace: -- CREATE UNIQUE INDEX trf_anno_idu ON transformation_annotations USING btree (transformation_annotations_id); -- -- TOC entry 1592 (class 1259 OID 78960) -- Dependencies: 1229 -- Name: trf_exec_anno_idu; Type: INDEX; Schema: public; Owner: jopera; Tablespace: -- CREATE UNIQUE INDEX trf_exec_anno_idu ON transformation_tion_annotation USING btree (transformation_n_annotation_id); -- -- TOC entry 1571 (class 1259 OID 78747) -- Dependencies: 1215 -- Name: trf_exec_id_uq; Type: INDEX; Schema: public; Owner: jopera; Tablespace: -- CREATE UNIQUE INDEX trf_exec_id_uq ON transformation_executions USING btree (transformation_executions_id); -- -- TOC entry 1608 (class 2606 OID 78901) -- Dependencies: 1219 1221 1575 -- Name: ct_trf_ann_fkey; Type: FK CONSTRAINT; Schema: public; Owner: jopera -- ALTER TABLE ONLY control_transfer_annotations ADD CONSTRAINT ct_trf_ann_fkey FOREIGN KEY (control_transfer_id) REFERENCES control_transfers(control_transfer_id); -- -- TOC entry 1606 (class 2606 OID 78828) -- Dependencies: 1215 1219 1569 -- Name: dst_exec_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: jopera -- ALTER TABLE ONLY control_transfers ADD CONSTRAINT dst_exec_id_fkey FOREIGN KEY (dst_execution_id) REFERENCES transformation_executions(transformation_executions_id); -- -- TOC entry 1604 (class 2606 OID 78818) -- Dependencies: 1567 1213 1219 -- Name: dst_trf_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: jopera -- ALTER TABLE ONLY control_transfers ADD CONSTRAINT dst_trf_id_fkey FOREIGN KEY (dst_transformation_id) REFERENCES transformations(transformation_id); -- -- TOC entry 1602 (class 2606 OID 78800) -- Dependencies: 1217 1569 1215 -- Name: dt_dst_exec_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: jopera -- ALTER TABLE ONLY data_transfers ADD CONSTRAINT dt_dst_exec_id_fkey FOREIGN KEY (dst_execution_id) REFERENCES transformation_executions(transformation_executions_id); -- -- TOC entry 1600 (class 2606 OID 78790) -- Dependencies: 1213 1567 1217 -- Name: dt_dst_trafo_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: jopera -- ALTER TABLE ONLY data_transfers ADD CONSTRAINT dt_dst_trafo_id_fkey FOREIGN KEY (dst_transformation_id) REFERENCES transformations(transformation_id); -- -- TOC entry 1603 (class 2606 OID 78805) -- Dependencies: 1569 1215 1217 -- Name: dt_src_exec_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: jopera -- ALTER TABLE ONLY data_transfers ADD CONSTRAINT dt_src_exec_id_fkey FOREIGN KEY (src_execution_id) REFERENCES transformation_executions(transformation_executions_id); -- -- TOC entry 1601 (class 2606 OID 78795) -- Dependencies: 1217 1213 1567 -- Name: dt_src_trafo_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: jopera -- ALTER TABLE ONLY data_transfers ADD CONSTRAINT dt_src_trafo_id_fkey FOREIGN KEY (src_transformation_id) REFERENCES transformations(transformation_id); -- -- TOC entry 1609 (class 2606 OID 78929) -- Dependencies: 1217 1225 1572 -- Name: dt_trf_ann_fkey; Type: FK CONSTRAINT; Schema: public; Owner: jopera -- ALTER TABLE ONLY data_transfer_annotations ADD CONSTRAINT dt_trf_ann_fkey FOREIGN KEY (data_transfer_id) REFERENCES data_transfers(data_transfer_id); -- -- TOC entry 1612 (class 2606 OID 78975) -- Dependencies: 1215 1231 1569 -- Name: exec_hier_trafo_id; Type: FK CONSTRAINT; Schema: public; Owner: jopera -- ALTER TABLE ONLY executions_hierarchy_tree ADD CONSTRAINT exec_hier_trafo_id FOREIGN KEY (transformation_executions_id) REFERENCES transformation_executions(transformation_executions_id); -- -- TOC entry 1607 (class 2606 OID 78833) -- Dependencies: 1219 1215 1569 -- Name: src_exec_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: jopera -- ALTER TABLE ONLY control_transfers ADD CONSTRAINT src_exec_id_fkey FOREIGN KEY (src_execution_id) REFERENCES transformation_executions(transformation_executions_id); -- -- TOC entry 1605 (class 2606 OID 78823) -- Dependencies: 1567 1219 1213 -- Name: src_trf_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: jopera -- ALTER TABLE ONLY control_transfers ADD CONSTRAINT src_trf_id_fkey FOREIGN KEY (src_transformation_id) REFERENCES transformations(transformation_id); -- -- TOC entry 1610 (class 2606 OID 78945) -- Dependencies: 1213 1567 1227 -- Name: tr_anno_fkey; Type: FK CONSTRAINT; Schema: public; Owner: jopera -- ALTER TABLE ONLY transformation_annotations ADD CONSTRAINT tr_anno_fkey FOREIGN KEY (transformation_id) REFERENCES transformations(transformation_id); -- -- TOC entry 1611 (class 2606 OID 78961) -- Dependencies: 1215 1569 1229 -- Name: tr_exec_anno_fkey; Type: FK CONSTRAINT; Schema: public; Owner: jopera -- ALTER TABLE ONLY transformation_tion_annotation ADD CONSTRAINT tr_exec_anno_fkey FOREIGN KEY (transformation_executions_id) REFERENCES transformation_executions(transformation_executions_id); -- -- TOC entry 1599 (class 2606 OID 78748) -- Dependencies: 1213 1215 1567 -- Name: trf_exec_fkey; Type: FK CONSTRAINT; Schema: public; Owner: jopera -- ALTER TABLE ONLY transformation_executions ADD CONSTRAINT trf_exec_fkey FOREIGN KEY (transformation_id) REFERENCES transformations(transformation_id); -- -- TOC entry 1627 (class 0 OID 0) -- Dependencies: 4 -- 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 2007-02-20 17:14:08 W. Europe Standard Time -- -- PostgreSQL database dump complete --