I have a number of instances of phpwcms on one mysql server each with a different prefix. Upgrading is more tricky than it needs to be because it is not readily aparent from the database what software version the database is patched up to.
I would like to suggest the addition of a field in a system table into which is stored the highest patch level sucessfully applied.
The upgrade.php script could then use this and offer a more automated upgrade path.
James Savage
phpwcms Support Forum
The phpwcms support forum will help to find answers to your questions. The small but strong community is here since more than 10 years.