generator client {
  provider = "prisma-client-js"
}

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

model UserRole {
  id        String   @id @default(cuid())
  userId    String
  guildId   String
  roleId    String
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt

  @@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])
}