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

INSERT INTO si_divisions (id, name, acronym) VALUES
	(1, 'Transmission and System Operations', 'TSO'),
	(2, 'Corporate', 'COR'),
	(3, 'Distribution Operations and Reliability', 'DOR');

ALTER TABLE si_inspections ADD COLUMN division_id INT DEFAULT NULL;

ALTER TABLE si_inspections ADD KEY idx_division_id (division_id);
ALTER TABLE si_inspections ADD FOREIGN KEY fk_division (division_id) REFERENCES si_divisions (id);