-- Add status to user_invites to reflect invitation lifecycle
ALTER TABLE user_invites ADD COLUMN IF NOT EXISTS status VARCHAR(32) DEFAULT 'clicked' NOT NULL;
CREATE INDEX IF NOT EXISTS idx_user_invites_status ON user_invites(status);

