Index: branches/5.2.x/core/install/upgrades.sql
===================================================================
diff -u -r14472 -r14474
--- branches/5.2.x/core/install/upgrades.sql	(.../upgrades.sql)	(revision 14472)
+++ branches/5.2.x/core/install/upgrades.sql	(.../upgrades.sql)	(revision 14474)
@@ -2039,4 +2039,12 @@
 	DROP PassResetTime,
 	CHANGE PwResetConfirm PwResetConfirm VARCHAR(255) NOT NULL;
 
-UPDATE PortalUser SET PwRequestTime = NULL WHERE PwRequestTime = 0;
\ No newline at end of file
+UPDATE PortalUser SET PwRequestTime = NULL WHERE PwRequestTime = 0;
+
+ALTER TABLE Category
+	ADD DirectLinkEnabled TINYINT NOT NULL DEFAULT '1',
+	ADD DirectLinkAuthKey VARCHAR(20) NOT NULL;
+
+UPDATE Category
+SET DirectLinkAuthKey = SUBSTRING( MD5( CONCAT(CategoryId, ':', ParentId, ':', l<%PRIMARY_LANGUAGE%>_Name, ':b38') ), 1, 20)
+WHERE DirectLinkAuthKey = '';
\ No newline at end of file
