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/migrate/20200218032023_add_defanged_to_users.rb       |  5 +++++
 db/migrate/20200218033651_add_halfmod_to_users.rb        |  5 +++++
 db/migrate/20200218070510_add_last_fanged_at_to_users.rb |  5 +++++
 db/structure.sql                                         | 10 ++++++++--
 4 files changed, 23 insertions(+), 2 deletions(-)
 create mode 100644 db/migrate/20200218032023_add_defanged_to_users.rb
 create mode 100644 db/migrate/20200218033651_add_halfmod_to_users.rb
 create mode 100644 db/migrate/20200218070510_add_last_fanged_at_to_users.rb

(limited to 'db')

diff --git a/db/migrate/20200218032023_add_defanged_to_users.rb b/db/migrate/20200218032023_add_defanged_to_users.rb
new file mode 100644
index 000000000..b5e6d02f6
--- /dev/null
+++ b/db/migrate/20200218032023_add_defanged_to_users.rb
@@ -0,0 +1,5 @@
+class AddDefangedToUsers < ActiveRecord::Migration[5.2]
+  def change
+    safety_assured { add_column :users, :defanged, :boolean, null: false, default: true }
+  end
+end
diff --git a/db/migrate/20200218033651_add_halfmod_to_users.rb b/db/migrate/20200218033651_add_halfmod_to_users.rb
new file mode 100644
index 000000000..7693e8135
--- /dev/null
+++ b/db/migrate/20200218033651_add_halfmod_to_users.rb
@@ -0,0 +1,5 @@
+class AddHalfmodToUsers < ActiveRecord::Migration[5.2]
+  def change
+    safety_assured { add_column :users, :halfmod, :boolean, null: false, default: false }
+  end
+end
diff --git a/db/migrate/20200218070510_add_last_fanged_at_to_users.rb b/db/migrate/20200218070510_add_last_fanged_at_to_users.rb
new file mode 100644
index 000000000..727a2cf55
--- /dev/null
+++ b/db/migrate/20200218070510_add_last_fanged_at_to_users.rb
@@ -0,0 +1,5 @@
+class AddLastFangedAtToUsers < ActiveRecord::Migration[5.2]
+  def change
+    add_column :users, :last_fanged_at, :datetime
+  end
+end
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