From 8970b3a5375ccfd9b41c8a08722a2fc6bbbe3af9 Mon Sep 17 00:00:00 2001 From: MohamedBassem Date: Wed, 7 Feb 2024 21:05:57 +0000 Subject: [feature] Add openAI integration for extracting tags from articles --- .../migration.sql | 21 +++++++++++++++++++++ db/prisma/schema.prisma | 1 - 2 files changed, 21 insertions(+), 1 deletion(-) create mode 100644 db/prisma/migrations/20240207204211_drop_extra_field_in_tags_links/migration.sql (limited to 'db/prisma') diff --git a/db/prisma/migrations/20240207204211_drop_extra_field_in_tags_links/migration.sql b/db/prisma/migrations/20240207204211_drop_extra_field_in_tags_links/migration.sql new file mode 100644 index 00000000..78184041 --- /dev/null +++ b/db/prisma/migrations/20240207204211_drop_extra_field_in_tags_links/migration.sql @@ -0,0 +1,21 @@ +/* + Warnings: + + - You are about to drop the column `bookmarkTagsId` on the `TagsOnLinks` table. All the data in the column will be lost. + +*/ +-- RedefineTables +PRAGMA foreign_keys=OFF; +CREATE TABLE "new_TagsOnLinks" ( + "linkId" TEXT NOT NULL, + "tagId" TEXT NOT NULL, + "attachedAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, + CONSTRAINT "TagsOnLinks_linkId_fkey" FOREIGN KEY ("linkId") REFERENCES "BookmarkedLink" ("id") ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT "TagsOnLinks_tagId_fkey" FOREIGN KEY ("tagId") REFERENCES "BookmarkTags" ("id") ON DELETE CASCADE ON UPDATE CASCADE +); +INSERT INTO "new_TagsOnLinks" ("attachedAt", "linkId", "tagId") SELECT "attachedAt", "linkId", "tagId" FROM "TagsOnLinks"; +DROP TABLE "TagsOnLinks"; +ALTER TABLE "new_TagsOnLinks" RENAME TO "TagsOnLinks"; +CREATE UNIQUE INDEX "TagsOnLinks_linkId_tagId_key" ON "TagsOnLinks"("linkId", "tagId"); +PRAGMA foreign_key_check; +PRAGMA foreign_keys=ON; diff --git a/db/prisma/schema.prisma b/db/prisma/schema.prisma index f5b83b66..0e6d080c 100644 --- a/db/prisma/schema.prisma +++ b/db/prisma/schema.prisma @@ -100,7 +100,6 @@ model TagsOnLinks { tagId String attachedAt DateTime @default(now()) - bookmarkTagsId String @@unique([linkId, tagId]) } -- cgit v1.2.3-70-g09d2