Support » Plugins » [Updated Plugin: Affiliates] Changes to the referrals table

  • 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.

  • The topic ‘[Updated Plugin: Affiliates] Changes to the referrals table’ is closed to new replies.