instead of modifying the database structure I just added this to payment/payment_cc.php
Code:
$order_details.=$ship_to;
$order_details.="\nIP: " . $_SERVER[REMOTE_ADDR];
#
# Only logged users can submit orders
#
This puts the IP address in the customer notes field.