Project

General

Profile

« Previous | Next » 

Revision 8192

Added by Aaron Marcuse-Kubitza almost 12 years ago

inputs/FIA/*/import: Use new mk_*_col()

View differences:

import
14 14 
, ('authorEventCode', 'integer')
15 15 
]::col_cast[]);
16 16 

  		




  17
  
  
    
SELECT create_if_not_exists($$


  		




  18
  
  
    
ALTER TABLE "COND" ADD   COLUMN "oldGrowth"      boolean;


  		




  19
  
  
    
ALTER TABLE "COND" ALTER COLUMN "oldGrowth" TYPE boolean USING


  		




  
  17
  
    
SELECT mk_derived_col(('"COND"', 'oldGrowth'), $$


  		




  20
  18
  
    
(


  		




  21
  19
  
    
    "COND


  		




  22
  20
  
    
STDAGE"::integer>80


  		




  ......




  42
  40
  
    
)


  		




  43
  41
  
    
OR "COND


  		




  44
  42
  
    
STND_COND_CD_PNWRS"='7'


  		




  45
  
  
    
;


  		




  46
  43
  
    
$$);


  		




  47
  44
  
    

  		




  48
  45
  
    
SELECT create_if_not_exists($$ALTER TABLE "COND" ADD CONSTRAINT "COND.ID"     UNIQUE ("COND


  		












Also available in:  Unified diff