CREATE TABLE capacities (
	id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
	capacity_date DATE,
	operating_area_id INT NOT NULL,
	normal_hours SMALLINT NOT NULL,
	ot_hours SMALLINT NOT NULL,
	display_notes VARCHAR(255) DEFAULT NULL,
	field_operating_notes VARCHAR(255) DEFAULT NULL,
	FOREIGN KEY fk_operating_area (operating_area_id) REFERENCES areas (id)
) ENGINE=InnoDB;