9 lines
438 B
SQL
9 lines
438 B
SQL
-- CreateEnum
|
|
CREATE TYPE "RequestWorkStatus" AS ENUM ('Pending', 'InProgress', 'Completed');
|
|
|
|
-- AlterTable
|
|
ALTER TABLE "RequestWork" ADD COLUMN "processByUserId" TEXT,
|
|
ADD COLUMN "workStatus" "RequestWorkStatus" NOT NULL DEFAULT 'Pending';
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "RequestWork" ADD CONSTRAINT "RequestWork_processByUserId_fkey" FOREIGN KEY ("processByUserId") REFERENCES "User"("id") ON DELETE SET NULL ON UPDATE CASCADE;
|