Index: trunk/core/install/install_schema.sql
===================================================================
diff -u -N -r8397 -r8556
--- trunk/core/install/install_schema.sql	(.../install_schema.sql)	(revision 8397)
+++ trunk/core/install/install_schema.sql	(.../install_schema.sql)	(revision 8556)
@@ -350,6 +350,8 @@
   CreatedById int(11) NOT NULL default '0',
   ResourceId int(11) default NULL,
   ParentPath TEXT NULL DEFAULT NULL,
+  TreeLeft bigint(20) NOT NULL default '0',
+  TreeRight bigint(20) NOT NULL default '0',
   NamedParentPath TEXT NULL DEFAULT NULL,
   MetaDescription varchar(255) default NULL,
   HotItem int(11) NOT NULL default '2',
@@ -375,7 +377,9 @@
   KEY l2_Description (l2_Description(5)),
   KEY l3_Description (l3_Description(5)),
   KEY l4_Description (l4_Description(5)),
-  KEY l5_Description (l5_Description(5))
+  KEY l5_Description (l5_Description(5)),
+  KEY TreeLeft (TreeLeft),
+  KEY TreeRight (TreeRight)
 );
 
 CREATE TABLE CategoryCustomData (
Index: trunk/core/install/upgrades.sql
===================================================================
diff -u -N -r8555 -r8556
--- trunk/core/install/upgrades.sql	(.../upgrades.sql)	(revision 8555)
+++ trunk/core/install/upgrades.sql	(.../upgrades.sql)	(revision 8556)
@@ -105,10 +105,10 @@
 
 ALTER TABLE Events ADD ReplacementTags TEXT AFTER Event;
 
-
-# ====== v 4.2.0 ====
+# ===== v 4.2.0 ====
 ALTER TABLE Category ADD `TreeLeft` BIGINT NOT NULL AFTER `ParentPath` ,
 ADD `TreeRight` BIGINT NOT NULL AFTER `TreeLeft` ;
 
-ALTER TABLE Category ADD INDEX ( `TreeLeft` , `TreeRight` ) ;
+ALTER TABLE Category ADD INDEX ( `TreeLeft` );
+ALTER TABLE Category ADD INDEX ( `TreeRight` );