MessageStore MySQL - Support Fractional Seconds

The SQL scripts to generate the MySQL table use the DATETIME datatype to store temporal information. Unfortunately, MySQL < 5.6.4 does not support fractional seconds. This, may cause non-deterministic behavior when messages are being polled from a MessageStore.

"MySQL 5.6.4 and up expands fractional seconds support for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision"

• http://dev.mysql.com/doc/refman/5.6/en/fractional-seconds.html
• http://dev.mysql.com/doc/refman/5.1/en/fractional-seconds.html

Therefore, I think we should improve the SQL scripts and a define maximum precision of:

DATETIME(6)

Furthermore, we should add a note to the documentation, that when using a MySQL- based message store, a version of MySQL >=5.6.4 shall be used and the reasons why.