From 7ae6aba8674556b216519a9a107fe3e2ef53169c Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Tue, 15 Dec 2015 12:21:30 +0800 Subject: [PATCH] UpdateDatabase/MysqlLinks.php --- UpdateDatabase/MysqlLinks.php | 11 ++++++++++- 1 file changed, 10 insertions(+), 1 deletion(-) diff --git a/UpdateDatabase/MysqlLinks.php b/UpdateDatabase/MysqlLinks.php index 71fc323c..2a83a68a 100644 --- a/UpdateDatabase/MysqlLinks.php +++ b/UpdateDatabase/MysqlLinks.php @@ -23,8 +23,17 @@ * -- {tablename}_trigger_{optional_string}_before_update_{column_name}(OLD.column, NEW.column} * -- {tablename}_trigger_{optional_string}_before_insert_{column_name}(OLD.column} * - * * + * ------- Importing with triggers disabled. + * + * SET @DISABLE_TRIGGER=1; (or anything you like except NULL) + * do imports + * SET @DISABLE_TRIGGER=NULL; + * + * ------ Call a method disabling a particular set of triggers + * SET @DISABLE_TRIGGER_the_table_name=1; (or anything you like except NULL) + * do action + * SET @DISABLE_TRIGGER_the_table_name=NULL;* */ class Pman_Core_UpdateDatabase_MysqlLinks { -- 2.39.2