SET storage_engine=InnoDB;

CREATE TABLE divisions (
	id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
	name VARCHAR(255) UNIQUE NOT NULL
);

INSERT INTO divisions (id, name) VALUES
	(1, 'Engineering'),
	(2, 'Finance & Compliance'),
	(3, 'Group CFO'),
	(4, 'Group Network Strategy'),
	(5, 'Group People & Services'),
	(6, 'Health Safety & Env'),
	(7, 'Human Resources'),
	(8, 'Information Comm & Tech'),
	(9, 'Network Development'),
	(10, 'Network Operations'),
	(11, 'Office of the CEO'),
	(12, 'Office of the COO'),
	(13, 'People & Services');

