--
-- 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 2608725)
-- 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 2608732)
-- 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 2608734)
-- 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 2608744)
-- 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 2608751)
-- 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 2608758)
-- 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 2608768)
-- 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 2608770)
-- 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 2608777)
-- 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 2608784)
-- 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 2608794)
-- 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 2608801)
-- 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 2608818)
-- 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 2608822)
-- 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 2608826)
-- 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 2608830)
-- 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 2608834)
-- 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 2608842)
-- 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 2608844)
-- 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 2608846)
-- 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 2608848)
-- 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 2608850)
-- 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 2608857)
-- 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 2608862)
-- 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 2608867)
-- 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 2608885)
-- 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 2608904)
-- 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 2608917)
-- 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 2608926)
-- 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 2608944)
-- 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 2608952)
-- 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 2608967)
-- 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 2608981)
-- 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 2608997)
-- 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 2608999)
-- 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 2609007)
-- 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 2609019)
-- 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 2609029)
-- 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 2609040)
-- 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 2608725)
-- Name: vds_schema; Type: TABLE DATA; Schema: public; Owner: benc
--

INSERT INTO vds_schema VALUES ('AnnotationSchema', 'vdc', 1.3, 'benc', '2007-02-21 05:34:21+00');
INSERT INTO vds_schema VALUES ('InvocationSchema', 'ptc', 1.5, 'benc', '2007-02-21 05:34:22+00');
INSERT INTO vds_schema VALUES ('Database', 'tc', 1.3, 'benc', '2007-02-21 05:34:22+00');
INSERT INTO vds_schema VALUES ('JDBCRC', 'rc', 1.2, 'benc', '2007-02-21 05:34:23+00');
INSERT INTO vds_schema VALUES ('WorkflowSchema', 'wf', 1.1000000000000001, 'benc', '2007-02-21 05:34:23+00');


--
-- Data for TOC entry 130 (OID 2608734)
-- Name: anno_definition; Type: TABLE DATA; Schema: public; Owner: benc
--

