Revision 12418
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.my.sql | ||
|---|---|---|
| 1035 | 1035 |
|
| 1036 | 1036 |
|
| 1037 | 1037 |
|
| 1038 |
-- |
|
| 1039 |
-- Name: ~type._plots_02_list_of_project_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1040 |
-- |
|
| 1038 | 1041 |
|
| 1042 |
CREATE TABLE `~type._plots_02_list_of_project_names` ( |
|
| 1043 |
project_name varchar(255) |
|
| 1044 |
); |
|
| 1039 | 1045 |
|
| 1046 |
|
|
| 1040 | 1047 |
-- |
| 1048 |
-- Name: ~type._plots_04_count_of_plots_in_each_project_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1049 |
-- |
|
| 1050 |
|
|
| 1051 |
CREATE TABLE `~type._plots_04_count_of_plots_in_each_project_in_this_source` ( |
|
| 1052 |
project_name varchar(255), |
|
| 1053 |
plots varchar(255) |
|
| 1054 |
); |
|
| 1055 |
|
|
| 1056 |
|
|
| 1057 |
|
|
| 1058 |
|
|
| 1059 |
-- |
|
| 1041 | 1060 |
-- Name: analytical_stem; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1042 | 1061 |
-- |
| 1043 | 1062 |
|
| ... | ... | |
| 3858 | 3877 |
|
| 3859 | 3878 |
|
| 3860 | 3879 |
-- |
| 3861 |
-- Name: ~type._plots_02_list_of_project_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3862 |
-- |
|
| 3863 |
|
|
| 3864 |
CREATE TABLE `~type._plots_02_list_of_project_names` ( |
|
| 3865 |
projectname varchar(255) |
|
| 3866 |
); |
|
| 3867 |
|
|
| 3868 |
|
|
| 3869 |
-- |
|
| 3870 | 3880 |
-- Name: ~type._plots_03_count_of_all_plots_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
| 3871 | 3881 |
-- |
| 3872 | 3882 |
|
| ... | ... | |
| 3876 | 3886 |
|
| 3877 | 3887 |
|
| 3878 | 3888 |
-- |
| 3879 |
-- Name: ~type._plots_04_count_of_plots_in_each_project_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3880 |
-- |
|
| 3881 |
|
|
| 3882 |
CREATE TABLE `~type._plots_04_count_of_plots_in_each_project_in_this_source` ( |
|
| 3883 |
project_name varchar(255), |
|
| 3884 |
plots varchar(255) |
|
| 3885 |
); |
|
| 3886 |
|
|
| 3887 |
|
|
| 3888 |
-- |
|
| 3889 | 3889 |
-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
| 3890 | 3890 |
-- |
| 3891 | 3891 |
|
Also available in: Unified diff
fix: inputs/SALVIAS/validations.sql: _plots_02_list_of_project_names: altered column aliases to match output query