Create idempotent SQL statements for the Drizzle MySQL outbox table.
Run these during migrations or local setup before using
createDrizzleMysqlOutboxPort(...).
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 string comparisons case-sensitive
and free of PAD SPACE semantics, which claim tokens and fingerprints
require.
Create idempotent SQL statements for the Drizzle MySQL outbox table.
Run these during migrations or local setup before using
createDrizzleMysqlOutboxPort(...).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 string comparisons case-sensitive and free of PAD SPACE semantics, which claim tokens and fingerprints require.