Convert civicrm_note.modified_date to timestamp
[civicrm-core.git] / CRM / Upgrade / Incremental / sql / 5.24.alpha1.mysql.tpl
1 {* file to handle db changes in 5.24.alpha1 during upgrade *}
2
3 {* #16338 Convert civicrm_note.modified_date to timestamp *}
4 ALTER TABLE civicrm_note MODIFY COLUMN modified_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'When was this note last modified/edited';