| @@ -11,7 +11,7 class AddUniqueIndexOnMembers < ActiveRecord::Migration | |||||
| 11 | " WHERE m.id > (SELECT min(m1.id) FROM #{Member.table_name} m1 WHERE m1.user_id = m.user_id AND m1.project_id = m.project_id)").each do |i| |
|
11 | " WHERE m.id > (SELECT min(m1.id) FROM #{Member.table_name} m1 WHERE m1.user_id = m.user_id AND m1.project_id = m.project_id)").each do |i| | |
| 12 | Member.delete_all(["id = ?", i]) |
|
12 | Member.delete_all(["id = ?", i]) | |
| 13 | end |
|
13 | end | |
| 14 |
|
14 | |||
| 15 | # Then add a unique index |
|
15 | # Then add a unique index | |
| 16 | add_index :members, [:user_id, :project_id], :unique => true |
|
16 | add_index :members, [:user_id, :project_id], :unique => true | |
| 17 | end |
|
17 | end | |
General Comments 0
You need to be logged in to leave comments.
Login now