Project

General

Profile

« Previous | Next » 

Revision 4547

Added by Aaron Marcuse-Kubitza over 12 years ago

inputs/VegBank/vegbank.~.clean_up.sql: Also rename taxonobservation.reference_id to taxonobservation_reference_id

View differences:

inputs/VegBank/vegbank.~.clean_up.sql
65 65 
DROP VIEW view_taxonobs_distinctid_curr_counts_plants CASCADE;
66 66 

  		




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


  		




  
  68
  
    
ALTER TABLE taxonobservation RENAME reference_id  TO taxonobservation_reference_id;


  		




  68
  69
  
    
ALTER TABLE taxonobservation RENAME accessioncode  TO taxonobservation_accessioncode;


  		




  69
  70
  
    
ALTER TABLE taxoninterpretation RENAME plantname_id  TO taxoninterpretation_plantname_id;


  		




  70
  71
  
    
ALTER TABLE taxoninterpretation RENAME accessioncode  TO taxoninterpretation_accessioncode;


  		












Also available in:  Unified diff