diff options
Diffstat (limited to 'sql/000_widen_tokens.sql')
| -rw-r--r-- | sql/000_widen_tokens.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/000_widen_tokens.sql b/sql/000_widen_tokens.sql new file mode 100644 index 0000000..ed358b2 --- /dev/null +++ b/sql/000_widen_tokens.sql @@ -0,0 +1,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; |