Differential D168 Diff 467 branches/5.3.x/core/install/upgrades.sql

Changeset View

Standalone View

	Show First 20 Lines • Show All 3027 Lines • ▼ Show 20 Line(s)
	WHERE `Name` IN ('Core', 'In-Portal');			WHERE `Name` IN ('Core', 'In-Portal');

	UPDATE EmailTemplates			UPDATE EmailTemplates
	SET			SET
	l1_Subject = REPLACE(l1_Subject, '<inp2:u_', '<inp2:'),			l1_Subject = REPLACE(l1_Subject, '<inp2:u_', '<inp2:'),
	l1_HtmlBody = REPLACE(l1_HtmlBody, '<inp2:u_', '<inp2:'),			l1_HtmlBody = REPLACE(l1_HtmlBody, '<inp2:u_', '<inp2:'),
	l1_PlainTextBody = REPLACE(l1_PlainTextBody, '<inp2:u_', '<inp2:')			l1_PlainTextBody = REPLACE(l1_PlainTextBody, '<inp2:u_', '<inp2:')
	WHERE TemplateName LIKE 'USER.MEMBERSHIP%';			WHERE TemplateName LIKE 'USER.MEMBERSHIP%';

				ALTER TABLE SiteDomains
				ADD `Status` TINYINT NOT NULL DEFAULT '1' AFTER Priority,
				ADD INDEX (`Status`);