SQL

Simple Copy and paste it

Create The SQL TABLE :

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

Just in case you need it , or check how looks like :

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}'),
	

Last updated

Was this helpful?