| gio | 40c0c99 | 2025-07-02 13:18:05 +0000 | [diff] [blame^] | 1 | /* |
| 2 | Warnings: |
| 3 | |
| 4 | - You are about to alter the column `timestampMilli` on the `Log` table. The data in that column could be lost. The data in that column will be cast from `Int` to `BigInt`. |
| 5 | |
| 6 | */ |
| 7 | -- RedefineTables |
| 8 | PRAGMA defer_foreign_keys=ON; |
| 9 | PRAGMA foreign_keys=OFF; |
| 10 | CREATE TABLE "new_Log" ( |
| 11 | "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, |
| 12 | "projectId" INTEGER NOT NULL, |
| 13 | "timestampMilli" BIGINT NOT NULL, |
| 14 | "contents" TEXT NOT NULL, |
| 15 | "commit" TEXT, |
| 16 | "serviceName" TEXT NOT NULL, |
| 17 | "workerId" TEXT NOT NULL, |
| 18 | "runId" TEXT NOT NULL, |
| 19 | CONSTRAINT "Log_projectId_fkey" FOREIGN KEY ("projectId") REFERENCES "Project" ("id") ON DELETE RESTRICT ON UPDATE CASCADE |
| 20 | ); |
| 21 | INSERT INTO "new_Log" ("commit", "contents", "id", "projectId", "runId", "serviceName", "timestampMilli", "workerId") SELECT "commit", "contents", "id", "projectId", "runId", "serviceName", "timestampMilli", "workerId" FROM "Log"; |
| 22 | DROP TABLE "Log"; |
| 23 | ALTER TABLE "new_Log" RENAME TO "Log"; |
| 24 | PRAGMA foreign_keys=ON; |
| 25 | PRAGMA defer_foreign_keys=OFF; |