CREATE TABLE IF NOT EXISTS `trustlevel` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`identifier` varchar(255) NOT NULL,
`charidentifier` varchar(255) NOT NULL,
`trust` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`trust`)),
PRIMARY KEY (`id`),
UNIQUE KEY `identifier` (`identifier`,`charidentifier`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci
INSERT IGNORE INTO `trustlevel` (`id`, `identifier`, `charidentifier`, `trust`) VALUES
(1, 'steam:xxx', '11', '{"drugcooker":10,"moonshine":0,"breaker":263,"boost":10,"gunner":10,"drugfarmer":10}'),