INSERT INTO anno_definition VALUES (0, 1896313669, 'align_warp', 'air', '', '<transformation namespace="air" name="align_warp"><declare name="model" link="none" container="scalar"/><declare name="quick" link="none" container="scalar"/><declare name="refhdr" link="input" container="scalar"/><declare name="refimg" link="input" container="scalar"/><declare name="subhdr" link="input" container="scalar"/><declare name="subimg" link="input" container="scalar"/><declare name="warp" link="output" container="scalar"/><argument><use name="refimg"/></argument><argument><use name="subimg"/></argument><argument><use name="warp"/></argument><argument><text>-m </text><use name="model"/></argument><argument><use name="quick"/></argument></transformation>');
INSERT INTO anno_definition VALUES (1, 1896313669, 'reslice', 'air', '', '<transformation namespace="air" name="reslice"><declare name="slicedhdr" link="output" container="scalar"/><declare name="slicedimg" link="output" container="scalar"/><declare name="subhdr" link="input" container="scalar"/><declare name="subimg" link="input" container="scalar"/><declare name="warp" link="input" container="scalar"/><argument><use name="warp"/></argument><argument><use name="slicedimg"/></argument></transformation>');
INSERT INTO anno_definition VALUES (2, 1896313669, 'softmean', 'air', '', '<transformation namespace="air" name="softmean"><declare name="atlashdr" link="output" container="scalar"/><declare name="atlasimg" link="output" container="scalar"/><declare name="overwrite" link="none" container="scalar"><scalar><text>y</text></scalar></declare><declare name="scalingsuffix" link="none" container="scalar"><scalar><text>null</text></scalar></declare><declare name="slicedhdrs" link="input" container="list"/><declare name="slicedimgs" link="input" container="list"/><argument><use name="atlasimg"/></argument><argument><use name="overwrite"/><text> </text><use name="scalingsuffix"/></argument><argument><use name="slicedimgs"/></argument></transformation>');
INSERT INTO anno_definition VALUES (3, 1896313669, 'slicer', 'fsl', '', '<transformation namespace="fsl" name="slicer"><declare name="axis" link="none" container="scalar"/><declare name="inhdr" link="input" container="scalar"/><declare name="inimg" link="input" container="scalar"/><declare name="outslice" link="output" container="scalar"/><declare name="position" link="none" container="scalar"/><argument><use name="inimg"/></argument><argument><use name="axis"/></argument><argument><use name="position"/></argument><argument><use name="outslice"/></argument></transformation>');
INSERT INTO anno_definition VALUES (4, 1896313669, 'convert', 'unix', '', '<transformation namespace="unix" name="convert"><declare name="inpgm" link="input" container="scalar"/><declare name="outgif" link="output" container="scalar"/><argument><use name="inpgm"/></argument><argument><use name="outgif"/></argument></transformation>');
INSERT INTO anno_definition VALUES (5, -889275714, 'align_warp.1', 'wilde.pc1.wf01', '', '<derivation namespace="wilde.pc1.wf01" name="align_warp.1" usesspace="air" uses="align_warp"><pass bind="model"><scalar><text>12</text></scalar></pass><pass bind="quick"><scalar><text>-q</text></scalar></pass><pass bind="refhdr"><scalar><lfn file="Data/Raw/reference.hdr" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="refimg"><scalar><lfn file="Data/Raw/reference.img" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="subhdr"><scalar><lfn file="Data/Raw/anatomy1.hdr" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="subimg"><scalar><lfn file="Data/Raw/anatomy1.img" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="warp"><scalar><lfn file="Data/Derived/warp1.warp" link="output" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass></derivation>');
INSERT INTO anno_definition VALUES (6, -889275714, 'reslice.2', 'wilde.pc1.wf01', '', '<derivation namespace="wilde.pc1.wf01" name="reslice.2" usesspace="air" uses="reslice"><pass bind="slicedhdr"><scalar><lfn file="Data/Derived/resliced1.hdr" link="output" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="slicedimg"><scalar><lfn file="Data/Derived/resliced1.img" link="output" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="subhdr"><scalar><lfn file="Data/Raw/anatomy1.hdr" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="subimg"><scalar><lfn file="Data/Raw/anatomy1.img" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="warp"><scalar><lfn file="Data/Derived/warp1.warp" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass></derivation>');
INSERT INTO anno_definition VALUES (7, -889275714, 'align_warp.3', 'wilde.pc1.wf01', '', '<derivation namespace="wilde.pc1.wf01" name="align_warp.3" usesspace="air" uses="align_warp"><pass bind="model"><scalar><text>12</text></scalar></pass><pass bind="quick"><scalar><text>-q</text></scalar></pass><pass bind="refhdr"><scalar><lfn file="Data/Raw/reference.hdr" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="refimg"><scalar><lfn file="Data/Raw/reference.img" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="subhdr"><scalar><lfn file="Data/Raw/anatomy2.hdr" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="subimg"><scalar><lfn file="Data/Raw/anatomy2.img" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="warp"><scalar><lfn file="Data/Derived/warp2.warp" link="output" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass></derivation>');
INSERT INTO anno_definition VALUES (8, -889275714, 'reslice.4', 'wilde.pc1.wf01', '', '<derivation namespace="wilde.pc1.wf01" name="reslice.4" usesspace="air" uses="reslice"><pass bind="slicedhdr"><scalar><lfn file="Data/Derived/resliced2.hdr" link="output" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="slicedimg"><scalar><lfn file="Data/Derived/resliced2.img" link="output" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="subhdr"><scalar><lfn file="Data/Raw/anatomy2.hdr" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="subimg"><scalar><lfn file="Data/Raw/anatomy2.img" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="warp"><scalar><lfn file="Data/Derived/warp2.warp" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass></derivation>');
INSERT INTO anno_definition VALUES (19, -889275714, 'convert.15', 'wilde.pc1.wf01', '', '<derivation namespace="wilde.pc1.wf01" name="convert.15" usesspace="unix" uses="convert"><pass bind="inpgm"><scalar><lfn file="Data/Derived/atlas-z.pgm" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="outgif"><scalar><lfn file="Data/Derived/atlas-z.gif" link="output" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass></derivation>');
INSERT INTO anno_definition VALUES (9, -889275714, 'align_warp.5', 'wilde.pc1.wf01', '', '<derivation namespace="wilde.pc1.wf01" name="align_warp.5" usesspace="air" uses="align_warp"><pass bind="model"><scalar><text>12</text></scalar></pass><pass bind="quick"><scalar><text>-q</text></scalar></pass><pass bind="refhdr"><scalar><lfn file="Data/Raw/reference.hdr" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="refimg"><scalar><lfn file="Data/Raw/reference.img" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="subhdr"><scalar><lfn file="Data/Raw/anatomy3.hdr" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="subimg"><scalar><lfn file="Data/Raw/anatomy3.img" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="warp"><scalar><lfn file="Data/Derived/warp3.warp" link="output" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass></derivation>');
INSERT INTO anno_definition VALUES (10, -889275714, 'reslice.6', 'wilde.pc1.wf01', '', '<derivation namespace="wilde.pc1.wf01" name="reslice.6" usesspace="air" uses="reslice"><pass bind="slicedhdr"><scalar><lfn file="Data/Derived/resliced3.hdr" link="output" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="slicedimg"><scalar><lfn file="Data/Derived/resliced3.img" link="output" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="subhdr"><scalar><lfn file="Data/Raw/anatomy3.hdr" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="subimg"><scalar><lfn file="Data/Raw/anatomy3.img" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="warp"><scalar><lfn file="Data/Derived/warp3.warp" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass></derivation>');
INSERT INTO anno_definition VALUES (11, -889275714, 'align_warp.7', 'wilde.pc1.wf01', '', '<derivation namespace="wilde.pc1.wf01" name="align_warp.7" usesspace="air" uses="align_warp"><pass bind="model"><scalar><text>12</text></scalar></pass><pass bind="quick"><scalar><text>-q</text></scalar></pass><pass bind="refhdr"><scalar><lfn file="Data/Raw/reference.hdr" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="refimg"><scalar><lfn file="Data/Raw/reference.img" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="subhdr"><scalar><lfn file="Data/Raw/anatomy4.hdr" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="subimg"><scalar><lfn file="Data/Raw/anatomy4.img" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="warp"><scalar><lfn file="Data/Derived/warp4.warp" link="output" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass></derivation>');
INSERT INTO anno_definition VALUES (12, -889275714, 'reslice.8', 'wilde.pc1.wf01', '', '<derivation namespace="wilde.pc1.wf01" name="reslice.8" usesspace="air" uses="reslice"><pass bind="slicedhdr"><scalar><lfn file="Data/Derived/resliced4.hdr" link="output" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="slicedimg"><scalar><lfn file="Data/Derived/resliced4.img" link="output" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="subhdr"><scalar><lfn file="Data/Raw/anatomy4.hdr" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="subimg"><scalar><lfn file="Data/Raw/anatomy4.img" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="warp"><scalar><lfn file="Data/Derived/warp4.warp" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass></derivation>');
INSERT INTO anno_definition VALUES (13, -889275714, 'softmean.9', 'wilde.pc1.wf01', '', '<derivation namespace="wilde.pc1.wf01" name="softmean.9" usesspace="air" uses="softmean"><pass bind="atlashdr"><scalar><lfn file="Data/Derived/atlas.hdr" link="output" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="atlasimg"><scalar><lfn file="Data/Derived/atlas.img" link="output" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="overwrite"><scalar><text>n</text></scalar></pass><pass bind="scalingsuffix"><scalar><text>null</text></scalar></pass><pass bind="slicedhdrs"><list><scalar><lfn file="Data/Derived/resliced1.hdr" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar><scalar><lfn file="Data/Derived/resliced2.hdr" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar><scalar><lfn file="Data/Derived/resliced3.hdr" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar><scalar><lfn file="Data/Derived/resliced4.hdr" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar></list></pass><pass bind="slicedimgs"><list><scalar><lfn file="Data/Derived/resliced1.img" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar><scalar><lfn file="Data/Derived/resliced2.img" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar><scalar><lfn file="Data/Derived/resliced3.img" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar><scalar><lfn file="Data/Derived/resliced4.img" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar></list></pass></derivation>');
INSERT INTO anno_definition VALUES (14, -889275714, 'slicer.10', 'wilde.pc1.wf01', '', '<derivation namespace="wilde.pc1.wf01" name="slicer.10" usesspace="fsl" uses="slicer"><pass bind="axis"><scalar><text>-x</text></scalar></pass><pass bind="inhdr"><scalar><lfn file="Data/Derived/atlas.hdr" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="inimg"><scalar><lfn file="Data/Derived/atlas.img" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="outslice"><scalar><lfn file="Data/Derived/atlas-x.pgm" link="output" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="position"><scalar><text>.5</text></scalar></pass></derivation>');
INSERT INTO anno_definition VALUES (15, -889275714, 'slicer.11', 'wilde.pc1.wf01', '', '<derivation namespace="wilde.pc1.wf01" name="slicer.11" usesspace="fsl" uses="slicer"><pass bind="axis"><scalar><text>-y</text></scalar></pass><pass bind="inhdr"><scalar><lfn file="Data/Derived/atlas.hdr" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="inimg"><scalar><lfn file="Data/Derived/atlas.img" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="outslice"><scalar><lfn file="Data/Derived/atlas-y.pgm" link="output" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="position"><scalar><text>.5</text></scalar></pass></derivation>');
INSERT INTO anno_definition VALUES (16, -889275714, 'slicer.12', 'wilde.pc1.wf01', '', '<derivation namespace="wilde.pc1.wf01" name="slicer.12" usesspace="fsl" uses="slicer"><pass bind="axis"><scalar><text>-z</text></scalar></pass><pass bind="inhdr"><scalar><lfn file="Data/Derived/atlas.hdr" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="inimg"><scalar><lfn file="Data/Derived/atlas.img" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="outslice"><scalar><lfn file="Data/Derived/atlas-z.pgm" link="output" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="position"><scalar><text>.5</text></scalar></pass></derivation>');
INSERT INTO anno_definition VALUES (17, -889275714, 'convert.13', 'wilde.pc1.wf01', '', '<derivation namespace="wilde.pc1.wf01" name="convert.13" usesspace="unix" uses="convert"><pass bind="inpgm"><scalar><lfn file="Data/Derived/atlas-x.pgm" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="outgif"><scalar><lfn file="Data/Derived/atlas-x.gif" link="output" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass></derivation>');
INSERT INTO anno_definition VALUES (18, -889275714, 'convert.14', 'wilde.pc1.wf01', '', '<derivation namespace="wilde.pc1.wf01" name="convert.14" usesspace="unix" uses="convert"><pass bind="inpgm"><scalar><lfn file="Data/Derived/atlas-y.pgm" link="input" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass><pass bind="outgif"><scalar><lfn file="Data/Derived/atlas-y.gif" link="output" dontRegister="false" dontTransfer="false" optional="false"/></scalar></pass></derivation>');


