Create idempotent SQL statements for the Drizzle MySQL idempotency table.
Run these during migrations or local setup before using
createDrizzleMysqlIdempotencyPort(...).
Indexes are declared inline because MySQL has no
CREATE INDEX IF NOT EXISTS; the whole shape stays idempotent under
CREATE TABLE IF NOT EXISTS. The binary no-pad collation
utf8mb4_0900_bin (MySQL 8.0+) keeps fingerprint comparisons
case-sensitive — "ABC" and "abc" must classify as conflict, never replay.
Create idempotent SQL statements for the Drizzle MySQL idempotency table.
Run these during migrations or local setup before using
createDrizzleMysqlIdempotencyPort(...).Indexes are declared inline because MySQL has no
CREATE INDEX IF NOT EXISTS; the whole shape stays idempotent underCREATE TABLE IF NOT EXISTS. The binary no-pad collationutf8mb4_0900_bin(MySQL 8.0+) keeps fingerprint comparisons case-sensitive — "ABC" and "abc" must classify as conflict, never replay.