Project

General

Profile

« Previous | Next » 

Revision 6029

schemas/Makefile: DDLs: $(pg_dump): Turn off schema-only mode so that lookup table contents are included as well

View differences:

schemas/vegbien.my.sql
556 556

  
557 557

  
558 558
--
559
-- Name: address_address_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
560
--
561

  
562

  
563

  
564
--
559 565
-- Name: aggregateoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace: 
560 566
--
561 567

  
......
616 622

  
617 623

  
618 624
--
625
-- Name: aggregateoccurrence_aggregateoccurrence_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
626
--
627

  
628

  
629

  
630
--
619 631
-- Name: analytical_aggregate; Type: TABLE; Schema: public; Owner: -; Tablespace: 
620 632
--
621 633

  
......
1430 1442

  
1431 1443

  
1432 1444
--
1445
-- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1446
--
1447

  
1448

  
1449

  
1450
--
1433 1451
-- Name: commclass; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1434 1452
--
1435 1453

  
......
1467 1485

  
1468 1486

  
1469 1487
--
1488
-- Name: commclass_commclass_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1489
--
1490

  
1491

  
1492

  
1493
--
1470 1494
-- Name: commconcept; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1471 1495
--
1472 1496

  
......
1497 1521

  
1498 1522

  
1499 1523
--
1524
-- Name: commconcept_commconcept_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1525
--
1526

  
1527

  
1528

  
1529
--
1500 1530
-- Name: commcorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1501 1531
--
1502 1532

  
......
1525 1555

  
1526 1556

  
1527 1557
--
1558
-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1559
--
1560

  
1561

  
1562

  
1563
--
1528 1564
-- Name: commdetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1529 1565
--
1530 1566

  
......
1558 1594

  
1559 1595

  
1560 1596
--
1597
-- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1598
--
1599

  
1600

  
1601

  
1602
--
1561 1603
-- Name: commlineage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1562 1604
--
1563 1605

  
......
1583 1625

  
1584 1626

  
1585 1627
--
1628
-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1629
--
1630

  
1631

  
1632

  
1633
--
1586 1634
-- Name: commname; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1587 1635
--
1588 1636

  
......
1609 1657

  
1610 1658

  
1611 1659
--
1660
-- Name: commname_commname_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1661
--
1662

  
1663

  
1664

  
1665
--
1612 1666
-- Name: commstatus; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1613 1667
--
1614 1668

  
......
1642 1696

  
1643 1697

  
1644 1698
--
1699
-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1700
--
1701

  
1702

  
1703

  
1704
--
1645 1705
-- Name: commusage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1646 1706
--
1647 1707

  
......
1674 1734

  
1675 1735

  
1676 1736
--
1737
-- Name: commusage_commusage_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1738
--
1739

  
1740

  
1741

  
1742
--
1677 1743
-- Name: coordinates_coordinates_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1678 1744
--
1679 1745

  
......
1688 1754

  
1689 1755

  
1690 1756
--
1757
-- Name: coordinates_coordinates_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1758
--
1759

  
1760

  
1761

  
1762
--
1691 1763
-- Name: coverindex; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1692 1764
--
1693 1765

  
......
1717 1789

  
1718 1790

  
1719 1791
--
1792
-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1793
--
1794

  
1795

  
1796

  
1797
--
1720 1798
-- Name: covermethod; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1721 1799
--
1722 1800

  
......
1744 1822

  
1745 1823

  
1746 1824
--
1825
-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1826
--
1827

  
1828

  
1829

  
1830
--
1747 1831
-- Name: dba_preassignacccode_dba_requestnumber_seq; Type: SEQUENCE; Schema: public; Owner: -
1748 1832
--
1749 1833

  
......
1751 1835

  
1752 1836

  
1753 1837
--
1838
-- Name: dba_preassignacccode_dba_requestnumber_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1839
--
1840

  
1841

  
1842

  
1843
--
1754 1844
-- Name: definedvalue; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1755 1845
--
1756 1846

  
......
1777 1867

  
1778 1868

  
1779 1869
--
1870
-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1871
--
1872

  
1873

  
1874

  
1875
--
1780 1876
-- Name: disturbanceobs; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1781 1877
--
1782 1878

  
......
1806 1902

  
1807 1903

  
1808 1904
--
1905
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1906
--
1907

  
1908

  
1909

  
1910
--
1809 1911
-- Name: geoscrub_input; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1810 1912
--
1811 1913

  
......
1857 1959

  
1858 1960

  
1859 1961
--
1962
-- Name: graphic_graphic_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1963
--
1964

  
1965

  
1966

  
1967
--
1860 1968
-- Name: location_location_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1861 1969
--
1862 1970

  
......
1871 1979

  
1872 1980

  
1873 1981
--
1982
-- Name: location_location_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1983
--
1984

  
1985

  
1986

  
1987
--
1874 1988
-- Name: locationevent_locationevent_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1875 1989
--
1876 1990

  
......
1885 1999

  
1886 2000

  
1887 2001
--
2002
-- Name: locationevent_locationevent_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2003
--
2004

  
2005

  
2006

  
2007
--
1888 2008
-- Name: locationeventcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1889 2009
--
1890 2010

  
......
1912 2032

  
1913 2033

  
1914 2034
--
2035
-- Name: locationeventcontributor_locationeventcontributor_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2036
--
2037

  
2038

  
2039

  
2040
--
1915 2041
-- Name: locationeventsynonym; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1916 2042
--
1917 2043

  
......
1943 2069

  
1944 2070

  
1945 2071
--
2072
-- Name: locationeventsynonym_locationeventsynonym_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2073
--
2074

  
2075

  
2076

  
2077
--
1946 2078
-- Name: locationplace_locationplace_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1947 2079
--
1948 2080

  
......
1957 2089

  
1958 2090

  
1959 2091
--
2092
-- Name: locationplace_locationplace_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2093
--
2094

  
2095

  
2096

  
2097
--
1960 2098
-- Name: method_method_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1961 2099
--
1962 2100

  
......
1971 2109

  
1972 2110

  
1973 2111
--
2112
-- Name: method_method_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2113
--
2114

  
2115

  
2116

  
2117
--
1974 2118
-- Name: methodtaxonclass; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1975 2119
--
1976 2120

  
......
2013 2157

  
2014 2158

  
2015 2159
--
2160
-- Name: methodtaxonclass_methodtaxonclass_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2161
--
2162

  
2163

  
2164

  
2165
--
2016 2166
-- Name: note; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2017 2167
--
2018 2168

  
......
2043 2193

  
2044 2194

  
2045 2195
--
2196
-- Name: note_note_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2197
--
2198

  
2199

  
2200

  
2201
--
2046 2202
-- Name: notelink; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2047 2203
--
2048 2204

  
......
2069 2225

  
2070 2226

  
2071 2227
--
2228
-- Name: notelink_notelink_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2229
--
2230

  
2231

  
2232

  
2233
--
2072 2234
-- Name: party_party_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2073 2235
--
2074 2236

  
......
2083 2245

  
2084 2246

  
2085 2247
--
2248
-- Name: party_party_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2249
--
2250

  
2251

  
2252

  
2253
--
2086 2254
-- Name: partymember; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2087 2255
--
2088 2256

  
......
2111 2279

  
2112 2280

  
2113 2281
--
2282
-- Name: partymember_partymember_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2283
--
2284

  
2285

  
2286

  
2287
--
2114 2288
-- Name: place_place_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2115 2289
--
2116 2290

  
......
2125 2299

  
2126 2300

  
2127 2301
--
2302
-- Name: place_place_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2303
--
2304

  
2305

  
2306

  
2307
--
2128 2308
-- Name: placecorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2129 2309
--
2130 2310

  
......
2151 2331

  
2152 2332

  
2153 2333
--
2334
-- Name: placecorrelation_placecorrelation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2335
--
2336

  
2337

  
2338

  
2339
--
2154 2340
-- Name: placename; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2155 2341
--
2156 2342

  
......
2201 2387

  
2202 2388

  
2203 2389
--
2390
-- Name: placename_placename_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2391
--
2392

  
2393

  
2394

  
2395
--
2204 2396
-- Name: plant; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2205 2397
--
2206 2398

  
......
2231 2423

  
2232 2424

  
2233 2425
--
2426
-- Name: plant_plant_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2427
--
2428

  
2429

  
2430

  
2431
--
2234 2432
-- Name: plantobservation_plantobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2235 2433
--
2236 2434

  
......
2245 2443

  
2246 2444

  
2247 2445
--
2446
-- Name: plantobservation_plantobservation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2447
--
2448

  
2449

  
2450

  
2451
--
2248 2452
-- Name: project; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2249 2453
--
2250 2454

  
......
2277 2481

  
2278 2482

  
2279 2483
--
2484
-- Name: project_project_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2485
--
2486

  
2487

  
2488

  
2489
--
2280 2490
-- Name: projectcontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2281 2491
--
2282 2492

  
......
2305 2515

  
2306 2516

  
2307 2517
--
2518
-- Name: projectcontributor_projectcontributor_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2519
--
2520

  
2521

  
2522

  
2523
--
2308 2524
-- Name: reference_reference_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2309 2525
--
2310 2526

  
......
2319 2535

  
2320 2536

  
2321 2537
--
2538
-- Name: reference_reference_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2539
--
2540

  
2541

  
2542

  
2543
--
2322 2544
-- Name: referencealtident; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2323 2545
--
2324 2546

  
......
2345 2567

  
2346 2568

  
2347 2569
--
2570
-- Name: referencealtident_referencealtident_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2571
--
2572

  
2573

  
2574

  
2575
--
2348 2576
-- Name: referencecontributor; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2349 2577
--
2350 2578

  
......
2372 2600

  
2373 2601

  
2374 2602
--
2603
-- Name: referencecontributor_referencecontributor_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2604
--
2605

  
2606

  
2607

  
2608
--
2375 2609
-- Name: referencejournal; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2376 2610
--
2377 2611

  
......
2399 2633

  
2400 2634

  
2401 2635
--
2636
-- Name: referencejournal_referencejournal_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2637
--
2638

  
2639

  
2640

  
2641
--
2402 2642
-- Name: referenceparty; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2403 2643
--
2404 2644

  
......
2431 2671

  
2432 2672

  
2433 2673
--
2674
-- Name: referenceparty_referenceparty_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2675
--
2676

  
2677

  
2678

  
2679
--
2434 2680
-- Name: revision; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2435 2681
--
2436 2682

  
......
2461 2707

  
2462 2708

  
2463 2709
--
2710
-- Name: revision_revision_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2711
--
2712

  
2713

  
2714

  
2715
--
2464 2716
-- Name: soilobs; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2465 2717
--
2466 2718

  
......
2508 2760

  
2509 2761

  
2510 2762
--
2763
-- Name: soilobs_soilobs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2764
--
2765

  
2766

  
2767

  
2768
--
2511 2769
-- Name: soiltaxon; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2512 2770
--
2513 2771

  
......
2537 2795

  
2538 2796

  
2539 2797
--
2798
-- Name: soiltaxon_soiltaxon_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2799
--
2800

  
2801

  
2802

  
2803
--
2540 2804
-- Name: specimen; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2541 2805
--
2542 2806

  
......
2567 2831

  
2568 2832

  
2569 2833
--
2834
-- Name: specimen_specimen_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2835
--
2836

  
2837

  
2838

  
2839
--
2570 2840
-- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2571 2841
--
2572 2842

  
......
2581 2851

  
2582 2852

  
2583 2853
--
2854
-- Name: specimenreplicate_specimenreplicate_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2855
--
2856

  
2857

  
2858

  
2859
--
2584 2860
-- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2585 2861
--
2586 2862

  
......
2595 2871

  
2596 2872

  
2597 2873
--
2874
-- Name: stemobservation_stemobservation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2875
--
2876

  
2877

  
2878

  
2879
--
2598 2880
-- Name: stratum; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2599 2881
--
2600 2882

  
......
2624 2906

  
2625 2907

  
2626 2908
--
2909
-- Name: stratum_stratum_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2910
--
2911

  
2912

  
2913

  
2914
--
2627 2915
-- Name: taxonalt; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2628 2916
--
2629 2917

  
......
2652 2940

  
2653 2941

  
2654 2942
--
2943
-- Name: taxonalt_taxonalt_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2944
--
2945

  
2946

  
2947

  
2948
--
2655 2949
-- Name: taxonconcept; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2656 2950
--
2657 2951

  
......
2690 2984

  
2691 2985

  
2692 2986
--
2987
-- Name: taxonconcept_taxonlabel_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2988
--
2989

  
2990

  
2991

  
2992
--
2693 2993
-- Name: taxoncorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2694 2994
--
2695 2995

  
......
2718 3018

  
2719 3019

  
2720 3020
--
3021
-- Name: taxoncorrelation_taxoncorrelation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3022
--
3023

  
3024

  
3025

  
3026
--
2721 3027
-- Name: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2722 3028
--
2723 3029

  
......
2732 3038

  
2733 3039

  
2734 3040
--
3041
-- Name: taxondetermination_taxondetermination_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3042
--
3043

  
3044

  
3045

  
3046
--
2735 3047
-- Name: taxonlabel_relationship; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2736 3048
--
2737 3049

  
......
2771 3083

  
2772 3084

  
2773 3085
--
3086
-- Name: taxonlabel_taxonlabel_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3087
--
3088

  
3089

  
3090

  
3091
--
2774 3092
-- Name: taxonlineage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2775 3093
--
2776 3094

  
......
2796 3114

  
2797 3115

  
2798 3116
--
3117
-- Name: taxonlineage_taxonlineage_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3118
--
3119

  
3120

  
3121

  
3122
--
2799 3123
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2800 3124
--
2801 3125

  
......
2810 3134

  
2811 3135

  
2812 3136
--
3137
-- Name: taxonoccurrence_taxonoccurrence_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3138
--
3139

  
3140

  
3141

  
3142
--
2813 3143
-- Name: taxonstatus; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2814 3144
--
2815 3145

  
......
2841 3171

  
2842 3172

  
2843 3173
--
3174
-- Name: taxonstatus_taxonstatus_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3175
--
3176

  
3177

  
3178

  
3179
--
2844 3180
-- Name: taxonverbatim_taxonverbatim_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2845 3181
--
2846 3182

  
......
2855 3191

  
2856 3192

  
2857 3193
--
3194
-- Name: taxonverbatim_taxonverbatim_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3195
--
3196

  
3197

  
3198

  
3199
--
2858 3200
-- Name: telephone; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2859 3201
--
2860 3202

  
......
2881 3223

  
2882 3224

  
2883 3225
--
3226
-- Name: telephone_telephone_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3227
--
3228

  
3229

  
3230

  
3231
--
2884 3232
-- Name: tnrs_input_name; Type: VIEW; Schema: public; Owner: -
2885 3233
--
2886 3234

  
......
2914 3262

  
2915 3263

  
2916 3264
--
3265
-- Name: trait_trait_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3266
--
3267

  
3268

  
3269

  
3270
--
2917 3271
-- Name: userdefined; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2918 3272
--
2919 3273

  
......
2943 3297

  
2944 3298

  
2945 3299
--
3300
-- Name: userdefined_userdefined_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3301
--
3302

  
3303

  
3304

  
3305
--
2946 3306
-- Name: voucher; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2947 3307
--
2948 3308

  
......
2968 3328

  
2969 3329

  
2970 3330
--
3331
-- Name: voucher_voucher_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
3332
--
3333

  
3334

  
3335

  
3336
--
2971 3337
-- Name: address_id; Type: DEFAULT; Schema: public; Owner: -
2972 3338
--
2973 3339

  
......
3381 3747

  
3382 3748

  
3383 3749
--
3750
-- Data for Name: address; Type: TABLE DATA; Schema: public; Owner: -
3751
--
3752

  
3753

  
3754

  
3755

  
3756
--
3757
-- Data for Name: aggregateoccurrence; Type: TABLE DATA; Schema: public; Owner: -
3758
--
3759

  
3760

  
3761

  
3762

  
3763
--
3764
-- Data for Name: analytical_aggregate; Type: TABLE DATA; Schema: public; Owner: -
3765
--
3766

  
3767

  
3768

  
3769

  
3770
--
3771
-- Data for Name: analytical_stem; Type: TABLE DATA; Schema: public; Owner: -
3772
--
3773

  
3774

  
3775

  
3776

  
3777
--
3778
-- Data for Name: classcontributor; Type: TABLE DATA; Schema: public; Owner: -
3779
--
3780

  
3781

  
3782

  
3783

  
3784
--
3785
-- Data for Name: commclass; Type: TABLE DATA; Schema: public; Owner: -
3786
--
3787

  
3788

  
3789

  
3790

  
3791
--
3792
-- Data for Name: commconcept; Type: TABLE DATA; Schema: public; Owner: -
3793
--
3794

  
3795

  
3796

  
3797

  
3798
--
3799
-- Data for Name: commcorrelation; Type: TABLE DATA; Schema: public; Owner: -
3800
--
3801

  
3802

  
3803

  
3804

  
3805
--
3806
-- Data for Name: commdetermination; Type: TABLE DATA; Schema: public; Owner: -
3807
--
3808

  
3809

  
3810

  
3811

  
3812
--
3813
-- Data for Name: commlineage; Type: TABLE DATA; Schema: public; Owner: -
3814
--
3815

  
3816

  
3817

  
3818

  
3819
--
3820
-- Data for Name: commname; Type: TABLE DATA; Schema: public; Owner: -
3821
--
3822

  
3823

  
3824

  
3825

  
3826
--
3827
-- Data for Name: commstatus; Type: TABLE DATA; Schema: public; Owner: -
3828
--
3829

  
3830

  
3831

  
3832

  
3833
--
3834
-- Data for Name: commusage; Type: TABLE DATA; Schema: public; Owner: -
3835
--
3836

  
3837

  
3838

  
3839

  
3840
--
3841
-- Data for Name: coordinates; Type: TABLE DATA; Schema: public; Owner: -
3842
--
3843

  
3844

  
3845

  
3846

  
3847
--
3848
-- Data for Name: coverindex; Type: TABLE DATA; Schema: public; Owner: -
3849
--
3850

  
3851

  
3852

  
3853

  
3854
--
3855
-- Data for Name: covermethod; Type: TABLE DATA; Schema: public; Owner: -
3856
--
3857

  
3858

  
3859

  
3860

  
3861
--
3862
-- Data for Name: definedvalue; Type: TABLE DATA; Schema: public; Owner: -
3863
--
3864

  
3865

  
3866

  
3867

  
3868
--
3869
-- Data for Name: disturbanceobs; Type: TABLE DATA; Schema: public; Owner: -
3870
--
3871

  
3872

  
3873

  
3874

  
3875
--
3876
-- Data for Name: geoscrub_input; Type: TABLE DATA; Schema: public; Owner: -
3877
--
3878

  
3879

  
3880

  
3881

  
3882
--
3883
-- Data for Name: graphic; Type: TABLE DATA; Schema: public; Owner: -
3884
--
3885

  
3886

  
3887

  
3888

  
3889
--
3890
-- Data for Name: location; Type: TABLE DATA; Schema: public; Owner: -
3891
--
3892

  
3893

  
3894

  
3895

  
3896
--
3897
-- Data for Name: locationevent; Type: TABLE DATA; Schema: public; Owner: -
3898
--
3899

  
3900

  
3901

  
3902

  
3903
--
3904
-- Data for Name: locationeventcontributor; Type: TABLE DATA; Schema: public; Owner: -
3905
--
3906

  
3907

  
3908

  
3909

  
3910
--
3911
-- Data for Name: locationeventsynonym; Type: TABLE DATA; Schema: public; Owner: -
3912
--
3913

  
3914

  
3915

  
3916

  
3917
--
3918
-- Data for Name: locationplace; Type: TABLE DATA; Schema: public; Owner: -
3919
--
3920

  
3921

  
3922

  
3923

  
3924
--
3925
-- Data for Name: method; Type: TABLE DATA; Schema: public; Owner: -
3926
--
3927

  
3928

  
3929

  
3930

  
3931
--
3932
-- Data for Name: methodtaxonclass; Type: TABLE DATA; Schema: public; Owner: -
3933
--
3934

  
3935

  
3936

  
3937

  
3938
--
3939
-- Data for Name: note; Type: TABLE DATA; Schema: public; Owner: -
3940
--
3941

  
3942

  
3943

  
3944

  
3945
--
3946
-- Data for Name: notelink; Type: TABLE DATA; Schema: public; Owner: -
3947
--
3948

  
3949

  
3950

  
3951

  
3952
--
3953
-- Data for Name: party; Type: TABLE DATA; Schema: public; Owner: -
3954
--
3955

  
3956

  
3957

  
3958

  
3959
--
3960
-- Data for Name: partymember; Type: TABLE DATA; Schema: public; Owner: -
3961
--
3962

  
3963

  
3964

  
3965

  
3966
--
3967
-- Data for Name: place; Type: TABLE DATA; Schema: public; Owner: -
3968
--
3969

  
3970

  
3971

  
3972

  
3973
--
3974
-- Data for Name: placecorrelation; Type: TABLE DATA; Schema: public; Owner: -
3975
--
3976

  
3977

  
3978

  
3979

  
3980
--
3981
-- Data for Name: placename; Type: TABLE DATA; Schema: public; Owner: -
3982
--
3983

  
3984

  
3985

  
3986

  
3987
--
3988
-- Data for Name: placename_ancestor; Type: TABLE DATA; Schema: public; Owner: -
3989
--
3990

  
3991

  
3992

  
3993

  
3994
--
3995
-- Data for Name: plant; Type: TABLE DATA; Schema: public; Owner: -
3996
--
3997

  
3998

  
3999

  
4000

  
4001
--
4002
-- Data for Name: plantobservation; Type: TABLE DATA; Schema: public; Owner: -
4003
--
4004

  
4005

  
4006

  
4007

  
4008
--
4009
-- Data for Name: project; Type: TABLE DATA; Schema: public; Owner: -
4010
--
4011

  
4012

  
4013

  
4014

  
4015
--
4016
-- Data for Name: projectcontributor; Type: TABLE DATA; Schema: public; Owner: -
4017
--
4018

  
4019

  
4020

  
4021

  
4022
--
4023
-- Data for Name: reference; Type: TABLE DATA; Schema: public; Owner: -
4024
--
4025

  
4026

  
4027

  
4028

  
4029
--
4030
-- Data for Name: referencealtident; Type: TABLE DATA; Schema: public; Owner: -
4031
--
4032

  
4033

  
4034

  
4035

  
4036
--
4037
-- Data for Name: referencecontributor; Type: TABLE DATA; Schema: public; Owner: -
4038
--
4039

  
4040

  
4041

  
4042

  
4043
--
4044
-- Data for Name: referencejournal; Type: TABLE DATA; Schema: public; Owner: -
4045
--
4046

  
4047

  
4048

  
4049

  
4050
--
4051
-- Data for Name: referenceparty; Type: TABLE DATA; Schema: public; Owner: -
4052
--
4053

  
4054

  
4055

  
4056

  
4057
--
4058
-- Data for Name: revision; Type: TABLE DATA; Schema: public; Owner: -
4059
--
4060

  
4061

  
4062

  
4063

  
4064
--
4065
-- Data for Name: soilobs; Type: TABLE DATA; Schema: public; Owner: -
4066
--
4067

  
4068

  
4069

  
4070

  
4071
--
4072
-- Data for Name: soiltaxon; Type: TABLE DATA; Schema: public; Owner: -
4073
--
4074

  
4075

  
4076

  
4077

  
4078
--
4079
-- Data for Name: specimen; Type: TABLE DATA; Schema: public; Owner: -
4080
--
4081

  
4082

  
4083

  
4084

  
4085
--
4086
-- Data for Name: specimenreplicate; Type: TABLE DATA; Schema: public; Owner: -
4087
--
4088

  
4089

  
4090

  
4091

  
4092
--
4093
-- Data for Name: stemobservation; Type: TABLE DATA; Schema: public; Owner: -
4094
--
4095

  
4096

  
4097

  
4098

  
4099
--
4100
-- Data for Name: stratum; Type: TABLE DATA; Schema: public; Owner: -
4101
--
4102

  
4103

  
4104

  
4105

  
4106
--
4107
-- Data for Name: taxonalt; Type: TABLE DATA; Schema: public; Owner: -
4108
--
4109

  
4110

  
4111

  
4112

  
4113
--
4114
-- Data for Name: taxonconcept; Type: TABLE DATA; Schema: public; Owner: -
4115
--
4116

  
4117

  
4118

  
4119

  
4120
--
4121
-- Data for Name: taxoncorrelation; Type: TABLE DATA; Schema: public; Owner: -
4122
--
4123

  
4124

  
4125

  
4126

  
4127
--
4128
-- Data for Name: taxondetermination; Type: TABLE DATA; Schema: public; Owner: -
4129
--
4130

  
4131

  
4132

  
4133

  
4134
--
4135
-- Data for Name: taxonlabel; Type: TABLE DATA; Schema: public; Owner: -
4136
--
4137

  
4138

  
4139

  
4140

  
4141
--
4142
-- Data for Name: taxonlabel_relationship; Type: TABLE DATA; Schema: public; Owner: -
4143
--
4144

  
4145

  
4146

  
4147

  
4148
--
4149
-- Data for Name: taxonlineage; Type: TABLE DATA; Schema: public; Owner: -
4150
--
4151

  
4152

  
4153

  
4154

  
4155
--
4156
-- Data for Name: taxonoccurrence; Type: TABLE DATA; Schema: public; Owner: -
4157
--
4158

  
4159

  
4160

  
4161

  
4162
--
4163
-- Data for Name: taxonstatus; Type: TABLE DATA; Schema: public; Owner: -
4164
--
4165

  
4166

  
4167

  
4168

  
4169
--
4170
-- Data for Name: taxonverbatim; Type: TABLE DATA; Schema: public; Owner: -
4171
--
4172

  
4173

  
4174

  
4175

  
4176
--
4177
-- Data for Name: telephone; Type: TABLE DATA; Schema: public; Owner: -
4178
--
4179

  
4180

  
4181

  
4182

  
4183
--
4184
-- Data for Name: trait; Type: TABLE DATA; Schema: public; Owner: -
4185
--
4186

  
4187

  
4188

  
4189

  
4190
--
4191
-- Data for Name: userdefined; Type: TABLE DATA; Schema: public; Owner: -
4192
--
4193

  
4194

  
4195

  
4196

  
4197
--
4198
-- Data for Name: voucher; Type: TABLE DATA; Schema: public; Owner: -
4199
--
4200

  
4201

  
4202

  
4203

  
4204
--
3384 4205
-- Name: address_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
3385 4206
--
3386 4207

  
schemas/Makefile
30 30

  
31 31
##### DDLs
32 32

  
33
pg_dump = ../bin/pg_dump_vegbien $(1) >$@
33
pg_dump = env schema= ../bin/pg_dump_vegbien $(1) >$@
34 34

  
35 35
vegbien.sql:
36 36
	$(call pg_dump,public)
