Cannot add NULL timestamp field

[afallison]

The application throws an error when adding a new field using dataType 'timestamp'

Syntax error or access violation: 1067 Invalid default value for 'date'
ALTER TABLE `test` MODIFY COLUMN `date` timestamp DEFAULT NULL

I was able to make it work by manually running this query:

ALTER TABLE `test` ADD COLUMN `timeIn` timestamp NULL DEFAULT NULL

'NULL' should be added after the dataType

BEFORE:
ALTER TABLE `test` ADD COLUMN `timeIn` timestamp DEFAULT NULL

AFTER:
ALTER TABLE `test` ADD COLUMN `timeIn` timestamp NULL DEFAULT NULL

Server Info:

• Ubuntu 14.14
• Apache 2.4.7
• PHP 5.5.9