CREATE TABLE expense_types (
	id TINYINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
	name VARCHAR(32) NOT NULL
) ENGINE=InnoDB;

INSERT INTO expense_types (id, name) VALUES (1, 'Capex'), (2, 'Opex');

ALTER TABLE requests ADD COLUMN expense_type_id TINYINT DEFAULT NULL;
ALTER TABLE requests ADD FOREIGN KEY idx_expense_type (expense_type_id) REFERENCES expense_types (id);
