[OGo-Discuss] phone call information to contacts in ogo

[Sebastian Reitenbach]

discuss@opengroupware.org wrote: 
> On 13.12.2007, at 15:35, Sebastian Reitenbach wrote:
> > Helge, how is the notes to persons added in the pending schema  
> > change you mentioned? Maybe I can just use that.
> 
> 
> ---snip---
> -- field to connect documents and notes to contacts
> ALTER TABLE document ADD COLUMN company_id INT NULL;
> 
> -- prepare for project hierarchies
> ALTER TABLE project ADD COLUMN parent_project_id INT NULL;
> ---snap---
> 
> Note: this is just in the DB schema, not in the OGo UI or even Logic  
> (I use those in a Java application).
thanks, I just only wanted to know, whether this is useful for the purpose 
I'm planning.
I think I'll add a complete table, for the asterisk call records, and then 
automatically add a unique sequence on it, somehow ;), my sql knowledge is a 
bit rusty, need to lookup sql documents. I think the details are much 
valuable, not necessarily for the call logs attached to persons, i don't 
need all fields, but with a complete table, I'd be able to add the phone 
call report interface to the AsteriskUI, which I would like to have too.

Sebastian

> 
> Greets,
>    Helge
> -- 
> Helge Hess
> http://www.helgehess.eu/
> -- 
> OpenGroupware.org Discussion discuss@opengroupware.org
> http://mail.opengroupware.org/mailman/listinfo/discuss
>