generate sha-1 hash for chart on score import

1 files changed, 18 insertions, 6 deletions

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[]
 }