msolarczekandClaude Opus 5
c8e6f30a27
Unveränderter Stand von certvia/dev (a48c5fb) plus Craftvia-Spezifikation und Brandbook unter docs/craftvia/. ISMS-Module werden im Folgecommit entfernt. Co-Authored-By: Claude Opus 5 <noreply@anthropic.com>
19 lines
789 B
SQL
19 lines
789 B
SQL
-- AlterTable
|
|
ALTER TABLE "processes" ADD COLUMN "bia_status" TEXT NOT NULL DEFAULT 'offen',
|
|
ADD COLUMN "catalog_code" TEXT,
|
|
ADD COLUMN "data_protection_relevant" BOOLEAN NOT NULL DEFAULT false,
|
|
ADD COLUMN "deputy_owner_id" TEXT,
|
|
ADD COLUMN "in_scope" BOOLEAN NOT NULL DEFAULT true,
|
|
ADD COLUMN "interfaces" TEXT,
|
|
ADD COLUMN "legal_basis" TEXT,
|
|
ADD COLUMN "parent_id" TEXT,
|
|
ADD COLUMN "prototype_relevant" BOOLEAN NOT NULL DEFAULT false,
|
|
ADD COLUMN "purpose" TEXT;
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "processes_tenant_id_parent_id_idx" ON "processes"("tenant_id", "parent_id");
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "processes" ADD CONSTRAINT "processes_parent_id_fkey" FOREIGN KEY ("parent_id") REFERENCES "processes"("id") ON DELETE SET NULL ON UPDATE CASCADE;
|
|
|