Project

General

Profile

« Previous | Next » 

Revision 12418

fix: inputs/SALVIAS/validations.sql: _plots_02_list_of_project_names: altered column aliases to match output query

View differences:

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