export host= user=postgres database=vegbank

if test -z "${password+_}"

then

    echo "Password can also be specified with: export password=..."

    read -s -p "Password for $user@$host: "; echo

    export password="$REPLY"

fi

-- Dumped from database version 9.1.1

-- Dumped by pg_dump version 9.1.0

-- Started on 2011-11-18 12:56:30 PST

SET standard_conforming_strings = on;

-- TOC entry 3354 (class 1262 OID 43433)

-- Name: vegbank; Type: DATABASE; Schema: -; Owner: -

CREATE DATABASE vegbank WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'C' LC_CTYPE = 'C';

SET standard_conforming_strings = on;

--

-- TOC entry 383 (class 3079 OID 11906)

-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: -

--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;

--

-- TOC entry 3357 (class 0 OID 0)

-- Dependencies: 383

-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: -

--

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';

-- TOC entry 1125 (class 1255 OID 43434)

-- Dependencies: 6

-- Name: concat(text); Type: AGGREGATE; Schema: public; Owner: -

-- TOC entry 161 (class 1259 OID 43435)

-- Dependencies: 6

-- Name: address; Type: TABLE; Schema: public; Owner: -; Tablespace: 

-- TOC entry 162 (class 1259 OID 43441)

-- Dependencies: 161 6

-- Name: address_address_id_seq; Type: SEQUENCE; Schema: public; Owner: -

    NO MAXVALUE

-- TOC entry 3358 (class 0 OID 0)

-- Dependencies: 162

-- Name: address_address_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

-- TOC entry 163 (class 1259 OID 43443)

-- Dependencies: 6

-- Name: aux_role; Type: TABLE; Schema: public; Owner: -; Tablespace: 

-- TOC entry 164 (class 1259 OID 43446)

-- Dependencies: 163 6

-- Name: aux_role_role_id_seq; Type: SEQUENCE; Schema: public; Owner: -

    NO MAXVALUE

-- TOC entry 3359 (class 0 OID 0)

-- Dependencies: 164

-- Name: aux_role_role_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

-- TOC entry 165 (class 1259 OID 43448)

-- Dependencies: 6

-- Name: classcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 

-- TOC entry 166 (class 1259 OID 43451)

-- Dependencies: 165 6

-- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: -

    NO MAXVALUE

-- TOC entry 3360 (class 0 OID 0)

-- Dependencies: 166

-- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

-- TOC entry 167 (class 1259 OID 43453)

-- Dependencies: 6

-- Name: commclass; Type: TABLE; Schema: public; Owner: -; Tablespace: 

-- TOC entry 168 (class 1259 OID 43459)

-- Dependencies: 167 6

-- Name: commclass_commclass_id_seq; Type: SEQUENCE; Schema: public; Owner: -

    NO MAXVALUE

-- TOC entry 3361 (class 0 OID 0)

-- Dependencies: 168

-- Name: commclass_commclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

-- TOC entry 169 (class 1259 OID 43461)

-- Dependencies: 6

-- Name: commconcept; Type: TABLE; Schema: public; Owner: -; Tablespace: 

-- TOC entry 170 (class 1259 OID 43467)

-- Dependencies: 169 6

-- Name: commconcept_commconcept_id_seq; Type: SEQUENCE; Schema: public; Owner: -

    NO MAXVALUE

-- TOC entry 3362 (class 0 OID 0)

-- Dependencies: 170

-- Name: commconcept_commconcept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

-- TOC entry 171 (class 1259 OID 43469)

-- Dependencies: 6

-- Name: commcorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 

-- TOC entry 172 (class 1259 OID 43472)

-- Dependencies: 6 171

-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -

    NO MAXVALUE

-- TOC entry 3363 (class 0 OID 0)

-- Dependencies: 172

-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

-- TOC entry 173 (class 1259 OID 43474)

-- Dependencies: 6

-- Name: comminterpretation; Type: TABLE; Schema: public; Owner: -; Tablespace: 

-- TOC entry 174 (class 1259 OID 43480)

-- Dependencies: 6 173

-- Name: comminterpretation_comminterpretation_id_seq; Type: SEQUENCE; Schema: public; Owner: -

    NO MAXVALUE

-- TOC entry 3364 (class 0 OID 0)

-- Dependencies: 174

-- Name: comminterpretation_comminterpretation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

-- TOC entry 175 (class 1259 OID 43482)

-- Dependencies: 6

