fix: Fix the uniquness constraint on tag name

1 files changed, 11 insertions, 0 deletions

diff --git a/packages/db/prisma/migrations/20240214011350_fix_tag_name_index/migration.sql b/packages/db/prisma/migrations/20240214011350_fix_tag_name_index/migration.sql
new file mode 100644
index 00000000..cbcd8821
--- /dev/null
+++ b/packages/db/prisma/migrations/20240214011350_fix_tag_name_index/migration.sql
@@ -0,0 +1,11 @@
+/*
+  Warnings:
+
+  - A unique constraint covering the columns `[userId,name]` on the table `BookmarkTags` will be added. If there are existing duplicate values, this will fail.
+
+*/
+-- DropIndex
+DROP INDEX "BookmarkTags_name_key";
+
+-- CreateIndex
+CREATE UNIQUE INDEX "BookmarkTags_userId_name_key" ON "BookmarkTags"("userId", "name");