如何将Datetime设置为Codeigniter迁移列的类型

Question

I am doing a migration file, and there is a field on a table wich type should be DateTime, and the default value CURRENT_TIMESTAMP. What I have until now is the next:

'date'  => array(
    'type' => 'DATETIME',
),

I think it is right... but I still need set the default value... definitely, what I want to do is make the translation from sql to codeigniter migration of this:

`date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP

Thanks in advance.

Answer 1

You can try like this.Need to use timestamp.See an example below..

   'created_at' => array('type' => 'timestamp')