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