ALTER TABLE requests DROP FOREIGN KEY requests_ibfk_6;
ALTER TABLE requests DROP FOREIGN KEY requests_ibfk_7;
ALTER TABLE requests DROP COLUMN region_id;
ALTER TABLE requests DROP COLUMN area_id;

ALTER TABLE user_defaults DROP FOREIGN KEY user_defaults_ibfk_2;
ALTER TABLE user_defaults DROP FOREIGN KEY user_defaults_ibfk_3;

ALTER TABLE user_defaults ADD FOREIGN KEY (area_id) REFERENCES operating_areas (id);
ALTER TABLE user_defaults ADD FOREIGN KEY (region_id) REFERENCES operating_regions (id);

DROP TABLE areas;
DROP TABLE regions;