-- -- PostgreSQL database dump -- SET client_encoding = 'SQL_ASCII'; SET check_function_bodies = false; SET SESSION AUTHORIZATION 'benc'; -- -- TOC entry 4 (OID 2200) -- Name: public; Type: ACL; Schema: -; Owner: benc -- REVOKE ALL ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; SET SESSION AUTHORIZATION 'benc'; SET search_path = public, pg_catalog; -- -- TOC entry 19 (OID 2610094) -- Name: vds_schema; Type: TABLE; Schema: public; Owner: benc -- CREATE TABLE vds_schema ( name character varying(64) NOT NULL, catalog character varying(16), "version" double precision, creator character varying(8) DEFAULT "current_user"(), creation timestamp with time zone DEFAULT ('now'::text)::timestamp(0) with time zone ); -- -- TOC entry 5 (OID 2610101) -- Name: def_id_seq; Type: SEQUENCE; Schema: public; Owner: benc -- CREATE SEQUENCE def_id_seq INCREMENT BY 1 NO MAXVALUE MINVALUE 0 CACHE 1; -- -- TOC entry 20 (OID 2610103) -- Name: anno_definition; Type: TABLE; Schema: public; Owner: benc -- CREATE TABLE anno_definition ( id bigint DEFAULT nextval('def_id_seq'::text) NOT NULL, "type" integer NOT NULL, name character varying(255) NOT NULL, namespace character varying(255) NOT NULL, "version" character varying(20) NOT NULL, xml text ); -- -- TOC entry 21 (OID 2610113) -- Name: anno_lfn_i; Type: TABLE; Schema: public; Owner: benc -- CREATE TABLE anno_lfn_i ( did bigint NOT NULL, name character varying NOT NULL ); -- -- TOC entry 22 (OID 2610120) -- Name: anno_lfn_o; Type: TABLE; Schema: public; Owner: benc -- CREATE TABLE anno_lfn_o ( did bigint NOT NULL, name character varying NOT NULL ); -- -- TOC entry 23 (OID 2610127) -- Name: anno_lfn_b; Type: TABLE; Schema: public; Owner: benc -- CREATE TABLE anno_lfn_b ( did bigint NOT NULL, name character varying NOT NULL ); -- -- TOC entry 7 (OID 2610137) -- Name: anno_id_seq; Type: SEQUENCE; Schema: public; Owner: benc -- CREATE SEQUENCE anno_id_seq START WITH 0 INCREMENT BY 1 NO MAXVALUE MINVALUE 0 CACHE 1; -- -- TOC entry 24 (OID 2610139) -- Name: anno_tr; Type: TABLE; Schema: public; Owner: benc -- CREATE TABLE anno_tr ( id bigint DEFAULT nextval('anno_id_seq'::text) NOT NULL, did bigint NOT NULL, mkey character varying(64) NOT NULL ); -- -- TOC entry 25 (OID 2610146) -- Name: anno_dv; Type: TABLE; Schema: public; Owner: benc -- CREATE TABLE anno_dv ( id bigint DEFAULT nextval('anno_id_seq'::text) NOT NULL, did bigint NOT NULL, mkey character varying(64) NOT NULL ); -- -- TOC entry 26 (OID 2610153) -- Name: anno_lfn; Type: TABLE; Schema: public; Owner: benc -- CREATE TABLE anno_lfn ( id bigint DEFAULT nextval('anno_id_seq'::text) NOT NULL, name character varying NOT NULL, mkey character varying(64) NOT NULL ); -- -- TOC entry 27 (OID 2610163) -- Name: anno_targ; Type: TABLE; Schema: public; Owner: benc -- CREATE TABLE anno_targ ( id bigint DEFAULT nextval('anno_id_seq'::text) NOT NULL, did bigint NOT NULL, name character varying(64) NOT NULL, mkey character varying(64) NOT NULL ); -- -- TOC entry 28 (OID 2610170) -- Name: anno_call; Type: TABLE; Schema: public; Owner: benc -- CREATE TABLE anno_call ( id bigint DEFAULT nextval('anno_id_seq'::text) NOT NULL, did bigint NOT NULL, pos integer NOT NULL, mkey character varying(64) NOT NULL ); -- -- TOC entry 29 (OID 2610187) -- Name: anno_bool; Type: TABLE; Schema: public; Owner: benc -- CREATE TABLE anno_bool ( id bigint NOT NULL, value boolean NOT NULL ); -- -- TOC entry 30 (OID 2610191) -- Name: anno_int; Type: TABLE; Schema: public; Owner: benc -- CREATE TABLE anno_int ( id bigint NOT NULL, value bigint NOT NULL ); -- -- TOC entry 31 (OID 2610195) -- Name: anno_float; Type: TABLE; Schema: public; Owner: benc -- CREATE TABLE anno_float ( id bigint NOT NULL, value double precision NOT NULL ); -- -- TOC entry 32 (OID 2610199) -- Name: anno_date; Type: TABLE; Schema: public; Owner: benc -- CREATE TABLE anno_date ( id bigint NOT NULL, value timestamp with time zone NOT NULL ); -- -- TOC entry 33 (OID 2610203) -- Name: anno_text; Type: TABLE; Schema: public; Owner: benc -- CREATE TABLE anno_text ( id bigint NOT NULL, value text NOT NULL ); -- -- TOC entry 9 (OID 2610211) -- Name: uname_id_seq; Type: SEQUENCE; Schema: public; Owner: benc -- CREATE SEQUENCE uname_id_seq INCREMENT BY 1 NO MAXVALUE MINVALUE 0 CACHE 1; -- -- TOC entry 11 (OID 2610213) -- Name: rusage_id_seq; Type: SEQUENCE; Schema: public; Owner: benc -- CREATE SEQUENCE rusage_id_seq INCREMENT BY 1 NO MAXVALUE MINVALUE 0 CACHE 1; -- -- TOC entry 13 (OID 2610215) -- Name: stat_id_seq; Type: SEQUENCE; Schema: public; Owner: benc -- CREATE SEQUENCE stat_id_seq INCREMENT BY 1 NO MAXVALUE MINVALUE 0 CACHE 1; -- -- TOC entry 15 (OID 2610217) -- Name: invocation_id_seq; Type: SEQUENCE; Schema: public; Owner: benc -- CREATE SEQUENCE invocation_id_seq INCREMENT BY 1 NO MAXVALUE MINVALUE 0 CACHE 1; -- -- TOC entry 34 (OID 2610219) -- Name: ptc_uname; Type: TABLE; Schema: public; Owner: benc -- CREATE TABLE ptc_uname ( id bigint DEFAULT nextval('uname_id_seq'::text) NOT NULL, archmode character varying(16), sysname character varying(64), release character varying(64), machine character varying(64) ); -- -- TOC entry 35 (OID 2610226) -- Name: ptc_rusage; Type: TABLE; Schema: public; Owner: benc -- CREATE TABLE ptc_rusage ( id bigint DEFAULT nextval('rusage_id_seq'::text) NOT NULL, utime double precision NOT NULL, stime double precision NOT NULL, minflt integer, majflt integer, nswaps integer, nsignals integer, nvcsw integer, nivcsw integer ); -- -- TOC entry 36 (OID 2610231) -- Name: ptc_stat; Type: TABLE; Schema: public; Owner: benc -- CREATE TABLE ptc_stat ( id bigint DEFAULT nextval('stat_id_seq'::text) NOT NULL, errno smallint NOT NULL, fname character varying(1024), fdesc integer, size bigint, "mode" integer, inode bigint, atime timestamp with time zone, ctime timestamp with time zone, mtime timestamp with time zone, uid integer, gid integer ); -- -- TOC entry 37 (OID 2610236) -- Name: ptc_invocation; Type: TABLE; Schema: public; Owner: benc -- CREATE TABLE ptc_invocation ( id bigint DEFAULT nextval('invocation_id_seq'::text) NOT NULL, creator character varying(16) DEFAULT "current_user"() NOT NULL, creationtime timestamp with time zone DEFAULT ('now'::text)::timestamp(0) with time zone NOT NULL, wf_label character varying(32), wf_time timestamp with time zone, "version" character varying(4), "start" timestamp with time zone NOT NULL, duration double precision NOT NULL, tr_namespace character varying(255), tr_name character varying(255), tr_version character varying(20), dv_namespace character varying(255), dv_name character varying(255), dv_version character varying(20), resource character varying(48), host character varying(16), pid integer, uid integer, gid integer, cwd character varying(1024), arch bigint, total bigint ); -- -- TOC entry 38 (OID 2610254) -- Name: ptc_job; Type: TABLE; Schema: public; Owner: benc -- CREATE TABLE ptc_job ( id bigint NOT NULL, "type" character(1) NOT NULL, "start" timestamp with time zone NOT NULL, duration double precision NOT NULL, pid integer, rusage bigint, stat bigint, exitcode integer NOT NULL, exit_msg character varying(255), args text ); -- -- TOC entry 39 (OID 2610273) -- Name: ptc_lfn; Type: TABLE; Schema: public; Owner: benc -- CREATE TABLE ptc_lfn ( id bigint NOT NULL, stat bigint NOT NULL, initial character(1), lfn character varying(255) ); -- -- TOC entry 40 (OID 2610286) -- Name: tc_sysinfo; Type: TABLE; Schema: public; Owner: benc -- CREATE TABLE tc_sysinfo ( id bigserial NOT NULL, architecture character varying(10) NOT NULL, os character varying(10) NOT NULL, glibc character varying(10), osversion character varying(10) ); -- -- TOC entry 41 (OID 2610295) -- Name: tc_physicaltx; Type: TABLE; Schema: public; Owner: benc -- CREATE TABLE tc_physicaltx ( id bigserial NOT NULL, resourceid character varying(255) NOT NULL, pfn character varying(255), "type" character varying(20) DEFAULT 'INSTALLED'::character varying NOT NULL, archid bigint ); -- -- TOC entry 42 (OID 2610313) -- Name: tc_logicaltx; Type: TABLE; Schema: public; Owner: benc -- CREATE TABLE tc_logicaltx ( id bigserial NOT NULL, namespace character varying(255) NOT NULL, name character varying(255) NOT NULL, "version" character varying(20) NOT NULL ); -- -- TOC entry 43 (OID 2610321) -- Name: tc_lfnprofile; Type: TABLE; Schema: public; Owner: benc -- CREATE TABLE tc_lfnprofile ( namespace character varying(20) DEFAULT 'env'::character varying NOT NULL, name character varying(64) NOT NULL, value text NOT NULL, lfnid bigint NOT NULL ); -- -- TOC entry 44 (OID 2610336) -- Name: tc_lfnpfnmap; Type: TABLE; Schema: public; Owner: benc -- CREATE TABLE tc_lfnpfnmap ( lfnid bigint NOT NULL, pfnid bigint NOT NULL ); -- -- TOC entry 45 (OID 2610350) -- Name: tc_pfnprofile; Type: TABLE; Schema: public; Owner: benc -- CREATE TABLE tc_pfnprofile ( namespace character varying(20) DEFAULT 'env'::character varying NOT NULL, name character varying(64) NOT NULL, value text NOT NULL, pfnid bigint NOT NULL ); -- -- TOC entry 17 (OID 2610366) -- Name: rc_lfn_id; Type: SEQUENCE; Schema: public; Owner: benc -- CREATE SEQUENCE rc_lfn_id START WITH 1 INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; -- -- TOC entry 46 (OID 2610368) -- Name: rc_lfn; Type: TABLE; Schema: public; Owner: benc -- CREATE TABLE rc_lfn ( id bigint DEFAULT nextval('rc_lfn_id'::text) NOT NULL, lfn character varying(255) NOT NULL, pfn character varying(255) NOT NULL ); -- -- TOC entry 47 (OID 2610376) -- Name: rc_attr; Type: TABLE; Schema: public; Owner: benc -- CREATE TABLE rc_attr ( id bigint NOT NULL, name character varying(64) NOT NULL, value character varying(255) NOT NULL ); -- -- TOC entry 48 (OID 2610388) -- Name: wf_work; Type: TABLE; Schema: public; Owner: benc -- CREATE TABLE wf_work ( id bigserial NOT NULL, basedir text, vogroup character varying(255), workflow character varying(255), run character varying(255), creator character varying(32), ctime timestamp with time zone NOT NULL, state integer NOT NULL, mtime timestamp with time zone NOT NULL ); -- -- TOC entry 49 (OID 2610398) -- Name: wf_jobstate; Type: TABLE; Schema: public; Owner: benc -- CREATE TABLE wf_jobstate ( wfid bigint NOT NULL, jobid character varying(64) NOT NULL, state character varying(24) NOT NULL, mtime timestamp with time zone NOT NULL, site character varying(64) ); -- -- TOC entry 50 (OID 2610409) -- Name: wf_siteinfo; Type: TABLE; Schema: public; Owner: benc -- CREATE TABLE wf_siteinfo ( id bigserial NOT NULL, handle character varying(48) NOT NULL, mtime timestamp with time zone, other integer DEFAULT 0, pending integer DEFAULT 0, running integer DEFAULT 0, success integer DEFAULT 0, smtime timestamp with time zone, failure integer DEFAULT 0, fmtime timestamp with time zone ); -- -- Data for TOC entry 129 (OID 2610094) -- Name: vds_schema; Type: TABLE DATA; Schema: public; Owner: benc -- INSERT INTO vds_schema VALUES ('AnnotationSchema', 'vdc', 1.3, 'benc', '2007-02-21 06:27:55+00'); INSERT INTO vds_schema VALUES ('InvocationSchema', 'ptc', 1.5, 'benc', '2007-02-21 06:27:55+00'); INSERT INTO vds_schema VALUES ('Database', 'tc', 1.3, 'benc', '2007-02-21 06:27:56+00'); INSERT INTO vds_schema VALUES ('JDBCRC', 'rc', 1.2, 'benc', '2007-02-21 06:27:56+00'); INSERT INTO vds_schema VALUES ('WorkflowSchema', 'wf', 1.1000000000000001, 'benc', '2007-02-21 06:27:56+00'); -- -- Data for TOC entry 130 (OID 2610103) -- Name: anno_definition; Type: TABLE DATA; Schema: public; Owner: benc -- INSERT INTO anno_definition VALUES (0, 1896313669, 'align_warp', 'air', '', '-m '); INSERT INTO anno_definition VALUES (1, 1896313669, 'reslice', 'air', '', ''); INSERT INTO anno_definition VALUES (2, 1896313669, 'softmean', 'air', '', 'ynull '); INSERT INTO anno_definition VALUES (3, 1896313669, 'slicer', 'fsl', '', ''); INSERT INTO anno_definition VALUES (4, 1896313669, 'convert', 'unix', '', ''); INSERT INTO anno_definition VALUES (5, -889275714, 'softmean.9', 'wilde.pc1.wf01', '', 'nnull'); -- -- Data for TOC entry 131 (OID 2610113) -- Name: anno_lfn_i; Type: TABLE DATA; Schema: public; Owner: benc -- INSERT INTO anno_lfn_i VALUES (5, 'Data/Derived/resliced1.hdr'); INSERT INTO anno_lfn_i VALUES (5, 'Data/Derived/resliced2.hdr'); INSERT INTO anno_lfn_i VALUES (5, 'Data/Derived/resliced3.hdr'); INSERT INTO anno_lfn_i VALUES (5, 'Data/Derived/resliced4.hdr'); INSERT INTO anno_lfn_i VALUES (5, 'Data/Derived/resliced1.img'); INSERT INTO anno_lfn_i VALUES (5, 'Data/Derived/resliced2.img'); INSERT INTO anno_lfn_i VALUES (5, 'Data/Derived/resliced3.img'); INSERT INTO anno_lfn_i VALUES (5, 'Data/Derived/resliced4.img'); -- -- Data for TOC entry 132 (OID 2610120) -- Name: anno_lfn_o; Type: TABLE DATA; Schema: public; Owner: benc -- INSERT INTO anno_lfn_o VALUES (5, 'Data/Derived/atlas.hdr'); INSERT INTO anno_lfn_o VALUES (5, 'Data/Derived/atlas.img'); -- -- Data for TOC entry 133 (OID 2610127) -- Name: anno_lfn_b; Type: TABLE DATA; Schema: public; Owner: benc -- -- -- Data for TOC entry 134 (OID 2610139) -- Name: anno_tr; Type: TABLE DATA; Schema: public; Owner: benc -- -- -- Data for TOC entry 135 (OID 2610146) -- Name: anno_dv; Type: TABLE DATA; Schema: public; Owner: benc -- -- -- Data for TOC entry 136 (OID 2610153) -- Name: anno_lfn; Type: TABLE DATA; Schema: public; Owner: benc -- -- -- Data for TOC entry 137 (OID 2610163) -- Name: anno_targ; Type: TABLE DATA; Schema: public; Owner: benc -- -- -- Data for TOC entry 138 (OID 2610170) -- Name: anno_call; Type: TABLE DATA; Schema: public; Owner: benc -- -- -- Data for TOC entry 139 (OID 2610187) -- Name: anno_bool; Type: TABLE DATA; Schema: public; Owner: benc -- -- -- Data for TOC entry 140 (OID 2610191) -- Name: anno_int; Type: TABLE DATA; Schema: public; Owner: benc -- -- -- Data for TOC entry 141 (OID 2610195) -- Name: anno_float; Type: TABLE DATA; Schema: public; Owner: benc -- -- -- Data for TOC entry 142 (OID 2610199) -- Name: anno_date; Type: TABLE DATA; Schema: public; Owner: benc -- -- -- Data for TOC entry 143 (OID 2610203) -- Name: anno_text; Type: TABLE DATA; Schema: public; Owner: benc -- -- -- Data for TOC entry 144 (OID 2610219) -- Name: ptc_uname; Type: TABLE DATA; Schema: public; Owner: benc -- INSERT INTO ptc_uname VALUES (0, 'unknown', 'darwin', '8.8.0', 'powermacintosh'); -- -- Data for TOC entry 145 (OID 2610226) -- Name: ptc_rusage; Type: TABLE DATA; Schema: public; Owner: benc -- INSERT INTO ptc_rusage VALUES (0, 3.657, 10.554, 0, 0, 0, 1, 0, 0); INSERT INTO ptc_rusage VALUES (1, 12.365, 1.329, 0, 0, 0, 0, 6, 0); -- -- Data for TOC entry 146 (OID 2610231) -- Name: ptc_stat; Type: TABLE DATA; Schema: public; Owner: benc -- INSERT INTO ptc_stat VALUES (0, 0, '/Users/benc/src/AIR5.2.5/bin/softmean', NULL, 147372, 33261, 20389135, '2007-02-21 05:38:58+00', '2007-02-21 00:19:09+00', '2007-02-21 00:19:09+00', 501, 501); -- -- Data for TOC entry 147 (OID 2610236) -- Name: ptc_invocation; Type: TABLE DATA; Schema: public; Owner: benc -- INSERT INTO ptc_invocation VALUES (0, 'benc', '2007-02-21 06:32:35.856+00', NULL, NULL, '1.10', '2007-02-21 06:31:02.171+00', 33.194000000000003, 'air', 'softmean', NULL, 'wilde.pc1.wf01', 'softmean.9', NULL, 'local', '0.0.0.0', 21886, 501, 501, '/Users/benc/work/provchal2/test', 0, 0); -- -- Data for TOC entry 148 (OID 2610254) -- Name: ptc_job; Type: TABLE DATA; Schema: public; Owner: benc -- INSERT INTO ptc_job VALUES (0, 'M', '2007-02-21 06:31:02.18+00', 33.183999999999997, 21887, 1, 0, 0, NULL, '/Users/benc/work/provchal2/test/Data/Derived/atlas.img n null /Users/benc/work/provchal2/test/Data/Derived/resliced1.img /Users/benc/work/provchal2/test/Data/Derived/resliced2.img /Users/benc/work/provchal2/test/Data/Derived/resliced3.img /Users/benc/work/provchal2/test/Data/Derived/resliced4.img'); -- -- Data for TOC entry 149 (OID 2610273) -- Name: ptc_lfn; Type: TABLE DATA; Schema: public; Owner: benc -- -- -- Data for TOC entry 150 (OID 2610286) -- Name: tc_sysinfo; Type: TABLE DATA; Schema: public; Owner: benc -- -- -- Data for TOC entry 151 (OID 2610295) -- Name: tc_physicaltx; Type: TABLE DATA; Schema: public; Owner: benc -- -- -- Data for TOC entry 152 (OID 2610313) -- Name: tc_logicaltx; Type: TABLE DATA; Schema: public; Owner: benc -- -- -- Data for TOC entry 153 (OID 2610321) -- Name: tc_lfnprofile; Type: TABLE DATA; Schema: public; Owner: benc -- -- -- Data for TOC entry 154 (OID 2610336) -- Name: tc_lfnpfnmap; Type: TABLE DATA; Schema: public; Owner: benc -- -- -- Data for TOC entry 155 (OID 2610350) -- Name: tc_pfnprofile; Type: TABLE DATA; Schema: public; Owner: benc -- -- -- Data for TOC entry 156 (OID 2610368) -- Name: rc_lfn; Type: TABLE DATA; Schema: public; Owner: benc -- -- -- Data for TOC entry 157 (OID 2610376) -- Name: rc_attr; Type: TABLE DATA; Schema: public; Owner: benc -- -- -- Data for TOC entry 158 (OID 2610388) -- Name: wf_work; Type: TABLE DATA; Schema: public; Owner: benc -- -- -- Data for TOC entry 159 (OID 2610398) -- Name: wf_jobstate; Type: TABLE DATA; Schema: public; Owner: benc -- -- -- Data for TOC entry 160 (OID 2610409) -- Name: wf_siteinfo; Type: TABLE DATA; Schema: public; Owner: benc -- -- -- TOC entry 59 (OID 2610134) -- Name: ix_anno_lfn_i; Type: INDEX; Schema: public; Owner: benc -- CREATE INDEX ix_anno_lfn_i ON anno_lfn_i USING btree (name); -- -- TOC entry 61 (OID 2610135) -- Name: ix_anno_lfn_o; Type: INDEX; Schema: public; Owner: benc -- CREATE INDEX ix_anno_lfn_o ON anno_lfn_o USING btree (name); -- -- TOC entry 63 (OID 2610136) -- Name: ix_anno_lfn_b; Type: INDEX; Schema: public; Owner: benc -- CREATE INDEX ix_anno_lfn_b ON anno_lfn_b USING btree (name); -- -- TOC entry 66 (OID 2610177) -- Name: ix_anno_tr; Type: INDEX; Schema: public; Owner: benc -- CREATE INDEX ix_anno_tr ON anno_tr USING btree (mkey); -- -- TOC entry 70 (OID 2610178) -- Name: ix_anno_dv; Type: INDEX; Schema: public; Owner: benc -- CREATE INDEX ix_anno_dv ON anno_dv USING btree (mkey); -- -- TOC entry 74 (OID 2610179) -- Name: ix_anno_lfn; Type: INDEX; Schema: public; Owner: benc -- CREATE INDEX ix_anno_lfn ON anno_lfn USING btree (mkey); -- -- TOC entry 78 (OID 2610180) -- Name: ix_anno_targ; Type: INDEX; Schema: public; Owner: benc -- CREATE INDEX ix_anno_targ ON anno_targ USING btree (mkey); -- -- TOC entry 82 (OID 2610181) -- Name: ix_anno_call; Type: INDEX; Schema: public; Owner: benc -- CREATE INDEX ix_anno_call ON anno_call USING btree (mkey); -- -- TOC entry 67 (OID 2610182) -- Name: ix_anno_tr2; Type: INDEX; Schema: public; Owner: benc -- CREATE INDEX ix_anno_tr2 ON anno_tr USING btree (did); -- -- TOC entry 71 (OID 2610183) -- Name: ix_anno_dv2; Type: INDEX; Schema: public; Owner: benc -- CREATE INDEX ix_anno_dv2 ON anno_dv USING btree (did); -- -- TOC entry 75 (OID 2610184) -- Name: ix_anno_lfn2; Type: INDEX; Schema: public; Owner: benc -- CREATE INDEX ix_anno_lfn2 ON anno_lfn USING btree (name); -- -- TOC entry 79 (OID 2610185) -- Name: ix_anno_targ2; Type: INDEX; Schema: public; Owner: benc -- CREATE INDEX ix_anno_targ2 ON anno_targ USING btree (did); -- -- TOC entry 83 (OID 2610186) -- Name: ix_anno_call2; Type: INDEX; Schema: public; Owner: benc -- CREATE INDEX ix_anno_call2 ON anno_call USING btree (did); -- -- TOC entry 98 (OID 2610307) -- Name: idx_tc_physicaltx; Type: INDEX; Schema: public; Owner: benc -- CREATE INDEX idx_tc_physicaltx ON tc_physicaltx USING btree (resourceid); -- -- TOC entry 99 (OID 2610308) -- Name: idx_tc_physicaltx2; Type: INDEX; Schema: public; Owner: benc -- CREATE INDEX idx_tc_physicaltx2 ON tc_physicaltx USING btree ("type"); -- -- TOC entry 100 (OID 2610309) -- Name: idx_tc_physicaltx3; Type: INDEX; Schema: public; Owner: benc -- CREATE INDEX idx_tc_physicaltx3 ON tc_physicaltx USING btree (pfn); -- -- TOC entry 101 (OID 2610310) -- Name: idx_tc_physicaltx4; Type: INDEX; Schema: public; Owner: benc -- CREATE INDEX idx_tc_physicaltx4 ON tc_physicaltx USING btree (archid); -- -- TOC entry 104 (OID 2610320) -- Name: idx_tc_logicaltx; Type: INDEX; Schema: public; Owner: benc -- CREATE INDEX idx_tc_logicaltx ON tc_logicaltx USING btree (name); -- -- TOC entry 107 (OID 2610333) -- Name: idx_tc_lfnprofile; Type: INDEX; Schema: public; Owner: benc -- CREATE INDEX idx_tc_lfnprofile ON tc_lfnprofile USING btree (lfnid); -- -- TOC entry 108 (OID 2610334) -- Name: idx_tc_lfnprofile2; Type: INDEX; Schema: public; Owner: benc -- CREATE INDEX idx_tc_lfnprofile2 ON tc_lfnprofile USING btree (namespace); -- -- TOC entry 109 (OID 2610335) -- Name: idx_tc_lfnprofile3; Type: INDEX; Schema: public; Owner: benc -- CREATE INDEX idx_tc_lfnprofile3 ON tc_lfnprofile USING btree (name); -- -- TOC entry 111 (OID 2610348) -- Name: idx_tc_lfnpfnmap_l; Type: INDEX; Schema: public; Owner: benc -- CREATE INDEX idx_tc_lfnpfnmap_l ON tc_lfnpfnmap USING btree (lfnid); -- -- TOC entry 112 (OID 2610349) -- Name: idx_tc_lfnpfnmap_p; Type: INDEX; Schema: public; Owner: benc -- CREATE INDEX idx_tc_lfnpfnmap_p ON tc_lfnpfnmap USING btree (pfnid); -- -- TOC entry 114 (OID 2610362) -- Name: idx_tc_pfnprofile; Type: INDEX; Schema: public; Owner: benc -- CREATE INDEX idx_tc_pfnprofile ON tc_pfnprofile USING btree (pfnid); -- -- TOC entry 115 (OID 2610363) -- Name: idx_tc_pfnprofile2; Type: INDEX; Schema: public; Owner: benc -- CREATE INDEX idx_tc_pfnprofile2 ON tc_pfnprofile USING btree (namespace); -- -- TOC entry 116 (OID 2610364) -- Name: idx_tc_pfnprofile3; Type: INDEX; Schema: public; Owner: benc -- CREATE INDEX idx_tc_pfnprofile3 ON tc_pfnprofile USING btree (name); -- -- TOC entry 118 (OID 2610375) -- Name: ix_rc_lfn; Type: INDEX; Schema: public; Owner: benc -- CREATE INDEX ix_rc_lfn ON rc_lfn USING btree (lfn); -- -- TOC entry 121 (OID 2610384) -- Name: ix_rc_attr; Type: INDEX; Schema: public; Owner: benc -- CREATE INDEX ix_rc_attr ON rc_attr USING btree (name); -- -- TOC entry 125 (OID 2610406) -- Name: ix_wf_jobstate; Type: INDEX; Schema: public; Owner: benc -- CREATE INDEX ix_wf_jobstate ON wf_jobstate USING btree (jobid); -- -- TOC entry 56 (OID 2610098) -- Name: pk_vds_schema; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY vds_schema ADD CONSTRAINT pk_vds_schema PRIMARY KEY (name); -- -- TOC entry 57 (OID 2610109) -- Name: anno_definition_pkey; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY anno_definition ADD CONSTRAINT anno_definition_pkey PRIMARY KEY (id); -- -- TOC entry 58 (OID 2610111) -- Name: sk_anno_definition; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY anno_definition ADD CONSTRAINT sk_anno_definition UNIQUE ("type", name, namespace, "version"); -- -- TOC entry 60 (OID 2610118) -- Name: pk_anno_lfn_i; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY anno_lfn_i ADD CONSTRAINT pk_anno_lfn_i PRIMARY KEY (did, name); -- -- TOC entry 62 (OID 2610125) -- Name: pk_anno_lfn_o; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY anno_lfn_o ADD CONSTRAINT pk_anno_lfn_o PRIMARY KEY (did, name); -- -- TOC entry 64 (OID 2610132) -- Name: pk_anno_lfn_b; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY anno_lfn_b ADD CONSTRAINT pk_anno_lfn_b PRIMARY KEY (did, name); -- -- TOC entry 65 (OID 2610142) -- Name: anno_tr_pkey; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY anno_tr ADD CONSTRAINT anno_tr_pkey PRIMARY KEY (id); -- -- TOC entry 68 (OID 2610144) -- Name: sk_anno_tr; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY anno_tr ADD CONSTRAINT sk_anno_tr UNIQUE (did, mkey); -- -- TOC entry 69 (OID 2610149) -- Name: anno_dv_pkey; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY anno_dv ADD CONSTRAINT anno_dv_pkey PRIMARY KEY (id); -- -- TOC entry 72 (OID 2610151) -- Name: sk_anno_dv; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY anno_dv ADD CONSTRAINT sk_anno_dv UNIQUE (did, mkey); -- -- TOC entry 73 (OID 2610159) -- Name: anno_lfn_pkey; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY anno_lfn ADD CONSTRAINT anno_lfn_pkey PRIMARY KEY (id); -- -- TOC entry 76 (OID 2610161) -- Name: sk_anno_lfn; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY anno_lfn ADD CONSTRAINT sk_anno_lfn UNIQUE (name, mkey); -- -- TOC entry 77 (OID 2610166) -- Name: anno_targ_pkey; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY anno_targ ADD CONSTRAINT anno_targ_pkey PRIMARY KEY (id); -- -- TOC entry 80 (OID 2610168) -- Name: sk_anno_targ; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY anno_targ ADD CONSTRAINT sk_anno_targ UNIQUE (did, name, mkey); -- -- TOC entry 81 (OID 2610173) -- Name: anno_call_pkey; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY anno_call ADD CONSTRAINT anno_call_pkey PRIMARY KEY (id); -- -- TOC entry 84 (OID 2610175) -- Name: sk_anno_call; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY anno_call ADD CONSTRAINT sk_anno_call UNIQUE (did, pos, mkey); -- -- TOC entry 85 (OID 2610189) -- Name: anno_bool_pkey; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY anno_bool ADD CONSTRAINT anno_bool_pkey PRIMARY KEY (id); -- -- TOC entry 86 (OID 2610193) -- Name: anno_int_pkey; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY anno_int ADD CONSTRAINT anno_int_pkey PRIMARY KEY (id); -- -- TOC entry 87 (OID 2610197) -- Name: anno_float_pkey; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY anno_float ADD CONSTRAINT anno_float_pkey PRIMARY KEY (id); -- -- TOC entry 88 (OID 2610201) -- Name: anno_date_pkey; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY anno_date ADD CONSTRAINT anno_date_pkey PRIMARY KEY (id); -- -- TOC entry 89 (OID 2610208) -- Name: anno_text_pkey; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY anno_text ADD CONSTRAINT anno_text_pkey PRIMARY KEY (id); -- -- TOC entry 90 (OID 2610222) -- Name: ptc_uname_pkey; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY ptc_uname ADD CONSTRAINT ptc_uname_pkey PRIMARY KEY (id); -- -- TOC entry 91 (OID 2610224) -- Name: sk_ptc_uname; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY ptc_uname ADD CONSTRAINT sk_ptc_uname UNIQUE (archmode, sysname, release, machine); -- -- TOC entry 92 (OID 2610229) -- Name: ptc_rusage_pkey; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY ptc_rusage ADD CONSTRAINT ptc_rusage_pkey PRIMARY KEY (id); -- -- TOC entry 93 (OID 2610234) -- Name: ptc_stat_pkey; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY ptc_stat ADD CONSTRAINT ptc_stat_pkey PRIMARY KEY (id); -- -- TOC entry 94 (OID 2610244) -- Name: ptc_invocation_pkey; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY ptc_invocation ADD CONSTRAINT ptc_invocation_pkey PRIMARY KEY (id); -- -- TOC entry 95 (OID 2610259) -- Name: pk_ptc_job; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY ptc_job ADD CONSTRAINT pk_ptc_job PRIMARY KEY (id, "type"); -- -- TOC entry 97 (OID 2610289) -- Name: tc_sysinfo_pkey; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY tc_sysinfo ADD CONSTRAINT tc_sysinfo_pkey PRIMARY KEY (id); -- -- TOC entry 96 (OID 2610291) -- Name: tc_sysinfo_architecture_key; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY tc_sysinfo ADD CONSTRAINT tc_sysinfo_architecture_key UNIQUE (architecture, os, glibc, osversion); -- -- TOC entry 102 (OID 2610299) -- Name: tc_physicaltx_pkey; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY tc_physicaltx ADD CONSTRAINT tc_physicaltx_pkey PRIMARY KEY (id); -- -- TOC entry 103 (OID 2610301) -- Name: tc_physicaltx_resourceid_key; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY tc_physicaltx ADD CONSTRAINT tc_physicaltx_resourceid_key UNIQUE (resourceid, pfn, "type"); -- -- TOC entry 106 (OID 2610316) -- Name: tc_logicaltx_pkey; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY tc_logicaltx ADD CONSTRAINT tc_logicaltx_pkey PRIMARY KEY (id); -- -- TOC entry 105 (OID 2610318) -- Name: tc_logicaltx_namespace_key; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY tc_logicaltx ADD CONSTRAINT tc_logicaltx_namespace_key UNIQUE (namespace, name, "version"); -- -- TOC entry 110 (OID 2610327) -- Name: tc_lfnprofile_pkey; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY tc_lfnprofile ADD CONSTRAINT tc_lfnprofile_pkey PRIMARY KEY (namespace, name, value, lfnid); -- -- TOC entry 113 (OID 2610338) -- Name: tc_lfnpfnmap_pkey; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY tc_lfnpfnmap ADD CONSTRAINT tc_lfnpfnmap_pkey PRIMARY KEY (lfnid, pfnid); -- -- TOC entry 117 (OID 2610356) -- Name: tc_pfnprofile_pkey; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY tc_pfnprofile ADD CONSTRAINT tc_pfnprofile_pkey PRIMARY KEY (namespace, name, value, pfnid); -- -- TOC entry 119 (OID 2610371) -- Name: pk_rc_lfn; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY rc_lfn ADD CONSTRAINT pk_rc_lfn PRIMARY KEY (id); -- -- TOC entry 120 (OID 2610373) -- Name: sk_rc_lfn; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY rc_lfn ADD CONSTRAINT sk_rc_lfn UNIQUE (lfn, pfn); -- -- TOC entry 122 (OID 2610378) -- Name: pk_rc_attr; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY rc_attr ADD CONSTRAINT pk_rc_attr PRIMARY KEY (id, name); -- -- TOC entry 124 (OID 2610394) -- Name: wf_work_pkey; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY wf_work ADD CONSTRAINT wf_work_pkey PRIMARY KEY (id); -- -- TOC entry 123 (OID 2610396) -- Name: sk_wf_work; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY wf_work ADD CONSTRAINT sk_wf_work UNIQUE (basedir, vogroup, workflow, run); -- -- TOC entry 126 (OID 2610400) -- Name: pk_wf_jobstate; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY wf_jobstate ADD CONSTRAINT pk_wf_jobstate PRIMARY KEY (wfid, jobid); -- -- TOC entry 128 (OID 2610417) -- Name: wf_siteinfo_pkey; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY wf_siteinfo ADD CONSTRAINT wf_siteinfo_pkey PRIMARY KEY (id); -- -- TOC entry 127 (OID 2610419) -- Name: sk_wf_siteinfo; Type: CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY wf_siteinfo ADD CONSTRAINT sk_wf_siteinfo UNIQUE (handle); -- -- TOC entry 161 (OID 2610246) -- Name: fk_ptc_inv_uname; Type: FK CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY ptc_invocation ADD CONSTRAINT fk_ptc_inv_uname FOREIGN KEY (arch) REFERENCES ptc_uname(id) ON DELETE SET NULL; -- -- TOC entry 162 (OID 2610250) -- Name: fk_ptc_inv_rusage; Type: FK CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY ptc_invocation ADD CONSTRAINT fk_ptc_inv_rusage FOREIGN KEY (total) REFERENCES ptc_rusage(id) ON DELETE SET NULL; -- -- TOC entry 163 (OID 2610261) -- Name: fk_ptc_job_inv; Type: FK CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY ptc_job ADD CONSTRAINT fk_ptc_job_inv FOREIGN KEY (id) REFERENCES ptc_invocation(id) ON DELETE CASCADE; -- -- TOC entry 164 (OID 2610265) -- Name: fk_ptc_job_rusage; Type: FK CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY ptc_job ADD CONSTRAINT fk_ptc_job_rusage FOREIGN KEY (rusage) REFERENCES ptc_rusage(id) ON DELETE SET NULL; -- -- TOC entry 165 (OID 2610269) -- Name: fk_ptc_job_stat; Type: FK CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY ptc_job ADD CONSTRAINT fk_ptc_job_stat FOREIGN KEY (stat) REFERENCES ptc_stat(id) ON DELETE SET NULL; -- -- TOC entry 166 (OID 2610275) -- Name: fk_ptc_lfn_inv; Type: FK CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY ptc_lfn ADD CONSTRAINT fk_ptc_lfn_inv FOREIGN KEY (id) REFERENCES ptc_invocation(id) ON DELETE CASCADE; -- -- TOC entry 167 (OID 2610279) -- Name: fk_ptc_lfn_stat; Type: FK CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY ptc_lfn ADD CONSTRAINT fk_ptc_lfn_stat FOREIGN KEY (stat) REFERENCES ptc_stat(id) ON DELETE CASCADE; -- -- TOC entry 168 (OID 2610303) -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY tc_physicaltx ADD CONSTRAINT "$1" FOREIGN KEY (archid) REFERENCES tc_sysinfo(id) ON DELETE CASCADE; -- -- TOC entry 169 (OID 2610329) -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY tc_lfnprofile ADD CONSTRAINT "$1" FOREIGN KEY (lfnid) REFERENCES tc_logicaltx(id) ON DELETE CASCADE; -- -- TOC entry 170 (OID 2610340) -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY tc_lfnpfnmap ADD CONSTRAINT "$1" FOREIGN KEY (lfnid) REFERENCES tc_logicaltx(id) ON DELETE CASCADE; -- -- TOC entry 171 (OID 2610344) -- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY tc_lfnpfnmap ADD CONSTRAINT "$2" FOREIGN KEY (pfnid) REFERENCES tc_physicaltx(id) ON DELETE CASCADE; -- -- TOC entry 172 (OID 2610358) -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY tc_pfnprofile ADD CONSTRAINT "$1" FOREIGN KEY (pfnid) REFERENCES tc_physicaltx(id) ON DELETE CASCADE; -- -- TOC entry 173 (OID 2610380) -- Name: fk_rc_attr; Type: FK CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY rc_attr ADD CONSTRAINT fk_rc_attr FOREIGN KEY (id) REFERENCES rc_lfn(id) ON DELETE CASCADE; -- -- TOC entry 174 (OID 2610402) -- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: benc -- ALTER TABLE ONLY wf_jobstate ADD CONSTRAINT "$1" FOREIGN KEY (wfid) REFERENCES wf_work(id) ON DELETE CASCADE; -- -- TOC entry 6 (OID 2610101) -- Name: def_id_seq; Type: SEQUENCE SET; Schema: public; Owner: benc -- SELECT pg_catalog.setval('def_id_seq', 5, true); -- -- TOC entry 8 (OID 2610137) -- Name: anno_id_seq; Type: SEQUENCE SET; Schema: public; Owner: benc -- SELECT pg_catalog.setval('anno_id_seq', 0, false); -- -- TOC entry 10 (OID 2610211) -- Name: uname_id_seq; Type: SEQUENCE SET; Schema: public; Owner: benc -- SELECT pg_catalog.setval('uname_id_seq', 0, true); -- -- TOC entry 12 (OID 2610213) -- Name: rusage_id_seq; Type: SEQUENCE SET; Schema: public; Owner: benc -- SELECT pg_catalog.setval('rusage_id_seq', 1, true); -- -- TOC entry 14 (OID 2610215) -- Name: stat_id_seq; Type: SEQUENCE SET; Schema: public; Owner: benc -- SELECT pg_catalog.setval('stat_id_seq', 0, true); -- -- TOC entry 16 (OID 2610217) -- Name: invocation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: benc -- SELECT pg_catalog.setval('invocation_id_seq', 0, true); -- -- TOC entry 51 (OID 2610284) -- Name: tc_sysinfo_id_seq; Type: SEQUENCE SET; Schema: public; Owner: benc -- SELECT pg_catalog.setval('tc_sysinfo_id_seq', 1, false); -- -- TOC entry 52 (OID 2610293) -- Name: tc_physicaltx_id_seq; Type: SEQUENCE SET; Schema: public; Owner: benc -- SELECT pg_catalog.setval('tc_physicaltx_id_seq', 1, false); -- -- TOC entry 53 (OID 2610311) -- Name: tc_logicaltx_id_seq; Type: SEQUENCE SET; Schema: public; Owner: benc -- SELECT pg_catalog.setval('tc_logicaltx_id_seq', 1, false); -- -- TOC entry 18 (OID 2610366) -- Name: rc_lfn_id; Type: SEQUENCE SET; Schema: public; Owner: benc -- SELECT pg_catalog.setval('rc_lfn_id', 1, false); -- -- TOC entry 54 (OID 2610386) -- Name: wf_work_id_seq; Type: SEQUENCE SET; Schema: public; Owner: benc -- SELECT pg_catalog.setval('wf_work_id_seq', 1, false); -- -- TOC entry 55 (OID 2610407) -- Name: wf_siteinfo_id_seq; Type: SEQUENCE SET; Schema: public; Owner: benc -- SELECT pg_catalog.setval('wf_siteinfo_id_seq', 1, false); -- -- TOC entry 3 (OID 2200) -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: benc -- COMMENT ON SCHEMA public IS 'Standard public schema';