Differential D121 Diff 345 branches/5.2.x/core/install/upgrades.sql

Changeset View

Standalone View

	Show First 20 Lines • Show All 2926 Lines • ▼ Show 20 Line(s)
	UPDATE Themes SET StylesheetFile = 'platform/inc/styles.css' WHERE `Name` = 'advanced';			UPDATE Themes SET StylesheetFile = 'platform/inc/styles.css' WHERE `Name` = 'advanced';

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

				UPDATE SystemSettings SET VariableValue = 1 WHERE VariableName = 'CSVExportEncoding';