summaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
authorJesse Morgan <jesse@jesterpm.net>2022-03-21 23:02:31 -0700
committerJesse Morgan <jesse@jesterpm.net>2025-02-23 14:40:49 -0800
commitda6f3f78965e1af2738a25b67126e396f881a0c9 (patch)
tree8c4ca881bfff4e3554d527fcb787ec37018cd419 /schema
parent7962df92f6aa6aac981d456ab1363a8ee6936091 (diff)
Diffstat (limited to 'schema')
-rw-r--r--schema/migrations/0012.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/0012.sql b/schema/migrations/0012.sql
new file mode 100644
index 0000000..9b1cc90
--- /dev/null
+++ b/schema/migrations/0012.sql
@@ -0,0 +1,2 @@
+ALTER TABLE users
+ADD COLUMN `micropub_optin_html_content` tinyint(4) DEFAULT '1';
diff --git a/schema/mysql.sql b/schema/mysql.sql
index 0a0accb..d262c77 100644
--- a/schema/mysql.sql
+++ b/schema/mysql.sql
@@ -11,6 +11,7 @@ CREATE TABLE `users` (
`micropub_slug_field` varchar(255) NOT NULL DEFAULT 'mp-slug',
`micropub_syndicate_field` varchar(255) NOT NULL DEFAULT 'mp-syndicate-to',
`micropub_success` tinyint(4) DEFAULT '0',
+ `micropub_optin_html_content` tinyint(4) DEFAULT '0',
`date_created` datetime DEFAULT NULL,
`last_login` datetime DEFAULT NULL,
`last_micropub_response` text,
diff --git a/schema/sqlite.sql b/schema/sqlite.sql
index dd041b3..107c9a9 100644
--- a/schema/sqlite.sql
+++ b/schema/sqlite.sql
@@ -10,6 +10,7 @@ CREATE TABLE users (
micropub_response TEXT,
micropub_slug_field TEXT default 'mp-slug',
micropub_syndicate_field TEXT default 'mp-syndicate-to',
+ micropub_optin_html_content INTEGER default 0,
micropub_success INTEGER default 0,
date_created datetime,
last_login datetime,