Project

General

Profile

« Previous | Next » 

Revision 10811

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/VegBank/*/postprocess.sql: added primary keys to derived tables

View differences:

inputs/VegBank/plantconcept_/postprocess.sql
1 
SELECT util.search_path_append('util');
2 

  		




  
  3
  
    
SELECT create_if_not_exists($$ALTER TABLE $$||:table_str||$$ ADD PRIMARY KEY ("plantconcept_id")$$); -- runtime: 1 s ("Time: 675.125 ms") @starscream


  		












  

    
      inputs/VegBank/stemlocation_/postprocess.sql
    
  





  
  1
  
    
SELECT util.search_path_append('util');


  		




  
  2
  
    

  		




  
  3
  
    
SELECT create_if_not_exists($$ALTER TABLE $$||:table_str||$$ ADD PRIMARY KEY ("stemlocation_id")$$); -- runtime: 0.1 s ("Time: 74.164 ms") @starscream


  		












  

    
      inputs/VegBank/plot_/postprocess.sql
    
  





  
  1
  
    
SELECT util.search_path_append('util');


  		




  
  2
  
    

  		




  
  3
  
    
SELECT create_if_not_exists($$ALTER TABLE $$||:table_str||$$ ADD PRIMARY KEY ("plot_id")$$); -- runtime: 0.2 s ("Time: 238.474 ms") @starscream


  		












Also available in:  Unified diff