Setup and migrate to Prisma (#456)

1 files changed, 49 insertions, 0 deletions

diff --git a/schema.prisma b/schema.prisma
new file mode 100644
index 0000000..95ce596
--- /dev/null
+++ b/schema.prisma
@@ -0,0 +1,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])
+}