Revision 12412
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.my.sql | ||
|---|---|---|
| 1021 | 1021 |
|
| 1022 | 1022 |
|
| 1023 | 1023 |
|
| 1024 |
-- |
|
| 1025 |
-- Name: ~type._plots_01_count_of_projects; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1026 |
-- |
|
| 1027 | 1024 |
|
| 1028 |
CREATE TABLE `~type._plots_01_count_of_projects` ( |
|
| 1029 |
projects varchar(255) |
|
| 1030 |
); |
|
| 1031 | 1025 |
|
| 1032 |
|
|
| 1033 | 1026 |
-- |
| 1034 |
-- Name: ~type._plots_02_list_of_project_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1035 |
-- |
|
| 1036 |
|
|
| 1037 |
CREATE TABLE `~type._plots_02_list_of_project_names` ( |
|
| 1038 |
projectname varchar(255) |
|
| 1039 |
); |
|
| 1040 |
|
|
| 1041 |
|
|
| 1042 |
-- |
|
| 1043 |
-- Name: ~type._plots_03_count_of_all_plots_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1044 |
-- |
|
| 1045 |
|
|
| 1046 |
CREATE TABLE `~type._plots_03_count_of_all_plots_in_this_source` ( |
|
| 1047 |
plots varchar(255) |
|
| 1048 |
); |
|
| 1049 |
|
|
| 1050 |
|
|
| 1051 |
|
|
| 1052 |
|
|
| 1053 |
-- |
|
| 1054 | 1027 |
-- Name: analytical_stem; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1055 | 1028 |
-- |
| 1056 | 1029 |
|
| ... | ... | |
| 3862 | 3835 |
|
| 3863 | 3836 |
|
| 3864 | 3837 |
-- |
| 3838 |
-- Name: ~type._plots_01_count_of_projects; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3839 |
-- |
|
| 3840 |
|
|
| 3841 |
CREATE TABLE `~type._plots_01_count_of_projects` ( |
|
| 3842 |
projects varchar(255) |
|
| 3843 |
); |
|
| 3844 |
|
|
| 3845 |
|
|
| 3846 |
-- |
|
| 3847 |
-- Name: ~type._plots_02_list_of_project_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3848 |
-- |
|
| 3849 |
|
|
| 3850 |
CREATE TABLE `~type._plots_02_list_of_project_names` ( |
|
| 3851 |
projectname varchar(255) |
|
| 3852 |
); |
|
| 3853 |
|
|
| 3854 |
|
|
| 3855 |
-- |
|
| 3856 |
-- Name: ~type._plots_03_count_of_all_plots_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3857 |
-- |
|
| 3858 |
|
|
| 3859 |
CREATE TABLE `~type._plots_03_count_of_all_plots_in_this_source` ( |
|
| 3860 |
plots varchar(255) |
|
| 3861 |
); |
|
| 3862 |
|
|
| 3863 |
|
|
| 3864 |
-- |
|
| 3865 | 3865 |
-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
| 3866 | 3866 |
-- |
| 3867 | 3867 |
|
Also available in: Unified diff
fix: schemas/vegbien.sql: public_validations._plots_* that use projectname: re-alias to project_name to match input queries. (reexporting apparently changes the relative order of the ~type tables.)