Project

General

Profile

« Previous | Next » 

Revision 8119

Added by Aaron Marcuse-Kubitza almost 12 years ago

inputs/FIA/REF_HABTYP_DESCRIPTION/postprocess.sql: Prepare columns for joining with COND

View differences:

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

  		




  
  3
  
    
SELECT functions.rename_if_exists($$ALTER TABLE "REF_HABTYP_DESCRIPTION" RENAME "REF_HABTYP_DESCRIPTION.HABTYPCD" TO ".HABTYPCD"     $$);


  		




  
  4
  
    
SELECT functions.rename_if_exists($$ALTER TABLE "REF_HABTYP_DESCRIPTION" RENAME "REF_HABTYP_DESCRIPTION.PUB_CD"   TO ".HABTYP_PUB_CD"$$);


  		




  
  5
  
    

  		




  
  6
  
    
SELECT functions.create_if_not_exists($$ALTER TABLE "REF_HABTYP_DESCRIPTION" ADD CONSTRAINT "REF_HABTYP_DESCRIPTION.unique" UNIQUE (".HABTYPCD", ".HABTYP_PUB_CD")$$);


  		












Also available in:  Unified diff