Project

General

Profile

Download (1.17 KB) Statistics
| Revision:

root/inputs/FIA/TREE/postprocess.sql @ 8101

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

      

      

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


      

      

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


      

      

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


      

      

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


      

      

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


      

      

        8
        
        
        
        
        
SELECT functions.rename_if_exists($$ALTER TABLE "TREE" RENAME "TREE.CONDID"   TO ".CONDID"  $$);


      

      

        9
        
        
        
        
        
SELECT functions.rename_if_exists($$ALTER TABLE "TREE" RENAME "TREE.SUBP"     TO ".SUBP"    $$);


      

      

        10
        
        
        
        
        
SELECT functions.rename_if_exists($$ALTER TABLE "TREE" RENAME "TREE.SPCD"     TO ".SPCD"    $$);


      

      

        11
        
        
        
        
        

      

      

        12
        
            7793
        
        
            aaronmk
        
        
-- ("STATECD", "UNITCD", "COUNTYCD", "PLOT", "INVYR", "CONDID", "SUBP", "TREE", "STATUSCD") is not unique


      

      

        13
        
            8093
        
        
            aaronmk
        
        
SELECT functions.create_if_not_exists($$ALTER TABLE "TREE" ADD CONSTRAINT "TREE.unique" UNIQUE ("TREE.CN")$$);


      

      

        14
        
            8099
        
        
            aaronmk
        
        

      

      

        15
        
        
        
        
        
SELECT functions.create_if_not_exists($$CREATE INDEX "TREE.parent" ON "TREE" (".STATECD", ".UNITCD", ".COUNTYCD", ".PLOT", ".INVYR", ".CONDID", ".SUBP")$$);