Revision 12528
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/schemas/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 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 2555 | 2555 |
); |
| 2556 | 2556 |
|
| 2557 | 2557 |
|
| 2558 |
-- |
|
| 2559 |
-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2560 |
-- |
|
| 2561 |
|
|
| 2562 |
CREATE TABLE "~type._traits_01_count_records" ( |
|
| 2563 |
"totalRecords" bigint |
|
| 2564 |
); |
|
| 2565 |
|
|
| 2566 |
|
|
| 2567 |
-- |
|
| 2568 |
-- Name: ~type._traits_02_count_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2569 |
-- |
|
| 2570 |
|
|
| 2571 |
CREATE TABLE "~type._traits_02_count_trait_names" ( |
|
| 2572 |
traits bigint |
|
| 2573 |
); |
|
| 2574 |
|
|
| 2575 |
|
|
| 2576 |
-- |
|
| 2577 |
-- Name: ~type._traits_03_list_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2578 |
-- |
|
| 2579 |
|
|
| 2580 |
CREATE TABLE "~type._traits_03_list_trait_names" ( |
|
| 2581 |
trait text |
|
| 2582 |
); |
|
| 2583 |
|
|
| 2584 |
|
|
| 2585 |
-- |
|
| 2586 |
-- Name: ~type._traits_04_count_records_per_trait; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2587 |
-- |
|
| 2588 |
|
|
| 2589 |
CREATE TABLE "~type._traits_04_count_records_per_trait" ( |
|
| 2590 |
trait text, |
|
| 2591 |
measurements bigint |
|
| 2592 |
); |
|
| 2593 |
|
|
| 2594 |
|
|
| 2595 |
-- |
|
| 2596 |
-- Name: ~type._traits_05_count_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2597 |
-- |
|
| 2598 |
|
|
| 2599 |
CREATE TABLE "~type._traits_05_count_taxa" ( |
|
| 2600 |
taxa bigint |
|
| 2601 |
); |
|
| 2602 |
|
|
| 2603 |
|
|
| 2604 |
-- |
|
| 2605 |
-- Name: ~type._traits_06_list_distinct_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2606 |
-- |
|
| 2607 |
|
|
| 2608 |
CREATE TABLE "~type._traits_06_list_distinct_taxa" ( |
|
| 2609 |
taxonwithauthor text |
|
| 2610 |
); |
|
| 2611 |
|
|
| 2612 |
|
|
| 2613 |
-- |
|
| 2614 |
-- Name: ~type._traits_07_trait_value_and_units; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2615 |
-- |
|
| 2616 |
|
|
| 2617 |
CREATE TABLE "~type._traits_07_trait_value_and_units" ( |
|
| 2618 |
trait text, |
|
| 2619 |
value text, |
|
| 2620 |
units text |
|
| 2621 |
); |
|
| 2622 |
|
|
| 2623 |
|
|
| 2624 |
-- |
|
| 2625 |
-- Name: ~type._traits_08_taxonname_trait_and_value; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 2626 |
-- |
|
| 2627 |
|
|
| 2628 |
CREATE TABLE "~type._traits_08_taxonname_trait_and_value" ( |
|
| 2629 |
taxonwithauthor text, |
|
| 2630 |
trait text, |
|
| 2631 |
value text |
|
| 2632 |
); |
|
| 2633 |
|
|
| 2634 |
|
|
| 2558 | 2635 |
SET search_path = public, pg_catalog; |
| 2559 | 2636 |
|
| 2560 | 2637 |
-- |
| ... | ... | |
| 9330 | 9407 |
|
| 9331 | 9408 |
|
| 9332 | 9409 |
|
| 9410 |
-- |
|
| 9411 |
-- Data for Name: ~type._traits_01_count_records; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 9412 |
-- |
|
| 9413 |
|
|
| 9414 |
|
|
| 9415 |
|
|
| 9416 |
-- |
|
| 9417 |
-- Data for Name: ~type._traits_02_count_trait_names; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 9418 |
-- |
|
| 9419 |
|
|
| 9420 |
|
|
| 9421 |
|
|
| 9422 |
-- |
|
| 9423 |
-- Data for Name: ~type._traits_03_list_trait_names; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 9424 |
-- |
|
| 9425 |
|
|
| 9426 |
|
|
| 9427 |
|
|
| 9428 |
-- |
|
| 9429 |
-- Data for Name: ~type._traits_04_count_records_per_trait; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 9430 |
-- |
|
| 9431 |
|
|
| 9432 |
|
|
| 9433 |
|
|
| 9434 |
-- |
|
| 9435 |
-- Data for Name: ~type._traits_05_count_taxa; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 9436 |
-- |
|
| 9437 |
|
|
| 9438 |
|
|
| 9439 |
|
|
| 9440 |
-- |
|
| 9441 |
-- Data for Name: ~type._traits_06_list_distinct_taxa; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 9442 |
-- |
|
| 9443 |
|
|
| 9444 |
|
|
| 9445 |
|
|
| 9446 |
-- |
|
| 9447 |
-- Data for Name: ~type._traits_07_trait_value_and_units; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 9448 |
-- |
|
| 9449 |
|
|
| 9450 |
|
|
| 9451 |
|
|
| 9452 |
-- |
|
| 9453 |
-- Data for Name: ~type._traits_08_taxonname_trait_and_value; Type: TABLE DATA; Schema: public_validations; Owner: - |
|
| 9454 |
-- |
|
| 9455 |
|
|
| 9456 |
|
|
| 9457 |
|
|
| 9333 | 9458 |
SET search_path = public, pg_catalog; |
| 9334 | 9459 |
|
| 9335 | 9460 |
-- |
Also available in: Unified diff
fix: schemas/vegbien.sql: added back traits* ~type tables