Handling timestamp defaults

[terryweiss]

Hi. I am using 6.3 with latest Mariadb. I have tables with a structure as follows:

Code: Select all

created	timestamp not null default now(),
updated	timestamp null default null on update current_timestamp,

MySQL only allows current_timestamp on one timestamp field per table, so this schema is valid and works on the DB.

But when forge generate or compares this is what I end up with is:

Code: Select all

created timestamp	not null default '0000-00-00 00:00:00' on update current_timestamp,
updated timestamp	null default null on update current_timestamp,

Which is not the same thing. Worse is that it is not valid.

Do you have any guidance for this?

t.

[alexa]

We will investigate this issue and will answer you as soon as possible.

[alexa]

Such a result is returned by the MySQL server itself.