Revision 12399
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.my.sql | ||
|---|---|---|
| 1021 | 1021 |
|
| 1022 | 1022 |
|
| 1023 | 1023 |
|
| 1024 |
-- |
|
| 1025 |
-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1026 |
-- |
|
| 1027 | 1024 |
|
| 1028 |
CREATE TABLE `~type._traits_01_count_records` ( |
|
| 1029 |
`totalRecords` varchar(255) |
|
| 1030 |
); |
|
| 1031 | 1025 |
|
| 1032 |
|
|
| 1033 | 1026 |
-- |
| 1034 |
-- Name: ~type._traits_02_count_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1035 |
-- |
|
| 1036 |
|
|
| 1037 |
CREATE TABLE `~type._traits_02_count_trait_names` ( |
|
| 1038 |
traits varchar(255) |
|
| 1039 |
); |
|
| 1040 |
|
|
| 1041 |
|
|
| 1042 |
-- |
|
| 1043 |
-- Name: ~type._traits_03_list_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1044 |
-- |
|
| 1045 |
|
|
| 1046 |
CREATE TABLE `~type._traits_03_list_trait_names` ( |
|
| 1047 |
trait varchar(255) |
|
| 1048 |
); |
|
| 1049 |
|
|
| 1050 |
|
|
| 1051 |
-- |
|
| 1052 |
-- Name: ~type._traits_04_count_records_per_trait; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1053 |
-- |
|
| 1054 |
|
|
| 1055 |
CREATE TABLE `~type._traits_04_count_records_per_trait` ( |
|
| 1056 |
trait varchar(255), |
|
| 1057 |
measurements varchar(255) |
|
| 1058 |
); |
|
| 1059 |
|
|
| 1060 |
|
|
| 1061 |
-- |
|
| 1062 |
-- Name: ~type._traits_05_count_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1063 |
-- |
|
| 1064 |
|
|
| 1065 |
CREATE TABLE `~type._traits_05_count_taxa` ( |
|
| 1066 |
taxa varchar(255) |
|
| 1067 |
); |
|
| 1068 |
|
|
| 1069 |
|
|
| 1070 |
-- |
|
| 1071 |
-- Name: ~type._traits_06_list_distinct_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1072 |
-- |
|
| 1073 |
|
|
| 1074 |
CREATE TABLE `~type._traits_06_list_distinct_taxa` ( |
|
| 1075 |
taxonwithauthor varchar(255) |
|
| 1076 |
); |
|
| 1077 |
|
|
| 1078 |
|
|
| 1079 |
-- |
|
| 1080 |
-- Name: ~type._traits_07_trait_value_and_units; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1081 |
-- |
|
| 1082 |
|
|
| 1083 |
CREATE TABLE `~type._traits_07_trait_value_and_units` ( |
|
| 1084 |
trait varchar(255), |
|
| 1085 |
value varchar(255), |
|
| 1086 |
units varchar(255) |
|
| 1087 |
); |
|
| 1088 |
|
|
| 1089 |
|
|
| 1090 |
-- |
|
| 1091 |
-- Name: ~type._traits_08_taxonname_trait_and_value; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1092 |
-- |
|
| 1093 |
|
|
| 1094 |
CREATE TABLE `~type._traits_08_taxonname_trait_and_value` ( |
|
| 1095 |
taxonwithauthor varchar(255), |
|
| 1096 |
trait varchar(255), |
|
| 1097 |
value varchar(255) |
|
| 1098 |
); |
|
| 1099 |
|
|
| 1100 |
|
|
| 1101 |
|
|
| 1102 |
|
|
| 1103 |
-- |
|
| 1104 | 1027 |
-- Name: analytical_stem; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1105 | 1028 |
-- |
| 1106 | 1029 |
|
| ... | ... | |
| 3911 | 3834 |
|
| 3912 | 3835 |
|
| 3913 | 3836 |
|
| 3837 |
-- |
|
| 3838 |
-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3839 |
-- |
|
| 3914 | 3840 |
|
| 3841 |
CREATE TABLE `~type._traits_01_count_records` ( |
|
| 3842 |
`totalRecords` varchar(255) |
|
| 3843 |
); |
|
| 3915 | 3844 |
|
| 3845 |
|
|
| 3916 | 3846 |
-- |
| 3847 |
-- Name: ~type._traits_02_count_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3848 |
-- |
|
| 3849 |
|
|
| 3850 |
CREATE TABLE `~type._traits_02_count_trait_names` ( |
|
| 3851 |
traits varchar(255) |
|
| 3852 |
); |
|
| 3853 |
|
|
| 3854 |
|
|
| 3855 |
-- |
|
| 3856 |
-- Name: ~type._traits_03_list_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3857 |
-- |
|
| 3858 |
|
|
| 3859 |
CREATE TABLE `~type._traits_03_list_trait_names` ( |
|
| 3860 |
trait varchar(255) |
|
| 3861 |
); |
|
| 3862 |
|
|
| 3863 |
|
|
| 3864 |
-- |
|
| 3865 |
-- Name: ~type._traits_04_count_records_per_trait; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3866 |
-- |
|
| 3867 |
|
|
| 3868 |
CREATE TABLE `~type._traits_04_count_records_per_trait` ( |
|
| 3869 |
trait varchar(255), |
|
| 3870 |
measurements varchar(255) |
|
| 3871 |
); |
|
| 3872 |
|
|
| 3873 |
|
|
| 3874 |
-- |
|
| 3875 |
-- Name: ~type._traits_05_count_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3876 |
-- |
|
| 3877 |
|
|
| 3878 |
CREATE TABLE `~type._traits_05_count_taxa` ( |
|
| 3879 |
taxa varchar(255) |
|
| 3880 |
); |
|
| 3881 |
|
|
| 3882 |
|
|
| 3883 |
-- |
|
| 3884 |
-- Name: ~type._traits_06_list_distinct_taxa; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3885 |
-- |
|
| 3886 |
|
|
| 3887 |
CREATE TABLE `~type._traits_06_list_distinct_taxa` ( |
|
| 3888 |
taxonwithauthor varchar(255) |
|
| 3889 |
); |
|
| 3890 |
|
|
| 3891 |
|
|
| 3892 |
-- |
|
| 3893 |
-- Name: ~type._traits_07_trait_value_and_units; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3894 |
-- |
|
| 3895 |
|
|
| 3896 |
CREATE TABLE `~type._traits_07_trait_value_and_units` ( |
|
| 3897 |
trait varchar(255), |
|
| 3898 |
value varchar(255), |
|
| 3899 |
units varchar(255) |
|
| 3900 |
); |
|
| 3901 |
|
|
| 3902 |
|
|
| 3903 |
-- |
|
| 3904 |
-- Name: ~type._traits_08_taxonname_trait_and_value; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3905 |
-- |
|
| 3906 |
|
|
| 3907 |
CREATE TABLE `~type._traits_08_taxonname_trait_and_value` ( |
|
| 3908 |
taxonwithauthor varchar(255), |
|
| 3909 |
trait varchar(255), |
|
| 3910 |
value varchar(255) |
|
| 3911 |
); |
|
| 3912 |
|
|
| 3913 |
|
|
| 3914 |
|
|
| 3915 |
|
|
| 3916 |
-- |
|
| 3917 | 3917 |
-- Name: address_id; Type: DEFAULT; Schema: public; Owner: - |
| 3918 | 3918 |
-- |
| 3919 | 3919 |
|
Also available in: Unified diff
schemas/vegbien.sql: synced to DB, which changes the sort order (due to system update?)