30 Dec 2013, 00:00

SQLite3 – Add or Remove NOT NULL Constraint on Existing Table Column
ALTER TABLE YourTable RENAME TO OldTable;
CREATE TABLE YourTable (/* old cols with new requirements */);
INSERT INTO YourTable SELECT * FROM OldTable;
DROP TABLE OldTable;
VACUUM;
.q

Source