blob: e37b2760bae13072f788dfd1a27e4a08e4423fd7 (
about) (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
-- Deploy kakeibo:transactions to pg
-- requires: schema
BEGIN;
CREATE TABLE kakeibo.transactions (
id SERIAL PRIMARY KEY,
type_code INTEGER,
date DATE NOT NULL,
note TEXT,
created_at TIMESTAMP NOT NULL DEFAULT NOW(),
updated_at TIMESTAMP NOT NULL DEFAULT NOW()
);
COMMIT;
|