Table of Contents

Extension version settings

to prevent database updates running twice see [CRM-19252]

DELETE FROM `civicrm_setting` WHERE `domain_id` = ${domain_id} AND `name` LIKE '%:version';

INSERT INTO `civicrm_setting` (`name`, `value`, `domain_id`, `contact_id`, `is_domain`, `component_id`, `created_date`, `created_id`) 
SELECT `name`, `value`, ${domain_id}, `contact_id`, `is_domain`, `component_id`, NOW(), `created_id`
FROM `civicrm_setting`
WHERE `domain_id` = 1
AND `name` LIKE '%:version';