database_fix.sql

-- 修复数据库表结构，确保 user_name / printer_name 列使用 utf8mb4 字符集

-- 1. 检查并修改数据库字符集
ALTER DATABASE 3d_printing CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 2. 检查并修改用户表结构
ALTER TABLE users MODIFY COLUMN user_name VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 3. 检查并修改设备表结构
ALTER TABLE devices MODIFY COLUMN printer_name VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 4. 检查并修改其他可能包含用户名或设备名的表
-- 例如订单表
ALTER TABLE orders MODIFY COLUMN user_name VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE orders MODIFY COLUMN printer_name VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 5. 检查并修改表的默认字符集
ALTER TABLE users DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE devices DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE orders DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 6. 验证修改结果
SHOW CREATE TABLE users;
SHOW CREATE TABLE devices;
SHOW CREATE TABLE orders;