-- CreateTable CREATE TABLE "audit_logs" ( "id" TEXT NOT NULL, "tenantId" TEXT NOT NULL, "userId" TEXT NOT NULL, "action" TEXT NOT NULL, "entity" TEXT NOT NULL, "entityId" TEXT NOT NULL, "details" JSONB NOT NULL DEFAULT '{}', "ipAddress" TEXT, "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT "audit_logs_pkey" PRIMARY KEY ("id") ); -- CreateIndex CREATE INDEX "audit_logs_tenantId_idx" ON "audit_logs"("tenantId"); -- CreateIndex CREATE INDEX "audit_logs_tenantId_entity_idx" ON "audit_logs"("tenantId", "entity"); -- CreateIndex CREATE INDEX "audit_logs_userId_idx" ON "audit_logs"("userId");