From 46c40a53a569f5f27de016bc0215bf30dcdba1a5 Mon Sep 17 00:00:00 2001
From: Fuwn <contact@fuwn.me>
Date: Thu, 23 Oct 2025 23:36:36 -0700
Subject: feat(gateway:listeners): Add role persistence

---
 .../prisma/migrations/20251024062804_init/migration.sql | 17 +++++++++++++++++
 packages/gateway/prisma/migrations/migration_lock.toml  |  3 +++
 2 files changed, 20 insertions(+)
 create mode 100644 packages/gateway/prisma/migrations/20251024062804_init/migration.sql
 create mode 100644 packages/gateway/prisma/migrations/migration_lock.toml

(limited to 'packages/gateway/prisma/migrations')

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"
-- 
cgit v1.2.3