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