-- -- ec_shipments_audit_tr/0 -- create or replace function ec_shipments_audit_tr( ) returns trigger as $$ begin insert into ec_shipments_audit ( shipment_id, order_id, address_id, shipment_date, expected_arrival_date, carrier, tracking_number, actual_arrival_date, actual_arrival_detail, last_modified, last_modifying_user, modified_ip_address ) values ( old.shipment_id, old.order_id, old.address_id, old.shipment_date, old.expected_arrival_date, old.carrier, old.tracking_number, old.actual_arrival_date, old.actual_arrival_detail, old.last_modified, old.last_modifying_user, old.modified_ip_address ); return new; end;$$ language plpgsql;