~singpolyma/jmp-schemas

ref: 12f3a3329df2e17d501945115e3e8a37f98ea077 jmp-schemas/deploy/plan_log.sql -rw-r--r-- 262 bytes
12f3a332Stephen Paul Weber Add an optional note to transactions 1 year, 11 months ago
                                                                                
1
2
3
4
5
6
7
8
9
10
11
12
13
14
-- Deploy jmp:plan_log to pg

BEGIN;

CREATE TABLE plan_log (
	customer_id TEXT      NOT NULL,
	plan_name   TEXT      NOT NULL,
	starts_at   TIMESTAMP NOT NULL,
	expires_at  TIMESTAMP NOT NULL
);

CREATE INDEX ON plan_log (customer_id, starts_at DESC);

COMMIT;