FuelPHP Forums

apkahym

Hi, everyone.

I need change the name of an column into specific table.

How can i do it usig DBUtil?

Thanks

Harro

\DBUtil::modify_fields('table', array(

'old-name' => array('name' => 'new-name'),

));

It might be that you need to repeat a few other values too, I can't recall from memory if some are required.

apkahym

One more question:

How to set a attribute:

'BINARY','UNSIGNED','UNSIGNED ZEROFILL','on update CURRENT_TIMESTAMP'

with this DBUtil.
Thanks

Harro

Binary is a column type, just like all others.

array(

'unsigned' => true,

),

The others are not supported as they are specific to MySQL while the current DB layer has to be generic enough to work on other platforms too.

Both the ORM and Model_Crud have built-in support for adding timestamps on both insert and update.