aboutsummaryrefslogtreecommitdiff
-- 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;