feat(gateway:listeners): Add emoji and sticker usage tracking

1 files changed, 37 insertions, 0 deletions

diff --git a/packages/gateway/prisma/migrations/20251024070034_add_emoji_sticker_tracking/migration.sql b/packages/gateway/prisma/migrations/20251024070034_add_emoji_sticker_tracking/migration.sql
new file mode 100644
index 0000000..bc59a37
--- /dev/null
+++ b/packages/gateway/prisma/migrations/20251024070034_add_emoji_sticker_tracking/migration.sql
@@ -0,0 +1,37 @@
+-- CreateTable
+CREATE TABLE "EmojiUsage" (
+    "id" TEXT NOT NULL,
+    "guildId" TEXT NOT NULL,
+    "emojiId" TEXT NOT NULL,
+    "emojiName" TEXT NOT NULL,
+    "usageCount" INTEGER NOT NULL DEFAULT 1,
+    "firstUsed" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    "lastUsed" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
+
+    CONSTRAINT "EmojiUsage_pkey" PRIMARY KEY ("id")
+);
+
+-- CreateTable
+CREATE TABLE "StickerUsage" (
+    "id" TEXT NOT NULL,
+    "guildId" TEXT NOT NULL,
+    "stickerId" TEXT NOT NULL,
+    "stickerName" TEXT NOT NULL,
+    "usageCount" INTEGER NOT NULL DEFAULT 1,
+    "firstUsed" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    "lastUsed" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
+
+    CONSTRAINT "StickerUsage_pkey" PRIMARY KEY ("id")
+);
+
+-- CreateIndex
+CREATE INDEX "EmojiUsage_guildId_usageCount_idx" ON "EmojiUsage"("guildId", "usageCount");
+
+-- CreateIndex
+CREATE UNIQUE INDEX "EmojiUsage_guildId_emojiId_key" ON "EmojiUsage"("guildId", "emojiId");
+
+-- CreateIndex
+CREATE INDEX "StickerUsage_guildId_usageCount_idx" ON "StickerUsage"("guildId", "usageCount");
+
+-- CreateIndex
+CREATE UNIQUE INDEX "StickerUsage_guildId_stickerId_key" ON "StickerUsage"("guildId", "stickerId");