schema.prisma

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

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

model FileCache {
  hash       String   @id
  bytes      Int
  accessedAt DateTime
  createdAt  DateTime @default(now())
  updatedAt  DateTime @updatedAt
}

model KeyValueCache {
  key       String   @id
  value     String
  expiresAt DateTime
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
}

model Setting {
  guildId                             String   @id
  playlistLimit                       Int      @default(50)
  secondsToWaitAfterQueueEmpties      Int      @default(30)
  leaveIfNoListeners                  Boolean  @default(true)
  queueAddResponseEphemeral           Boolean  @default(false)
  autoAnnounceNextSong                Boolean  @default(false)
  defaultVolume                       Int      @default(100)
  defaultQueuePageSize                Int      @default(10)
  turnDownVolumeWhenPeopleSpeak       Boolean  @default(false)
  turnDownVolumeWhenPeopleSpeakTarget Int      @default(20)
  createdAt                           DateTime @default(now())
  updatedAt                           DateTime @updatedAt
}

model FavoriteQuery {
  id        Int      @id @default(autoincrement())
  guildId   String
  authorId  String
  name      String
  query     String
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt

  @@unique([guildId, name])
}

model ListeningSession {
  id              String                    @id
  guildId         String
  voiceChannelId  String
  channelId       String?
  messageId       String?
  startedAt       DateTime
  endedAt         DateTime?
  endReason       String?
  recoveryPending Boolean                   @default(false)
  entries         ListeningSessionEntry[]
  historyMessages ListeningSessionMessage[]

  @@index([guildId, startedAt])
  @@index([endedAt])
  @@index([recoveryPending])
}

model ListeningSessionEntry {
  id          String           @id
  sessionId   String
  position    Int
  title       String
  artist      String
  url         String
  source      String
  length      Float
  offset      Float
  requestedBy String
  startedAt   DateTime
  endedAt     DateTime?
  status      String
  session     ListeningSession @relation(fields: [sessionId], references: [id], onDelete: Cascade)

  @@unique([sessionId, position])
}

model ListeningSessionMessage {
  sessionId      String
  position       Int
  messageId      String?
  afterMessageId String?
  nonce          String?
  session        ListeningSession @relation(fields: [sessionId], references: [id], onDelete: Cascade)

  @@id([sessionId, position])
}