blob: 54cea964ff2c789786bab34bd2468397fab81c5a (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
class RemoveTodosForDeletedMergeRequests < ActiveRecord::Migration
def up
execute <<-SQL
DELETE FROM todos
WHERE todos.target_type = 'MergeRequest'
AND NOT EXISTS (
SELECT *
FROM merge_requests
WHERE merge_requests.id = todos.target_id
AND merge_requests.deleted_at IS NULL
)
SQL
end
def down
end
end
|