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