deploy/transaction_types.sql


1
2
3
4
5
6
7
8
9
10
11
12

-- Deploy kakeibo:transaction_types to pg
-- requires: schema

BEGIN;

CREATE TABLE kakeibo.transaction_types (
  code INTEGER PRIMARY KEY,
  name TEXT NOT NULL
);
INSERT INTO kakeibo.transaction_types VALUES (0, 'outgo'),  (1, 'income');

COMMIT;