Changeset View
Changeset View
Standalone View
Standalone View
core/install/upgrades.sql
| Show First 20 Lines • Show All 3033 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"; | |||||