AiDOPWarehouse/server/sql/aidopdev_alter_tables_utf8mb4_unicode_ci.sql

-- aidopdev：将下列表整表转换为 utf8mb4 / utf8mb4_unicode_ci（消除与 utf8mb4_general_ci 混用时的 collation 冲突）
-- 执行前请备份；大表可能耗时较长。

SET FOREIGN_KEY_CHECKS = 0;
USE `aidopdev`;

ALTER TABLE `NbrDetail` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `NbrMaster` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `OpTransEmployee` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `PurOrdDetail` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `YearDemandManagement` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `qms_qcp_insappnentry` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `srm_po_occupy` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

SET FOREIGN_KEY_CHECKS = 1;