Project

General

Profile

« Previous | Next » 

Revision 14944

Added by Aaron Marcuse-Kubitza about 10 years ago

schemas/public_.sql: added 2014-11-16.Ana_Maria_Csergo.demography_and_habitat.public view

View differences:

trunk/schemas/vegbien.my.sql
4457 4457 

  		




  4458
  4458
  
    

  		




  4459
  4459
  
    
--


  		




  
  4460
  
    
-- Name: 2014-11-16.Ana_Maria_Csergo.demography_and_habitat.public; Type: VIEW; Schema: public; Owner: -


  		




  
  4461
  
    
--


  		




  
  4462
  
    

  		




  
  4463
  
    

  		




  
  4464
  
    

  		




  
  4465
  
    

  		




  
  4466
  
    
--


  		




  4460
  4467
  
    
-- Name: 2014-3-11.Jeff_Ott.climatic_range_determinants; Type: VIEW; Schema: public; Owner: -


  		




  4461
  4468
  
    
--


  		




  4462
  4469
  
    

  		




  ......




  14595
  14602
  
    

  		




  14596
  14603
  
    

  		




  14597
  14604
  
    
--


  		




  
  14605
  
    
-- Name: 2014-11-16.Ana_Maria_Csergo.demography_and_habitat.public; Type: ACL; Schema: public; Owner: -


  		




  
  14606
  
    
--


  		




  
  14607
  
    

  		




  
  14608
  
    

  		




  
  14609
  
    

  		




  
  14610
  
    

  		




  
  14611
  
    

  		




  
  14612
  
    

  		




  
  14613
  
    

  		




  
  14614
  
    
--


  		




  14598
  14615
  
    
-- Name: 2014-3-11.Jeff_Ott.climatic_range_determinants; Type: ACL; Schema: public; Owner: -


  		




  14599
  14616
  
    
--


  		




  14600
  14617
  
    

  		












  

    
      trunk/schemas/public_.sql
    
  





  7128
  7128
  
    

  		




  7129
  7129
  
    

  		




  7130
  7130
  
    
--


  		




  
  7131
  
    
-- Name: 2014-11-16.Ana_Maria_Csergo.demography_and_habitat.public; Type: VIEW; Schema: public; Owner: -


  		




  
  7132
  
    
--


  		




  
  7133
  
    

  		




  
  7134
  
    
CREATE VIEW "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.public" AS


  		




  
  7135
  
    
 SELECT "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".datasource,


  		




  
  7136
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".country,


  		




  
  7137
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".locality,


  		




  
  7138
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".latitude,


  		




  
  7139
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".longitude,


  		




  
  7140
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".coord_uncertainty_m,


  		




  
  7141
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".georef_sources,


  		




  
  7142
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".georef_protocol,


  		




  
  7143
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".is_geovalid,


  		




  
  7144
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".is_new_world,


  		




  
  7145
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".is_location_cultivated,


  		




  
  7146
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".custodial_institution_codes,


  		




  
  7147
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".collection_code,


  		




  
  7148
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".catalog_number,


  		




  
  7149
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".recorded_by,


  		




  
  7150
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".date_collected,


  		




  
  7151
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".verbatim_family,


  		




  
  7152
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".verbatim_scientific_name,


  		




  
  7153
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".identified_by,


  		




  
  7154
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".date_identified,


  		




  
  7155
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".identification_remarks,


  		




  
  7156
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".family_matched,


  		




  
  7157
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".name_matched,


  		




  
  7158
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".name_matched_author,


  		




  
  7159
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".taxonomic_status,


  		




  
  7160
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".scrubbed_family,


  		




  
  7161
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".scrubbed_genus,


  		




  
  7162
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".scrubbed_specific_epithet,


  		




  
  7163
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".scrubbed_species_binomial,


  		




  
  7164
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".scrubbed_taxon_name_no_author,


  		




  
  7165
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".scrubbed_author,


  		




  
  7166
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".scrubbed_taxon_name_with_author,


  		




  
  7167
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".is_cultivated


  		




  
  7168
  
    
   FROM "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private"


  		




  
  7169
  
    
  WHERE ("2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".datasource = ANY (public_datasources()));


  		




  
  7170
  
    

  		




  
  7171
  
    

  		




  
  7172
  
    
--


  		




  7131
  7173
  
    
-- Name: 2014-3-11.Jeff_Ott.climatic_range_determinants; Type: VIEW; Schema: public; Owner: -


  		




  7132
  7174
  
    
--


  		




  7133
  7175
  
    

  		




  ......




  19323
  19365
  
    

  		




  19324
  19366
  
    

  		




  19325
  19367
  
    
--


  		




  
  19368
  
    
-- Name: 2014-11-16.Ana_Maria_Csergo.demography_and_habitat.public; Type: ACL; Schema: public; Owner: -


  		




  
  19369
  
    
