| gio | 40c0c99 | 2025-07-02 13:18:05 +0000 | [diff] [blame^] | 1 | -- CreateTable |
| 2 | CREATE TABLE "Log" ( | ||||
| 3 | "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, | ||||
| 4 | "projectId" INTEGER NOT NULL, | ||||
| 5 | "timestampMilli" INTEGER NOT NULL, | ||||
| 6 | "contents" TEXT NOT NULL, | ||||
| 7 | "commit" TEXT, | ||||
| 8 | "serviceName" TEXT NOT NULL, | ||||
| 9 | "workerId" TEXT NOT NULL, | ||||
| 10 | "runId" TEXT NOT NULL, | ||||
| 11 | CONSTRAINT "Log_projectId_fkey" FOREIGN KEY ("projectId") REFERENCES "Project" ("id") ON DELETE RESTRICT ON UPDATE CASCADE | ||||
| 12 | ); | ||||