Project

General

Profile

« Previous | Next » 

Revision 6163

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/SALVIAS/salvias_plots.~.clean_up.sql: Remove private data that should not be publicly visible, indicated by plotMetadata.AccessCode = 1

View differences:

salvias_plots.~.clean_up.sql
11 11 

  		




  12
  12
  
    
CREATE INDEX ON stems ("PlotObsID");


  		




  13
  13
  
    
ALTER TABLE stems ADD FOREIGN KEY ("PlotObsID") REFERENCES "plotObservations"("PlotObsID") ON UPDATE CASCADE ON DELETE CASCADE;


  		




  
  14
  
    

  		




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


  		




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


  		












Also available in:  Unified diff