feat(gateway:listeners): Add role persistence

1 files changed, 20 insertions, 0 deletions

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