| @@ -1,6 +1,7 | |||
|
|
1 | 1 | class AddUniqueIndexOnMembers < ActiveRecord::Migration |
|
|
2 | 2 | def self.up |
|
|
3 |
# |
|
|
|
3 | # Clean and reassign MemberRole rows if needed | |
|
|
4 | MemberRole.delete_all("member_id NOT IN (SELECT id FROM #{Member.table_name})") | |
|
|
4 | 5 | MemberRole.update_all("member_id =" + |
|
|
5 | 6 | " (SELECT min(m2.id) FROM #{Member.table_name} m1, #{Member.table_name} m2" + |
|
|
6 | 7 | " WHERE m1.user_id = m2.user_id AND m1.project_id = m2.project_id" + |
General Comments 0
You need to be logged in to leave comments.
Login now