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:

inputs/FIA/COND/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


  		












  

    
      inputs/FIA/REF_SPECIES/import
    
  





  9
  9
  
    
  ('SPCD', 'integer')


  		




  10
  10
  
    
]::col_cast[]);


  		




  11
  11
  
    

  		




  12
  
  
    
SELECT create_if_not_exists($$ALTER TABLE "REF_SPECIES" ADD COLUMN "PLANT_SYMBOL_TYPE" text NOT NULL DEFAULT 'Species'$$);


  		




  
  12
  
    
SELECT mk_const_col(('"REF_SPECIES"', 'PLANT_SYMBOL_TYPE'), 'Species'::text);


  		




  13
  13
  
    

  		




  14
  14
  
    
SELECT create_if_not_exists($$ALTER TABLE "REF_SPECIES" ADD CONSTRAINT "REF_SPECIES.unique" UNIQUE ("SPCD")$$);


  		












Also available in:  Unified diff