ALTER TABLE "cards" RENAME TO "cards_non_strict"; CREATE TABLE IF NOT EXISTS "cards" ( question TEXT NOT NULL, responses TEXT NOT NULL, state TEXT NOT NULL, created INTEGER NOT NULL, /* TIMESTAMP */ updated INTEGER NULL, /* TIMESTAMP */ deleted INTEGER NULL, /* TIMESTAMP */ ready INTEGER NOT NULL, /* TIMESTAMP */ PRIMARY KEY (question, responses) ) STRICT; INSERT INTO cards (question, responses, state, created, updated, deleted, ready) SELECT question, responses, state, created, updated, deleted, ready FROM cards_non_strict; DROP TABLE cards_non_strict;