add a `manual_only` (manual trust only) moderation option + handle more `reject_unknown`/graylist mode caveats

3 files changed, 23 insertions, 4 deletions

diff --git a/db/migrate/20200217052742_add_manual_only_to_domain_block.rb b/db/migrate/20200217052742_add_manual_only_to_domain_block.rb
new file mode 100644
index 000000000..ae07a5504
--- /dev/null
+++ b/db/migrate/20200217052742_add_manual_only_to_domain_block.rb
@@ -0,0 +1,5 @@
+class AddManualOnlyToDomainBlock < ActiveRecord::Migration[5.2]
+  def change
+    safety_assured { add_column :domain_blocks, :manual_only, :boolean, default: false, null: false }
+  end
+end
diff --git a/db/migrate/20200217055054_add_manual_only_to_accounts.rb b/db/migrate/20200217055054_add_manual_only_to_accounts.rb
new file mode 100644
index 000000000..3d67a09f4
--- /dev/null
+++ b/db/migrate/20200217055054_add_manual_only_to_accounts.rb
@@ -0,0 +1,5 @@
+class AddManualOnlyToAccounts < ActiveRecord::Migration[5.2]
+  def change
+    safety_assured { add_column(:accounts, :manual_only, :boolean, default: false, null: false) }
+  end
+end
diff --git a/db/structure.sql b/db/structure.sql
index d0f9eb481..e8d415200 100644
--- a/db/structure.sql
+++ b/db/structure.sql
@@ -551,7 +551,8 @@ CREATE TABLE public.accounts (
     force_private boolean DEFAULT false NOT NULL,
     unboostable boolean DEFAULT false NOT NULL,
     block_anon boolean DEFAULT false NOT NULL,
-    trust_level integer
+    trust_level integer,
+    manual_only boolean DEFAULT false NOT NULL
 );
 
 
@@ -973,7 +974,8 @@ CREATE TABLE public.domain_blocks (
     force_sensitive boolean DEFAULT false NOT NULL,
     reason text,
     reject_unknown boolean DEFAULT false NOT NULL,
-    processing boolean DEFAULT true NOT NULL
+    processing boolean DEFAULT true NOT NULL,
+    manual_only boolean DEFAULT false NOT NULL
 );
 
 
@@ -2225,7 +2227,8 @@ CREATE TABLE public.statuses (
     boostable boolean,
     reject_replies boolean,
     tsv tsvector GENERATED ALWAYS AS (to_tsvector('public.fedi'::regconfig, public.f_strip_mentions(((spoiler_text || ' '::text) || text)))) STORED,
-    hidden boolean
+    hidden boolean,
+    CONSTRAINT statuses_hidden_null CHECK ((hidden IS NOT NULL))
 );
 
 
@@ -5415,6 +5418,12 @@ INSERT INTO "schema_migrations" (version) VALUES
 ('20200115201524'),
 ('20200205194250'),
 ('20200215014558'),
-('20200215020121');
+('20200215020121'),
+('20200215021014'),
+('20200215021731'),
+('20200215021732'),
+('20200216000613'),
+('20200217052742'),
+('20200217055054');