PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE todo (id INTEGER PRIMARY KEY, task char(100) NOT NULL, status bool NOT NULL);
INSERT INTO "todo" VALUES(1,'Read Google News',0);
INSERT INTO "todo" VALUES(2,'Visit the Python website',1);
INSERT INTO "todo" VALUES(3,'See how flask differs from bottle',1);
INSERT INTO "todo" VALUES(4,'Watch the latest from the Slingshot Channel',0);
COMMIT;