UUID Column change the generation function

Is your feature request related to a problem? Please describe.
Currently we use md5() to generate the uuid column, but since it is not completly safe to use it
suggest to use https://www.postgresql.org/docs/current/functions-uuid.html

Also the identity columns should also be changed

CREATE TABLE IF NOT EXISTS main.auth_clients (
	id                   integer  NOT NULL GENERATED BY DEFAULT AS IDENTITY,

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

Inspect the schema or migration definitions for main.auth_clients and search for the current md5()-based UUID generation and identity-column declarations. Read the linked PostgreSQL UUID documentation first, then identify every affected definition; done means the UUID generation and requested identity columns consistently use the agreed PostgreSQL approach.