/*
  Warnings:

  - You are about to drop the column `approved_by_id` on the `blog_comments` table. All the data in the column will be lost.

*/
-- DropForeignKey
ALTER TABLE `blog_comments` DROP FOREIGN KEY `blog_comments_approved_by_id_fkey`;

-- DropIndex
DROP INDEX `blog_comments_approved_by_id_fkey` ON `blog_comments`;

-- AlterTable
ALTER TABLE `blog_comments` DROP COLUMN `approved_by_id`,
    ADD COLUMN `status` ENUM('PENDING', 'APPROVED', 'REJECTED') NOT NULL DEFAULT 'PENDING';