--


  		




  
  19370
  
    

  		




  
  19371
  
    
REVOKE ALL ON TABLE "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.public" FROM PUBLIC;


  		




  
  19372
  
    
REVOKE ALL ON TABLE "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.public" FROM bien;


  		




  
  19373
  
    
GRANT ALL ON TABLE "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.public" TO bien;


  		




  
  19374
  
    
GRANT SELECT ON TABLE "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.public" TO bien_read;


  		




  
  19375
  
    

  		




  
  19376
  
    

  		




  
  19377
  
    
--


  		




  19326
  19378
  
    
-- Name: 2014-3-11.Jeff_Ott.climatic_range_determinants; Type: ACL; Schema: public; Owner: -


  		




  19327
  19379
  
    
--


  		




  19328
  19380
  
    

  		












  

    
      trunk/schemas/vegbien.sql
    
  





  7128
  7128
  
    

  		




  7129
  7129
  
    

  		




  7130
  7130
  
    
--


  		




  
  7131
  
    
-- Name: 2014-11-16.Ana_Maria_Csergo.demography_and_habitat.public; Type: VIEW; Schema: public; Owner: -


  		




  
  7132
  
    
--


  		




  
  7133
  
    

  		




  
  7134
  
    
CREATE VIEW "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.public" AS


  		




  
  7135
  
    
 SELECT "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".datasource,


  		




  
  7136
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".country,


  		




  
  7137
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".locality,


  		




  
  7138
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".latitude,


  		




  
  7139
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".longitude,


  		




  
  7140
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".coord_uncertainty_m,


  		




  
  7141
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".georef_sources,


  		




  
  7142
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".georef_protocol,


  		




  
  7143
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".is_geovalid,


  		




  
  7144
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".is_new_world,


  		




  
  7145
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".is_location_cultivated,


  		




  
  7146
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".custodial_institution_codes,


  		




  
  7147
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".collection_code,


  		




  
  7148
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".catalog_number,


  		




  
  7149
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".recorded_by,


  		




  
  7150
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".date_collected,


  		




  
  7151
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".verbatim_family,


  		




  
  7152
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".verbatim_scientific_name,


  		




  
  7153
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".identified_by,


  		




  
  7154
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".date_identified,


  		




  
  7155
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".identification_remarks,


  		




  
  7156
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".family_matched,


  		




  
  7157
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".name_matched,


  		




  
  7158
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".name_matched_author,


  		




  
  7159
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".taxonomic_status,


  		




  
  7160
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".scrubbed_family,


  		




  
  7161
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".scrubbed_genus,


  		




  
  7162
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".scrubbed_specific_epithet,


  		




  
  7163
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".scrubbed_species_binomial,


  		




  
  7164
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".scrubbed_taxon_name_no_author,


  		




  
  7165
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".scrubbed_author,


  		




  
  7166
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".scrubbed_taxon_name_with_author,


  		




  
  7167
  
    
    "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".is_cultivated


  		




  
  7168
  
    
   FROM "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private"


  		




  
  7169
  
    
  WHERE ("2014-11-16.Ana_Maria_Csergo.demography_and_habitat.private".datasource = ANY (public_datasources()));


  		




  
  7170
  
    

  		




  
  7171
  
    

  		




  
  7172
  
    
--


  		




  7131
  7173
  
    
-- Name: 2014-3-11.Jeff_Ott.climatic_range_determinants; Type: VIEW; Schema: public; Owner: -


  		




  7132
  7174
  
    
--


  		




  7133
  7175
  
    

  		




  ......




  19323
  19365
  
    

  		




  19324
  19366
  
    

  		




  19325
  19367
  
    
--


  		




  
  19368
  
    
-- Name: 2014-11-16.Ana_Maria_Csergo.demography_and_habitat.public; Type: ACL; Schema: public; Owner: -


  		




  
  19369
  
    
--


  		




  
  19370
  
    

  		




  
  19371
  
    
REVOKE ALL ON TABLE "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.public" FROM PUBLIC;


  		




  
  19372
  
    
REVOKE ALL ON TABLE "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.public" FROM bien;


  		




  
  19373
  
    
GRANT ALL ON TABLE "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.public" TO bien;


  		




  
  19374
  
    
GRANT SELECT ON TABLE "2014-11-16.Ana_Maria_Csergo.demography_and_habitat.public" TO bien_read;


  		




  
  19375
  
    

  		




  
  19376
  
    

  		




  
  19377
  
    
--


  		




  19326
  19378
  
    
-- Name: 2014-3-11.Jeff_Ott.climatic_range_determinants; Type: ACL; Schema: public; Owner: -


  		




  19327
  19379
  
    
--


  		




  19328
  19380
  
    

  		












Also available in:  Unified diff