1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
|
-- CreateTable
CREATE TABLE "UserProfile" (
"id" TEXT NOT NULL,
"name" TEXT NOT NULL,
"setting" JSONB,
CONSTRAINT "UserProfile_pkey" PRIMARY KEY ("id")
);
-- CreateTable
CREATE TABLE "WatchListEpisode" (
"id" TEXT NOT NULL,
"aniId" TEXT,
"title" TEXT,
"aniTitle" TEXT,
"image" TEXT,
"episode" INTEGER,
"timeWatched" INTEGER,
"duration" INTEGER,
"provider" TEXT,
"createdDate" TIMESTAMP(3) DEFAULT CURRENT_TIMESTAMP,
"userProfileId" TEXT NOT NULL,
"watchId" TEXT NOT NULL,
CONSTRAINT "WatchListEpisode_pkey" PRIMARY KEY ("id")
);
-- CreateIndex
CREATE UNIQUE INDEX "UserProfile_name_key" ON "UserProfile"("name");
-- AddForeignKey
ALTER TABLE "WatchListEpisode" ADD CONSTRAINT "WatchListEpisode_userProfileId_fkey" FOREIGN KEY ("userProfileId") REFERENCES "UserProfile"("name") ON DELETE RESTRICT ON UPDATE CASCADE;
|