Improvement of PIM-SQL Databases, but search queries are still limited.

Addressbook: Changed table layout. Now, we just need 1/3 of disk-space.
Todo: Started to add new attributes. Some type conversions missing.

1 files changed, 10 insertions, 0 deletions

diff --git a/libopie/pim/ocontactfields.cpp b/libopie/pim/ocontactfields.cpp
index 831a596..7206f0d 100644
--- a/libopie/pim/ocontactfields.cpp
+++ b/libopie/pim/ocontactfields.cpp
@@ -152,86 +152,92 @@ QStringList OContactFields::trfields( bool sorted )
     list.append( mapIdToStr[Qtopia::HomeCity] );
     list.append( mapIdToStr[Qtopia::HomeState] );
     list.append( mapIdToStr[Qtopia::HomeZip] );
     list.append( mapIdToStr[Qtopia::HomeCountry] );
 
     list += trdetailsfields( sorted );
 
     list.append( mapIdToStr[Qtopia::Notes] );
     list.append( mapIdToStr[Qtopia::Groups] );
 
     if (sorted) list.sort();
 
     return list;
 }
 
 /*!
   \internal
   Returns an untranslated list of field names for a contact.
 */
 QStringList OContactFields::untrfields( bool sorted )
 {
     QStringList list;
     QMap<int, QString> mapIdToStr = idToUntrFields();
 
+    list.append( mapIdToStr[ Qtopia::AddressUid ] );
+    list.append( mapIdToStr[ Qtopia::AddressCategory ] );
+
     list.append( mapIdToStr[ Qtopia::Title ] );
     list.append( mapIdToStr[ Qtopia::FirstName ] );
     list.append( mapIdToStr[ Qtopia::MiddleName ] );
     list.append( mapIdToStr[ Qtopia::LastName ] );
     list.append( mapIdToStr[ Qtopia::Suffix ] );
     list.append( mapIdToStr[ Qtopia::FileAs ] );
 
     list.append( mapIdToStr[ Qtopia::JobTitle ] );
     list.append( mapIdToStr[ Qtopia::Department ] );
     list.append( mapIdToStr[ Qtopia::Company ] );
 
     list += untrphonefields( sorted );
 
     list.append( mapIdToStr[ Qtopia::BusinessStreet ] );
     list.append( mapIdToStr[ Qtopia::BusinessCity ] );
     list.append( mapIdToStr[ Qtopia::BusinessState ] );
     list.append( mapIdToStr[ Qtopia::BusinessZip ] );
     list.append( mapIdToStr[ Qtopia::BusinessCountry ] );
 
     list.append( mapIdToStr[ Qtopia::HomeStreet ] );
     list.append( mapIdToStr[ Qtopia::HomeCity ] );
     list.append( mapIdToStr[ Qtopia::HomeState ] );
     list.append( mapIdToStr[ Qtopia::HomeZip ] );
     list.append( mapIdToStr[ Qtopia::HomeCountry ] );
 
     list += untrdetailsfields( sorted );
 
     list.append( mapIdToStr[ Qtopia::Notes ] );
     list.append( mapIdToStr[ Qtopia::Groups ] );
 
     if (sorted) list.sort();
 
     return list;
 }
 QMap<int, QString> OContactFields::idToTrFields()
 {
         QMap<int, QString> ret_map;
 
+        ret_map.insert( Qtopia::AddressUid, QObject::tr( "User Id" ) );
+        ret_map.insert( Qtopia::AddressCategory, QObject::tr( "Categories" ) );
+
         ret_map.insert( Qtopia::Title, QObject::tr( "Name Title") );
         ret_map.insert( Qtopia::FirstName, QObject::tr( "First Name" ) );
         ret_map.insert( Qtopia::MiddleName, QObject::tr( "Middle Name" ) );
         ret_map.insert( Qtopia::LastName, QObject::tr( "Last Name" ) );
         ret_map.insert( Qtopia::Suffix,  QObject::tr( "Suffix" ));
         ret_map.insert( Qtopia::FileAs, QObject::tr( "File As" ) );
 
         ret_map.insert( Qtopia::JobTitle, QObject::tr( "Job Title" ) );
         ret_map.insert( Qtopia::Department, QObject::tr( "Department" ) );
         ret_map.insert( Qtopia::Company, QObject::tr( "Company" ) );
         ret_map.insert( Qtopia::BusinessPhone, QObject::tr( "Business Phone" ) );
         ret_map.insert( Qtopia::BusinessFax, QObject::tr( "Business Fax" ) );
         ret_map.insert( Qtopia::BusinessMobile,  QObject::tr( "Business Mobile" ));
 
         // email
         ret_map.insert( Qtopia::DefaultEmail, QObject::tr( "Default Email" ) );
         ret_map.insert( Qtopia::Emails, QObject::tr( "Emails" ) );
 
         ret_map.insert( Qtopia::HomePhone, QObject::tr( "Home Phone" ) );
         ret_map.insert( Qtopia::HomeFax, QObject::tr( "Home Fax" ) );
         ret_map.insert( Qtopia::HomeMobile, QObject::tr( "Home Mobile" ) );
 
         // business
         ret_map.insert( Qtopia::BusinessStreet, QObject::tr( "Business Street" ) );
@@ -253,48 +259,51 @@ QMap<int, QString> OContactFields::idToTrFields()
         ret_map.insert( Qtopia::HomeState, QObject::tr( "Home State" ) );
         ret_map.insert( Qtopia::HomeZip, QObject::tr( "Home Zip" ) );
         ret_map.insert( Qtopia::HomeCountry, QObject::tr( "Home Country" ) );
         ret_map.insert( Qtopia::HomeWebPage, QObject::tr( "Home Web Page" ) );
 
         //personal
         ret_map.insert( Qtopia::Spouse, QObject::tr( "Spouse" ) );
         ret_map.insert( Qtopia::Gender, QObject::tr( "Gender" ) );
         ret_map.insert( Qtopia::Birthday, QObject::tr( "Birthday" ) );
         ret_map.insert( Qtopia::Anniversary, QObject::tr( "Anniversary" ) );
         ret_map.insert( Qtopia::Nickname, QObject::tr( "Nickname" ) );
         ret_map.insert( Qtopia::Children, QObject::tr( "Children" ) );
 
         // other
         ret_map.insert( Qtopia::Notes, QObject::tr( "Notes" ) );
 
 
         return ret_map;
 }
 
 QMap<int, QString> OContactFields::idToUntrFields()
 {
         QMap<int, QString> ret_map;
 
+        ret_map.insert( Qtopia::AddressUid, "User Id" );
+        ret_map.insert( Qtopia::AddressCategory, "Categories" );
+
         ret_map.insert( Qtopia::Title, "Name Title" );
         ret_map.insert( Qtopia::FirstName, "First Name" );
         ret_map.insert( Qtopia::MiddleName, "Middle Name" );
         ret_map.insert( Qtopia::LastName, "Last Name" );
         ret_map.insert( Qtopia::Suffix, "Suffix" );
         ret_map.insert( Qtopia::FileAs, "File As" );
 
         ret_map.insert( Qtopia::JobTitle, "Job Title" );
         ret_map.insert( Qtopia::Department, "Department" );
         ret_map.insert( Qtopia::Company, "Company" );
         ret_map.insert( Qtopia::BusinessPhone, "Business Phone" );
         ret_map.insert( Qtopia::BusinessFax, "Business Fax" );
         ret_map.insert( Qtopia::BusinessMobile, "Business Mobile" );
 
         // email
         ret_map.insert( Qtopia::DefaultEmail, "Default Email" );
         ret_map.insert( Qtopia::Emails, "Emails" );
 
         ret_map.insert( Qtopia::HomePhone, "Home Phone" );
         ret_map.insert( Qtopia::HomeFax, "Home Fax" );
         ret_map.insert( Qtopia::HomeMobile, "Home Mobile" );
 
         // business
         ret_map.insert( Qtopia::BusinessStreet, "Business Street" );
@@ -307,48 +316,49 @@ QMap<int, QString> OContactFields::idToUntrFields()
 
         ret_map.insert( Qtopia::Office, "Office" );
         ret_map.insert( Qtopia::Profession, "Profession" );
         ret_map.insert( Qtopia::Assistant, "Assistant" );
         ret_map.insert( Qtopia::Manager, "Manager" );
 
         // home
         ret_map.insert( Qtopia::HomeStreet, "Home Street" );
         ret_map.insert( Qtopia::HomeCity, "Home City" );
         ret_map.insert( Qtopia::HomeState, "Home State" );
         ret_map.insert( Qtopia::HomeZip, "Home Zip" );
         ret_map.insert( Qtopia::HomeCountry, "Home Country" );
         ret_map.insert( Qtopia::HomeWebPage, "Home Web Page" );
 
         //personal
         ret_map.insert( Qtopia::Spouse, "Spouse" );
         ret_map.insert( Qtopia::Gender, "Gender" );
         ret_map.insert( Qtopia::Birthday, "Birthday" );
         ret_map.insert( Qtopia::Anniversary, "Anniversary" );
         ret_map.insert( Qtopia::Nickname, "Nickname" );
         ret_map.insert( Qtopia::Children, "Children" );
 
         // other
         ret_map.insert( Qtopia::Notes, "Notes" );
+        ret_map.insert( Qtopia::Groups, "Groups" );
 
 
         return ret_map;
 }
 
 QMap<QString, int> OContactFields::trFieldsToId()
 {
         QMap<int, QString> idtostr = idToTrFields();
         QMap<QString, int> ret_map;
 
 
         QMap<int, QString>::Iterator it;
         for( it = idtostr.begin(); it != idtostr.end(); ++it )
                 ret_map.insert( *it, it.key() );
 
 
         return ret_map;
 }
 
 QMap<QString, int> OContactFields::untrFieldsToId()
 {
         QMap<int, QString> idtostr = idToUntrFields();
         QMap<QString, int> ret_map;