1
2
3
4
5
6
7
8
9
10
11
|
-- migration 0001_init.sql
BEGIN;
CREATE TABLE IF NOT EXISTS payments (
id BIGSERIAL PRIMARY KEY,
external_id TEXT NOT NULL UNIQUE,
amount_cents BIGINT NOT NULL DEFAULT 0,
created_at TIMESTAMPTZ NOT NULL DEFAULT now(),
updated_at TIMESTAMPTZ NOT NULL DEFAULT now()
);
CREATE INDEX IF NOT EXISTS idx_payments_external ON payments(external_id);
COMMIT;
|