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" <[email protected]> To: <[email protected]> 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/
