sql/mysql/aftersales_ticket_text_fields.sql
@@ -1,6 +1,8 @@ -- ============================================= -- 售后工单：客户/联系人/物料/批次 改为文本存储 + 兜底补齐工单按钮权限（可重复执行） -- ============================================= -- 强制连接字符集，避免中文被双重编码（乱码） SET NAMES utf8mb4; SET @c1 := (SELECT COUNT(*) FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'after_sale_ticket' AND COLUMN_NAME = 'customer_name'); SET @ddl1 := IF(@c1 = 0,
