Index: branches/5.1.x/core/install/install_schema.sql
===================================================================
diff -u -r13951 -r13962
--- branches/5.1.x/core/install/install_schema.sql	(.../install_schema.sql)	(revision 13951)
+++ branches/5.1.x/core/install/install_schema.sql	(.../install_schema.sql)	(revision 13962)
@@ -115,7 +115,7 @@
   MessageType varchar(4) NOT NULL DEFAULT 'text',
   Enabled int(11) NOT NULL DEFAULT '1',
   FrontEndOnly tinyint(3) unsigned NOT NULL DEFAULT '0',
-  Module varchar(40) NOT NULL DEFAULT '',
+  Module varchar(40) NOT NULL DEFAULT 'Core',
   Description text,
   `Type` int(11) NOT NULL DEFAULT '0',
   PRIMARY KEY (EventId),
@@ -144,13 +144,13 @@
   Priority int(11) NOT NULL DEFAULT '0',
   IconURL varchar(255) DEFAULT NULL,
   IconDisabledURL varchar(255) DEFAULT NULL,
-  DateFormat varchar(50) NOT NULL DEFAULT '',
-  TimeFormat varchar(50) NOT NULL DEFAULT '',
+  DateFormat varchar(50) NOT NULL DEFAULT 'm/d/Y',
+  TimeFormat varchar(50) NOT NULL DEFAULT 'g:i:s A',
   InputDateFormat varchar(50) NOT NULL DEFAULT 'm/d/Y',
   InputTimeFormat varchar(50) NOT NULL DEFAULT 'g:i:s A',
-  DecimalPoint varchar(10) NOT NULL DEFAULT '',
+  DecimalPoint varchar(10) NOT NULL DEFAULT '.',
   ThousandSep varchar(10) NOT NULL DEFAULT '',
-  `Charset` varchar(20) NOT NULL DEFAULT '',
+  `Charset` varchar(20) NOT NULL DEFAULT 'utf-8',
   UnitSystem tinyint(4) NOT NULL DEFAULT '1',
   FilenameReplacements text,
   Locale varchar(10) NOT NULL DEFAULT 'en-US',
@@ -420,14 +420,14 @@
   `Status` tinyint(4) NOT NULL DEFAULT '1',
   Priority int(11) NOT NULL DEFAULT '0',
   MetaKeywords text,
-  CachedDescendantCatsQty int(11) DEFAULT NULL,
+  CachedDescendantCatsQty int(11) NOT NULL DEFAULT '0',
   CachedNavbar text,
   l1_CachedNavbar text,
   l2_CachedNavbar text,
   l3_CachedNavbar text,
   l4_CachedNavbar text,
   l5_CachedNavbar text,
-  CreatedById int(11) NOT NULL DEFAULT '0',
+  CreatedById int(11) DEFAULT NULL,
   ResourceId int(11) DEFAULT NULL,
   ParentPath text,
   TreeLeft bigint(20) NOT NULL DEFAULT '0',
@@ -438,7 +438,7 @@
   NewItem int(11) NOT NULL DEFAULT '2',
   PopItem int(11) NOT NULL DEFAULT '2',
   Modified int(11) DEFAULT NULL,
-  ModifiedById int(11) NOT NULL DEFAULT '0',
+  ModifiedById int(11) DEFAULT NULL,
   CachedTemplate varchar(255) NOT NULL DEFAULT '',
   Template varchar(255) NOT NULL DEFAULT '#inherit#',
   UseExternalUrl tinyint(3) unsigned NOT NULL DEFAULT '0',
@@ -792,10 +792,10 @@
   ReviewId int(11) NOT NULL AUTO_INCREMENT,
   CreatedOn int(10) unsigned DEFAULT NULL,
   ReviewText longtext,
-  Rating tinyint(3) unsigned DEFAULT NULL,
+  Rating tinyint(3) unsigned NOT NULL DEFAULT '0',
   IPAddress varchar(255) NOT NULL DEFAULT '',
   ItemId int(11) NOT NULL DEFAULT '0',
-  CreatedById int(11) NOT NULL DEFAULT '-1',
+  CreatedById int(11) DEFAULT NULL,
   ItemType tinyint(4) NOT NULL DEFAULT '0',
   Priority int(11) NOT NULL DEFAULT '0',
   `Status` tinyint(4) NOT NULL DEFAULT '2',
@@ -835,7 +835,7 @@
   Size int(11) NOT NULL DEFAULT '0',
   `Status` tinyint(4) NOT NULL DEFAULT '1',
   CreatedOn int(11) unsigned DEFAULT NULL,
-  CreatedById int(11) NOT NULL DEFAULT '-1',
+  CreatedById int(11) DEFAULT NULL,
   MimeType varchar(255) NOT NULL DEFAULT '',
   PRIMARY KEY (FileId),
   KEY ResourceId (ResourceId),
@@ -1151,7 +1151,7 @@
   DraftId int(11) NOT NULL AUTO_INCREMENT,
   FormSubmissionId int(10) unsigned NOT NULL DEFAULT '0',
   CreatedOn int(10) unsigned DEFAULT NULL,
-  CreatedById int(11) NOT NULL,
+  CreatedById int(11) DEFAULT NULL,
   Message text,
   PRIMARY KEY (DraftId),
   KEY FormSubmissionId (FormSubmissionId),
