Using dbforge?

[eluser]WanWizard[/eluser]
It's not going to work, because the dbforge database driver assumes it's a literal (string, number), an places any default value in single quotes.

The work-around is:

Code:

'date' => array("date TIMESTAMP DEFAULT CURRENT_TIMESTAMP")

if you pass a string as array value instead of an creating an associated array, the string is used as-is. Note that it is likely that this breaks database portability.

This is explained in the user guide, database library, dbforge, add_field.