IF UPDATING
 UPDATE cache_merchants
    SET merchant_name = :new.merchant_name,transflow_username = :new.transflow_username,
    transflow_password = :new.transflow_password,
    callback_url = :new.callback_url,status = :new.status, updated_at=now()
  WHERE merchant_id = :old.merchant_id ;

  IF DELETING
 DELETE FROM cache_merchants WHERE merchant_id = :old.merchant_id ;