Fix issue with GeneratedValue in PfGeneratedIdKey 39/127139/4
authora.sreekumar <ajith.sreekumar@bell.ca>
Tue, 15 Feb 2022 18:20:01 +0000 (18:20 +0000)
committera.sreekumar <ajith.sreekumar@bell.ca>
Wed, 16 Feb 2022 11:29:28 +0000 (11:29 +0000)
commit461a8bd824c06f42c717e6db55ba5cbb8b280c46
tree051ad2bf02e564ea6acb9ed541a74578a95e9392
parent14998a399334d72d1974b70fe5ef682d332508d2
Fix issue with GeneratedValue in PfGeneratedIdKey

Until now, 'ID, name and version' was used as the primary key in
jpapolicyaudit and pdpstatistics tables. With this change, only ID will
be used as the PK.
The applications works with or without this change, as ID was the only
field which was always unique. "name" and "version" are mostly
duplicates (policyName in case of jpapolicyaudit & pdpName in case of
pdpstatistics table).
Pushing this change anyway to keep the tables consistent
with the entity classes.

Change-Id: I34a7582ed9c74fa0ead8fce2e86ac2ce1ecacf1e
Issue-ID: POLICY-3897
Signed-off-by: a.sreekumar <ajith.sreekumar@bell.ca>
policy-db-migrator/src/main/docker/config/policyadmin/postgres/1000/downgrade/0160-jpapolicyaudit_pk.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/1000/downgrade/0170-pdpstatistics_pk.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/1000/upgrade/0160-jpapolicyaudit_pk.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/1000/upgrade/0170-pdpstatistics_pk.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/sql/1000/downgrade/0160-jpapolicyaudit_pk.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/sql/1000/downgrade/0170-pdpstatistics_pk.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/sql/1000/upgrade/0160-jpapolicyaudit_pk.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/sql/1000/upgrade/0170-pdpstatistics_pk.sql [new file with mode: 0644]