/*
  Warnings:

  - The values [cancelled] on the enum `CansProgress` will be removed. If these variants are still used in the database, this will fail.

*/
-- AlterEnum
BEGIN;
CREATE TYPE "CansProgress_new" AS ENUM ('waiting', 'accepted', 'arrived', 'collected');
ALTER TABLE "Cans" ALTER COLUMN "cans_progress" DROP DEFAULT;
ALTER TABLE "Cans" ALTER COLUMN "cans_progress" TYPE "CansProgress_new" USING ("cans_progress"::text::"CansProgress_new");
ALTER TYPE "CansProgress" RENAME TO "CansProgress_old";
ALTER TYPE "CansProgress_new" RENAME TO "CansProgress";
DROP TYPE "CansProgress_old";
ALTER TABLE "Cans" ALTER COLUMN "cans_progress" SET DEFAULT 'waiting';
COMMIT;