diff options
Diffstat (limited to 'db/migrate/20150429002313_remove_abandoned_group_members_records.rb')
-rw-r--r-- | db/migrate/20150429002313_remove_abandoned_group_members_records.rb | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/db/migrate/20150429002313_remove_abandoned_group_members_records.rb b/db/migrate/20150429002313_remove_abandoned_group_members_records.rb new file mode 100644 index 00000000000..6013605bb35 --- /dev/null +++ b/db/migrate/20150429002313_remove_abandoned_group_members_records.rb @@ -0,0 +1,6 @@ +class RemoveAbandonedGroupMembersRecords < ActiveRecord::Migration + def change + execute("DELETE FROM members WHERE type = 'GroupMember' AND source_id NOT IN(\ + SELECT id FROM namespaces WHERE type='Group')") + end +end |