X-Git-Url: https://git.openstreetmap.org/rails.git/blobdiff_plain/4d164df5b8a0d6571f738f2d10b49da1aeaafdcd..84c601460fe2be392689378ba6c3aa9de714c31b:/db/migrate/20210511104518_add_time_to_friendships.rb

diff --git a/db/migrate/20210511104518_add_time_to_friendships.rb b/db/migrate/20210511104518_add_time_to_friendships.rb
new file mode 100644
index 000000000..4f426a63f
--- /dev/null
+++ b/db/migrate/20210511104518_add_time_to_friendships.rb
@@ -0,0 +1,9 @@
+class AddTimeToFriendships < ActiveRecord::Migration[6.0]
+  disable_ddl_transaction!
+
+  def change
+    add_column :friends, :created_at, :datetime
+    add_index :friends, [:user_id, :created_at], :algorithm => :concurrently
+    remove_index :friends, :column => :user_id, :name => "friends_user_id_idx"
+  end
+end