Index: trunk/admin/install/upgrades/inportal_upgrade_v4.2.0.sql =================================================================== diff -u --- trunk/admin/install/upgrades/inportal_upgrade_v4.2.0.sql (revision 0) +++ trunk/admin/install/upgrades/inportal_upgrade_v4.2.0.sql (revision 8560) @@ -0,0 +1,10 @@ +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'; Fisheye: Tag 8560 refers to a dead (removed) revision in file `trunk/admin/install/upgrades/inportal_upgrade_v4.1.1.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: trunk/core/install/upgrades.sql =================================================================== diff -u -r8557 -r8560 --- trunk/core/install/upgrades.sql (.../upgrades.sql) (revision 8557) +++ trunk/core/install/upgrades.sql (.../upgrades.sql) (revision 8560) @@ -105,10 +105,10 @@ ALTER TABLE Events ADD ReplacementTags TEXT AFTER Event; -# ===== v 4.2.0 ==== +# ===== v 4.2.0 ===== ALTER TABLE CustomField ADD MultiLingual TINYINT UNSIGNED NOT NULL DEFAULT '1' AFTER FieldLabel; ALTER TABLE Category - ADD TreeLeft BIGINT NOT NULL AFTER ParentPath , + ADD TreeLeft BIGINT NOT NULL AFTER ParentPath, ADD TreeRight BIGINT NOT NULL AFTER TreeLeft; ALTER TABLE Category ADD INDEX (TreeLeft); Fisheye: Tag 8560 refers to a dead (removed) revision in file `trunk/admin/install/upgrades/changelog_.txt'. Fisheye: No comparison available. Pass `N' to diff? Index: trunk/admin/install/inportal_data.sql =================================================================== diff -u -r8397 -r8560 --- trunk/admin/install/inportal_data.sql (.../inportal_data.sql) (revision 8397) +++ trunk/admin/install/inportal_data.sql (.../inportal_data.sql) (revision 8560) @@ -225,4 +225,4 @@ INSERT INTO Stylesheets VALUES (8, 'Default', 'In-Portal Default Theme', '', 1124952555, 1); -INSERT INTO Modules VALUES ('In-Portal', 'kernel/', 'm', '4.1.0', 1, 0, '', 0, '1054738405'); +INSERT INTO Modules VALUES ('In-Portal', 'kernel/', 'm', '4.2.0', 1, 0, '', 0, '1054738405');