WordPress.org

Ready to get started?Download WordPress

Forums

[Updated Plugin: Affiliates] Changes to the referrals table (1 post)

  1. itthinx
    Member
    Posted 2 years ago #

    The latest release of the Affiliates plugin features an important improvement which is especially interesting for developers.

    The referrals table now uses an id-based primary key referral_id instead of the compound one it had before. This was necessary to avoid duplicate keys when multiple referrals are processed at the same (MySQL) datetime, as in the previous versions, the primary key was composed of (affiliate_id, post_id,datetime).

    A new column has been added to the table: reference which can be very useful when a transaction id is to be recorded along with the referral which can then be used to access the referral in further processing by the associated transaction id stored in reference. This column is indexed.

Topic Closed

This topic has been closed to new replies.

About this Topic

  • RSS feed for this topic
  • Started 2 years ago by itthinx
  • This topic is not a support question
  • WordPress version: 3.3