class AddCascadeDeleteEdfiStudentIndicators < ActiveRecord::Migration[6.0]
  def change
    remove_foreign_key :EdFi_StudentIndicators, column: :SchoolID

    remove_foreign_key :EdFi_StudentIndicators, column: :StudentID

    remove_foreign_key :EdFi_StudentIndicators, column: :SchoolYearStudentID

    add_foreign_key :EdFi_StudentIndicators, :Schools, column: :SchoolID,
      primary_key: :SchoolID, on_delete: :cascade

    add_foreign_key :EdFi_StudentIndicators, :Students, column: :StudentID,
      primary_key: :StudentID, on_delete: :cascade

    add_foreign_key :EdFi_StudentIndicators, :SchoolYearStudents,
      column: :SchoolYearStudentID, primary_key: :SchoolYearStudentID,
      on_delete: :cascade
  end
end