jws-backend/prisma/migrations/20241015100831_update_quotation_structure/migration.sql
2024-10-15 17:09:05 +07:00

11 lines
450 B
SQL

/*
Warnings:
- Added the required column `registeredBranchId` to the `Quotation` table without a default value. This is not possible if the table is not empty.
*/
-- AlterTable
ALTER TABLE "Quotation" ADD COLUMN "registeredBranchId" TEXT NOT NULL;
-- AddForeignKey
ALTER TABLE "Quotation" ADD CONSTRAINT "Quotation_registeredBranchId_fkey" FOREIGN KEY ("registeredBranchId") REFERENCES "Branch"("id") ON DELETE RESTRICT ON UPDATE CASCADE;