diff options
Diffstat (limited to 'db/migrate/20200424050250_remove_orphaned_invited_members.rb')
-rw-r--r-- | db/migrate/20200424050250_remove_orphaned_invited_members.rb | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/db/migrate/20200424050250_remove_orphaned_invited_members.rb b/db/migrate/20200424050250_remove_orphaned_invited_members.rb new file mode 100644 index 00000000000..0fb2f7d9c39 --- /dev/null +++ b/db/migrate/20200424050250_remove_orphaned_invited_members.rb @@ -0,0 +1,13 @@ +# frozen_string_literal: true + +class RemoveOrphanedInvitedMembers < ActiveRecord::Migration[6.0] + DOWNTIME = false + + def up + # As of 2020-04-23, there are 19 entries on GitLab.com that match this criteria. + execute "DELETE FROM members WHERE user_id IS NULL AND invite_token IS NULL AND invite_accepted_at IS NOT NULL" + end + + def down + end +end |