account.EmailAddress: (models.W036) MySQL does not support unique constraints with conditions

The following warning is produced by docker compose exec web django-admin initialize

[...]
web-1  | WARNINGS:
web-1  | account.EmailAddress: (models.W036) MariaDB does not support unique constraints with conditions.
web-1  |        HINT: A constraint won't be created. Silence this warning if you don't care about it.
web-1  | account.EmailAddress: (models.W043) MariaDB does not support indexes on expressions.
web-1  |        HINT: An index won't be created. Silence this warning if you don't care about it.
[...]

This warning is caused by django-allauth using a constraint that MySQL does not support, background info: https://codeberg.org/allauth/django-allauth/issues/3385

Following those post, I'd assess that it is acceptable to ignore this warning, especially knowing that it will eventually fixed by simply migrating away from MariaDB.

💡 Possible solution

Ignore this warning, then migrate to PostgreSQL.