Index: branches/5.0.x/core/install/upgrades.sql =================================================================== diff -u -r12587 -r12591 --- branches/5.0.x/core/install/upgrades.sql (.../upgrades.sql) (revision 12587) +++ branches/5.0.x/core/install/upgrades.sql (.../upgrades.sql) (revision 12591) @@ -1141,9 +1141,8 @@ UPDATE Permissions SET Permission = REPLACE(Permission, 'proj-base:', 'in-portal:'); ALTER TABLE CategoryItems ADD INDEX (ItemResourceId); -ALTER TABLE CategoryItems - DROP INDEX Filename, - ADD INDEX Filename(Filename); +ALTER TABLE CategoryItems DROP INDEX Filename; +ALTER TABLE CategoryItems ADD INDEX Filename(Filename); DROP TABLE Pages; DELETE FROM PermissionConfig WHERE PermissionName LIKE 'PAGE.%'; @@ -1495,4 +1494,15 @@ INSERT INTO Permissions VALUES (DEFAULT, 'in-portal:service.edit', 11, 1, 1, 0); +UPDATE Phrase SET Phrase = 'la_col_Rating' WHERE Phrase = 'la_col_rating'; +UPDATE Phrase SET Phrase = 'la_text_Review' WHERE Phrase = 'la_text_review'; +UPDATE Phrase SET Phrase = 'la_title_Reviews' WHERE Phrase = 'la_title_reviews'; +UPDATE Phrase SET Phrase = 'la_ToolTip_cancel' WHERE Phrase = 'la_tooltip_cancel'; + +ALTER TABLE Phrase + ADD PhraseKey VARCHAR(255) NOT NULL AFTER Phrase, + ADD INDEX (PhraseKey); + +UPDATE Phrase SET PhraseKey = UPPER(Phrase); + UPDATE Modules SET Loaded = 1 WHERE `Name` = 'In-Portal'; \ No newline at end of file