20130321124312_ticket_escalation_update_time.rb 513 B

12345678910111213
  1. class TicketEscalationUpdateTime < ActiveRecord::Migration
  2. def up
  3. add_column :tickets, :update_time_escal_date, :timestamp, :null => true
  4. add_column :tickets, :updtate_time_sla_time, :timestamp, :null => true
  5. add_column :tickets, :update_time_in_min, :integer, :null => true
  6. add_column :tickets, :update_time_diff_in_min, :integer, :null => true
  7. add_index :tickets, [:update_time_in_min]
  8. add_index :tickets, [:update_time_diff_in_min]
  9. end
  10. def down
  11. end
  12. end