Project

General

Profile

Download (840 Bytes) Statistics
| Revision:

root/inputs/FIA/SUBPLOT/postprocess.sql @ 8099

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

      

      

        3
        
            8098
        
        
            aaronmk
        
        
SELECT functions.rename_if_exists($$ALTER TABLE "SUBPLOT" RENAME "SUBPLOT.STATECD"  TO ".STATECD" $$);


      

      

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


      

      

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


      

      

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


      

      

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


      

      

        8
        
        
        
        
        
SELECT functions.rename_if_exists($$ALTER TABLE "SUBPLOT" RENAME "SUBPLOT.SUBP"     TO ".SUBP"    $$);


      

      

        9
        
        
        
        
        

      

      

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