Project

General

Profile

Download (692 Bytes) Statistics
| Revision:

root/inputs/FIA/PLOT/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 "PLOT" RENAME "PLOT.STATECD"  TO ".STATECD" $$);


      

      

        4
        
        
        
        
        
SELECT functions.rename_if_exists($$ALTER TABLE "PLOT" RENAME "PLOT.UNITCD"   TO ".UNITCD"  $$);


      

      

        5
        
        
        
        
        
SELECT functions.rename_if_exists($$ALTER TABLE "PLOT" RENAME "PLOT.COUNTYCD" TO ".COUNTYCD"$$);


      

      

        6
        
        
        
        
        
SELECT functions.rename_if_exists($$ALTER TABLE "PLOT" RENAME "PLOT.PLOT"     TO ".PLOT"    $$);


      

      

        7
        
        
        
        
        
SELECT functions.rename_if_exists($$ALTER TABLE "PLOT" RENAME "PLOT.INVYR"    TO ".INVYR"   $$);


      

      

        8
        
        
        
        
        

      

      

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