ALTER TABLE `meas`.`meas_spectral_radiation` MODIFY COLUMN `gain` double(5, 1) NOT NULL COMMENT '增益' AFTER `lens_f_view`; ALTER TABLE `meas`.`meas_thermal_imager_test_data` ADD COLUMN `focal_length` double(11, 2) NULL COMMENT '焦距' AFTER `rad_temp`, ADD COLUMN `raw_data` varchar(255) NULL COMMENT '原始数据' AFTER `focal_length`, ADD COLUMN `processed_data` varchar(255) NULL COMMENT '处理后数据' AFTER `raw_data`;