blob: 6e0787f4a94b3a3fb19997c1c6f8ee515547aa93 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
-- Deploy kakeibo:transactions to pg
-- requires: schema
-- requires: articles
BEGIN;
ALTER TABLE kakeibo.transactions RENAME COLUMN type_code TO type;
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;
|