-- Executed on: DEV
CREATE TABLE tblindustry (
	id BIGINT PRIMARY KEY AUTO_INCREMENT NOT NULL,
    name VARCHAR(255) NOT NULL,
    code_name VARCHAR(255) NOT NULL
);

-- Executed on: DEV
ALTER TABLE `tblstaff` ADD `industry` VARCHAR(255) AFTER `datecreated`;
ALTER TABLE `tblstaff` ADD `company_role` VARCHAR(255) AFTER `industry`;
ALTER TABLE `tblstaff` ADD `company_size` VARCHAR(255) AFTER `company_role`;
ALTER TABLE `tblstaff` ADD `years_in_business` VARCHAR(255) AFTER `company_size`;
ALTER TABLE `tblstaff` ADD `how_found_cp` VARCHAR(255) AFTER `years_in_business`;
ALTER TABLE `tblstaff` ADD `fcm_token` LONGTEXT;