aboutsummaryrefslogtreecommitdiff
-- Revert kakeibo:transaction_type_to_integer from pg

BEGIN;

ALTER TABLE kakeibo.transactions ALTER COLUMN type TYPE kakeibo.transaction_type
  USING CASE type WHEN 0 THEN 'outgo'::kakeibo.transaction_type ELSE 'income'::kakeibo.transaction_type END;

COMMIT;