buzz/migrations/0028_long_reaction_payloads.sql

-- A valid 64-character custom emoji shortcode is wrapped as `:shortcode:` in
-- NIP-25 reaction content. Preserve the wrapper in the reaction projection.
ALTER TABLE reactions ALTER COLUMN emoji TYPE VARCHAR(66);