ALTER TABLE `report_history_variences` ADD `total_assets_scanned` INT NULL AFTER `total_assets`, ADD `location_id` INT NULL DEFAULT NULL AFTER `total_assets_scanned`; ALTER TABLE `report_history_variences` ADD `location_name` VARCHAR(45) NULL AFTER `location_id`;