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

Helge Hess discuss@opengroupware.org
Thu, 13 Dec 2007 15:39:30 +0100


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).

Greets,
   Helge
-- 
Helge Hess
http://www.helgehess.eu/