ALTER TABLE value
ADD COLUMN value_numeric NUMERIC;

ALTER TABLE value
RENAME COLUMN value TO value_text;