--- mysql_create.sql	2004-06-15 10:44:12.530244592 +1000
+++ mysql_create.sql.new	2004-06-15 10:50:44.484658464 +1000
@@ -11,20 +11,35 @@
     object_type VARCHAR(255) NOT NULL DEFAULT 'Object',
     object_members BLOB,
     object_name VARCHAR(255),
+    object_lastname VARCHAR(255),
     object_alias VARCHAR(32),
     object_email VARCHAR(255),
     object_homeaddress VARCHAR(255),
+    object_homecity VARCHAR(255),
+    object_homeprovince VARCHAR(255),
+    object_homepostalcode VARCHAR(255),
+    object_homecountry VARCHAR(255),
     object_workaddress VARCHAR(255),
+    object_workcity VARCHAR(255),
+    object_workprovince VARCHAR(255),
+    object_workcountry VARCHAR(255),
+    object_workpostalcode VARCHAR(255),
+    object_companyaddress VARCHAR(255),
     object_homephone VARCHAR(25),
     object_workphone VARCHAR(25),
     object_cellphone VARCHAR(25),
     object_fax VARCHAR(25),
+    object_businesscategory VARCHAR(255),
     object_title VARCHAR(255),
     object_company VARCHAR(255),
     object_notes TEXT,
     object_pgppublickey TEXT,
     object_smimepublickey TEXT,
     object_freebusyurl VARCHAR(255),
+    object_website VARCHAR(255),
+    object_department VARCHAR(255),
+    object_nickname VARCHAR(255),
+    object_office VARCHAR(255),
     
     PRIMARY KEY(object_id)
 );
