CREATE TRIGGER t_thumbnail_prune BEFORE UPDATE OR DELETE ON adf_content_thumbnail
FOR EACH ROW
WHEN( coalesce(current_setting('your.SKIP_PRUNE_TRIGGER', 't'),'FALSE') <> 'TRUE')
EXECUTE PROCEDURE lo_manage(thumbnail);
CREATE TRIGGER t_pr_emailpass_template BEFORE UPDATE OR DELETE ON ADF_EMAIL_CONFIG
FOR EACH ROW
WHEN( coalesce(current_setting('your.SKIP_PRUNE_TRIGGER', 't'),'FALSE') <> 'TRUE')
EXECUTE PROCEDURE lo_manage(EMAIL_PASSWORD_TEMPLATE);
CREATE TRIGGER t_pr_file_content BEFORE UPDATE OR DELETE ON THEIA_FILES
FOR EACH ROW
WHEN( coalesce(current_setting('your.SKIP_PRUNE_TRIGGER', 't'),'FALSE') <> 'TRUE')
EXECUTE PROCEDURE lo_manage(CONTENT);
CREATE TRIGGER t_pr_file_thumb_l BEFORE UPDATE OR DELETE ON THEIA_FILES
FOR EACH ROW
WHEN( coalesce(current_setting('your.SKIP_PRUNE_TRIGGER', 't'),'FALSE') <> 'TRUE')
EXECUTE PROCEDURE lo_manage(THUMBNAIL_LARGE);
CREATE TRIGGER t_pr_file_thumb_s BEFORE UPDATE OR DELETE ON THEIA_FILES
FOR EACH ROW
WHEN( coalesce(current_setting('your.SKIP_PRUNE_TRIGGER', 't'),'FALSE') <> 'TRUE')
EXECUTE PROCEDURE lo_manage(THUMBNAIL_SMALL);
CREATE TRIGGER t_pr_adffile_content BEFORE UPDATE OR DELETE ON ADF_CONTENT_FILE
FOR EACH ROW
WHEN( coalesce(current_setting('your.SKIP_PRUNE_TRIGGER', 't'),'FALSE') <> 'TRUE')
EXECUTE PROCEDURE lo_manage(CONTENT);
CREATE TRIGGER t_pr_adffile_thumb_l BEFORE UPDATE OR DELETE ON ADF_CONTENT_FILE
FOR EACH ROW
WHEN( coalesce(current_setting('your.SKIP_PRUNE_TRIGGER', 't'),'FALSE') <> 'TRUE')
EXECUTE PROCEDURE lo_manage(THUMBNAIL_LARGE);
CREATE TRIGGER t_pr_adffile_thumb_s BEFORE UPDATE OR DELETE ON ADF_CONTENT_FILE
FOR EACH ROW
WHEN( coalesce(current_setting('your.SKIP_PRUNE_TRIGGER', 't'),'FALSE') <> 'TRUE')
EXECUTE PROCEDURE lo_manage(THUMBNAIL_SMALL);