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