/*
  Warnings:

  - You are about to drop the column `artist` on the `SongRequest` table. All the data in the column will be lost.
  - You are about to drop the column `song` on the `SongRequest` table. All the data in the column will be lost.
  - You are about to drop the column `temp_artist` on the `SongRequest` table. All the data in the column will be lost.
  - You are about to drop the column `temp_song` on the `SongRequest` table. All the data in the column will be lost.
  - Made the column `songId` on table `SongRequest` required. This step will fail if there are existing NULL values in that column.

*/
-- DropForeignKey
ALTER TABLE `SongRequest` DROP FOREIGN KEY `SongRequest_songId_fkey`;

-- DropIndex
DROP INDEX `SongRequest_songId_fkey` ON `SongRequest`;

-- AlterTable
ALTER TABLE `SongRequest` DROP COLUMN `artist`,
    DROP COLUMN `song`,
    DROP COLUMN `temp_artist`,
    DROP COLUMN `temp_song`,
    ALTER COLUMN `status` DROP DEFAULT,
    MODIFY `songId` INTEGER NOT NULL;

-- AddForeignKey
ALTER TABLE `SongRequest` ADD CONSTRAINT `SongRequest_songId_fkey` FOREIGN KEY (`songId`) REFERENCES `Song`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;
