-- RedefineTables PRAGMA defer_foreign_keys=ON; PRAGMA foreign_keys=OFF; CREATE TABLE "new_Year" ( "year" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "budget" REAL NOT NULL DEFAULT 3000 ); INSERT INTO "new_Year" ("year") SELECT "year" FROM "Year"; DROP TABLE "Year"; ALTER TABLE "new_Year" RENAME TO "Year"; PRAGMA foreign_keys=ON; PRAGMA defer_foreign_keys=OFF;