4
A way to work around this would be to make another table named e.g. [Prefix_MyModule_]users and have a one:one relationship with the [prefix]users table.
On install just take all the uid's from the [prefix]users table and insert into the [Prefix_MyModule_]users table.
Of course this would mean that new registrations will not update the [Prefix_MyModule]users table, but I guess you have some procedure for adding information in that field, so just check to see if the uid is already in the database - if yes, then update, else insert.
