Differential D237 Diff 634 branches/5.2.x/core/install/upgrades.sql

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;
				alexAuthorUnsubmitted Done Reply Discovered bug (after release), that "MainIDs" column during In-Portal 5.2.2-B1 upgrade is created as "INT" instead of "TEXT". alex: Discovered bug (after release), that "MainIDs" column during In-Portal 5.2.2-B1 upgrade is…