use kgraph;

ALTER TABLE `kgraph`.`t_air_system_info`
ADD COLUMN `name` varchar(64) NULL COMMENT '系统名称' AFTER `id`;
ALTER TABLE `kgraph`.`t_air_subsystem_info`
ADD COLUMN `name` varchar(64) NULL COMMENT '分系统名称' AFTER `id`;
ALTER TABLE `kgraph`.`t_air_part_info`
ADD COLUMN `name` varchar(64) NULL COMMENT '部件名称' AFTER `id`;
ALTER TABLE `kgraph`.`t_air_system_status_info`
ADD COLUMN `name` varchar(64) NULL COMMENT '系统名称' AFTER `id`;
ALTER TABLE `kgraph`.`t_air_subsystem_status_info`
ADD COLUMN `name` varchar(64) NULL COMMENT '分系统名称' AFTER `id`;
ALTER TABLE `kgraph`.`t_air_part_status_info`
ADD COLUMN `name` varchar(64) NULL COMMENT '部件名称' AFTER `id`;

ALTER TABLE `kgraph`.`t_air_system_status_info`
MODIFY COLUMN `serial` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '系统编号' AFTER `air_number`,
MODIFY COLUMN `version` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '版本升级' AFTER `production_date`,
MODIFY COLUMN `version_update_date` datetime NULL DEFAULT NULL COMMENT '升级时间' AFTER `version`,
ADD COLUMN `return_factory_time` datetime NULL COMMENT '返厂时间' AFTER `repair_date`,
ADD COLUMN `repair_item` varchar(255) NULL COMMENT '维修事项' AFTER `return_factory_time`,
ADD COLUMN `bunch_unit` varchar(255) NULL COMMENT '串件安装飞机号' AFTER `repair_item`;

commit;