From 3930f67660e5a94845ee3c6f67cc7a7f8374b103 Mon Sep 17 00:00:00 2001 From: FrancescoFioraEst Date: Mon, 21 Jul 2025 13:56:39 +0100 Subject: [PATCH] Add revisionId field to support restore DB Issue-ID: POLICY-5420 Change-Id: I4b6f716e7f5b4af3de02cef72a6ade27d5618ce8 Signed-off-by: FrancescoFioraEst --- .../clampacm/postgres/1702/downgrade/0100-automationcomposition.sql | 2 +- .../postgres/1702/downgrade/0200-automationcompositiondefinition.sql | 2 +- .../clampacm/postgres/1702/upgrade/0100-automationcomposition.sql | 2 +- .../postgres/1702/upgrade/0200-automationcompositiondefinition.sql | 2 +- 4 files changed, 4 insertions(+), 4 deletions(-) diff --git a/policy-db-migrator/src/main/docker/config/clampacm/postgres/1702/downgrade/0100-automationcomposition.sql b/policy-db-migrator/src/main/docker/config/clampacm/postgres/1702/downgrade/0100-automationcomposition.sql index e0306546..5557bed1 100644 --- a/policy-db-migrator/src/main/docker/config/clampacm/postgres/1702/downgrade/0100-automationcomposition.sql +++ b/policy-db-migrator/src/main/docker/config/clampacm/postgres/1702/downgrade/0100-automationcomposition.sql @@ -17,4 +17,4 @@ * ============LICENSE_END========================================================= */ -ALTER TABLE automationcomposition DROP lastUpdate; +ALTER TABLE automationcomposition DROP revisionId; diff --git a/policy-db-migrator/src/main/docker/config/clampacm/postgres/1702/downgrade/0200-automationcompositiondefinition.sql b/policy-db-migrator/src/main/docker/config/clampacm/postgres/1702/downgrade/0200-automationcompositiondefinition.sql index 234e93be..69f5d842 100644 --- a/policy-db-migrator/src/main/docker/config/clampacm/postgres/1702/downgrade/0200-automationcompositiondefinition.sql +++ b/policy-db-migrator/src/main/docker/config/clampacm/postgres/1702/downgrade/0200-automationcompositiondefinition.sql @@ -17,4 +17,4 @@ * ============LICENSE_END========================================================= */ -ALTER TABLE automationcompositiondefinition DROP lastUpdate; +ALTER TABLE automationcompositiondefinition DROP revisionId; diff --git a/policy-db-migrator/src/main/docker/config/clampacm/postgres/1702/upgrade/0100-automationcomposition.sql b/policy-db-migrator/src/main/docker/config/clampacm/postgres/1702/upgrade/0100-automationcomposition.sql index 246bcde9..d349ca26 100644 --- a/policy-db-migrator/src/main/docker/config/clampacm/postgres/1702/upgrade/0100-automationcomposition.sql +++ b/policy-db-migrator/src/main/docker/config/clampacm/postgres/1702/upgrade/0100-automationcomposition.sql @@ -18,4 +18,4 @@ */ ALTER TABLE automationcomposition - ADD COLUMN lastUpdate VARCHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000'; + ADD COLUMN revisionId VARCHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000'; diff --git a/policy-db-migrator/src/main/docker/config/clampacm/postgres/1702/upgrade/0200-automationcompositiondefinition.sql b/policy-db-migrator/src/main/docker/config/clampacm/postgres/1702/upgrade/0200-automationcompositiondefinition.sql index cf64529f..1e94848b 100644 --- a/policy-db-migrator/src/main/docker/config/clampacm/postgres/1702/upgrade/0200-automationcompositiondefinition.sql +++ b/policy-db-migrator/src/main/docker/config/clampacm/postgres/1702/upgrade/0200-automationcompositiondefinition.sql @@ -18,4 +18,4 @@ */ ALTER TABLE automationcompositiondefinition - ADD COLUMN lastUpdate VARCHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000'; + ADD COLUMN revisionId VARCHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000'; -- 2.16.6