Hi all,

I think it might be a good idea to have a database table for plugins.

If plugins needs to store some values currently this is done mostly by using 'users' table 'preferences' field.

I think it's better to have a separate table.

The following structure should be flexible enough. ------------------------------------------------------ CREATE TABLE IF NOT EXISTS plugins ( id int(11) NOT NULL AUTO_INCREMENT, user_id int(11) DEFAULT NULL, contact_id int(11) DEFAULT NULL, identity_id int(11) DEFAULT NULL, plugin text, key text, value text, timestamp timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -------------------------------------------------------- Any comments are welcome. Regards, Roland

List info: http://lists.roundcube.net/dev/