Index: branches/5.2.x/core/install/upgrades.sql =================================================================== diff -u -N -r15433 -r15436 --- branches/5.2.x/core/install/upgrades.sql (.../upgrades.sql) (revision 15433) +++ branches/5.2.x/core/install/upgrades.sql (.../upgrades.sql) (revision 15436) @@ -2763,3 +2763,12 @@ ALTER TABLE ScheduledTasks ADD RunSchedule VARCHAR(255) NOT NULL DEFAULT '* * * * *' AFTER Event; DELETE FROM UserPersistentSessionData WHERE VariableName = 'scheduled-task[Default]columns_.'; DELETE FROM LanguageLabels WHERE PhraseKey = 'LA_FLD_RUNINTERVAL'; + +ALTER TABLE Languages + ADD ShortDateFormat VARCHAR(255) NOT NULL DEFAULT 'm/d' AFTER DateFormat, + ADD ShortTimeFormat VARCHAR(255) NOT NULL DEFAULT 'g:i A' AFTER TimeFormat; + +UPDATE Languages +SET + ShortDateFormat = REPLACE(REPLACE(DateFormat, '/Y', ''), '/y', ''), + ShortTimeFormat = REPLACE(TimeFormat, ':s', '');