accounts/sql/20260205_sessions_token_unique.sql

7 lines
300 B
MySQL
Raw Permalink Normal View History

-- Migration: Add unique constraint on sessions.token
-- Date: 2026-02-05
-- Description: Adds a unique index on the sessions.token column to support
-- the ON CONFLICT clause in session upsert operations.
CREATE UNIQUE INDEX IF NOT EXISTS sessions_token_uk ON public.sessions (token);