On 1/3/2006, "(Harvey Smith)" <[EMAIL PROTECTED]> wrote:
>On a related note I wish the the IM contacts part was more free-form
>too. As it is (and is with most all other programs) it takes work to
>add support for a new IM-protocol and people can't have more than one
>ID for any one protocol (I have multiple jabber accounts for example).
>
>I think it would be better if it was arrange in the DB like:
> im1_type text,
> im1_id text,
> im2_type text,
> im2_id text,
> im3_type text,
> im3_id text,
Yeah, this is a tricky one. Your solution would be flexible and might
work for the current functionality, but it would make it slightly harder
to do structured exports (e.g. "export all my friends AIM screen
names").
One possibility is to add another table with fields like:
contact_id int,
field_name text,
field_type char,
field_value blob,
and allow users to add pretty much any kind of data they want. If the
field_name is somewhat structured (i.e. we know AIM screen names always
have field_name="AIM") it's pretty easy to extract the data.
Ryo
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Ilohamail-devel mailing list
Ilohamail-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ilohamail-devel
