30 lines
930 B
MySQL
30 lines
930 B
MySQL
|
-- AlterTable
|
||
|
|
ALTER TABLE "Employee" ALTER COLUMN "firstName" DROP NOT NULL,
|
||
|
|
ALTER COLUMN "lastName" DROP NOT NULL;
|
||
|
|
|
||
|
|
-- AlterTable
|
||
|
|
ALTER TABLE "Institution" ADD COLUMN "contactEmail" TEXT,
|
||
|
|
ADD COLUMN "contactName" TEXT,
|
||
|
|
ADD COLUMN "contactTel" TEXT;
|
||
|
|
|
||
|
|
-- AlterTable
|
||
|
|
ALTER TABLE "User" ADD COLUMN "agencyStatus" TEXT,
|
||
|
|
ADD COLUMN "remark" TEXT;
|
||
|
|
|
||
|
|
-- CreateTable
|
||
|
|
CREATE TABLE "InstitutionBank" (
|
||
|
|
"id" TEXT NOT NULL,
|
||
|
|
"bankName" TEXT NOT NULL,
|
||
|
|
"bankBranch" TEXT NOT NULL,
|
||
|
|
"accountName" TEXT NOT NULL,
|
||
|
|
"accountNumber" TEXT NOT NULL,
|
||
|
|
"accountType" TEXT NOT NULL,
|
||
|
|
"currentlyUse" BOOLEAN NOT NULL,
|
||
|
|
"institutionId" TEXT NOT NULL,
|
||
|
|
|
||
|
|
CONSTRAINT "InstitutionBank_pkey" PRIMARY KEY ("id")
|
||
|
|
);
|
||
|
|
|
||
|
|
-- AddForeignKey
|
||
|
|
ALTER TABLE "InstitutionBank" ADD CONSTRAINT "InstitutionBank_institutionId_fkey" FOREIGN KEY ("institutionId") REFERENCES "Institution"("id") ON DELETE RESTRICT ON UPDATE CASCADE;
|