about summary refs log tree commit diff
path: root/db
diff options
context:
space:
mode:
Diffstat (limited to 'db')
-rw-r--r--db/migrate/20170301222600_create_mutes.rb1
-rw-r--r--db/migrate/20170508230434_create_conversation_mutes.rb10
-rw-r--r--db/schema.rb8
3 files changed, 17 insertions, 2 deletions
diff --git a/db/migrate/20170301222600_create_mutes.rb b/db/migrate/20170301222600_create_mutes.rb
index 8f1bb22f5..4c27eca1e 100644
--- a/db/migrate/20170301222600_create_mutes.rb
+++ b/db/migrate/20170301222600_create_mutes.rb
@@ -7,6 +7,5 @@ class CreateMutes < ActiveRecord::Migration[5.0]
     end
 
     add_index :mutes, [:account_id, :target_account_id], unique: true
-
   end
 end
diff --git a/db/migrate/20170508230434_create_conversation_mutes.rb b/db/migrate/20170508230434_create_conversation_mutes.rb
new file mode 100644
index 000000000..81edf2733
--- /dev/null
+++ b/db/migrate/20170508230434_create_conversation_mutes.rb
@@ -0,0 +1,10 @@
+class CreateConversationMutes < ActiveRecord::Migration[5.0]
+  def change
+    create_table :conversation_mutes do |t|
+      t.integer :account_id, null: false
+      t.bigint :conversation_id, null: false
+    end
+
+    add_index :conversation_mutes, [:account_id, :conversation_id], unique: true
+  end
+end
diff --git a/db/schema.rb b/db/schema.rb
index 7f7fc5978..76624f07a 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -10,7 +10,7 @@
 #
 # It's strongly recommended that you check this file into your version control system.
 
-ActiveRecord::Schema.define(version: 20170507141759) do
+ActiveRecord::Schema.define(version: 20170508230434) do
 
   # These are extensions that must be enabled in order to support this database
   enable_extension "plpgsql"
@@ -62,6 +62,12 @@ ActiveRecord::Schema.define(version: 20170507141759) do
     t.index ["account_id", "target_account_id"], name: "index_blocks_on_account_id_and_target_account_id", unique: true, using: :btree
   end
 
+  create_table "conversation_mutes", force: :cascade do |t|
+    t.integer "account_id",      null: false
+    t.bigint  "conversation_id", null: false
+    t.index ["account_id", "conversation_id"], name: "index_conversation_mutes_on_account_id_and_conversation_id", unique: true, using: :btree
+  end
+
   create_table "conversations", id: :bigserial, force: :cascade do |t|
     t.string   "uri"
     t.datetime "created_at", null: false