dc348238f1
- Fixed CreateSession and GetSession SQL queries to use user_uuid instead of user_id - Added unique constraint on sessions.token column for proper upsert support - Created migration file to add the unique index to existing databases This fixes the 500 error on /api/auth/login caused by session creation failure
7 lines
300 B
SQL
7 lines
300 B
SQL
-- 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);
|