/*
  Warnings:

  - You are about to drop the column `foul_player` on the `Foals` table. All the data in the column will be lost.
  - You are about to drop the column `foul_type` on the `Foals` table. All the data in the column will be lost.
  - Added the required column `foul_description` to the `Foals` table without a default value. This is not possible if the table is not empty.
  - Added the required column `foul_player_id` to the `Foals` table without a default value. This is not possible if the table is not empty.
  - Added the required column `foul_team_id` to the `Foals` table without a default value. This is not possible if the table is not empty.

*/
-- AlterTable
ALTER TABLE "Foals" DROP COLUMN "foul_player",
DROP COLUMN "foul_type",
ADD COLUMN     "foul_description" TEXT NOT NULL,
ADD COLUMN     "foul_player_id" INTEGER NOT NULL,
ADD COLUMN     "foul_team_id" INTEGER NOT NULL;

-- AddForeignKey
ALTER TABLE "Foals" ADD CONSTRAINT "Foals_foul_team_id_fkey" FOREIGN KEY ("foul_team_id") REFERENCES "teams"("team_id") ON DELETE RESTRICT ON UPDATE CASCADE;

-- AddForeignKey
ALTER TABLE "Foals" ADD CONSTRAINT "Foals_foul_player_id_fkey" FOREIGN KEY ("foul_player_id") REFERENCES "users"("user_id") ON DELETE RESTRICT ON UPDATE CASCADE;
