about summary refs log tree commit diff
path: root/db
diff options
context:
space:
mode:
authormultiple creatures <dev@multiple-creature.party>2019-07-15 13:40:54 -0500
committermultiple creatures <dev@multiple-creature.party>2019-07-15 14:12:24 -0500
commit5e3ea221a80d7498d4939386f072d933e6b23dda (patch)
treee64017e83bbe4dc7689c3663bca19c58359890ed /db
parentcf3ec71aa564c7fe47ec79f8dd5f14e3bce0b85c (diff)
add `supports_chat` property, rename `adults_only` to `adult_content`, federate the kobolds~
Diffstat (limited to 'db')
-rw-r--r--db/migrate/20190531084425_add_supports_chat_to_accounts.rb5
-rw-r--r--db/migrate/20190714172440_add_kobolds_to_accounts.rb6
-rw-r--r--db/migrate/20190714172721_adults_only_to_adult_content.rb8
-rw-r--r--db/schema.rb5
4 files changed, 23 insertions, 1 deletions
diff --git a/db/migrate/20190531084425_add_supports_chat_to_accounts.rb b/db/migrate/20190531084425_add_supports_chat_to_accounts.rb
new file mode 100644
index 000000000..4312f78d3
--- /dev/null
+++ b/db/migrate/20190531084425_add_supports_chat_to_accounts.rb
@@ -0,0 +1,5 @@
+class AddSupportsChatToAccounts < ActiveRecord::Migration[5.2]
+  def change
+    safety_assured { add_column :accounts, :supports_chat, :boolean, null: false, default: false }
+  end
+end
diff --git a/db/migrate/20190714172440_add_kobolds_to_accounts.rb b/db/migrate/20190714172440_add_kobolds_to_accounts.rb
new file mode 100644
index 000000000..608dd2bfa
--- /dev/null
+++ b/db/migrate/20190714172440_add_kobolds_to_accounts.rb
@@ -0,0 +1,6 @@
+class AddKoboldsToAccounts < ActiveRecord::Migration[5.2]
+  def change
+    safety_assured { add_column :accounts, :gently, :boolean, null: false, default: false }
+    safety_assured { add_column :accounts, :kobold, :boolean, null: false, default: false }
+  end
+end
diff --git a/db/migrate/20190714172721_adults_only_to_adult_content.rb b/db/migrate/20190714172721_adults_only_to_adult_content.rb
new file mode 100644
index 000000000..c42e6fb35
--- /dev/null
+++ b/db/migrate/20190714172721_adults_only_to_adult_content.rb
@@ -0,0 +1,8 @@
+class AdultsOnlyToAdultContent < ActiveRecord::Migration[5.2]
+  def up
+    safety_assured { rename_column :accounts, :adults_only, :adult_content }
+  end
+  def down
+    safety_assured { rename_column :accounts, :adult_content, :adults_only }
+  end
+end
diff --git a/db/schema.rb b/db/schema.rb
index 0cfefbf7f..5c4360422 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -148,9 +148,12 @@ ActiveRecord::Schema.define(version: 2019_05_21_003909) do
     t.boolean "unlisted", default: false, null: false
     t.boolean "force_unlisted", default: false, null: false
     t.boolean "force_sensitive", default: false, null: false
-    t.boolean "adults_only", default: false, null: false
+    t.boolean "adult_content", default: false, null: false
     t.datetime "silenced_at"
     t.datetime "suspended_at"
+    t.boolean "supports_chat", default: false, null: false
+    t.boolean "gently", default: false, null: false
+    t.boolean "kobold", default: false, null: false
     t.index "(((setweight(to_tsvector('simple'::regconfig, (display_name)::text), 'A'::\"char\") || setweight(to_tsvector('simple'::regconfig, (username)::text), 'B'::\"char\")) || setweight(to_tsvector('simple'::regconfig, (COALESCE(domain, ''::character varying))::text), 'C'::\"char\")))", name: "search_index", using: :gin
     t.index "lower((username)::text), lower((domain)::text)", name: "index_accounts_on_username_and_domain_lower", unique: true
     t.index ["moved_to_account_id"], name: "index_accounts_on_moved_to_account_id"