CRM/Upgrade/Incremental/sql/5.4.alpha1.mysql.tpl

   1 {* file to handle db changes in 5.4.alpha1 during upgrade *}
   2
   3 {*
   4 v4.7.20 updated these colums so that new installs would default to TIMESTAMP instead of DATETIME.
   5 Status-checks and DoctorWhen have been encouraging a transition, but it wasn't mandated, and there
   6 was little urgency... because `expired_date` was ignored, and adhoc TTLs on `created_date` had
   7 generally long windows. Now that we're using `expired_date` in more important ways for 5.4,
   8 we want to ensure that these values are handled precisely and consistently.
   9 *}
  10
  11 ALTER TABLE civicrm_cache
  12   CHANGE created_date created_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP COMMENT 'When was the cache item created',
  13   CHANGE expired_date expired_date  TIMESTAMP NULL DEFAULT NULL COMMENT 'When should the cache item expire';