From f76ec5595fad4b8ee72827f23b3b76eaf6eb2868 Mon Sep 17 00:00:00 2001
From: Tim Otten <totten@civicrm.org>
Date: Mon, 18 Apr 2016 18:58:38 -0700
Subject: [PATCH] CRM-18212 - Declare core setting
 `logging_no_trigger_permission`

---
 settings/Core.setting.php                         | 15 +++++++++++++++
 .../CRM/common/civicrm.settings.php.template      |  3 +++
 2 files changed, 18 insertions(+)

diff --git a/settings/Core.setting.php b/settings/Core.setting.php
index 388f9387ab..89dd7d150c 100644
--- a/settings/Core.setting.php
+++ b/settings/Core.setting.php
@@ -699,6 +699,21 @@ return array(
     'description' => 'When enabled, "empowered by CiviCRM" is displayed at the bottom of public forms.',
     'help_text' => NULL,
   ),
+  'logging_no_trigger_permission' => array(
+    'add' => '4.7',
+    'is_domain' => 1,
+    'is_contact' => 0,
+    'group_name' => 'CiviCRM Preferences',
+    'group' => 'core',
+    'help_text' => ts('(EXPERIMENTAL) If the MySQL user does not have permission to administer triggers, then you must create the triggers outside CiviCRM. No support is provided for this configuration.'),
+    'name' => 'logging_no_trigger_permission',
+    'type' => 'Boolean',
+    'quick_form_type' => 'YesNo',
+    'html_type' => '',
+    'default' => 0,
+    'title' => '(EXPERIMENTAL) MySQL user does not have trigger permissions',
+    'description' => 'Set this when you intend to manage trigger creation outside of CiviCRM',
+  ),
   'logging' => array(
     'add' => '4.7',
     'help_text' => NULL,
diff --git a/templates/CRM/common/civicrm.settings.php.template b/templates/CRM/common/civicrm.settings.php.template
index f6906bcdf1..19f26c9126 100644
--- a/templates/CRM/common/civicrm.settings.php.template
+++ b/templates/CRM/common/civicrm.settings.php.template
@@ -247,6 +247,9 @@ if (!defined('CIVICRM_UF_BASEURL')) {
  // Disable automatic download / installation of extensions
  // $civicrm_setting['Extension Preferences']['ext_repo_url'] = false;
 
+ // set triggers to be managed offline per CRM-18212
+ // $civicrm_setting['CiviCRM Preferences']['logging_no_trigger_permission'] = 1;
+
  // Override the CMS root path defined by cmsRootPath.
  // define('CIVICRM_CMSDIR', '/path/to/install/root/');
 
-- 
2.25.1