-- Repair CRM invoice columns missing from the local integration database. -- Safe to rerun; existing invoices retain NULL links. SET @db_name = DATABASE(); SET @ddl = (SELECT IF(COUNT(*) = 0, 'ALTER TABLE crm_invoice ADD COLUMN sale_order_id BIGINT NULL COMMENT ''关联销售订单'' AFTER contract_id', 'SELECT 1') FROM information_schema.columns WHERE table_schema = @db_name AND table_name = 'crm_invoice' AND column_name = 'sale_order_id'); PREPARE invoice_stmt FROM @ddl; EXECUTE invoice_stmt; DEALLOCATE PREPARE invoice_stmt; SET @ddl = (SELECT IF(COUNT(*) = 0, 'ALTER TABLE crm_invoice ADD COLUMN contract_amount DECIMAL(18,2) NULL AFTER price', 'SELECT 1') FROM information_schema.columns WHERE table_schema = @db_name AND table_name = 'crm_invoice' AND column_name = 'contract_amount'); PREPARE invoice_stmt FROM @ddl; EXECUTE invoice_stmt; DEALLOCATE PREPARE invoice_stmt; SET @ddl = (SELECT IF(COUNT(*) = 0, 'ALTER TABLE crm_invoice ADD COLUMN prepayment_amount DECIMAL(18,2) NULL AFTER contract_amount', 'SELECT 1') FROM information_schema.columns WHERE table_schema = @db_name AND table_name = 'crm_invoice' AND column_name = 'prepayment_amount'); PREPARE invoice_stmt FROM @ddl; EXECUTE invoice_stmt; DEALLOCATE PREPARE invoice_stmt; SET @ddl = (SELECT IF(COUNT(*) = 0, 'ALTER TABLE crm_invoice ADD COLUMN delivery_amount DECIMAL(18,2) NULL AFTER prepayment_amount', 'SELECT 1') FROM information_schema.columns WHERE table_schema = @db_name AND table_name = 'crm_invoice' AND column_name = 'delivery_amount'); PREPARE invoice_stmt FROM @ddl; EXECUTE invoice_stmt; DEALLOCATE PREPARE invoice_stmt; SET @ddl = (SELECT IF(COUNT(*) = 0, 'ALTER TABLE crm_invoice ADD COLUMN acceptance_amount DECIMAL(18,2) NULL AFTER delivery_amount', 'SELECT 1') FROM information_schema.columns WHERE table_schema = @db_name AND table_name = 'crm_invoice' AND column_name = 'acceptance_amount'); PREPARE invoice_stmt FROM @ddl; EXECUTE invoice_stmt; DEALLOCATE PREPARE invoice_stmt; SET @ddl = (SELECT IF(COUNT(*) = 0, 'ALTER TABLE crm_invoice ADD COLUMN sale_out_id BIGINT NULL COMMENT ''关联销售出库单'' AFTER sale_order_id', 'SELECT 1') FROM information_schema.columns WHERE table_schema = @db_name AND table_name = 'crm_invoice' AND column_name = 'sale_out_id'); PREPARE invoice_stmt FROM @ddl; EXECUTE invoice_stmt; DEALLOCATE PREPARE invoice_stmt;