blob: a31898fd358cbe8b63bee34ecb416c96b7b08805 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
|
-- Deploy kakeibo:transactions to pg
-- requires: schema
-- requires: articles
BEGIN;
ALTER TABLE kakeibo.transactions RENAME COLUMN type TO type_code;
ALTER TABLE kakeibo.transactions
ALTER COLUMN type_code TYPE integer
USING CASE type_code WHEN 'outgo' THEN 0 ELSE 1 END;
COMMIT;
|