Consolidate Users

Hello,

Our organization recently changed domain names on our e-mail addresses
so we now are in a situation where there are multiple user accounts for
a single person. I would like to consolidate these duplicate users so
that all tickets are owned by one user and delete the duplicate user
accounts. Can anyone tell me what tables in the database I need to
update to do this? We currently have RT 3.8.1 installed.

Thanks,

Adam