Revision 19
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbank.sql | ||
|---|---|---|
| 3 | 3 |
-- PostgreSQL database dump |
| 4 | 4 |
-- |
| 5 | 5 |
|
| 6 |
-- Dumped from database version 9.1.1 |
|
| 7 |
-- Dumped by pg_dump version 9.1.0 |
|
| 8 |
-- Started on 2011-11-18 12:56:30 PST |
|
| 9 |
|
|
| 10 | 6 |
SET statement_timeout = 0; |
| 11 | 7 |
SET client_encoding = 'UTF8'; |
| 12 |
SET standard_conforming_strings = on;
|
|
| 8 |
SET standard_conforming_strings = off;
|
|
| 13 | 9 |
SET check_function_bodies = false; |
| 14 | 10 |
SET client_min_messages = warning; |
| 11 |
SET escape_string_warning = off; |
|
| 15 | 12 |
|
| 16 | 13 |
-- |
| 17 |
-- TOC entry 3354 (class 1262 OID 43433) |
|
| 18 |
-- Name: vegbank; Type: DATABASE; Schema: -; Owner: - |
|
| 14 |
-- Name: vegbank; Type: DATABASE; Schema: -; Owner: vegbank |
|
| 19 | 15 |
-- |
| 20 | 16 |
|
| 21 |
CREATE DATABASE vegbank WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'C' LC_CTYPE = 'C';
|
|
| 17 |
CREATE DATABASE vegbank WITH TEMPLATE = template0 ENCODING = 'UTF8'; |
|
| 22 | 18 |
|
| 23 | 19 |
|
| 20 |
ALTER DATABASE vegbank OWNER TO vegbank; |
|
| 21 |
|
|
| 24 | 22 |
\connect vegbank |
| 25 | 23 |
|
| 26 | 24 |
SET statement_timeout = 0; |
| 27 | 25 |
SET client_encoding = 'UTF8'; |
| 28 |
SET standard_conforming_strings = on;
|
|
| 26 |
SET standard_conforming_strings = off;
|
|
| 29 | 27 |
SET check_function_bodies = false; |
| 30 | 28 |
SET client_min_messages = warning; |
| 29 |
SET escape_string_warning = off; |
|
| 31 | 30 |
|
| 32 |
-- |
|
| 33 |
-- TOC entry 383 (class 3079 OID 11906) |
|
| 34 |
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: - |
|
| 35 |
-- |
|
| 36 |
|
|
| 37 |
CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog; |
|
| 38 |
|
|
| 39 |
|
|
| 40 |
-- |
|
| 41 |
-- TOC entry 3357 (class 0 OID 0) |
|
| 42 |
-- Dependencies: 383 |
|
| 43 |
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: - |
|
| 44 |
-- |
|
| 45 |
|
|
| 46 |
COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language'; |
|
| 47 |
|
|
| 48 |
|
|
| 49 | 31 |
SET search_path = public, pg_catalog; |
| 50 | 32 |
|
| 51 | 33 |
-- |
| 52 |
-- TOC entry 1125 (class 1255 OID 43434) |
|
| 53 |
-- Dependencies: 6 |
|
| 54 |
-- Name: concat(text); Type: AGGREGATE; Schema: public; Owner: - |
|
| 34 |
-- Name: concat(text); Type: AGGREGATE; Schema: public; Owner: vegbank |
|
| 55 | 35 |
-- |
| 56 | 36 |
|
| 57 | 37 |
CREATE AGGREGATE concat(text) ( |
| ... | ... | |
| 61 | 41 |
); |
| 62 | 42 |
|
| 63 | 43 |
|
| 44 |
ALTER AGGREGATE public.concat(text) OWNER TO vegbank; |
|
| 45 |
|
|
| 64 | 46 |
SET default_tablespace = ''; |
| 65 | 47 |
|
| 66 | 48 |
SET default_with_oids = true; |
| 67 | 49 |
|
| 68 | 50 |
-- |
| 69 |
-- TOC entry 161 (class 1259 OID 43435) |
|
| 70 |
-- Dependencies: 6 |
|
| 71 |
-- Name: address; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 51 |
-- Name: address; Type: TABLE; Schema: public; Owner: vegbank; Tablespace: |
|
| 72 | 52 |
-- |
| 73 | 53 |
|
| 74 | 54 |
CREATE TABLE address ( |
| ... | ... | |
| 87 | 67 |
); |
| 88 | 68 |
|
| 89 | 69 |
|
| 70 |
ALTER TABLE public.address OWNER TO vegbank; |
|
| 71 |
|
|
| 90 | 72 |
-- |
| 91 |
-- TOC entry 162 (class 1259 OID 43441) |
|
| 92 |
-- Dependencies: 161 6 |
|
| 93 |
-- Name: address_address_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 73 |
-- Name: address_address_id_seq; Type: SEQUENCE; Schema: public; Owner: vegbank |
|
| 94 | 74 |
-- |
| 95 | 75 |
|
| 96 | 76 |
CREATE SEQUENCE address_address_id_seq |
| 97 | 77 |
START WITH 1 |
| 98 | 78 |
INCREMENT BY 1 |
| 79 |
NO MAXVALUE |
|
| 99 | 80 |
NO MINVALUE |
| 100 |
NO MAXVALUE |
|
| 101 | 81 |
CACHE 1; |
| 102 | 82 |
|
| 103 | 83 |
|
| 84 |
ALTER TABLE public.address_address_id_seq OWNER TO vegbank; |
|
| 85 |
|
|
| 104 | 86 |
-- |
| 105 |
-- TOC entry 3358 (class 0 OID 0) |
|
| 106 |
-- Dependencies: 162 |
|
| 107 |
-- Name: address_address_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 87 |
-- Name: address_address_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vegbank |
|
| 108 | 88 |
-- |
| 109 | 89 |
|
| 110 | 90 |
ALTER SEQUENCE address_address_id_seq OWNED BY address.address_id; |
| 111 | 91 |
|
| 112 | 92 |
|
| 113 | 93 |
-- |
| 114 |
-- TOC entry 163 (class 1259 OID 43443) |
|
| 115 |
-- Dependencies: 6 |
|
| 116 |
-- Name: aux_role; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 94 |
-- Name: aux_role; Type: TABLE; Schema: public; Owner: vegbank; Tablespace: |
|
| 117 | 95 |
-- |
| 118 | 96 |
|
| 119 | 97 |
CREATE TABLE aux_role ( |
| ... | ... | |
| 128 | 106 |
); |
| 129 | 107 |
|
| 130 | 108 |
|
| 109 |
ALTER TABLE public.aux_role OWNER TO vegbank; |
|
| 110 |
|
|
| 131 | 111 |
-- |
| 132 |
-- TOC entry 164 (class 1259 OID 43446) |
|
| 133 |
-- Dependencies: 163 6 |
|
| 134 |
-- Name: aux_role_role_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 112 |
-- Name: aux_role_role_id_seq; Type: SEQUENCE; Schema: public; Owner: vegbank |
|
| 135 | 113 |
-- |
| 136 | 114 |
|
| 137 | 115 |
CREATE SEQUENCE aux_role_role_id_seq |
| 138 | 116 |
START WITH 1 |
| 139 | 117 |
INCREMENT BY 1 |
| 118 |
NO MAXVALUE |
|
| 140 | 119 |
NO MINVALUE |
| 141 |
NO MAXVALUE |
|
| 142 | 120 |
CACHE 1; |
| 143 | 121 |
|
| 144 | 122 |
|
| 123 |
ALTER TABLE public.aux_role_role_id_seq OWNER TO vegbank; |
|
| 124 |
|
|
| 145 | 125 |
-- |
| 146 |
-- TOC entry 3359 (class 0 OID 0) |
|
| 147 |
-- Dependencies: 164 |
|
| 148 |
-- Name: aux_role_role_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 126 |
-- Name: aux_role_role_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vegbank |
|
| 149 | 127 |
-- |
| 150 | 128 |
|
| 151 | 129 |
ALTER SEQUENCE aux_role_role_id_seq OWNED BY aux_role.role_id; |
| 152 | 130 |
|
| 153 | 131 |
|
| 154 | 132 |
-- |
| 155 |
-- TOC entry 165 (class 1259 OID 43448) |
|
| 156 |
-- Dependencies: 6 |
|
| 157 |
-- Name: classcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 133 |
-- Name: classcontributor; Type: TABLE; Schema: public; Owner: vegbank; Tablespace: |
|
| 158 | 134 |
-- |
| 159 | 135 |
|
| 160 | 136 |
CREATE TABLE classcontributor ( |
| ... | ... | |
| 166 | 142 |
); |
| 167 | 143 |
|
| 168 | 144 |
|
| 145 |
ALTER TABLE public.classcontributor OWNER TO vegbank; |
|
| 146 |
|
|
| 169 | 147 |
-- |
| 170 |
-- TOC entry 166 (class 1259 OID 43451) |
|
| 171 |
-- Dependencies: 165 6 |
|
| 172 |
-- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 148 |
-- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: vegbank |
|
| 173 | 149 |
-- |
| 174 | 150 |
|
| 175 | 151 |
CREATE SEQUENCE classcontributor_classcontributor_id_seq |
| 176 | 152 |
START WITH 1 |
| 177 | 153 |
INCREMENT BY 1 |
| 154 |
NO MAXVALUE |
|
| 178 | 155 |
NO MINVALUE |
| 179 |
NO MAXVALUE |
|
| 180 | 156 |
CACHE 1; |
| 181 | 157 |
|
| 182 | 158 |
|
| 159 |
ALTER TABLE public.classcontributor_classcontributor_id_seq OWNER TO vegbank; |
|
| 160 |
|
|
| 183 | 161 |
-- |
| 184 |
-- TOC entry 3360 (class 0 OID 0) |
|
| 185 |
-- Dependencies: 166 |
|
| 186 |
-- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 162 |
-- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vegbank |
|
| 187 | 163 |
-- |
| 188 | 164 |
|
| 189 | 165 |
ALTER SEQUENCE classcontributor_classcontributor_id_seq OWNED BY classcontributor.classcontributor_id; |
| 190 | 166 |
|
| 191 | 167 |
|
| 192 | 168 |
-- |
| 193 |
-- TOC entry 167 (class 1259 OID 43453) |
|
| 194 |
-- Dependencies: 6 |
|
| 195 |
-- Name: commclass; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 169 |
-- Name: commclass; Type: TABLE; Schema: public; Owner: vegbank; Tablespace: |
|
| 196 | 170 |
-- |
| 197 | 171 |
|
| 198 | 172 |
CREATE TABLE commclass ( |
| ... | ... | |
| 215 | 189 |
); |
| 216 | 190 |
|
| 217 | 191 |
|
| 192 |
ALTER TABLE public.commclass OWNER TO vegbank; |
|
| 193 |
|
|
| 218 | 194 |
-- |
| 219 |
-- TOC entry 168 (class 1259 OID 43459) |
|
| 220 |
-- Dependencies: 167 6 |
|
| 221 |
-- Name: commclass_commclass_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 195 |
-- Name: commclass_commclass_id_seq; Type: SEQUENCE; Schema: public; Owner: vegbank |
|
| 222 | 196 |
-- |
| 223 | 197 |
|
| 224 | 198 |
CREATE SEQUENCE commclass_commclass_id_seq |
| 225 | 199 |
START WITH 1 |
| 226 | 200 |
INCREMENT BY 1 |
| 201 |
NO MAXVALUE |
|
| 227 | 202 |
NO MINVALUE |
| 228 |
NO MAXVALUE |
|
| 229 | 203 |
CACHE 1; |
| 230 | 204 |
|
| 231 | 205 |
|
| 206 |
ALTER TABLE public.commclass_commclass_id_seq OWNER TO vegbank; |
|
| 207 |
|
|
| 232 | 208 |
-- |
| 233 |
-- TOC entry 3361 (class 0 OID 0) |
|
| 234 |
-- Dependencies: 168 |
|
| 235 |
-- Name: commclass_commclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 209 |
-- Name: commclass_commclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vegbank |
|
| 236 | 210 |
-- |
| 237 | 211 |
|
| 238 | 212 |
ALTER SEQUENCE commclass_commclass_id_seq OWNED BY commclass.commclass_id; |
| 239 | 213 |
|
| 240 | 214 |
|
| 241 | 215 |
-- |
| 242 |
-- TOC entry 169 (class 1259 OID 43461) |
|
| 243 |
-- Dependencies: 6 |
|
| 244 |
-- Name: commconcept; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 216 |
-- Name: commconcept; Type: TABLE; Schema: public; Owner: vegbank; Tablespace: |
|
| 245 | 217 |
-- |
| 246 | 218 |
|
| 247 | 219 |
CREATE TABLE commconcept ( |
| ... | ... | |
| 256 | 228 |
); |
| 257 | 229 |
|
| 258 | 230 |
|
| 231 |
ALTER TABLE public.commconcept OWNER TO vegbank; |
|
| 232 |
|
|
| 259 | 233 |
-- |
| 260 |
-- TOC entry 170 (class 1259 OID 43467) |
|
| 261 |
-- Dependencies: 169 6 |
|
| 262 |
-- Name: commconcept_commconcept_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 234 |
-- Name: commconcept_commconcept_id_seq; Type: SEQUENCE; Schema: public; Owner: vegbank |
|
| 263 | 235 |
-- |
| 264 | 236 |
|
| 265 | 237 |
CREATE SEQUENCE commconcept_commconcept_id_seq |
| 266 | 238 |
START WITH 1 |
| 267 | 239 |
INCREMENT BY 1 |
| 240 |
NO MAXVALUE |
|
| 268 | 241 |
NO MINVALUE |
| 269 |
NO MAXVALUE |
|
| 270 | 242 |
CACHE 1; |
| 271 | 243 |
|
| 272 | 244 |
|
| 245 |
ALTER TABLE public.commconcept_commconcept_id_seq OWNER TO vegbank; |
|
| 246 |
|
|
| 273 | 247 |
-- |
| 274 |
-- TOC entry 3362 (class 0 OID 0) |
|
| 275 |
-- Dependencies: 170 |
|
| 276 |
-- Name: commconcept_commconcept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 248 |
-- Name: commconcept_commconcept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vegbank |
|
| 277 | 249 |
-- |
| 278 | 250 |
|
| 279 | 251 |
ALTER SEQUENCE commconcept_commconcept_id_seq OWNED BY commconcept.commconcept_id; |
| 280 | 252 |
|
| 281 | 253 |
|
| 282 | 254 |
-- |
| 283 |
-- TOC entry 171 (class 1259 OID 43469) |
|
| 284 |
-- Dependencies: 6 |
|
| 285 |
-- Name: commcorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 255 |
-- Name: commcorrelation; Type: TABLE; Schema: public; Owner: vegbank; Tablespace: |
|
| 286 | 256 |
-- |
| 287 | 257 |
|
| 288 | 258 |
CREATE TABLE commcorrelation ( |
| ... | ... | |
| 295 | 265 |
); |
| 296 | 266 |
|
| 297 | 267 |
|
| 268 |
ALTER TABLE public.commcorrelation OWNER TO vegbank; |
|
| 269 |
|
|
| 298 | 270 |
-- |
| 299 |
-- TOC entry 172 (class 1259 OID 43472) |
|
| 300 |
-- Dependencies: 6 171 |
|
| 301 |
-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 271 |
-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: vegbank |
|
| 302 | 272 |
-- |
| 303 | 273 |
|
| 304 | 274 |
CREATE SEQUENCE commcorrelation_commcorrelation_id_seq |
| 305 | 275 |
START WITH 1 |
| 306 | 276 |
INCREMENT BY 1 |
| 277 |
NO MAXVALUE |
|
| 307 | 278 |
NO MINVALUE |
| 308 |
NO MAXVALUE |
|
| 309 | 279 |
CACHE 1; |
| 310 | 280 |
|
| 311 | 281 |
|
| 282 |
ALTER TABLE public.commcorrelation_commcorrelation_id_seq OWNER TO vegbank; |
|
| 283 |
|
|
| 312 | 284 |
-- |
| 313 |
-- TOC entry 3363 (class 0 OID 0) |
|
| 314 |
-- Dependencies: 172 |
|
| 315 |
-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 285 |
-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vegbank |
|
| 316 | 286 |
-- |
| 317 | 287 |
|
| 318 | 288 |
ALTER SEQUENCE commcorrelation_commcorrelation_id_seq OWNED BY commcorrelation.commcorrelation_id; |
| 319 | 289 |
|
| 320 | 290 |
|
| 321 | 291 |
-- |
| 322 |
-- TOC entry 173 (class 1259 OID 43474) |
|
| 323 |
-- Dependencies: 6 |
|
| 324 |
-- Name: comminterpretation; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 292 |
-- Name: comminterpretation; Type: TABLE; Schema: public; Owner: vegbank; Tablespace: |
|
| 325 | 293 |
-- |
| 326 | 294 |
|
| 327 | 295 |
CREATE TABLE comminterpretation ( |
| ... | ... | |
| 340 | 308 |
); |
| 341 | 309 |
|
| 342 | 310 |
|
| 311 |
ALTER TABLE public.comminterpretation OWNER TO vegbank; |
|
| 312 |
|
|
| 343 | 313 |
-- |
| 344 |
-- TOC entry 174 (class 1259 OID 43480) |
|
| 345 |
-- Dependencies: 6 173 |
|
| 346 |
-- Name: comminterpretation_comminterpretation_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 314 |
-- Name: comminterpretation_comminterpretation_id_seq; Type: SEQUENCE; Schema: public; Owner: vegbank |
|
| 347 | 315 |
-- |
| 348 | 316 |
|
| 349 | 317 |
CREATE SEQUENCE comminterpretation_comminterpretation_id_seq |
| 350 | 318 |
START WITH 1 |
| 351 | 319 |
INCREMENT BY 1 |
| 320 |
NO MAXVALUE |
|
| 352 | 321 |
NO MINVALUE |
| 353 |
NO MAXVALUE |
|
| 354 | 322 |
CACHE 1; |
| 355 | 323 |
|
| 356 | 324 |
|
| 325 |
ALTER TABLE public.comminterpretation_comminterpretation_id_seq OWNER TO vegbank; |
|
| 326 |
|
|
| 357 | 327 |
-- |
| 358 |
-- TOC entry 3364 (class 0 OID 0) |
|
| 359 |
-- Dependencies: 174 |
|
| 360 |
-- Name: comminterpretation_comminterpretation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 328 |
-- Name: comminterpretation_comminterpretation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vegbank |
|
| 361 | 329 |
-- |
| 362 | 330 |
|
| 363 | 331 |
ALTER SEQUENCE comminterpretation_comminterpretation_id_seq OWNED BY comminterpretation.comminterpretation_id; |
| 364 | 332 |
|
| 365 | 333 |
|
| 366 | 334 |
-- |
| 367 |
-- TOC entry 175 (class 1259 OID 43482) |
|
| 368 |
-- Dependencies: 6 |
|
| 369 |
-- Name: commlineage; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 335 |
-- Name: commlineage; Type: TABLE; Schema: public; Owner: vegbank; Tablespace: |
|
| 370 | 336 |
-- |
| 371 | 337 |
|
| 372 | 338 |
CREATE TABLE commlineage ( |
| ... | ... | |
| 376 | 342 |
); |
| 377 | 343 |
|
| 378 | 344 |
|
| 345 |
ALTER TABLE public.commlineage OWNER TO vegbank; |
|
| 346 |
|
|
| 379 | 347 |
-- |
| 380 |
-- TOC entry 176 (class 1259 OID 43485) |
|
| 381 |
-- Dependencies: 175 6 |
|
| 382 |
-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 348 |
-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE; Schema: public; Owner: vegbank |
|
| 383 | 349 |
-- |
| 384 | 350 |
|
| 385 | 351 |
CREATE SEQUENCE commlineage_commlineage_id_seq |
| 386 | 352 |
START WITH 1 |
| 387 | 353 |
INCREMENT BY 1 |
| 354 |
NO MAXVALUE |
|
| 388 | 355 |
NO MINVALUE |
| 389 |
NO MAXVALUE |
|
| 390 | 356 |
CACHE 1; |
| 391 | 357 |
|
| 392 | 358 |
|
| 359 |
ALTER TABLE public.commlineage_commlineage_id_seq OWNER TO vegbank; |
|
| 360 |
|
|
| 393 | 361 |
-- |
| 394 |
-- TOC entry 3365 (class 0 OID 0) |
|
| 395 |
-- Dependencies: 176 |
|
| 396 |
-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 362 |
-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vegbank |
|
| 397 | 363 |
-- |
| 398 | 364 |
|
| 399 | 365 |
ALTER SEQUENCE commlineage_commlineage_id_seq OWNED BY commlineage.commlineage_id; |
| 400 | 366 |
|
| 401 | 367 |
|
| 402 | 368 |
-- |
| 403 |
-- TOC entry 177 (class 1259 OID 43487) |
|
| 404 |
-- Dependencies: 2822 6 |
|
| 405 |
-- Name: commname; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 369 |
-- Name: commname; Type: TABLE; Schema: public; Owner: vegbank; Tablespace: |
|
| 406 | 370 |
-- |
| 407 | 371 |
|
| 408 | 372 |
CREATE TABLE commname ( |
| ... | ... | |
| 413 | 377 |
); |
| 414 | 378 |
|
| 415 | 379 |
|
| 380 |
ALTER TABLE public.commname OWNER TO vegbank; |
|
| 381 |
|
|
| 416 | 382 |
-- |
| 417 |
-- TOC entry 178 (class 1259 OID 43494) |
|
| 418 |
-- Dependencies: 6 177 |
|
| 419 |
-- Name: commname_commname_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 383 |
-- Name: commname_commname_id_seq; Type: SEQUENCE; Schema: public; Owner: vegbank |
|
| 420 | 384 |
-- |
| 421 | 385 |
|
| 422 | 386 |
CREATE SEQUENCE commname_commname_id_seq |
| 423 | 387 |
START WITH 1 |
| 424 | 388 |
INCREMENT BY 1 |
| 389 |
NO MAXVALUE |
|
| 425 | 390 |
NO MINVALUE |
| 426 |
NO MAXVALUE |
|
| 427 | 391 |
CACHE 1; |
| 428 | 392 |
|
| 429 | 393 |
|
| 394 |
ALTER TABLE public.commname_commname_id_seq OWNER TO vegbank; |
|
| 395 |
|
|
| 430 | 396 |
-- |
| 431 |
-- TOC entry 3366 (class 0 OID 0) |
|
| 432 |
-- Dependencies: 178 |
|
| 433 |
-- Name: commname_commname_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 397 |
-- Name: commname_commname_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vegbank |
|
| 434 | 398 |
-- |
| 435 | 399 |
|
| 436 | 400 |
ALTER SEQUENCE commname_commname_id_seq OWNED BY commname.commname_id; |
| 437 | 401 |
|
| 438 | 402 |
|
| 439 | 403 |
-- |
| 440 |
-- TOC entry 179 (class 1259 OID 43496) |
|
| 441 |
-- Dependencies: 6 |
|
| 442 |
-- Name: commstatus; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 404 |
-- Name: commstatus; Type: TABLE; Schema: public; Owner: vegbank; Tablespace: |
|
| 443 | 405 |
-- |
| 444 | 406 |
|
| 445 | 407 |
CREATE TABLE commstatus ( |
| ... | ... | |
| 457 | 419 |
); |
| 458 | 420 |
|
| 459 | 421 |
|
| 422 |
ALTER TABLE public.commstatus OWNER TO vegbank; |
|
| 423 |
|
|
| 460 | 424 |
-- |
| 461 |
-- TOC entry 180 (class 1259 OID 43502) |
|
| 462 |
-- Dependencies: 179 6 |
|
| 463 |
-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 425 |
-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE; Schema: public; Owner: vegbank |
|
| 464 | 426 |
-- |
| 465 | 427 |
|
| 466 | 428 |
CREATE SEQUENCE commstatus_commstatus_id_seq |
| 467 | 429 |
START WITH 1 |
| 468 | 430 |
INCREMENT BY 1 |
| 431 |
NO MAXVALUE |
|
| 469 | 432 |
NO MINVALUE |
| 470 |
NO MAXVALUE |
|
| 471 | 433 |
CACHE 1; |
| 472 | 434 |
|
| 473 | 435 |
|
| 436 |
ALTER TABLE public.commstatus_commstatus_id_seq OWNER TO vegbank; |
|
| 437 |
|
|
| 474 | 438 |
-- |
| 475 |
-- TOC entry 3367 (class 0 OID 0) |
|
| 476 |
-- Dependencies: 180 |
|
| 477 |
-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 439 |
-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vegbank |
|
| 478 | 440 |
-- |
| 479 | 441 |
|
| 480 | 442 |
ALTER SEQUENCE commstatus_commstatus_id_seq OWNED BY commstatus.commstatus_id; |
| 481 | 443 |
|
| 482 | 444 |
|
| 483 | 445 |
-- |
| 484 |
-- TOC entry 181 (class 1259 OID 43504) |
|
| 485 |
-- Dependencies: 6 |
|
| 486 |
-- Name: commusage; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 446 |
-- Name: commusage; Type: TABLE; Schema: public; Owner: vegbank; Tablespace: |
|
| 487 | 447 |
-- |
| 488 | 448 |
|
| 489 | 449 |
CREATE TABLE commusage ( |
| ... | ... | |
| 500 | 460 |
); |
| 501 | 461 |
|
| 502 | 462 |
|
| 463 |
ALTER TABLE public.commusage OWNER TO vegbank; |
|
| 464 |
|
|
| 503 | 465 |
-- |
| 504 |
-- TOC entry 182 (class 1259 OID 43510) |
|
| 505 |
-- Dependencies: 6 181 |
|
| 506 |
-- Name: commusage_commusage_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 466 |
-- Name: commusage_commusage_id_seq; Type: SEQUENCE; Schema: public; Owner: vegbank |
|
| 507 | 467 |
-- |
| 508 | 468 |
|
| 509 | 469 |
CREATE SEQUENCE commusage_commusage_id_seq |
| 510 | 470 |
START WITH 1 |
| 511 | 471 |
INCREMENT BY 1 |
| 472 |
NO MAXVALUE |
|
| 512 | 473 |
NO MINVALUE |
| 513 |
NO MAXVALUE |
|
| 514 | 474 |
CACHE 1; |
| 515 | 475 |
|
| 516 | 476 |
|
| 477 |
ALTER TABLE public.commusage_commusage_id_seq OWNER TO vegbank; |
|
| 478 |
|
|
| 517 | 479 |
-- |
| 518 |
-- TOC entry 3368 (class 0 OID 0) |
|
| 519 |
-- Dependencies: 182 |
|
| 520 |
-- Name: commusage_commusage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 480 |
-- Name: commusage_commusage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vegbank |
|
| 521 | 481 |
-- |
| 522 | 482 |
|
| 523 | 483 |
ALTER SEQUENCE commusage_commusage_id_seq OWNED BY commusage.commusage_id; |
| 524 | 484 |
|
| 525 | 485 |
|
| 526 | 486 |
-- |
| 527 |
-- TOC entry 183 (class 1259 OID 43512) |
|
| 528 |
-- Dependencies: 6 |
|
| 529 |
-- Name: coverindex; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 487 |
-- Name: coverindex; Type: TABLE; Schema: public; Owner: vegbank; Tablespace: |
|
| 530 | 488 |
-- |
| 531 | 489 |
|
| 532 | 490 |
CREATE TABLE coverindex ( |
| ... | ... | |
| 540 | 498 |
); |
| 541 | 499 |
|
| 542 | 500 |
|
| 501 |
ALTER TABLE public.coverindex OWNER TO vegbank; |
|
| 502 |
|
|
| 543 | 503 |
-- |
| 544 |
-- TOC entry 184 (class 1259 OID 43518) |
|
| 545 |
-- Dependencies: 183 6 |
|
| 546 |
-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 504 |
-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE; Schema: public; Owner: vegbank |
|
| 547 | 505 |
-- |
| 548 | 506 |
|
| 549 | 507 |
CREATE SEQUENCE coverindex_coverindex_id_seq |
| 550 | 508 |
START WITH 1 |
| 551 | 509 |
INCREMENT BY 1 |
| 510 |
NO MAXVALUE |
|
| 552 | 511 |
NO MINVALUE |
| 553 |
NO MAXVALUE |
|
| 554 | 512 |
CACHE 1; |
| 555 | 513 |
|
| 556 | 514 |
|
| 515 |
ALTER TABLE public.coverindex_coverindex_id_seq OWNER TO vegbank; |
|
| 516 |
|
|
| 557 | 517 |
-- |
| 558 |
-- TOC entry 3369 (class 0 OID 0) |
|
| 559 |
-- Dependencies: 184 |
|
| 560 |
-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 518 |
-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vegbank |
|
| 561 | 519 |
-- |
| 562 | 520 |
|
| 563 | 521 |
ALTER SEQUENCE coverindex_coverindex_id_seq OWNED BY coverindex.coverindex_id; |
| 564 | 522 |
|
| 565 | 523 |
|
| 566 | 524 |
-- |
| 567 |
-- TOC entry 185 (class 1259 OID 43520) |
|
| 568 |
-- Dependencies: 6 |
|
| 569 |
-- Name: covermethod; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 525 |
-- Name: covermethod; Type: TABLE; Schema: public; Owner: vegbank; Tablespace: |
|
| 570 | 526 |
-- |
| 571 | 527 |
|
| 572 | 528 |
CREATE TABLE covermethod ( |
| ... | ... | |
| 578 | 534 |
); |
| 579 | 535 |
|
| 580 | 536 |
|
| 537 |
ALTER TABLE public.covermethod OWNER TO vegbank; |
|
| 538 |
|
|
| 581 | 539 |
-- |
| 582 |
-- TOC entry 186 (class 1259 OID 43523) |
|
| 583 |
-- Dependencies: 6 185 |
|
| 584 |
-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 540 |
-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE; Schema: public; Owner: vegbank |
|
| 585 | 541 |
-- |
| 586 | 542 |
|
| 587 | 543 |
CREATE SEQUENCE covermethod_covermethod_id_seq |
| 588 | 544 |
START WITH 1 |
| 589 | 545 |
INCREMENT BY 1 |
| 546 |
NO MAXVALUE |
|
| 590 | 547 |
NO MINVALUE |
| 591 |
NO MAXVALUE |
|
| 592 | 548 |
CACHE 1; |
| 593 | 549 |
|
| 594 | 550 |
|
| 551 |
ALTER TABLE public.covermethod_covermethod_id_seq OWNER TO vegbank; |
|
| 552 |
|
|
| 595 | 553 |
-- |
| 596 |
-- TOC entry 3370 (class 0 OID 0) |
|
| 597 |
-- Dependencies: 186 |
|
| 598 |
-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 554 |
-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vegbank |
|
| 599 | 555 |
-- |
| 600 | 556 |
|
| 601 | 557 |
ALTER SEQUENCE covermethod_covermethod_id_seq OWNED BY covermethod.covermethod_id; |
| 602 | 558 |
|
| 603 | 559 |
|
| 604 | 560 |
-- |
| 605 |
-- TOC entry 187 (class 1259 OID 43525) |
|
| 606 |
-- Dependencies: 6 |
|
| 607 |
-- Name: dba_confidentialitystatus; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 561 |
-- Name: dba_confidentialitystatus; Type: TABLE; Schema: public; Owner: vegbank; Tablespace: |
|
| 608 | 562 |
-- |
| 609 | 563 |
|
| 610 | 564 |
CREATE TABLE dba_confidentialitystatus ( |
| ... | ... | |
| 614 | 568 |
); |
| 615 | 569 |
|
| 616 | 570 |
|
| 571 |
ALTER TABLE public.dba_confidentialitystatus OWNER TO vegbank; |
|
| 572 |
|
|
| 617 | 573 |
-- |
| 618 |
-- TOC entry 188 (class 1259 OID 43528) |
|
| 619 |
-- Dependencies: 6 |
|
| 620 |
-- Name: dba_cookie; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 574 |
-- Name: dba_cookie; Type: TABLE; Schema: public; Owner: vegbank; Tablespace: |
|
| 621 | 575 |
-- |
| 622 | 576 |
|
| 623 | 577 |
CREATE TABLE dba_cookie ( |
| ... | ... | |
| 634 | 588 |
); |
| 635 | 589 |
|
| 636 | 590 |
|
| 591 |
ALTER TABLE public.dba_cookie OWNER TO vegbank; |
|
| 592 |
|
|
| 637 | 593 |
-- |
| 638 |
-- TOC entry 189 (class 1259 OID 43534) |
|
| 639 |
-- Dependencies: 6 188 |
|
| 640 |
-- Name: dba_cookie_cookie_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 594 |
-- Name: dba_cookie_cookie_id_seq; Type: SEQUENCE; Schema: public; Owner: vegbank |
|
| 641 | 595 |
-- |
| 642 | 596 |
|
| 643 | 597 |
CREATE SEQUENCE dba_cookie_cookie_id_seq |
| 644 | 598 |
START WITH 1 |
| 645 | 599 |
INCREMENT BY 1 |
| 600 |
NO MAXVALUE |
|
| 646 | 601 |
NO MINVALUE |
| 647 |
NO MAXVALUE |
|
| 648 | 602 |
CACHE 1; |
| 649 | 603 |
|
| 650 | 604 |
|
| 605 |
ALTER TABLE public.dba_cookie_cookie_id_seq OWNER TO vegbank; |
|
| 606 |
|
|
| 651 | 607 |
-- |
| 652 |
-- TOC entry 3371 (class 0 OID 0) |
|
| 653 |
-- Dependencies: 189 |
|
| 654 |
-- Name: dba_cookie_cookie_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 608 |
-- Name: dba_cookie_cookie_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vegbank |
|
| 655 | 609 |
-- |
| 656 | 610 |
|
| 657 | 611 |
ALTER SEQUENCE dba_cookie_cookie_id_seq OWNED BY dba_cookie.cookie_id; |
| 658 | 612 |
|
| 659 | 613 |
|
| 660 | 614 |
-- |
| 661 |
-- TOC entry 190 (class 1259 OID 43536) |
|
| 662 |
-- Dependencies: 6 |
|
| 663 |
-- Name: dba_cookielabels; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 615 |
-- Name: dba_cookielabels; Type: TABLE; Schema: public; Owner: vegbank; Tablespace: |
|
| 664 | 616 |
-- |
| 665 | 617 |
|
| 666 | 618 |
CREATE TABLE dba_cookielabels ( |
| ... | ... | |
| 670 | 622 |
); |
| 671 | 623 |
|
| 672 | 624 |
|
| 625 |
ALTER TABLE public.dba_cookielabels OWNER TO vegbank; |
|
| 626 |
|
|
| 673 | 627 |
-- |
| 674 |
-- TOC entry 191 (class 1259 OID 43542) |
|
| 675 |
-- Dependencies: 6 190 |
|
| 676 |
-- Name: dba_cookielabels_cookielabel_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 628 |
-- Name: dba_cookielabels_cookielabel_id_seq; Type: SEQUENCE; Schema: public; Owner: vegbank |
|
| 677 | 629 |
-- |
| 678 | 630 |
|
| 679 | 631 |
CREATE SEQUENCE dba_cookielabels_cookielabel_id_seq |
| 680 | 632 |
START WITH 1 |
| 681 | 633 |
INCREMENT BY 1 |
| 634 |
NO MAXVALUE |
|
| 682 | 635 |
NO MINVALUE |
| 683 |
NO MAXVALUE |
|
| 684 | 636 |
CACHE 1; |
| 685 | 637 |
|
| 686 | 638 |
|
| 639 |
ALTER TABLE public.dba_cookielabels_cookielabel_id_seq OWNER TO vegbank; |
|
| 640 |
|
|
| 687 | 641 |
-- |
| 688 |
-- TOC entry 3372 (class 0 OID 0) |
|
| 689 |
-- Dependencies: 191 |
|
| 690 |
-- Name: dba_cookielabels_cookielabel_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 642 |
-- Name: dba_cookielabels_cookielabel_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vegbank |
|
| 691 | 643 |
-- |
| 692 | 644 |
|
| 693 | 645 |
ALTER SEQUENCE dba_cookielabels_cookielabel_id_seq OWNED BY dba_cookielabels.cookielabel_id; |
| ... | ... | |
| 696 | 648 |
SET default_with_oids = false; |
| 697 | 649 |
|
| 698 | 650 |
-- |
| 699 |
-- TOC entry 192 (class 1259 OID 43544) |
|
| 700 |
-- Dependencies: 6 |
|
| 701 |
-- Name: dba_datacache; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 651 |
-- Name: dba_datacache; Type: TABLE; Schema: public; Owner: vegbank; Tablespace: |
|
| 702 | 652 |
-- |
| 703 | 653 |
|
| 704 | 654 |
CREATE TABLE dba_datacache ( |
| ... | ... | |
| 719 | 669 |
); |
| 720 | 670 |
|
| 721 | 671 |
|
| 672 |
ALTER TABLE public.dba_datacache OWNER TO vegbank; |
|
| 673 |
|
|
| 722 | 674 |
-- |
| 723 |
-- TOC entry 193 (class 1259 OID 43550) |
|
| 724 |
-- Dependencies: 6 192 |
|
| 725 |
-- Name: dba_datacache_dba_datacache_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 675 |
-- Name: dba_datacache_dba_datacache_id_seq; Type: SEQUENCE; Schema: public; Owner: vegbank |
|
| 726 | 676 |
-- |
| 727 | 677 |
|
| 728 | 678 |
CREATE SEQUENCE dba_datacache_dba_datacache_id_seq |
| 729 | 679 |
START WITH 1 |
| 730 | 680 |
INCREMENT BY 1 |
| 681 |
NO MAXVALUE |
|
| 731 | 682 |
NO MINVALUE |
| 732 |
NO MAXVALUE |
|
| 733 | 683 |
CACHE 1; |
| 734 | 684 |
|
| 735 | 685 |
|
| 686 |
ALTER TABLE public.dba_datacache_dba_datacache_id_seq OWNER TO vegbank; |
|
| 687 |
|
|
| 736 | 688 |
-- |
| 737 |
-- TOC entry 3373 (class 0 OID 0) |
|
| 738 |
-- Dependencies: 193 |
|
| 739 |
-- Name: dba_datacache_dba_datacache_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 689 |
-- Name: dba_datacache_dba_datacache_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vegbank |
|
| 740 | 690 |
-- |
| 741 | 691 |
|
| 742 | 692 |
ALTER SEQUENCE dba_datacache_dba_datacache_id_seq OWNED BY dba_datacache.dba_datacache_id; |
| 743 | 693 |
|
| 744 | 694 |
|
| 745 | 695 |
-- |
| 746 |
-- TOC entry 194 (class 1259 OID 43552) |
|
| 747 |
-- Dependencies: 2831 6 |
|
| 748 |
-- Name: dba_datamodelversion; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 696 |
-- Name: dba_datamodelversion; Type: TABLE; Schema: public; Owner: vegbank; Tablespace: |
|
| 749 | 697 |
-- |
| 750 | 698 |
|
| 751 | 699 |
CREATE TABLE dba_datamodelversion ( |
| ... | ... | |
| 755 | 703 |
); |
| 756 | 704 |
|
| 757 | 705 |
|
| 706 |
ALTER TABLE public.dba_datamodelversion OWNER TO vegbank; |
|
| 707 |
|
|
| 758 | 708 |
-- |
| 759 |
-- TOC entry 195 (class 1259 OID 43556) |
|
| 760 |
-- Dependencies: 194 6 |
|
| 761 |
-- Name: dba_datamodelversion_dba_datamodelversion_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 709 |
-- Name: dba_datamodelversion_dba_datamodelversion_id_seq; Type: SEQUENCE; Schema: public; Owner: vegbank |
|
| 762 | 710 |
-- |
| 763 | 711 |
|
| 764 | 712 |
CREATE SEQUENCE dba_datamodelversion_dba_datamodelversion_id_seq |
| 765 | 713 |
START WITH 1 |
| 766 | 714 |
INCREMENT BY 1 |
| 715 |
NO MAXVALUE |
|
| 767 | 716 |
NO MINVALUE |
| 768 |
NO MAXVALUE |
|
| 769 | 717 |
CACHE 1; |
| 770 | 718 |
|
| 771 | 719 |
|
| 720 |
ALTER TABLE public.dba_datamodelversion_dba_datamodelversion_id_seq OWNER TO vegbank; |
|
| 721 |
|
|
| 772 | 722 |
-- |
| 773 |
-- TOC entry 3374 (class 0 OID 0) |
|
| 774 |
-- Dependencies: 195 |
|
| 775 |
-- Name: dba_datamodelversion_dba_datamodelversion_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 723 |
-- Name: dba_datamodelversion_dba_datamodelversion_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vegbank |
|
| 776 | 724 |
-- |
| 777 | 725 |
|
| 778 | 726 |
ALTER SEQUENCE dba_datamodelversion_dba_datamodelversion_id_seq OWNED BY dba_datamodelversion.dba_datamodelversion_id; |
| ... | ... | |
| 781 | 729 |
SET default_with_oids = true; |
| 782 | 730 |
|
| 783 | 731 |
-- |
| 784 |
-- TOC entry 196 (class 1259 OID 43558) |
|
| 785 |
-- Dependencies: 6 |
|
| 786 |
-- Name: dba_dbstatstime; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 732 |
-- Name: dba_dbstatstime; Type: TABLE; Schema: public; Owner: vegbank; Tablespace: |
|
| 787 | 733 |
-- |
| 788 | 734 |
|
| 789 | 735 |
CREATE TABLE dba_dbstatstime ( |
| ... | ... | |
| 798 | 744 |
); |
| 799 | 745 |
|
| 800 | 746 |
|
| 747 |
ALTER TABLE public.dba_dbstatstime OWNER TO vegbank; |
|
| 748 |
|
|
| 801 | 749 |
-- |
| 802 |
-- TOC entry 197 (class 1259 OID 43564) |
|
| 803 |
-- Dependencies: 196 6 |
|
| 804 |
-- Name: dba_dbstatstime_stat_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 750 |
-- Name: dba_dbstatstime_stat_id_seq; Type: SEQUENCE; Schema: public; Owner: vegbank |
|
| 805 | 751 |
-- |
| 806 | 752 |
|
| 807 | 753 |
CREATE SEQUENCE dba_dbstatstime_stat_id_seq |
| 808 | 754 |
START WITH 1 |
| 809 | 755 |
INCREMENT BY 1 |
| 756 |
NO MAXVALUE |
|
| 810 | 757 |
NO MINVALUE |
| 811 |
NO MAXVALUE |
|
| 812 | 758 |
CACHE 1; |
| 813 | 759 |
|
| 814 | 760 |
|
| 761 |
ALTER TABLE public.dba_dbstatstime_stat_id_seq OWNER TO vegbank; |
|
| 762 |
|
|
| 815 | 763 |
-- |
| 816 |
-- TOC entry 3375 (class 0 OID 0) |
|
| 817 |
-- Dependencies: 197 |
|
| 818 |
-- Name: dba_dbstatstime_stat_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 764 |
-- Name: dba_dbstatstime_stat_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vegbank |
|
| 819 | 765 |
-- |
| 820 | 766 |
|
| 821 | 767 |
ALTER SEQUENCE dba_dbstatstime_stat_id_seq OWNED BY dba_dbstatstime.stat_id; |
| ... | ... | |
| 824 | 770 |
SET default_with_oids = false; |
| 825 | 771 |
|
| 826 | 772 |
-- |
| 827 |
-- TOC entry 198 (class 1259 OID 43566) |
|
| 828 |
-- Dependencies: 6 |
|
| 829 |
-- Name: dba_fielddescription; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 773 |
-- Name: dba_fielddescription; Type: TABLE; Schema: public; Owner: vegbank; Tablespace: |
|
| 830 | 774 |
-- |
| 831 | 775 |
|
| 832 | 776 |
CREATE TABLE dba_fielddescription ( |
| ... | ... | |
| 846 | 790 |
); |
| 847 | 791 |
|
| 848 | 792 |
|
| 793 |
ALTER TABLE public.dba_fielddescription OWNER TO vegbank; |
|
| 794 |
|
|
| 849 | 795 |
-- |
| 850 |
-- TOC entry 199 (class 1259 OID 43572) |
|
| 851 |
-- Dependencies: 198 6 |
|
| 852 |
-- Name: dba_fielddescription_dba_fielddescription_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 796 |
-- Name: dba_fielddescription_dba_fielddescription_id_seq; Type: SEQUENCE; Schema: public; Owner: vegbank |
|
| 853 | 797 |
-- |
| 854 | 798 |
|
| 855 | 799 |
CREATE SEQUENCE dba_fielddescription_dba_fielddescription_id_seq |
| 856 | 800 |
START WITH 1 |
| 857 | 801 |
INCREMENT BY 1 |
| 802 |
NO MAXVALUE |
|
| 858 | 803 |
NO MINVALUE |
| 859 |
NO MAXVALUE |
|
| 860 | 804 |
CACHE 1; |
| 861 | 805 |
|
| 862 | 806 |
|
| 807 |
ALTER TABLE public.dba_fielddescription_dba_fielddescription_id_seq OWNER TO vegbank; |
|
| 808 |
|
|
| 863 | 809 |
-- |
| 864 |
-- TOC entry 3376 (class 0 OID 0) |
|
| 865 |
-- Dependencies: 199 |
|
| 866 |
-- Name: dba_fielddescription_dba_fielddescription_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 810 |
-- Name: dba_fielddescription_dba_fielddescription_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vegbank |
|
| 867 | 811 |
-- |
| 868 | 812 |
|
| 869 | 813 |
ALTER SEQUENCE dba_fielddescription_dba_fielddescription_id_seq OWNED BY dba_fielddescription.dba_fielddescription_id; |
| 870 | 814 |
|
| 871 | 815 |
|
| 872 | 816 |
-- |
| 873 |
-- TOC entry 200 (class 1259 OID 43574) |
|
| 874 |
-- Dependencies: 6 |
|
| 875 |
-- Name: dba_fieldlist; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 817 |
-- Name: dba_fieldlist; Type: TABLE; Schema: public; Owner: vegbank; Tablespace: |
|
| 876 | 818 |
-- |
| 877 | 819 |
|
| 878 | 820 |
CREATE TABLE dba_fieldlist ( |
| ... | ... | |
| 885 | 827 |
); |
| 886 | 828 |
|
| 887 | 829 |
|
| 830 |
ALTER TABLE public.dba_fieldlist OWNER TO vegbank; |
|
| 831 |
|
|
| 888 | 832 |
-- |
| 889 |
-- TOC entry 201 (class 1259 OID 43580) |
|
| 890 |
-- Dependencies: 6 200 |
|
| 891 |
-- Name: dba_fieldlist_dba_fieldlist_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 833 |
-- Name: dba_fieldlist_dba_fieldlist_id_seq; Type: SEQUENCE; Schema: public; Owner: vegbank |
|
| 892 | 834 |
-- |
| 893 | 835 |
|
| 894 | 836 |
CREATE SEQUENCE dba_fieldlist_dba_fieldlist_id_seq |
| 895 | 837 |
START WITH 1 |
| 896 | 838 |
INCREMENT BY 1 |
| 839 |
NO MAXVALUE |
|
| 897 | 840 |
NO MINVALUE |
| 898 |
NO MAXVALUE |
|
| 899 | 841 |
CACHE 1; |
| 900 | 842 |
|
| 901 | 843 |
|
| 844 |
ALTER TABLE public.dba_fieldlist_dba_fieldlist_id_seq OWNER TO vegbank; |
|
| 845 |
|
|
| 902 | 846 |
-- |
| 903 |
-- TOC entry 3377 (class 0 OID 0) |
|
| 904 |
-- Dependencies: 201 |
|
| 905 |
-- Name: dba_fieldlist_dba_fieldlist_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 847 |
-- Name: dba_fieldlist_dba_fieldlist_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vegbank |
|
| 906 | 848 |
-- |
| 907 | 849 |
|
| 908 | 850 |
ALTER SEQUENCE dba_fieldlist_dba_fieldlist_id_seq OWNED BY dba_fieldlist.dba_fieldlist_id; |
| 909 | 851 |
|
| 910 | 852 |
|
| 911 | 853 |
-- |
| 912 |
-- TOC entry 202 (class 1259 OID 43582) |
|
| 913 |
-- Dependencies: 6 |
|
| 914 |
-- Name: dba_onerow; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 854 |
-- Name: dba_onerow; Type: TABLE; Schema: public; Owner: vegbank; Tablespace: |
|
| 915 | 855 |
-- |
| 916 | 856 |
|
| 917 | 857 |
CREATE TABLE dba_onerow ( |
| ... | ... | |
| 919 | 859 |
); |
| 920 | 860 |
|
| 921 | 861 |
|
| 862 |
ALTER TABLE public.dba_onerow OWNER TO vegbank; |
|
| 863 |
|
|
| 922 | 864 |
-- |
| 923 |
-- TOC entry 203 (class 1259 OID 43585) |
|
| 924 |
-- Dependencies: 202 6 |
|
| 925 |
-- Name: dba_onerow_dba_onerow_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 865 |
-- Name: dba_onerow_dba_onerow_id_seq; Type: SEQUENCE; Schema: public; Owner: vegbank |
|
| 926 | 866 |
-- |
| 927 | 867 |
|
| 928 | 868 |
CREATE SEQUENCE dba_onerow_dba_onerow_id_seq |
| 929 | 869 |
START WITH 1 |
| 930 | 870 |
INCREMENT BY 1 |
| 871 |
NO MAXVALUE |
|
| 931 | 872 |
NO MINVALUE |
| 932 |
NO MAXVALUE |
|
| 933 | 873 |
CACHE 1; |
| 934 | 874 |
|
| 935 | 875 |
|
| 876 |
ALTER TABLE public.dba_onerow_dba_onerow_id_seq OWNER TO vegbank; |
|
| 877 |
|
|
| 936 | 878 |
-- |
| 937 |
-- TOC entry 3378 (class 0 OID 0) |
|
| 938 |
-- Dependencies: 203 |
|
| 939 |
-- Name: dba_onerow_dba_onerow_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 879 |
-- Name: dba_onerow_dba_onerow_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vegbank |
|
| 940 | 880 |
-- |
| 941 | 881 |
|
| 942 | 882 |
ALTER SEQUENCE dba_onerow_dba_onerow_id_seq OWNED BY dba_onerow.dba_onerow_id; |
| 943 | 883 |
|
| 944 | 884 |
|
| 945 | 885 |
-- |
| 946 |
-- TOC entry 204 (class 1259 OID 43587) |
|
| 947 |
-- Dependencies: 2837 6 |
|
| 948 |
-- Name: dba_preassignacccode; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 886 |
-- Name: dba_preassignacccode; Type: TABLE; Schema: public; Owner: vegbank; Tablespace: |
|
| 949 | 887 |
-- |
| 950 | 888 |
|
| 951 | 889 |
CREATE TABLE dba_preassignacccode ( |
| ... | ... | |
| 959 | 897 |
); |
| 960 | 898 |
|
| 961 | 899 |
|
| 900 |
ALTER TABLE public.dba_preassignacccode OWNER TO vegbank; |
|
| 901 |
|
|
| 962 | 902 |
-- |
| 963 |
-- TOC entry 205 (class 1259 OID 43591) |
|
| 964 |
-- Dependencies: 204 6 |
|
| 965 |
-- Name: dba_preassignacccode_dba_preassignacccode_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 903 |
-- Name: dba_preassignacccode_dba_preassignacccode_id_seq; Type: SEQUENCE; Schema: public; Owner: vegbank |
|
| 966 | 904 |
-- |
| 967 | 905 |
|
| 968 | 906 |
CREATE SEQUENCE dba_preassignacccode_dba_preassignacccode_id_seq |
| 969 | 907 |
START WITH 1 |
| 970 | 908 |
INCREMENT BY 1 |
| 909 |
NO MAXVALUE |
|
| 971 | 910 |
NO MINVALUE |
| 972 |
NO MAXVALUE |
|
| 973 | 911 |
CACHE 1; |
| 974 | 912 |
|
| 975 | 913 |
|
| 914 |
ALTER TABLE public.dba_preassignacccode_dba_preassignacccode_id_seq OWNER TO vegbank; |
|
| 915 |
|
|
| 976 | 916 |
-- |
| 977 |
-- TOC entry 3379 (class 0 OID 0) |
|
| 978 |
-- Dependencies: 205 |
|
| 979 |
-- Name: dba_preassignacccode_dba_preassignacccode_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 917 |
-- Name: dba_preassignacccode_dba_preassignacccode_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vegbank |
|
| 980 | 918 |
-- |
| 981 | 919 |
|
| 982 | 920 |
ALTER SEQUENCE dba_preassignacccode_dba_preassignacccode_id_seq OWNED BY dba_preassignacccode.dba_preassignacccode_id; |
| 983 | 921 |
|
| 984 | 922 |
|
| 985 | 923 |
-- |
| 986 |
-- TOC entry 206 (class 1259 OID 43593) |
|
| 987 |
-- Dependencies: 6 |
|
| 988 |
-- Name: dba_preassignacccode_dba_requestnumber_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 924 |
-- Name: dba_preassignacccode_dba_requestnumber_seq; Type: SEQUENCE; Schema: public; Owner: vegbank |
|
| 989 | 925 |
-- |
| 990 | 926 |
|
| 991 | 927 |
CREATE SEQUENCE dba_preassignacccode_dba_requestnumber_seq |
| 992 | 928 |
START WITH 1 |
| 993 | 929 |
INCREMENT BY 1 |
| 930 |
NO MAXVALUE |
|
| 994 | 931 |
NO MINVALUE |
| 995 |
NO MAXVALUE |
|
| 996 | 932 |
CACHE 1; |
| 997 | 933 |
|
| 998 | 934 |
|
| 935 |
ALTER TABLE public.dba_preassignacccode_dba_requestnumber_seq OWNER TO vegbank; |
|
| 936 |
|
|
| 999 | 937 |
-- |
| 1000 |
-- TOC entry 207 (class 1259 OID 43595) |
|
| 1001 |
-- Dependencies: 6 |
|
| 1002 |
-- Name: dba_tabledescription; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 938 |
-- Name: dba_tabledescription; Type: TABLE; Schema: public; Owner: vegbank; Tablespace: |
|
| 1003 | 939 |
-- |
| 1004 | 940 |
|
| 1005 | 941 |
CREATE TABLE dba_tabledescription ( |
| ... | ... | |
| 1012 | 948 |
); |
| 1013 | 949 |
|
| 1014 | 950 |
|
| 951 |
ALTER TABLE public.dba_tabledescription OWNER TO vegbank; |
|
| 952 |
|
|
| 1015 | 953 |
-- |
| 1016 |
-- TOC entry 208 (class 1259 OID 43601) |
|
| 1017 |
-- Dependencies: 6 207 |
|
| 1018 |
-- Name: dba_tabledescription_dba_tabledescription_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 954 |
-- Name: dba_tabledescription_dba_tabledescription_id_seq; Type: SEQUENCE; Schema: public; Owner: vegbank |
|
| 1019 | 955 |
-- |
| 1020 | 956 |
|
| 1021 | 957 |
CREATE SEQUENCE dba_tabledescription_dba_tabledescription_id_seq |
| 1022 | 958 |
START WITH 1 |
| 1023 | 959 |
INCREMENT BY 1 |
| 960 |
NO MAXVALUE |
|
| 1024 | 961 |
NO MINVALUE |
| 1025 |
NO MAXVALUE |
|
| 1026 | 962 |
CACHE 1; |
| 1027 | 963 |
|
| 1028 | 964 |
|
| 965 |
ALTER TABLE public.dba_tabledescription_dba_tabledescription_id_seq OWNER TO vegbank; |
|
| 966 |
|
|
| 1029 | 967 |
-- |
| 1030 |
-- TOC entry 3380 (class 0 OID 0) |
|
| 1031 |
-- Dependencies: 208 |
|
| 1032 |
-- Name: dba_tabledescription_dba_tabledescription_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 968 |
-- Name: dba_tabledescription_dba_tabledescription_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vegbank |
|
| 1033 | 969 |
-- |
| 1034 | 970 |
|
| 1035 | 971 |
ALTER SEQUENCE dba_tabledescription_dba_tabledescription_id_seq OWNED BY dba_tabledescription.dba_tabledescription_id; |
| 1036 | 972 |
|
| 1037 | 973 |
|
| 1038 | 974 |
-- |
| 1039 |
-- TOC entry 209 (class 1259 OID 43603) |
|
| 1040 |
-- Dependencies: 6 |
|
| 1041 |
-- Name: dba_xmlcache; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 975 |
-- Name: dba_xmlcache; Type: TABLE; Schema: public; Owner: vegbank; Tablespace: |
|
| 1042 | 976 |
-- |
| 1043 | 977 |
|
| 1044 | 978 |
CREATE TABLE dba_xmlcache ( |
| ... | ... | |
| 1047 | 981 |
); |
| 1048 | 982 |
|
| 1049 | 983 |
|
| 984 |
ALTER TABLE public.dba_xmlcache OWNER TO vegbank; |
|
| 985 |
|
|
| 1050 | 986 |
SET default_with_oids = true; |
| 1051 | 987 |
|
| 1052 | 988 |
-- |
| 1053 |
-- TOC entry 210 (class 1259 OID 43609) |
|
| 1054 |
-- Dependencies: 6 |
|
| 1055 |
-- Name: definedvalue; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 989 |
-- Name: definedvalue; Type: TABLE; Schema: public; Owner: vegbank; Tablespace: |
|
| 1056 | 990 |
-- |
| 1057 | 991 |
|
| 1058 | 992 |
CREATE TABLE definedvalue ( |
| ... | ... | |
| 1063 | 997 |
); |
| 1064 | 998 |
|
| 1065 | 999 |
|
| 1000 |
ALTER TABLE public.definedvalue OWNER TO vegbank; |
|
| 1001 |
|
|
| 1066 | 1002 |
-- |
| 1067 |
-- TOC entry 211 (class 1259 OID 43615) |
|
| 1068 |
-- Dependencies: 6 210 |
|
| 1069 |
-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 1003 |
-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE; Schema: public; Owner: vegbank |
|
| 1070 | 1004 |
-- |
| 1071 | 1005 |
|
| 1072 | 1006 |
CREATE SEQUENCE definedvalue_definedvalue_id_seq |
| 1073 | 1007 |
START WITH 1 |
| 1074 | 1008 |
INCREMENT BY 1 |
| 1009 |
NO MAXVALUE |
|
| 1075 | 1010 |
NO MINVALUE |
| 1076 |
NO MAXVALUE |
|
| 1077 | 1011 |
CACHE 1; |
| 1078 | 1012 |
|
| 1079 | 1013 |
|
| 1014 |
ALTER TABLE public.definedvalue_definedvalue_id_seq OWNER TO vegbank; |
|
| 1015 |
|
|
| 1080 | 1016 |
-- |
| 1081 |
-- TOC entry 3381 (class 0 OID 0) |
|
| 1082 |
-- Dependencies: 211 |
|
| 1083 |
-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 1017 |
-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vegbank |
|
| 1084 | 1018 |
-- |
| 1085 | 1019 |
|
| 1086 | 1020 |
ALTER SEQUENCE definedvalue_definedvalue_id_seq OWNED BY definedvalue.definedvalue_id; |
| 1087 | 1021 |
|
| 1088 | 1022 |
|
| 1089 | 1023 |
-- |
| 1090 |
-- TOC entry 212 (class 1259 OID 43617) |
|
| 1091 |
-- Dependencies: 6 |
|
| 1092 |
-- Name: disturbanceobs; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1024 |
-- Name: disturbanceobs; Type: TABLE; Schema: public; Owner: vegbank; Tablespace: |
|
| 1093 | 1025 |
-- |
| 1094 | 1026 |
|
| 1095 | 1027 |
CREATE TABLE disturbanceobs ( |
| ... | ... | |
| 1104 | 1036 |
); |
| 1105 | 1037 |
|
| 1106 | 1038 |
|
| 1039 |
ALTER TABLE public.disturbanceobs OWNER TO vegbank; |
|
| 1040 |
|
|
| 1107 | 1041 |
-- |
| 1108 |
-- TOC entry 213 (class 1259 OID 43623) |
|
| 1109 |
-- Dependencies: 212 6 |
|
| 1110 |
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 1042 |
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE; Schema: public; Owner: vegbank |
|
| 1111 | 1043 |
-- |
| 1112 | 1044 |
|
| 1113 | 1045 |
CREATE SEQUENCE disturbanceobs_disturbanceobs_id_seq |
| 1114 | 1046 |
START WITH 1 |
| 1115 | 1047 |
INCREMENT BY 1 |
| 1048 |
NO MAXVALUE |
|
| 1116 | 1049 |
NO MINVALUE |
| 1117 |
NO MAXVALUE |
|
| 1118 | 1050 |
CACHE 1; |
| 1119 | 1051 |
|
| 1120 | 1052 |
|
| 1053 |
ALTER TABLE public.disturbanceobs_disturbanceobs_id_seq OWNER TO vegbank; |
|
| 1054 |
|
|
| 1121 | 1055 |
-- |
| 1122 |
-- TOC entry 3382 (class 0 OID 0) |
|
| 1123 |
-- Dependencies: 213 |
|
| 1124 |
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 1056 |
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vegbank |
|
| 1125 | 1057 |
-- |
| 1126 | 1058 |
|
| 1127 | 1059 |
ALTER SEQUENCE disturbanceobs_disturbanceobs_id_seq OWNED BY disturbanceobs.disturbanceobs_id; |
| 1128 | 1060 |
|
| 1129 | 1061 |
|
| 1130 | 1062 |
-- |
| 1131 |
-- TOC entry 214 (class 1259 OID 43625) |
|
| 1132 |
-- Dependencies: 6 |
|
| 1133 |
-- Name: embargo; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1063 |
-- Name: embargo; Type: TABLE; Schema: public; Owner: vegbank; Tablespace: |
|
| 1134 | 1064 |
-- |
| 1135 | 1065 |
|
| 1136 | 1066 |
CREATE TABLE embargo ( |
| ... | ... | |
| 1143 | 1073 |
); |
| 1144 | 1074 |
|
| 1145 | 1075 |
|
| 1076 |
ALTER TABLE public.embargo OWNER TO vegbank; |
|
| 1077 |
|
|
| 1146 | 1078 |
-- |
| 1147 |
-- TOC entry 215 (class 1259 OID 43631) |
|
| 1148 |
-- Dependencies: 214 6 |
|
| 1149 |
-- Name: embargo_embargo_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 1079 |
-- Name: embargo_embargo_id_seq; Type: SEQUENCE; Schema: public; Owner: vegbank |
|
| 1150 | 1080 |
-- |
| 1151 | 1081 |
|
| 1152 | 1082 |
CREATE SEQUENCE embargo_embargo_id_seq |
| 1153 | 1083 |
START WITH 1 |
| 1154 | 1084 |
INCREMENT BY 1 |
| 1085 |
NO MAXVALUE |
|
| 1155 | 1086 |
NO MINVALUE |
| 1156 |
NO MAXVALUE |
|
| 1157 | 1087 |
CACHE 1; |
| 1158 | 1088 |
|
| 1159 | 1089 |
|
| 1090 |
ALTER TABLE public.embargo_embargo_id_seq OWNER TO vegbank; |
|
| 1091 |
|
|
| 1160 | 1092 |
-- |
| 1161 |
-- TOC entry 3383 (class 0 OID 0) |
|
| 1162 |
-- Dependencies: 215 |
|
| 1163 |
-- Name: embargo_embargo_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 1093 |
-- Name: embargo_embargo_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vegbank |
|
| 1164 | 1094 |
-- |
| 1165 | 1095 |
|
| 1166 | 1096 |
ALTER SEQUENCE embargo_embargo_id_seq OWNED BY embargo.embargo_id; |
| 1167 | 1097 |
|
| 1168 | 1098 |
|
| 1169 | 1099 |
-- |
| 1170 |
-- TOC entry 216 (class 1259 OID 43633) |
|
| 1171 |
-- Dependencies: 6 |
|
| 1172 |
-- Name: graphic; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1100 |
-- Name: graphic; Type: TABLE; Schema: public; Owner: vegbank; Tablespace: |
|
| 1173 | 1101 |
-- |
| 1174 | 1102 |
|
| 1175 | 1103 |
CREATE TABLE graphic ( |
| ... | ... | |
| 1185 | 1113 |
); |
| 1186 | 1114 |
|
| 1187 | 1115 |
|
| 1116 |
ALTER TABLE public.graphic OWNER TO vegbank; |
|
| 1117 |
|
|
| 1188 | 1118 |
-- |
| 1189 |
-- TOC entry 217 (class 1259 OID 43639) |
|
| 1190 |
-- Dependencies: 216 6 |
|
| 1191 |
-- Name: graphic_graphic_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 1119 |
-- Name: graphic_graphic_id_seq; Type: SEQUENCE; Schema: public; Owner: vegbank |
|
| 1192 | 1120 |
-- |
| 1193 | 1121 |
|
| 1194 | 1122 |
CREATE SEQUENCE graphic_graphic_id_seq |
| 1195 | 1123 |
START WITH 1 |
| 1196 | 1124 |
INCREMENT BY 1 |
| 1125 |
NO MAXVALUE |
|
| 1197 | 1126 |
NO MINVALUE |
| 1198 |
NO MAXVALUE |
|
| 1199 | 1127 |
CACHE 1; |
| 1200 | 1128 |
|
| 1201 | 1129 |
|
| 1130 |
ALTER TABLE public.graphic_graphic_id_seq OWNER TO vegbank; |
|
| 1131 |
|
|
| 1202 | 1132 |
-- |
| 1203 |
-- TOC entry 3384 (class 0 OID 0) |
|
| 1204 |
-- Dependencies: 217 |
|
| 1205 |
-- Name: graphic_graphic_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 1133 |
-- Name: graphic_graphic_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vegbank |
|
| 1206 | 1134 |
-- |
| 1207 | 1135 |
|
| 1208 | 1136 |
ALTER SEQUENCE graphic_graphic_id_seq OWNED BY graphic.graphic_id; |
| 1209 | 1137 |
|
| 1210 | 1138 |
|
| 1211 | 1139 |
-- |
| 1212 |
-- TOC entry 218 (class 1259 OID 43641) |
|
| 1213 |
-- Dependencies: 6 |
|
| 1214 |
-- Name: keywords; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1140 |
-- Name: keywords; Type: TABLE; Schema: public; Owner: vegbank; Tablespace: |
|
| 1215 | 1141 |
-- |
| 1216 | 1142 |
|
| 1217 | 1143 |
CREATE TABLE keywords ( |
| ... | ... | |
| 1221 | 1147 |
); |
| 1222 | 1148 |
|
| 1223 | 1149 |
|
| 1150 |
ALTER TABLE public.keywords OWNER TO vegbank; |
|
| 1151 |
|
|
| 1224 | 1152 |
-- |
| 1225 |
-- TOC entry 219 (class 1259 OID 43647) |
|
| 1226 |
-- Dependencies: 6 |
|
| 1227 |
-- Name: keywords_extra; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1153 |
-- Name: keywords_extra; Type: TABLE; Schema: public; Owner: vegbank; Tablespace: |
|
| 1228 | 1154 |
-- |
| 1229 | 1155 |
|
| 1230 | 1156 |
CREATE TABLE keywords_extra ( |
| ... | ... | |
| 1234 | 1160 |
); |
| 1235 | 1161 |
|
| 1236 | 1162 |
|
| 1163 |
ALTER TABLE public.keywords_extra OWNER TO vegbank; |
|
| 1164 |
|
|
| 1237 | 1165 |
-- |
| 1238 |
-- TOC entry 220 (class 1259 OID 43653) |
|
| 1239 |
-- Dependencies: 6 |
|
| 1240 |
-- Name: namedplace; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1166 |
-- Name: namedplace; Type: TABLE; Schema: public; Owner: vegbank; Tablespace: |
|
| 1241 | 1167 |
-- |
| 1242 | 1168 |
|
| 1243 | 1169 |
CREATE TABLE namedplace ( |
| ... | ... | |
| 1253 | 1179 |
); |
| 1254 | 1180 |
|
| 1255 | 1181 |
|
| 1182 |
ALTER TABLE public.namedplace OWNER TO vegbank; |
|
| 1183 |
|
|
| 1256 | 1184 |
-- |
| 1257 |
-- TOC entry 221 (class 1259 OID 43659) |
|
| 1258 |
-- Dependencies: 220 6 |
|
| 1259 |
-- Name: namedplace_namedplace_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 1185 |
-- Name: namedplace_namedplace_id_seq; Type: SEQUENCE; Schema: public; Owner: vegbank |
|
| 1260 | 1186 |
-- |
| 1261 | 1187 |
|
| 1262 | 1188 |
CREATE SEQUENCE namedplace_namedplace_id_seq |
| 1263 | 1189 |
START WITH 1 |
| 1264 | 1190 |
INCREMENT BY 1 |
| 1191 |
NO MAXVALUE |
|
| 1265 | 1192 |
NO MINVALUE |
| 1266 |
NO MAXVALUE |
|
| 1267 | 1193 |
CACHE 1; |
| 1268 | 1194 |
|
| 1269 | 1195 |
|
| 1196 |
ALTER TABLE public.namedplace_namedplace_id_seq OWNER TO vegbank; |
|
| 1197 |
|
|
| 1270 | 1198 |
-- |
| 1271 |
-- TOC entry 3385 (class 0 OID 0) |
|
| 1272 |
-- Dependencies: 221 |
|
| 1273 |
-- Name: namedplace_namedplace_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 1199 |
-- Name: namedplace_namedplace_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vegbank |
|
| 1274 | 1200 |
-- |
| 1275 | 1201 |
|
| 1276 | 1202 |
ALTER SEQUENCE namedplace_namedplace_id_seq OWNED BY namedplace.namedplace_id; |
| 1277 | 1203 |
|
| 1278 | 1204 |
|
| 1279 | 1205 |
-- |
| 1280 |
-- TOC entry 222 (class 1259 OID 43661) |
|
| 1281 |
-- Dependencies: 6 |
|
| 1282 |
-- Name: namedplacecorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1206 |
-- Name: namedplacecorrelation; Type: TABLE; Schema: public; Owner: vegbank; Tablespace: |
|
| 1283 | 1207 |
-- |
| 1284 | 1208 |
|
| 1285 | 1209 |
CREATE TABLE namedplacecorrelation ( |
| ... | ... | |
| 1290 | 1214 |
); |
| 1291 | 1215 |
|
| 1292 | 1216 |
|
| 1217 |
ALTER TABLE public.namedplacecorrelation OWNER TO vegbank; |
|
| 1218 |
|
|
| 1293 | 1219 |
-- |
| 1294 |
-- TOC entry 223 (class 1259 OID 43664) |
|
| 1295 |
-- Dependencies: 6 222 |
|
| 1296 |
-- Name: namedplacecorrelation_namedplacecorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 1220 |
-- Name: namedplacecorrelation_namedplacecorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: vegbank |
|
| 1297 | 1221 |
-- |
| 1298 | 1222 |
|
| 1299 | 1223 |
CREATE SEQUENCE namedplacecorrelation_namedplacecorrelation_id_seq |
| 1300 | 1224 |
START WITH 1 |
| 1301 | 1225 |
INCREMENT BY 1 |
| 1226 |
NO MAXVALUE |
|
| 1302 | 1227 |
NO MINVALUE |
| 1303 |
NO MAXVALUE |
|
| 1304 | 1228 |
CACHE 1; |
| 1305 | 1229 |
|
| 1306 | 1230 |
|
| 1231 |
ALTER TABLE public.namedplacecorrelation_namedplacecorrelation_id_seq OWNER TO vegbank; |
|
| 1232 |
|
|
| 1307 | 1233 |
-- |
| 1308 |
-- TOC entry 3386 (class 0 OID 0) |
|
| 1309 |
-- Dependencies: 223 |
|
| 1310 |
-- Name: namedplacecorrelation_namedplacecorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 1234 |
-- Name: namedplacecorrelation_namedplacecorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vegbank |
|
| 1311 | 1235 |
-- |
| 1312 | 1236 |
|
| 1313 | 1237 |
ALTER SEQUENCE namedplacecorrelation_namedplacecorrelation_id_seq OWNED BY namedplacecorrelation.namedplacecorrelation_id; |
| 1314 | 1238 |
|
| 1315 | 1239 |
|
| 1316 | 1240 |
-- |
| 1317 |
-- TOC entry 224 (class 1259 OID 43666) |
|
| 1318 |
-- Dependencies: 6 |
|
| 1319 |
-- Name: note; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1241 |
-- Name: note; Type: TABLE; Schema: public; Owner: vegbank; Tablespace: |
|
| 1320 | 1242 |
-- |
| 1321 | 1243 |
|
| 1322 | 1244 |
CREATE TABLE note ( |
| ... | ... | |
| 1331 | 1253 |
); |
| 1332 | 1254 |
|
| 1333 | 1255 |
|
| 1256 |
ALTER TABLE public.note OWNER TO vegbank; |
|
| 1257 |
|
|
| 1334 | 1258 |
-- |
| 1335 |
-- TOC entry 225 (class 1259 OID 43672) |
|
| 1336 |
-- Dependencies: 224 6 |
|
| 1337 |
-- Name: note_note_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 1259 |
-- Name: note_note_id_seq; Type: SEQUENCE; Schema: public; Owner: vegbank |
|
| 1338 | 1260 |
-- |
| 1339 | 1261 |
|
| 1340 | 1262 |
CREATE SEQUENCE note_note_id_seq |
| 1341 | 1263 |
START WITH 1 |
| 1342 | 1264 |
INCREMENT BY 1 |
| 1265 |
NO MAXVALUE |
|
| 1343 | 1266 |
NO MINVALUE |
| 1344 |
NO MAXVALUE |
|
| 1345 | 1267 |
CACHE 1; |
| 1346 | 1268 |
|
| 1347 | 1269 |
|
| 1270 |
ALTER TABLE public.note_note_id_seq OWNER TO vegbank; |
|
| 1271 |
|
|
| 1348 | 1272 |
-- |
| 1349 |
-- TOC entry 3387 (class 0 OID 0) |
|
| 1350 |
-- Dependencies: 225 |
|
| 1351 |
-- Name: note_note_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 1273 |
-- Name: note_note_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vegbank |
|
| 1352 | 1274 |
-- |
| 1353 | 1275 |
|
| 1354 | 1276 |
ALTER SEQUENCE note_note_id_seq OWNED BY note.note_id; |
| 1355 | 1277 |
|
| 1356 | 1278 |
|
| 1357 | 1279 |
-- |
| 1358 |
-- TOC entry 226 (class 1259 OID 43674) |
|
| 1359 |
-- Dependencies: 6 |
|
| 1360 |
-- Name: notelink; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1280 |
-- Name: notelink; Type: TABLE; Schema: public; Owner: vegbank; Tablespace: |
|
| 1361 | 1281 |
-- |
| 1362 | 1282 |
|
| 1363 | 1283 |
CREATE TABLE notelink ( |
| ... | ... | |
| 1368 | 1288 |
); |
| 1369 | 1289 |
|
| 1370 | 1290 |
|
| 1291 |
ALTER TABLE public.notelink OWNER TO vegbank; |
|
| 1292 |
|
|
| 1371 | 1293 |
-- |
| 1372 |
-- TOC entry 227 (class 1259 OID 43677) |
|
| 1373 |
-- Dependencies: 6 226 |
|
| 1374 |
-- Name: notelink_notelink_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
| 1294 |
-- Name: notelink_notelink_id_seq; Type: SEQUENCE; Schema: public; Owner: vegbank |
|
| 1375 | 1295 |
-- |
| 1376 | 1296 |
|
| 1377 | 1297 |
CREATE SEQUENCE notelink_notelink_id_seq |
| 1378 | 1298 |
START WITH 1 |
| 1379 | 1299 |
INCREMENT BY 1 |
| 1300 |
NO MAXVALUE |
|
| 1380 | 1301 |
NO MINVALUE |
| 1381 |
NO MAXVALUE |
|
| 1382 | 1302 |
CACHE 1; |
| 1383 | 1303 |
|
| 1384 | 1304 |
|
| 1305 |
ALTER TABLE public.notelink_notelink_id_seq OWNER TO vegbank; |
|
| 1306 |
|
|
| 1385 | 1307 |
-- |
| 1386 |
-- TOC entry 3388 (class 0 OID 0) |
|
| 1387 |
-- Dependencies: 227 |
|
| 1388 |
-- Name: notelink_notelink_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
| 1308 |
-- Name: notelink_notelink_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vegbank |
|
| 1389 | 1309 |
-- |
| 1390 | 1310 |
|
| 1391 | 1311 |
ALTER SEQUENCE notelink_notelink_id_seq OWNED BY notelink.notelink_id; |
| 1392 | 1312 |
|
| 1393 | 1313 |
|
| 1394 | 1314 |
-- |
| 1395 |
-- TOC entry 228 (class 1259 OID 43679) |
|
| 1396 |
-- Dependencies: 2848 6 |
|
| 1397 |
-- Name: observation; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1315 |
-- Name: observation; Type: TABLE; Schema: public; Owner: vegbank; Tablespace: |
|
| 1398 | 1316 |
-- |
| 1399 | 1317 |
|
| 1400 | 1318 |
CREATE TABLE observation ( |
| ... | ... | |
| 1499 | 1417 |
); |
| 1500 | 1418 |
|
| 1501 | 1419 |
|
| 1420 |
ALTER TABLE public.observation OWNER TO vegbank; |
|
Also available in: Unified diff
Changed xml2db and vegbank db to be owned by new user vegbank