From 152894146b72830e48e800721ea6160228a9bdc1 Mon Sep 17 00:00:00 2001
From: Pinapelz <yukais@pinapelz.com>
Date: Mon, 7 Jul 2025 00:00:22 -0700
Subject: generate sha-1 hash for chart on score import

---
 backend/schema.prisma | 24 ++++++++++++++++++------
 1 file changed, 18 insertions(+), 6 deletions(-)

(limited to 'backend/schema.prisma')

diff --git a/backend/schema.prisma b/backend/schema.prisma
index 467d59d..a613628 100644
--- a/backend/schema.prisma
+++ b/backend/schema.prisma
@@ -30,14 +30,26 @@ model Game {
   formattedName  String  @unique
   description    String
   scores Score[]
+  charts Charts[]
 }
 
 model Score {
-  id     Int  @id @default(autoincrement())
+  id               Int     @id @default(autoincrement())
   gameInternalName String
-  userId Int
-  timestamp BigInt //in UNIX milliseconds
-  data   Json
-  game   Game @relation(fields: [gameInternalName], references: [internalName])
-  user   User @relation(fields: [userId], references: [id])
+  chartId          String
+  userId           Int
+  timestamp        BigInt // in UNIX milliseconds
+  data             Json
+  game   Game   @relation(fields: [gameInternalName], references: [internalName])
+  user   User   @relation(fields: [userId], references: [id])
+  chart  Charts @relation(fields: [chartId], references: [chartId])
+}
+
+model Charts {
+  chartId          String  @id // platform-wide unique hash
+  gameInternalName String
+  title        String
+  artist           String
+  game   Game   @relation(fields: [gameInternalName], references: [internalName])
+  scores Score[]
 }
-- 
cgit v1.2.3