-- -- ec_offers_audit_tr/0 -- create or replace function ec_offers_audit_tr( ) returns trigger as $$ begin insert into ec_offers_audit ( offer_id, product_id, retailer_location_id, store_sku, retailer_premiums, price, shipping, shipping_unavailable_p, stock_status, special_offer_p, special_offer_html, offer_begins, offer_ends, deleted_p, last_modified, last_modifying_user, modified_ip_address ) values ( old.offer_id, old.product_id, old.retailer_location_id, old.store_sku, old.retailer_premiums, old.price, old.shipping, old.shipping_unavailable_p, old.stock_status, old.special_offer_p, old.special_offer_html, old.offer_begins, old.offer_ends, old.deleted_p, old.last_modified, old.last_modifying_user, old.modified_ip_address ); return new; end;$$ language plpgsql;