summaryrefslogtreecommitdiff
path: root/db/migrate/20140914145549_migrate_to_new_members_model.rb
blob: 22d8b3d651b39567faf04b73a55c8caa0b494666 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
# rubocop:disable all
class MigrateToNewMembersModel < ActiveRecord::Migration[4.2]
  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