15 lines
561 B
PL/PgSQL
15 lines
561 B
PL/PgSQL
/*
|
|
Warnings:
|
|
|
|
- The values [WIN_CHALLENGE] on the enum `MoneyUpdateType` will be removed. If these variants are still used in the database, this will fail.
|
|
|
|
*/
|
|
-- AlterEnum
|
|
BEGIN;
|
|
CREATE TYPE "MoneyUpdateType_new" AS ENUM ('START', 'NEW_RUN', 'CHALLENGE', 'BUY_TRAIN');
|
|
ALTER TABLE "MoneyUpdate" ALTER COLUMN "reason" TYPE "MoneyUpdateType_new" USING ("reason"::text::"MoneyUpdateType_new");
|
|
ALTER TYPE "MoneyUpdateType" RENAME TO "MoneyUpdateType_old";
|
|
ALTER TYPE "MoneyUpdateType_new" RENAME TO "MoneyUpdateType";
|
|
DROP TYPE "MoneyUpdateType_old";
|
|
COMMIT;
|