[cvs] [Wiki] changed: SyncMLTurbaConfiguration

[Wiki Guest]

guest [91.86.75.99]  Wed, 14 Feb 2007 07:33:47 -0800

Modified page: http://wiki.horde.org/SyncMLTurbaConfiguration
New Revision:  1.1
Change log:  Added first migration script

@@ -3,9 +3,8 @@
  The sql script below provides a sql database schema and source.php snippet to make SyncML work better with Turba address books. Run the sql script to create the table. You have to rename/delete/backup your original turba_objects table first. 
  
  You also have to use the sources.php below or paste it into your existing sources.php (in the turba/conf directory) 
  
-It would be greate if somebody could provide a script that converts an existing database table to the new format.
  
  Here's the sql script:
  
  <code>
@@ -121,5 +120,37 @@
     'browse' => true,
     'use_shares' => true,
  );
  
+</code>
+
+Here is a first migration script, nothing spectacular nor perfect but better than nothing :
+
+<code>
+ALTER TABLE turba_objects add   object_firstname VARCHAR(255);
+ALTER TABLE turba_objects add 	object_lastname VARCHAR(255);
+ALTER TABLE turba_objects add 	object_nameprefix VARCHAR(255);
+ALTER TABLE turba_objects add 	object_homestreet VARCHAR(255);
+ALTER TABLE turba_objects add 	object_homecity VARCHAR(255);
+ALTER TABLE turba_objects add 	object_homeprovince VARCHAR(255);
+ALTER TABLE turba_objects add 	object_homepostalcode VARCHAR(255);
+ALTER TABLE turba_objects add 	object_homecountry VARCHAR(255);
+ALTER TABLE turba_objects add 	object_workstreet VARCHAR(255);
+ALTER TABLE turba_objects add 	object_workcity VARCHAR(255);
+ALTER TABLE turba_objects add 	object_workprovince VARCHAR(255);
+ALTER TABLE turba_objects add 	object_workpostalcode VARCHAR(255);
+ALTER TABLE turba_objects add 	object_workcountry VARCHAR(255);
+ALTER TABLE turba_objects add 	object_pager VARCHAR(25);
+ALTER TABLE turba_objects add 	object_role varchar(255);
+ALTER TABLE turba_objects add  	object_category varchar(80);
+ALTER TABLE turba_objects add 	object_photo blob;
+ALTER TABLE turba_objects add  	object_blobtype varchar(10);
+ALTER TABLE turba_objects add  	object_bday varchar(10);
+ALTER TABLE turba_objects add 	object_url varchar(255);
+
+//Replace name of the "full" field (definitively not perfect)
+ALTER TABLE turba_objects CHANGE object_homeaddress object_homestreet VARCHAR(255);
+
+ALTER TABLE turba_objects CHANGE object_workaddress object_workstreet VARCHAR(255);
+
+ALTER TABLE turba_objects CHANGE object_name object_lastname VARCHAR(255);
  </code>