CREATE TABLE priorities (
	id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
	name VARCHAR(255) UNIQUE
) ENGINE=InnoDB;

ALTER TABLE requests ADD COLUMN priority_id INT DEFAULT NULL;

ALTER TABLE requests ADD CONSTRAINT FOREIGN KEY idx_priority_id (priority_id) REFERENCES priorities (id);