[TYPO3-english] Set (mySQL) ON UPDATE CURRENT_TIMESTAMP from ext_tables.sql

Peter Ruijter peter.ruijter at gmail.com
Tue Dec 11 09:52:13 CET 2012


Hi List,

Is it possible to set a (MYSQL) ON UPDATE CURRENT_TIMESTAMP from an
ext_tables.sql file?

When I add for example:

CREATE TABLE statistics(
   lastvisit timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE
CURRENT_TIMESTAMP,
);

The records with a column comment will keep appearing inside the extension
manager, when I try to reinstall the extension.

-- 

Kind regards,

Peter Ruijter
*Peter Industries*
www.peterindustries.com


More information about the TYPO3-english mailing list