2 files changed, 35 insertions, 0 deletions
diff --git a/prisma/migrations/20230809105139_init/migration.sql b/prisma/migrations/20230809105139_init/migration.sql
new file mode 100644
index 0000000..67268c9
--- /dev/null
+++ b/prisma/migrations/20230809105139_init/migration.sql
@@ -0,0 +1,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;
diff --git a/prisma/migrations/migration_lock.toml b/prisma/migrations/migration_lock.toml
new file mode 100644
index 0000000..fbffa92
--- /dev/null
+++ b/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 (i.e. Git)
+provider = "postgresql"
+\ No newline at end of file