[cvs] [Wiki] changed: SyncMLTurbaConfiguration

[Michael Rubinsky]

mrubinsk  Wed, 22 Aug 2007 12:30:12 -0700

Modified page: http://dev.horde.org/horde/wicked/SyncMLTurbaConfiguration
New Revision:  1.4
Change log:  formatting nits

@@ -128,25 +128,25 @@

 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_nameprefix 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_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);
+ALTER TABLE turba_objects ADD   object_firstname VARCHAR(255);
+ALTER TABLE turba_objects ADD   object_nameprefix 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_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);