Description

Based on the conversation here: https://github.com/keycloak/keycloak/pull/39994#discussion_r2109606990, we should add a unique constraint to the UPDATE_TIME column in MIGRATION_MODEL table to ensure there are no duplications. When duplicates are present, the behavior might be broken for deployments as different resource versions would be returned which might lead to not properly loading resources (like account console, login screens, etc.)

A cleanup script should be also added.

Discussion

https://github.com/keycloak/keycloak/pull/39994#discussion_r2109606990

Motivation

No response

Details

No response