templates.velocity.ro_notify.mysql.remove_ro_notify_trigger.sql.vm Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of sql2java-observer Show documentation

table listener base row observer UDF

There is a newer version: 5.2.0

#parse( "header.include.vm")

#set ( $trigger_prefix = $schematable.replace(".","_") )
# 删除${schematable}表触发器 AFTER_INSERT
DROP TRIGGER IF EXISTS ${trigger_prefix}_after_insert_trigger ;
# 删除${schematable}表触发器 BEFORE_INSERT
DROP TRIGGER IF EXISTS ${trigger_prefix}_before_insert_trigger ;
# 删除${schematable}表触发器 AFTER_UPDATE
DROP TRIGGER IF EXISTS ${trigger_prefix}_after_update_trigger ;
# 删除${schematable}表触发器 BEFORE_UPDATE
DROP TRIGGER IF EXISTS ${trigger_prefix}_before_update_trigger ;
# 删除${schematable}表触发器 AFTER_DELETE
DROP TRIGGER IF EXISTS ${trigger_prefix}_after_delete_trigger ;
# 删除${schematable}表触发器 BEFORE_DELETE
DROP TRIGGER IF EXISTS ${trigger_prefix}_before_delete_trigger ;