[support] database fields not present

[Thijs Hakkenberg]

  Dear List,

I am using an module 'ideal professional' for ubercart. Everything works 
well, but when an user finishes an payment, the following error is shown:

* user warning: Unknown column 'trx_id' in 'field list' query: INSERT 
INTO uc_payment_ideal (order_id, trx_id, status, received) VALUES (11, 
'0050000551913841', 'OPEN', 1278337590) in 
//public_html/modules/uc_ideal_pro/uc_ideal_pro.module on line 271.
* user warning: Unknown column 'trx_id' in 'field list' query: SELECT 
trx_id, status FROM uc_payment_ideal WHERE order_id = 11 in 
/public_html/modules/uc_ideal_pro/uc_ideal_pro.module on line 286.

I've looked in the datbase and can't find the trx_id column. The 
uc_ideal_pro.install file contains this:

function uc_ideal_pro_schema() {
   $schema = array();

   $schema['uc_payment_ideal'] = array(
     'description' => t('Logs iDEAL transaction statuses.'),
     'fields' => array(
       'order_id' => array(
         'description' => t('The Ubercart order ID.'),
         'type' => 'int',
         'unsigned' => TRUE,
         'not null' => TRUE,
         'default' => 0,
       ),
       'trx_id' => array(
         'description' => t('The iDEAL transaction ID.'),
         'type' => 'varchar',
         'length' => 16,
         'not null' => TRUE,
         'default' => 0,
       ),
       'status' => array(
         'description' => t('The iDEAL transaction status.'),
         'type' => 'varchar',
         'length' => 10,
         'not null' => TRUE,
         'default' => 'OPEN',
       ),
       'received' => array(
         'description' => t('The transaction status timestamp.'),
         'type' => 'int',
         'unsigned' => TRUE,
         'not null' => TRUE,
         'default' => 0,
       ),
     ),
     'primary key' => array('order_id'),
     'unique keys' => array(
       'vid'     => array('trx_id'),
     ),
     'indexes' => array(
       'status' => array('status', 'received'),
     ),
   );

   return $schema;
}

/**
  * Implementation of hook_install().
  */
function uc_ideal_pro_install() {
   drupal_install_schema('uc_ideal_pro');

   $t = get_t();
   db_query("INSERT INTO {uc_order_statuses} (order_status_id, title, 
state, weight, locked) VALUES ('ideal_pending', '%s', 
'payment_received', 7, 1);", $t('i\
DEAL pending'));
}

So it looks like the database fields weren't modified during install. I 
tried the update.php script, but it won't show this module. Any other 
way to modify the db?

Cheers,
Thijs Hakkenberg