-- $Horde: turba/scripts/sql/turba_objects.pgsql.sql,v 1.5 2006/03/20 18:25:00 selsky Exp $
-- You can simply execute this file in your database.
-- 
-- Run as:
--
-- $ psql -d DATABASE_NAME < turba_objects.pgsql.sql

CREATE TABLE turba_objects (
    object_id VARCHAR(32) NOT NULL,
    owner_id VARCHAR(255) NOT NULL,
    object_type VARCHAR(255) DEFAULT 'Object' NOT NULL,
    object_uid VARCHAR(255),
    object_members TEXT,
	object_firstname VARCHAR(255),
	object_lastname VARCHAR(255),
	object_nameprefix VARCHAR(255),
	object_alias VARCHAR(32),
    object_email VARCHAR(255),
	object_homestreet VARCHAR(255),
	object_homecity VARCHAR(255),
	object_homeprovince VARCHAR(255),
	object_homepostalcode VARCHAR(255),
	object_homecountry VARCHAR(255),
	object_workstreet VARCHAR(255),
	object_workcity VARCHAR(255),
	object_workprovince VARCHAR(255),
	object_workpostalcode VARCHAR(255),
	object_workcountry VARCHAR(255),
    object_homephone VARCHAR(25),
    object_workphone VARCHAR(25),
    object_cellphone VARCHAR(25),
	object_pager VARCHAR(25),
    object_fax VARCHAR(25),
    object_title VARCHAR(255),
    object_company VARCHAR(255),
    object_url VARCHAR(255),
    object_notes TEXT,
    object_pgppublickey TEXT,
    object_smimepublickey TEXT,
    object_freebusyurl VARCHAR(255),
    
    PRIMARY KEY(object_id)
);

CREATE INDEX turba_owner_idx ON turba_objects (owner_id);

GRANT SELECT, INSERT, UPDATE, DELETE ON turba_objects TO horde;