deploy/types.sql


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

-- Deploy kakeibo:types to pg
-- requires: appschema

BEGIN;

CREATE TABLE kakeibo.types (
  code INTEGER PRIMARY KEY,
  name TEXT NOT NULL
);
INSERT INTO kakeibo.types VALUES (0, '支出'),  (1, '収入');

COMMIT;