diff options
| author |   lukegleeson <luke.gleeson@est.tech> | 2022-10-04 16:07:37 +0100 |
|---|---|---|
| committer | lukegleeson <luke.gleeson@est.tech> | 2022-10-05 16:19:03 +0100 |
| commit | 984d1f2d90fee958d545da6924c3628f87fac840 (patch) | |
| tree | 9f3c7cfc54d0e2fc54a56c8d93dcd0dae6d088f3 /cps-ri/src/main/resources/changelog/db/changes/16-insert-cm-handle-state-rollback.sql | |
| parent | 4bd450e1d48a24a1617906932c1de8d727bd7a40 (diff) | |
Make CPS/NCMP upgradeable
Liquibase step to add CM Handle Advised state to existing CM Handles
Issue-ID: CPS-1312
Signed-off-by: lukegleeson <luke.gleeson@est.tech>
Change-Id: I8077e66c64946f6ce092daa96ee40cd935fe0b72
Diffstat (limited to 'cps-ri/src/main/resources/changelog/db/changes/16-insert-cm-handle-state-rollback.sql')
| -rw-r--r-- | cps-ri/src/main/resources/changelog/db/changes/16-insert-cm-handle-state-rollback.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/cps-ri/src/main/resources/changelog/db/changes/16-insert-cm-handle-state-rollback.sql b/cps-ri/src/main/resources/changelog/db/changes/16-insert-cm-handle-state-rollback.sql new file mode 100644 index 0000000000..aaf05a24cb --- /dev/null +++ b/cps-ri/src/main/resources/changelog/db/changes/16-insert-cm-handle-state-rollback.sql @@ -0,0 +1,4 @@ +delete from fragment where xpath ~* '^/dmi-registry/cm-handles\[@id=''[\w\-]+''\]/state/lock-reason$'; +delete from fragment where xpath ~* '^/dmi-registry/cm-handles\[@id=''[\w\-]+''\]/state/datastores/operational$'; +delete from fragment where xpath ~* '^/dmi-registry/cm-handles\[@id=''[\w\-]+''\]/state/datastores$'; +delete from fragment where xpath ~* '^/dmi-registry/cm-handles\[@id=''[\w\-]+''\]/state$';
\ No newline at end of file |