Project

General

Profile

« Previous | Next » 

Revision 6495

Added by Aaron Marcuse-Kubitza about 12 years ago

schemas/vegbien.sql: sync_analytical_*_to_view(): Added CREATE INDEX statements

View differences:

schemas/vegbien.sql
897 897 
    AS $$
898 898 
DROP TABLE IF EXISTS analytical_aggregate;
899 899 
CREATE TABLE analytical_aggregate AS SELECT * FROM analytical_aggregate_view;
900 

  		




  
  901
  
    
CREATE INDEX ON analytical_aggregate ("institutionCode", "plotName", "dateCollected" );


  		




  900
  902
  
    
$$;


  		




  901
  903
  
    

  		




  902
  904
  
    

  		




  ......




  909
  911
  
    
    AS $$


  		




  910
  912
  
    
DROP TABLE IF EXISTS analytical_stem;


  		




  911
  913
  
    
CREATE TABLE analytical_stem AS SELECT * FROM analytical_stem_view;


  		




  
  914
  
    

  		




  
  915
  
    
CREATE INDEX ON analytical_stem ("institutionCode", "plotName", "dateCollected" );


  		




  912
  916
  
    
$$;


  		




  913
  917
  
    

  		




  914
  918
  
    

  		












Also available in:  Unified diff