[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 keyreferral_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 inreference
. This column is indexed.
- The topic ‘[Updated Plugin: Affiliates] Changes to the referrals table’ is closed to new replies.