This site has been permanently archived. This is a static copy provided by the University of Southampton.
-- -- PostgreSQL database dump -- -- Started on 2007-02-20 17:05:16 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 78604) -- 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 78524) -- Dependencies: 4 -- Name: control_transfe_transfer_id_seq; Type: SEQUENCE; Schema: public; Owner: jopera -- CREATE SEQUENCE control_transfe_transfer_id_seq START WITH 1 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', 1, false); SET default_tablespace = ''; SET default_with_oids = false; -- -- TOC entry 1221 (class 1259 OID 78606) -- 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 78526) -- 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 78620) -- 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 78622) -- 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 78716) -- 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', 6, true); -- -- TOC entry 1233 (class 1259 OID 78718) -- 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 78632) -- 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 78634) -- 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 78494) -- 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', 6, true); -- -- TOC entry 1217 (class 1259 OID 78496) -- 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 78680) -- 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', 2, true); -- -- TOC entry 1231 (class 1259 OID 78682) -- 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 78648) -- 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 78650) -- 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 78451) -- 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', 2, true); -- -- TOC entry 1215 (class 1259 OID 78453) -- 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 78664) -- 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 78666) -- 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 78440) -- 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', 2, true); -- -- TOC entry 1213 (class 1259 OID 78442) -- 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 78606) -- 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 78526) -- 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; \. -- -- TOC entry 1618 (class 0 OID 78622) -- 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 78718) -- 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.hdr 2 String C:\\fmri\\resliced1 3 String C:\\fmri\\resliced2 4 String C:\\fmri\\resliced3 5 String C:\\fmri\\resliced4 6 String C:\\fmri\\atlas.hdr\n \. -- -- TOC entry 1619 (class 0 OID 78634) -- 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 78496) -- 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 2 2 1 1 1 1 1 atlasHeader atlasHeader data_item_string 2 2 2 1 1 1 1 2 reslicedImage1 reslicedImage1 data_item_string 3 2 2 1 1 1 1 3 reslicedImage2 reslicedImage2 data_item_string 4 2 2 1 1 1 1 4 reslicedImage3 reslicedImage3 data_item_string 5 2 2 1 1 1 1 5 reslicedImage4 reslicedImage4 data_item_string 6 1 1 2 2 0 0 6 stdout stdout data_item_string \. -- -- TOC entry 1622 (class 0 OID 78682) -- 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 2 1 2 1 0 3 -1 2 \. -- -- TOC entry 1620 (class 0 OID 78650) -- 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 78453) -- 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 softmean {fmri_part2}FMRI_2[1.0].softmean.0 4 1 2007-02-20 17:01:00.268 2007-02-20 17:01:00.268 2007-02-20 17:02:13.877 73.608999999999995 2 2 0 0 {fmri_part2}FMRI_2[1.0].0.0 4 1 2007-02-20 17:01:00.268 2007-02-20 17:01:00.268 2007-02-20 17:02:13.893 73.625 \. -- -- TOC entry 1621 (class 0 OID 78666) -- 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 78442) -- 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_part2}softmean[1.0] act__fmri_part2_softmean_1_0_ f 1.0 Stable 2 {fmri_part2}FMRI_2[1.0] proc__fmri_part2_fmri_2_1_0_ t 1.0 Stable \. -- -- TOC entry 1579 (class 2606 OID 78613) -- 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 78530) -- 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 78629) -- 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 78725) -- 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 78641) -- 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 78503) -- 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 78688) -- 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 78686) -- 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 78657) -- 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 78460) -- 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 78673) -- 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 78449) -- 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 78614) -- 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 78531) -- 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 78630) -- 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 78631) -- 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 78642) -- 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 78450) -- 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 78658) -- 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 78674) -- 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 78461) -- 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 78615) -- Dependencies: 1219 1575 1221 -- 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 78542) -- Dependencies: 1219 1569 1215 -- 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 78532) -- Dependencies: 1219 1213 1567 -- 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 78514) -- Dependencies: 1215 1569 1217 -- 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 78504) -- Dependencies: 1217 1213 1567 -- 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 78519) -- Dependencies: 1215 1569 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 78509) -- Dependencies: 1567 1213 1217 -- 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 78643) -- Dependencies: 1572 1225 1217 -- 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 78689) -- Dependencies: 1231 1569 1215 -- 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 78547) -- 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 78537) -- Dependencies: 1567 1213 1219 -- 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 78659) -- Dependencies: 1227 1567 1213 -- 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 78675) -- Dependencies: 1229 1215 1569 -- 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 78462) -- 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:05:17 W. Europe Standard Time -- -- PostgreSQL database dump complete --