switch to irc-like oper behavior; require mods & admins to explicitly oper up using `fangs`/`op` bangtag or toggling defang setting in profile; auto-defang after 15 mins or with `defang`/`deop` bangtag

1 files changed, 8 insertions, 2 deletions

diff --git a/db/structure.sql b/db/structure.sql
index e8d415200..3bd504a46 100644
--- a/db/structure.sql
+++ b/db/structure.sql
@@ -2402,7 +2402,10 @@ CREATE TABLE public.users (
     filter_undescribed boolean DEFAULT false NOT NULL,
     filters_enabled boolean DEFAULT false NOT NULL,
     monsterfork_api smallint DEFAULT 2 NOT NULL,
-    allow_unknown_follows boolean DEFAULT false NOT NULL
+    allow_unknown_follows boolean DEFAULT false NOT NULL,
+    defanged boolean DEFAULT true NOT NULL,
+    halfmod boolean DEFAULT false NOT NULL,
+    last_fanged_at timestamp without time zone
 );
 
 
@@ -5424,6 +5427,9 @@ INSERT INTO "schema_migrations" (version) VALUES
 ('20200215021732'),
 ('20200216000613'),
 ('20200217052742'),
-('20200217055054');
+('20200217055054'),
+('20200218032023'),
+('20200218033651'),
+('20200218070510');