[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