Robert, the SQL patching is all done automatically via the file /YOUR_ADMIN/includes/functions/extra_functions/init_snap.php. That file adds the necessary database tables as well as the configuration fields controlled by Configuration->Affiliate Program.

There's a SQL patch to remove the stuff that's added ...