Seb Hardman wrote:
> Hi,
>
> Not sure if I've used Trac correctly, but our usernames are our email
> addresses. We now need to change the email addresses, looking at the DB
> structure there is no easy way to do this other than run a load of
> update queries directly against the DB. Can anybody advise if there is
> an easy way to accomplish this, and also if there is a way of having a
> username associated with an email address which could then be
> subsequently changed.
>
Usernames should be usernames, not e-mail addresses. The association
between username and e-mail address is done at the "session" db
("session_attribute" for 0.10dev) table, eg:
INSERT INTO session (sid, authenticated, var_name, var_value) VALUES
('<your username here>', 1, 'email', '<your email address here>');
Have a look at the format of your "sid" and " var_value WHERE
var_name='email' " in this table.
HTH,
Daniel Serodio
_______________________________________________
Trac mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac
