BEGIN TRANSACTION;
CREATE TABLE foo (
    id INTEGER PRIMARY KEY,
    value TEXT NOT NULL
);
INSERT INTO foo (id, value) VALUES (1, 'foo');
COMMIT TRANSACTION;
