Canvas: Persistent log storage
Change-Id: I3eac705329e6d68d8e4b9a371c6e9b9807f357ec
diff --git a/apps/canvas/back/prisma/migrations/20250702123930_logs/migration.sql b/apps/canvas/back/prisma/migrations/20250702123930_logs/migration.sql
new file mode 100644
index 0000000..cbfe7f9
--- /dev/null
+++ b/apps/canvas/back/prisma/migrations/20250702123930_logs/migration.sql
@@ -0,0 +1,12 @@
+-- CreateTable
+CREATE TABLE "Log" (
+ "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
+ "projectId" INTEGER NOT NULL,
+ "timestampMilli" INTEGER NOT NULL,
+ "contents" TEXT NOT NULL,
+ "commit" TEXT,
+ "serviceName" TEXT NOT NULL,
+ "workerId" TEXT NOT NULL,
+ "runId" TEXT NOT NULL,
+ CONSTRAINT "Log_projectId_fkey" FOREIGN KEY ("projectId") REFERENCES "Project" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
+);