Contact Management

[James Tavares]

(redirected from IMP list to TURBA list)
--------------------------------------------------------

I'd like to move progess along on turba's group support. It's important to
me (I hacked it into 2.2.4 in the worst way.)

Quoting Chuck Hagenbuch <chuck@horde.org>:

> Quoting Kris von Mach <dev@swishmail.com>:
>
> > CREATE TABLE Turba_Groups (
> >    group_ID varchar(32) NOT NULL,
> >    name varchar(32),
> >    PRIMARY KEY (group_ID)
> > );
> >
> > CREATE TABLE Turba_Groups_Objects (
> >    group_ID varchar(32) NOT NULL,
> >    object_ID varchar(32) NOT NULL
> > );
>
> These aren't used yet, and will probably be changed slightly before they
> are.

I'd like to make one suggestion...If I'm to code this, I'd like to add a
table so as I could support Groups within Groups.. Basically:

CREATE TABLE Turba_Groups_Groups (
    parent_grID varchar(32) NOT NULL,
    child_grID varchar(32) NOT NULL
);

What do you think?

> > CREATE TABLE Turba_Objects (
> >    object_ID varchar(32) NOT NULL,
> >    owner_ID varchar(32) NOT NULL,
> >    name varchar(255),
> >    email varchar(255),
> >    homeAddress varchar(255),
> >    workAddress varchar(255),
> >    homePhone varchar(25),
> >    workPhone varchar(25),
> >    cellPhone varchar(25),
> >    fax varchar(25),
> >    title varchar(32),
> >    company varchar(32),
> >    notes text,
> >    PRIMARY KEY (object_ID)
> > );

What is the contents of object_ID and owner_ID?

Do you guys have any reservations about using Auto Increment columns?
Personally, I think they would make perfect _ID's to link all these
tables.....

-James

---------------------------------------------------------
James Tavares <jtavares@loa.com>
Sr. Data Network Engineer
Log On America, Inc.

Ph: 1-401-459-6294
Fax: 1-401-459-6580
Web: http://www.loa.com/