Revision 4390
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 1135 | 1135 |
|
| 1136 | 1136 |
|
| 1137 | 1137 |
|
| 1138 |
|
|
| 1139 |
|
|
| 1140 | 1138 |
-- |
| 1141 | 1139 |
-- Name: methodtaxonclass; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1142 | 1140 |
-- |
| ... | ... | |
| 1179 | 1177 |
|
| 1180 | 1178 |
|
| 1181 | 1179 |
|
| 1182 |
|
|
| 1183 |
|
|
| 1184 | 1180 |
-- |
| 1185 | 1181 |
-- Name: namedplace; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1186 | 1182 |
-- |
| ... | ... | |
| 1196 | 1192 |
); |
| 1197 | 1193 |
|
| 1198 | 1194 |
|
| 1199 |
|
|
| 1200 |
|
|
| 1201 | 1195 |
-- |
| 1202 | 1196 |
-- Name: namedplace_ancestor; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1203 | 1197 |
-- |
| ... | ... | |
| 1222 | 1216 |
|
| 1223 | 1217 |
|
| 1224 | 1218 |
|
| 1225 |
|
|
| 1226 |
|
|
| 1227 | 1219 |
-- |
| 1228 | 1220 |
-- Name: namedplacecorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1229 | 1221 |
-- |
| ... | ... | |
| 1369 | 1361 |
|
| 1370 | 1362 |
|
| 1371 | 1363 |
|
| 1372 |
|
|
| 1373 |
|
|
| 1374 | 1364 |
-- |
| 1375 | 1365 |
-- Name: plant; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1376 | 1366 |
-- |
| ... | ... | |
| 1401 | 1391 |
|
| 1402 | 1392 |
|
| 1403 | 1393 |
|
| 1404 |
|
|
| 1405 |
|
|
| 1406 | 1394 |
-- |
| 1407 | 1395 |
-- Name: plantconcept; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1408 | 1396 |
-- |
| ... | ... | |
| 1497 | 1485 |
); |
| 1498 | 1486 |
|
| 1499 | 1487 |
|
| 1500 |
|
|
| 1501 |
|
|
| 1502 | 1488 |
-- |
| 1503 | 1489 |
-- Name: plantname_ancestor; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1504 | 1490 |
-- |
| ... | ... | |
| 1549 | 1535 |
|
| 1550 | 1536 |
|
| 1551 | 1537 |
|
| 1552 |
|
|
| 1553 |
|
|
| 1554 | 1538 |
-- |
| 1555 | 1539 |
-- Name: plantobservation; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1556 | 1540 |
-- |
| ... | ... | |
| 2086 | 2070 |
|
| 2087 | 2071 |
|
| 2088 | 2072 |
|
| 2089 |
|
|
| 2090 |
|
|
| 2091 | 2073 |
-- |
| 2092 | 2074 |
-- Name: specimen; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 2093 | 2075 |
-- |
| ... | ... | |
| 2118 | 2100 |
|
| 2119 | 2101 |
|
| 2120 | 2102 |
|
| 2121 |
|
|
| 2122 |
|
|
| 2123 | 2103 |
-- |
| 2124 | 2104 |
-- Name: specimenreplicate; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 2125 | 2105 |
-- |
| ... | ... | |
| 2218 | 2198 |
|
| 2219 | 2199 |
|
| 2220 | 2200 |
|
| 2221 |
|
|
| 2222 |
|
|
| 2223 | 2201 |
-- |
| 2224 | 2202 |
-- Name: stemtag; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 2225 | 2203 |
-- |
| ... | ... | |
| 2246 | 2224 |
|
| 2247 | 2225 |
|
| 2248 | 2226 |
|
| 2249 |
|
|
| 2250 |
|
|
| 2251 | 2227 |
-- |
| 2252 | 2228 |
-- Name: stratum; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 2253 | 2229 |
-- |
| ... | ... | |
| 2352 | 2328 |
|
| 2353 | 2329 |
|
| 2354 | 2330 |
|
| 2355 |
|
|
| 2356 |
|
|
| 2357 | 2331 |
-- |
| 2358 | 2332 |
-- Name: taxonoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 2359 | 2333 |
-- |
| ... | ... | |
| 2415 | 2389 |
|
| 2416 | 2390 |
|
| 2417 | 2391 |
|
| 2418 |
|
|
| 2419 |
|
|
| 2420 | 2392 |
-- |
| 2421 | 2393 |
-- Name: telephone; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 2422 | 2394 |
-- |
| ... | ... | |
| 2443 | 2415 |
|
| 2444 | 2416 |
|
| 2445 | 2417 |
|
| 2446 |
|
|
| 2447 |
|
|
| 2448 | 2418 |
-- |
| 2449 | 2419 |
-- Name: trait; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 2450 | 2420 |
-- |
| ... | ... | |
| 2471 | 2441 |
|
| 2472 | 2442 |
|
| 2473 | 2443 |
|
| 2474 |
|
|
| 2475 |
|
|
| 2476 | 2444 |
-- |
| 2477 | 2445 |
-- Name: userdefined; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 2478 | 2446 |
-- |
| ... | ... | |
| 2502 | 2470 |
|
| 2503 | 2471 |
|
| 2504 | 2472 |
|
| 2505 |
|
|
| 2506 |
|
|
| 2507 | 2473 |
-- |
| 2508 | 2474 |
-- Name: voucher; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 2509 | 2475 |
-- |
| schemas/vegbien.sql | ||
|---|---|---|
| 310 | 310 |
|
| 311 | 311 |
SET default_tablespace = ''; |
| 312 | 312 |
|
| 313 |
SET default_with_oids = true;
|
|
| 313 |
SET default_with_oids = false;
|
|
| 314 | 314 |
|
| 315 | 315 |
-- |
| 316 | 316 |
-- Name: address; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| ... | ... | |
| 1475 | 1475 |
ALTER SEQUENCE method_method_id_seq OWNED BY method.method_id; |
| 1476 | 1476 |
|
| 1477 | 1477 |
|
| 1478 |
SET default_with_oids = false; |
|
| 1479 |
|
|
| 1480 | 1478 |
-- |
| 1481 | 1479 |
-- Name: methodtaxonclass; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1482 | 1480 |
-- |
| ... | ... | |
| 1525 | 1523 |
ALTER SEQUENCE methodtaxonclass_methodtaxonclass_id_seq OWNED BY methodtaxonclass.methodtaxonclass_id; |
| 1526 | 1524 |
|
| 1527 | 1525 |
|
| 1528 |
SET default_with_oids = true; |
|
| 1529 |
|
|
| 1530 | 1526 |
-- |
| 1531 | 1527 |
-- Name: namedplace; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1532 | 1528 |
-- |
| ... | ... | |
| 1542 | 1538 |
); |
| 1543 | 1539 |
|
| 1544 | 1540 |
|
| 1545 |
SET default_with_oids = false; |
|
| 1546 |
|
|
| 1547 | 1541 |
-- |
| 1548 | 1542 |
-- Name: namedplace_ancestor; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1549 | 1543 |
-- |
| ... | ... | |
| 1573 | 1567 |
ALTER SEQUENCE namedplace_namedplace_id_seq OWNED BY namedplace.namedplace_id; |
| 1574 | 1568 |
|
| 1575 | 1569 |
|
| 1576 |
SET default_with_oids = true; |
|
| 1577 |
|
|
| 1578 | 1570 |
-- |
| 1579 | 1571 |
-- Name: namedplacecorrelation; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1580 | 1572 |
-- |
| ... | ... | |
| 1745 | 1737 |
ALTER SEQUENCE partymember_partymember_id_seq OWNED BY partymember.partymember_id; |
| 1746 | 1738 |
|
| 1747 | 1739 |
|
| 1748 |
SET default_with_oids = false; |
|
| 1749 |
|
|
| 1750 | 1740 |
-- |
| 1751 | 1741 |
-- Name: plant; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1752 | 1742 |
-- |
| ... | ... | |
| 1782 | 1772 |
ALTER SEQUENCE plant_plant_id_seq OWNED BY plant.plant_id; |
| 1783 | 1773 |
|
| 1784 | 1774 |
|
| 1785 |
SET default_with_oids = true; |
|
| 1786 |
|
|
| 1787 | 1775 |
-- |
| 1788 | 1776 |
-- Name: plantconcept; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1789 | 1777 |
-- |
| ... | ... | |
| 1893 | 1881 |
); |
| 1894 | 1882 |
|
| 1895 | 1883 |
|
| 1896 |
SET default_with_oids = false; |
|
| 1897 |
|
|
| 1898 | 1884 |
-- |
| 1899 | 1885 |
-- Name: plantname_ancestor; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1900 | 1886 |
-- |
| ... | ... | |
| 1956 | 1942 |
ALTER SEQUENCE plantnamescope_plantnamescope_id_seq OWNED BY plantnamescope.plantnamescope_id; |
| 1957 | 1943 |
|
| 1958 | 1944 |
|
| 1959 |
SET default_with_oids = true; |
|
| 1960 |
|
|
| 1961 | 1945 |
-- |
| 1962 | 1946 |
-- Name: plantobservation; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1963 | 1947 |
-- |
| ... | ... | |
| 2558 | 2542 |
ALTER SEQUENCE soiltaxon_soiltaxon_id_seq OWNED BY soiltaxon.soiltaxon_id; |
| 2559 | 2543 |
|
| 2560 | 2544 |
|
| 2561 |
SET default_with_oids = false; |
|
| 2562 |
|
|
| 2563 | 2545 |
-- |
| 2564 | 2546 |
-- Name: specimen; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 2565 | 2547 |
-- |
| ... | ... | |
| 2595 | 2577 |
ALTER SEQUENCE specimen_specimen_id_seq OWNED BY specimen.specimen_id; |
| 2596 | 2578 |
|
| 2597 | 2579 |
|
| 2598 |
SET default_with_oids = true; |
|
| 2599 |
|
|
| 2600 | 2580 |
-- |
| 2601 | 2581 |
-- Name: specimenreplicate; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 2602 | 2582 |
-- |
| ... | ... | |
| 2706 | 2686 |
ALTER SEQUENCE stemobservation_stemobservation_id_seq OWNED BY stemobservation.stemobservation_id; |
| 2707 | 2687 |
|
| 2708 | 2688 |
|
| 2709 |
SET default_with_oids = false; |
|
| 2710 |
|
|
| 2711 | 2689 |
-- |
| 2712 | 2690 |
-- Name: stemtag; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 2713 | 2691 |
-- |
| ... | ... | |
| 2739 | 2717 |
ALTER SEQUENCE stemtag_stemtag_id_seq OWNED BY stemtag.stemtag_id; |
| 2740 | 2718 |
|
| 2741 | 2719 |
|
| 2742 |
SET default_with_oids = true; |
|
| 2743 |
|
|
| 2744 | 2720 |
-- |
| 2745 | 2721 |
-- Name: stratum; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 2746 | 2722 |
-- |
| ... | ... | |
| 2860 | 2836 |
ALTER SEQUENCE taxondetermination_taxondetermination_id_seq OWNED BY taxondetermination.taxondetermination_id; |
| 2861 | 2837 |
|
| 2862 | 2838 |
|
| 2863 |
SET default_with_oids = false; |
|
| 2864 |
|
|
| 2865 | 2839 |
-- |
| 2866 | 2840 |
-- Name: taxonoccurrence; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 2867 | 2841 |
-- |
| ... | ... | |
| 2928 | 2902 |
ALTER SEQUENCE taxonoccurrence_taxonoccurrence_id_seq OWNED BY taxonoccurrence.taxonoccurrence_id; |
| 2929 | 2903 |
|
| 2930 | 2904 |
|
| 2931 |
SET default_with_oids = true; |
|
| 2932 |
|
|
| 2933 | 2905 |
-- |
| 2934 | 2906 |
-- Name: telephone; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 2935 | 2907 |
-- |
| ... | ... | |
| 2961 | 2933 |
ALTER SEQUENCE telephone_telephone_id_seq OWNED BY telephone.telephone_id; |
| 2962 | 2934 |
|
| 2963 | 2935 |
|
| 2964 |
SET default_with_oids = false; |
|
| 2965 |
|
|
| 2966 | 2936 |
-- |
| 2967 | 2937 |
-- Name: trait; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 2968 | 2938 |
-- |
| ... | ... | |
| 2994 | 2964 |
ALTER SEQUENCE trait_trait_id_seq OWNED BY trait.trait_id; |
| 2995 | 2965 |
|
| 2996 | 2966 |
|
| 2997 |
SET default_with_oids = true; |
|
| 2998 |
|
|
| 2999 | 2967 |
-- |
| 3000 | 2968 |
-- Name: userdefined; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 3001 | 2969 |
-- |
| ... | ... | |
| 3030 | 2998 |
ALTER SEQUENCE userdefined_userdefined_id_seq OWNED BY userdefined.userdefined_id; |
| 3031 | 2999 |
|
| 3032 | 3000 |
|
| 3033 |
SET default_with_oids = false; |
|
| 3034 |
|
|
| 3035 | 3001 |
-- |
| 3036 | 3002 |
-- Name: voucher; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 3037 | 3003 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: Removed OIDs from tables because we don't use them (tables have primary keys instead)