Differential D202 Diff 695 branches/5.3.x/core/install/upgrades.sql

Changeset View

Standalone View

branches/5.3.x/core/install/upgrades.sql

	Show First 20 Lines • Show All 3043 Lines • ▼ Show 20 Line(s)
	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			ALTER TABLE SiteDomains
	ADD `Status` TINYINT NOT NULL DEFAULT '1' AFTER Priority,			ADD `Status` TINYINT NOT NULL DEFAULT '1' AFTER Priority,
	ADD INDEX (`Status`);			ADD INDEX (`Status`);

	INSERT INTO SystemSettings VALUES(DEFAULT, 'SessionLogRotationInterval', '2629800', 'In-Portal', 'in-portal:configure_advanced', 'la_section_SettingsLogs', 'la_config_SessionLogRotationInterval', 'select', '', '86400=la_opt_OneDay\|\|604800=la_opt_OneWeek\|\|1209600=la_opt_TwoWeeks\|\|2629800=la_opt_OneMonth\|\|7889400=la_opt_ThreeMonths\|\|31557600=la_opt_OneYear\|\|63115200=la_opt_TwoYears\|\|94672800=la_opt_ThreeYears\|\|157788000=la_opt_FiveYears\|\|-1=la_opt_EmailLogKeepForever', 65.05, 0, 1, NULL);			INSERT INTO SystemSettings VALUES(DEFAULT, 'SessionLogRotationInterval', '2629800', 'In-Portal', 'in-portal:configure_advanced', 'la_section_SettingsLogs', 'la_config_SessionLogRotationInterval', 'select', '', '86400=la_opt_OneDay\|\|604800=la_opt_OneWeek\|\|1209600=la_opt_TwoWeeks\|\|2629800=la_opt_OneMonth\|\|7889400=la_opt_ThreeMonths\|\|31557600=la_opt_OneYear\|\|63115200=la_opt_TwoYears\|\|94672800=la_opt_ThreeYears\|\|157788000=la_opt_FiveYears\|\|-1=la_opt_EmailLogKeepForever', 65.05, 0, 1, NULL);

				UPDATE PromoBlocks SET ScheduleToDate = ScheduleToDate + 86399 WHERE DATE_FORMAT(FROM_UNIXTIME(ScheduleTodate), "%H%i") = "0000";
				DELETE FROM LanguageLabels WHERE PhraseKey = "LA_FLD_SCHEDULEDATE";