ALTER TABLE `wh_house_info`
    MODIFY COLUMN `house_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '仓库名称NAME' AFTER `house_id`,
    ADD COLUMN `physical_name` varchar(60) NULL COMMENT '实物库名称' AFTER `house_name`,
    ADD COLUMN `geo_location` varchar(60) NULL COMMENT '仓库地理位置' AFTER `physical_name`,
    MODIFY COLUMN `dept_id` bigint(20) NULL DEFAULT NULL COMMENT '所属上级ID' AFTER `status`,
    MODIFY COLUMN `company_id` bigint(20) NULL DEFAULT NULL COMMENT '数据所属组织' AFTER `remark`,
    MODIFY COLUMN `phone` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系电话' AFTER `concat`;