Project

General

Profile

« Previous | Next » 

Revision 8166

Added by Aaron Marcuse-Kubitza almost 12 years ago

inputs/FIA/*/map.csv: Removed no longer needed leading . from joined fields (globally-unique terms), because functions.to_global_col_names() is not used anymore

View differences:

import
11 11 
, ('.COUNTYCD', 'integer')
12 12 
]::functions.col_cast[]);
13 13 

  		




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


  		




  15
  
  
    
SELECT functions.create_if_not_exists($$ALTER TABLE "COUNTY" ADD CONSTRAINT "COUNTY.unique" UNIQUE (".STATECD", ".UNITCD", ".COUNTYCD")$$);


  		




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


  		




  
  15
  
    
SELECT functions.create_if_not_exists($$ALTER TABLE "COUNTY" ADD CONSTRAINT "COUNTY.unique" UNIQUE ("STATECD", "UNITCD", "COUNTYCD")$$);


  		












Also available in:  Unified diff