# -*- coding: utf-8 -*-
class AddRequestIdToReports < ActiveRecord::Migration
  def self.up
    add_column :reports, :request_id, :integer
    ActiveRecord::Base.connection.execute("UPDATE reports r SET r.request_id = r.tracker_id WHERE (department='mod' OR department='corp') AND  dhcp_login = 'new'")
  end

  def self.down
    remove_column :reports, :request_id
  end
end