[cvs] [Wiki] changed: RenameUsers

[Wiki Guest]

guest [70.233.170.222]  Mon, 16 Jan 2006 01:25:30 -0800

Modified page: http://wiki.horde.org/RenameUsers
New Revision:  1.6
Change log:  Revert

@@ -23,18 +23,16 @@
 #!/bin/sh
 
 function horde_rename() {
   new=$2; old=$1
-  echo Rename $old \-\> $new
+  echo Rename $old -> $new
 
   mysql -u horde -ppassword horde << EOF
 update hermes_timeslices set employee_id = '$new' where employee_id = '$old';
 update horde_datatree set user_uid = '$new' where user_uid = '$old';
 update horde_datatree set datatree_name = '$new' where datatree_name = '$old' and user_uid = '$new';
 update horde_datatree_attributes set attribute_value = '$new' where attribute_value = '$old' and attribute_key = 'who';
 update horde_datatree_attributes set attribute_key= '$new' where attribute_key = '$old' and attribute_name = 'perm_users';
-update horde_datatree_attributes set attribute_key= '$new' where attribute_key = '$old' and attribute_name = 'user';
-update horde_datatree_attributes set attribute_value = '$new' where attribute_value = '$old' and attribute_name = 'uid';
 update horde_datatree_attributes set attribute_value = '$new' where attribute_value = '$old' and attribute_name = 'owner';
 update horde_prefs set pref_uid = '$new' where pref_uid = '$old';
 update kronolith_events set event_creator_id = '$new' where event_creator_id = '$old';
 update kronolith_events set calendar_id = '$new' where calendar_id = '$old';