Changeset View

Standalone View

	Show First 20 Lines • Show All 2928 Lines • ▼ Show 20 Line(s)
	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';			UPDATE SystemSettings SET VariableValue = 1 WHERE VariableName = 'CSVExportEncoding';
				ALTER TABLE Semaphores ADD MainIDs INT NULL DEFAULT NULL AFTER MainPrefix;