Files
kefu/im/.deploy/backend-20260830/migrations/012_expand_client_message_id.sql
2026-09-03 08:38:17 +08:00

7 lines
277 B
SQL

SET NAMES utf8mb4;
-- Accept both the canonical 26-character client ID and UUID-style IDs from
-- older/cached clients while preserving sender-level idempotency.
ALTER TABLE im_messages
MODIFY COLUMN client_msg_id VARCHAR(64) CHARACTER SET ascii COLLATE ascii_bin NOT NULL;