CREATE TABLE tablename ( ..., ts timestamp DEFAULT CURRENT_TIMESTAMP, ... );