Revision 13104
Added by Aaron Marcuse-Kubitza almost 11 years ago
| vegbien.my.sql | ||
|---|---|---|
| 406 | 406 |
|
| 407 | 407 |
|
| 408 | 408 |
-- |
| 409 |
-- Name: keys_~type._specimens_04_count_of_species_binomials; Type: TYPE; Schema: public_validations; Owner: - |
|
| 410 |
-- |
|
| 411 |
|
|
| 412 |
|
|
| 413 |
|
|
| 414 |
|
|
| 415 |
-- |
|
| 416 |
-- Name: TYPE `keys_~type._specimens_04_count_of_species_binomials`; Type: COMMENT; Schema: public_validations; Owner: - |
|
| 417 |
-- |
|
| 418 |
|
|
| 419 |
|
|
| 420 |
|
|
| 421 |
|
|
| 422 |
-- |
|
| 423 |
-- Name: keys_~type._specimens_05_list_of_species_binomials; Type: TYPE; Schema: public_validations; Owner: - |
|
| 424 |
-- |
|
| 425 |
|
|
| 426 |
|
|
| 427 |
|
|
| 428 |
|
|
| 429 |
-- |
|
| 430 |
-- Name: TYPE `keys_~type._specimens_05_list_of_species_binomials`; Type: COMMENT; Schema: public_validations; Owner: - |
|
| 431 |
-- |
|
| 432 |
|
|
| 433 |
|
|
| 434 |
|
|
| 435 |
|
|
| 436 |
-- |
|
| 409 | 437 |
-- Name: keys_~type._specimens_06_count_of_unique_verb_subsp_taxa_with_a; Type: TYPE; Schema: public_validations; Owner: - |
| 410 | 438 |
-- |
| 411 | 439 |
|
| ... | ... | |
| 826 | 854 |
|
| 827 | 855 |
|
| 828 | 856 |
-- |
| 857 |
-- Name: values__~type._specimens_04_count_of_species_binomials; Type: TYPE; Schema: public_validations; Owner: - |
|
| 858 |
-- |
|
| 859 |
|
|
| 860 |
|
|
| 861 |
|
|
| 862 |
|
|
| 863 |
-- |
|
| 864 |
-- Name: TYPE `values__~type._specimens_04_count_of_species_binomials`; Type: COMMENT; Schema: public_validations; Owner: - |
|
| 865 |
-- |
|
| 866 |
|
|
| 867 |
|
|
| 868 |
|
|
| 869 |
|
|
| 870 |
-- |
|
| 871 |
-- Name: values__~type._specimens_05_list_of_species_binomials; Type: TYPE; Schema: public_validations; Owner: - |
|
| 872 |
-- |
|
| 873 |
|
|
| 874 |
|
|
| 875 |
|
|
| 876 |
|
|
| 877 |
-- |
|
| 878 |
-- Name: TYPE `values__~type._specimens_05_list_of_species_binomials`; Type: COMMENT; Schema: public_validations; Owner: - |
|
| 879 |
-- |
|
| 880 |
|
|
| 881 |
|
|
| 882 |
|
|
| 883 |
|
|
| 884 |
-- |
|
| 829 | 885 |
-- Name: values__~type._specimens_06_count_of_unique_verb_subsp_taxa_wit; Type: TYPE; Schema: public_validations; Owner: - |
| 830 | 886 |
-- |
| 831 | 887 |
|
| ... | ... | |
| 2112 | 2168 |
|
| 2113 | 2169 |
|
| 2114 | 2170 |
-- |
| 2171 |
-- Name: ~type._specimens_04_count_of_species_binomials; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2172 |
-- |
|
| 2173 |
|
|
| 2174 |
CREATE TABLE `~type._specimens_04_count_of_species_binomials` ( |
|
| 2175 |
species_binomials varchar(255) |
|
| 2176 |
); |
|
| 2177 |
|
|
| 2178 |
|
|
| 2179 |
-- |
|
| 2180 |
-- Name: keys(`~type._specimens_04_count_of_species_binomials`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 2181 |
-- |
|
| 2182 |
|
|
| 2183 |
|
|
| 2184 |
|
|
| 2185 |
|
|
| 2186 |
-- |
|
| 2187 |
-- Name: ~type._specimens_05_list_of_species_binomials; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2188 |
-- |
|
| 2189 |
|
|
| 2190 |
CREATE TABLE `~type._specimens_05_list_of_species_binomials` ( |
|
| 2191 |
species_binomial varchar(255) |
|
| 2192 |
); |
|
| 2193 |
|
|
| 2194 |
|
|
| 2195 |
-- |
|
| 2196 |
-- Name: keys(`~type._specimens_05_list_of_species_binomials`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 2197 |
-- |
|
| 2198 |
|
|
| 2199 |
|
|
| 2200 |
|
|
| 2201 |
|
|
| 2202 |
-- |
|
| 2115 | 2203 |
-- Name: ~type._specimens_06_count_of_unique_verb_subsp_taxa_with_author; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
| 2116 | 2204 |
-- |
| 2117 | 2205 |
|
| ... | ... | |
| 2776 | 2864 |
|
| 2777 | 2865 |
|
| 2778 | 2866 |
-- |
| 2867 |
-- Name: values_(`~type._specimens_04_count_of_species_binomials`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 2868 |
-- |
|
| 2869 |
|
|
| 2870 |
|
|
| 2871 |
|
|
| 2872 |
|
|
| 2873 |
-- |
|
| 2874 |
-- Name: values_(`~type._specimens_05_list_of_species_binomials`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 2875 |
-- |
|
| 2876 |
|
|
| 2877 |
|
|
| 2878 |
|
|
| 2879 |
|
|
| 2880 |
-- |
|
| 2779 | 2881 |
-- Name: values_(`~type._specimens_06_count_of_unique_verb_subsp_taxa_with_author`); Type: FUNCTION; Schema: public_validations; Owner: - |
| 2780 | 2882 |
-- |
| 2781 | 2883 |
|
| ... | ... | |
| 8883 | 8985 |
|
| 8884 | 8986 |
|
| 8885 | 8987 |
-- |
| 8988 |
-- Data for Name: ~type._specimens_04_count_of_species_binomials; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 8989 |
-- |
|
| 8990 |
|
|
| 8991 |
|
|
| 8992 |
|
|
| 8993 |
-- |
|
| 8994 |
-- Data for Name: ~type._specimens_05_list_of_species_binomials; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 8995 |
-- |
|
| 8996 |
|
|
| 8997 |
|
|
| 8998 |
|
|
| 8999 |
-- |
|
| 8886 | 9000 |
-- Data for Name: ~type._specimens_06_count_of_unique_verb_subsp_taxa_with_author; Type: TABLE DATA; Schema: public_validations; Owner: - |
| 8887 | 9001 |
-- |
| 8888 | 9002 |
|
Also available in: Unified diff
schemas/vegbien.sql: specimens*: ran through pipeline