--
-- Data for TOC entry 131 (OID 2608744)
-- Name: anno_lfn_i; Type: TABLE DATA; Schema: public; Owner: benc
--

INSERT INTO anno_lfn_i VALUES (5, 'Data/Raw/reference.hdr');
INSERT INTO anno_lfn_i VALUES (5, 'Data/Raw/reference.img');
INSERT INTO anno_lfn_i VALUES (5, 'Data/Raw/anatomy1.hdr');
INSERT INTO anno_lfn_i VALUES (5, 'Data/Raw/anatomy1.img');
INSERT INTO anno_lfn_i VALUES (6, 'Data/Raw/anatomy1.hdr');
INSERT INTO anno_lfn_i VALUES (6, 'Data/Raw/anatomy1.img');
INSERT INTO anno_lfn_i VALUES (6, 'Data/Derived/warp1.warp');
INSERT INTO anno_lfn_i VALUES (7, 'Data/Raw/reference.hdr');
INSERT INTO anno_lfn_i VALUES (7, 'Data/Raw/reference.img');
INSERT INTO anno_lfn_i VALUES (7, 'Data/Raw/anatomy2.hdr');
INSERT INTO anno_lfn_i VALUES (7, 'Data/Raw/anatomy2.img');
INSERT INTO anno_lfn_i VALUES (8, 'Data/Raw/anatomy2.hdr');
INSERT INTO anno_lfn_i VALUES (8, 'Data/Raw/anatomy2.img');
INSERT INTO anno_lfn_i VALUES (8, 'Data/Derived/warp2.warp');
INSERT INTO anno_lfn_i VALUES (9, 'Data/Raw/reference.hdr');
INSERT INTO anno_lfn_i VALUES (9, 'Data/Raw/reference.img');
INSERT INTO anno_lfn_i VALUES (9, 'Data/Raw/anatomy3.hdr');
INSERT INTO anno_lfn_i VALUES (9, 'Data/Raw/anatomy3.img');
INSERT INTO anno_lfn_i VALUES (10, 'Data/Raw/anatomy3.hdr');
INSERT INTO anno_lfn_i VALUES (10, 'Data/Raw/anatomy3.img');
INSERT INTO anno_lfn_i VALUES (10, 'Data/Derived/warp3.warp');
INSERT INTO anno_lfn_i VALUES (11, 'Data/Raw/reference.hdr');
INSERT INTO anno_lfn_i VALUES (11, 'Data/Raw/reference.img');
INSERT INTO anno_lfn_i VALUES (11, 'Data/Raw/anatomy4.hdr');
INSERT INTO anno_lfn_i VALUES (11, 'Data/Raw/anatomy4.img');
INSERT INTO anno_lfn_i VALUES (12, 'Data/Raw/anatomy4.hdr');
INSERT INTO anno_lfn_i VALUES (12, 'Data/Raw/anatomy4.img');
INSERT INTO anno_lfn_i VALUES (12, 'Data/Derived/warp4.warp');
INSERT INTO anno_lfn_i VALUES (13, 'Data/Derived/resliced1.hdr');
INSERT INTO anno_lfn_i VALUES (13, 'Data/Derived/resliced2.hdr');
INSERT INTO anno_lfn_i VALUES (13, 'Data/Derived/resliced3.hdr');
INSERT INTO anno_lfn_i VALUES (13, 'Data/Derived/resliced4.hdr');
INSERT INTO anno_lfn_i VALUES (13, 'Data/Derived/resliced1.img');
INSERT INTO anno_lfn_i VALUES (13, 'Data/Derived/resliced2.img');
INSERT INTO anno_lfn_i VALUES (13, 'Data/Derived/resliced3.img');
INSERT INTO anno_lfn_i VALUES (13, 'Data/Derived/resliced4.img');
INSERT INTO anno_lfn_i VALUES (14, 'Data/Derived/atlas.hdr');
INSERT INTO anno_lfn_i VALUES (14, 'Data/Derived/atlas.img');
INSERT INTO anno_lfn_i VALUES (15, 'Data/Derived/atlas.hdr');
INSERT INTO anno_lfn_i VALUES (15, 'Data/Derived/atlas.img');
INSERT INTO anno_lfn_i VALUES (16, 'Data/Derived/atlas.hdr');
INSERT INTO anno_lfn_i VALUES (16, 'Data/Derived/atlas.img');
INSERT INTO anno_lfn_i VALUES (17, 'Data/Derived/atlas-x.pgm');
INSERT INTO anno_lfn_i VALUES (18, 'Data/Derived/atlas-y.pgm');
INSERT INTO anno_lfn_i VALUES (19, 'Data/Derived/atlas-z.pgm');


