evgv/mage_add_new_column_to_existed_table.md

Created March 17, 2017 07:45

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/evgv/99a14a69dc5391e9f5e58f6fc8ca0d4f.js"></script>
Save evgv/99a14a69dc5391e9f5e58f6fc8ca0d4f to your computer and use it in GitHub Desktop.

Download ZIP

Magento. Add new column to existed table

Raw

mage_add_new_column_to_existed_table.md

Add new column to existed table

/* @var $installer Mage_Core_Model_Resource_Setup */
$installer = $this;
$installer->startSetup();

try {
    $installer->getConnection()
        ->addColumn($installer->getTable('blog/blog'), 'thumbnail', array(
            'type'      => Varien_Db_Ddl_Table::TYPE_TEXT,
            'nullable'  => false,
            'length'    => 255,
            'after'     => null, // column name to insert new column after
            'comment'   => 'Title'
        ));   
} catch (Exception $e) {
    Mage::logException($e);
}

$installer->endSetup();