User authorizations are now saved in "userAuthorizations".
For most users, the authorizations are typically empty so it's not necessary to have all columns in the users table. Also, adding further authorizations always requires a database change, which can be avoided. The new table also saves the scope used for authorization, so it can be checked if an updated auth is needed after the required scopes have changed. Also the streamlabs socket token was never encrypted which is fixed with the change.
Moderators get their own mod authentication now to execute commands (currently only used for !announce).
Authentication status can be checked in the navigation bar
User authorizations are now saved in "userAuthorizations".
For most users, the authorizations are typically empty so it's not necessary to have all columns in the users table. Also, adding further authorizations always requires a database change, which can be avoided. The new table also saves the scope used for authorization, so it can be checked if an updated auth is needed after the required scopes have changed. Also the streamlabs socket token was never encrypted which is fixed with the change.
Moderators get their own mod authentication now to execute commands (currently only used for !announce).
Authentication status can be checked in the navigation bar