Change version numbering in portal-security-audit to ensure that the AUDIT_AUDITEVENT table can be upgraded in Liferay 7.1

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: Master
• Fix Version/s: Master
• Component/s: Environments, Environments > Databases
• Labels:
  • ee-ts
  • pt-upgrade-review
• Fix Priority: 3
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/73017

LPS-93033 was created to upgrade the AUDIT_AUDITEVENT table.
However, a few things are missing to ensure that this upgrade goes smoothly and the version numbers are synchronized through branches.

The upgrade process should be defined as 1.0.1 and the BaseUpgradeSQLServerDatetime should be kept as the lastest one since it does not exist in 7.1.

Tasks to be done within this current LPS:

• Set UpgradeSchema from 1.0.0 to 1.0.1
• Set BaseUpgradeSQLServerDatetime from 1.0.1 to 2.0.0
• Define the step 2.0.0 to 2.0.1 as DummyUpgradeStep (so that current users using Beta version won't have any issue)

Once we have done this, we can backport the upgrade UpgradeSchema to 7.1 as a step from 1.0.0 to 1.0.1

This information comes from:
https://github.com/achaparro/liferay-portal-ee/pull/49#issuecomment-487569676