From 51d378e4cb4584196b14132b4d330b8d370f8fb3 Mon Sep 17 00:00:00 2001
From: Peerawas Archavanuntakun <peerawas.a@gmail.com>
Date: Thu, 6 Jan 2022 03:30:32 +0700
Subject: Setup and migrate to Prisma (#456)

---
 schema.prisma | 49 +++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 49 insertions(+)
 create mode 100644 schema.prisma

(limited to 'schema.prisma')

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])
+}
-- 
cgit v1.2.3