Index: branches/5.2.x/core/install/upgrades.sql =================================================================== diff -u -N -r14981 -r14994 --- branches/5.2.x/core/install/upgrades.sql (.../upgrades.sql) (revision 14981) +++ branches/5.2.x/core/install/upgrades.sql (.../upgrades.sql) (revision 14994) @@ -2525,3 +2525,10 @@ ADD RequireLogin TINYINT NOT NULL DEFAULT '0'; INSERT INTO ConfigurationValues VALUES(DEFAULT, 'UpdateCountersOnFilterChange', '1', 'In-Portal', 'in-portal:configure_categories', 'la_title_General', 'la_config_UpdateCountersOnFilterChange', 'checkbox', '', '', 10.15, 0, 0, NULL); + +ALTER TABLE UserSession CHANGE `tz` `TimeZone` VARCHAR(255) NOT NULL; +ALTER TABLE PortalUser CHANGE `tz` `TimeZone` VARCHAR(255) NOT NULL DEFAULT ''; + +UPDATE SearchConfig +SET FieldName = 'TimeZone' +WHERE FieldName = 'tz' AND TableName = 'PortalUser';