How to set CURRENT_TIMESTAMP as a default value in Magento DDL

Question

I am updating my table structure and everything work good, but default value for column created_at is 0000-00-00 00:00:00 again and again.

I want it to be equal to current time (CURRENT_TIMESTAMP);

Here is my current code:

$table->addColumn($tableBanners, 'created_at', [
    'type'     => Varien_Db_Ddl_Table::TYPE_TIMESTAMP,
    'nullable' => false,
    'comment'  => 'created_at',
    'default'  => 'CURRENT_TIMESTAMP'
]);

Answer 1

On 'default' section, change to Varien_Db_Ddl_Table::TIMESTAMP_INIT. So that:

'default'  => Varien_Db_Ddl_Table::TIMESTAMP_INIT

Ref: https://code007.wordpress.com/2014/04/26/magento-how-to-create-a-timestamp-table-column-with-current_timestamp-as-default-value/

Answer 2

You can use these for equal value for current timestamp

date('Y-m-d G:i:s')