summaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
Diffstat (limited to 'schema')
-rw-r--r--schema/migrations/0013.sql2
-rw-r--r--schema/mysql.sql1
-rw-r--r--schema/sqlite.sql1
3 files changed, 4 insertions, 0 deletions
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',