[cvs] [Wiki] changed: RenameUsers

[Wiki Guest]

guest [213.197.150.2]  Thu, 18 Jan 2007 08:28:47 -0800

Modified page: http://wiki.horde.org/RenameUsers
New Revision:  1.9
Change log:  enable script to convert ticket requesters too

@@ -40,8 +40,9 @@
  update kronolith_events set calendar_id = '$new' where calendar_id = '$old';
  update mnemo_memos set memo_owner = '$new' where memo_owner = '$old';
  update nag_tasks set task_owner = '$new' where task_owner = '$old';
  update turba_objects set owner_id = '$new' where owner_id = '$old';
+update whups_tickets set user_id_requester = '$new' where user_id_requester = '$old';
  update whups_queues_users set user_uid = '$new' where user_uid = '$old';
  update whups_users_searches set user_uid = '$new' where user_uid = '$old';
  EOF
    echo "Done with $new"