diff options
| author | Fuwn <[email protected]> | 2025-10-23 23:59:54 -0700 |
|---|---|---|
| committer | Fuwn <[email protected]> | 2025-10-24 00:00:49 -0700 |
| commit | 454d848c43aa8223118ea5982adfbb36681dd765 (patch) | |
| tree | a969c5317b05f9f804c2ed198b042ec98a9c9cb1 /packages/gateway/prisma/schema.prisma | |
| parent | feat(gateway:listeners): Add role persistence (diff) | |
| download | umabotdiscord-454d848c43aa8223118ea5982adfbb36681dd765.tar.xz umabotdiscord-454d848c43aa8223118ea5982adfbb36681dd765.zip | |
feat(gateway:listeners): Add emoji and sticker usage tracking
Diffstat (limited to 'packages/gateway/prisma/schema.prisma')
| -rw-r--r-- | packages/gateway/prisma/schema.prisma | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/packages/gateway/prisma/schema.prisma b/packages/gateway/prisma/schema.prisma index 922ca6f..3f69cf0 100644 --- a/packages/gateway/prisma/schema.prisma +++ b/packages/gateway/prisma/schema.prisma @@ -18,3 +18,29 @@ model UserRole { @@unique([userId, guildId, roleId]) @@index([userId, guildId]) } + +model EmojiUsage { + id String @id @default(cuid()) + guildId String + emojiId String + emojiName String + usageCount Int @default(1) + firstUsed DateTime @default(now()) + lastUsed DateTime @default(now()) + + @@unique([guildId, emojiId]) + @@index([guildId, usageCount]) +} + +model StickerUsage { + id String @id @default(cuid()) + guildId String + stickerId String + stickerName String + usageCount Int @default(1) + firstUsed DateTime @default(now()) + lastUsed DateTime @default(now()) + + @@unique([guildId, stickerId]) + @@index([guildId, usageCount]) +} |