From f4cf9d776af00cefd24be16c6aba6c37672dcc8d Mon Sep 17 00:00:00 2001 From: Douglas Barbosa Alexandre Date: Thu, 17 Nov 2016 13:50:14 -0200 Subject: Remove extra subscribable_type filter on migration --- db/migrate/20161031174110_migrate_subscriptions_project_id.rb | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/db/migrate/20161031174110_migrate_subscriptions_project_id.rb b/db/migrate/20161031174110_migrate_subscriptions_project_id.rb index 9e1bdb7c567..549145a0a65 100644 --- a/db/migrate/20161031174110_migrate_subscriptions_project_id.rb +++ b/db/migrate/20161031174110_migrate_subscriptions_project_id.rb @@ -10,7 +10,7 @@ class MigrateSubscriptionsProjectId < ActiveRecord::Migration SET project_id = ( SELECT issues.project_id FROM issues - WHERE issues.id = subscriptions.subscribable_id AND subscriptions.subscribable_type = 'Issue' + WHERE issues.id = subscriptions.subscribable_id ) WHERE subscriptions.subscribable_type = 'Issue'; EOF @@ -20,7 +20,7 @@ class MigrateSubscriptionsProjectId < ActiveRecord::Migration SET project_id = ( SELECT merge_requests.target_project_id FROM merge_requests - WHERE merge_requests.id = subscriptions.subscribable_id AND subscriptions.subscribable_type = 'MergeRequest' + WHERE merge_requests.id = subscriptions.subscribable_id ) WHERE subscriptions.subscribable_type = 'MergeRequest'; EOF @@ -30,7 +30,7 @@ class MigrateSubscriptionsProjectId < ActiveRecord::Migration SET project_id = ( SELECT projects.id FROM labels INNER JOIN projects ON projects.id = labels.project_id - WHERE labels.id = subscriptions.subscribable_id AND subscriptions.subscribable_type = 'Label' + WHERE labels.id = subscriptions.subscribable_id ) WHERE subscriptions.subscribable_type = 'Label'; EOF -- cgit v1.2.1