schemas/vegbien.sql
1146 1146

  
1147 1147

  
1148 1148
--
1149
-- Name: address_address_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1150
--
1151

  
1152

  
1153

  
1154
--
1149 1155
-- Name: aggregateoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1150 1156
--
1151 1157

  
......
1212 1218

  
1213 1219

  
1214 1220
--
1221
-- Name: aggregateoccurrence_aggregateoccurrence_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
1222
--
1223

  
1224

  
1225

  
1226
--
1215 1227
-- Name: analytical_aggregate; Type: TABLE; Schema: public; Owner: -; Tablespace: 
1216 1228
--
1217 1229

  
......
2066 2078

  
2067 2079

  
2068 2080
--
2081
-- Name: classcontributor_classcontributor_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2082
--
2083

  
2084

  
2085

  
2086
--
2069 2087
-- Name: commclass; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2070 2088
--
2071 2089

  
......
2108 2126

  
2109 2127

  
2110 2128
--
2129
-- Name: commclass_commclass_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2130
--
2131

  
2132

  
2133

  
2134
--
2111 2135
-- Name: commconcept; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2112 2136
--
2113 2137

  
......
2143 2167

  
2144 2168

  
2145 2169
--
2170
-- Name: commconcept_commconcept_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2171
--
2172

  
2173

  
2174

  
2175
--
2146 2176
-- Name: commcorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2147 2177
--
2148 2178

  
......
2176 2206

  
2177 2207

  
2178 2208
--
2209
-- Name: commcorrelation_commcorrelation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2210
--
2211

  
2212

  
2213

  
2214
--
2179 2215
-- Name: commdetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2180 2216
--
2181 2217

  
......
2214 2250

  
2215 2251

  
2216 2252
--
2253
-- Name: commdetermination_commdetermination_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2254
--
2255

  
2256

  
2257

  
2258
--
2217 2259
-- Name: commlineage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2218 2260
--
2219 2261

  
......
2244 2286

  
2245 2287

  
2246 2288
--
2289
-- Name: commlineage_commlineage_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2290
--
2291

  
2292

  
2293

  
2294
--
2247 2295
-- Name: commname; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2248 2296
--
2249 2297

  
......
2275 2323

  
2276 2324

  
2277 2325
--
2326
-- Name: commname_commname_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2327
--
2328

  
2329

  
2330

  
2331
--
2278 2332
-- Name: commstatus; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2279 2333
--
2280 2334

  
......
2313 2367

  
2314 2368

  
2315 2369
--
2370
-- Name: commstatus_commstatus_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2371
--
2372

  
2373

  
2374

  
2375
--
2316 2376
-- Name: commusage; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2317 2377
--
2318 2378

  
......
2350 2410

  
2351 2411

  
2352 2412
--
2413
-- Name: commusage_commusage_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2414
--
2415

  
2416

  
2417

  
2418
--
2353 2419
-- Name: coordinates_coordinates_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2354 2420
--
2355 2421

  
......
2369 2435

  
2370 2436

  
2371 2437
--
2438
-- Name: coordinates_coordinates_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2439
--
2440

  
2441

  
2442

  
2443
--
2372 2444
-- Name: coverindex; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2373 2445
--
2374 2446

  
......
2403 2475

  
2404 2476

  
2405 2477
--
2478
-- Name: coverindex_coverindex_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2479
--
2480

  
2481

  
2482

  
2483
--
2406 2484
-- Name: covermethod; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2407 2485
--
2408 2486

  
......
2435 2513

  
2436 2514

  
2437 2515
--
2516
-- Name: covermethod_covermethod_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2517
--
2518

  
2519

  
2520

  
2521
--
2438 2522
-- Name: dba_preassignacccode_dba_requestnumber_seq; Type: SEQUENCE; Schema: public; Owner: -
2439 2523
--
2440 2524

  
......
2447 2531

  
2448 2532

  
2449 2533
--
2534
-- Name: dba_preassignacccode_dba_requestnumber_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2535
--
2536

  
2537

  
2538

  
2539
--
2450 2540
-- Name: definedvalue; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2451 2541
--
2452 2542

  
......
2478 2568

  
2479 2569

  
2480 2570
--
2571
-- Name: definedvalue_definedvalue_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2572
--
2573

  
2574

  
2575

  
2576
--
2481 2577
-- Name: disturbanceobs; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2482 2578
--
2483 2579

  
......
2512 2608

  
2513 2609

  
2514 2610
--
2611
-- Name: disturbanceobs_disturbanceobs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
2612
--
2613

  
2614

  
2615

  
2616
--
2515 2617
-- Name: geoscrub_input; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2516 2618
--
2517 2619

  
......
2569 2671

  
2570 2672

  
2571 2673
--
... This diff was truncated because it exceeds the maximum size that can be displayed.

Also available in: Unified diff