12 lines
448 B
SQL
12 lines
448 B
SQL
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); |