51 lines
1.5 KiB
SQL
51 lines
1.5 KiB
SQL
|
/*
|
||
|
|
Warnings:
|
||
|
|
|
||
|
|
- A unique constraint covering the columns `[seoId]` on the table `Doctor` will be added. If there are existing duplicate values, this will fail.
|
||
|
|
|
||
|
|
*/
|
||
|
|
-- AlterTable
|
||
|
|
ALTER TABLE "Doctor" ADD COLUMN "professionalSummary" TEXT,
|
||
|
|
ADD COLUMN "seoId" INTEGER;
|
||
|
|
|
||
|
|
-- CreateTable
|
||
|
|
CREATE TABLE "DoctorSpecialization" (
|
||
|
|
"id" SERIAL NOT NULL,
|
||
|
|
"name" TEXT NOT NULL,
|
||
|
|
"description" TEXT,
|
||
|
|
"doctorId" INTEGER NOT NULL,
|
||
|
|
"createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
||
|
|
"updatedAt" TIMESTAMP(3) NOT NULL,
|
||
|
|
|
||
|
|
CONSTRAINT "DoctorSpecialization_pkey" PRIMARY KEY ("id")
|
||
|
|
);
|
||
|
|
|
||
|
|
-- CreateTable
|
||
|
|
CREATE TABLE "Seo" (
|
||
|
|
"id" SERIAL NOT NULL,
|
||
|
|
"seoTitle" TEXT,
|
||
|
|
"metaDescription" TEXT,
|
||
|
|
"focusKeyphrase" TEXT,
|
||
|
|
"slug" TEXT,
|
||
|
|
"tags" TEXT[],
|
||
|
|
"ogTitle" TEXT,
|
||
|
|
"ogDescription" TEXT,
|
||
|
|
"ogImage" TEXT,
|
||
|
|
"createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
||
|
|
"updatedAt" TIMESTAMP(3) NOT NULL,
|
||
|
|
|
||
|
|
CONSTRAINT "Seo_pkey" PRIMARY KEY ("id")
|
||
|
|
);
|
||
|
|
|
||
|
|
-- CreateIndex
|
||
|
|
CREATE UNIQUE INDEX "Seo_slug_key" ON "Seo"("slug");
|
||
|
|
|
||
|
|
-- CreateIndex
|
||
|
|
CREATE UNIQUE INDEX "Doctor_seoId_key" ON "Doctor"("seoId");
|
||
|
|
|
||
|
|
-- AddForeignKey
|
||
|
|
ALTER TABLE "Doctor" ADD CONSTRAINT "Doctor_seoId_fkey" FOREIGN KEY ("seoId") REFERENCES "Seo"("id") ON DELETE SET NULL ON UPDATE CASCADE;
|
||
|
|
|
||
|
|
-- AddForeignKey
|
||
|
|
ALTER TABLE "DoctorSpecialization" ADD CONSTRAINT "DoctorSpecialization_doctorId_fkey" FOREIGN KEY ("doctorId") REFERENCES "Doctor"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|