-- $Horde: turba/scripts/sql/turba_objects_syncml.mysql.sql,v 1.4 2006/03/20 18:25:00 selsky Exp $
-- turba_objects more suitable for SyncML replication.
--
-- You can simply execute this file in your database.
--
-- Run as:
--
-- $ mysql --user=root --password=<MySQL-root-password> <db name> < turba_objects.mysql.sql
CREATE TABLE `turba_objects` (
  `object_id` varchar(32) NOT NULL,
  `owner_id` varchar(255) NOT NULL,
  `object_type` varchar(255) NOT NULL default 'Object',
  `object_uid` varchar(255),
  `object_members` blob,
  `object_lastname` varchar(255) NOT NULL default '',
  `object_firstname` varchar(255),
  `object_alias` varchar(32),
  `object_nameprefix` varchar(255),
  `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_fax` varchar(25),
  `object_pager` varchar(25),
  `object_title` varchar(255),
  `object_company` varchar(255),
  `object_notes` text,
  `object_url` varchar(255),
  `object_pgppublickey` text,
  `object_smimepublickey` text,
  `object_freebusyurl` varchar(255),
  `object_role` varchar(255),
  `object_category` varchar(80),
  `object_photo` blob,
  `object_blobtype` varchar(10),
  `object_bday` bigint(10),
    
    PRIMARY KEY(object_id)
);

CREATE INDEX turba_owner_idx ON turba_objects (owner_id);

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

