mirror of
https://github.com/hanzoai/calendar.git
synced 2026-10-30 14:46:43 +00:00
MorganandGitHub
524c0d81a7
* Revert "Revert "chore: rename DWD to DelegationCredential (#19703)" (#19734)"
This reverts commit 340b5ab061.
* chore: fix schema and types for now
* fix: domainWideDelegationCredentialId error type
52 lines
2.3 KiB
SQL
52 lines
2.3 KiB
SQL
-- AlterTable
|
|
ALTER TABLE "BookingReference" ADD COLUMN "delegationCredentialId" TEXT;
|
|
|
|
-- AlterTable
|
|
ALTER TABLE "DestinationCalendar" ADD COLUMN "delegationCredentialId" TEXT;
|
|
|
|
-- AlterTable
|
|
ALTER TABLE "SelectedCalendar" ADD COLUMN "delegationCredentialId" TEXT;
|
|
|
|
-- CreateTable
|
|
CREATE TABLE "DelegationCredential" (
|
|
"id" TEXT NOT NULL,
|
|
"workspacePlatformId" INTEGER NOT NULL,
|
|
"serviceAccountKey" JSONB NOT NULL,
|
|
"enabled" BOOLEAN NOT NULL DEFAULT false,
|
|
"organizationId" INTEGER NOT NULL,
|
|
"domain" TEXT NOT NULL,
|
|
"createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
"updatedAt" TIMESTAMP(3) NOT NULL,
|
|
|
|
CONSTRAINT "DelegationCredential_pkey" PRIMARY KEY ("id")
|
|
);
|
|
|
|
-- CreateIndex
|
|
CREATE UNIQUE INDEX "DelegationCredential_organizationId_domain_key" ON "DelegationCredential"("organizationId", "domain");
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "DestinationCalendar" ADD CONSTRAINT "DestinationCalendar_delegationCredentialId_fkey" FOREIGN KEY ("delegationCredentialId") REFERENCES "DelegationCredential"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "BookingReference" ADD CONSTRAINT "BookingReference_delegationCredentialId_fkey" FOREIGN KEY ("delegationCredentialId") REFERENCES "DelegationCredential"("id") ON DELETE SET NULL ON UPDATE CASCADE;
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "SelectedCalendar" ADD CONSTRAINT "SelectedCalendar_delegationCredentialId_fkey" FOREIGN KEY ("delegationCredentialId") REFERENCES "DelegationCredential"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "DelegationCredential" ADD CONSTRAINT "DelegationCredential_workspacePlatformId_fkey" FOREIGN KEY ("workspacePlatformId") REFERENCES "WorkspacePlatform"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "DelegationCredential" ADD CONSTRAINT "DelegationCredential_organizationId_fkey" FOREIGN KEY ("organizationId") REFERENCES "Team"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
-- Insert New Delegation Credential Flag
|
|
INSERT INTO
|
|
"Feature" (slug, enabled, description, "type")
|
|
VALUES
|
|
(
|
|
'delegation-credential',
|
|
false,
|
|
'Enable Delegation Credentials - Allows system to act on behalf of Workspace users on third parties such as google,oulook, etc ...',
|
|
'OPERATIONAL'
|
|
) ON CONFLICT (slug) DO NOTHING;
|