Remove unused columns from DB schema 76/141576/1
authordanielhanrahan <daniel.hanrahan@est.tech>
Tue, 22 Jul 2025 19:49:41 +0000 (20:49 +0100)
committerdanielhanrahan <daniel.hanrahan@est.tech>
Wed, 23 Jul 2025 12:40:06 +0000 (13:40 +0100)
commit45ee0025f545eb38b5a071ef4640b9994a8722fd
treec61bdca5da2d9a3dac2784c2d4b056d9275d5716
parent6fc962479cb04aab9d5cd800e8e3f72c423f489e
Remove unused columns from DB schema

The following columns are unused by Java and can be removed:
- AutomationComposition.restarting
- AutomationCompositionDefinition.restarting
- Participant.participantState
- Participant.lastMsg

Issue-ID: POLICY-5422
Change-Id: Idc9dadb3e021ee067c6a733b797975a0ceb83c4f
Signed-off-by: danielhanrahan <daniel.hanrahan@est.tech>
policy-db-migrator/src/main/docker/config/clampacm/postgres/1702/downgrade/0100-automationcomposition.sql
policy-db-migrator/src/main/docker/config/clampacm/postgres/1702/downgrade/0200-automationcompositiondefinition.sql
policy-db-migrator/src/main/docker/config/clampacm/postgres/1702/downgrade/0400-participant.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/clampacm/postgres/1702/upgrade/0100-automationcomposition.sql
policy-db-migrator/src/main/docker/config/clampacm/postgres/1702/upgrade/0200-automationcompositiondefinition.sql
policy-db-migrator/src/main/docker/config/clampacm/postgres/1702/upgrade/0400-participant.sql [new file with mode: 0644]