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';
