https://kamailio.org/docs/db-tables/kamailio-db-devel.html#idm9040 contains:
* thay instead of they, (UID_AUTH_DB Module) * `,if` without comma in between (in UAC Module) * for table "uacreg" column realm is described as “Remote username”, it should be Remote realm
For table dbaliases indexes contains: * alias_user_idx on column alias_username * alias_idx composite index on columns alias_username and alias_domain
I would say the composite index will also be used on queries only on the alias_username column, so the index alias_user_idx is redundant and should be deleted.