CREATE TABLE foo (a text, b integer, c DATETIME, d DATE);