Storing paypal information

im trying to implement paypal with IPN to update my databases on completed payments. (im using php and mysql)

right now it works. yay! but i dont know what kind of information i should store in the database.

right now this is what i have in mind

server gets IPN. checks data blah

if IPN is VERIFIED and Completed (meaning the payment cleared) i update my databases to show that i received the payment. i do this buy increasing their balance in their user login table.

i also think its appropiate to keep track of transactions themself.

right now i log every paypal IPN i get regardless of the results and in the log i put all the variables the IPN script gets posted. so if theres any issues i can always refer to this log at a for sure identifier.

but what about the mysql database. at first im thinking i should just put the txn_id the payer_id and payer_email the amount datetime.

but what if the user creates a dispute ie a chargeback or something the payment_status would be different and id have invalid data. my IPN script is queried on each update i beleive but when it comes to refunds and dipsutes etc i dont know what other information id need easy access to (refernig back to a possibly huge IPN log file doesnt seem that fun)

bump sorry

have u tried looking at TinyTool? I didnt read your entire post, so i hope it helps.

hash the info?

no what i mean is like, thers 100s of paypal variables which can be used which ones are important (in a simple transaction of the user paying me money nothing special about it) bassicaly i cant figure out the bare bone variables to do the basic paypal task of using it for receiving money on a website. (as far as receiving the money, clearing it after the payment is cleared, and if there is a dispute like a charge back or similar)