19 lines
765 B
Smarty
19 lines
765 B
Smarty
|
{* 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);
|