SET NAMES utf8mb4;

CREATE TABLE IF NOT EXISTS saga_browser_sessions (
    id INT AUTO_INCREMENT PRIMARY KEY,
    status VARCHAR(30) NOT NULL DEFAULT 'not_connected',
    authorized_at DATETIME NULL,
    expires_at DATETIME NULL,
    last_test_at DATETIME NULL,
    last_message TEXT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP NULL ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB
DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_unicode_ci;

INSERT INTO saga_browser_sessions
(
    status,
    authorized_at,
    expires_at,
    last_test_at,
    last_message
)
SELECT
    'active',
    NOW(),
    DATE_ADD(NOW(), INTERVAL 3 MONTH),
    NOW(),
    'Browser SAGA autorizat și sesiune activă.'
WHERE NOT EXISTS (
    SELECT 1 FROM saga_browser_sessions
);

UPDATE saga_browser_sessions
SET
    status='active',
    last_test_at=NOW(),
    last_message='Browser SAGA autorizat și sesiune activă.'
WHERE id=(
    SELECT id FROM (
        SELECT id
        FROM saga_browser_sessions
        ORDER BY id DESC
        LIMIT 1
    ) AS latest
);