-- Widen token columns and add separate timestamps.
-- Run this before 001_add_api_logs.sql.

-- Widen token columns (JWTs can exceed 255 chars).
ALTER TABLE account MODIFY refresh_token TEXT DEFAULT NULL;
ALTER TABLE account MODIFY access_token  TEXT DEFAULT NULL;

-- Add separate created timestamps if they do not exist.
ALTER TABLE account ADD COLUMN IF NOT EXISTS refresh_token_created TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP;
ALTER TABLE account ADD COLUMN IF NOT EXISTS access_token_created  TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP;