Shawn Koppenhoefer - 2014-12-29 18:13:09 - In reply to message 1 from Shawn Koppenhoefer
By looking into your manager_database.php file I see that I should be using 'timestamp'.
(I had thought it was 'time stamp' because of the space you used in the documentation I was using from
So I tried that, but now I am getting this error message:
Error: Could not parse database schema file: field value is not a valid timestamp value
Manuel Lemos - 2014-12-29 18:33:41 - In reply to message 2 from Shawn Koppenhoefer
Yes, that's because an empty string is not a valid timestamp for the default value. If you want the default to be NULL, just do not define the default. Otherwise, you need to specify a value in the ISO format YYYY-MM-DD HH:MM:SS .
Shawn Koppenhoefer - 2014-12-30 09:31:20 - In reply to message 5 from Manuel Lemos
but Arghhh. It didn’t work out as I expected.
The resulting mysql definition ended up with DEFAULT for my fields set to a *specific* datetime value (2014-12-30 10:22:45)(the datetime of the instant I reran the my updatedatabase.php script with that $manager->UpdateDatabase call. :(
But of course, I in mysql I can set the default to “CURRENT_TIMESTAMP” and that works fine, so this is not a problem (but would be nice to be able to set in the schema :)