Revision 13091
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 392 | 392 |
|
| 393 | 393 |
|
| 394 | 394 |
-- |
| 395 |
-- Name: keys_~type._specimens_03_list_of_verbatim_families; Type: TYPE; Schema: public_validations; Owner: - |
|
| 396 |
-- |
|
| 397 |
|
|
| 398 |
|
|
| 399 |
|
|
| 400 |
|
|
| 401 |
-- |
|
| 402 |
-- Name: TYPE `keys_~type._specimens_03_list_of_verbatim_families`; Type: COMMENT; Schema: public_validations; Owner: - |
|
| 403 |
-- |
|
| 404 |
|
|
| 405 |
|
|
| 406 |
|
|
| 407 |
|
|
| 408 |
-- |
|
| 395 | 409 |
-- Name: keys_~type._specimens_06_count_of_unique_verb_subsp_taxa_with_a; Type: TYPE; Schema: public_validations; Owner: - |
| 396 | 410 |
-- |
| 397 | 411 |
|
| ... | ... | |
| 462 | 476 |
|
| 463 | 477 |
|
| 464 | 478 |
-- |
| 479 |
-- Name: keys_~type._specimens_12_distinct_collector_name_collect_num_da; Type: TYPE; Schema: public_validations; Owner: - |
|
| 480 |
-- |
|
| 481 |
|
|
| 482 |
|
|
| 483 |
|
|
| 484 |
|
|
| 485 |
-- |
|
| 486 |
-- Name: TYPE `keys_~type._specimens_12_distinct_collector_name_collect_num_da`; Type: COMMENT; Schema: public_validations; Owner: - |
|
| 487 |
-- |
|
| 488 |
|
|
| 489 |
|
|
| 490 |
|
|
| 491 |
|
|
| 492 |
-- |
|
| 465 | 493 |
-- Name: keys_~type._specimens_13_count_of_all_verbatim_and_decimal_lat_; Type: TYPE; Schema: public_validations; Owner: - |
| 466 | 494 |
-- |
| 467 | 495 |
|
| ... | ... | |
| 770 | 798 |
|
| 771 | 799 |
|
| 772 | 800 |
-- |
| 801 |
-- Name: values__~type._specimens_03_list_of_verbatim_families; Type: TYPE; Schema: public_validations; Owner: - |
|
| 802 |
-- |
|
| 803 |
|
|
| 804 |
|
|
| 805 |
|
|
| 806 |
|
|
| 807 |
-- |
|
| 808 |
-- Name: TYPE `values__~type._specimens_03_list_of_verbatim_families`; Type: COMMENT; Schema: public_validations; Owner: - |
|
| 809 |
-- |
|
| 810 |
|
|
| 811 |
|
|
| 812 |
|
|
| 813 |
|
|
| 814 |
-- |
|
| 773 | 815 |
-- Name: values__~type._specimens_06_count_of_unique_verb_subsp_taxa_wit; Type: TYPE; Schema: public_validations; Owner: - |
| 774 | 816 |
-- |
| 775 | 817 |
|
| ... | ... | |
| 840 | 882 |
|
| 841 | 883 |
|
| 842 | 884 |
-- |
| 885 |
-- Name: values__~type._specimens_12_distinct_collector_name_collect_num; Type: TYPE; Schema: public_validations; Owner: - |
|
| 886 |
-- |
|
| 887 |
|
|
| 888 |
|
|
| 889 |
|
|
| 890 |
|
|
| 891 |
-- |
|
| 892 |
-- Name: TYPE `values__~type._specimens_12_distinct_collector_name_collect_num`; Type: COMMENT; Schema: public_validations; Owner: - |
|
| 893 |
-- |
|
| 894 |
|
|
| 895 |
|
|
| 896 |
|
|
| 897 |
|
|
| 898 |
-- |
|
| 843 | 899 |
-- Name: values__~type._specimens_13_count_of_all_verbatim_and_decimal_l; Type: TYPE; Schema: public_validations; Owner: - |
| 844 | 900 |
-- |
| 845 | 901 |
|
| ... | ... | |
| 2012 | 2068 |
|
| 2013 | 2069 |
|
| 2014 | 2070 |
-- |
| 2071 |
-- Name: ~type._specimens_03_list_of_verbatim_families; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2072 |
-- |
|
| 2073 |
|
|
| 2074 |
CREATE TABLE `~type._specimens_03_list_of_verbatim_families` ( |
|
| 2075 |
family varchar(255) |
|
| 2076 |
); |
|
| 2077 |
|
|
| 2078 |
|
|
| 2079 |
-- |
|
| 2080 |
-- Name: keys(`~type._specimens_03_list_of_verbatim_families`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 2081 |
-- |
|
| 2082 |
|
|
| 2083 |
|
|
| 2084 |
|
|
| 2085 |
|
|
| 2086 |
-- |
|
| 2015 | 2087 |
-- Name: ~type._specimens_06_count_of_unique_verb_subsp_taxa_with_author; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
| 2016 | 2088 |
-- |
| 2017 | 2089 |
|
| ... | ... | |
| 2093 | 2165 |
|
| 2094 | 2166 |
|
| 2095 | 2167 |
-- |
| 2168 |
-- Name: ~type._specimens_12_distinct_collector_name_collect_num_date_w_; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2169 |
-- |
|
| 2170 |
|
|
| 2171 |
CREATE TABLE `~type._specimens_12_distinct_collector_name_collect_num_date_w_` ( |
|
| 2172 |
`collectorName` varchar(255), |
|
| 2173 |
`collectionNumber` varchar(255), |
|
| 2174 |
`dateCollected` varchar(255), |
|
| 2175 |
`specimenRecords` varchar(255) |
|
| 2176 |
); |
|
| 2177 |
|
|
| 2178 |
|
|
| 2179 |
-- |
|
| 2180 |
-- Name: keys(`~type._specimens_12_distinct_collector_name_collect_num_date_w_`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 2181 |
-- |
|
| 2182 |
|
|
| 2183 |
|
|
| 2184 |
|
|
| 2185 |
|
|
| 2186 |
-- |
|
| 2096 | 2187 |
-- Name: ~type._specimens_13_count_of_all_verbatim_and_decimal_lat_long; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
| 2097 | 2188 |
-- |
| 2098 | 2189 |
|
| ... | ... | |
| 2633 | 2724 |
|
| 2634 | 2725 |
|
| 2635 | 2726 |
-- |
| 2727 |
-- Name: values_(`~type._specimens_03_list_of_verbatim_families`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 2728 |
-- |
|
| 2729 |
|
|
| 2730 |
|
|
| 2731 |
|
|
| 2732 |
|
|
| 2733 |
-- |
|
| 2636 | 2734 |
-- Name: values_(`~type._specimens_06_count_of_unique_verb_subsp_taxa_with_author`); Type: FUNCTION; Schema: public_validations; Owner: - |
| 2637 | 2735 |
-- |
| 2638 | 2736 |
|
| ... | ... | |
| 2668 | 2766 |
|
| 2669 | 2767 |
|
| 2670 | 2768 |
-- |
| 2769 |
-- Name: values_(`~type._specimens_12_distinct_collector_name_collect_num_date_w_`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 2770 |
-- |
|
| 2771 |
|
|
| 2772 |
|
|
| 2773 |
|
|
| 2774 |
|
|
| 2775 |
-- |
|
| 2671 | 2776 |
-- Name: values_(`~type._specimens_13_count_of_all_verbatim_and_decimal_lat_long`); Type: FUNCTION; Schema: public_validations; Owner: - |
| 2672 | 2777 |
-- |
| 2673 | 2778 |
|
| ... | ... | |
| 8720 | 8825 |
|
| 8721 | 8826 |
|
| 8722 | 8827 |
-- |
| 8828 |
-- Data for Name: ~type._specimens_03_list_of_verbatim_families; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 8829 |
-- |
|
| 8830 |
|
|
| 8831 |
|
|
| 8832 |
|
|
| 8833 |
-- |
|
| 8723 | 8834 |
-- Data for Name: ~type._specimens_06_count_of_unique_verb_subsp_taxa_with_author; Type: TABLE DATA; Schema: public_validations; Owner: - |
| 8724 | 8835 |
-- |
| 8725 | 8836 |
|
| ... | ... | |
| 8750 | 8861 |
|
| 8751 | 8862 |
|
| 8752 | 8863 |
-- |
| 8864 |
-- Data for Name: ~type._specimens_12_distinct_collector_name_collect_num_date_w_; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 8865 |
-- |
|
| 8866 |
|
|
| 8867 |
|
|
| 8868 |
|
|
| 8869 |
-- |
|
| 8753 | 8870 |
-- Data for Name: ~type._specimens_13_count_of_all_verbatim_and_decimal_lat_long; Type: TABLE DATA; Schema: public_validations; Owner: - |
| 8754 | 8871 |
-- |
| 8755 | 8872 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 731 | 731 |
|
| 732 | 732 |
|
| 733 | 733 |
-- |
| 734 |
-- Name: keys_~type._specimens_03_list_of_verbatim_families; Type: TYPE; Schema: public_validations; Owner: - |
|
| 735 |
-- |
|
| 736 |
|
|
| 737 |
CREATE TYPE "keys_~type._specimens_03_list_of_verbatim_families" AS ( |
|
| 738 |
family text |
|
| 739 |
); |
|
| 740 |
|
|
| 741 |
|
|
| 742 |
-- |
|
| 743 |
-- Name: TYPE "keys_~type._specimens_03_list_of_verbatim_families"; Type: COMMENT; Schema: public_validations; Owner: - |
|
| 744 |
-- |
|
| 745 |
|
|
| 746 |
COMMENT ON TYPE "keys_~type._specimens_03_list_of_verbatim_families" IS ' |
|
| 747 |
autogenerated |
|
| 748 |
'; |
|
| 749 |
|
|
| 750 |
|
|
| 751 |
-- |
|
| 734 | 752 |
-- Name: keys_~type._specimens_06_count_of_unique_verb_subsp_taxa_with_a; Type: TYPE; Schema: public_validations; Owner: - |
| 735 | 753 |
-- |
| 736 | 754 |
|
| ... | ... | |
| 819 | 837 |
|
| 820 | 838 |
|
| 821 | 839 |
-- |
| 840 |
-- Name: keys_~type._specimens_12_distinct_collector_name_collect_num_da; Type: TYPE; Schema: public_validations; Owner: - |
|
| 841 |
-- |
|
| 842 |
|
|
| 843 |
CREATE TYPE "keys_~type._specimens_12_distinct_collector_name_collect_num_da" AS ( |
|
| 844 |
"collectorName" text, |
|
| 845 |
"collectionNumber" text, |
|
| 846 |
"dateCollected" text |
|
| 847 |
); |
|
| 848 |
|
|
| 849 |
|
|
| 850 |
-- |
|
| 851 |
-- Name: TYPE "keys_~type._specimens_12_distinct_collector_name_collect_num_da"; Type: COMMENT; Schema: public_validations; Owner: - |
|
| 852 |
-- |
|
| 853 |
|
|
| 854 |
COMMENT ON TYPE "keys_~type._specimens_12_distinct_collector_name_collect_num_da" IS ' |
|
| 855 |
autogenerated |
|
| 856 |
'; |
|
| 857 |
|
|
| 858 |
|
|
| 859 |
-- |
|
| 822 | 860 |
-- Name: keys_~type._specimens_13_count_of_all_verbatim_and_decimal_lat_; Type: TYPE; Schema: public_validations; Owner: - |
| 823 | 861 |
-- |
| 824 | 862 |
|
| ... | ... | |
| 1225 | 1263 |
|
| 1226 | 1264 |
|
| 1227 | 1265 |
-- |
| 1266 |
-- Name: values__~type._specimens_03_list_of_verbatim_families; Type: TYPE; Schema: public_validations; Owner: - |
|
| 1267 |
-- |
|
| 1268 |
|
|
| 1269 |
CREATE TYPE "values__~type._specimens_03_list_of_verbatim_families" AS ( |
|
| 1270 |
family text |
|
| 1271 |
); |
|
| 1272 |
|
|
| 1273 |
|
|
| 1274 |
-- |
|
| 1275 |
-- Name: TYPE "values__~type._specimens_03_list_of_verbatim_families"; Type: COMMENT; Schema: public_validations; Owner: - |
|
| 1276 |
-- |
|
| 1277 |
|
|
| 1278 |
COMMENT ON TYPE "values__~type._specimens_03_list_of_verbatim_families" IS ' |
|
| 1279 |
autogenerated |
|
| 1280 |
'; |
|
| 1281 |
|
|
| 1282 |
|
|
| 1283 |
-- |
|
| 1228 | 1284 |
-- Name: values__~type._specimens_06_count_of_unique_verb_subsp_taxa_wit; Type: TYPE; Schema: public_validations; Owner: - |
| 1229 | 1285 |
-- |
| 1230 | 1286 |
|
| ... | ... | |
| 1315 | 1371 |
|
| 1316 | 1372 |
|
| 1317 | 1373 |
-- |
| 1374 |
-- Name: values__~type._specimens_12_distinct_collector_name_collect_num; Type: TYPE; Schema: public_validations; Owner: - |
|
| 1375 |
-- |
|
| 1376 |
|
|
| 1377 |
CREATE TYPE "values__~type._specimens_12_distinct_collector_name_collect_num" AS ( |
|
| 1378 |
"specimenRecords" bigint |
|
| 1379 |
); |
|
| 1380 |
|
|
| 1381 |
|
|
| 1382 |
-- |
|
| 1383 |
-- Name: TYPE "values__~type._specimens_12_distinct_collector_name_collect_num"; Type: COMMENT; Schema: public_validations; Owner: - |
|
| 1384 |
-- |
|
| 1385 |
|
|
| 1386 |
COMMENT ON TYPE "values__~type._specimens_12_distinct_collector_name_collect_num" IS ' |
|
| 1387 |
autogenerated |
|
| 1388 |
'; |
|
| 1389 |
|
|
| 1390 |
|
|
| 1391 |
-- |
|
| 1318 | 1392 |
-- Name: values__~type._specimens_13_count_of_all_verbatim_and_decimal_l; Type: TYPE; Schema: public_validations; Owner: - |
| 1319 | 1393 |
-- |
| 1320 | 1394 |
|
| ... | ... | |
| 3498 | 3572 |
|
| 3499 | 3573 |
|
| 3500 | 3574 |
-- |
| 3575 |
-- Name: ~type._specimens_03_list_of_verbatim_families; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3576 |
-- |
|
| 3577 |
|
|
| 3578 |
CREATE TABLE "~type._specimens_03_list_of_verbatim_families" ( |
|
| 3579 |
family text |
|
| 3580 |
); |
|
| 3581 |
|
|
| 3582 |
|
|
| 3583 |
-- |
|
| 3584 |
-- Name: keys("~type._specimens_03_list_of_verbatim_families"); Type: FUNCTION; Schema: public_validations; Owner: -
|
|
| 3585 |
-- |
|
| 3586 |
|
|
| 3587 |
CREATE FUNCTION keys(value "~type._specimens_03_list_of_verbatim_families") RETURNS "keys_~type._specimens_03_list_of_verbatim_families" |
|
| 3588 |
LANGUAGE sql IMMUTABLE |
|
| 3589 |
AS $_$ |
|
| 3590 |
SELECT ROW($1.family)::public_validations."keys_~type._specimens_03_list_of_verbatim_families" |
|
| 3591 |
$_$; |
|
| 3592 |
|
|
| 3593 |
|
|
| 3594 |
-- |
|
| 3501 | 3595 |
-- Name: ~type._specimens_06_count_of_unique_verb_subsp_taxa_with_author; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
| 3502 | 3596 |
-- |
| 3503 | 3597 |
|
| ... | ... | |
| 3599 | 3693 |
|
| 3600 | 3694 |
|
| 3601 | 3695 |
-- |
| 3696 |
-- Name: ~type._specimens_12_distinct_collector_name_collect_num_date_w_; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3697 |
-- |
|
| 3698 |
|
|
| 3699 |
CREATE TABLE "~type._specimens_12_distinct_collector_name_collect_num_date_w_" ( |
|
| 3700 |
"collectorName" text, |
|
| 3701 |
"collectionNumber" text, |
|
| 3702 |
"dateCollected" text, |
|
| 3703 |
"specimenRecords" bigint |
|
| 3704 |
); |
|
| 3705 |
|
|
| 3706 |
|
|
| 3707 |
-- |
|
| 3708 |
-- Name: keys("~type._specimens_12_distinct_collector_name_collect_num_date_w_"); Type: FUNCTION; Schema: public_validations; Owner: -
|
|
| 3709 |
-- |
|
| 3710 |
|
|
| 3711 |
CREATE FUNCTION keys(value "~type._specimens_12_distinct_collector_name_collect_num_date_w_") RETURNS "keys_~type._specimens_12_distinct_collector_name_collect_num_da" |
|
| 3712 |
LANGUAGE sql IMMUTABLE |
|
| 3713 |
AS $_$ |
|
| 3714 |
SELECT ROW($1."collectorName", $1."collectionNumber", $1."dateCollected")::public_validations."keys_~type._specimens_12_distinct_collector_name_collect_num_da" |
|
| 3715 |
$_$; |
|
| 3716 |
|
|
| 3717 |
|
|
| 3718 |
-- |
|
| 3602 | 3719 |
-- Name: ~type._specimens_13_count_of_all_verbatim_and_decimal_lat_long; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
| 3603 | 3720 |
-- |
| 3604 | 3721 |
|
| ... | ... | |
| 4581 | 4698 |
|
| 4582 | 4699 |
|
| 4583 | 4700 |
-- |
| 4701 |
-- Name: values_("~type._specimens_03_list_of_verbatim_families"); Type: FUNCTION; Schema: public_validations; Owner: -
|
|
| 4702 |
-- |
|
| 4703 |
|
|
| 4704 |
CREATE FUNCTION values_(value "~type._specimens_03_list_of_verbatim_families") RETURNS "values__~type._specimens_03_list_of_verbatim_families" |
|
| 4705 |
LANGUAGE sql IMMUTABLE |
|
| 4706 |
AS $_$ |
|
| 4707 |
SELECT ROW($1.family)::public_validations."values__~type._specimens_03_list_of_verbatim_families" |
|
| 4708 |
$_$; |
|
| 4709 |
|
|
| 4710 |
|
|
| 4711 |
-- |
|
| 4584 | 4712 |
-- Name: values_("~type._specimens_06_count_of_unique_verb_subsp_taxa_with_author"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 4585 | 4713 |
-- |
| 4586 | 4714 |
|
| ... | ... | |
| 4636 | 4764 |
|
| 4637 | 4765 |
|
| 4638 | 4766 |
-- |
| 4767 |
-- Name: values_("~type._specimens_12_distinct_collector_name_collect_num_date_w_"); Type: FUNCTION; Schema: public_validations; Owner: -
|
|
| 4768 |
-- |
|
| 4769 |
|
|
| 4770 |
CREATE FUNCTION values_(value "~type._specimens_12_distinct_collector_name_collect_num_date_w_") RETURNS "values__~type._specimens_12_distinct_collector_name_collect_num" |
|
| 4771 |
LANGUAGE sql IMMUTABLE |
|
| 4772 |
AS $_$ |
|
| 4773 |
SELECT ROW($1."specimenRecords")::public_validations."values__~type._specimens_12_distinct_collector_name_collect_num" |
|
| 4774 |
$_$; |
|
| 4775 |
|
|
| 4776 |
|
|
| 4777 |
-- |
|
| 4639 | 4778 |
-- Name: values_("~type._specimens_13_count_of_all_verbatim_and_decimal_lat_long"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 4640 | 4779 |
-- |
| 4641 | 4780 |
|
| ... | ... | |
| 12108 | 12247 |
|
| 12109 | 12248 |
|
| 12110 | 12249 |
-- |
| 12250 |
-- Data for Name: ~type._specimens_03_list_of_verbatim_families; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 12251 |
-- |
|
| 12252 |
|
|
| 12253 |
|
|
| 12254 |
|
|
| 12255 |
-- |
|
| 12111 | 12256 |
-- Data for Name: ~type._specimens_06_count_of_unique_verb_subsp_taxa_with_author; Type: TABLE DATA; Schema: public_validations; Owner: - |
| 12112 | 12257 |
-- |
| 12113 | 12258 |
|
| ... | ... | |
| 12138 | 12283 |
|
| 12139 | 12284 |
|
| 12140 | 12285 |
-- |
| 12286 |
-- Data for Name: ~type._specimens_12_distinct_collector_name_collect_num_date_w_; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 12287 |
-- |
|
| 12288 |
|
|
| 12289 |
|
|
| 12290 |
|
|
| 12291 |
-- |
|
| 12141 | 12292 |
-- Data for Name: ~type._specimens_13_count_of_all_verbatim_and_decimal_lat_long; Type: TABLE DATA; Schema: public_validations; Owner: - |
| 12142 | 12293 |
-- |
| 12143 | 12294 |
|
Also available in: Unified diff
schemas/vegbien.sql: _specimens_13_count_of_all_verbatim_and_decimal_lat_long: ran through pipeline