The latest release of the Affiliates plugin features an important improvement which is especially interesting for developers.
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
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.