Adding A Column to a Flat Table

Handy to add attributes to sales_flat_order:

$installer->getConnection()->addColumn(
    $this->getTable('sales/order'),
    'some_attribute',
    [
        'type' => Varien_Db_Ddl_Table::TYPE_INTEGER,
        'length' => 1,
        'comment'=> 'Comment'
    ]
);
Mike Whitby Over 8 years ago