[turba] Updating the Turba Schema

[Simon Brereton]

> -----Original Message-----
> From: Simon Brereton


> Mike - I'll take another look at it.  I meant to add the third
> option, that Turba already supported this and I hadn't seen it.
> 
> However, I'm not sure I can agree that it does :)  if I go into the
> DB Structure, turba_objects, there are:
> 
> object_id	owner_id	object_type	object_uid	object_members
> 	object_firstname	object_lastname	object_middlenames
> 	object_nameprefix	object_namesuffix	object_alias
> 	object_photo	object_phototype	object_bday
> 	object_homestreet	object_homepob	object_homecity
> 	object_homeprovince	object_homepostalcode
> 	object_homecountry	object_workstreet	object_workpob
> 	object_workcity	object_workprovince	object_workpostalcode
> 	object_workcountry	object_tz	object_geo	object_email
> 	object_homephone	object_workphone	object_cellphone	object_fax
> 	object_pager	object_title	object_role	object_logo
> 	object_logotype	object_company	object_category
> 	object_notes	object_url	object_freebusyurl
> 	object_pgppublickey	object_smimepublickey
> 
> only one email.  And indeed this is what is displayed for all my
> contacts - system wide.  So it looks like I have to go down the hack
> route (unless there's a simple .sql I can run?).  So,  I'm a little
> perplexed, because I feel you should be right (searching on the topic
> didn't bring up a wealth of previous posts, so either this isn't a
> feature no one else needed *or* there's something not right with my
> set up.  This, however, is a fresh install and not an upgrade - so
> I'm confused as to how I've ended up with only one email field.
> 
> In the meantime I'll give your instructions a shot.

Mike

Having followed your instructions - and using the blog as crutch I now have what seems to be a working home email and work email fields in Turba. IMP is giving me both options to chose from when I type in the alias, so it looks good (I'll try synching next).

However, I now have an extraneous field - 

Email	
Home Email	
Work Email

Is it safe to get rid of this?

Should I just remove it from the communications tab section in backends.php/sources.php?  Or do I need to do it from attributes.php too?

Assume I've copied all current values from Email to homeEmail in the DB.

I just think the extra field will confuse users.


Thanks.

Simon