deploy/transactions.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

-- Deploy kakeibo:transactions to pg
-- requires: appschema
-- requires: transaction_type

BEGIN;

CREATE TABLE kakeibo.transactions (
  id SERIAL PRIMARY KEY,
  type kakeibo.transaction_type NOT NULL,
  date DATE NOT NULL,
  note TEXT,
  created_at TIMESTAMP NOT NULL DEFAULT NOW(),
  updated_at TIMESTAMP NOT NULL DEFAULT NOW()
);

COMMIT;