--
-- Data for TOC entry 132 (OID 2608751)
-- Name: anno_lfn_o; Type: TABLE DATA; Schema: public; Owner: benc
--

INSERT INTO anno_lfn_o VALUES (5, 'Data/Derived/warp1.warp');
INSERT INTO anno_lfn_o VALUES (6, 'Data/Derived/resliced1.hdr');
INSERT INTO anno_lfn_o VALUES (6, 'Data/Derived/resliced1.img');
INSERT INTO anno_lfn_o VALUES (7, 'Data/Derived/warp2.warp');
INSERT INTO anno_lfn_o VALUES (8, 'Data/Derived/resliced2.hdr');
INSERT INTO anno_lfn_o VALUES (8, 'Data/Derived/resliced2.img');
INSERT INTO anno_lfn_o VALUES (9, 'Data/Derived/warp3.warp');
INSERT INTO anno_lfn_o VALUES (10, 'Data/Derived/resliced3.hdr');
INSERT INTO anno_lfn_o VALUES (10, 'Data/Derived/resliced3.img');
INSERT INTO anno_lfn_o VALUES (11, 'Data/Derived/warp4.warp');
INSERT INTO anno_lfn_o VALUES (12, 'Data/Derived/resliced4.hdr');
INSERT INTO anno_lfn_o VALUES (12, 'Data/Derived/resliced4.img');
INSERT INTO anno_lfn_o VALUES (13, 'Data/Derived/atlas.hdr');
INSERT INTO anno_lfn_o VALUES (13, 'Data/Derived/atlas.img');
INSERT INTO anno_lfn_o VALUES (14, 'Data/Derived/atlas-x.pgm');
INSERT INTO anno_lfn_o VALUES (15, 'Data/Derived/atlas-y.pgm');
INSERT INTO anno_lfn_o VALUES (16, 'Data/Derived/atlas-z.pgm');
INSERT INTO anno_lfn_o VALUES (17, 'Data/Derived/atlas-x.gif');
INSERT INTO anno_lfn_o VALUES (18, 'Data/Derived/atlas-y.gif');
INSERT INTO anno_lfn_o VALUES (19, 'Data/Derived/atlas-z.gif');


--
-- Data for TOC entry 133 (OID 2608758)
-- Name: anno_lfn_b; Type: TABLE DATA; Schema: public; Owner: benc
--



--
-- Data for TOC entry 134 (OID 2608770)
-- Name: anno_tr; Type: TABLE DATA; Schema: public; Owner: benc
--



--
-- Data for TOC entry 135 (OID 2608777)
-- Name: anno_dv; Type: TABLE DATA; Schema: public; Owner: benc
--



--
-- Data for TOC entry 136 (OID 2608784)
-- Name: anno_lfn; Type: TABLE DATA; Schema: public; Owner: benc
--



--
-- Data for TOC entry 137 (OID 2608794)
-- Name: anno_targ; Type: TABLE DATA; Schema: public; Owner: benc
--



--
-- Data for TOC entry 138 (OID 2608801)
-- Name: anno_call; Type: TABLE DATA; Schema: public; Owner: benc
--



--
-- Data for TOC entry 139 (OID 2608818)
-- Name: anno_bool; Type: TABLE DATA; Schema: public; Owner: benc
--



--
-- Data for TOC entry 140 (OID 2608822)
-- Name: anno_int; Type: TABLE DATA; Schema: public; Owner: benc
--



--
-- Data for TOC entry 141 (OID 2608826)
-- Name: anno_float; Type: TABLE DATA; Schema: public; Owner: benc
--



--
-- Data for TOC entry 142 (OID 2608830)
-- Name: anno_date; Type: TABLE DATA; Schema: public; Owner: benc
--



--
-- Data for TOC entry 143 (OID 2608834)
-- Name: anno_text; Type: TABLE DATA; Schema: public; Owner: benc
--



--
-- Data for TOC entry 144 (OID 2608850)
-- 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 2608857)
-- Name: ptc_rusage; Type: TABLE DATA; Schema: public; Owner: benc
--

