(dev/core#174) civicrm_cache - Mandate change from DATETIME to TIMESTAMP
authorTim Otten <totten@civicrm.org>
Wed, 27 Jun 2018 20:20:36 +0000 (13:20 -0700)
committerTim Otten <totten@civicrm.org>
Wed, 27 Jun 2018 20:20:36 +0000 (13:20 -0700)
commit6f63cf575da8b27a5a1d6d30e9a0c364f1a78cb0
tree41072b08e98dcc12f2d353e7bd51cd77a7ee81e7
parent5db1add4b0498ab927d14b210bd30f85272e188a
(dev/core#174) civicrm_cache - Mandate change from DATETIME to TIMESTAMP

v4.7.20 updated the definition of `created_date` and `expired_date` so that
new installs would default to TIMESTAMP instead of DATETIME.  Status-checks
and DoctorWhen have been encouraging a transition, but it wasn't mandated,
and there was little urgency...  because `expired_date` was ignored, and
adhoc TTLs on `created_date` had generally long windows.  Now that we're
using `expired_date` in more important ways for 5.4 (dev/core#174), we want
to ensure that these values are handled precisely and consistently.

Before
------------------------------
* On new deployments, `created_date` and `expired_date` are TIMESTAMP.
* On upgraded deployments, `created_date` and `expired_date` may
  be using DATETIME or TIMESTAMP (depending on the particular history
  and administrative decisions).

After
------------------------------
* On all deployments, `created_date` and `expired_date` are TIMESTAMP.
CRM/Upgrade/Incremental/sql/5.4.alpha1.mysql.tpl