ALTER TABLE requests ADD COLUMN is_sharp TINYINT(1) DEFAULT 0;

CREATE TABLE permit_types (
	id TINYINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
	name VARCHAR(64) NOT NULL
);

ALTER TABLE requests ADD COLUMN permit_type_id TINYINT DEFAULT NULL;
ALTER TABLE requests ADD FOREIGN KEY idx_permit_type (permit_type_id) REFERENCES permit_types (id);

INSERT INTO permit_types (id, name) VALUES (1, 'Clearance to Work'), (2, 'Info Only');
