/*
  Warnings:

  - The values [SUPER_ADMIN,PILOT,CABIN_CREW,MAINTENANCE_ENGINEER,QUALITY_INSPECTOR,OPERATIONS_STAFF] on the enum `Role` will be removed. If these variants are still used in the database, this will fail.

*/
-- AlterEnum
BEGIN;
CREATE TYPE "Role_new" AS ENUM ('USER', 'ADMIN', 'TECHNICAL_DIRECTOR', 'CHIEF_INSPECTOR', 'CHIEF_MAINTENANCE', 'MAINTENANCE_OPERATOR');
ALTER TABLE "User" ALTER COLUMN "role" DROP DEFAULT;
ALTER TABLE "User" ALTER COLUMN "role" TYPE "Role_new" USING ("role"::text::"Role_new");
ALTER TYPE "Role" RENAME TO "Role_old";
ALTER TYPE "Role_new" RENAME TO "Role";
DROP TYPE "Role_old";
ALTER TABLE "User" ALTER COLUMN "role" SET DEFAULT 'USER';
COMMIT;

-- AlterTable
ALTER TABLE "PurchaseRequest" ALTER COLUMN "status" DROP DEFAULT;
