Revision 12497
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.my.sql | ||
|---|---|---|
| 878 | 878 |
|
| 879 | 879 |
|
| 880 | 880 |
-- |
| 881 |
-- Name: %==(`~type._plots_04_count_of_plots_in_each_project_in_this_source`, `~type._plots_04_count_of_plots_in_each_project_in_this_source`); Type: FUNCTION; Schema: public_validations; Owner: -
|
|
| 881 |
-- Name: keys(`~type._plots_04_count_of_plots_in_each_project_in_this_source`); Type: FUNCTION; Schema: public_validations; Owner: -
|
|
| 882 | 882 |
-- |
| 883 | 883 |
|
| 884 | 884 |
|
| ... | ... | |
| 895 | 895 |
|
| 896 | 896 |
|
| 897 | 897 |
-- |
| 898 |
-- Name: %==(`~type._traits_04_count_records_per_trait`, `~type._traits_04_count_records_per_trait`); Type: FUNCTION; Schema: public_validations; Owner: -
|
|
| 898 |
-- Name: keys(`~type._traits_04_count_records_per_trait`); Type: FUNCTION; Schema: public_validations; Owner: -
|
|
| 899 | 899 |
-- |
| 900 | 900 |
|
| 901 | 901 |
|
| ... | ... | |
| 1070 | 1070 |
|
| 1071 | 1071 |
|
| 1072 | 1072 |
-- |
| 1073 |
-- Name: %==; Type: OPERATOR; Schema: public_validations; Owner: -
|
|
| 1073 |
-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace:
|
|
| 1074 | 1074 |
-- |
| 1075 | 1075 |
|
| 1076 |
CREATE OPERATOR %== ( |
|
| 1077 |
PROCEDURE = `%==`, |
|
| 1078 |
LEFTARG = `~type._traits_04_count_records_per_trait`, |
|
| 1079 |
RIGHTARG = `~type._traits_04_count_records_per_trait` |
|
| 1076 |
CREATE TABLE `~type._traits_01_count_records` ( |
|
| 1077 |
`totalRecords` varchar(255) |
|
| 1080 | 1078 |
); |
| 1081 | 1079 |
|
| 1082 | 1080 |
|
| 1083 | 1081 |
-- |
| 1084 |
-- Name: %==; Type: OPERATOR; Schema: public_validations; Owner: -
|
|
| 1082 |
-- Name: ~type._traits_02_count_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace:
|
|
| 1085 | 1083 |
-- |
| 1086 | 1084 |
|
| 1087 |
CREATE OPERATOR %== ( |
|
| 1088 |
PROCEDURE = `%==`, |
|
| 1089 |
LEFTARG = `~type._plots_04_count_of_plots_in_each_project_in_this_source`, |
|
| 1090 |
RIGHTARG = `~type._plots_04_count_of_plots_in_each_project_in_this_source` |
|
| 1085 |
CREATE TABLE `~type._traits_02_count_trait_names` ( |
|
| 1086 |
traits varchar(255) |
|
| 1091 | 1087 |
); |
| 1092 | 1088 |
|
| 1093 | 1089 |
|
| 1090 |
-- |
|
| 1091 |
-- Name: ~type._traits_03_list_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1092 |
-- |
|
| 1094 | 1093 |
|
| 1094 |
CREATE TABLE `~type._traits_03_list_trait_names` ( |
|
| 1095 |
trait varchar(255) |
|
| 1096 |
); |
|
| 1095 | 1097 |
|
| 1098 |
|
|
| 1096 | 1099 |
-- |
| 1100 |
-- Name: ~type._traits_05_count_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1101 |
-- |
|
| 1102 |
|
|
| 1103 |
CREATE TABLE `~type._traits_05_count_taxa` ( |
|
| 1104 |
taxa varchar(255) |
|
| 1105 |
); |
|
| 1106 |
|
|
| 1107 |
|
|
| 1108 |
-- |
|
| 1109 |
-- Name: ~type._traits_06_list_distinct_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1110 |
-- |
|
| 1111 |
|
|
| 1112 |
CREATE TABLE `~type._traits_06_list_distinct_taxa` ( |
|
| 1113 |
taxonwithauthor varchar(255) |
|
| 1114 |
); |
|
| 1115 |
|
|
| 1116 |
|
|
| 1117 |
-- |
|
| 1118 |
-- Name: ~type._traits_07_trait_value_and_units; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1119 |
-- |
|
| 1120 |
|
|
| 1121 |
CREATE TABLE `~type._traits_07_trait_value_and_units` ( |
|
| 1122 |
trait varchar(255), |
|
| 1123 |
value varchar(255), |
|
| 1124 |
units varchar(255) |
|
| 1125 |
); |
|
| 1126 |
|
|
| 1127 |
|
|
| 1128 |
-- |
|
| 1129 |
-- Name: ~type._traits_08_taxonname_trait_and_value; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1130 |
-- |
|
| 1131 |
|
|
| 1132 |
CREATE TABLE `~type._traits_08_taxonname_trait_and_value` ( |
|
| 1133 |
taxonwithauthor varchar(255), |
|
| 1134 |
trait varchar(255), |
|
| 1135 |
value varchar(255) |
|
| 1136 |
); |
|
| 1137 |
|
|
| 1138 |
|
|
| 1139 |
|
|
| 1140 |
|
|
| 1141 |
-- |
|
| 1097 | 1142 |
-- Name: analytical_stem; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1098 | 1143 |
-- |
| 1099 | 1144 |
|
| ... | ... | |
| 3931 | 3976 |
); |
| 3932 | 3977 |
|
| 3933 | 3978 |
|
| 3934 |
-- |
|
| 3935 |
-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3936 |
-- |
|
| 3937 | 3979 |
|
| 3938 |
CREATE TABLE `~type._traits_01_count_records` ( |
|
| 3939 |
`totalRecords` varchar(255) |
|
| 3940 |
); |
|
| 3941 | 3980 |
|
| 3942 |
|
|
| 3943 | 3981 |
-- |
| 3944 |
-- Name: ~type._traits_02_count_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3945 |
-- |
|
| 3946 |
|
|
| 3947 |
CREATE TABLE `~type._traits_02_count_trait_names` ( |
|
| 3948 |
traits varchar(255) |
|
| 3949 |
); |
|
| 3950 |
|
|
| 3951 |
|
|
| 3952 |
-- |
|
| 3953 |
-- Name: ~type._traits_03_list_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3954 |
-- |
|
| 3955 |
|
|
| 3956 |
CREATE TABLE `~type._traits_03_list_trait_names` ( |
|
| 3957 |
trait varchar(255) |
|
| 3958 |
); |
|
| 3959 |
|
|
| 3960 |
|
|
| 3961 |
-- |
|
| 3962 |
-- Name: ~type._traits_05_count_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3963 |
-- |
|
| 3964 |
|
|
| 3965 |
CREATE TABLE `~type._traits_05_count_taxa` ( |
|
| 3966 |
taxa varchar(255) |
|
| 3967 |
); |
|
| 3968 |
|
|
| 3969 |
|
|
| 3970 |
-- |
|
| 3971 |
-- Name: ~type._traits_06_list_distinct_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3972 |
-- |
|
| 3973 |
|
|
| 3974 |
CREATE TABLE `~type._traits_06_list_distinct_taxa` ( |
|
| 3975 |
taxonwithauthor varchar(255) |
|
| 3976 |
); |
|
| 3977 |
|
|
| 3978 |
|
|
| 3979 |
-- |
|
| 3980 |
-- Name: ~type._traits_07_trait_value_and_units; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3981 |
-- |
|
| 3982 |
|
|
| 3983 |
CREATE TABLE `~type._traits_07_trait_value_and_units` ( |
|
| 3984 |
trait varchar(255), |
|
| 3985 |
value varchar(255), |
|
| 3986 |
units varchar(255) |
|
| 3987 |
); |
|
| 3988 |
|
|
| 3989 |
|
|
| 3990 |
-- |
|
| 3991 |
-- Name: ~type._traits_08_taxonname_trait_and_value; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3992 |
-- |
|
| 3993 |
|
|
| 3994 |
CREATE TABLE `~type._traits_08_taxonname_trait_and_value` ( |
|
| 3995 |
taxonwithauthor varchar(255), |
|
| 3996 |
trait varchar(255), |
|
| 3997 |
value varchar(255) |
|
| 3998 |
); |
|
| 3999 |
|
|
| 4000 |
|
|
| 4001 |
|
|
| 4002 |
|
|
| 4003 |
-- |
|
| 4004 | 3982 |
-- Name: address_id; Type: DEFAULT; Schema: public; Owner: - |
| 4005 | 3983 |
-- |
| 4006 | 3984 |
|
Also available in: Unified diff
schemas/vegbien.sql: replaced custom %== operators with much simpler custom keys() functions. this avoids both the need to write out an = comparison for each field, and especially, also the need to write both an operator and a function implementing that operator.