diff options
Diffstat (limited to 'db/migrate/20170523073948_remove_assignee_id_from_issue.rb')
-rw-r--r-- | db/migrate/20170523073948_remove_assignee_id_from_issue.rb | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/db/migrate/20170523073948_remove_assignee_id_from_issue.rb b/db/migrate/20170523073948_remove_assignee_id_from_issue.rb index e310a6df9bd..6fe2bb9c770 100644 --- a/db/migrate/20170523073948_remove_assignee_id_from_issue.rb +++ b/db/migrate/20170523073948_remove_assignee_id_from_issue.rb @@ -32,5 +32,7 @@ class RemoveAssigneeIdFromIssue < ActiveRecord::Migration def down add_column :issues, :assignee_id, :integer add_concurrent_index :issues, :assignee_id + + execute('UPDATE issues SET assignee_id = (SELECT user_id FROM issue_assignees WHERE issue_assignees.issue_id = issues.id LIMIT 1)') end end |