INSERT INTO ptc_rusage VALUES (0, 0.879, 2.524, 0, 0, 0, 1, 0, 0);
INSERT INTO ptc_rusage VALUES (1, 3.085, 0.29499999999999998, 0, 0, 0, 0, 0, 0);
INSERT INTO ptc_rusage VALUES (2, 0.86399999999999999, 2.496, 0, 0, 0, 1, 0, 0);
INSERT INTO ptc_rusage VALUES (3, 3.0409999999999999, 0.28699999999999998, 0, 0, 0, 0, 0, 0);
INSERT INTO ptc_rusage VALUES (4, 0.83799999999999997, 2.4630000000000001, 0, 0, 0, 1, 0, 0);
INSERT INTO ptc_rusage VALUES (5, 3.0369999999999999, 0.28100000000000003, 0, 0, 0, 0, 0, 0);
INSERT INTO ptc_rusage VALUES (6, 0.86699999999999999, 2.48, 0, 0, 0, 1, 0, 0);
INSERT INTO ptc_rusage VALUES (7, 3.0459999999999998, 0.29199999999999998, 0, 0, 0, 0, 0, 0);
INSERT INTO ptc_rusage VALUES (8, 0.032000000000000001, 0.099000000000000005, 0, 0, 0, 1, 0, 0);
INSERT INTO ptc_rusage VALUES (9, 0.066000000000000003, 0.065000000000000002, 0, 0, 0, 0, 0, 0);
INSERT INTO ptc_rusage VALUES (10, 0.035000000000000003, 0.106, 0, 0, 0, 1, 0, 0);
INSERT INTO ptc_rusage VALUES (11, 0.066000000000000003, 0.065000000000000002, 0, 0, 0, 0, 0, 0);
INSERT INTO ptc_rusage VALUES (12, 0.042000000000000003, 0.125, 0, 0, 0, 1, 0, 0);
INSERT INTO ptc_rusage VALUES (13, 0.067000000000000004, 0.065000000000000002, 0, 0, 0, 0, 0, 0);
INSERT INTO ptc_rusage VALUES (14, 2.2919999999999998, 6.6050000000000004, 0, 0, 0, 1, 0, 0);
INSERT INTO ptc_rusage VALUES (15, 7.9500000000000002, 0.50800000000000001, 0, 0, 0, 0, 1, 0);
INSERT INTO ptc_rusage VALUES (16, 2.1800000000000002, 6.2709999999999999, 0, 0, 0, 1, 0, 0);
INSERT INTO ptc_rusage VALUES (17, 7.9619999999999997, 0.54400000000000004, 0, 0, 0, 0, 0, 0);
INSERT INTO ptc_rusage VALUES (18, 2.202, 6.3600000000000003, 0, 0, 0, 1, 0, 0);
INSERT INTO ptc_rusage VALUES (19, 7.9470000000000001, 0.53600000000000003, 0, 0, 0, 0, 1, 0);
INSERT INTO ptc_rusage VALUES (20, 2.181, 6.3120000000000003, 0, 0, 0, 1, 0, 0);
INSERT INTO ptc_rusage VALUES (21, 7.9560000000000004, 0.56299999999999994, 0, 0, 0, 0, 0, 0);
INSERT INTO ptc_rusage VALUES (22, 1.3340000000000001, 3.9100000000000001, 0, 0, 0, 1, 0, 0);
INSERT INTO ptc_rusage VALUES (23, 4.2599999999999998, 0.91700000000000004, 0, 0, 0, 0, 0, 0);
INSERT INTO ptc_rusage VALUES (24, 1.302, 3.754, 0, 0, 0, 1, 0, 0);
INSERT INTO ptc_rusage VALUES (25, 4.2210000000000001, 0.879, 0, 0, 0, 0, 0, 0);
INSERT INTO ptc_rusage VALUES (26, 1.329, 3.8639999999999999, 0, 0, 0, 1, 0, 0);
INSERT INTO ptc_rusage VALUES (27, 4.25, 0.89400000000000002, 0, 0, 0, 0, 0, 0);
INSERT INTO ptc_rusage VALUES (28, 3.597, 10.137, 0, 0, 0, 1, 0, 0);
INSERT INTO ptc_rusage VALUES (29, 12.331, 1.329, 0, 0, 0, 0, 5, 0);


--
-- Data for TOC entry 146 (OID 2608862)
-- Name: ptc_stat; Type: TABLE DATA; Schema: public; Owner: benc
--

INSERT INTO ptc_stat VALUES (0, 0, '/Users/benc/src/AIR5.2.5/bin/align_warp', NULL, 631660, 33261, 20388839, '2007-02-21 05:24:30+00', '2007-02-21 00:18:50+00', '2007-02-21 00:18:50+00', 501, 501);
INSERT INTO ptc_stat VALUES (1, 0, '/Users/benc/src/AIR5.2.5/bin/align_warp', NULL, 631660, 33261, 20388839, '2007-02-21 05:36:42+00', '2007-02-21 00:18:50+00', '2007-02-21 00:18:50+00', 501, 501);
INSERT INTO ptc_stat VALUES (2, 0, '/Users/benc/src/AIR5.2.5/bin/align_warp', NULL, 631660, 33261, 20388839, '2007-02-21 05:36:57+00', '2007-02-21 00:18:50+00', '2007-02-21 00:18:50+00', 501, 501);
INSERT INTO ptc_stat VALUES (3, 0, '/Users/benc/src/AIR5.2.5/bin/align_warp', NULL, 631660, 33261, 20388839, '2007-02-21 05:36:52+00', '2007-02-21 00:18:50+00', '2007-02-21 00:18:50+00', 501, 501);
INSERT INTO ptc_stat VALUES (4, 0, '/opt/local/bin/convert', NULL, 31396, 33261, 13867241, '2007-02-21 05:27:18+00', '2006-02-09 02:18:00+00', '2006-02-09 02:16:25+00', 0, 80);
INSERT INTO ptc_stat VALUES (5, 0, '/opt/local/bin/convert', NULL, 31396, 33261, 13867241, '2007-02-21 05:40:01+00', '2006-02-09 02:18:00+00', '2006-02-09 02:16:25+00', 0, 80);
INSERT INTO ptc_stat VALUES (6, 0, '/opt/local/bin/convert', NULL, 31396, 33261, 13867241, '2007-02-21 05:40:03+00', '2006-02-09 02:18:00+00', '2006-02-09 02:16:25+00', 0, 80);
INSERT INTO ptc_stat VALUES (7, 0, '/Users/benc/src/AIR5.2.5/bin/reslice', NULL, 592684, 33261, 20389030, '2007-02-21 05:25:50+00', '2007-02-21 00:19:02+00', '2007-02-21 00:19:02+00', 501, 501);
INSERT INTO ptc_stat VALUES (8, 0, '/Users/benc/src/AIR5.2.5/bin/reslice', NULL, 592684, 33261, 20389030, '2007-02-21 05:37:28+00', '2007-02-21 00:19:02+00', '2007-02-21 00:19:02+00', 501, 501);
INSERT INTO ptc_stat VALUES (9, 0, '/Users/benc/src/AIR5.2.5/bin/reslice', NULL, 592684, 33261, 20389030, '2007-02-21 05:37:58+00', '2007-02-21 00:19:02+00', '2007-02-21 00:19:02+00', 501, 501);
INSERT INTO ptc_stat VALUES (10, 0, '/Users/benc/src/AIR5.2.5/bin/reslice', NULL, 592684, 33261, 20389030, '2007-02-21 05:37:53+00', '2007-02-21 00:19:02+00', '2007-02-21 00:19:02+00', 501, 501);
INSERT INTO ptc_stat VALUES (11, 0, '/Users/benc/src/fsl/bin/slicer', NULL, 1893124, 33261, 20397670, '2007-02-21 05:27:11+00', '2007-02-21 04:30:01+00', '2006-04-07 14:36:22+01', 501, 501);
INSERT INTO ptc_stat VALUES (12, 0, '/Users/benc/src/fsl/bin/slicer', NULL, 1893124, 33261, 20397670, '2007-02-21 05:39:29+00', '2007-02-21 04:30:01+00', '2006-04-07 14:36:22+01', 501, 501);
INSERT INTO ptc_stat VALUES (13, 0, '/Users/benc/src/fsl/bin/slicer', NULL, 1893124, 33261, 20397670, '2007-02-21 05:39:43+00', '2007-02-21 04:30:01+00', '2006-04-07 14:36:22+01', 501, 501);
INSERT INTO ptc_stat VALUES (14, 0, '/Users/benc/src/AIR5.2.5/bin/softmean', NULL, 147372, 33261, 20389135, '2007-02-21 05:26:21+00', '2007-02-21 00:19:09+00', '2007-02-21 00:19:09+00', 501, 501);


