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

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

-- CRM-17745: Make maximum additional participants configurable
ALTER TABLE civicrm_event
  ADD COLUMN max_additional_participants int(10) unsigned
  DEFAULT 0
  COMMENT 'Maximum number of additional participants that can be registered on a single booking'
  AFTER is_multiple_registrations;
UPDATE civicrm_event
  SET max_additional_participants = 9
  WHERE is_multiple_registrations = 1;
Commit	Line	Data
f1bc01e0 J	1	{* file to handle db changes in 4.8.alpha1 during upgrade *}
	2
	3	-- CRM-17745: Make maximum additional participants configurable
	4	ALTER TABLE civicrm_event
	5	ADD COLUMN max_additional_participants int(10) unsigned
	6	DEFAULT 0
	7	COMMENT 'Maximum number of additional participants that can be registered on a single booking'
	8	AFTER is_multiple_registrations;
	9	UPDATE civicrm_event
	10	SET max_additional_participants = 9
	11	WHERE is_multiple_registrations = 1;