Index: branches/5.2.x/install/upgrades.sql =================================================================== diff -u -N -r15213 -r15244 --- branches/5.2.x/install/upgrades.sql (.../upgrades.sql) (revision 15213) +++ branches/5.2.x/install/upgrades.sql (.../upgrades.sql) (revision 15244) @@ -265,3 +265,12 @@ SET main_table.CachedReviewsQty = (SELECT COUNT(*) FROM <%TABLE_PREFIX%>CatalogReviews review_table WHERE review_table.ItemId = main_table.ResourceId); # ===== v 5.2.0-B3 ===== +ALTER TABLE OrderItems CHANGE OptionsSalt OptionsSalt BIGINT(11) NULL DEFAULT '0'; +UPDATE OrderItems +SET OptionsSalt = CAST((OptionsSalt & 0xFFFFFFFF) AS UNSIGNED INTEGER) +WHERE OptionsSalt < 0; + +ALTER TABLE ProductOptionCombinations CHANGE CombinationCRC CombinationCRC BIGINT(11) NOT NULL DEFAULT '0'; +UPDATE ProductOptionCombinations +SET CombinationCRC = CAST((CombinationCRC & 0xFFFFFFFF) AS UNSIGNED INTEGER) +WHERE CombinationCRC < 0;