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

    remove_foreign_key :EdFi_StudentIndicators, column: :StudentID

    remove_foreign_key :EdFi_StudentIndicatorValues, column: :StudentIndicatorID

    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_StudentIndicatorValues, :EdFi_StudentIndicators,
      column: :StudentIndicatorID, primary_key: :StudentIndicatorID,
      on_delete: :cascade
  end
end