Index: branches/5.2.x/core/install/upgrades.sql
===================================================================
diff -u -N -r15373 -r15390
--- branches/5.2.x/core/install/upgrades.sql	(.../upgrades.sql)	(revision 15373)
+++ branches/5.2.x/core/install/upgrades.sql	(.../upgrades.sql)	(revision 15390)
@@ -2750,3 +2750,9 @@
 UPDATE LanguageLabels SET l<%PRIMARY_LANGUAGE%>_Translation = '&lt;TITLE&gt; Tag' WHERE PhraseKey = 'LA_FLD_PAGECONTENTTITLE';
 ALTER TABLE EmailLog ADD EventType TINYINT(4) NULL AFTER EventName;
 DELETE FROM UserPersistentSessionData WHERE VariableName IN ('email-log[Default]columns_.', 'promo-block[Default]columns_.');
+
+ALTER TABLE Categories
+	ADD NamedParentPathHash INT UNSIGNED NOT NULL DEFAULT '0' AFTER NamedParentPath,
+	ADD CachedTemplateHash INT UNSIGNED NOT NULL DEFAULT '0' AFTER CachedTemplate,
+	ADD INDEX (NamedParentPathHash),
+	ADD INDEX (CachedTemplateHash);
