Revision 12528
Added by Aaron Marcuse-Kubitza almost 11 years ago
| vegbien.my.sql | ||
|---|---|---|
| 1160 | 1160 |
); |
| 1161 | 1161 |
|
| 1162 | 1162 |
|
| 1163 |
-- |
|
| 1164 |
-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1165 |
-- |
|
| 1163 | 1166 |
|
| 1167 |
CREATE TABLE `~type._traits_01_count_records` ( |
|
| 1168 |
`totalRecords` varchar(255) |
|
| 1169 |
); |
|
| 1164 | 1170 |
|
| 1171 |
|
|
| 1165 | 1172 |
-- |
| 1173 |
-- Name: ~type._traits_02_count_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1174 |
-- |
|
| 1175 |
|
|
| 1176 |
CREATE TABLE `~type._traits_02_count_trait_names` ( |
|
| 1177 |
traits varchar(255) |
|
| 1178 |
); |
|
| 1179 |
|
|
| 1180 |
|
|
| 1181 |
-- |
|
| 1182 |
-- Name: ~type._traits_03_list_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1183 |
-- |
|
| 1184 |
|
|
| 1185 |
CREATE TABLE `~type._traits_03_list_trait_names` ( |
|
| 1186 |
trait varchar(255) |
|
| 1187 |
); |
|
| 1188 |
|
|
| 1189 |
|
|
| 1190 |
-- |
|
| 1191 |
-- Name: ~type._traits_04_count_records_per_trait; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1192 |
-- |
|
| 1193 |
|
|
| 1194 |
CREATE TABLE `~type._traits_04_count_records_per_trait` ( |
|
| 1195 |
trait varchar(255), |
|
| 1196 |
measurements varchar(255) |
|
| 1197 |
); |
|
| 1198 |
|
|
| 1199 |
|
|
| 1200 |
-- |
|
| 1201 |
-- Name: ~type._traits_05_count_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1202 |
-- |
|
| 1203 |
|
|
| 1204 |
CREATE TABLE `~type._traits_05_count_taxa` ( |
|
| 1205 |
taxa varchar(255) |
|
| 1206 |
); |
|
| 1207 |
|
|
| 1208 |
|
|
| 1209 |
-- |
|
| 1210 |
-- Name: ~type._traits_06_list_distinct_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1211 |
-- |
|
| 1212 |
|
|
| 1213 |
CREATE TABLE `~type._traits_06_list_distinct_taxa` ( |
|
| 1214 |
taxonwithauthor varchar(255) |
|
| 1215 |
); |
|
| 1216 |
|
|
| 1217 |
|
|
| 1218 |
-- |
|
| 1219 |
-- Name: ~type._traits_07_trait_value_and_units; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1220 |
-- |
|
| 1221 |
|
|
| 1222 |
CREATE TABLE `~type._traits_07_trait_value_and_units` ( |
|
| 1223 |
trait varchar(255), |
|
| 1224 |
value varchar(255), |
|
| 1225 |
units varchar(255) |
|
| 1226 |
); |
|
| 1227 |
|
|
| 1228 |
|
|
| 1229 |
-- |
|
| 1230 |
-- Name: ~type._traits_08_taxonname_trait_and_value; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1231 |
-- |
|
| 1232 |
|
|
| 1233 |
CREATE TABLE `~type._traits_08_taxonname_trait_and_value` ( |
|
| 1234 |
taxonwithauthor varchar(255), |
|
| 1235 |
trait varchar(255), |
|
| 1236 |
value varchar(255) |
|
| 1237 |
); |
|
| 1238 |
|
|
| 1239 |
|
|
| 1240 |
|
|
| 1241 |
|
|
| 1242 |
-- |
|
| 1166 | 1243 |
-- Name: analytical_stem; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1167 | 1244 |
-- |
| 1168 | 1245 |
|
| ... | ... | |
| 6831 | 6908 |
|
| 6832 | 6909 |
|
| 6833 | 6910 |
|
| 6911 |
-- |
|
| 6912 |
-- Data for Name: ~type._traits_01_count_records; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 6913 |
-- |
|
| 6834 | 6914 |
|
| 6835 | 6915 |
|
| 6916 |
|
|
| 6836 | 6917 |
-- |
| 6918 |
-- Data for Name: ~type._traits_02_count_trait_names; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 6919 |
-- |
|
| 6920 |
|
|
| 6921 |
|
|
| 6922 |
|
|
| 6923 |
-- |
|
| 6924 |
-- Data for Name: ~type._traits_03_list_trait_names; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 6925 |
-- |
|
| 6926 |
|
|
| 6927 |
|
|
| 6928 |
|
|
| 6929 |
-- |
|
| 6930 |
-- Data for Name: ~type._traits_04_count_records_per_trait; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 6931 |
-- |
|
| 6932 |
|
|
| 6933 |
|
|
| 6934 |
|
|
| 6935 |
-- |
|
| 6936 |
-- Data for Name: ~type._traits_05_count_taxa; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 6937 |
-- |
|
| 6938 |
|
|
| 6939 |
|
|
| 6940 |
|
|
| 6941 |
-- |
|
| 6942 |
-- Data for Name: ~type._traits_06_list_distinct_taxa; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 6943 |
-- |
|
| 6944 |
|
|
| 6945 |
|
|
| 6946 |
|
|
| 6947 |
-- |
|
| 6948 |
-- Data for Name: ~type._traits_07_trait_value_and_units; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 6949 |
-- |
|
| 6950 |
|
|
| 6951 |
|
|
| 6952 |
|
|
| 6953 |
-- |
|
| 6954 |
-- Data for Name: ~type._traits_08_taxonname_trait_and_value; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 6955 |
-- |
|
| 6956 |
|
|
| 6957 |
|
|
| 6958 |
|
|
| 6959 |
|
|
| 6960 |
|
|
| 6961 |
-- |
|
| 6837 | 6962 |
-- Name: address_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 6838 | 6963 |
-- |
| 6839 | 6964 |
|
Also available in: Unified diff
fix: schemas/vegbien.sql: added back traits* ~type tables