class AddPStaffIdToBusinesses < ActiveRecord::Migration[5.2]
  def change
    add_column :educode_sales_businesses, :p_stage, :integer, comment: '项目阶段'
    add_column :educode_sales_businesses, :p_difficulty, :integer, comment: '项目难度'
    add_column :educode_sales_businesses, :p_special, :integer, comment: '定制'
    add_column :educode_sales_businesses, :p_status, :integer, comment: '交付'
    add_column :educode_sales_businesses, :p_staff_id, :integer, comment: '指派人'
    add_column :educode_sales_businesses, :p_sale_staff_id, :integer, comment: '销售经理'
    add_column :educode_sales_businesses, :p_course_time, :date, comment: '课程交付时间'
    add_column :educode_sales_businesses, :p_platform_time, :date, comment: '平台交付时间'
    add_column :educode_sales_businesses, :p_deploy_time, :date, comment: '现场部署时间'
    add_column :educode_sales_businesses, :p_accept_time, :date, comment: '实际验收时间'
    add_column :educode_sales_businesses, :p_pre_money_time, :date, comment: '拟定回款时间'
    add_column :educode_sales_businesses, :p_actual_money_time, :date, comment: '实际回款时间'
    add_column :educode_sales_businesses, :p_money, :float, default: 0, comment: '回款'
    add_column :educode_sales_businesses, :p_content, :text, comment: '问题备注'
    add_column :educode_sales_businesses, :p_deleted_at, :datetime, comment: '删除时间'
    add_column :educode_sales_businesses, :p_deleter_id, :integer, comment: '删除人'
  end
end