clawshow-api/migrate-add-emoji-trigger-fields.sql

ALTER TABLE "emojis" ADD COLUMN "trigger_type" TEXT NOT NULL DEFAULT 'message';
ALTER TABLE "emojis" ADD COLUMN "trigger_result" TEXT;
CREATE UNIQUE INDEX IF NOT EXISTS "emojis_avatar_default_unique_idx" ON "emojis" ("avatar_id") WHERE "trigger_type" = 'default';