From 0f3b01eaab82325baaf1c7a4c75a322d3c21a67f Mon Sep 17 00:00:00 2001
From: multiple creatures <dev@multiple-creature.party>
Date: Tue, 18 Feb 2020 02:02:54 -0600
Subject: 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

---
 db/structure.sql | 10 ++++++++--
 1 file changed, 8 insertions(+), 2 deletions(-)

(limited to 'db/structure.sql')

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');
 
 
-- 
cgit 

