mirror of
https://github.com/hanzoai/calendar.git
synced 2026-10-30 14:46:43 +00:00
1064e1181d
Co-authored-by: Alex van Andel <[email protected]> Co-authored-by: Keith Williams <[email protected]> Co-authored-by: Peer Richelsen <[email protected]> Co-authored-by: Joe Au-Yeung <[email protected]> Co-authored-by: Joe Au-Yeung <[email protected]> Co-authored-by: sean-brydon <[email protected]> Co-authored-by: Udit Takkar <[email protected]>
16 lines
451 B
SQL
16 lines
451 B
SQL
-- CreateTable
|
|
CREATE TABLE "DSyncData" (
|
|
"id" SERIAL NOT NULL,
|
|
"directoryId" TEXT NOT NULL,
|
|
"tenant" TEXT NOT NULL,
|
|
"orgId" INTEGER,
|
|
|
|
CONSTRAINT "DSyncData_pkey" PRIMARY KEY ("id")
|
|
);
|
|
|
|
-- CreateIndex
|
|
CREATE UNIQUE INDEX "DSyncData_orgId_key" ON "DSyncData"("orgId");
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "DSyncData" ADD CONSTRAINT "DSyncData_orgId_fkey" FOREIGN KEY ("orgId") REFERENCES "Team"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|