theory/sqitch — pull request #182 by robertblank (2014-09-22 11:58:06+00:00)
Title: Update mysql.sql: DATETIME(6) is not compatible with MySQL < 5.6.4

http://dev.mysql.com/doc/refman/5.6/en/date-and-time-type-overview.html

"MySQL 5.6.4 and up permits fractional seconds for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision. To define a column that includes a fractional seconds part, use the syntax type_name(fsp), where type_name is TIME, DATETIME, or TIMESTAMP, and fsp is the fractional seconds precision. For example:

CREATE TABLE t1 (t TIME(3), dt DATETIME(6));"

This means that for versions MySQL < 5.6.4 the syntax dt DATETIME(6) produces an error.
As this is an optional value I suggest to use DATETIME without fsp to keep it more compatible.