diff options
Diffstat (limited to 'packages/gateway/prisma/migrations')
| -rw-r--r-- | packages/gateway/prisma/migrations/20251024062804_init/migration.sql | 17 | ||||
| -rw-r--r-- | packages/gateway/prisma/migrations/migration_lock.toml | 3 |
2 files changed, 20 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" |