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>
16 lines
606 B
SQL
16 lines
606 B
SQL
-- CreateEnum
|
|
CREATE TYPE "Domain" AS ENUM ('GOVERNANCE', 'HR', 'PHYSICAL', 'BCM', 'IT', 'PROCUREMENT', 'COMPLIANCE', 'DATA_PROTECTION', 'PROTOTYPE');
|
|
|
|
-- CreateEnum
|
|
CREATE TYPE "RaciKind" AS ENUM ('RESPONSIBLE', 'ACCOUNTABLE', 'CONSULTED', 'INFORMED');
|
|
|
|
-- CreateEnum
|
|
CREATE TYPE "InfoLabel" AS ENUM ('NONE', 'INFO_HIGH', 'INFO_VERY_HIGH', 'PROTOTYPE', 'PERSONAL_DATA');
|
|
|
|
-- AlterTable
|
|
ALTER TABLE "tasks" ADD COLUMN "domain" "Domain",
|
|
ADD COLUMN "order_idx" INTEGER NOT NULL DEFAULT 0;
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "tasks_tenant_id_domain_status_idx" ON "tasks"("tenant_id", "domain", "status");
|