Canvas: Project -> Logs cascade delete
Change-Id: I268751c8a568240dc7a2976549a46d227d35f968
diff --git a/apps/canvas/back/prisma/migrations/20250707082734_delete_cascade_logs/migration.sql b/apps/canvas/back/prisma/migrations/20250707082734_delete_cascade_logs/migration.sql
new file mode 100644
index 0000000..803307c
--- /dev/null
+++ b/apps/canvas/back/prisma/migrations/20250707082734_delete_cascade_logs/migration.sql
@@ -0,0 +1,19 @@
+-- RedefineTables
+PRAGMA defer_foreign_keys=ON;
+PRAGMA foreign_keys=OFF;
+CREATE TABLE "new_Log" (
+ "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
+ "projectId" INTEGER NOT NULL,
+ "timestampMilli" BIGINT 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 CASCADE ON UPDATE CASCADE
+);
+INSERT INTO "new_Log" ("commit", "contents", "id", "projectId", "runId", "serviceName", "timestampMilli", "workerId") SELECT "commit", "contents", "id", "projectId", "runId", "serviceName", "timestampMilli", "workerId" FROM "Log";
+DROP TABLE "Log";
+ALTER TABLE "new_Log" RENAME TO "Log";
+PRAGMA foreign_keys=ON;
+PRAGMA defer_foreign_keys=OFF;
diff --git a/apps/canvas/back/prisma/schema.prisma b/apps/canvas/back/prisma/schema.prisma
index cee6787..e80b827 100644
--- a/apps/canvas/back/prisma/schema.prisma
+++ b/apps/canvas/back/prisma/schema.prisma
@@ -32,7 +32,7 @@
model Log {
id Int @id @default(autoincrement())
projectId Int
- project Project @relation(fields: [projectId], references: [id])
+ project Project @relation(fields: [projectId], references: [id], onDelete: Cascade)
timestampMilli BigInt
contents String
commit String?