Revision 13094
Added by Aaron Marcuse-Kubitza almost 11 years ago
trunk/schemas/vegbien.my.sql | ||
---|---|---|
476 | 476 |
|
477 | 477 |
|
478 | 478 |
-- |
479 |
-- Name: keys_~type._specimens_11_list_of_three_standard_political_divis; Type: TYPE; Schema: public_validations; Owner: - |
|
480 |
-- |
|
481 |
|
|
482 |
|
|
483 |
|
|
484 |
|
|
485 |
-- |
|
486 |
-- Name: TYPE `keys_~type._specimens_11_list_of_three_standard_political_divis`; Type: COMMENT; Schema: public_validations; Owner: - |
|
487 |
-- |
|
488 |
|
|
489 |
|
|
490 |
|
|
491 |
|
|
492 |
-- |
|
479 | 493 |
-- Name: keys_~type._specimens_12_distinct_collector_name_collect_num_da; Type: TYPE; Schema: public_validations; Owner: - |
480 | 494 |
-- |
481 | 495 |
|
... | ... | |
882 | 896 |
|
883 | 897 |
|
884 | 898 |
-- |
899 |
-- Name: values__~type._specimens_11_list_of_three_standard_political_di; Type: TYPE; Schema: public_validations; Owner: - |
|
900 |
-- |
|
901 |
|
|
902 |
|
|
903 |
|
|
904 |
|
|
905 |
-- |
|
906 |
-- Name: TYPE `values__~type._specimens_11_list_of_three_standard_political_di`; Type: COMMENT; Schema: public_validations; Owner: - |
|
907 |
-- |
|
908 |
|
|
909 |
|
|
910 |
|
|
911 |
|
|
912 |
-- |
|
885 | 913 |
-- Name: values__~type._specimens_12_distinct_collector_name_collect_num; Type: TYPE; Schema: public_validations; Owner: - |
886 | 914 |
-- |
887 | 915 |
|
... | ... | |
2165 | 2193 |
|
2166 | 2194 |
|
2167 | 2195 |
-- |
2196 |
-- Name: ~type._specimens_11_list_of_three_standard_political_divisions; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
2197 |
-- |
|
2198 |
|
|
2199 |
CREATE TABLE `~type._specimens_11_list_of_three_standard_political_divisions` ( |
|
2200 |
country varchar(255), |
|
2201 |
`stateProvince` varchar(255), |
|
2202 |
county varchar(255) |
|
2203 |
); |
|
2204 |
|
|
2205 |
|
|
2206 |
-- |
|
2207 |
-- Name: keys(`~type._specimens_11_list_of_three_standard_political_divisions`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
2208 |
-- |
|
2209 |
|
|
2210 |
|
|
2211 |
|
|
2212 |
|
|
2213 |
-- |
|
2168 | 2214 |
-- Name: ~type._specimens_12_distinct_collector_name_collect_num_date_w_; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
2169 | 2215 |
-- |
2170 | 2216 |
|
... | ... | |
2766 | 2812 |
|
2767 | 2813 |
|
2768 | 2814 |
-- |
2815 |
-- Name: values_(`~type._specimens_11_list_of_three_standard_political_divisions`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
2816 |
-- |
|
2817 |
|
|
2818 |
|
|
2819 |
|
|
2820 |
|
|
2821 |
-- |
|
2769 | 2822 |
-- Name: values_(`~type._specimens_12_distinct_collector_name_collect_num_date_w_`); Type: FUNCTION; Schema: public_validations; Owner: - |
2770 | 2823 |
-- |
2771 | 2824 |
|
... | ... | |
8861 | 8914 |
|
8862 | 8915 |
|
8863 | 8916 |
-- |
8917 |
-- Data for Name: ~type._specimens_11_list_of_three_standard_political_divisions; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
8918 |
-- |
|
8919 |
|
|
8920 |
|
|
8921 |
|
|
8922 |
-- |
|
8864 | 8923 |
-- Data for Name: ~type._specimens_12_distinct_collector_name_collect_num_date_w_; Type: TABLE DATA; Schema: public_validations; Owner: - |
8865 | 8924 |
-- |
8866 | 8925 |
|
trunk/schemas/vegbien.sql | ||
---|---|---|
837 | 837 |
|
838 | 838 |
|
839 | 839 |
-- |
840 |
-- Name: keys_~type._specimens_11_list_of_three_standard_political_divis; Type: TYPE; Schema: public_validations; Owner: - |
|
841 |
-- |
|
842 |
|
|
843 |
CREATE TYPE "keys_~type._specimens_11_list_of_three_standard_political_divis" AS ( |
|
844 |
country text, |
|
845 |
"stateProvince" text, |
|
846 |
county text |
|
847 |
); |
|
848 |
|
|
849 |
|
|
850 |
-- |
|
851 |
-- Name: TYPE "keys_~type._specimens_11_list_of_three_standard_political_divis"; Type: COMMENT; Schema: public_validations; Owner: - |
|
852 |
-- |
|
853 |
|
|
854 |
COMMENT ON TYPE "keys_~type._specimens_11_list_of_three_standard_political_divis" IS ' |
|
855 |
autogenerated |
|
856 |
'; |
|
857 |
|
|
858 |
|
|
859 |
-- |
|
840 | 860 |
-- Name: keys_~type._specimens_12_distinct_collector_name_collect_num_da; Type: TYPE; Schema: public_validations; Owner: - |
841 | 861 |
-- |
842 | 862 |
|
... | ... | |
1371 | 1391 |
|
1372 | 1392 |
|
1373 | 1393 |
-- |
1394 |
-- Name: values__~type._specimens_11_list_of_three_standard_political_di; Type: TYPE; Schema: public_validations; Owner: - |
|
1395 |
-- |
|
1396 |
|
|
1397 |
CREATE TYPE "values__~type._specimens_11_list_of_three_standard_political_di" AS ( |
|
1398 |
country text, |
|
1399 |
"stateProvince" text, |
|
1400 |
county text |
|
1401 |
); |
|
1402 |
|
|
1403 |
|
|
1404 |
-- |
|
1405 |
-- Name: TYPE "values__~type._specimens_11_list_of_three_standard_political_di"; Type: COMMENT; Schema: public_validations; Owner: - |
|
1406 |
-- |
|
1407 |
|
|
1408 |
COMMENT ON TYPE "values__~type._specimens_11_list_of_three_standard_political_di" IS ' |
|
1409 |
autogenerated |
|
1410 |
'; |
|
1411 |
|
|
1412 |
|
|
1413 |
-- |
|
1374 | 1414 |
-- Name: values__~type._specimens_12_distinct_collector_name_collect_num; Type: TYPE; Schema: public_validations; Owner: - |
1375 | 1415 |
-- |
1376 | 1416 |
|
... | ... | |
3693 | 3733 |
|
3694 | 3734 |
|
3695 | 3735 |
-- |
3736 |
-- Name: ~type._specimens_11_list_of_three_standard_political_divisions; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
3737 |
-- |
|
3738 |
|
|
3739 |
CREATE TABLE "~type._specimens_11_list_of_three_standard_political_divisions" ( |
|
3740 |
country text, |
|
3741 |
"stateProvince" text, |
|
3742 |
county text |
|
3743 |
); |
|
3744 |
|
|
3745 |
|
|
3746 |
-- |
|
3747 |
-- Name: keys("~type._specimens_11_list_of_three_standard_political_divisions"); Type: FUNCTION; Schema: public_validations; Owner: - |
|
3748 |
-- |
|
3749 |
|
|
3750 |
CREATE FUNCTION keys(value "~type._specimens_11_list_of_three_standard_political_divisions") RETURNS "keys_~type._specimens_11_list_of_three_standard_political_divis" |
|
3751 |
LANGUAGE sql IMMUTABLE |
|
3752 |
AS $_$ |
|
3753 |
SELECT ROW($1.country, $1."stateProvince", $1.county)::public_validations."keys_~type._specimens_11_list_of_three_standard_political_divis" |
|
3754 |
$_$; |
|
3755 |
|
|
3756 |
|
|
3757 |
-- |
|
3696 | 3758 |
-- Name: ~type._specimens_12_distinct_collector_name_collect_num_date_w_; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
3697 | 3759 |
-- |
3698 | 3760 |
|
... | ... | |
4764 | 4826 |
|
4765 | 4827 |
|
4766 | 4828 |
-- |
4829 |
-- Name: values_("~type._specimens_11_list_of_three_standard_political_divisions"); Type: FUNCTION; Schema: public_validations; Owner: - |
|
4830 |
-- |
|
4831 |
|
|
4832 |
CREATE FUNCTION values_(value "~type._specimens_11_list_of_three_standard_political_divisions") RETURNS "values__~type._specimens_11_list_of_three_standard_political_di" |
|
4833 |
LANGUAGE sql IMMUTABLE |
|
4834 |
AS $_$ |
|
4835 |
SELECT ROW($1.country, $1."stateProvince", $1.county)::public_validations."values__~type._specimens_11_list_of_three_standard_political_di" |
|
4836 |
$_$; |
|
4837 |
|
|
4838 |
|
|
4839 |
-- |
|
4767 | 4840 |
-- Name: values_("~type._specimens_12_distinct_collector_name_collect_num_date_w_"); Type: FUNCTION; Schema: public_validations; Owner: - |
4768 | 4841 |
-- |
4769 | 4842 |
|
... | ... | |
12283 | 12356 |
|
12284 | 12357 |
|
12285 | 12358 |
-- |
12359 |
-- Data for Name: ~type._specimens_11_list_of_three_standard_political_divisions; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
12360 |
-- |
|
12361 |
|
|
12362 |
|
|
12363 |
|
|
12364 |
-- |
|
12286 | 12365 |
-- Data for Name: ~type._specimens_12_distinct_collector_name_collect_num_date_w_; Type: TABLE DATA; Schema: public_validations; Owner: - |
12287 | 12366 |
-- |
12288 | 12367 |
|
Also available in: Unified diff
schemas/vegbien.sql: _specimens_11_list_of_three_standard_political_divisions: ran through pipeline