1
CREATE FUNCTION update_list_subscription_history() RETURNS "trigger"
4
INSERT INTO list_subscription_history (id, areaid, prefixid, msn, j4f_customer_id,
5
subscriptiondate, seqid, refid, price, stopdate) VALUES (OLD.id, OLD.areaid,
6
OLD.prefixid, OLD.msn, OLD.j4f_customer_id, OLD.subscriptiondate, OLD.seqid,
7
OLD.refid, OLD.price, CURRENT_TIMESTAMP);