THIS OLD POST HAS BEEN UPDATED TO BE CURRENT WITH THE LATEST RELEASE AS OF 8.42 TO INCLUDE ALL TABLES THROUGH THAT VERSION.
If for some reason you need to change your PhotoPost tables to use a prefix because of conflicts with other scripts; this group of RENAMEs will accomplish what you need quickly.
First, close your gallery. Then paste these commands into phpmyadmin using your PhotoPost database.
Content visible to verified customers only.
You'll need to edit your config-inc.php and change
$pp_db_prefix = "pp_";
That's it. Now your tables are using a pp_ prefix which will avoid any conflicts with other tables created in your database by other applications.