qshub / migrations /002_add_token_version.sql
basel00omar's picture
THE QS HUB v2.0 - Complete React + FastAPI Platform (clean deploy)
1b4b6d2
Raw History Blame Contribute Delete
298 Bytes
-- Add token_version column to qto_users for instant session revocation.
-- Bumping token_version invalidates ALL active sessions for that user.
-- Default 0 so existing tokens (without version) are treated as version 0.
ALTER TABLE qto_users ADD COLUMN IF NOT EXISTS token_version INT DEFAULT 0;