| @@ -1,6 +1,7 | |||||
| 1 | class AddUniqueIndexOnMembers < ActiveRecord::Migration |
|
1 | class AddUniqueIndexOnMembers < ActiveRecord::Migration | |
| 2 | def self.up |
|
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 | MemberRole.update_all("member_id =" + |
|
5 | MemberRole.update_all("member_id =" + | |
| 5 | " (SELECT min(m2.id) FROM #{Member.table_name} m1, #{Member.table_name} m2" + |
|
6 | " (SELECT min(m2.id) FROM #{Member.table_name} m1, #{Member.table_name} m2" + | |
| 6 | " WHERE m1.user_id = m2.user_id AND m1.project_id = m2.project_id" + |
|
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