[TYPO3-dev] Default definitions of database fields

Steffen Kamper ks at dislabs.de
Thu Feb 11 18:23:47 CET 2010


Hi Jochen,

there was already a discussion for timetamps if we ue NULL if not set, 
as you also pointed out that 0 is 01.01.1970.
But core does not support it. May be i'll look for such solution.

I also change such statements, and if sqlparser complains it's a bug 
which should be fixed ;)

So i would go for
starttime int DEFAULT NULL :)

we also could use

starttime timestamp

but i'm sure it's not supported by sqlparser as well, also it doesn't 
support DEFAULT NULL.

When using this MySQL will add this:

`starttime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE 
CURRENT_TIMESTAMP

vg Steffen




More information about the TYPO3-dev mailing list