-- -- ec_products_audit_tr/0 -- create or replace function ec_products_audit_tr( ) returns trigger as $$ begin insert into ec_products_audit ( product_id, product_name, creation_date, one_line_description, detailed_description, search_keywords, shipping, shipping_additional, weight, dirname, present_p, active_p, available_date, announcements, announcements_expire, url, template_id, stock_status, last_modified, last_modifying_user, modified_ip_address ) values ( old.product_id, old.product_name, old.creation_date, old.one_line_description, old.detailed_description, old.search_keywords, old.shipping, old.shipping_additional, old.weight, old.dirname, old.present_p, old.active_p, old.available_date, old.announcements, old.announcements_expire, old.url, old.template_id, old.stock_status, old.last_modified, old.last_modifying_user, old.modified_ip_address ); return new; end;$$ language plpgsql;