ALTER TABLE ItemReview ADD Rating TINYINT UNSIGNED AFTER ReviewText; 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); UPDATE Modules SET Version = '4.2.0' WHERE Name = 'Core'; UPDATE Modules SET Version = '4.2.0' WHERE Name = 'In-Portal';