Differential D9 Diff 205 branches/5.2.x/core/install/upgrades.sql

Changeset View

Standalone View

	Show First 20 Lines • Show All 2919 Lines • ▼ Show 20 Line(s)
	WHERE PhraseKey = 'LA_ERR_VALUE_OUT_OF_RANGE';			WHERE PhraseKey = 'LA_ERR_VALUE_OUT_OF_RANGE';

	UPDATE LanguageLabels			UPDATE LanguageLabels
	SET l1_Translation = 'Field value length is out of range, possible value length from {min_length} to {max_length}'			SET l1_Translation = 'Field value length is out of range, possible value length from {min_length} to {max_length}'
	WHERE PhraseKey = 'LA_ERR_LENGTH_OUT_OF_RANGE';			WHERE PhraseKey = 'LA_ERR_LENGTH_OUT_OF_RANGE';

	ALTER TABLE Themes ADD StylesheetFile VARCHAR( 255 ) NOT NULL DEFAULT '';			ALTER TABLE Themes ADD StylesheetFile VARCHAR( 255 ) NOT NULL DEFAULT '';
	UPDATE Themes SET StylesheetFile = 'platform/inc/styles.css' WHERE `Name` = 'advanced';			UPDATE Themes SET StylesheetFile = 'platform/inc/styles.css' WHERE `Name` = 'advanced';

				UPDATE EmailTemplates
				SET l1_Subject = REPLACE(l1_Subject, "Field name='Username'", 'UserTitle'), l1_HtmlBody = REPLACE(l1_HtmlBody, "Field name='Username'", 'UserTitle')
				WHERE TemplateName LIKE 'USER%';
				UPDATE EmailTemplates
				SET l1_Subject = REPLACE(l1_Subject, 'Field name="Username"', 'UserTitle'), l1_HtmlBody = REPLACE(l1_HtmlBody, 'Field name="Username"', 'UserTitle')
				WHERE TemplateName LIKE 'USER%';