--
-- Data for TOC entry 147 (OID 2608867)
-- Name: ptc_invocation; Type: TABLE DATA; Schema: public; Owner: benc
--

INSERT INTO ptc_invocation VALUES (0, 'benc', '2007-02-21 05:52:31.773+00', NULL, NULL, '1.10', '2007-02-21 05:36:34.381+00', 7.9169999999999998, 'air', 'align_warp', NULL, 'wilde.pc1.wf01', 'align_warp.5', NULL, 'local', '0.0.0.0', 15870, 501, 501, '/Users/benc/work/provchal2/test', 0, 0);
INSERT INTO ptc_invocation VALUES (1, 'benc', '2007-02-21 05:52:35.715+00', NULL, NULL, '1.10', '2007-02-21 05:36:44.28+00', 7.9420000000000002, 'air', 'align_warp', NULL, 'wilde.pc1.wf01', 'align_warp.1', NULL, 'local', '0.0.0.0', 15885, 501, 501, '/Users/benc/work/provchal2/test', 0, 2);
INSERT INTO ptc_invocation VALUES (2, 'benc', '2007-02-21 05:52:39.46+00', NULL, NULL, '1.10', '2007-02-21 05:37:03.727+00', 7.1449999999999996, 'air', 'align_warp', NULL, 'wilde.pc1.wf01', 'align_warp.3', NULL, 'local', '0.0.0.0', 15915, 501, 501, '/Users/benc/work/provchal2/test', 0, 4);
INSERT INTO ptc_invocation VALUES (3, 'benc', '2007-02-21 05:52:43.188+00', NULL, NULL, '1.10', '2007-02-21 05:36:53.893+00', 8.0660000000000007, 'air', 'align_warp', NULL, 'wilde.pc1.wf01', 'align_warp.7', NULL, 'local', '0.0.0.0', 15900, 501, 501, '/Users/benc/work/provchal2/test', 0, 6);
INSERT INTO ptc_invocation VALUES (4, 'benc', '2007-02-21 05:52:46.978+00', NULL, NULL, '1.10', '2007-02-21 05:40:01.817+00', 0.26700000000000002, 'unix', 'convert', NULL, 'wilde.pc1.wf01', 'convert.13', NULL, 'local', '0.0.0.0', 16051, 501, 501, '/Users/benc/work/provchal2/test', 0, 8);
INSERT INTO ptc_invocation VALUES (5, 'benc', '2007-02-21 05:52:50.687+00', NULL, NULL, '1.10', '2007-02-21 05:40:03.695+00', 0.28799999999999998, 'unix', 'convert', NULL, 'wilde.pc1.wf01', 'convert.14', NULL, 'local', '0.0.0.0', 16067, 501, 501, '/Users/benc/work/provchal2/test', 0, 10);
INSERT INTO ptc_invocation VALUES (6, 'benc', '2007-02-21 05:52:54.107+00', NULL, NULL, '1.10', '2007-02-21 05:40:05.586+00', 0.315, 'unix', 'convert', NULL, 'wilde.pc1.wf01', 'convert.15', NULL, 'local', '0.0.0.0', 16082, 501, 501, '/Users/benc/work/provchal2/test', 0, 12);
INSERT INTO ptc_invocation VALUES (7, 'benc', '2007-02-21 05:52:57.925+00', NULL, NULL, '1.10', '2007-02-21 05:37:12.797+00', 18.370999999999999, 'air', 'reslice', NULL, 'wilde.pc1.wf01', 'reslice.6', NULL, 'local', '0.0.0.0', 15930, 501, 501, '/Users/benc/work/provchal2/test', 0, 14);
INSERT INTO ptc_invocation VALUES (8, 'benc', '2007-02-21 05:53:01.777+00', NULL, NULL, '1.10', '2007-02-21 05:37:33.431+00', 19.768999999999998, 'air', 'reslice', NULL, 'wilde.pc1.wf01', 'reslice.2', NULL, 'local', '0.0.0.0', 15945, 501, 501, '/Users/benc/work/provchal2/test', 0, 16);
INSERT INTO ptc_invocation VALUES (9, 'benc', '2007-02-21 05:53:05.298+00', NULL, NULL, '1.10', '2007-02-21 05:38:18.87+00', 18.114999999999998, 'air', 'reslice', NULL, 'wilde.pc1.wf01', 'reslice.4', NULL, 'local', '0.0.0.0', 15975, 501, 501, '/Users/benc/work/provchal2/test', 0, 18);
INSERT INTO ptc_invocation VALUES (10, 'benc', '2007-02-21 05:53:08.849+00', NULL, NULL, '1.10', '2007-02-21 05:37:55.741+00', 19.542000000000002, 'air', 'reslice', NULL, 'wilde.pc1.wf01', 'reslice.8', NULL, 'local', '0.0.0.0', 15960, 501, 501, '/Users/benc/work/provchal2/test', 0, 20);
INSERT INTO ptc_invocation VALUES (11, 'benc', '2007-02-21 05:53:12.011+00', NULL, NULL, '1.10', '2007-02-21 05:39:13.905+00', 19.166, 'fsl', 'slicer', NULL, 'wilde.pc1.wf01', 'slicer.10', NULL, 'local', '0.0.0.0', 16005, 501, 501, '/Users/benc/work/provchal2/test', 0, 22);
INSERT INTO ptc_invocation VALUES (12, 'benc', '2007-02-21 05:53:15.143+00', NULL, NULL, '1.10', '2007-02-21 05:39:34.666+00', 12.144, 'fsl', 'slicer', NULL, 'wilde.pc1.wf01', 'slicer.11', NULL, 'local', '0.0.0.0', 16020, 501, 501, '/Users/benc/work/provchal2/test', 0, 24);
INSERT INTO ptc_invocation VALUES (13, 'benc', '2007-02-21 05:53:18.296+00', NULL, NULL, '1.10', '2007-02-21 05:39:48.412+00', 11.795999999999999, 'fsl', 'slicer', NULL, 'wilde.pc1.wf01', 'slicer.12', NULL, 'local', '0.0.0.0', 16036, 501, 501, '/Users/benc/work/provchal2/test', 0, 26);
INSERT INTO ptc_invocation VALUES (14, 'benc', '2007-02-21 05:53:21.988+00', NULL, NULL, '1.10', '2007-02-21 05:38:38.697+00', 30.774999999999999, 'air', 'softmean', NULL, 'wilde.pc1.wf01', 'softmean.9', NULL, 'local', '0.0.0.0', 15990, 501, 501, '/Users/benc/work/provchal2/test', 0, 28);


