Remove usage of MD5 in postgresql & mysql schema for use DoD IL4-6

[robotdan]

Remove usage of MD5 in postgresql & mysql schema for use DoD IL4-6

Description

We use md5 in the Postgres & MySQL schema to build a UUID v4 to avoid depending upon the uuid-ossp extension.

In Postgres version >= 13 we can use gen_random_uuid() to generate a v4 UUID.

Because we still support Postgres < 13 we will need to be able to fall back to the existing pattern of using MD5.

Postgres 12 was EOL Nov 2024, and Postgres 13 is EOL as of Nov 2025, so we could just update our supported versions to >= 13.

• https://www.postgresql.org/support/versioning/
• https://endoflife.date/postgresql

Community guidelines

All issues filed in this repository must abide by the FusionAuth community guidelines.