Revision 12422
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.my.sql | ||
|---|---|---|
| 1063 | 1063 |
); |
| 1064 | 1064 |
|
| 1065 | 1065 |
|
| 1066 |
-- |
|
| 1067 |
-- Name: ~type._plots_02_list_of_project_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1068 |
-- |
|
| 1069 | 1066 |
|
| 1070 |
CREATE TABLE `~type._plots_02_list_of_project_names` ( |
|
| 1071 |
project_name varchar(255) |
|
| 1072 |
); |
|
| 1073 | 1067 |
|
| 1074 |
|
|
| 1075 | 1068 |
-- |
| 1076 |
-- Name: ~type._plots_04_count_of_plots_in_each_project_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1077 |
-- |
|
| 1078 |
|
|
| 1079 |
CREATE TABLE `~type._plots_04_count_of_plots_in_each_project_in_this_source` ( |
|
| 1080 |
project_name varchar(255), |
|
| 1081 |
plots varchar(255) |
|
| 1082 |
); |
|
| 1083 |
|
|
| 1084 |
|
|
| 1085 |
|
|
| 1086 |
|
|
| 1087 |
-- |
|
| 1088 | 1069 |
-- Name: analytical_stem; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1089 | 1070 |
-- |
| 1090 | 1071 |
|
| ... | ... | |
| 3905 | 3886 |
|
| 3906 | 3887 |
|
| 3907 | 3888 |
-- |
| 3889 |
-- Name: ~type._plots_02_list_of_project_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3890 |
-- |
|
| 3891 |
|
|
| 3892 |
CREATE TABLE `~type._plots_02_list_of_project_names` ( |
|
| 3893 |
project_name varchar(255) |
|
| 3894 |
); |
|
| 3895 |
|
|
| 3896 |
|
|
| 3897 |
-- |
|
| 3908 | 3898 |
-- Name: ~type._plots_03_count_of_all_plots_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
| 3909 | 3899 |
-- |
| 3910 | 3900 |
|
| ... | ... | |
| 3914 | 3904 |
|
| 3915 | 3905 |
|
| 3916 | 3906 |
-- |
| 3907 |
-- Name: ~type._plots_04_count_of_plots_in_each_project_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3908 |
-- |
|
| 3909 |
|
|
| 3910 |
CREATE TABLE `~type._plots_04_count_of_plots_in_each_project_in_this_source` ( |
|
| 3911 |
project_name varchar(255), |
|
| 3912 |
plots varchar(255) |
|
| 3913 |
); |
|
| 3914 |
|
|
| 3915 |
|
|
| 3916 |
-- |
|
| 3917 | 3917 |
-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
| 3918 | 3918 |
-- |
| 3919 | 3919 |
|
Also available in: Unified diff
schemas/vegbien.sql: synced from DB, which changes the order of the ~type tables