--
-- Data for TOC entry 148 (OID 2608885)
-- Name: ptc_job; Type: TABLE DATA; Schema: public; Owner: benc
--

INSERT INTO ptc_job VALUES (0, 'M', '2007-02-21 05:36:34.389+00', 7.9080000000000004, 15871, 1, 0, 0, NULL, 'Data/Raw/reference.img Data/Raw/anatomy3.img /Users/benc/work/provchal2/test/Data/Derived/warp3.warp -m 12 -q');
INSERT INTO ptc_job VALUES (1, 'M', '2007-02-21 05:36:44.286+00', 7.9359999999999999, 15886, 3, 1, 0, NULL, 'Data/Raw/reference.img Data/Raw/anatomy1.img /Users/benc/work/provchal2/test/Data/Derived/warp1.warp -m 12 -q');
INSERT INTO ptc_job VALUES (2, 'M', '2007-02-21 05:37:03.733+00', 7.1390000000000002, 15916, 5, 2, 0, NULL, 'Data/Raw/reference.img Data/Raw/anatomy2.img /Users/benc/work/provchal2/test/Data/Derived/warp2.warp -m 12 -q');
INSERT INTO ptc_job VALUES (3, 'M', '2007-02-21 05:36:53.899+00', 8.0589999999999993, 15901, 7, 3, 0, NULL, 'Data/Raw/reference.img Data/Raw/anatomy4.img /Users/benc/work/provchal2/test/Data/Derived/warp4.warp -m 12 -q');
INSERT INTO ptc_job VALUES (4, 'M', '2007-02-21 05:40:01.823+00', 0.26100000000000001, 16052, 9, 4, 0, NULL, '/Users/benc/work/provchal2/test/Data/Derived/atlas-x.pgm /Users/benc/work/provchal2/test/Data/Derived/atlas-x.gif');
INSERT INTO ptc_job VALUES (5, 'M', '2007-02-21 05:40:03.701+00', 0.28199999999999997, 16068, 11, 5, 0, NULL, '/Users/benc/work/provchal2/test/Data/Derived/atlas-y.pgm /Users/benc/work/provchal2/test/Data/Derived/atlas-y.gif');
INSERT INTO ptc_job VALUES (6, 'M', '2007-02-21 05:40:05.592+00', 0.309, 16083, 13, 6, 0, NULL, '/Users/benc/work/provchal2/test/Data/Derived/atlas-z.pgm /Users/benc/work/provchal2/test/Data/Derived/atlas-z.gif');
INSERT INTO ptc_job VALUES (7, 'M', '2007-02-21 05:37:12.802+00', 18.364000000000001, 15931, 15, 7, 0, NULL, '/Users/benc/work/provchal2/test/Data/Derived/warp3.warp /Users/benc/work/provchal2/test/Data/Derived/resliced3.img');
INSERT INTO ptc_job VALUES (8, 'M', '2007-02-21 05:37:33.436+00', 19.763000000000002, 15946, 17, 8, 0, NULL, '/Users/benc/work/provchal2/test/Data/Derived/warp1.warp /Users/benc/work/provchal2/test/Data/Derived/resliced1.img');
INSERT INTO ptc_job VALUES (9, 'M', '2007-02-21 05:38:18.875+00', 18.109000000000002, 15976, 19, 9, 0, NULL, '/Users/benc/work/provchal2/test/Data/Derived/warp2.warp /Users/benc/work/provchal2/test/Data/Derived/resliced2.img');
INSERT INTO ptc_job VALUES (10, 'M', '2007-02-21 05:37:55.747+00', 19.536000000000001, 15961, 21, 10, 0, NULL, '/Users/benc/work/provchal2/test/Data/Derived/warp4.warp /Users/benc/work/provchal2/test/Data/Derived/resliced4.img');
INSERT INTO ptc_job VALUES (11, 'M', '2007-02-21 05:39:13.911+00', 19.158999999999999, 16006, 23, 11, 0, NULL, '/Users/benc/work/provchal2/test/Data/Derived/atlas.img -x .5 /Users/benc/work/provchal2/test/Data/Derived/atlas-x.pgm');
INSERT INTO ptc_job VALUES (12, 'M', '2007-02-21 05:39:34.671+00', 12.138, 16021, 25, 12, 0, NULL, '/Users/benc/work/provchal2/test/Data/Derived/atlas.img -y .5 /Users/benc/work/provchal2/test/Data/Derived/atlas-y.pgm');
INSERT INTO ptc_job VALUES (13, 'M', '2007-02-21 05:39:48.418+00', 11.789999999999999, 16037, 27, 13, 0, NULL, '/Users/benc/work/provchal2/test/Data/Derived/atlas.img -z .5 /Users/benc/work/provchal2/test/Data/Derived/atlas-z.pgm');
INSERT INTO ptc_job VALUES (14, 'M', '2007-02-21 05:38:38.703+00', 30.768000000000001, 15991, 29, 14, 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 2608904)
-- Name: ptc_lfn; Type: TABLE DATA; Schema: public; Owner: benc
--



