CREATE TABLE foo (id int not null, name text not null, bar text null, mystr text not null);