Index: branches/5.1.x/install/install_schema.sql
===================================================================
diff -u -N -r13809 -r13959
--- branches/5.1.x/install/install_schema.sql	(.../install_schema.sql)	(revision 13809)
+++ branches/5.1.x/install/install_schema.sql	(.../install_schema.sql)	(revision 13959)
@@ -171,7 +171,7 @@
   ReturnTotal decimal(20,4) NOT NULL DEFAULT '0.0000',
   CostTotal decimal(20,4) NOT NULL DEFAULT '0.0000',
   OriginalAmount decimal(20,4) NOT NULL DEFAULT '0.0000',
-  ShippingOption tinyint(4) DEFAULT NULL,
+  ShippingOption tinyint(4) NOT NULL DEFAULT '0',
   ShippingInfo text,
   CouponId int(11) DEFAULT NULL,
   CouponDiscount decimal(20,4) NOT NULL DEFAULT '0.0000',
@@ -301,11 +301,11 @@
   Modified int(10) unsigned DEFAULT NULL,
   Expire int(10) unsigned DEFAULT NULL,
   Hits double NOT NULL DEFAULT '0',
-  CachedRating varchar(10) NOT NULL default '0',
+  CachedRating varchar(10) NOT NULL DEFAULT '0',
   CachedVotesQty int(11) NOT NULL DEFAULT '0',
   CachedReviewsQty int(11) NOT NULL DEFAULT '0',
-  CreatedById int(11) NOT NULL DEFAULT '0',
-  ModifiedById int(11) NOT NULL DEFAULT '0',
+  CreatedById int(11) DEFAULT NULL,
+  ModifiedById int(11) DEFAULT NULL,
   Priority int(11) NOT NULL DEFAULT '0',
   `Status` tinyint(4) NOT NULL DEFAULT '2',
   EditorsPick tinyint(4) NOT NULL DEFAULT '0',
@@ -444,7 +444,7 @@
   IsPrimary tinyint(4) NOT NULL DEFAULT '0',
   Priority smallint(6) NOT NULL DEFAULT '0',
   AddedOn int(11) DEFAULT NULL,
-  AddedById int(11) NOT NULL DEFAULT '0',
+  AddedById int(11) DEFAULT NULL,
   MIMEType varchar(255) NOT NULL DEFAULT '',
   PRIMARY KEY (FileId),
   KEY ProductId (ProductId),
