Hi, thanks for your help, please see below
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(20) | YES | | NULL | |
| UpdateAt | bigint(20) | YES | | NULL | |
| DeleteAt | bigint(20) | YES | | NULL | |
| Scope | varchar(32) | YES | | NULL | |
| DefaultTeamAdminRole | varchar(64) | YES | | NULL | |
| DefaultTeamUserRole | varchar(64) | YES | | NULL | |
| DefaultChannelAdminRole | varchar(64) | YES | | NULL | |
| DefaultChannelUserRole | varchar(64) | YES | | NULL | |
| DefaultTeamGuestRole | text | YES | | NULL | |
| DefaultChannelGuestRole | text | YES | | NULL | |
+-------------------------+--------------+------+-----+---------+-------+
14 rows in set (0.00 sec)
CREATE TABLE `Schemes` (
`Id` varchar(26) NOT NULL,
`Name` varchar(64) DEFAULT NULL,
`DisplayName` varchar(128) DEFAULT NULL,
`Description` text,
`CreateAt` bigint(20) DEFAULT NULL,
`UpdateAt` bigint(20) DEFAULT NULL,
`DeleteAt` bigint(20) DEFAULT NULL,
`Scope` varchar(32) DEFAULT NULL,
`DefaultTeamAdminRole` varchar(64) DEFAULT NULL,
`DefaultTeamUserRole` varchar(64) DEFAULT NULL,
`DefaultChannelAdminRole` varchar(64) DEFAULT NULL,
`DefaultChannelUserRole` varchar(64) DEFAULT NULL,
`DefaultTeamGuestRole` text,
`DefaultChannelGuestRole` text,
PRIMARY KEY (`Id`),
UNIQUE KEY `Name` (`Name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4