1CREATE TABLE handle_reservations (
2 handle TEXT PRIMARY KEY,
3 reserved_by TEXT NOT NULL,
4 created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
5 expires_at TIMESTAMPTZ NOT NULL DEFAULT NOW() + INTERVAL '5 minutes'
6);
7
8CREATE INDEX idx_handle_reservations_expires ON handle_reservations(expires_at);