summaryrefslogtreecommitdiff
path: root/db/migrate/20140914145549_migrate_to_new_members_model.rb
blob: b4c98f016d0e29fa61d91f501e12eddeb419c809 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
# rubocop:disable all
class MigrateToNewMembersModel < ActiveRecord::Migration
  def up
    execute "INSERT INTO members ( user_id, source_id, source_type, access_level, notification_level, type ) SELECT user_id, group_id, 'Namespace', group_access, notification_level, 'GroupMember' FROM users_groups"
    execute "INSERT INTO members ( user_id, source_id, source_type, access_level, notification_level, type ) SELECT user_id, project_id, 'Project', project_access, notification_level, 'ProjectMember' FROM users_projects"
  end

  def down
    Member.delete_all
  end
end