[cvs] [Wiki] changed: TurbaOutlook2003

[Ben Chavet]

ben  Thu, 24 Aug 2006 08:37:23 -0700

Modified page: http://wiki.horde.org/TurbaOutlook2003
New Revision:  1.2
Change log:  add SQL script

@@ -482,6 +482,89 @@
          'Certificates' => array('pgpPublicKey', 'smimePublicKey'),
      ),
  </code>
  
-++ Preparing the database to use new fields
+++ Preparing the database
+
+The following SQL script will create a turba database table to hold all of the new fields.
+<code type="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 BLOB,
+    object_lastname VARCHAR(255),
+    object_alias VARCHAR(32),
+    object_email VARCHAR(255),
+    object_homestreet VARCHAR(255),
+    object_homestreet3 VARCHAR(255),
+    object_workstreet VARCHAR(255),
+    object_workstreet3 VARCHAR(255),
+    object_homephone VARCHAR(25),
+    object_workphone VARCHAR(25),
+    object_cellphone VARCHAR(25),
+    object_workfax VARCHAR(25),
+    object_title VARCHAR(255),
+    object_company VARCHAR(255),
+    object_notes TEXT,
+    object_pgppublickey TEXT,
+    object_smimepublickey TEXT,
+    object_freebusyurl VARCHAR(255),
+    object_firstname VARCHAR(255),
+    object_homecity VARCHAR(255),
+    object_homeprovince VARCHAR(255),
+    object_homepostalcode VARCHAR(255),
+    object_homecountry VARCHAR(255),
+    object_homestreet2 VARCHAR(255),
+    object_workstreet2 VARCHAR(255),
+    object_workcity VARCHAR(255),
+    object_workprovince VARCHAR(255),
+    object_workpostalcode VARCHAR(255),
+    object_workcountry VARCHAR(255),
+    object_website VARCHAR(255),
+    object_birthday VARCHAR(255),
+    object_nickname VARCHAR(255),
+    object_office VARCHAR(255),
+    object_jobtitle VARCHAR(255),
+    object_profession VARCHAR(255),
+    object_manager VARCHAR(255),
+    object_assistant VARCHAR(255),
+    object_suffix VARCHAR(255),
+    object_spouse VARCHAR(255),
+    object_anniversary VARCHAR(255),
+    object_email2 VARCHAR(255),
+    object_email3 VARCHAR(255),
+    object_category VARCHAR(255),
+    object_assistantphone VARCHAR(25),
+    object_workphone2 VARCHAR(25),
+    object_callback VARCHAR(255),
+    object_carphone VARCHAR(25),
+    object_companyphone VARCHAR(25),
+    object_homephone2 VARCHAR(25),
+    object_homefax VARCHAR(25),
+    object_isdn VARCHAR(255),
+    object_otherphone VARCHAR(25),
+    object_otherfax VARCHAR(25),
+    object_pager VARCHAR(25),
+    object_primaryphone VARCHAR(25),
+    object_radio VARCHAR(255),
+    object_telex VARCHAR(255),
+    object_ttytdd VARCHAR(255),
+    object_otherstreet VARCHAR(255),
+    object_otherstreet2 VARCHAR(255),
+    object_otherstreet3 VARCHAR(255),
+    object_othercity VARCHAR(255),
+    object_otherprovince VARCHAR(255),
+    object_otherpostalcode VARCHAR(255),
+    object_othercountry VARCHAR(255),
+    object_middlename VARCHAR(255),
+    object_department 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;
+</code>