| 12345678910111213141516171819 |
- -- Story 2.11: Relance manuelle Transformateur (FR11, FR12, FR13)
- -- CreateTable
- CREATE TABLE "ManualRelanceLog" (
- "id" TEXT NOT NULL,
- "workspaceId" TEXT NOT NULL,
- "subject" TEXT NOT NULL,
- "recipientCount" INTEGER NOT NULL,
- "sentCount" INTEGER NOT NULL,
- "failedCount" INTEGER NOT NULL DEFAULT 0,
- "sentAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
- CONSTRAINT "ManualRelanceLog_pkey" PRIMARY KEY ("id")
- );
- -- CreateIndex
- CREATE INDEX "ManualRelanceLog_workspaceId_idx" ON "ManualRelanceLog"("workspaceId");
- -- AddForeignKey
- ALTER TABLE "ManualRelanceLog" ADD CONSTRAINT "ManualRelanceLog_workspaceId_fkey" FOREIGN KEY ("workspaceId") REFERENCES "Workspace"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|