summaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
authorJesse Morgan <jesse@jesterpm.net>2025-02-23 16:50:30 -0800
committerJesse Morgan <jesse@jesterpm.net>2025-02-23 16:50:30 -0800
commit9cef96e19452ec5fd9857ef64eca48e7c8690b5d (patch)
tree2836fc1a0f787a11544329d1468ca0a5b46a1961 /schema
parent8ecaed3d2f5a19bf1a5c4cb077658e1bd3bc8438 (diff)
parentda6f3f78965e1af2738a25b67126e396f881a0c9 (diff)
Merge branch 'fix-location-header' into local-install
Diffstat (limited to 'schema')
-rw-r--r--schema/migrations/0014.sql3
-rw-r--r--schema/mysql.sql1
-rw-r--r--schema/sqlite.sql1
3 files changed, 5 insertions, 0 deletions
diff --git a/schema/migrations/0014.sql b/schema/migrations/0014.sql
new file mode 100644
index 0000000..40b97c1
--- /dev/null
+++ b/schema/migrations/0014.sql
@@ -0,0 +1,3 @@
+ALTER TABLE users
+ADD COLUMN `micropub_optin_html_content` tinyint(4) DEFAULT '1';
+
diff --git a/schema/mysql.sql b/schema/mysql.sql
index d6210d9..3d2b45e 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 310b2ae..3283960 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,