I have used the following SQL statements to change names in Trac 0.11 databases:
UPDATE "attachment" SET "author" ='<NEW-NAME>' WHERE "author" ='<OLD-NAME>'; UPDATE "auth_cookie" SET "name" ='<NEW-NAME>' WHERE "name" ='<OLD-NAME>'; UPDATE "component" SET "owner" ='<NEW-NAME>' WHERE "owner" ='<OLD-NAME>'; UPDATE "permission" SET "username" ='<NEW-NAME>' WHERE "username" ='<OLD-NAME>'; UPDATE "revision" SET "author" ='<NEW-NAME>' WHERE "author" ='<OLD-NAME>'; UPDATE "session" SET "sid" ='<NEW-NAME>' WHERE "sid" ='<OLD-NAME>'; UPDATE "session_attribute" SET "sid" ='<NEW-NAME>' WHERE "sid" ='<OLD-NAME>'; UPDATE "ticket" SET "owner" ='<NEW-NAME>' WHERE "owner" ='<OLD-NAME>'; UPDATE "ticket" SET "reporter" ='<NEW-NAME>' WHERE "reporter" ='<OLD-NAME>'; UPDATE "ticket_change" SET "author" ='<NEW-NAME>' WHERE "author" ='<OLD-NAME>'; UPDATE "ticket_change" SET "oldvalue" ='<NEW-NAME>' WHERE "oldvalue" ='<OLD-NAME>' AND "field"='owner'; UPDATE "ticket_change" SET "newvalue" ='<NEW-NAME>' WHERE "newvalue" ='<OLD-NAME>' AND "field"='owner'; UPDATE "wiki" SET "author" ='<NEW-NAME>' WHERE "author" ='<OLD-NAME>'; I am pretty sure this covers all that has to be done for one user. -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
