feat(gateway:listeners): Add role persistence

3 files changed, 40 insertions, 0 deletions

diff --git a/packages/gateway/prisma/migrations/20251024062804_init/migration.sql b/packages/gateway/prisma/migrations/20251024062804_init/migration.sql
new file mode 100644
index 0000000..ffb366a
--- /dev/null
+++ b/packages/gateway/prisma/migrations/20251024062804_init/migration.sql
@@ -0,0 +1,17 @@
+-- CreateTable
+CREATE TABLE "UserRole" (
+    "id" TEXT NOT NULL,
+    "userId" TEXT NOT NULL,
+    "guildId" TEXT NOT NULL,
+    "roleId" TEXT NOT NULL,
+    "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    "updatedAt" TIMESTAMP(3) NOT NULL,
+
+    CONSTRAINT "UserRole_pkey" PRIMARY KEY ("id")
+);
+
+-- CreateIndex
+CREATE INDEX "UserRole_userId_guildId_idx" ON "UserRole"("userId", "guildId");
+
+-- CreateIndex
+CREATE UNIQUE INDEX "UserRole_userId_guildId_roleId_key" ON "UserRole"("userId", "guildId", "roleId");
diff --git a/packages/gateway/prisma/migrations/migration_lock.toml b/packages/gateway/prisma/migrations/migration_lock.toml
new file mode 100644
index 0000000..044d57c
--- /dev/null
+++ b/packages/gateway/prisma/migrations/migration_lock.toml
@@ -0,0 +1,3 @@
+# Please do not edit this file manually
+# It should be added in your version-control system (e.g., Git)
+provider = "postgresql"
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])
+}