Modify uc_cim schema to use unsigned int, not mediumint, for uid

user warning: Duplicate entry '8388607' for key 1 query: INSERT INTO uc_cim (uid, customer_profile_id) VALUES (213124447, 4092207)

The uc_cim module defines the uc_cim table this way:

  $schema['uc_cim'] = array(
    'fields' => array(
      'uid' => array('type' => 'int', 'size' => 'medium', 'not null' => TRUE, 'disp-width' => '9'),
      'customer_profile_id' => array('type' => 'int', 'not null' => TRUE, 'disp-width' => '11')),
    'primary key' => array('uid'),
  );

Problem is, a uid as large as 213124447 isn't going to fit in a medium size integer field. It always gets mangled and set to 8388607 when the uid is too large for the field, hence the duplicate entry errors.

The solution is to define the uid field the same way that the user.module does. The attached patch modifies the schema this for uc_cim and uc_cim_test tables, and provides a hook_update_N() to bring across those changes to sites already running uc_cim. It was created against uc_cim-HEAD.

This is also an issue with the payments table using mediumint. My related issue is at #1066368: order_id field in {uc_payment_cim} should be int not mediumint; storing cim_ppid breaks otherwise. I'll make this subject a little more relevant.

Thanks for the patch kostajh!

Committed!