The problem is described on the forums:

http://www.tigase.org/content/timestamp-issue-databasemysql-schema-4sql-tigase-51

Maybe the schema is not optimal but we have following requirements for these fields:

• acc_create_time must be automatically set to the current time when the record is first time created and should never be automatically changed afterwards

• last_login must be set so some initial value when the record is created and then it is manually updated on user's login. Default value like this: '1970-01-01 01:01:01' works sometimes and sometimes it causes failure. It may depends on the locale settings and/or timezone.

• last_logout as above, must be set to some initial value which does not break the DB and is manually updated on user logout event.

We are interested in MySQL versions: 5.0.x, 5.1.x, 5.5.x and 6.x.