migrations/002_scope_sessions_per_user.sql

Rama main · réplica de lectura del repositorio original.

BEGIN;

ALTER TABLE sessions DROP CONSTRAINT IF EXISTS sessions_session_id_key;

DROP INDEX IF EXISTS sessions_session_id_key;

CREATE UNIQUE INDEX IF NOT EXISTS uq_sessions_user_session_id
    ON sessions (user_id, session_id);

COMMIT;