SELECT functions.to_global_col_names(:table_str);

SELECT functions.rename_if_exists($$ALTER TABLE "REF_PLANT_DICTIONARY" RENAME "REF_PLANT_DICTIONARY.SYMBOL_TYPE" TO ".SYMBOL_TYPE"$$);

SELECT functions.rename_if_exists($$ALTER TABLE "REF_PLANT_DICTIONARY" RENAME "REF_PLANT_DICTIONARY.SYMBOL"      TO ".SYMBOL"     $$);

-- Remove 56 duplicate symbols of type 'Old' (these are ambiguous)

DELETE FROM :table

WHERE ".SYMBOL" IN (

    SELECT ".SYMBOL"

    FROM :table

    WHERE ".SYMBOL_TYPE" = 'Old'

    GROUP BY ".SYMBOL"

    HAVING count(*) > 1

);

SELECT functions.create_if_not_exists($$ALTER TABLE "REF_PLANT_DICTIONARY" ADD CONSTRAINT "REF_PLANT_DICTIONARY.unique" UNIQUE (".SYMBOL_TYPE", ".SYMBOL")$$);