Project

General

Profile

Download (800 Bytes) Statistics
| Revision:

root/inputs/FIA/COND/postprocess.sql @ 8098

1 8093 aaronmk 
SELECT functions.to_global_col_names(:table_str);
2 

      

      

        3
        
            8098
        
        
            aaronmk
        
        
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
        
        
        
        
        

      

      

        10
        
        
        
        
        
SELECT functions.create_if_not_exists($$ALTER TABLE "COND" ADD CONSTRAINT "COND.unique" UNIQUE (".STATECD", ".UNITCD", ".COUNTYCD", ".PLOT", ".INVYR", ".CONDID")$$);