Before reporting an issue

[X] I have read and understood the above terms for submitting issues, and I understand that my issue may be closed without action if I do not follow them.

Area

storage

Describe the bug

The fix of the issue https://github.com/keycloak/keycloak/issues/30631 in KC 26.0.7 broke the KC deployment on Mysql 8.0 with replication enabled.

Deploying KC 26.0.7 on a Mysql 8 replicated cluster fails with the error :

```

 Reason: liquibase.exception.DatabaseException: The table does not comply with the requirements by an external plugin. [Failed SQL: (3098) DELETE FROM {{adminop-db-rec}}.USER_CONSENT WHERE ID IN (SELECT ID FROM TEMP_USER_CONSENT_IDS)]

```

As the table TEMP_USER_CONSENT_IDS is no more temporary, the above command failed.

We had to revert to KC 26.0.6

Version

26.0.7

Regression

[X] The issue is a regression

Expected behavior

We can upgrade or install KC 26 with mysql 8

Actual behavior

Upgrade to KC 26.0.7 is broken.

How to Reproduce?

With a KC 24 deployement using a Mysql 8 cluster with replicaton enabled
Upgrade to KC 26.0.7

On startup the installation fails and a TEMP_USER_CONSENT_IDS persists in the database

Anything else?

No response