use aerion; ALTER TABLE `aerion`.`inv` \nDROP COLUMN `to_address_type`,\nDROP COLUMN `to_suite_no`,\nDROP COLUMN `from_address_type`,\nDROP COLUMN `from_suite_no`,\nCHANGE COLUMN `from_look_street_no_id` `from_add_ref_id` INT NULL DEFAULT NULL ,\nCHANGE COLUMN `to_look_street_no_id` `to_add_ref_id` INT NULL DEFAULT NULL ;\n