Index: branches/5.2.x/core/install/install_schema.sql
===================================================================
diff -u -r15033 -r15105
--- branches/5.2.x/core/install/install_schema.sql	(.../install_schema.sql)	(revision 15033)
+++ branches/5.2.x/core/install/install_schema.sql	(.../install_schema.sql)	(revision 15105)
@@ -244,7 +244,7 @@
 
 CREATE TABLE Users (
   PortalUserId int(11) NOT NULL AUTO_INCREMENT,
-  Username varchar(255) NOT NULL,
+  Username varchar(255) NOT NULL DEFAULT '',
   `Password` varchar(255) DEFAULT 'd41d8cd98f00b204e9800998ecf8427e',
   FirstName varchar(255) NOT NULL DEFAULT '',
   LastName varchar(255) NOT NULL DEFAULT '',
@@ -266,9 +266,9 @@
   Modified int(11) DEFAULT NULL,
   dob int(11) DEFAULT NULL,
   TimeZone varchar(255) NOT NULL DEFAULT '',
-  IPAddress varchar(15) NOT NULL,
+  IPAddress varchar(15) NOT NULL DEFAULT '',
   IsBanned tinyint(1) NOT NULL DEFAULT '0',
-  PwResetConfirm varchar(255) NOT NULL,
+  PwResetConfirm varchar(255) NOT NULL DEFAULT '',
   PwRequestTime int(11) unsigned DEFAULT NULL,
   FrontLanguage int(11) DEFAULT NULL,
   AdminLanguage int(11) DEFAULT NULL,
@@ -360,7 +360,7 @@
   IpAddress varchar(20) NOT NULL DEFAULT '0.0.0.0',
   `Status` int(11) NOT NULL DEFAULT '1',
   GroupList varchar(255) DEFAULT NULL,
-  TimeZone varchar(255) NOT NULL,
+  TimeZone varchar(255) NOT NULL DEFAULT '',
   BrowserSignature varchar(32) NOT NULL DEFAULT '',
   PRIMARY KEY (SessionKey),
   KEY UserId (PortalUserId),
@@ -393,11 +393,11 @@
   CountryStateId int(11) NOT NULL AUTO_INCREMENT,
   `Type` int(11) NOT NULL DEFAULT '1',
   StateCountryId int(11) DEFAULT NULL,
-  l1_Name varchar(255) NOT NULL,
-  l2_Name varchar(255) NOT NULL,
-  l3_Name varchar(255) NOT NULL,
-  l4_Name varchar(255) NOT NULL,
-  l5_Name varchar(255) NOT NULL,
+  l1_Name varchar(255) NOT NULL DEFAULT '',
+  l2_Name varchar(255) NOT NULL DEFAULT '',
+  l3_Name varchar(255) NOT NULL DEFAULT '',
+  l4_Name varchar(255) NOT NULL DEFAULT '',
+  l5_Name varchar(255) NOT NULL DEFAULT '',
   IsoCode char(3) NOT NULL DEFAULT '',
   ShortIsoCode char(2) DEFAULT NULL,
   PRIMARY KEY (CountryStateId),
@@ -479,7 +479,7 @@
   PageExpiration int(11) DEFAULT NULL,
   LiveRevisionNumber int(11) NOT NULL DEFAULT '1',
   DirectLinkEnabled tinyint(4) NOT NULL DEFAULT '1',
-  DirectLinkAuthKey varchar(20) NOT NULL,
+  DirectLinkAuthKey varchar(20) NOT NULL DEFAULT '',
   PromoBlockGroupId int(10) unsigned NOT NULL DEFAULT '0',
   RequireSSL tinyint(4) NOT NULL DEFAULT '0',
   RequireLogin tinyint(4) NOT NULL DEFAULT '0',
@@ -683,7 +683,7 @@
   RunTime int(10) unsigned NOT NULL DEFAULT '0',
   Timeout int(10) unsigned DEFAULT NULL,
   LastTimeoutOn int(10) unsigned DEFAULT NULL,
-  SiteDomainLimitation varchar(255) NOT NULL,
+  SiteDomainLimitation varchar(255) NOT NULL DEFAULT '',
   PRIMARY KEY (ScheduledTaskId),
   KEY `Status` (`Status`),
   KEY RunInterval (RunInterval),
@@ -823,9 +823,9 @@
 
 CREATE TABLE ItemFilters (
   FilterId int(11) NOT NULL AUTO_INCREMENT,
-  ItemPrefix varchar(255) NOT NULL,
-  FilterField varchar(255) NOT NULL,
-  FilterType varchar(100) NOT NULL,
+  ItemPrefix varchar(255) NOT NULL DEFAULT '',
+  FilterField varchar(255) NOT NULL DEFAULT '',
+  FilterType varchar(100) NOT NULL DEFAULT '',
   Enabled tinyint(4) NOT NULL DEFAULT '1',
   RangeCount int(11) DEFAULT NULL,
   PRIMARY KEY (FilterId),
@@ -835,7 +835,7 @@
 
 CREATE TABLE SpamReports (
   ReportId int(11) NOT NULL AUTO_INCREMENT,
-  ItemPrefix varchar(255) NOT NULL,
+  ItemPrefix varchar(255) NOT NULL DEFAULT '',
   ItemId int(11) NOT NULL,
   MessageText text,
   ReportedOn int(11) DEFAULT NULL,
@@ -1210,7 +1210,7 @@
   DomainId int(11) NOT NULL DEFAULT '0',
   `Hash` int(11) NOT NULL DEFAULT '0',
   Prefixes varchar(255) NOT NULL DEFAULT '',
-  ParsedVars text NOT NULL,
+  ParsedVars text,
   Cached int(10) unsigned DEFAULT NULL,
   LifeTime int(11) NOT NULL DEFAULT '-1',
   PRIMARY KEY (UrlId),
@@ -1257,9 +1257,9 @@
 
 CREATE TABLE CurlLog (
   LogId int(11) NOT NULL AUTO_INCREMENT,
-  Message varchar(255) NOT NULL,
-  PageUrl varchar(255) NOT NULL,
-  RequestUrl varchar(255) NOT NULL,
+  Message varchar(255) NOT NULL DEFAULT '',
+  PageUrl varchar(255) NOT NULL DEFAULT '',
+  RequestUrl varchar(255) NOT NULL DEFAULT '',
   PortalUserId int(11) NOT NULL,
   SessionKey int(11) NOT NULL,
   IsAdmin tinyint(4) NOT NULL,
@@ -1269,7 +1269,7 @@
   RequestDate int(11) DEFAULT NULL,
   ResponseDate int(11) DEFAULT NULL,
   ResponseHttpCode int(11) NOT NULL,
-  CurlError varchar(255) NOT NULL,
+  CurlError varchar(255) NOT NULL DEFAULT '',
   PRIMARY KEY (LogId),
   KEY Message (Message),
   KEY PageUrl (PageUrl),
