[horde] Changing UserNames

[Rob]

Rearranged

>>-----Original Message-----
>>From: Rob [mailto:horde.lists.horde.org at rosenfeld.to]
>>Sent: July 9, 2006 14:13
>>To: horde at lists.horde.org
>>Subject: [horde] Changing UserNames
>>
>>I'm migrating my hode installation to a new host.  My existing setup
>>uses IMP IMAP for authentication.  Unfortunately, on the new host, some
>>user IMAP logins must change.  I've noticed that throughout the horde
>>databases, username is used as a key.  Is there a way I can accomplish
>>this username change without losing all the data keyed by username?

On 7/10/2006, "Marc-Antoine Zizka" <mazizka at wantedtech.com> wrote:

>What backend do you use for preferences? In any case, you'll probably have
>to do the work manually. If you use an SQL database, then that shouldn't be
>too hard, assuming all the username changes are consistent. You should be
>able to write an SQL script for it.
>

I do use a SQL backend and can see that I can run a bunch of UPDATE
statements.  Is there a way to know what columns could possibly contain
a username for changing?  Or do I just brute force browse through every
column of every table and see what it seems to hold?