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