Project

General

Profile

« Previous | Next » 

Revision 6166

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/SALVIAS/salvias_plots.~.clean_up.sql: Moved Ensure globally unique column names to end to match VegBank order

View differences:

inputs/SALVIAS/salvias_plots.~.clean_up.sql
1 
-- Ensure globally unique column names when tables are joined
2 
ALTER TABLE "lookup_MethodCode" RENAME "Description" TO "lookup_MethodCode_Description";
3 

  		




  4
  1
  
    
-- Enable cascading deletes


  		




  5
  2
  
    

  		




  6
  3
  
    
CREATE INDEX ON "plotMetadata" (project_id);


  		




  ......




  14
  11
  
    

  		




  15
  12
  
    
-- Remove private data that should not be publicly visible


  		




  16
  13
  
    
DELETE FROM "plotMetadata" WHERE "AccessCode" = 1;


  		




  
  14
  
    

  		




  
  15
  
    
-- Ensure globally unique column names when tables are joined


  		




  
  16
  
    
ALTER TABLE "lookup_MethodCode" RENAME "Description" TO "lookup_MethodCode_Description";


  		












Also available in:  Unified diff