-- Deploy jmp:invites to pg

BEGIN;

CREATE TABLE invites (
	creator_id TEXT NOT NULL,
	used_by_id TEXT,
	created_at TIMESTAMP NOT NULL DEFAULT(LOCALTIMESTAMP),
	used_at    TIMESTAMP,
	code       CITEXT NOT NULL PRIMARY KEY
	           DEFAULT(UPPER(ENCODE(GEN_RANDOM_BYTES(4), 'hex')))
);

CREATE INDEX ON invites (creator_id, created_at DESC);
CREATE INDEX ON invites (used_by_id, used_at DESC);

COMMIT;