From: Alan Knowles Date: Thu, 16 Apr 2015 04:55:42 +0000 (+0800) Subject: UpdateDatabase/MysqlLinks.php X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=2aa0f64ee65b39a8028401919ab0c928adcae004 UpdateDatabase/MysqlLinks.php --- diff --git a/UpdateDatabase/MysqlLinks.php b/UpdateDatabase/MysqlLinks.php index 5272e19c..a7ea502a 100644 --- a/UpdateDatabase/MysqlLinks.php +++ b/UpdateDatabase/MysqlLinks.php @@ -19,9 +19,9 @@ * initial code will auto generate triggers * -- how to add User defined modifications to triggers? * -- we can CALL a stored procedure..? - * -- {tablename}_trigger_before_delete_{column_name}(NEW.column) - * -- {tablename}_trigger_before_update_{column_name}(OLD.column, NEW.column} - * -- {tablename}_trigger_before_insert_{column_name}(OLD.column} + * -- {tablename}_trigger_{optional_string}_before_delete_{column_name}(NEW.column) + * -- {tablename}_trigger_{optional_string}_before_update_{column_name}(OLD.column, NEW.column} + * -- {tablename}_trigger_{optional_string}_before_insert_{column_name}(OLD.column} * * * @@ -339,6 +339,14 @@ class Pman_Core_UpdateDatabase_MysqlLinks { } + /** + * check the information schema for any methods that match the trigger criteria. + * + * + */ + // type = update/insert/delete + + function listTriggerFunctions($type) }