Project

General

Profile

« Previous | Next » 

Revision 8122

Added by Aaron Marcuse-Kubitza almost 12 years ago

inputs/FIA/COND/postprocess.sql: Matched COND.HABTYPCD1, COND.HABTYPCD1_PUB_CD to REF_HABTYP_DESCRIPTION

View differences:

inputs/FIA/COND/postprocess.sql
1 1 
SELECT functions.to_global_col_names(:table_str);
2 2 

  		




  3
  
  
    
SELECT functions.rename_if_exists($$ALTER TABLE "COND" RENAME "COND.STATECD"  TO ".STATECD" $$);


  		




  4
  
  
    
SELECT functions.rename_if_exists($$ALTER TABLE "COND" RENAME "COND.UNITCD"   TO ".UNITCD"  $$);


  		




  5
  
  
    
SELECT functions.rename_if_exists($$ALTER TABLE "COND" RENAME "COND.COUNTYCD" TO ".COUNTYCD"$$);


  		




  6
  
  
    
SELECT functions.rename_if_exists($$ALTER TABLE "COND" RENAME "COND.PLOT"     TO ".PLOT"    $$);


  		




  7
  
  
    
SELECT functions.rename_if_exists($$ALTER TABLE "COND" RENAME "COND.INVYR"    TO ".INVYR"   $$);


  		




  8
  
  
    
SELECT functions.rename_if_exists($$ALTER TABLE "COND" RENAME "COND.CONDID"   TO ".CONDID"  $$);


  		




  
  3
  
    
SELECT functions.rename_if_exists($$ALTER TABLE "COND" RENAME "COND.STATECD"          TO ".STATECD"      $$);


  		




  
  4
  
    
SELECT functions.rename_if_exists($$ALTER TABLE "COND" RENAME "COND.UNITCD"           TO ".UNITCD"       $$);


  		




  
  5
  
    
SELECT functions.rename_if_exists($$ALTER TABLE "COND" RENAME "COND.COUNTYCD"         TO ".COUNTYCD"     $$);


  		




  
  6
  
    
SELECT functions.rename_if_exists($$ALTER TABLE "COND" RENAME "COND.PLOT"             TO ".PLOT"         $$);


  		




  
  7
  
    
SELECT functions.rename_if_exists($$ALTER TABLE "COND" RENAME "COND.INVYR"            TO ".INVYR"        $$);


  		




  
  8
  
    
SELECT functions.rename_if_exists($$ALTER TABLE "COND" RENAME "COND.CONDID"           TO ".CONDID"       $$);


  		




  
  9
  
    
SELECT functions.rename_if_exists($$ALTER TABLE "COND" RENAME "COND.HABTYPCD1"        TO ".HABTYPCD"     $$);


  		




  
  10
  
    
SELECT functions.rename_if_exists($$ALTER TABLE "COND" RENAME "COND.HABTYPCD1_PUB_CD" TO ".HABTYP_PUB_CD"$$);


  		




  9
  11
  
    

  		




  10
  12
  
    
SELECT functions.set_col_types(:table_str, ARRAY[


  		




  11
  13
  
    
  ('.STATECD' , 'integer')


  		












Also available in:  Unified diff