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

{* file to handle db changes in 5.29.1 during upgrade *}

UPDATE `civicrm_custom_field` SET `serialize` = 0 WHERE `serialize` IS NULL;

ALTER TABLE `civicrm_custom_field`
CHANGE COLUMN `serialize`
`serialize` int unsigned NOT NULL DEFAULT 0 COMMENT 'Serialization method - a non-zero value indicates a multi-valued field.';
Commit	Line	Data
49df88a8 CW	1	{* file to handle db changes in 5.29.1 during upgrade *}
	2
	3	UPDATE `civicrm_custom_field` SET `serialize` = 0 WHERE `serialize` IS NULL;
	4
	5	ALTER TABLE `civicrm_custom_field`
	6	CHANGE COLUMN `serialize`
	7	`serialize` int unsigned NOT NULL DEFAULT 0 COMMENT 'Serialization method - a non-zero value indicates a multi-valued field.';