* chore: rename user role to `host`

* chore: related frontend changes

* chore: fix migration file

* chore: use tricky sql