CREATE TABLE test ( id integer NOT NULL PRIMARY KEY AUTOINCREMENT, int_val integer NOT NULL, text_val text NOT NULL );