Index: trunk/core/install/upgrades.sql =================================================================== diff -u -r8556 -r8557 --- trunk/core/install/upgrades.sql (.../upgrades.sql) (revision 8556) +++ trunk/core/install/upgrades.sql (.../upgrades.sql) (revision 8557) @@ -106,9 +106,10 @@ ALTER TABLE Events ADD ReplacementTags TEXT AFTER Event; # ===== v 4.2.0 ==== -ALTER TABLE Category ADD `TreeLeft` BIGINT NOT NULL AFTER `ParentPath` , -ADD `TreeRight` BIGINT NOT NULL AFTER `TreeLeft` ; +ALTER TABLE CustomField ADD MultiLingual TINYINT UNSIGNED NOT NULL DEFAULT '1' AFTER FieldLabel; +ALTER TABLE Category + ADD TreeLeft BIGINT NOT NULL AFTER ParentPath , + ADD TreeRight BIGINT NOT NULL AFTER TreeLeft; -ALTER TABLE Category ADD INDEX ( `TreeLeft` ); -ALTER TABLE Category ADD INDEX ( `TreeRight` ); - +ALTER TABLE Category ADD INDEX (TreeLeft); +ALTER TABLE Category ADD INDEX (TreeRight);