From d347e8286bae38b3949f6e0f58d8ab8632cd9c0e Mon Sep 17 00:00:00 2001
From: Jesse Morgan <jesse@jesterpm.net>
Date: Sun, 23 Feb 2025 17:01:01 -0800
Subject: Track token expiration

Force reauthentication after the token expires.
---
 schema/mysql.sql | 1 +
 1 file changed, 1 insertion(+)

(limited to 'schema/mysql.sql')

diff --git a/schema/mysql.sql b/schema/mysql.sql
index d6210d9..63b8346 100644
--- a/schema/mysql.sql
+++ b/schema/mysql.sql
@@ -6,6 +6,7 @@ CREATE TABLE `users` (
   `micropub_endpoint` varchar(255) DEFAULT NULL,
   `micropub_media_endpoint` varchar(255) DEFAULT NULL,
   `micropub_access_token` text,
+  `micropub_token_expiration` datetime DEFAULT NULL,
   `micropub_scope` varchar(255) DEFAULT NULL,
   `micropub_response` text,
   `micropub_slug_field` varchar(255) NOT NULL DEFAULT 'mp-slug',
-- 
cgit v1.2.3

