Project

General

Profile

« Previous | Next » 

Revision 11749

Added by Aaron Marcuse-Kubitza about 11 years ago

inputs/CVS/: switched to new-style import, using the steps at http://wiki.vegpath.org/Adding_new-style_import_to_a_datasource

View differences:

postprocess.sql
1 1 
SELECT util.search_path_append('util');
2 2 

  		




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


  		




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


  		




  4
  4
  
    

  		




  5
  
  
    
SELECT create_if_not_exists($$CREATE INDEX $$||:table_str||%'_parent'||$$ ON $$||:table_str||$$ ("PLOT_ID")$$); -- runtime: ~0 @starscream


  		




  
  5
  
    
SELECT create_if_not_exists($$CREATE INDEX $$||:table_str||%'_parent'||$$ ON $$||:table_str||$$ ("locationID")$$); -- runtime: ~0 @starscream


  		












Also available in:  Unified diff