Revision 17
Added by Aaron Marcuse-Kubitza about 13 years ago
scripts/xml2db/vegbank.sql | ||
---|---|---|
1 |
DROP DATABASE IF EXISTS vegbank; |
|
1 | 2 |
-- |
2 | 3 |
-- PostgreSQL database dump |
3 | 4 |
-- |
4 | 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 |
|
|
5 | 10 |
SET statement_timeout = 0; |
6 | 11 |
SET client_encoding = 'UTF8'; |
7 |
SET standard_conforming_strings = off;
|
|
12 |
SET standard_conforming_strings = on;
|
|
8 | 13 |
SET check_function_bodies = false; |
9 | 14 |
SET client_min_messages = warning; |
10 |
SET escape_string_warning = off; |
|
11 | 15 |
|
16 |
-- |
|
17 |
-- TOC entry 3354 (class 1262 OID 43433) |
|
18 |
-- Name: vegbank; Type: DATABASE; Schema: -; Owner: - |
|
19 |
-- |
|
20 |
|
|
21 |
CREATE DATABASE vegbank WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'C' LC_CTYPE = 'C'; |
|
22 |
|
|
23 |
|
|
24 |
\connect vegbank |
|
25 |
|
|
26 |
SET statement_timeout = 0; |
|
27 |
SET client_encoding = 'UTF8'; |
|
28 |
SET standard_conforming_strings = on; |
|
29 |
SET check_function_bodies = false; |
|
30 |
SET client_min_messages = warning; |
|
31 |
|
|
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 |
|
|
12 | 49 |
SET search_path = public, pg_catalog; |
13 | 50 |
|
14 | 51 |
-- |
52 |
-- TOC entry 1125 (class 1255 OID 43434) |
|
53 |
-- Dependencies: 6 |
|
15 | 54 |
-- Name: concat(text); Type: AGGREGATE; Schema: public; Owner: - |
16 | 55 |
-- |
17 | 56 |
|
... | ... | |
27 | 66 |
SET default_with_oids = true; |
28 | 67 |
|
29 | 68 |
-- |
69 |
-- TOC entry 161 (class 1259 OID 43435) |
|
70 |
-- Dependencies: 6 |
|
30 | 71 |
-- Name: address; Type: TABLE; Schema: public; Owner: -; Tablespace: |
31 | 72 |
-- |
32 | 73 |
|
... | ... | |
47 | 88 |
|
48 | 89 |
|
49 | 90 |
-- |
91 |
-- TOC entry 162 (class 1259 OID 43441) |
|
92 |
-- Dependencies: 161 6 |
|
50 | 93 |
-- Name: address_address_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
51 | 94 |
-- |
52 | 95 |
|
53 | 96 |
CREATE SEQUENCE address_address_id_seq |
54 | 97 |
START WITH 1 |
55 | 98 |
INCREMENT BY 1 |
99 |
NO MINVALUE |
|
56 | 100 |
NO MAXVALUE |
57 |
NO MINVALUE |
|
58 | 101 |
CACHE 1; |
59 | 102 |
|
60 | 103 |
|
61 | 104 |
-- |
105 |
-- TOC entry 3358 (class 0 OID 0) |
|
106 |
-- Dependencies: 162 |
|
62 | 107 |
-- Name: address_address_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
63 | 108 |
-- |
64 | 109 |
|
... | ... | |
66 | 111 |
|
67 | 112 |
|
68 | 113 |
-- |
114 |
-- TOC entry 163 (class 1259 OID 43443) |
|
115 |
-- Dependencies: 6 |
|
69 | 116 |
-- Name: aux_role; Type: TABLE; Schema: public; Owner: -; Tablespace: |
70 | 117 |
-- |
71 | 118 |
|
... | ... | |
82 | 129 |
|
83 | 130 |
|
84 | 131 |
-- |
132 |
-- TOC entry 164 (class 1259 OID 43446) |
|
133 |
-- Dependencies: 163 6 |
|
85 | 134 |
-- Name: aux_role_role_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
86 | 135 |
-- |
87 | 136 |
|
88 | 137 |
CREATE SEQUENCE aux_role_role_id_seq |
89 | 138 |
START WITH 1 |
90 | 139 |
INCREMENT BY 1 |
140 |
NO MINVALUE |
|
91 | 141 |
NO MAXVALUE |
92 |
NO MINVALUE |
|
93 | 142 |
CACHE 1; |
94 | 143 |
|
95 | 144 |
|
96 | 145 |
-- |
146 |
-- TOC entry 3359 (class 0 OID 0) |
|
147 |
-- Dependencies: 164 |
|
97 | 148 |
-- Name: aux_role_role_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
98 | 149 |
-- |
99 | 150 |
|
... | ... | |
101 | 152 |
|
102 | 153 |
|
103 | 154 |
-- |
155 |
-- TOC entry 165 (class 1259 OID 43448) |
|
156 |
-- Dependencies: 6 |
|
104 | 157 |
-- Name: classcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: |
105 | 158 |
-- |
106 | 159 |
|
... | ... | |
114 | 167 |
|
115 | 168 |
|
116 | 169 |
-- |
170 |
-- TOC entry 166 (class 1259 OID 43451) |
|
171 |
-- Dependencies: 165 6 |
|
117 | 172 |
-- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
118 | 173 |
-- |
119 | 174 |
|
120 | 175 |
CREATE SEQUENCE classcontributor_classcontributor_id_seq |
121 | 176 |
START WITH 1 |
122 | 177 |
INCREMENT BY 1 |
178 |
NO MINVALUE |
|
123 | 179 |
NO MAXVALUE |
124 |
NO MINVALUE |
|
125 | 180 |
CACHE 1; |
126 | 181 |
|
127 | 182 |
|
128 | 183 |
-- |
184 |
-- TOC entry 3360 (class 0 OID 0) |
|
185 |
-- Dependencies: 166 |
|
129 | 186 |
-- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
130 | 187 |
-- |
131 | 188 |
|
... | ... | |
133 | 190 |
|
134 | 191 |
|
135 | 192 |
-- |
193 |
-- TOC entry 167 (class 1259 OID 43453) |
|
194 |
-- Dependencies: 6 |
|
136 | 195 |
-- Name: commclass; Type: TABLE; Schema: public; Owner: -; Tablespace: |
137 | 196 |
-- |
138 | 197 |
|
... | ... | |
157 | 216 |
|
158 | 217 |
|
159 | 218 |
-- |
219 |
-- TOC entry 168 (class 1259 OID 43459) |
|
220 |
-- Dependencies: 167 6 |
|
160 | 221 |
-- Name: commclass_commclass_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
161 | 222 |
-- |
162 | 223 |
|
163 | 224 |
CREATE SEQUENCE commclass_commclass_id_seq |
164 | 225 |
START WITH 1 |
165 | 226 |
INCREMENT BY 1 |
227 |
NO MINVALUE |
|
166 | 228 |
NO MAXVALUE |
167 |
NO MINVALUE |
|
168 | 229 |
CACHE 1; |
169 | 230 |
|
170 | 231 |
|
171 | 232 |
-- |
233 |
-- TOC entry 3361 (class 0 OID 0) |
|
234 |
-- Dependencies: 168 |
|
172 | 235 |
-- Name: commclass_commclass_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
173 | 236 |
-- |
174 | 237 |
|
... | ... | |
176 | 239 |
|
177 | 240 |
|
178 | 241 |
-- |
242 |
-- TOC entry 169 (class 1259 OID 43461) |
|
243 |
-- Dependencies: 6 |
|
179 | 244 |
-- Name: commconcept; Type: TABLE; Schema: public; Owner: -; Tablespace: |
180 | 245 |
-- |
181 | 246 |
|
... | ... | |
192 | 257 |
|
193 | 258 |
|
194 | 259 |
-- |
260 |
-- TOC entry 170 (class 1259 OID 43467) |
|
261 |
-- Dependencies: 169 6 |
|
195 | 262 |
-- Name: commconcept_commconcept_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
196 | 263 |
-- |
197 | 264 |
|
198 | 265 |
CREATE SEQUENCE commconcept_commconcept_id_seq |
199 | 266 |
START WITH 1 |
200 | 267 |
INCREMENT BY 1 |
268 |
NO MINVALUE |
|
201 | 269 |
NO MAXVALUE |
202 |
NO MINVALUE |
|
203 | 270 |
CACHE 1; |
204 | 271 |
|
205 | 272 |
|
206 | 273 |
-- |
274 |
-- TOC entry 3362 (class 0 OID 0) |
|
275 |
-- Dependencies: 170 |
|
207 | 276 |
-- Name: commconcept_commconcept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
208 | 277 |
-- |
209 | 278 |
|
... | ... | |
211 | 280 |
|
212 | 281 |
|
213 | 282 |
-- |
283 |
-- TOC entry 171 (class 1259 OID 43469) |
|
284 |
-- Dependencies: 6 |
|
214 | 285 |
-- Name: commcorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: |
215 | 286 |
-- |
216 | 287 |
|
... | ... | |
225 | 296 |
|
226 | 297 |
|
227 | 298 |
-- |
299 |
-- TOC entry 172 (class 1259 OID 43472) |
|
300 |
-- Dependencies: 6 171 |
|
228 | 301 |
-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
229 | 302 |
-- |
230 | 303 |
|
231 | 304 |
CREATE SEQUENCE commcorrelation_commcorrelation_id_seq |
232 | 305 |
START WITH 1 |
233 | 306 |
INCREMENT BY 1 |
307 |
NO MINVALUE |
|
234 | 308 |
NO MAXVALUE |
235 |
NO MINVALUE |
|
236 | 309 |
CACHE 1; |
237 | 310 |
|
238 | 311 |
|
239 | 312 |
-- |
313 |
-- TOC entry 3363 (class 0 OID 0) |
|
314 |
-- Dependencies: 172 |
|
240 | 315 |
-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
241 | 316 |
-- |
242 | 317 |
|
... | ... | |
244 | 319 |
|
245 | 320 |
|
246 | 321 |
-- |
322 |
-- TOC entry 173 (class 1259 OID 43474) |
|
323 |
-- Dependencies: 6 |
|
247 | 324 |
-- Name: comminterpretation; Type: TABLE; Schema: public; Owner: -; Tablespace: |
248 | 325 |
-- |
249 | 326 |
|
... | ... | |
264 | 341 |
|
265 | 342 |
|
266 | 343 |
-- |
344 |
-- TOC entry 174 (class 1259 OID 43480) |
|
345 |
-- Dependencies: 6 173 |
|
267 | 346 |
-- Name: comminterpretation_comminterpretation_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
268 | 347 |
-- |
269 | 348 |
|
270 | 349 |
CREATE SEQUENCE comminterpretation_comminterpretation_id_seq |
271 | 350 |
START WITH 1 |
272 | 351 |
INCREMENT BY 1 |
352 |
NO MINVALUE |
|
273 | 353 |
NO MAXVALUE |
274 |
NO MINVALUE |
|
275 | 354 |
CACHE 1; |
276 | 355 |
|
277 | 356 |
|
278 | 357 |
-- |
358 |
-- TOC entry 3364 (class 0 OID 0) |
|
359 |
-- Dependencies: 174 |
|
279 | 360 |
-- Name: comminterpretation_comminterpretation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
280 | 361 |
-- |
281 | 362 |
|
... | ... | |
283 | 364 |
|
284 | 365 |
|
285 | 366 |
-- |
367 |
-- TOC entry 175 (class 1259 OID 43482) |
|
368 |
-- Dependencies: 6 |
|
286 | 369 |
-- Name: commlineage; Type: TABLE; Schema: public; Owner: -; Tablespace: |
287 | 370 |
-- |
288 | 371 |
|
... | ... | |
294 | 377 |
|
295 | 378 |
|
296 | 379 |
-- |
380 |
-- TOC entry 176 (class 1259 OID 43485) |
|
381 |
-- Dependencies: 175 6 |
|
297 | 382 |
-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
298 | 383 |
-- |
299 | 384 |
|
300 | 385 |
CREATE SEQUENCE commlineage_commlineage_id_seq |
301 | 386 |
START WITH 1 |
302 | 387 |
INCREMENT BY 1 |
388 |
NO MINVALUE |
|
303 | 389 |
NO MAXVALUE |
304 |
NO MINVALUE |
|
305 | 390 |
CACHE 1; |
306 | 391 |
|
307 | 392 |
|
308 | 393 |
-- |
394 |
-- TOC entry 3365 (class 0 OID 0) |
|
395 |
-- Dependencies: 176 |
|
309 | 396 |
-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
310 | 397 |
-- |
311 | 398 |
|
... | ... | |
313 | 400 |
|
314 | 401 |
|
315 | 402 |
-- |
403 |
-- TOC entry 177 (class 1259 OID 43487) |
|
404 |
-- Dependencies: 2822 6 |
|
316 | 405 |
-- Name: commname; Type: TABLE; Schema: public; Owner: -; Tablespace: |
317 | 406 |
-- |
318 | 407 |
|
... | ... | |
325 | 414 |
|
326 | 415 |
|
327 | 416 |
-- |
417 |
-- TOC entry 178 (class 1259 OID 43494) |
|
418 |
-- Dependencies: 6 177 |
|
328 | 419 |
-- Name: commname_commname_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
329 | 420 |
-- |
330 | 421 |
|
331 | 422 |
CREATE SEQUENCE commname_commname_id_seq |
332 | 423 |
START WITH 1 |
333 | 424 |
INCREMENT BY 1 |
425 |
NO MINVALUE |
|
334 | 426 |
NO MAXVALUE |
335 |
NO MINVALUE |
|
336 | 427 |
CACHE 1; |
337 | 428 |
|
338 | 429 |
|
339 | 430 |
-- |
431 |
-- TOC entry 3366 (class 0 OID 0) |
|
432 |
-- Dependencies: 178 |
|
340 | 433 |
-- Name: commname_commname_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
341 | 434 |
-- |
342 | 435 |
|
... | ... | |
344 | 437 |
|
345 | 438 |
|
346 | 439 |
-- |
440 |
-- TOC entry 179 (class 1259 OID 43496) |
|
441 |
-- Dependencies: 6 |
|
347 | 442 |
-- Name: commstatus; Type: TABLE; Schema: public; Owner: -; Tablespace: |
348 | 443 |
-- |
349 | 444 |
|
... | ... | |
363 | 458 |
|
364 | 459 |
|
365 | 460 |
-- |
461 |
-- TOC entry 180 (class 1259 OID 43502) |
|
462 |
-- Dependencies: 179 6 |
|
366 | 463 |
-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
367 | 464 |
-- |
368 | 465 |
|
369 | 466 |
CREATE SEQUENCE commstatus_commstatus_id_seq |
370 | 467 |
START WITH 1 |
371 | 468 |
INCREMENT BY 1 |
469 |
NO MINVALUE |
|
372 | 470 |
NO MAXVALUE |
373 |
NO MINVALUE |
|
374 | 471 |
CACHE 1; |
375 | 472 |
|
376 | 473 |
|
377 | 474 |
-- |
475 |
-- TOC entry 3367 (class 0 OID 0) |
|
476 |
-- Dependencies: 180 |
|
378 | 477 |
-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
379 | 478 |
-- |
380 | 479 |
|
... | ... | |
382 | 481 |
|
383 | 482 |
|
384 | 483 |
-- |
484 |
-- TOC entry 181 (class 1259 OID 43504) |
|
485 |
-- Dependencies: 6 |
|
385 | 486 |
-- Name: commusage; Type: TABLE; Schema: public; Owner: -; Tablespace: |
386 | 487 |
-- |
387 | 488 |
|
... | ... | |
400 | 501 |
|
401 | 502 |
|
402 | 503 |
-- |
504 |
-- TOC entry 182 (class 1259 OID 43510) |
|
505 |
-- Dependencies: 6 181 |
|
403 | 506 |
-- Name: commusage_commusage_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
404 | 507 |
-- |
405 | 508 |
|
406 | 509 |
CREATE SEQUENCE commusage_commusage_id_seq |
407 | 510 |
START WITH 1 |
408 | 511 |
INCREMENT BY 1 |
512 |
NO MINVALUE |
|
409 | 513 |
NO MAXVALUE |
410 |
NO MINVALUE |
|
411 | 514 |
CACHE 1; |
412 | 515 |
|
413 | 516 |
|
414 | 517 |
-- |
518 |
-- TOC entry 3368 (class 0 OID 0) |
|
519 |
-- Dependencies: 182 |
|
415 | 520 |
-- Name: commusage_commusage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
416 | 521 |
-- |
417 | 522 |
|
... | ... | |
419 | 524 |
|
420 | 525 |
|
421 | 526 |
-- |
527 |
-- TOC entry 183 (class 1259 OID 43512) |
|
528 |
-- Dependencies: 6 |
|
422 | 529 |
-- Name: coverindex; Type: TABLE; Schema: public; Owner: -; Tablespace: |
423 | 530 |
-- |
424 | 531 |
|
... | ... | |
434 | 541 |
|
435 | 542 |
|
436 | 543 |
-- |
544 |
-- TOC entry 184 (class 1259 OID 43518) |
|
545 |
-- Dependencies: 183 6 |
|
437 | 546 |
-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
438 | 547 |
-- |
439 | 548 |
|
440 | 549 |
CREATE SEQUENCE coverindex_coverindex_id_seq |
441 | 550 |
START WITH 1 |
442 | 551 |
INCREMENT BY 1 |
552 |
NO MINVALUE |
|
443 | 553 |
NO MAXVALUE |
444 |
NO MINVALUE |
|
445 | 554 |
CACHE 1; |
446 | 555 |
|
447 | 556 |
|
448 | 557 |
-- |
558 |
-- TOC entry 3369 (class 0 OID 0) |
|
559 |
-- Dependencies: 184 |
|
449 | 560 |
-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
450 | 561 |
-- |
451 | 562 |
|
... | ... | |
453 | 564 |
|
454 | 565 |
|
455 | 566 |
-- |
567 |
-- TOC entry 185 (class 1259 OID 43520) |
|
568 |
-- Dependencies: 6 |
|
456 | 569 |
-- Name: covermethod; Type: TABLE; Schema: public; Owner: -; Tablespace: |
457 | 570 |
-- |
458 | 571 |
|
... | ... | |
466 | 579 |
|
467 | 580 |
|
468 | 581 |
-- |
582 |
-- TOC entry 186 (class 1259 OID 43523) |
|
583 |
-- Dependencies: 6 185 |
|
469 | 584 |
-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
470 | 585 |
-- |
471 | 586 |
|
472 | 587 |
CREATE SEQUENCE covermethod_covermethod_id_seq |
473 | 588 |
START WITH 1 |
474 | 589 |
INCREMENT BY 1 |
590 |
NO MINVALUE |
|
475 | 591 |
NO MAXVALUE |
476 |
NO MINVALUE |
|
477 | 592 |
CACHE 1; |
478 | 593 |
|
479 | 594 |
|
480 | 595 |
-- |
596 |
-- TOC entry 3370 (class 0 OID 0) |
|
597 |
-- Dependencies: 186 |
|
481 | 598 |
-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
482 | 599 |
-- |
483 | 600 |
|
... | ... | |
485 | 602 |
|
486 | 603 |
|
487 | 604 |
-- |
605 |
-- TOC entry 187 (class 1259 OID 43525) |
|
606 |
-- Dependencies: 6 |
|
488 | 607 |
-- Name: dba_confidentialitystatus; Type: TABLE; Schema: public; Owner: -; Tablespace: |
489 | 608 |
-- |
490 | 609 |
|
... | ... | |
496 | 615 |
|
497 | 616 |
|
498 | 617 |
-- |
618 |
-- TOC entry 188 (class 1259 OID 43528) |
|
619 |
-- Dependencies: 6 |
|
499 | 620 |
-- Name: dba_cookie; Type: TABLE; Schema: public; Owner: -; Tablespace: |
500 | 621 |
-- |
501 | 622 |
|
... | ... | |
514 | 635 |
|
515 | 636 |
|
516 | 637 |
-- |
638 |
-- TOC entry 189 (class 1259 OID 43534) |
|
639 |
-- Dependencies: 6 188 |
|
517 | 640 |
-- Name: dba_cookie_cookie_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
518 | 641 |
-- |
519 | 642 |
|
520 | 643 |
CREATE SEQUENCE dba_cookie_cookie_id_seq |
521 | 644 |
START WITH 1 |
522 | 645 |
INCREMENT BY 1 |
646 |
NO MINVALUE |
|
523 | 647 |
NO MAXVALUE |
524 |
NO MINVALUE |
|
525 | 648 |
CACHE 1; |
526 | 649 |
|
527 | 650 |
|
528 | 651 |
-- |
652 |
-- TOC entry 3371 (class 0 OID 0) |
|
653 |
-- Dependencies: 189 |
|
529 | 654 |
-- Name: dba_cookie_cookie_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
530 | 655 |
-- |
531 | 656 |
|
... | ... | |
533 | 658 |
|
534 | 659 |
|
535 | 660 |
-- |
661 |
-- TOC entry 190 (class 1259 OID 43536) |
|
662 |
-- Dependencies: 6 |
|
536 | 663 |
-- Name: dba_cookielabels; Type: TABLE; Schema: public; Owner: -; Tablespace: |
537 | 664 |
-- |
538 | 665 |
|
... | ... | |
544 | 671 |
|
545 | 672 |
|
546 | 673 |
-- |
674 |
-- TOC entry 191 (class 1259 OID 43542) |
|
675 |
-- Dependencies: 6 190 |
|
547 | 676 |
-- Name: dba_cookielabels_cookielabel_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
548 | 677 |
-- |
549 | 678 |
|
550 | 679 |
CREATE SEQUENCE dba_cookielabels_cookielabel_id_seq |
551 | 680 |
START WITH 1 |
552 | 681 |
INCREMENT BY 1 |
682 |
NO MINVALUE |
|
553 | 683 |
NO MAXVALUE |
554 |
NO MINVALUE |
|
555 | 684 |
CACHE 1; |
556 | 685 |
|
557 | 686 |
|
558 | 687 |
-- |
688 |
-- TOC entry 3372 (class 0 OID 0) |
|
689 |
-- Dependencies: 191 |
|
559 | 690 |
-- Name: dba_cookielabels_cookielabel_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
560 | 691 |
-- |
561 | 692 |
|
... | ... | |
565 | 696 |
SET default_with_oids = false; |
566 | 697 |
|
567 | 698 |
-- |
699 |
-- TOC entry 192 (class 1259 OID 43544) |
|
700 |
-- Dependencies: 6 |
|
568 | 701 |
-- Name: dba_datacache; Type: TABLE; Schema: public; Owner: -; Tablespace: |
569 | 702 |
-- |
570 | 703 |
|
... | ... | |
587 | 720 |
|
588 | 721 |
|
589 | 722 |
-- |
723 |
-- TOC entry 193 (class 1259 OID 43550) |
|
724 |
-- Dependencies: 6 192 |
|
590 | 725 |
-- Name: dba_datacache_dba_datacache_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
591 | 726 |
-- |
592 | 727 |
|
593 | 728 |
CREATE SEQUENCE dba_datacache_dba_datacache_id_seq |
594 | 729 |
START WITH 1 |
595 | 730 |
INCREMENT BY 1 |
731 |
NO MINVALUE |
|
596 | 732 |
NO MAXVALUE |
597 |
NO MINVALUE |
|
598 | 733 |
CACHE 1; |
599 | 734 |
|
600 | 735 |
|
601 | 736 |
-- |
737 |
-- TOC entry 3373 (class 0 OID 0) |
|
738 |
-- Dependencies: 193 |
|
602 | 739 |
-- Name: dba_datacache_dba_datacache_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
603 | 740 |
-- |
604 | 741 |
|
... | ... | |
606 | 743 |
|
607 | 744 |
|
608 | 745 |
-- |
746 |
-- TOC entry 194 (class 1259 OID 43552) |
|
747 |
-- Dependencies: 2831 6 |
|
609 | 748 |
-- Name: dba_datamodelversion; Type: TABLE; Schema: public; Owner: -; Tablespace: |
610 | 749 |
-- |
611 | 750 |
|
... | ... | |
617 | 756 |
|
618 | 757 |
|
619 | 758 |
-- |
759 |
-- TOC entry 195 (class 1259 OID 43556) |
|
760 |
-- Dependencies: 194 6 |
|
620 | 761 |
-- Name: dba_datamodelversion_dba_datamodelversion_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
621 | 762 |
-- |
622 | 763 |
|
623 | 764 |
CREATE SEQUENCE dba_datamodelversion_dba_datamodelversion_id_seq |
624 | 765 |
START WITH 1 |
625 | 766 |
INCREMENT BY 1 |
767 |
NO MINVALUE |
|
626 | 768 |
NO MAXVALUE |
627 |
NO MINVALUE |
|
628 | 769 |
CACHE 1; |
629 | 770 |
|
630 | 771 |
|
631 | 772 |
-- |
773 |
-- TOC entry 3374 (class 0 OID 0) |
|
774 |
-- Dependencies: 195 |
|
632 | 775 |
-- Name: dba_datamodelversion_dba_datamodelversion_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
633 | 776 |
-- |
634 | 777 |
|
... | ... | |
638 | 781 |
SET default_with_oids = true; |
639 | 782 |
|
640 | 783 |
-- |
784 |
-- TOC entry 196 (class 1259 OID 43558) |
|
785 |
-- Dependencies: 6 |
|
641 | 786 |
-- Name: dba_dbstatstime; Type: TABLE; Schema: public; Owner: -; Tablespace: |
642 | 787 |
-- |
643 | 788 |
|
... | ... | |
654 | 799 |
|
655 | 800 |
|
656 | 801 |
-- |
802 |
-- TOC entry 197 (class 1259 OID 43564) |
|
803 |
-- Dependencies: 196 6 |
|
657 | 804 |
-- Name: dba_dbstatstime_stat_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
658 | 805 |
-- |
659 | 806 |
|
660 | 807 |
CREATE SEQUENCE dba_dbstatstime_stat_id_seq |
661 | 808 |
START WITH 1 |
662 | 809 |
INCREMENT BY 1 |
810 |
NO MINVALUE |
|
663 | 811 |
NO MAXVALUE |
664 |
NO MINVALUE |
|
665 | 812 |
CACHE 1; |
666 | 813 |
|
667 | 814 |
|
668 | 815 |
-- |
816 |
-- TOC entry 3375 (class 0 OID 0) |
|
817 |
-- Dependencies: 197 |
|
669 | 818 |
-- Name: dba_dbstatstime_stat_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
670 | 819 |
-- |
671 | 820 |
|
... | ... | |
675 | 824 |
SET default_with_oids = false; |
676 | 825 |
|
677 | 826 |
-- |
827 |
-- TOC entry 198 (class 1259 OID 43566) |
|
828 |
-- Dependencies: 6 |
|
678 | 829 |
-- Name: dba_fielddescription; Type: TABLE; Schema: public; Owner: -; Tablespace: |
679 | 830 |
-- |
680 | 831 |
|
... | ... | |
696 | 847 |
|
697 | 848 |
|
698 | 849 |
-- |
850 |
-- TOC entry 199 (class 1259 OID 43572) |
|
851 |
-- Dependencies: 198 6 |
|
699 | 852 |
-- Name: dba_fielddescription_dba_fielddescription_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
700 | 853 |
-- |
701 | 854 |
|
702 | 855 |
CREATE SEQUENCE dba_fielddescription_dba_fielddescription_id_seq |
703 | 856 |
START WITH 1 |
704 | 857 |
INCREMENT BY 1 |
858 |
NO MINVALUE |
|
705 | 859 |
NO MAXVALUE |
706 |
NO MINVALUE |
|
707 | 860 |
CACHE 1; |
708 | 861 |
|
709 | 862 |
|
710 | 863 |
-- |
864 |
-- TOC entry 3376 (class 0 OID 0) |
|
865 |
-- Dependencies: 199 |
|
711 | 866 |
-- Name: dba_fielddescription_dba_fielddescription_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
712 | 867 |
-- |
713 | 868 |
|
... | ... | |
715 | 870 |
|
716 | 871 |
|
717 | 872 |
-- |
873 |
-- TOC entry 200 (class 1259 OID 43574) |
|
874 |
-- Dependencies: 6 |
|
718 | 875 |
-- Name: dba_fieldlist; Type: TABLE; Schema: public; Owner: -; Tablespace: |
719 | 876 |
-- |
720 | 877 |
|
... | ... | |
729 | 886 |
|
730 | 887 |
|
731 | 888 |
-- |
889 |
-- TOC entry 201 (class 1259 OID 43580) |
|
890 |
-- Dependencies: 6 200 |
|
732 | 891 |
-- Name: dba_fieldlist_dba_fieldlist_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
733 | 892 |
-- |
734 | 893 |
|
735 | 894 |
CREATE SEQUENCE dba_fieldlist_dba_fieldlist_id_seq |
736 | 895 |
START WITH 1 |
737 | 896 |
INCREMENT BY 1 |
897 |
NO MINVALUE |
|
738 | 898 |
NO MAXVALUE |
739 |
NO MINVALUE |
|
740 | 899 |
CACHE 1; |
741 | 900 |
|
742 | 901 |
|
743 | 902 |
-- |
903 |
-- TOC entry 3377 (class 0 OID 0) |
|
904 |
-- Dependencies: 201 |
|
744 | 905 |
-- Name: dba_fieldlist_dba_fieldlist_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
745 | 906 |
-- |
746 | 907 |
|
... | ... | |
748 | 909 |
|
749 | 910 |
|
750 | 911 |
-- |
912 |
-- TOC entry 202 (class 1259 OID 43582) |
|
913 |
-- Dependencies: 6 |
|
751 | 914 |
-- Name: dba_onerow; Type: TABLE; Schema: public; Owner: -; Tablespace: |
752 | 915 |
-- |
753 | 916 |
|
... | ... | |
757 | 920 |
|
758 | 921 |
|
759 | 922 |
-- |
923 |
-- TOC entry 203 (class 1259 OID 43585) |
|
924 |
-- Dependencies: 202 6 |
|
760 | 925 |
-- Name: dba_onerow_dba_onerow_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
761 | 926 |
-- |
762 | 927 |
|
763 | 928 |
CREATE SEQUENCE dba_onerow_dba_onerow_id_seq |
764 | 929 |
START WITH 1 |
765 | 930 |
INCREMENT BY 1 |
931 |
NO MINVALUE |
|
766 | 932 |
NO MAXVALUE |
767 |
NO MINVALUE |
|
768 | 933 |
CACHE 1; |
769 | 934 |
|
770 | 935 |
|
771 | 936 |
-- |
937 |
-- TOC entry 3378 (class 0 OID 0) |
|
938 |
-- Dependencies: 203 |
|
772 | 939 |
-- Name: dba_onerow_dba_onerow_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
773 | 940 |
-- |
774 | 941 |
|
... | ... | |
776 | 943 |
|
777 | 944 |
|
778 | 945 |
-- |
946 |
-- TOC entry 204 (class 1259 OID 43587) |
|
947 |
-- Dependencies: 2837 6 |
|
779 | 948 |
-- Name: dba_preassignacccode; Type: TABLE; Schema: public; Owner: -; Tablespace: |
780 | 949 |
-- |
781 | 950 |
|
... | ... | |
791 | 960 |
|
792 | 961 |
|
793 | 962 |
-- |
963 |
-- TOC entry 205 (class 1259 OID 43591) |
|
964 |
-- Dependencies: 204 6 |
|
794 | 965 |
-- Name: dba_preassignacccode_dba_preassignacccode_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
795 | 966 |
-- |
796 | 967 |
|
797 | 968 |
CREATE SEQUENCE dba_preassignacccode_dba_preassignacccode_id_seq |
798 | 969 |
START WITH 1 |
799 | 970 |
INCREMENT BY 1 |
971 |
NO MINVALUE |
|
800 | 972 |
NO MAXVALUE |
801 |
NO MINVALUE |
|
802 | 973 |
CACHE 1; |
803 | 974 |
|
804 | 975 |
|
805 | 976 |
-- |
977 |
-- TOC entry 3379 (class 0 OID 0) |
|
978 |
-- Dependencies: 205 |
|
806 | 979 |
-- Name: dba_preassignacccode_dba_preassignacccode_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
807 | 980 |
-- |
808 | 981 |
|
... | ... | |
810 | 983 |
|
811 | 984 |
|
812 | 985 |
-- |
986 |
-- TOC entry 206 (class 1259 OID 43593) |
|
987 |
-- Dependencies: 6 |
|
813 | 988 |
-- Name: dba_preassignacccode_dba_requestnumber_seq; Type: SEQUENCE; Schema: public; Owner: - |
814 | 989 |
-- |
815 | 990 |
|
816 | 991 |
CREATE SEQUENCE dba_preassignacccode_dba_requestnumber_seq |
817 | 992 |
START WITH 1 |
818 | 993 |
INCREMENT BY 1 |
994 |
NO MINVALUE |
|
819 | 995 |
NO MAXVALUE |
820 |
NO MINVALUE |
|
821 | 996 |
CACHE 1; |
822 | 997 |
|
823 | 998 |
|
824 | 999 |
-- |
1000 |
-- TOC entry 207 (class 1259 OID 43595) |
|
1001 |
-- Dependencies: 6 |
|
825 | 1002 |
-- Name: dba_tabledescription; Type: TABLE; Schema: public; Owner: -; Tablespace: |
826 | 1003 |
-- |
827 | 1004 |
|
... | ... | |
836 | 1013 |
|
837 | 1014 |
|
838 | 1015 |
-- |
1016 |
-- TOC entry 208 (class 1259 OID 43601) |
|
1017 |
-- Dependencies: 6 207 |
|
839 | 1018 |
-- Name: dba_tabledescription_dba_tabledescription_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
840 | 1019 |
-- |
841 | 1020 |
|
842 | 1021 |
CREATE SEQUENCE dba_tabledescription_dba_tabledescription_id_seq |
843 | 1022 |
START WITH 1 |
844 | 1023 |
INCREMENT BY 1 |
1024 |
NO MINVALUE |
|
845 | 1025 |
NO MAXVALUE |
846 |
NO MINVALUE |
|
847 | 1026 |
CACHE 1; |
848 | 1027 |
|
849 | 1028 |
|
850 | 1029 |
-- |
1030 |
-- TOC entry 3380 (class 0 OID 0) |
|
1031 |
-- Dependencies: 208 |
|
851 | 1032 |
-- Name: dba_tabledescription_dba_tabledescription_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
852 | 1033 |
-- |
853 | 1034 |
|
... | ... | |
855 | 1036 |
|
856 | 1037 |
|
857 | 1038 |
-- |
1039 |
-- TOC entry 209 (class 1259 OID 43603) |
|
1040 |
-- Dependencies: 6 |
|
858 | 1041 |
-- Name: dba_xmlcache; Type: TABLE; Schema: public; Owner: -; Tablespace: |
859 | 1042 |
-- |
860 | 1043 |
|
... | ... | |
867 | 1050 |
SET default_with_oids = true; |
868 | 1051 |
|
869 | 1052 |
-- |
1053 |
-- TOC entry 210 (class 1259 OID 43609) |
|
1054 |
-- Dependencies: 6 |
|
870 | 1055 |
-- Name: definedvalue; Type: TABLE; Schema: public; Owner: -; Tablespace: |
871 | 1056 |
-- |
872 | 1057 |
|
... | ... | |
879 | 1064 |
|
880 | 1065 |
|
881 | 1066 |
-- |
1067 |
-- TOC entry 211 (class 1259 OID 43615) |
|
1068 |
-- Dependencies: 6 210 |
|
882 | 1069 |
-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
883 | 1070 |
-- |
884 | 1071 |
|
885 | 1072 |
CREATE SEQUENCE definedvalue_definedvalue_id_seq |
886 | 1073 |
START WITH 1 |
887 | 1074 |
INCREMENT BY 1 |
1075 |
NO MINVALUE |
|
888 | 1076 |
NO MAXVALUE |
889 |
NO MINVALUE |
|
890 | 1077 |
CACHE 1; |
891 | 1078 |
|
892 | 1079 |
|
893 | 1080 |
-- |
1081 |
-- TOC entry 3381 (class 0 OID 0) |
|
1082 |
-- Dependencies: 211 |
|
894 | 1083 |
-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
895 | 1084 |
-- |
896 | 1085 |
|
... | ... | |
898 | 1087 |
|
899 | 1088 |
|
900 | 1089 |
-- |
1090 |
-- TOC entry 212 (class 1259 OID 43617) |
|
1091 |
-- Dependencies: 6 |
|
901 | 1092 |
-- Name: disturbanceobs; Type: TABLE; Schema: public; Owner: -; Tablespace: |
902 | 1093 |
-- |
903 | 1094 |
|
... | ... | |
914 | 1105 |
|
915 | 1106 |
|
916 | 1107 |
-- |
1108 |
-- TOC entry 213 (class 1259 OID 43623) |
|
1109 |
-- Dependencies: 212 6 |
|
917 | 1110 |
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
918 | 1111 |
-- |
919 | 1112 |
|
920 | 1113 |
CREATE SEQUENCE disturbanceobs_disturbanceobs_id_seq |
921 | 1114 |
START WITH 1 |
922 | 1115 |
INCREMENT BY 1 |
1116 |
NO MINVALUE |
|
923 | 1117 |
NO MAXVALUE |
924 |
NO MINVALUE |
|
925 | 1118 |
CACHE 1; |
926 | 1119 |
|
927 | 1120 |
|
928 | 1121 |
-- |
1122 |
-- TOC entry 3382 (class 0 OID 0) |
|
1123 |
-- Dependencies: 213 |
|
929 | 1124 |
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
930 | 1125 |
-- |
931 | 1126 |
|
... | ... | |
933 | 1128 |
|
934 | 1129 |
|
935 | 1130 |
-- |
1131 |
-- TOC entry 214 (class 1259 OID 43625) |
|
1132 |
-- Dependencies: 6 |
|
936 | 1133 |
-- Name: embargo; Type: TABLE; Schema: public; Owner: -; Tablespace: |
937 | 1134 |
-- |
938 | 1135 |
|
... | ... | |
947 | 1144 |
|
948 | 1145 |
|
949 | 1146 |
-- |
1147 |
-- TOC entry 215 (class 1259 OID 43631) |
|
1148 |
-- Dependencies: 214 6 |
|
950 | 1149 |
-- Name: embargo_embargo_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
951 | 1150 |
-- |
952 | 1151 |
|
953 | 1152 |
CREATE SEQUENCE embargo_embargo_id_seq |
954 | 1153 |
START WITH 1 |
955 | 1154 |
INCREMENT BY 1 |
1155 |
NO MINVALUE |
|
956 | 1156 |
NO MAXVALUE |
957 |
NO MINVALUE |
|
958 | 1157 |
CACHE 1; |
959 | 1158 |
|
960 | 1159 |
|
961 | 1160 |
-- |
1161 |
-- TOC entry 3383 (class 0 OID 0) |
|
1162 |
-- Dependencies: 215 |
|
962 | 1163 |
-- Name: embargo_embargo_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
963 | 1164 |
-- |
964 | 1165 |
|
... | ... | |
966 | 1167 |
|
967 | 1168 |
|
968 | 1169 |
-- |
1170 |
-- TOC entry 216 (class 1259 OID 43633) |
|
1171 |
-- Dependencies: 6 |
|
969 | 1172 |
-- Name: graphic; Type: TABLE; Schema: public; Owner: -; Tablespace: |
970 | 1173 |
-- |
971 | 1174 |
|
... | ... | |
983 | 1186 |
|
984 | 1187 |
|
985 | 1188 |
-- |
1189 |
-- TOC entry 217 (class 1259 OID 43639) |
|
1190 |
-- Dependencies: 216 6 |
|
986 | 1191 |
-- Name: graphic_graphic_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
987 | 1192 |
-- |
988 | 1193 |
|
989 | 1194 |
CREATE SEQUENCE graphic_graphic_id_seq |
990 | 1195 |
START WITH 1 |
991 | 1196 |
INCREMENT BY 1 |
1197 |
NO MINVALUE |
|
992 | 1198 |
NO MAXVALUE |
993 |
NO MINVALUE |
|
994 | 1199 |
CACHE 1; |
995 | 1200 |
|
996 | 1201 |
|
997 | 1202 |
-- |
1203 |
-- TOC entry 3384 (class 0 OID 0) |
|
1204 |
-- Dependencies: 217 |
|
998 | 1205 |
-- Name: graphic_graphic_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
999 | 1206 |
-- |
1000 | 1207 |
|
... | ... | |
1002 | 1209 |
|
1003 | 1210 |
|
1004 | 1211 |
-- |
1212 |
-- TOC entry 218 (class 1259 OID 43641) |
|
1213 |
-- Dependencies: 6 |
|
1005 | 1214 |
-- Name: keywords; Type: TABLE; Schema: public; Owner: -; Tablespace: |
1006 | 1215 |
-- |
1007 | 1216 |
|
... | ... | |
1013 | 1222 |
|
1014 | 1223 |
|
1015 | 1224 |
-- |
1225 |
-- TOC entry 219 (class 1259 OID 43647) |
|
1226 |
-- Dependencies: 6 |
|
1016 | 1227 |
-- Name: keywords_extra; Type: TABLE; Schema: public; Owner: -; Tablespace: |
1017 | 1228 |
-- |
1018 | 1229 |
|
... | ... | |
1024 | 1235 |
|
1025 | 1236 |
|
1026 | 1237 |
-- |
1238 |
-- TOC entry 220 (class 1259 OID 43653) |
|
1239 |
-- Dependencies: 6 |
|
1027 | 1240 |
-- Name: namedplace; Type: TABLE; Schema: public; Owner: -; Tablespace: |
1028 | 1241 |
-- |
1029 | 1242 |
|
... | ... | |
1041 | 1254 |
|
1042 | 1255 |
|
1043 | 1256 |
-- |
1257 |
-- TOC entry 221 (class 1259 OID 43659) |
|
1258 |
-- Dependencies: 220 6 |
|
1044 | 1259 |
-- Name: namedplace_namedplace_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
1045 | 1260 |
-- |
1046 | 1261 |
|
1047 | 1262 |
CREATE SEQUENCE namedplace_namedplace_id_seq |
1048 | 1263 |
START WITH 1 |
1049 | 1264 |
INCREMENT BY 1 |
1265 |
NO MINVALUE |
|
1050 | 1266 |
NO MAXVALUE |
1051 |
NO MINVALUE |
|
1052 | 1267 |
CACHE 1; |
1053 | 1268 |
|
1054 | 1269 |
|
1055 | 1270 |
-- |
1271 |
-- TOC entry 3385 (class 0 OID 0) |
|
1272 |
-- Dependencies: 221 |
|
1056 | 1273 |
-- Name: namedplace_namedplace_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
1057 | 1274 |
-- |
1058 | 1275 |
|
... | ... | |
1060 | 1277 |
|
1061 | 1278 |
|
1062 | 1279 |
-- |
1280 |
-- TOC entry 222 (class 1259 OID 43661) |
|
1281 |
-- Dependencies: 6 |
|
1063 | 1282 |
-- Name: namedplacecorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: |
1064 | 1283 |
-- |
1065 | 1284 |
|
... | ... | |
1072 | 1291 |
|
1073 | 1292 |
|
1074 | 1293 |
-- |
1294 |
-- TOC entry 223 (class 1259 OID 43664) |
|
1295 |
-- Dependencies: 6 222 |
|
1075 | 1296 |
-- Name: namedplacecorrelation_namedplacecorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
1076 | 1297 |
-- |
1077 | 1298 |
|
1078 | 1299 |
CREATE SEQUENCE namedplacecorrelation_namedplacecorrelation_id_seq |
1079 | 1300 |
START WITH 1 |
1080 | 1301 |
INCREMENT BY 1 |
1302 |
NO MINVALUE |
|
1081 | 1303 |
NO MAXVALUE |
1082 |
NO MINVALUE |
|
1083 | 1304 |
CACHE 1; |
1084 | 1305 |
|
1085 | 1306 |
|
1086 | 1307 |
-- |
1308 |
-- TOC entry 3386 (class 0 OID 0) |
|
1309 |
-- Dependencies: 223 |
|
1087 | 1310 |
-- Name: namedplacecorrelation_namedplacecorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
1088 | 1311 |
-- |
1089 | 1312 |
|
... | ... | |
1091 | 1314 |
|
1092 | 1315 |
|
1093 | 1316 |
-- |
1317 |
-- TOC entry 224 (class 1259 OID 43666) |
|
1318 |
-- Dependencies: 6 |
|
1094 | 1319 |
-- Name: note; Type: TABLE; Schema: public; Owner: -; Tablespace: |
1095 | 1320 |
-- |
1096 | 1321 |
|
... | ... | |
1107 | 1332 |
|
1108 | 1333 |
|
1109 | 1334 |
-- |
1335 |
-- TOC entry 225 (class 1259 OID 43672) |
|
1336 |
-- Dependencies: 224 6 |
|
1110 | 1337 |
-- Name: note_note_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
1111 | 1338 |
-- |
1112 | 1339 |
|
1113 | 1340 |
CREATE SEQUENCE note_note_id_seq |
1114 | 1341 |
START WITH 1 |
1115 | 1342 |
INCREMENT BY 1 |
1343 |
NO MINVALUE |
|
1116 | 1344 |
NO MAXVALUE |
1117 |
NO MINVALUE |
|
1118 | 1345 |
CACHE 1; |
1119 | 1346 |
|
1120 | 1347 |
|
1121 | 1348 |
-- |
1349 |
-- TOC entry 3387 (class 0 OID 0) |
|
1350 |
-- Dependencies: 225 |
|
1122 | 1351 |
-- Name: note_note_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
1123 | 1352 |
-- |
1124 | 1353 |
|
... | ... | |
1126 | 1355 |
|
1127 | 1356 |
|
1128 | 1357 |
-- |
1358 |
-- TOC entry 226 (class 1259 OID 43674) |
|
1359 |
-- Dependencies: 6 |
|
1129 | 1360 |
-- Name: notelink; Type: TABLE; Schema: public; Owner: -; Tablespace: |
1130 | 1361 |
-- |
1131 | 1362 |
|
... | ... | |
1138 | 1369 |
|
1139 | 1370 |
|
1140 | 1371 |
-- |
1372 |
-- TOC entry 227 (class 1259 OID 43677) |
|
1373 |
-- Dependencies: 6 226 |
|
1141 | 1374 |
-- Name: notelink_notelink_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
1142 | 1375 |
-- |
1143 | 1376 |
|
1144 | 1377 |
CREATE SEQUENCE notelink_notelink_id_seq |
1145 | 1378 |
START WITH 1 |
1146 | 1379 |
INCREMENT BY 1 |
1380 |
NO MINVALUE |
|
1147 | 1381 |
NO MAXVALUE |
1148 |
NO MINVALUE |
|
1149 | 1382 |
CACHE 1; |
1150 | 1383 |
|
1151 | 1384 |
|
1152 | 1385 |
-- |
1386 |
-- TOC entry 3388 (class 0 OID 0) |
|
1387 |
-- Dependencies: 227 |
|
1153 | 1388 |
-- Name: notelink_notelink_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
1154 | 1389 |
-- |
1155 | 1390 |
|
... | ... | |
1157 | 1392 |
|
1158 | 1393 |
|
1159 | 1394 |
-- |
1395 |
-- TOC entry 228 (class 1259 OID 43679) |
|
1396 |
-- Dependencies: 2848 6 |
|
1160 | 1397 |
-- Name: observation; Type: TABLE; Schema: public; Owner: -; Tablespace: |
1161 | 1398 |
-- |
1162 | 1399 |
|
... | ... | |
1263 | 1500 |
|
1264 | 1501 |
|
1265 | 1502 |
-- |
1503 |
-- TOC entry 229 (class 1259 OID 43686) |
|
1504 |
-- Dependencies: 228 6 |
|
1266 | 1505 |
-- Name: observation_observation_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
1267 | 1506 |
-- |
1268 | 1507 |
|
1269 | 1508 |
CREATE SEQUENCE observation_observation_id_seq |
1270 | 1509 |
START WITH 1 |
1271 | 1510 |
INCREMENT BY 1 |
1511 |
NO MINVALUE |
|
1272 | 1512 |
NO MAXVALUE |
1273 |
NO MINVALUE |
|
1274 | 1513 |
CACHE 1; |
1275 | 1514 |
|
1276 | 1515 |
|
1277 | 1516 |
-- |
1517 |
-- TOC entry 3389 (class 0 OID 0) |
|
1518 |
-- Dependencies: 229 |
|
1278 | 1519 |
-- Name: observation_observation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
1279 | 1520 |
-- |
1280 | 1521 |
|
... | ... | |
1282 | 1523 |
|
1283 | 1524 |
|
1284 | 1525 |
-- |
1526 |
-- TOC entry 230 (class 1259 OID 43688) |
|
1527 |
-- Dependencies: 6 |
|
1285 | 1528 |
-- Name: observationcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: |
1286 | 1529 |
-- |
1287 | 1530 |
|
... | ... | |
1295 | 1538 |
|
1296 | 1539 |
|
1297 | 1540 |
-- |
1541 |
-- TOC entry 231 (class 1259 OID 43691) |
|
1542 |
-- Dependencies: 230 6 |
|
1298 | 1543 |
-- Name: observationcontributor_observationcontributor_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
1299 | 1544 |
-- |
1300 | 1545 |
|
1301 | 1546 |
CREATE SEQUENCE observationcontributor_observationcontributor_id_seq |
1302 | 1547 |
START WITH 1 |
1303 | 1548 |
INCREMENT BY 1 |
1549 |
NO MINVALUE |
|
1304 | 1550 |
NO MAXVALUE |
1305 |
NO MINVALUE |
|
1306 | 1551 |
CACHE 1; |
1307 | 1552 |
|
1308 | 1553 |
|
1309 | 1554 |
-- |
1555 |
-- TOC entry 3390 (class 0 OID 0) |
|
1556 |
-- Dependencies: 231 |
|
1310 | 1557 |
-- Name: observationcontributor_observationcontributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
1311 | 1558 |
-- |
1312 | 1559 |
|
... | ... | |
1314 | 1561 |
|
1315 | 1562 |
|
1316 | 1563 |
-- |
1564 |
-- TOC entry 232 (class 1259 OID 43693) |
|
1565 |
-- Dependencies: 2851 6 |
|
1317 | 1566 |
-- Name: observationsynonym; Type: TABLE; Schema: public; Owner: -; Tablespace: |
1318 | 1567 |
-- |
1319 | 1568 |
|
... | ... | |
1331 | 1580 |
|
1332 | 1581 |
|
1333 | 1582 |
-- |
1583 |
-- TOC entry 233 (class 1259 OID 43700) |
|
1584 |
-- Dependencies: 232 6 |
|
1334 | 1585 |
-- Name: observationsynonym_observationsynonym_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
1335 | 1586 |
-- |
1336 | 1587 |
|
1337 | 1588 |
CREATE SEQUENCE observationsynonym_observationsynonym_id_seq |
1338 | 1589 |
START WITH 1 |
1339 | 1590 |
INCREMENT BY 1 |
1591 |
NO MINVALUE |
|
1340 | 1592 |
NO MAXVALUE |
1341 |
NO MINVALUE |
|
1342 | 1593 |
CACHE 1; |
1343 | 1594 |
|
1344 | 1595 |
|
1345 | 1596 |
-- |
1597 |
-- TOC entry 3391 (class 0 OID 0) |
|
1598 |
-- Dependencies: 233 |
|
1346 | 1599 |
-- Name: observationsynonym_observationsynonym_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
1347 | 1600 |
-- |
1348 | 1601 |
|
... | ... | |
1350 | 1603 |
|
1351 | 1604 |
|
1352 | 1605 |
-- |
1606 |
-- TOC entry 234 (class 1259 OID 43702) |
|
1607 |
-- Dependencies: 2853 6 |
|
1353 | 1608 |
-- Name: party; Type: TABLE; Schema: public; Owner: -; Tablespace: |
1354 | 1609 |
-- |
1355 | 1610 |
|
... | ... | |
1371 | 1626 |
|
1372 | 1627 |
|
1373 | 1628 |
-- |
1629 |
-- TOC entry 235 (class 1259 OID 43709) |
|
1630 |
-- Dependencies: 234 6 |
|
1374 | 1631 |
-- Name: party_party_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
1375 | 1632 |
-- |
1376 | 1633 |
|
1377 | 1634 |
CREATE SEQUENCE party_party_id_seq |
1378 | 1635 |
START WITH 1 |
1379 | 1636 |
INCREMENT BY 1 |
1637 |
NO MINVALUE |
|
1380 | 1638 |
NO MAXVALUE |
1381 |
NO MINVALUE |
|
1382 | 1639 |
CACHE 1; |
1383 | 1640 |
|
1384 | 1641 |
|
1385 | 1642 |
-- |
1643 |
-- TOC entry 3392 (class 0 OID 0) |
|
1644 |
-- Dependencies: 235 |
|
1386 | 1645 |
-- Name: party_party_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
1387 | 1646 |
-- |
1388 | 1647 |
|
... | ... | |
1390 | 1649 |
|
1391 | 1650 |
|
1392 | 1651 |
-- |
1652 |
-- TOC entry 236 (class 1259 OID 43711) |
|
1653 |
-- Dependencies: 2855 6 |
|
1393 | 1654 |
-- Name: partymember; Type: TABLE; Schema: public; Owner: -; Tablespace: |
1394 | 1655 |
-- |
1395 | 1656 |
|
... | ... | |
1404 | 1665 |
|
1405 | 1666 |
|
1406 | 1667 |
-- |
1668 |
-- TOC entry 237 (class 1259 OID 43715) |
|
1669 |
-- Dependencies: 236 6 |
|
1407 | 1670 |
-- Name: partymember_partymember_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
1408 | 1671 |
-- |
1409 | 1672 |
|
1410 | 1673 |
CREATE SEQUENCE partymember_partymember_id_seq |
1411 | 1674 |
START WITH 1 |
1412 | 1675 |
INCREMENT BY 1 |
1676 |
NO MINVALUE |
|
1413 | 1677 |
NO MAXVALUE |
1414 |
NO MINVALUE |
|
1415 | 1678 |
CACHE 1; |
1416 | 1679 |
|
1417 | 1680 |
|
1418 | 1681 |
-- |
1682 |
-- TOC entry 3393 (class 0 OID 0) |
|
1683 |
-- Dependencies: 237 |
|
1419 | 1684 |
-- Name: partymember_partymember_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
1420 | 1685 |
-- |
1421 | 1686 |
|
... | ... | |
1423 | 1688 |
|
1424 | 1689 |
|
1425 | 1690 |
-- |
1691 |
-- TOC entry 238 (class 1259 OID 43717) |
|
1692 |
-- Dependencies: 6 |
|
1426 | 1693 |
-- Name: place; Type: TABLE; Schema: public; Owner: -; Tablespace: |
1427 | 1694 |
-- |
1428 | 1695 |
|
... | ... | |
1435 | 1702 |
|
1436 | 1703 |
|
1437 | 1704 |
-- |
1705 |
-- TOC entry 239 (class 1259 OID 43720) |
|
1706 |
-- Dependencies: 6 238 |
|
1438 | 1707 |
-- Name: place_plotplace_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
1439 | 1708 |
-- |
1440 | 1709 |
|
1441 | 1710 |
CREATE SEQUENCE place_plotplace_id_seq |
1442 | 1711 |
START WITH 1 |
1443 | 1712 |
INCREMENT BY 1 |
1713 |
NO MINVALUE |
|
1444 | 1714 |
NO MAXVALUE |
1445 |
NO MINVALUE |
|
1446 | 1715 |
CACHE 1; |
1447 | 1716 |
|
1448 | 1717 |
|
1449 | 1718 |
-- |
1719 |
-- TOC entry 3394 (class 0 OID 0) |
|
1720 |
-- Dependencies: 239 |
|
1450 | 1721 |
-- Name: place_plotplace_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
1451 | 1722 |
-- |
1452 | 1723 |
|
... | ... | |
1454 | 1725 |
|
1455 | 1726 |
|
1456 | 1727 |
-- |
1728 |
-- TOC entry 240 (class 1259 OID 43722) |
|
1729 |
-- Dependencies: 6 |
|
1457 | 1730 |
-- Name: plantconcept; Type: TABLE; Schema: public; Owner: -; Tablespace: |
1458 | 1731 |
-- |
1459 | 1732 |
|
... | ... | |
1471 | 1744 |
|
1472 | 1745 |
|
1473 | 1746 |
-- |
1747 |
-- TOC entry 241 (class 1259 OID 43728) |
|
1748 |
-- Dependencies: 6 240 |
|
1474 | 1749 |
-- Name: plantconcept_plantconcept_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
1475 | 1750 |
-- |
1476 | 1751 |
|
1477 | 1752 |
CREATE SEQUENCE plantconcept_plantconcept_id_seq |
1478 | 1753 |
START WITH 1 |
1479 | 1754 |
INCREMENT BY 1 |
1755 |
NO MINVALUE |
|
1480 | 1756 |
NO MAXVALUE |
1481 |
NO MINVALUE |
|
1482 | 1757 |
CACHE 1; |
1483 | 1758 |
|
1484 | 1759 |
|
1485 | 1760 |
-- |
1761 |
-- TOC entry 3395 (class 0 OID 0) |
|
1762 |
-- Dependencies: 241 |
|
1486 | 1763 |
-- Name: plantconcept_plantconcept_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
1487 | 1764 |
-- |
1488 | 1765 |
|
... | ... | |
1490 | 1767 |
|
1491 | 1768 |
|
1492 | 1769 |
-- |
1770 |
-- TOC entry 242 (class 1259 OID 43730) |
|
1771 |
-- Dependencies: 6 |
|
1493 | 1772 |
-- Name: plantcorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: |
1494 | 1773 |
-- |
1495 | 1774 |
|
... | ... | |
1504 | 1783 |
|
1505 | 1784 |
|
1506 | 1785 |
-- |
1786 |
-- TOC entry 243 (class 1259 OID 43733) |
|
1787 |
-- Dependencies: 6 242 |
|
1507 | 1788 |
-- Name: plantcorrelation_plantcorrelation_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
1508 | 1789 |
-- |
1509 | 1790 |
|
1510 | 1791 |
CREATE SEQUENCE plantcorrelation_plantcorrelation_id_seq |
1511 | 1792 |
START WITH 1 |
1512 | 1793 |
INCREMENT BY 1 |
1794 |
NO MINVALUE |
|
1513 | 1795 |
NO MAXVALUE |
1514 |
NO MINVALUE |
|
1515 | 1796 |
CACHE 1; |
1516 | 1797 |
|
1517 | 1798 |
|
1518 | 1799 |
-- |
1800 |
-- TOC entry 3396 (class 0 OID 0) |
|
1801 |
-- Dependencies: 243 |
|
1519 | 1802 |
-- Name: plantcorrelation_plantcorrelation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
1520 | 1803 |
-- |
1521 | 1804 |
|
... | ... | |
1523 | 1806 |
|
1524 | 1807 |
|
1525 | 1808 |
-- |
1809 |
-- TOC entry 244 (class 1259 OID 43735) |
|
1810 |
-- Dependencies: 6 |
|
1526 | 1811 |
-- Name: plantlineage; Type: TABLE; Schema: public; Owner: -; Tablespace: |
1527 | 1812 |
-- |
1528 | 1813 |
|
... | ... | |
1534 | 1819 |
|
1535 | 1820 |
|
1536 | 1821 |
-- |
1822 |
-- TOC entry 245 (class 1259 OID 43738) |
|
1823 |
-- Dependencies: 244 6 |
|
1537 | 1824 |
-- Name: plantlineage_plantlineage_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
1538 | 1825 |
-- |
1539 | 1826 |
|
1540 | 1827 |
CREATE SEQUENCE plantlineage_plantlineage_id_seq |
1541 | 1828 |
START WITH 1 |
1542 | 1829 |
INCREMENT BY 1 |
1830 |
NO MINVALUE |
|
1543 | 1831 |
NO MAXVALUE |
1544 |
NO MINVALUE |
|
1545 | 1832 |
CACHE 1; |
1546 | 1833 |
|
1547 | 1834 |
|
1548 | 1835 |
-- |
1836 |
-- TOC entry 3397 (class 0 OID 0) |
|
1837 |
-- Dependencies: 245 |
|
1549 | 1838 |
-- Name: plantlineage_plantlineage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
1550 | 1839 |
-- |
1551 | 1840 |
|
... | ... | |
1553 | 1842 |
|
1554 | 1843 |
|
1555 | 1844 |
-- |
1845 |
-- TOC entry 246 (class 1259 OID 43740) |
|
1846 |
-- Dependencies: 2861 6 |
|
1556 | 1847 |
-- Name: plantname; Type: TABLE; Schema: public; Owner: -; Tablespace: |
1557 | 1848 |
-- |
1558 | 1849 |
|
... | ... | |
1565 | 1856 |
|
1566 | 1857 |
|
1567 | 1858 |
-- |
1859 |
-- TOC entry 247 (class 1259 OID 43744) |
|
1860 |
-- Dependencies: 6 246 |
|
1568 | 1861 |
-- Name: plantname_plantname_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
1569 | 1862 |
-- |
1570 | 1863 |
|
1571 | 1864 |
CREATE SEQUENCE plantname_plantname_id_seq |
1572 | 1865 |
START WITH 1 |
1573 | 1866 |
INCREMENT BY 1 |
1867 |
NO MINVALUE |
|
1574 | 1868 |
NO MAXVALUE |
1575 |
NO MINVALUE |
|
1576 | 1869 |
CACHE 1; |
Also available in: Unified diff
Added DROP DATABASE and CREATE DATABASE to vegbank.sql