-- Name: commlineage; Type: TABLE; Schema: public; Owner: -; Tablespace: 

-- TOC entry 176 (class 1259 OID 43485)

-- Dependencies: 175 6

-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE; Schema: public; Owner: -

    NO MAXVALUE

-- TOC entry 3365 (class 0 OID 0)

-- Dependencies: 176

-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

-- TOC entry 177 (class 1259 OID 43487)

-- Dependencies: 2822 6

-- Name: commname; Type: TABLE; Schema: public; Owner: -; Tablespace: 

-- TOC entry 178 (class 1259 OID 43494)

-- Dependencies: 6 177

-- Name: commname_commname_id_seq; Type: SEQUENCE; Schema: public; Owner: -

    NO MAXVALUE

-- TOC entry 3366 (class 0 OID 0)

-- Dependencies: 178

-- Name: commname_commname_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

-- TOC entry 179 (class 1259 OID 43496)

-- Dependencies: 6

-- Name: commstatus; Type: TABLE; Schema: public; Owner: -; Tablespace: 

-- TOC entry 180 (class 1259 OID 43502)

-- Dependencies: 179 6

-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE; Schema: public; Owner: -

    NO MAXVALUE

-- TOC entry 3367 (class 0 OID 0)

-- Dependencies: 180

-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

-- TOC entry 181 (class 1259 OID 43504)

-- Dependencies: 6

-- Name: commusage; Type: TABLE; Schema: public; Owner: -; Tablespace: 

-- TOC entry 182 (class 1259 OID 43510)

-- Dependencies: 6 181

-- Name: commusage_commusage_id_seq; Type: SEQUENCE; Schema: public; Owner: -

    NO MAXVALUE

-- TOC entry 3368 (class 0 OID 0)

-- Dependencies: 182

-- Name: commusage_commusage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

-- TOC entry 183 (class 1259 OID 43512)

-- Dependencies: 6

-- Name: coverindex; Type: TABLE; Schema: public; Owner: -; Tablespace: 

-- TOC entry 184 (class 1259 OID 43518)

-- Dependencies: 183 6

-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE; Schema: public; Owner: -

    NO MAXVALUE

-- TOC entry 3369 (class 0 OID 0)

-- Dependencies: 184

-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

-- TOC entry 185 (class 1259 OID 43520)

-- Dependencies: 6

-- Name: covermethod; Type: TABLE; Schema: public; Owner: -; Tablespace: 

-- TOC entry 186 (class 1259 OID 43523)

-- Dependencies: 6 185

-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE; Schema: public; Owner: -

    NO MAXVALUE

-- TOC entry 3370 (class 0 OID 0)

-- Dependencies: 186

-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

-- TOC entry 187 (class 1259 OID 43525)

-- Dependencies: 6

-- Name: dba_confidentialitystatus; Type: TABLE; Schema: public; Owner: -; Tablespace: 

-- TOC entry 188 (class 1259 OID 43528)

-- Dependencies: 6

-- Name: dba_cookie; Type: TABLE; Schema: public; Owner: -; Tablespace: 

-- TOC entry 189 (class 1259 OID 43534)

-- Dependencies: 6 188

-- Name: dba_cookie_cookie_id_seq; Type: SEQUENCE; Schema: public; Owner: -

    NO MAXVALUE

-- TOC entry 3371 (class 0 OID 0)

-- Dependencies: 189

-- Name: dba_cookie_cookie_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

-- TOC entry 190 (class 1259 OID 43536)

-- Dependencies: 6

-- Name: dba_cookielabels; Type: TABLE; Schema: public; Owner: -; Tablespace: 

-- TOC entry 191 (class 1259 OID 43542)

-- Dependencies: 6 190

-- Name: dba_cookielabels_cookielabel_id_seq; Type: SEQUENCE; Schema: public; Owner: -

    NO MAXVALUE

-- TOC entry 3372 (class 0 OID 0)

-- Dependencies: 191

-- Name: dba_cookielabels_cookielabel_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

-- TOC entry 192 (class 1259 OID 43544)

-- Dependencies: 6

-- Name: dba_datacache; Type: TABLE; Schema: public; Owner: -; Tablespace: 

-- TOC entry 193 (class 1259 OID 43550)

-- Dependencies: 6 192

-- Name: dba_datacache_dba_datacache_id_seq; Type: SEQUENCE; Schema: public; Owner: -

    NO MAXVALUE

-- TOC entry 3373 (class 0 OID 0)

