Project

General

Profile

« Previous | Next » 

Revision 12757

Added by Aaron Marcuse-Kubitza almost 11 years ago

inputs/CVS/plot_/postprocess.sql: add unique constraint on locationName (analogous to the unique constraint in plot), for use by inputs/VegBank/plot/postprocess.sql in removing inter-datasource duplication

View differences:

trunk/inputs/CVS/plot_/postprocess.sql
2 2 

  		




  3
  3
  
    
SELECT create_if_not_exists($$ALTER TABLE $$||:table_str||$$ ADD PRIMARY KEY ("locationID")$$); -- runtime: ~0 ("78.941 ms") @starscream


  		




  4
  4
  
    

  		




  
  5
  
    
SELECT create_if_not_exists($$ALTER TABLE $$||:table_str||$$ ADD CONSTRAINT $$||:table_str||%'locationName'||$$ UNIQUE("locationName")$$); -- runtime: 0.2 s ("Time: 200.133 ms") @starscream


  		




  5
  6
  
    

  		




  
  7
  
    

  		




  6
  8
  
    
-- map_*() derived cols


  		




  7
  9
  
    
-- runtime: 1 s @starscream


  		




  8
  10
  
    

  		












Also available in:  Unified diff