[civicrm-core.git] / CRM / Upgrade / Incremental / sql / 5.24.alpha1.mysql.tpl

{* file to handle db changes in 5.24.alpha1 during upgrade *}

{* #16338 Convert civicrm_note.modified_date to timestamp *}
ALTER TABLE civicrm_note MODIFY COLUMN modified_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'When was this note last modified/edited';
Commit	Line	Data
f9a4aff1	1	{* file to handle db changes in 5.24.alpha1 during upgrade *}
95ae25b9 MW	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';