Project

General

Profile

« Previous | Next » 

Revision 6082

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/VegBank/vegbank.~.clean_up.sql: Remove private columns (plot.reallatitude, reallongitude) that should not be publicly visible

View differences:

vegbank.~.clean_up.sql
64 64 
DROP VIEW IF EXISTS view_taxonobs_distinctid_curr_counts CASCADE;
65 65 
DROP VIEW IF EXISTS view_taxonobs_distinctid_curr_counts_plants CASCADE;
66 66 

  		




  
  67
  
    
-- Remove private columns that should not be publicly visible


  		




  
  68
  
    
ALTER TABLE plot DROP COLUMN reallatitude;


  		




  
  69
  
    
ALTER TABLE plot DROP COLUMN reallongitude;


  		




  
  70
  
    

  		




  67
  71
  
    
-- Prevent "column name specified more than once" errors when tables are joined


  		




  68
  72
  
    
ALTER TABLE taxonobservation RENAME reference_id  TO taxonobservation_reference_id;


  		




  69
  73
  
    
ALTER TABLE taxonobservation RENAME accessioncode  TO taxonobservation_accessioncode;


  		












Also available in:  Unified diff