Revision 12418
Added by Aaron Marcuse-Kubitza over 10 years ago
trunk/schemas/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 |
|
trunk/schemas/vegbien.sql | ||
---|---|---|
2379 | 2379 |
$_$; |
2380 | 2380 |
|
2381 | 2381 |
|
2382 |
-- |
|
2383 |
-- Name: ~type._plots_02_list_of_project_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
2384 |
-- |
|
2385 |
|
|
2386 |
CREATE TABLE "~type._plots_02_list_of_project_names" ( |
|
2387 |
project_name text |
|
2388 |
); |
|
2389 |
|
|
2390 |
|
|
2391 |
-- |
|
2392 |
-- Name: ~type._plots_04_count_of_plots_in_each_project_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
2393 |
-- |
|
2394 |
|
|
2395 |
CREATE TABLE "~type._plots_04_count_of_plots_in_each_project_in_this_source" ( |
|
2396 |
project_name text, |
|
2397 |
plots bigint |
|
2398 |
); |
|
2399 |
|
|
2400 |
|
|
2382 | 2401 |
SET search_path = public, pg_catalog; |
2383 | 2402 |
|
2384 | 2403 |
-- |
... | ... | |
6303 | 6322 |
|
6304 | 6323 |
|
6305 | 6324 |
-- |
6306 |
-- Name: ~type._plots_02_list_of_project_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
6307 |
-- |
|
6308 |
|
|
6309 |
CREATE TABLE "~type._plots_02_list_of_project_names" ( |
|
6310 |
projectname text |
|
6311 |
); |
|
6312 |
|
|
6313 |
|
|
6314 |
-- |
|
6315 | 6325 |
-- Name: ~type._plots_03_count_of_all_plots_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
6316 | 6326 |
-- |
6317 | 6327 |
|
... | ... | |
6321 | 6331 |
|
6322 | 6332 |
|
6323 | 6333 |
-- |
6324 |
-- Name: ~type._plots_04_count_of_plots_in_each_project_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
6325 |
-- |
|
6326 |
|
|
6327 |
CREATE TABLE "~type._plots_04_count_of_plots_in_each_project_in_this_source" ( |
|
6328 |
project_name text, |
|
6329 |
plots bigint |
|
6330 |
); |
|
6331 |
|
|
6332 |
|
|
6333 |
-- |
|
6334 | 6334 |
-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
6335 | 6335 |
-- |
6336 | 6336 |
|
Also available in: Unified diff
fix: inputs/SALVIAS/validations.sql: _plots_02_list_of_project_names: altered column aliases to match output query