For comparison purposes, this is the output that I am getting on my end:
mysql> DESCRIBE Schemes;
+-------------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------------+--------------+------+-----+---------+-------+
| Id | varchar(26) | NO | PRI | NULL | |
| Name | varchar(64) | YES | UNI | NULL | |
| DisplayName | varchar(128) | YES | | NULL | |
| Description | text | YES | | NULL | |
| CreateAt | bigint | YES | | NULL | |
| UpdateAt | bigint | YES | | NULL | |
| DeleteAt | bigint | YES | | NULL | |
| Scope | varchar(32) | YES | | NULL | |
| DefaultTeamAdminRole | varchar(64) | YES | | NULL | |
| DefaultTeamUserRole | varchar(64) | YES | | NULL | |
| DefaultChannelAdminRole | varchar(64) | YES | MUL | NULL | |
| DefaultChannelUserRole | varchar(64) | YES | MUL | NULL | |
| DefaultTeamGuestRole | varchar(64) | YES | | NULL | |
| DefaultChannelGuestRole | varchar(64) | YES | MUL | NULL | |
+-------------------------+--------------+------+-----+---------+-------+
14 rows in set (0.01 sec)
indicating that DefaultTeamGuestRole
and DefaultChannelGuestRole
are supposed to be created as varchar(64)
instead of `text.
Let us know how it goes on your end.