From 5e1bf272bb7aaaedc792136b28b0de9766885be2 Mon Sep 17 00:00:00 2001
From: Alan Knowles <alan@roojs.com>
Date: Wed, 20 Mar 2019 12:15:32 +0800
Subject: [PATCH] Fix #5814 - do not create tirggers

---
 UpdateDatabase.php            |  6 ++++++
 UpdateDatabase/MysqlLinks.php | 15 ++++++++++-----
 2 files changed, 16 insertions(+), 5 deletions(-)

diff --git a/UpdateDatabase.php b/UpdateDatabase.php
index 989e524f..8398e9d9 100644
--- a/UpdateDatabase.php
+++ b/UpdateDatabase.php
@@ -73,6 +73,12 @@ class Pman_Core_UpdateDatabase extends Pman
             'min' => 1,
             'max' => 1,
         ),
+        'disable-create-triggers' => array(
+            'desc' => 'So not create the mysql triggers',
+            'default' => '',
+            'min' => 1,
+            'max' => 1,
+        ),
         
         'json-person' => array(
             'desc' => 'Person JSON file',
diff --git a/UpdateDatabase/MysqlLinks.php b/UpdateDatabase/MysqlLinks.php
index 2c5541ad..07cf02ff 100644
--- a/UpdateDatabase/MysqlLinks.php
+++ b/UpdateDatabase/MysqlLinks.php
@@ -49,15 +49,20 @@ class Pman_Core_UpdateDatabase_MysqlLinks {
         $this->updateTableComments();
        
         $ff = HTML_FlexyFramework::get();
-        if (!empty($ff->Pman['enable_trigger_tests'])) {
+        if (empty($ff->Pman['enable_trigger_tests'])) {
+            return;
+        }
+        if (!empty($ff->page->opts['disable-create-triggers'])) {
+            return;
+        }
             
             // note we may want to override some of these... - to do special triggers..
             // as you can only have one trigger per table for each action.
             
-            $this->createDeleteTriggers();
-            $this->createInsertTriggers();
-            $this->createUpdateTriggers();
-        }
+        $this->createDeleteTriggers();
+        $this->createInsertTriggers();
+        $this->createUpdateTriggers();
+        
         
         
     }
-- 
2.39.2