-- CESTÃO VALENÇA — HOTFIX ATUAL DA FASE 92
-- Corrige a estrutura de sessão usada por cadastro/login.
-- Não contém banco completo nem SQL de fases anteriores.

SET NAMES utf8mb4;

SET @db := DATABASE();

SET @has_expires := (
    SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS
    WHERE TABLE_SCHEMA=@db AND TABLE_NAME='auth_tokens' AND COLUMN_NAME='expires_at'
);
SET @sql := IF(
    @has_expires=0,
    'ALTER TABLE auth_tokens ADD COLUMN expires_at DATETIME NULL AFTER created_at',
    'SELECT 1'
);
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

SET @has_last_used := (
    SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS
    WHERE TABLE_SCHEMA=@db AND TABLE_NAME='auth_tokens' AND COLUMN_NAME='last_used_at'
);
SET @sql := IF(
    @has_last_used=0,
    'ALTER TABLE auth_tokens ADD COLUMN last_used_at DATETIME NULL AFTER expires_at',
    'SELECT 1'
);
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;