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/
