Modify table column

Change column type from int(11) to bigint(20) with modifyColumn() function from class Varien_Db_Adapter_Pdo_Mysql

$installer = $this;
$installer->startSetup();

$installer->getConnection()->modifyColumn($installer->getTable('webforms/results'), 'customer_ip', array('type' => Varien_Db_Ddl_Table::TYPE_BIGINT));    

// or
// $installer->run("ALTER TABLE {$this->getTable('webforms/results')} MODIFY `customer_ip` BIGINT( 20 ) ;");

$installer->endSetup();
view raw mage_modify_table_column.md hosted with ❤ by GitHub