From 97e3922c6f7b69c7eb01f28f940b0dfd40cc2d54 Mon Sep 17 00:00:00 2001 From: JKingsnorth Date: Mon, 4 Jan 2016 13:39:00 +0000 Subject: [PATCH] CRM-17745 Add SQL updates to 4.7b6 --- CRM/Upgrade/Incremental/sql/4.7.beta6.mysql.tpl | 10 ++++++++++ 1 file changed, 10 insertions(+) diff --git a/CRM/Upgrade/Incremental/sql/4.7.beta6.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.7.beta6.mysql.tpl index eaf4c4a2c7..ead67d5eea 100644 --- a/CRM/Upgrade/Incremental/sql/4.7.beta6.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.7.beta6.mysql.tpl @@ -3,3 +3,13 @@ -- 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; -- 2.25.1