Index: branches/5.0.x/in-commerce/install/upgrades.sql
===================================================================
diff -u -r12674 -r12699
--- branches/5.0.x/in-commerce/install/upgrades.sql	(.../upgrades.sql)	(revision 12674)
+++ branches/5.0.x/in-commerce/install/upgrades.sql	(.../upgrades.sql)	(revision 12699)
@@ -57,4 +57,60 @@
 
 UPDATE Events SET Type = 1 WHERE Event = 'BACKORDER.FULLFILL';
 
-UPDATE ConfigurationAdmin SET ValueList = 'style="width: 50px;"' WHERE VariableName IN ('product_RatingDelay_Value', 'product_ReviewDelay_Value');
\ No newline at end of file
+UPDATE ConfigurationAdmin SET ValueList = 'style="width: 50px;"' WHERE VariableName IN ('product_RatingDelay_Value', 'product_ReviewDelay_Value');
+
+# ===== v 5.0.2 =====
+ALTER TABLE AffiliatePayments
+	CHANGE Comment Comment text NULL,
+	CHANGE PaymentDate PaymentDate INT(10) UNSIGNED NULL DEFAULT NULL;
+
+ALTER TABLE AffiliatePaymentTypes CHANGE Description Description text NULL;
+
+ALTER TABLE Affiliates
+	CHANGE Comments Comments text NULL,
+	CHANGE CreatedOn CreatedOn INT(11) NULL DEFAULT NULL;
+
+ALTER TABLE Manufacturers CHANGE Description Description text NULL;
+
+ALTER TABLE Orders
+	CHANGE UserComment UserComment text NULL,
+	CHANGE AdminComment AdminComment text NULL,
+	CHANGE GWResult1 GWResult1 MEDIUMTEXT NULL,
+	CHANGE GWResult2 GWResult2 MEDIUMTEXT NULL,
+	CHANGE OrderDate OrderDate INT(10) UNSIGNED NULL DEFAULT NULL,
+	CHANGE PaymentExpires PaymentExpires INT(10) UNSIGNED NULL DEFAULT NULL;
+
+ALTER TABLE PaymentTypes CHANGE PortalGroups PortalGroups text NULL;
+ALTER TABLE ProductOptionCombinations CHANGE Combination Combination text NULL;
+
+ALTER TABLE Products
+	CHANGE ShippingLimitation ShippingLimitation text NULL,
+	CHANGE PackageContent PackageContent MEDIUMTEXT NULL;
+
+ALTER TABLE ShippingQuoteEngines CHANGE Properties Properties text NULL;
+ALTER TABLE ShippingType CHANGE PortalGroups PortalGroups text NULL;
+
+ALTER TABLE ProductFiles
+	CHANGE ProductId ProductId INT(11) NOT NULL DEFAULT '0',
+	CHANGE `Name` `Name` VARCHAR(255) NOT NULL DEFAULT '',
+	CHANGE Version Version VARCHAR(100) NOT NULL DEFAULT '',
+	CHANGE FilePath FilePath VARCHAR(255) NOT NULL DEFAULT '',
+	CHANGE RealPath RealPath VARCHAR(255) NOT NULL DEFAULT '',
+	CHANGE Size Size INT(11) NOT NULL DEFAULT '0',
+	CHANGE AddedOn AddedOn INT(11) NULL DEFAULT NULL;
+
+ALTER TABLE UserFileAccess
+	CHANGE ProductId ProductId INT( 11 ) NOT NULL DEFAULT '0',
+	CHANGE PortalUserId PortalUserId INT( 11 ) NOT NULL DEFAULT '0';
+
+ALTER TABLE GatewayConfigFields CHANGE ValueList ValueList MEDIUMTEXT NULL;
+
+ALTER TABLE Currencies
+	CHANGE `Status` `Status` SMALLINT(6) NOT NULL DEFAULT '1',
+	CHANGE Modified Modified INT(11) NULL DEFAULT NULL;
+
+ALTER TABLE GiftCertificates CHANGE `Status` `Status` TINYINT(1) NOT NULL DEFAULT '2';
+
+ALTER TABLE UserDownloads
+	CHANGE StartedOn StartedOn INT(11) NULL DEFAULT NULL,
+	CHANGE EndedOn EndedOn INT(11) NULL DEFAULT NULL;
\ No newline at end of file
