--
-- 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;