schema.prisma


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49

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
  prefix        String
  channel       String?
  finishedSetup Boolean  @default(false)
  playlistLimit Int      @default(50)
  createdAt     DateTime @default(now())
  updatedAt     DateTime @updatedAt
}

model Shortcut {
  id        Int      @id @default(autoincrement())
  guildId   String
  authorId  String
  shortcut  String
  command   String
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt


  @@index([shortcut], map: "shortcuts_shortcut")
  @@index([guildId], map: "shortcuts_guild_id")
  @@index([guildId, shortcut])
}