SELECT util.search_path_append('util');

SELECT set_col_types('"REF_SPECIES"', ARRAY[

  ('*SPCD', 'integer')

]::col_cast[]);

SELECT mk_const_col(('"REF_SPECIES"', '*PLANT_SYMBOL_TYPE'), 'Species'::text);

SELECT create_if_not_exists($$ALTER TABLE "REF_SPECIES" ADD CONSTRAINT "REF_SPECIES.unique" UNIQUE ("*SPCD")$$);