[imp] Contacts Management

[Chuck Hagenbuch]

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.

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

This is required if you want to use SQL contacts, although the exact fields are 
up to you - just make the source map match the table.

> CREATE TABLE user_turba_prefs (
>    uid varchar(32) NOT NULL,
>    pref_name varchar(32) NOT NULL,
>    pref_value text,
>    PRIMARY KEY (uid, pref_name)
> );

This isn't necessary.

-chuck

--
Charles Hagenbuch, <chuck@horde.org>
Number of U.S. nuclear bombs lost in accidents and never recovered: 11