Project

General

Profile

« Previous | Next » 

Revision 8130

Added by Aaron Marcuse-Kubitza almost 12 years ago

inputs/FIA/*/postprocess.sql: Added index on *.CN (autogen IDs)

View differences:

postprocess.sql
16 16 
, ('.SUBP'    , 'integer')
17 17 
]::functions.col_cast[]);
18 18 

  		




  
  19
  
    
SELECT functions.create_if_not_exists($$ALTER TABLE "SUBPLOT" ADD CONSTRAINT "SUBPLOT.ID"     UNIQUE ("SUBPLOT.CN")                                                  $$);


  		




  19
  20
  
    
SELECT functions.create_if_not_exists($$ALTER TABLE "SUBPLOT" ADD CONSTRAINT "SUBPLOT.unique" UNIQUE (".STATECD", ".UNITCD", ".COUNTYCD", ".PLOT", ".INVYR", ".SUBP")$$);


  		




  20
  21
  
    
SELECT functions.cluster_once(:table_str, '"SUBPLOT.unique"');


  		












Also available in:  Unified diff