SQL to import paid Subscriptions

[kronnos]

Hi,

I am importing paid subscriptions from a mod I was using to handle those instead of the default VB subscription system.

Seems like Im going to be importing to 3 different tables (paymentinfo, paymenttransaction, subscriptionlog) and prob do a VLOOKUP on paymentinfoid field in paymentinfo and paymenttransaction table since the paymenttransaction table does not have a userid column.

Unfortunately the subscription mod I was using did not generate a hash which is a field in the paymentinfo table. Can I just generate my oun number/letter that is as long as those hash's? Or is a hash supposed to be composed of something and its not completely random? Can I leave that field blank (prefer not to)?

Thanks!