Index: branches/5.2.x/core/install/upgrades.sql
===================================================================
diff -u -N -r14730 -r14745
--- branches/5.2.x/core/install/upgrades.sql	(.../upgrades.sql)	(revision 14730)
+++ branches/5.2.x/core/install/upgrades.sql	(.../upgrades.sql)	(revision 14745)
@@ -2236,4 +2236,49 @@
 SET VariableValue = IF(VariableValue = 1, 0, 1)
 WHERE VariableName = 'RegistrationUsernameRequired';
 
-INSERT INTO ConfigurationValues VALUES (DEFAULT, 'PerformExactSearch', '1', 'In-Portal', 'in-portal:configure_advanced', 'la_section_SettingsWebsite', 'la_config_PerformExactSearch', 'checkbox', '', '', '10.10', 0, 0, 'la_hint_PerformExactSearch');
\ No newline at end of file
+INSERT INTO ConfigurationValues VALUES (DEFAULT, 'PerformExactSearch', '1', 'In-Portal', 'in-portal:configure_advanced', 'la_section_SettingsWebsite', 'la_config_PerformExactSearch', 'checkbox', '', '', '10.10', 0, 0, 'la_hint_PerformExactSearch');
+
+
+UPDATE Phrase
+SET PhraseType = 1
+WHERE PhraseKey IN (
+	'LA_USERS_SUBSCRIBER_GROUP', 'LA_PROMPT_DUPREVIEWS', 'LA_PROMPT_DUPREVIEWS', 'LA_PROMPT_DUPRATING',
+	'LA_PROMPT_OVERWRITEPHRASES', 'LA_TEXT_BACKUP_ACCESS', 'LA_PHRASETYPE_BOTH', 'LA_TOOLTIP_NEWLISTING'
+);
+
+UPDATE Phrase
+SET PhraseType = 0
+WHERE PhraseKey IN ('LU_TITLE_SHIPPINGINFORMATION', 'LU_COMM_LASTQUATER');
+
+UPDATE Phrase
+SET Phrase = REPLACE(Phrase, 'lu_', 'la_'), PhraseKey = UPPER(Phrase)
+WHERE PhraseKey IN ('LU_OPT_AUTODETECT', 'LU_OPT_COOKIES', 'LU_OPT_QUERYSTRING');
+
+UPDATE ConfigurationValues
+SET ValueList = REPLACE(ValueList, 'lu_', 'la_')
+WHERE VariableName = 'CookieSessions';
+
+DELETE FROM Phrase WHERE PhraseKey IN ('LU_INVALID_PASSWORD', 'LA_OF', 'LU_TITLE_REVIEWPRODUCT');
+
+UPDATE Phrase
+SET PhraseType = 2
+WHERE PhraseType = 1 AND (PhraseKey LIKE 'lu_field_%' OR PhraseKey = 'LA_TEXT_VALID');
+
+UPDATE Phrase
+SET Phrase = REPLACE(Phrase, 'la_', 'lc_'), PhraseKey = UPPER(Phrase)
+WHERE PhraseType = 2;
+
+UPDATE Phrase
+SET Phrase = REPLACE(Phrase, 'lu_', 'lc_'), PhraseKey = UPPER(Phrase)
+WHERE PhraseType = 2;
+
+UPDATE SearchConfig
+SET DisplayName = REPLACE(DisplayName, 'lu_', 'lc_')
+WHERE DisplayName IN (
+	'lu_field_newitem', 'lu_field_popitem', 'lu_field_hotitem', 'lu_field_resourceid', 'lu_field_createdbyid',
+	'lu_field_priority', 'lu_field_status', 'lu_field_createdon', 'lu_field_description', 'lu_field_name',
+	'lu_field_modified', 'lu_field_modifiedbyid', 'lu_field_ParentPath', 'lu_field_ParentId', 'lu_field_MetaKeywords',
+	'lu_field_MetaDescription', 'lu_field_EditorsPick', 'lu_field_CategoryId', 'lu_field_CachedNavBar',
+	'lu_field_CachedDescendantCatsQty', 'lu_field_hits', 'lu_field_cachedrating', 'lu_field_cachedvotesqty',
+	'lu_field_cachedreviewsqty', 'lu_field_orgid'
+);
