Hi all, I have been playing around with the import and export of contacts and I have noticed the following:
The database structure for contacts does not make any of the actual contact entries unique. I think at least the 'name' entry should be, otherwise it might lead to confusion. It is easy to change the database. The structure (MySQL) currently looks like this: CREATE TABLE `contacts` ( `id` mediumint(9) NOT NULL auto_increment, `owner` mediumint(9) NOT NULL default '0', `name` text, `email` text, `email2` text, `grp` text, `aim` text, `icq` text, `msn` text, `yahoo` text, `jabber` text, `phone` text, `work` text, `cell` text, `address` text, `url` text, `cal_url` text, `rss_url` text, `comments` text, `shared` char(1) default NULL, `firstname` text, `lastname` text, `street` text, `extended` text, `city` text, `region` text, `postalcode` text, `country` text, PRIMARY KEY (`id`), KEY `id` (`id`), KEY `owner` (`owner`), KEY `shared` (`shared`) ) TYPE=MyISAM; and should be changed to CREATE TABLE `contacts` ( `id` mediumint(9) NOT NULL auto_increment, `owner` mediumint(9) NOT NULL default '0', `name` text, `email` text, `email2` text, `grp` text, `aim` text, `icq` text, `msn` text, `yahoo` text, `jabber` text, `phone` text, `work` text, `cell` text, `address` text, `url` text, `cal_url` text, `rss_url` text, `comments` text, `shared` char(1) default NULL, `firstname` text, `lastname` text, `street` text, `extended` text, `city` text, `region` text, `postalcode` text, `country` text, PRIMARY KEY (`id`), KEY `name` (`name`), KEY `id` (`id`), KEY `owner` (`owner`), KEY `shared` (`shared`) ) TYPE=MyISAM; However, error handling when a user tries to add/import an entry with a name that already exists will have to be added as well. Cheers, Martin -- "What a fool believes he sees, no wise man has the power to reason away..." Doobie Brothers (1978) ------------------------------------------------------- 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_idv37&alloc_id865&op=click _______________________________________________ Ilohamail-devel mailing list Ilohamail-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ilohamail-devel
