Update custom module database

Question

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?

Answer 1

$installer->getTable('emailorder') is wrong.

It format is should be

$installer->getTable('ModulePrefix/Entity)

Or instead of $installer->getTable('emailorder') use the table name