23 lines
1.1 KiB
SQL
23 lines
1.1 KiB
SQL
/*
|
|
Warnings:
|
|
|
|
- Added the required column `code` to the `RequestData` table without a default value. This is not possible if the table is not empty.
|
|
- Added the required column `updatedAt` to the `RequestData` table without a default value. This is not possible if the table is not empty.
|
|
|
|
*/
|
|
-- DropForeignKey
|
|
ALTER TABLE "RequestWork" DROP CONSTRAINT "RequestWork_productServiceId_fkey";
|
|
|
|
-- DropForeignKey
|
|
ALTER TABLE "RequestWork" DROP CONSTRAINT "RequestWork_requestDataId_fkey";
|
|
|
|
-- AlterTable
|
|
ALTER TABLE "RequestData" ADD COLUMN "code" TEXT NOT NULL,
|
|
ADD COLUMN "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
ADD COLUMN "updatedAt" TIMESTAMP(3) NOT NULL;
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "RequestWork" ADD CONSTRAINT "RequestWork_requestDataId_fkey" FOREIGN KEY ("requestDataId") REFERENCES "RequestData"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "RequestWork" ADD CONSTRAINT "RequestWork_productServiceId_fkey" FOREIGN KEY ("productServiceId") REFERENCES "QuotationProductServiceList"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|