From d347e8286bae38b3949f6e0f58d8ab8632cd9c0e Mon Sep 17 00:00:00 2001 From: Jesse Morgan Date: Sun, 23 Feb 2025 17:01:01 -0800 Subject: Track token expiration Force reauthentication after the token expires. --- schema/migrations/0013.sql | 2 ++ schema/mysql.sql | 1 + schema/sqlite.sql | 1 + 3 files changed, 4 insertions(+) create mode 100644 schema/migrations/0013.sql (limited to 'schema') diff --git a/schema/migrations/0013.sql b/schema/migrations/0013.sql new file mode 100644 index 0000000..709ad21 --- /dev/null +++ b/schema/migrations/0013.sql @@ -0,0 +1,2 @@ +ALTER TABLE users +ADD COLUMN `micropub_token_expiration` datetime DEFAULT NULL; 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', diff --git a/schema/sqlite.sql b/schema/sqlite.sql index 310b2ae..9170e83 100644 --- a/schema/sqlite.sql +++ b/schema/sqlite.sql @@ -6,6 +6,7 @@ CREATE TABLE users ( micropub_endpoint TEXT, micropub_media_endpoint TEXT, micropub_access_token TEXT, + micropub_token_expiration datetime, micropub_scope TEXT, micropub_response TEXT, micropub_slug_field TEXT default 'mp-slug', -- cgit v1.2.3