/* Warnings: - You are about to drop the column `deleted` on the `Pub` table. All the data in the column will be lost. */ -- RedefineTables PRAGMA defer_foreign_keys=ON; PRAGMA foreign_keys=OFF; CREATE TABLE "new_Pub" ( "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "title" TEXT NOT NULL, "link" TEXT NOT NULL DEFAULT '', "query_after_days" INTEGER NOT NULL ); INSERT INTO "new_Pub" ("id", "link", "query_after_days", "title") SELECT "id", "link", "query_after_days", "title" FROM "Pub"; DROP TABLE "Pub"; ALTER TABLE "new_Pub" RENAME TO "Pub"; PRAGMA foreign_keys=ON; PRAGMA defer_foreign_keys=OFF;