-- Dependencies: 193

-- Name: dba_datacache_dba_datacache_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

-- TOC entry 194 (class 1259 OID 43552)

-- Dependencies: 2831 6

-- Name: dba_datamodelversion; Type: TABLE; Schema: public; Owner: -; Tablespace: 

-- TOC entry 195 (class 1259 OID 43556)

-- Dependencies: 194 6

-- Name: dba_datamodelversion_dba_datamodelversion_id_seq; Type: SEQUENCE; Schema: public; Owner: -

    NO MAXVALUE

-- TOC entry 3374 (class 0 OID 0)

-- Dependencies: 195

-- Name: dba_datamodelversion_dba_datamodelversion_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

-- TOC entry 196 (class 1259 OID 43558)

-- Dependencies: 6

-- Name: dba_dbstatstime; Type: TABLE; Schema: public; Owner: -; Tablespace: 

-- TOC entry 197 (class 1259 OID 43564)

-- Dependencies: 196 6

-- Name: dba_dbstatstime_stat_id_seq; Type: SEQUENCE; Schema: public; Owner: -

    NO MAXVALUE

-- TOC entry 3375 (class 0 OID 0)

-- Dependencies: 197

-- Name: dba_dbstatstime_stat_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

-- TOC entry 198 (class 1259 OID 43566)

-- Dependencies: 6

-- Name: dba_fielddescription; Type: TABLE; Schema: public; Owner: -; Tablespace: 

-- TOC entry 199 (class 1259 OID 43572)

-- Dependencies: 198 6

-- Name: dba_fielddescription_dba_fielddescription_id_seq; Type: SEQUENCE; Schema: public; Owner: -

    NO MAXVALUE

-- TOC entry 3376 (class 0 OID 0)

-- Dependencies: 199

-- Name: dba_fielddescription_dba_fielddescription_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

-- TOC entry 200 (class 1259 OID 43574)

-- Dependencies: 6

-- Name: dba_fieldlist; Type: TABLE; Schema: public; Owner: -; Tablespace: 

-- TOC entry 201 (class 1259 OID 43580)

-- Dependencies: 6 200

-- Name: dba_fieldlist_dba_fieldlist_id_seq; Type: SEQUENCE; Schema: public; Owner: -

    NO MAXVALUE

-- TOC entry 3377 (class 0 OID 0)

-- Dependencies: 201

-- Name: dba_fieldlist_dba_fieldlist_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

-- TOC entry 202 (class 1259 OID 43582)

-- Dependencies: 6

-- Name: dba_onerow; Type: TABLE; Schema: public; Owner: -; Tablespace: 

-- TOC entry 203 (class 1259 OID 43585)

-- Dependencies: 202 6

-- Name: dba_onerow_dba_onerow_id_seq; Type: SEQUENCE; Schema: public; Owner: -

    NO MAXVALUE

-- TOC entry 3378 (class 0 OID 0)

-- Dependencies: 203

-- Name: dba_onerow_dba_onerow_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

-- TOC entry 204 (class 1259 OID 43587)

-- Dependencies: 2837 6

-- Name: dba_preassignacccode; Type: TABLE; Schema: public; Owner: -; Tablespace: 

-- TOC entry 205 (class 1259 OID 43591)

-- Dependencies: 204 6

-- Name: dba_preassignacccode_dba_preassignacccode_id_seq; Type: SEQUENCE; Schema: public; Owner: -

    NO MAXVALUE

-- TOC entry 3379 (class 0 OID 0)

-- Dependencies: 205

-- Name: dba_preassignacccode_dba_preassignacccode_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

-- TOC entry 206 (class 1259 OID 43593)

-- Dependencies: 6

-- Name: dba_preassignacccode_dba_requestnumber_seq; Type: SEQUENCE; Schema: public; Owner: -

    NO MAXVALUE

-- TOC entry 207 (class 1259 OID 43595)

-- Dependencies: 6

-- Name: dba_tabledescription; Type: TABLE; Schema: public; Owner: -; Tablespace: 

-- TOC entry 208 (class 1259 OID 43601)

-- Dependencies: 6 207

-- Name: dba_tabledescription_dba_tabledescription_id_seq; Type: SEQUENCE; Schema: public; Owner: -

    NO MAXVALUE

-- TOC entry 3380 (class 0 OID 0)

-- Dependencies: 208

-- Name: dba_tabledescription_dba_tabledescription_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

