From da6f3f78965e1af2738a25b67126e396f881a0c9 Mon Sep 17 00:00:00 2001
From: Jesse Morgan <jesse@jesterpm.net>
Date: Mon, 21 Mar 2022 23:02:31 -0700
Subject: Fix schema

---
 schema/migrations/0012.sql | 2 ++
 schema/mysql.sql           | 1 +
 schema/sqlite.sql          | 1 +
 3 files changed, 4 insertions(+)
 create mode 100644 schema/migrations/0012.sql

(limited to 'schema')

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,
-- 
cgit v1.2.3