I'm trying to update my custom module's database table.
An so far i have done this.
Created mysql4-upgrade-0.1.0-0.1.1 - With the following code
<?php
$installer = $this;
$connection = $installer->getConnection();
//do this for each column you want to add
$connection->addColumn($installer->getTable('emailorder'), 'number_of_entries', array(
'type' => Varien_Db_Ddl_Table::TYPE_INTEGER,
'nullable' => false,
'comment' => 'Number Of Entries',
));
Ive change the vertionsnumber in the module config.xml and in the etc/module folder
Still it doesn't update my database table. What to do?
core_resource
table ?version
anddata_version
values ?data_version
andversion
to 0.1.1 for your module entry under thecore_resource
table. That will force the upgrade script to run again