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

INSERT INTO si_query_severities (id, name) VALUES
	(1, 'Non-Negotiable'),
	(2, 'Opportunities');

ALTER TABLE si_inspection_queries ADD COLUMN severity_id INT DEFAULT NULL;

ALTER TABLE si_inspection_queries ADD KEY idk_severity_id (severity_id);

ALTER TABLE si_inspection_queries ADD FOREIGN KEY fk_severity_id (severity_id) REFERENCES si_query_severities (id);