20160603180330_remove_duplicated_notification_settings.rb 297 Bytes
Newer Older
1 2 3 4 5 6 7
class RemoveDuplicatedNotificationSettings < ActiveRecord::Migration
  def up
    execute <<-SQL
      DELETE FROM notification_settings WHERE id NOT IN ( SELECT min_id from (SELECT MIN(id) as min_id FROM notification_settings GROUP BY user_id, source_type, source_id) as dups )
    SQL
  end
end