Project

General

Profile

« Previous | Next » 

Revision 11815

Added by Aaron Marcuse-Kubitza about 11 years ago

inputs/CVS/cvs.~.clean_up.sql: commClass, commConcept fields: prepend table name to avoid inter-table collisions upon join

View differences:

inputs/CVS/cvs.~.clean_up.sql
3 3 

  		




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


  		




  5
  5
  
    
ALTER TABLE "observationContributor" RENAME "dba_src_ID" TO "observationContributor--dba_src_ID";


  		




  
  6
  
    
ALTER TABLE "commClass" RENAME "commName" TO "commClass--commName";


  		




  
  7
  
    
ALTER TABLE "commClass" RENAME "commLevel" TO "commClass--commLevel";


  		




  
  8
  
    
ALTER TABLE "commClass" RENAME "accessionCode" TO "commClass--accessionCode";


  		




  6
  9
  
    
ALTER TABLE "commClass" RENAME "dba_src_ID" TO "commClass--dba_src_ID";


  		




  
  10
  
    
ALTER TABLE "commConcept" RENAME "dba_src_ID" TO "commConcept--dba_src_ID";


  		




  7
  11
  
    
ALTER TABLE "soilObs" RENAME "dba_src_ID" TO "soilObs_dba_src_ID";


  		




  8
  12
  
    
ALTER TABLE "taxonObservation" RENAME "reference_ID" TO "taxonObservation_reference_ID";


  		




  9
  13
  
    
ALTER TABLE "taxonObservation" RENAME "accessionCode" TO "taxonObservation_accessionCode";


  		












Also available in:  Unified diff