-- -- ec_email_templates_audit_tr/0 -- create or replace function ec_email_templates_audit_tr( ) returns trigger as $$ begin insert into ec_email_templates_audit ( email_template_id, title, subject, message, variables, when_sent, issue_type_list, last_modified, last_modifying_user, modified_ip_address ) values ( old.email_template_id, old.title, old.subject, old.message, old.variables, old.when_sent, old.issue_type_list, old.last_modified, old.last_modifying_user, old.modified_ip_address ); return new; end;$$ language plpgsql;