-- MES 退货单关联售后申请。长辉线上和本地已存在此列; -- 其他项目迁移时安全补列,不回填历史数据。 SET @as_return_link_sql := IF( (SELECT COUNT(*) FROM information_schema.columns WHERE table_schema=DATABASE() AND table_name='mes_wm_return_sales' AND column_name='after_sale_return_id')=0, 'ALTER TABLE mes_wm_return_sales ADD COLUMN after_sale_return_id BIGINT NULL COMMENT ''来源售后退货申请''', 'SELECT 1'); PREPARE as_return_link_stmt FROM @as_return_link_sql; EXECUTE as_return_link_stmt; DEALLOCATE PREPARE as_return_link_stmt;