Index: branches/5.0.x/core/install/upgrades.php
===================================================================
diff -u -N -r12809 -r12877
--- branches/5.0.x/core/install/upgrades.php	(.../upgrades.php)	(revision 12809)
+++ branches/5.0.x/core/install/upgrades.php	(.../upgrades.php)	(revision 12877)
@@ -1,6 +1,6 @@
 <?php
 /**
-* @version	$Id: upgrades.php 12809 2009-10-27 17:49:44Z alex $
+* @version	$Id: upgrades.php 12877 2009-11-03 20:10:32Z alex $
 * @package	In-Portal
 * @copyright	Copyright (C) 1997 - 2009 Intechnic. All rights reserved.
 * @license      GNU/GPL
@@ -1197,22 +1197,48 @@
 		}
 
 		/**
-		 * Update to 5.0.2-B2
+		 * Update to 5.0.2-B2; Transforms IsIndex field values to SymLinkCategoryId field
 		 *
 		 * @param string $mode when called mode {before, after)
 		 */
 		function Upgrade_5_0_2_B2($mode)
 		{
+			// 0 - Regular, 1 - Category Index, 2 - Container
+
 			if ($mode == 'before') {
+				// fix "Content" category
 				$fields_hash = Array (
 					'CreatedById' => -1, // root
 					'CreatedOn' => time(),
 					'ResourceId' => $this->Application->NextResourceId(),
 				);
 
 				$category_id = $this->Application->findModule('Name', 'Core', 'RootCat');
-
 				$this->Conn->doUpdate($fields_hash, TABLE_PREFIX . 'Category', 'CategoryId = ' . $category_id);
+
+				// get all categories, marked as category index
+				$sql = 'SELECT ParentPath, CategoryId
+						FROM ' . TABLE_PREFIX . 'Category
+						WHERE IsIndex = 1';
+				$category_indexes = $this->Conn->GetCol($sql, 'CategoryId');
+
+				foreach ($category_indexes as $category_id => $parent_path) {
+					$parent_path = explode('|', substr($parent_path, 1, -1));
+
+					// set symlink to $category_id for each category, marked as container in given category path
+					$sql = 'SELECT CategoryId
+							FROM ' . TABLE_PREFIX . 'Category
+							WHERE CategoryId IN (' . implode(',', $parent_path) . ') AND (IsIndex = 2)';
+					$category_containers = $this->Conn->GetCol($sql);
+
+					if ($category_containers) {
+						$sql = 'UPDATE ' . TABLE_PREFIX . 'Category
+								SET SymLinkCategoryId = ' . $category_id . '
+								WHERE CategoryId IN (' . implode(',', $category_containers) . ')';
+						$this->Conn->Query($sql);
+					}
+
+				}
 			}
 
 			if ($mode == 'after') {