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;