class AddFieldsToStateReportingConfigs < ActiveRecord::Migration[6.0]
  def change
    change_table :state_reporting_configs, bulk: true do |t|
      t.references :schedule_descriptor, type: :integer, after: :school_year_id,
        foreign_key: { to_table: :EdFi_Descriptors, primary_key: :DescriptorID }
      t.references :calendar_descriptor, type: :integer, after: :school_year_id,
        foreign_key: { to_table: :EdFi_Descriptors, primary_key: :DescriptorID }

      t.boolean :performance, default: false, null: false, after: :enabled
      t.time :start_time, after: :performance
      t.time :end_time, after: :start_time
      t.integer :minutes, after: :end_time
      t.integer :days, after: :minutes
      t.integer :grading_period, null: false, default: 0, after: :days
    end
  end
end