blob: ed358b26124b3a7ea8196a6b58bd97286581b4af (
plain)
1
2
3
4
5
6
7
8
9
10
|
-- 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;
|
