CREATE TABLE `mdt_authorities` (
	`id` int AUTO_INCREMENT NOT NULL,
	`key` varchar(32) NOT NULL,
	`name` varchar(128) NOT NULL,
	`color` varchar(16) NOT NULL DEFAULT '#2f6df6',
	`department` enum('police','ems','fire') NOT NULL,
	`jobs` json NOT NULL DEFAULT ('[]'),
	CONSTRAINT `mdt_authorities_id` PRIMARY KEY(`id`),
	CONSTRAINT `mdt_authorities_key_unique` UNIQUE(`key`)
);
--> statement-breakpoint
ALTER TABLE `mdt_users` ADD `job` varchar(64);