19 lines
677 B
SQL
19 lines
677 B
SQL
-- +goose Up
|
|
|
|
-- 000021/000049 创建表时未显式指定排序规则，在 MySQL 8 中会继承
|
|
-- utf8mb4_0900_ai_ci。财务出款查询会与 utf8mb4_unicode_ci 的订单、
|
|
-- 提现和手工出款表做 UNION，混用排序规则会触发 Error 1271。
|
|
ALTER TABLE admin_pickups
|
|
CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
|
|
|
|
ALTER TABLE admin_pickup_financial_adjustments
|
|
CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
|
|
|
|
-- +goose Down
|
|
|
|
ALTER TABLE admin_pickup_financial_adjustments
|
|
CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
|
|
|
|
ALTER TABLE admin_pickups
|
|
CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
|