/* Warnings: - Added the required column `fileName` to the `PhotoPost` table without a default value. This is not possible if the table is not empty. - Added the required column `filePath` to the `PhotoPost` table without a default value. This is not possible if the table is not empty. - Added the required column `title` to the `PhotoPost` table without a default value. This is not possible if the table is not empty. */ -- RedefineTables PRAGMA defer_foreign_keys=ON; PRAGMA foreign_keys=OFF; CREATE TABLE "new_PhotoPost" ( "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, "deletedAt" DATETIME, "publishedAt" DATETIME, "filePath" TEXT NOT NULL, "fileName" TEXT NOT NULL, "title" TEXT NOT NULL, "description" TEXT ); INSERT INTO "new_PhotoPost" ("createdAt", "id") SELECT "createdAt", "id" FROM "PhotoPost"; DROP TABLE "PhotoPost"; ALTER TABLE "new_PhotoPost" RENAME TO "PhotoPost"; PRAGMA foreign_keys=ON; PRAGMA defer_foreign_keys=OFF;