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