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

{* file to handle db changes in 4.7.beta6 during upgrade *}

-- CRM-17686
ALTER TABLE `civicrm_job`
ADD COLUMN `scheduled_run_date` timestamp NULL DEFAULT NULL COMMENT 'When is this cron entry scheduled to run' AFTER `last_run`;

-- 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;

SELECT @domainID := min(id) FROM civicrm_domain;
INSERT INTO civicrm_setting(name, value, domain_id, is_domain) values ('installed', 'i:1;', @domainID, 1);
Commit	Line	Data
3bfc603d	1	{* file to handle db changes in 4.7.beta6 during upgrade *}
902e557f DRJ	2
	3	-- CRM-17686
	4	ALTER TABLE `civicrm_job`
	5	ADD COLUMN `scheduled_run_date` timestamp NULL DEFAULT NULL COMMENT 'When is this cron entry scheduled to run' AFTER `last_run`;
97e3922c J	6
	7	-- CRM-17745: Make maximum additional participants configurable
	8	ALTER TABLE civicrm_event
	9	ADD COLUMN max_additional_participants int(10) unsigned
	10	DEFAULT 0
	11	COMMENT 'Maximum number of additional participants that can be registered on a single booking'
	12	AFTER is_multiple_registrations;
	13	UPDATE civicrm_event
	14	SET max_additional_participants = 9
	15	WHERE is_multiple_registrations = 1;
169abce4	16
0085db83	17	SELECT @domainID := min(id) FROM civicrm_domain;
20d5377e	18	INSERT INTO civicrm_setting(name, value, domain_id, is_domain) values ('installed', 'i:1;', @domainID, 1);