[horde] Reset user prefs?

[Kevin Konowalec]

Wow - our users would go INSANE if I nuked the prefs table to just  
change one thing...  The real problem is you've got some fields that  
are all serialized.  To change one value means unpacking the field,  
modifying, and re-adding it.  Definitely a pain if you are trying to  
make a global change across thousands of users....


On Oct 14, 2005, at 9:10 AM, Edwin L. Culp wrote:

> Quoting Jason Dixon <jason at dixongroup.net>:
>
>
>> Is there any way to easily reset user preferences on a global or per-
>> application basis?
>>
>
> This seems far too simple but hopefully this is what you want.  I do
> global on my test instalation with
>
> mysql [your_data_base_name <<%
> DROP TABLE IF EXISTS `horde_prefs`;
> CREATE TABLE `horde_prefs` (
>   `pref_uid` varchar(200) NOT NULL default '',
>   `pref_scope` varchar(16) NOT NULL default '',
>   `pref_name` varchar(32) NOT NULL default '',
>   `pref_value` longtext,
>   PRIMARY KEY  (`pref_uid`,`pref_scope`,`pref_name`)
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
> %
>
> Of course you may want to put the contents of the "here doc" in a file
> [resetprefs.sql] and
> mysql [your_data_base_name < resetprefs.sql
>
> I have a file like that in my horde/scripts/sql folder.
>
> I never do individual prefs resets.  Maybe I should. . . . .
>
> ed
>
> -- 
> Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>
>