--
-- Data for TOC entry 150 (OID 2608917)
-- Name: tc_sysinfo; Type: TABLE DATA; Schema: public; Owner: benc
--



--
-- Data for TOC entry 151 (OID 2608926)
-- Name: tc_physicaltx; Type: TABLE DATA; Schema: public; Owner: benc
--



--
-- Data for TOC entry 152 (OID 2608944)
-- Name: tc_logicaltx; Type: TABLE DATA; Schema: public; Owner: benc
--



--
-- Data for TOC entry 153 (OID 2608952)
-- Name: tc_lfnprofile; Type: TABLE DATA; Schema: public; Owner: benc
--



--
-- Data for TOC entry 154 (OID 2608967)
-- Name: tc_lfnpfnmap; Type: TABLE DATA; Schema: public; Owner: benc
--



--
-- Data for TOC entry 155 (OID 2608981)
-- Name: tc_pfnprofile; Type: TABLE DATA; Schema: public; Owner: benc
--



--
-- Data for TOC entry 156 (OID 2608999)
-- Name: rc_lfn; Type: TABLE DATA; Schema: public; Owner: benc
--



--
-- Data for TOC entry 157 (OID 2609007)
-- Name: rc_attr; Type: TABLE DATA; Schema: public; Owner: benc
--



--
-- Data for TOC entry 158 (OID 2609019)
-- Name: wf_work; Type: TABLE DATA; Schema: public; Owner: benc
--



--
-- Data for TOC entry 159 (OID 2609029)
-- Name: wf_jobstate; Type: TABLE DATA; Schema: public; Owner: benc
--



--
-- Data for TOC entry 160 (OID 2609040)
-- Name: wf_siteinfo; Type: TABLE DATA; Schema: public; Owner: benc
--



--
-- TOC entry 59 (OID 2608765)
-- 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 2608766)
-- 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 2608767)
-- 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 2608808)
-- 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 2608809)
-- 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 2608810)
-- 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 2608811)
-- 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 2608812)
-- 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 2608813)
-- 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 2608814)
-- 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 2608815)
-- 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 2608816)
-- 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 2608817)
-- 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 2608938)
-- 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 2608939)
-- 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 2608940)
-- 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 2608941)
-- 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 2608951)
-- 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 2608964)
-- 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 2608965)
-- 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 2608966)
-- 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 2608979)
-- 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 2608980)
-- 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 2608993)
-- 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 2608994)
-- 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 2608995)
-- 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 2609006)
-- 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 2609015)
-- 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 2609037)
-- 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 2608729)
-- 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 2608740)
-- 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 2608742)
-- 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 2608749)
-- 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 2608756)
-- 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 2608763)
-- 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 2608773)
-- 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 2608775)
-- 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 2608780)
-- 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 2608782)
-- 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 2608790)
-- 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 2608792)
-- 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 2608797)
-- 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 2608799)
-- 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 2608804)
-- 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 2608806)
-- 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 2608820)
-- 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 2608824)
-- 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 2608828)
-- 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 2608832)
-- 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 2608839)
-- 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 2608853)
-- 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 2608855)
-- 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 2608860)
-- 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 2608865)
-- 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 2608875)
-- 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 2608890)
-- 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 2608920)
-- 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 2608922)
-- 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 2608930)
-- 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 2608932)
-- 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 2608947)
-- 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 2608949)
-- 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 2608958)
-- 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 2608969)
-- 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 2608987)
-- 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 2609002)
-- 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 2609004)
-- 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 2609009)
-- 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 2609025)
-- 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 2609027)
-- 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 2609031)
-- 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 2609048)
-- 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 2609050)
-- 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 2608877)
-- 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 2608881)
-- 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 2608892)
-- 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 2608896)
-- 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 2608900)
-- 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 2608906)
-- 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 2608910)
-- 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 2608934)
-- 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 2608960)
-- 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 2608971)
-- 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 2608975)
-- 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 2608989)
-- 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 2609011)
-- 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 2609033)
-- 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 2608732)
-- Name: def_id_seq; Type: SEQUENCE SET; Schema: public; Owner: benc
--

SELECT pg_catalog.setval('def_id_seq', 19, true);


--
-- TOC entry 8 (OID 2608768)
-- Name: anno_id_seq; Type: SEQUENCE SET; Schema: public; Owner: benc
--

SELECT pg_catalog.setval('anno_id_seq', 0, false);


--
-- TOC entry 10 (OID 2608842)
-- Name: uname_id_seq; Type: SEQUENCE SET; Schema: public; Owner: benc
--

SELECT pg_catalog.setval('uname_id_seq', 0, true);


--
-- TOC entry 12 (OID 2608844)
-- Name: rusage_id_seq; Type: SEQUENCE SET; Schema: public; Owner: benc
--

SELECT pg_catalog.setval('rusage_id_seq', 29, true);


--
-- TOC entry 14 (OID 2608846)
-- Name: stat_id_seq; Type: SEQUENCE SET; Schema: public; Owner: benc
--

SELECT pg_catalog.setval('stat_id_seq', 14, true);


--
-- TOC entry 16 (OID 2608848)
-- Name: invocation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: benc
--

SELECT pg_catalog.setval('invocation_id_seq', 14, true);


--
-- TOC entry 51 (OID 2608915)
-- 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 2608924)
-- 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 2608942)
-- 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 2608997)
-- Name: rc_lfn_id; Type: SEQUENCE SET; Schema: public; Owner: benc
--

SELECT pg_catalog.setval('rc_lfn_id', 1, false);


--
-- TOC entry 54 (OID 2609017)
-- 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 2609038)
-- 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';