-- TOC entry 209 (class 1259 OID 43603)

-- Dependencies: 6

-- Name: dba_xmlcache; Type: TABLE; Schema: public; Owner: -; Tablespace: 

-- TOC entry 210 (class 1259 OID 43609)

-- Dependencies: 6

-- Name: definedvalue; Type: TABLE; Schema: public; Owner: -; Tablespace: 

-- TOC entry 211 (class 1259 OID 43615)

-- Dependencies: 6 210

-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE; Schema: public; Owner: -

    NO MAXVALUE

-- TOC entry 3381 (class 0 OID 0)

-- Dependencies: 211

-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

-- TOC entry 212 (class 1259 OID 43617)

-- Dependencies: 6

-- Name: disturbanceobs; Type: TABLE; Schema: public; Owner: -; Tablespace: 

-- TOC entry 213 (class 1259 OID 43623)

-- Dependencies: 212 6

-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -

    NO MAXVALUE

-- TOC entry 3382 (class 0 OID 0)

-- Dependencies: 213

-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

-- TOC entry 214 (class 1259 OID 43625)

-- Dependencies: 6

-- Name: embargo; Type: TABLE; Schema: public; Owner: -; Tablespace: 

-- TOC entry 215 (class 1259 OID 43631)

-- Dependencies: 214 6

-- Name: embargo_embargo_id_seq; Type: SEQUENCE; Schema: public; Owner: -

    NO MAXVALUE

-- TOC entry 3383 (class 0 OID 0)

-- Dependencies: 215

-- Name: embargo_embargo_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

-- TOC entry 216 (class 1259 OID 43633)

-- Dependencies: 6

-- Name: graphic; Type: TABLE; Schema: public; Owner: -; Tablespace: 

-- TOC entry 217 (class 1259 OID 43639)

-- Dependencies: 216 6

-- Name: graphic_graphic_id_seq; Type: SEQUENCE; Schema: public; Owner: -

    NO MAXVALUE

-- TOC entry 3384 (class 0 OID 0)

-- Dependencies: 217

-- Name: graphic_graphic_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

-- TOC entry 218 (class 1259 OID 43641)

-- Dependencies: 6

-- Name: keywords; Type: TABLE; Schema: public; Owner: -; Tablespace: 

-- TOC entry 219 (class 1259 OID 43647)

-- Dependencies: 6

-- Name: keywords_extra; Type: TABLE; Schema: public; Owner: -; Tablespace: 

-- TOC entry 220 (class 1259 OID 43653)

-- Dependencies: 6

-- Name: namedplace; Type: TABLE; Schema: public; Owner: -; Tablespace: 

-- TOC entry 221 (class 1259 OID 43659)

-- Dependencies: 220 6

-- Name: namedplace_namedplace_id_seq; Type: SEQUENCE; Schema: public; Owner: -

    NO MAXVALUE

-- TOC entry 3385 (class 0 OID 0)

-- Dependencies: 221

-- Name: namedplace_namedplace_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

-- TOC entry 222 (class 1259 OID 43661)

-- Dependencies: 6

-- Name: namedplacecorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 

-- TOC entry 223 (class 1259 OID 43664)

-- Dependencies: 6 222

-- Name: namedplacecorrelation_namedplacecorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: -

    NO MAXVALUE

-- TOC entry 3386 (class 0 OID 0)

-- Dependencies: 223

-- Name: namedplacecorrelation_namedplacecorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

-- TOC entry 224 (class 1259 OID 43666)

-- Dependencies: 6

-- Name: note; Type: TABLE; Schema: public; Owner: -; Tablespace: 

-- TOC entry 225 (class 1259 OID 43672)

-- Dependencies: 224 6

-- Name: note_note_id_seq; Type: SEQUENCE; Schema: public; Owner: -

    NO MAXVALUE

-- TOC entry 3387 (class 0 OID 0)

-- Dependencies: 225

-- Name: note_note_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

-- TOC entry 226 (class 1259 OID 43674)

-- Dependencies: 6

-- Name: notelink; Type: TABLE; Schema: public; Owner: -; Tablespace: 

-- TOC entry 227 (class 1259 OID 43677)

-- Dependencies: 6 226

-- Name: notelink_notelink_id_seq; Type: SEQUENCE; Schema: public; Owner: -

    NO MAXVALUE

-- TOC entry 3388 (class 0 OID 0)

-- Dependencies: 227

-- Name: notelink_notelink_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -