IMO you can add a separate table into RoundCube database without a problem.
Personally I would prefer to add just a "type" field to the default addressbook table to indicate that the contact was added automatically.
It would also fit my plans to introduce global (editable/write protected) contacts by a future plugin.
So lets say ....
- type 0 or NULL = indiviually created
- type 1 = automatically created
- type 2 = global editable
- type 3 = global write protected
Finally we would need some kind of filter for the differnt types in the contacts list and an option in the preferences page to discard auto-saving on a per user level.
-Roland
----- Original Message ----- From: "Jocelyn Delalande" jocelyn.lists08@crapouillou.net To: dev@lists.roundcube.net Sent: Thursday, June 04, 2009 2:16 AM Subject: [RCD] sql extra table ?
Hi,
I am planning to write a plugin to reproduce the "collected addressbook" feature of thunderbird (ie: each email address you send a mail to is collected in a special automatic addressbook, usefull for completion).
I need to store the completed addresses somewhere of course, watching at some code and existing plugins, I see 3 ways to do that :
- store it into the main address book of the user, but it's not a good
solution as "explicit" contacts will get lost in collected addresses.
- store it in the "cache" table, but I then have only one field and I
need to use serializing/unserializing, that is bad for performances (& with a quicly growing collected list...).
- creating a new SQL table for the plugin, that would be the cleaner
solution at the moment but I wonder if there is some caveats adding "freely" tables to the roundcube base...
... Can you guys give me some advice on that ?
Thanks for your help & anyway for that great piece of code !
Jocelyn _______________________________________________ List info: http://lists.roundcube.net/dev/
List info: http://lists.roundcube.net/dev/