[cvs] [Wiki] created: RenameRealm

Wiki Guest wikiguest at horde.org
Wed Jul 16 00:20:34 UTC 2008


guest [138.123.84.220]  Tue, 15 Jul 2008 20:20:34 -0400

Created page: http://wiki.horde.org/RenameRealm

The below SQL code can be used to rename the realm for all users or  
remove the realm from the uid's.

You probably want to tweak the SELECT statement for creating the  
temporary table in order to change the realm to what you need.  You'll  
also want to compare the update statements to make sure they match all  
the tables in your Horde install.  The update statements below are  
applicable to the Horde Groupware Webmail Edition.


<code type="sql">
--
-- realm_change.sql
--
-- This SQL code will change all the horde users from user at example.com  
to user.
--

CREATE TEMPORARY TABLE hu AS
SELECT DISTINCT pref_uid AS olduid, SUBSTRING_INDEX( pref_uid, '@', 1  
) AS newuid
FROM horde_prefs
WHERE pref_uid LIKE "%@example.com";

update hu, horde_alarms set alarm_uid = hu.newuid where alarm_uid = hu.olduid;
update hu, horde_datatree set user_uid = hu.newuid where user_uid = hu.olduid;
update hu, horde_datatree set datatree_name = hu.newuid where  
datatree_name = hu.olduid and user_uid = hu.newuid;
update hu, horde_datatree_attributes set attribute_value = hu.newuid  
where attribute_value = hu.olduid and attribute_key = 'who';
update hu, horde_datatree_attributes set attribute_key = hu.newuid  
where attribute_key = hu.olduid and attribute_name = 'perm_users';
update hu, horde_datatree_attributes set attribute_value = hu.newuid  
where attribute_value = hu.olduid and attribute_name = 'uid';
update hu, horde_datatree_attributes set attribute_value = hu.newuid  
where attribute_value = hu.olduid and attribute_name = 'owner';
update hu, horde_histories set history_who = hu.newuid where  
history_who = hu.olduid;
update hu, horde_prefs set pref_uid = hu.newuid where pref_uid = hu.olduid;
update hu, horde_syncml_anchors set syncml_uid = hu.newuid where  
syncml_uid = hu.olduid;
update hu, horde_syncml_map set syncml_uid = hu.newuid where  
syncml_uid = hu.olduid;
update hu, ingo_forwards set forward_owner = hu.newuid where  
forward_owner = hu.olduid;
update hu, ingo_lists set list_owner = hu.newuid where list_owner = hu.olduid;
update hu, ingo_rules set rule_owner = hu.newuid where rule_owner = hu.olduid;
update hu, ingo_shares set share_owner = hu.newuid where share_owner =  
hu.olduid;
update hu, ingo_shares set perm_creator = hu.newuid where perm_creator  
= hu.olduid;
update hu, ingo_shares_users set user_uid = hu.newuid where user_uid =  
hu.olduid;
update hu, ingo_spam set spam_owner = hu.newuid where spam_owner = hu.olduid;
update hu, ingo_vacations set vacation_owner = hu.newuid where  
vacation_owner = hu.olduid;
update hu, kronolith_events set event_creator_id = hu.newuid where  
event_creator_id = hu.olduid;
update hu, kronolith_events set calendar_id = hu.newuid where  
calendar_id = hu.olduid;
update hu, kronolith_shares set share_owner = hu.newuid where  
share_owner = hu.olduid;
update hu, kronolith_shares set perm_creator = hu.newuid where  
perm_creator = hu.olduid;
update hu, kronolith_shares_users set user_uid = hu.newuid where  
user_uid = hu.olduid;
update hu, mnemo_memos set memo_owner = hu.newuid where memo_owner =  
hu.olduid;
update hu, nag_tasks set task_owner = hu.newuid where task_owner = hu.olduid;
update hu, turba_objects set owner_id = hu.newuid where owner_id = hu.olduid;
</code>


More information about the cvs mailing list