Index: branches/5.1.x/core/install/install_schema.sql
===================================================================
diff -u -N -r13962 -r14029
--- branches/5.1.x/core/install/install_schema.sql	(.../install_schema.sql)	(revision 13962)
+++ branches/5.1.x/core/install/install_schema.sql	(.../install_schema.sql)	(revision 14029)
@@ -244,20 +244,20 @@
   Company varchar(255) NOT NULL DEFAULT '',
   Email varchar(255) NOT NULL DEFAULT '',
   CreatedOn int(11) DEFAULT NULL,
-  Phone varchar(20) DEFAULT NULL,
+  Phone varchar(255) NOT NULL DEFAULT '',
   Fax varchar(255) NOT NULL DEFAULT '',
-  Street varchar(255) DEFAULT NULL,
+  Street varchar(255) NOT NULL DEFAULT '',
   Street2 varchar(255) NOT NULL DEFAULT '',
-  City varchar(20) DEFAULT NULL,
+  City varchar(255) NOT NULL DEFAULT '',
   State varchar(20) NOT NULL DEFAULT '',
-  Zip varchar(20) DEFAULT NULL,
+  Zip varchar(20) NOT NULL DEFAULT '',
   Country varchar(20) NOT NULL DEFAULT '',
   ResourceId int(11) NOT NULL DEFAULT '0',
   `Status` tinyint(4) NOT NULL DEFAULT '1',
   Modified int(11) DEFAULT NULL,
   dob int(11) DEFAULT NULL,
   tz int(11) DEFAULT NULL,
-  ip varchar(20) DEFAULT NULL,
+  ip varchar(20) NOT NULL DEFAULT '',
   IsBanned tinyint(1) NOT NULL DEFAULT '0',
   PassResetTime int(11) unsigned DEFAULT NULL,
   PwResetConfirm varchar(255) DEFAULT NULL,