-- Drop industry table

DROP TABLE `tblindustry`;

ALTER TABLE `tbltenants` DROP COLUMN `industry`;

ALTER TABLE `tblstaff` DROP COLUMN `industry`;

DELETE FROM tbltenant_onboarding_steps WHERE onboarding_steps_static_id IN (SELECT id FROM tblonboarding_steps_static WHERE code_name = 'select_industry');

DELETE FROM tblonboarding_steps_static WHERE code_name = 'select_industry';