As a Site Admin, I want the upgrade process to only update tables that have changed

• Type: Story
• Status: Closed
• Priority: Minor
• Resolution: Completed
• Affects Version/s: 6.1.30 EE GA3, 6.2.2 CE GA3 , 7.0.0 M4
• Fix Version/s: 6.2.4 CE GA5, 6.2.X EE, Master
• Component/s: Core Infrastructure, Database Upgrade Framework
• Labels:
  • Core-Infrastructure
  • liferay-fixpack-portal-58-6210
• Branch Version/s:
  6.2.x
• Backported to Branch:
  Committed
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/25720

Currently when a user updates/adds a table to a portlet and increments service.properties, the upgrade process will backup, upgrade, and restore all data for all models tied to that portlet.

We need to improve this so the upgrade is smart enough to just:

1. only update the tables that have been changed
2. add new tables if there are those found
3. should only backup/restore data tied to the tables that have been modified