ALTER TABLE forward_sessions ADD COLUMN browser TEXT CHECK (browser IS NULL OR (length(browser) = 32 AND browser NOT GLOB '*[^0-9a-f]*')); CREATE INDEX forward_sessions_browser_idx ON forward_sessions(user_id, browser) WHERE browser IS NOT NULL;