Differential D289 Diff 713 core/install/upgrades.sql

Changeset View

Standalone View

core/install/upgrades.sql

	Show First 20 Lines • Show All 2929 Lines • ▼ Show 20 Line(s)
	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;			ALTER TABLE Semaphores ADD MainIDs INT NULL DEFAULT NULL AFTER MainPrefix;

				UPDATE EmailTemplates
				SET l1_HtmlBody = REPLACE(l1_HtmlBody, 'your In-portal account', 'your account')
				WHERE TemplateName = 'USER.PSWDC';

				UPDATE EmailTemplates
				SET l1_HtmlBody = REPLACE(l1_HtmlBody, 'If you would like to proceed and change the password', 'If you would like to proceed with the change of your old password')
				WHERE TemplateName = 'USER.PSWDC';

				UPDATE EmailTemplates
				SET l1_HtmlBody = REPLACE(l1_HtmlBody, 'You will receive a second email with your new password shortly.', 'Once clicked, you''ll be taken to taken to the page where you can set your new password.')
				WHERE TemplateName = 'USER.PSWDC';

				UPDATE EmailTemplates
				SET l1_HtmlBody = REPLACE(l1_HtmlBody, 'Your password will not be changed unless you have clicked on the above link.', 'Your password will not be changed unless you successfully change it by following the above link.')
				WHERE TemplateName = 'USER.PSWDC';

				UPDATE LanguageLabels
				SET l1_Translation = 'Enter your Username or Email below to continue with resetting your password.'
				WHERE PhraseKey = 'LU_ENTERFORGOTUSEREMAIL';

				UPDATE LanguageLabels
				SET l1_Translation = REPLACE(l1_Translation, 'Please follow the link in the email in order to receive a new password.', 'Please follow the link in that email to set your new password.')
				WHERE PhraseKey = 'LU_TEXT_FORGOTPASSRESETEMAILSENT';

				UPDATE LanguageLabels
				SET l1_Translation = 'Your password has been successfully changed.'
				WHERE PhraseKey = 'LU_TEXT_FORGOTPASSHASBEENRESET';