This article is tagged with:
Sql syntax create timestamp column
and mysql
sql syntax create timestamp column
CREATE TABLE tablename (columnname datetime NOT NULL DEFAULT CURRENT_TIMESTAMP)