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` );