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 16:57:32 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 78309) -- 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 78229) -- 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', 4, true); SET default_tablespace = ''; SET default_with_oids = false; -- -- TOC entry 1221 (class 1259 OID 78311) -- 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 78231) -- 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 78325) -- 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 78327) -- 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 78419) -- 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', 21, true); -- -- TOC entry 1233 (class 1259 OID 78421) -- 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 78337) -- 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 78339) -- 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 78199) -- 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', 24, true); -- -- TOC entry 1217 (class 1259 OID 78201) -- 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 78385) -- 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', 9, true); -- -- TOC entry 1231 (class 1259 OID 78387) -- 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 78353) -- 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 78355) -- 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 78156) -- 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', 9, true); -- -- TOC entry 1215 (class 1259 OID 78158) -- 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 78369) -- 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 78371) -- 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 78145) -- 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 78147) -- 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 78311) -- 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 78231) -- 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 4 2 5 2 1 3 2 6 3 1 2 2 7 4 1 1 2 8 \. -- -- TOC entry 1618 (class 0 OID 78327) -- 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 78421) -- 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\\warp1.warp\n 2 String C:\\fmri\\warp4.warp\n 3 String C:\\fmri\\warp2.warp\n 4 String C:\\fmri\\warp3.warp\n 5 String C:\\fmri\\anatomy1.img 6 String C:\\fmri\\warp1.warp 7 String C:\\fmri\\reference.img 8 String C:\\fmri\\anatomy2.img 9 String C:\\fmri\\warp2.warp 10 String C:\\fmri\\anatomy3.img 11 String C:\\fmri\\warp3.warp 12 String C:\\fmri\\anatomy4.img 13 String C:\\fmri\\warp4.warp 14 String C:\\fmri\\resliced4 15 String C:\\fmri\\resliced1 16 String C:\\fmri\\resliced2 17 String C:\\fmri\\resliced3 18 String C:\\fmri\\resliced1\n 19 String C:\\fmri\\resliced2\n 20 String C:\\fmri\\resliced3\n 21 String C:\\fmri\\resliced4\n \. -- -- TOC entry 1619 (class 0 OID 78339) -- 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 78201) -- 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 1 4 2 5 1 0 1 stdout warpParameters data_item_string 2 1 3 2 6 1 0 2 stdout warpParameters data_item_string 3 1 2 2 7 1 0 3 stdout warpParameters data_item_string 4 1 1 2 8 1 0 4 stdout warpParameters data_item_string 5 3 9 1 4 1 1 5 anatomyImage1 anatomyImage data_item_string 6 3 9 1 4 1 1 6 warpParams1 warpParams data_item_string 7 3 9 1 4 1 1 7 referenceImage referenceImage data_item_string 8 3 9 1 2 1 1 7 referenceImage referenceImage data_item_string 9 3 9 1 1 1 1 7 referenceImage referenceImage data_item_string 10 3 9 1 3 1 1 7 referenceImage referenceImage data_item_string 11 3 9 1 2 1 1 8 anatomyImage2 anatomyImage data_item_string 12 3 9 1 2 1 1 9 warpParams2 warpParams data_item_string 13 3 9 1 1 1 1 10 anatomyImage3 anatomyImage data_item_string 14 3 9 1 1 1 1 11 warpParams3 warpParams data_item_string 15 3 9 1 3 1 1 12 anatomyImage4 anatomyImage data_item_string 16 3 9 1 3 1 1 13 warpParams4 warpParams data_item_string 17 3 9 2 6 1 1 14 outputImage4 outputImage data_item_string 18 3 9 2 5 1 1 15 outputImage1 outputImage data_item_string 19 3 9 2 7 1 1 16 outputImage2 outputImage data_item_string 20 3 9 2 8 1 1 17 outputImage3 outputImage data_item_string 21 2 5 3 9 0 0 18 stdout stdout1 data_item_string 22 2 7 3 9 0 0 19 stdout stdout2 data_item_string 23 2 8 3 9 0 0 20 stdout stdout3 data_item_string 24 2 6 3 9 0 0 21 stdout stdout4 data_item_string \. -- -- TOC entry 1622 (class 0 OID 78387) -- 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 9 3 2 1 3 4 9 8 3 1 5 6 9 5 4 1 7 8 9 6 5 1 9 10 9 1 6 1 11 12 9 4 7 1 13 14 9 2 8 1 15 16 9 7 9 1 0 17 -1 9 \. -- -- TOC entry 1620 (class 0 OID 78355) -- 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 78158) -- 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 align_warp3 {fmri_part1}FMRI_1[1.0].align_warp3.0 4 1 2007-02-20 16:53:04.284 2007-02-20 16:53:04.206 2007-02-20 16:53:59.862 55.655999999999999 2 1 0 align_warp2 {fmri_part1}FMRI_1[1.0].align_warp2.0 4 1 2007-02-20 16:53:04.252 2007-02-20 16:53:04.206 2007-02-20 16:53:59.909 55.703000000000003 3 1 0 align_warp4 {fmri_part1}FMRI_1[1.0].align_warp4.0 4 1 2007-02-20 16:53:04.252 2007-02-20 16:53:04.206 2007-02-20 16:53:59.94 55.734000000000002 4 1 0 align_warp1 {fmri_part1}FMRI_1[1.0].align_warp1.0 4 1 2007-02-20 16:53:04.221 2007-02-20 16:53:04.206 2007-02-20 16:53:59.94 55.734000000000002 5 2 0 reslice1 {fmri_part1}FMRI_1[1.0].reslice1.0 4 1 2007-02-20 16:53:59.94 2007-02-20 16:53:04.206 2007-02-20 16:55:18.674 134.46799999999999 6 2 0 reslice4 {fmri_part1}FMRI_1[1.0].reslice4.0 4 1 2007-02-20 16:53:59.909 2007-02-20 16:53:04.206 2007-02-20 16:55:18.706 134.5 7 2 0 reslice2 {fmri_part1}FMRI_1[1.0].reslice2.0 4 1 2007-02-20 16:53:59.909 2007-02-20 16:53:04.206 2007-02-20 16:55:18.706 134.5 8 2 0 reslice3 {fmri_part1}FMRI_1[1.0].reslice3.0 4 1 2007-02-20 16:53:59.768 2007-02-20 16:53:04.206 2007-02-20 16:55:18.706 134.5 9 3 0 0 {fmri_part1}FMRI_1[1.0].0.0 4 1 2007-02-20 16:53:04.206 2007-02-20 16:53:04.206 2007-02-20 16:55:18.721 134.51499999999999 \. -- -- TOC entry 1621 (class 0 OID 78371) -- 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 78147) -- 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_part1}align_warp[1.0] act__fmri_part1_align_warp_1_0_ f 1.0 Stable 2 {fmri_part1}reslice[1.0] act__fmri_part1_reslice_1_0_ f 1.0 Stable 3 {fmri_part1}FMRI_1[1.0] proc__fmri_part1_fmri_1_1_0_ t 1.0 Stable \. -- -- TOC entry 1579 (class 2606 OID 78318) -- 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 78235) -- 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 78334) -- 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 78428) -- 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 78346) -- 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 78208) -- 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 78393) -- 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 78391) -- 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 78362) -- 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 78165) -- 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 78378) -- 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 78154) -- 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 78319) -- 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 78236) -- 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 78335) -- 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 78336) -- 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 78347) -- 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 78155) -- 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 78363) -- 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 78379) -- 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 78166) -- 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 78320) -- 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 1605 (class 2606 OID 78247) -- 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 1607 (class 2606 OID 78237) -- 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 1601 (class 2606 OID 78219) -- 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 1603 (class 2606 OID 78209) -- 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 1600 (class 2606 OID 78224) -- 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 1602 (class 2606 OID 78214) -- 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 78348) -- 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 78394) -- 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 1604 (class 2606 OID 78252) -- 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 1606 (class 2606 OID 78242) -- 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 78364) -- 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 78380) -- 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 78167) -- 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 16:57:33 W. Europe Standard Time -- -- PostgreSQL database dump complete --